/**
* 查询输出
* @param pageNo
* @param pageSize
* @return pageModel
*/
public PageModel findAllUser(int pageNo,int pageSize){
String sql = "select * from user where user_name <> 'root' order by user_name" +
"limit" + (pageNo - 1) * pageSize + "," + pageSize;
PageModel pageModel =null;
Connection conn =null;
Statement stmt =null;
ResultSet rs = null;
try{
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
List user_List = new ArrayList();
while(rs.next()){
User user = new User();
user.setUser_name(rs.getString("user_name"));
user.setUser_password(rs.getString("user_password"));
user.setUser_tel(rs.getString("user_tel"));
user.setUser_email(rs.getString("user_email"));
user.setUser_createDate(rs.getTimestamp("user_createdate"));
user_List.add(user);
}
//取得所有记录
int totalRecords = getTotalRecords(conn);
pageModel = new PageModel();
pageModel.setPageSize(pageSize);
pageModel.setList(user_List);
pageModel.setTotalRecord(totalRecords);
}catch(SQLException e){
e.printStackTrace();
}finally{
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return pageModel;
}
/**
* 取得所有记录
* @param conn
* @return 所有记录totalRecords
*/
public int getTotalRecords(Connection conn){
String sql = "select count(*) from user where user_name <> 'root' ";
int totalRecords = 0;
Statement stmt = null;
ResultSet rs = null;
try{
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(rs.next()){
totalRecords = rs.getInt(1);
}
}catch(SQLException e){
e.printStackTrace();
}finally{
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return totalRecords;
}
这两个方法写在UserManager里了,那在JSP上怎么用LIST把数据显示在表格上~
* 查询输出
* @param pageNo
* @param pageSize
* @return pageModel
*/
public PageModel findAllUser(int pageNo,int pageSize){
String sql = "select * from user where user_name <> 'root' order by user_name" +
"limit" + (pageNo - 1) * pageSize + "," + pageSize;
PageModel pageModel =null;
Connection conn =null;
Statement stmt =null;
ResultSet rs = null;
try{
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
List user_List = new ArrayList();
while(rs.next()){
User user = new User();
user.setUser_name(rs.getString("user_name"));
user.setUser_password(rs.getString("user_password"));
user.setUser_tel(rs.getString("user_tel"));
user.setUser_email(rs.getString("user_email"));
user.setUser_createDate(rs.getTimestamp("user_createdate"));
user_List.add(user);
}
//取得所有记录
int totalRecords = getTotalRecords(conn);
pageModel = new PageModel();
pageModel.setPageSize(pageSize);
pageModel.setList(user_List);
pageModel.setTotalRecord(totalRecords);
}catch(SQLException e){
e.printStackTrace();
}finally{
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return pageModel;
}
/**
* 取得所有记录
* @param conn
* @return 所有记录totalRecords
*/
public int getTotalRecords(Connection conn){
String sql = "select count(*) from user where user_name <> 'root' ";
int totalRecords = 0;
Statement stmt = null;
ResultSet rs = null;
try{
conn = DB.getConn();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
if(rs.next()){
totalRecords = rs.getInt(1);
}
}catch(SQLException e){
e.printStackTrace();
}finally{
DB.close(rs);
DB.close(stmt);
DB.close(conn);
}
return totalRecords;
}
这两个方法写在UserManager里了,那在JSP上怎么用LIST把数据显示在表格上~
用标签循环出来
<%
UserManager um = new UserManager();
PageModel pm = um.findAllUser(xxx,yyy);
List list = pm.getList();
for(int i = 0;i < list.size();i++)
{
User user = (User)list.get(i);
out.print("<tr>");
out.print("<td>"+user.getxxx()+"</td>");
out.print("<td>"+user.getyyy()+"</td>");
out.print("<td>"+user.getzzz()+"</td>");
out.print("</tr>");
}
%>
</table>
反正无论怎样!你都需要或者一个request对象,把你从数据库中取得的List集合
用request.setAttribute("list",list)前面一个是Key,后面一个是你从数据库中获取的集合,
页面代码,最原始的写法
<%
List list=(List)request.getAttribute("list");
for(A a:list){
%>
<tr><td><%=a.get()%></td></tr>
<%}
%>
大致的就是这样,大写A代表的是你存放在List集合里面的对象的类型,
小写a自定义了
还有什么不懂的就在继续发帖问吧!