北风网报价系统第49集资料.docVIP

1.查询用户 分为两类： 一类是查询所有用户 一类是按条件查询用户：按用户名来查询，按用户的等级来查询。 2.查询所有用户。 DAO接口。 public ListUser findAll(Page page); public int findAllCount(); DAO实现类。 public ListUser findAll(Page page) { //1.获得连接对象 Connection conn = DataBaseManager.getConnection(); //2.查询SQL语句 String querySql = select * from user limit ?,?; PreparedStatement pstmt = null; ResultSet rs = null; ListUser users = null; //3.通过连接对象获得预处理语句对象 try { pstmt = conn.prepareStatement(querySql); //4.设置参数 pstmt.setInt(1, page.getBeginIndex()); pstmt.setInt(2, page.getEveryPage()); //5.执行查询 rs = pstmt.executeQuery(); users = new ArrayListUser(); while(rs.next()) { User user = new User(); user.setUsername(rs.getString(1)); user.setPassword(rs.getString(2)); user.setGrade(rs.getString(3)); users.add(user); } } catch (SQLException e) { e.printStackTrace(); } finally { DataBaseManager.close(rs); DataBaseManager.close(pstmt); DataBaseManager.close(conn); } return users; } public int findAllCount() { //1.获得连接对象 Connection conn = DataBaseManager.getConnection(); //2.查询SQL语句 String querySql = select count(*) from user; PreparedStatement pstmt = null; ResultSet rs = null; int count = 0; //3.通过连接对象获得预处理语句对象 try { pstmt = conn.prepareStatement(querySql); //4.设置参数 //5.执行查询 rs = pstmt.executeQuery(); if(rs.next()) { count = rs.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } finally { DataBaseManager.close(rs); DataBaseManager.close(pstmt); DataBaseManager.close(conn); } return count; } 获得所有用户的Action。 package com.ibeifeng.action; import java.util.List; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.ibeifeng.dao.UserDAO; import com.ibeifeng.daofactory.UserDAOFactory; import com.ibeifeng.fenye.Page; import com.ibeifeng.fenye.PageUtil; import com.ibeifeng.vo.User; public cl