简单的个人博客系统 jsp+sql server

package ctrl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import conn.DBConn; import bean.Users; public class UsersCtrl { /** * * @param user * @return 检查用户登录信息 */ public int checkUser(Users user){ int flag=0; DBConn db=new DBConn(); Connection conn=db.getConn(); PreparedStatement pstat=null; ResultSet rs=null; String sql="select * from users where u_name=? and u_pwd=?"; try { pstat=conn.prepareStatement(sql); pstat.setString(1, user.getUsername()); pstat.setString(2, user.getPwd()); rs=pstat.executeQuery(); if(rs.next()){ flag=Integer.parseInt(rs.getString("u_power")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.close(rs, pstat, conn); } return flag; } /** * 根据用户名查找一个用户的所有信息 * @param username * @return */ public Users researchByusername(String username){ DBConn db=new DBConn(); Connection conn=db.getConn(); PreparedStatement pstat=null; ResultSet rs=null; String sql="select * from users where u_name=? "; Users users=null; try { pstat=conn.prepareStatement(sql); pstat.setString(1, username); rs=pstat.executeQuery(); if(rs.next()){ users=new Users(); users.setUserid(rs.getInt("u_id")); users.setUsername(rs.getString("u_name").trim()); users.setPwd(rs.getString("u_pwd").trim()); users.setSex(rs.getString("u_sex").trim()); users.setPower(rs.getString("u_power").trim()); users.setHeadimage(rs.getString("u_headimage").trim()); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.close(rs, pstat, conn); } return users; } /** * * @param user * @return 添加一条用户信息 */ public int addUser(Users user){ int flag=0; DBConn db=new DBConn(); Connection conn=db.getConn(); PreparedStatement pstat=null; String sql="insert into users values(?,?,?,?,?)"; try { pstat=conn.prepareStatement(sql); pstat.setString(1, user.getUsername()); pstat.setString(2, user.getPwd()); pstat.setString(3, user.getPower()); pstat.setString(4, user.getSex()); pstat.setString(5, user.getHeadimage()); flag=pstat.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.close(null, pstat, conn); } return flag; } /** * 根据用户id修改用户信息 * @param user * @return */ public int updateUser(Users user){ int flag=0; DBConn db=new DBConn(); Connection conn=db.getConn(); PreparedStatement pstat=null; String sql="update users set u_pwd=?,u_sex=?,u_headimage=? where u_id=?"; try { pstat=conn.prepareStatement(sql); pstat.setString(1, user.getPwd()); pstat.setString(2, user.getSex()); pstat.setString(3, user.getHeadimage()); pstat.setInt(4, user.getUserid()); flag=pstat.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.close(null, pstat, conn); } return flag; } /** * * @return 返回所有的留言记录 * */ public List<Users> researchAllUser(){ List<Users> userlist=new ArrayList<Users>(); DBConn db=new DBConn(); Connection conn=db.getConn(); PreparedStatement pstat=null; ResultSet rs=null; String sql="select * from users order by u_id DESC"; try { pstat=conn.prepareStatement(sql); rs=pstat.executeQuery(); while(rs.next()){ Users user=new Users(); user.setUserid(rs.getInt("u_id")); user.setUsername(rs.getString("u_name")); user.setSex(rs.getString("u_sex")); user.setHeadimage(rs.getString("u_headimage")); userlist.add(user); System.out.println(user.getUsername()); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ db.close(rs, pstat, conn); } return userlist; } }