jsphelloworld.jsp

JSP访问数据库及分页的功能

<%@page import="java.net.URL"%>
<%@page import="java.sql.*"%>
<%@page language="java"%>



<%@page contentType="text/html; charset=GBK"%><style type="text/css">
<!--
body {
	background-color: #264989;
	margin-left: 20px;
	margin-top: 20px;
	margin-right: 20px;
	margin-bottom: 20px;
}
body,td,th {
	font-size: 12px;
}
.style1 {color: #FFFFFF}
-->
</style>


<%


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

String url="jdbc:odbc:oa";

int intPageSize; //一页显示的记录数 
int intRowCount; //记录总数 
int intPageCount; //总页数 
int intPage; //待显示页码 
java.lang.String strPage; 

int i; 

//设置一页显示的记录数 
intPageSize = 15; 

//取得待显示页码 
strPage = request.getParameter("page"); 
if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
intPage = 1; 
} 
else{//将字符串转换成整型 
intPage = java.lang.Integer.parseInt(strPage); 
if(intPage<1) intPage = 1; 
} 




Connection con= DriverManager.getConnection(url,"sa","12127922"); 
//创建statement对象
Statement stmt = con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
String sql="select id,user_name,user_id,sex from users order by id";
ResultSet rs=stmt.executeQuery(sql);


rs.last(); 
intRowCount = rs.getRow(); 
rs.first();

//记算总页数 
intPageCount = (intRowCount+intPageSize-1) / intPageSize; 

//调整待显示的页码 
if(intPage>intPageCount) 
{intPage = intPageCount;} 





%>
<table width="300"  border="0" cellspacing="0" bgcolor="#000033">
  <tr bgcolor="#663300">
    <td width="11%" height="25"><span class="style1 style1">ID</span></td>
    <td width="27%" height="25"><span class="style1">用户名</span></td>
    <td width="20%" height="25"><span class="style1">用户ID</span></td>
    <td width="42%" height="25"><span class="style1">性别</span></td>
  </tr>
<% 
if(intPageCount>0){ 
//将记录指针定位到待显示页的第一条记录上 
rs.absolute((intPage-1) * intPageSize + 1); 

//显示数据 
i = 0; 
while(i<intPageSize&&!rs.isAfterLast()){ 
%> 

  <tr bgcolor="#FFFFFF">
    <td><%=rs.getString(1)%></td>
    <td><%=rs.getString(2)%></td>
    <td><%=rs.getString(3)%></td>
    <td><%=rs.getString(4)%></td>
  </tr>
<%
i++;
rs.next();
}
}
rs.close();
stmt.close();
%>
  <tr bgcolor="#FFFFFF">
    <td colspan="4">第<%=intPage%>页  共<%=intPageCount%>页  <%if(intPage<intPageCount){%><a href="JspHelloWorld.jsp?page=<%=intPage+1%>">下一页</a><%}%>  <%if(intPage>1){%><a href="JspHelloWorld.jsp?page=<%=intPage-1%>">上一页</a><%}%> </td>
  </tr>
</table>