import java.sql.*;public class BaseDao { public static Connection getConnection() {
try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); return DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;databaseName=userinfo",
"sa", "123456");
} catch (Exception e) {
e.printStackTrace();
return null;
} }
public static void main(String[] args) {
if(BaseDao.getConnection()!=null){
System.out.println("ok");
}
}}
數據查詢操作類package dao;import entity.PageBean;
import entity.Userinfo;import java.sql.*;
import java.util.ArrayList;
import java.util.List;public class UserDao extends BaseDao { public PageBean queryUsers(int pageid) {
PageBean page = new PageBean();
Connection conn = super.getConnection();
Statement st = null;
ResultSet rs = null; try {
String sql = "select top " + page.getPageSize()
+ " * from userinfo where id not in(select top "
+ page.getPageSize() * (pageid - 1) + " Id from userinfo)"; st = conn.createStatement();
rs = st.executeQuery(sql);
List list = new ArrayList(); while (rs.next()) { Userinfo user = new Userinfo();
user.setId(rs.getInt("id"));
user.setUsername(rs.getString("username"));
user.setUserpwd(rs.getString("userpwd"));
user.setAddress(rs.getString("address"));
list.add(user);
} page.setPageList(list);
page.setPageid(pageid);
page.setTotalCount(this.getCount()); if (page.getTotalCount() % page.getPageSize() == 0) {
page.setTotalPage(page.getTotalCount() / page.getPageSize());
} else {
page
.setTotalPage(page.getTotalCount() / page.getPageSize()
+ 1);
} return page; } catch (Exception e) {
e.printStackTrace();
return null;
}
} public int getCount() {
Connection conn = super.getConnection();
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select count(*) from userinfo"); if (rs.next()) {
return rs.getInt(1);
}
return 0; } catch (Exception e) {
e.printStackTrace();
return 0;
} }}
分頁實體類:package entity;import java.util.List;public class PageBean {
private int pageid;
private int pageSize=5;
private int totalPage;
private int totalCount;
private List pageList;
/**
* @return the pageid
*/
public int getPageid() {
return pageid;
}
/**
* @param pageid the pageid to set
*/
public void setPageid(int pageid) {
this.pageid = pageid;
}
/**
* @return the pageList
*/
public List getPageList() {
return pageList;
}
/**
* @param pageList the pageList to set
*/
public void setPageList(List pageList) {
this.pageList = pageList;
}
/**
* @return the pageSize
*/
public int getPageSize() {
return pageSize;
}
/**
* @param pageSize the pageSize to set
*/
public void setPageSize(int pageSize) {
this.pageSize = pageSize;
}
/**
* @return the totalCount
*/
public int getTotalCount() {
return totalCount;
}
/**
* @param totalCount the totalCount to set
*/
public void setTotalCount(int totalCount) {
this.totalCount = totalCount;
}
/**
* @return the totalPage
*/
public int getTotalPage() {
return totalPage;
}
/**
* @param totalPage the totalPage to set
*/
public void setTotalPage(int totalPage) {
this.totalPage = totalPage;
}}
以上數據查詢的用戶實體類package entity;public class Userinfo {
private int id; private String username; private String userpwd; private String address; /**
* @return the address
*/
public String getAddress() {
return address;
} /**
* @param address
* the address to set
*/
public void setAddress(String address) {
this.address = address;
} /**
* @return the id
*/
public int getId() {
return id;
} /**
* @param id
* the id to set
*/
public void setId(int id) {
this.id = id;
} /**
* @return the username
*/
public String getUsername() {
return username;
} /**
* @param username
* the username to set
*/
public void setUsername(String username) {
this.username = username;
} /**
* @return the userpwd
*/
public String getUserpwd() {
return userpwd;
} /**
* @param userpwd
* the userpwd to set
*/
public void setUserpwd(String userpwd) {
this.userpwd = userpwd;
}}
Servlet:package servlet;import java.io.IOException;
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import biz.UserBiz;import entity.PageBean;public class QueryUserServlet extends HttpServlet { /**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html");
response.setCharacterEncoding("GBK");
PrintWriter out = response.getWriter();
String pageid=request.getParameter("pageid");
PageBean page=null;
UserBiz biz=null;
if(pageid==null){
biz= new UserBiz();
page=biz.queryUser(1);
}else{
biz= new UserBiz();
page=biz.queryUser(Integer.parseInt(pageid));
}
request.setAttribute("pagebean", page);
request.getRequestDispatcher("show.jsp").forward(request, response);
} /**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html");
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
out.print(" This is ");
out.print(this.getClass());
out.println(", using the POST method");
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}} 頁面顯示:<%@ page language="java" import="java.util.*,entity.*"
pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>"> <title>My JSP 'show.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head> <body>
<table border="1" width="60%">
<tr>
<Td>
ID
</Td>
<Td>
用戶名
</Td>
<Td>
密碼
</Td>
<Td>
地址
</Td>
</tr> <%
PageBean pe = (PageBean) request.getAttribute("pagebean");
List list = pe.getPageList();
for (int i = 0; i < list.size(); i++) {
Userinfo user = (Userinfo) list.get(i);
%>
<tr>
<Td>
<%=user.getId()%>
</Td>
<Td>
<%=user.getUsername()%>
</Td>
<Td>
<%=user.getUserpwd()%>
</Td>
<Td>
<%=user.getAddress()%>
</Td>
</tr>
<%
}
%>
</table>
<%if(pe.getPageid()!=1){%>
<a href="queryUserServlet?pageid=1">首頁</a>
<a href="queryUserServlet?pageid=<%=pe.getPageid()-1%>">上壹頁</a>
<%}%>
<%if(pe.getPageid()!=pe.getTotalPage()){%>
<a href="queryUserServlet?pageid=<%=pe.getPageid()+1%>">下壹頁</a>
<a href="queryUserServlet?pageid=<%=pe.getTotalPage()%>">尾頁</a>
<%}%>
<br>
當前頁:<%=pe.getPageid() %><br>
總記錄:<%=pe.getTotalCount() %><br>
總頁數:<%=pe.getTotalPage() %><br>
</body>
</html>