先用JAVA做一个BEAN,用于封装连接和操纵数据库的方法,JDBC方面不用多说了吧? 在页面上定义相关变量,用于收集<form>的信息,再把这些变量传递给BEAN的对象,调用数据库操作方法写入数据库. 页面显示主要是调用BEAN的查询方法,将结果集遍历并赋给相应变量,把变量写在页面HTML的相关位置就可以了.
先用JAVA做一个BEAN,用于封装连接和操纵数据库的方法,JDBC方面不用多说了吧? 在页面上定义相关变量,用于收集<form>的信息,再把这些变量传递给BEAN的对象,调用数据库操作方法写入数据库. 页面显示主要是调用BEAN的查询方法,将结果集遍历并赋给相应变量,把变量写在页面HTML的相关位置就可以了.
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title></title>
</head>
<body>
<%
java.sql.Connection sqlCon;
java.sql.Statement sqlStmt;
java.sql.ResultSet sqlRst;
java.lang.String strCon;
java.lang.String strSQL;
int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
java.lang.String strPage;
int i,j,k;
intPageSize = 10;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
} else{
intPage = java.lang.Integer.parseInt(strPage);
if(intPage<1) intPage = 1; }
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
strCon = "jdbc:db2:sample";
sqlCon = java.sql.DriverManager.getConnection(strCon,"","");
sqlStmt = sqlCon.createStatement();
strSQL = "select count(*) from org";
sqlRst = sqlStmt.executeQuery(strSQL);
sqlRst.next();
intRowCount = sqlRst.getInt(1);
sqlRst.close();
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
strSQL = "select * from org";
sqlRst = sqlStmt.executeQuery(strSQL);
i = (intPage-1) * intPageSize;
for(j=0;j<i;j++) sqlRst.next(); %>
<table border="1">
<tr>
<td colspan=5 align=center>
<%=intPage%>/<%=intPageCount%>
<%if(intPage != 1){%>
<a href="pagedb2.jsp?page=1">first</a>
<%}else{%>
first
<%}%>
<%if(intPage>1){%>
<a href="pagedb2.jsp?page=<%=intPage-1%>"><<</a>
<%
}else{
%>
<<
<%}%>
<%if(intPage<intPageCount){%>
<a href="pagedb2.jsp?page=<%=intPage+1%>">>></a>
<%
}else{
%>
>>
<%}%>
<%if(intPage != intPageCount){%>
<a href="pagedb2.jsp?page=<%=intPageCount%>">last</a>
<%}else{%>
last
<%}%>
all<%=intRowCount%>row
</td>
</tr>
<tr>
<td>deptnumb</td>
<td>deptname</td>
<td>manage</td>
<td>division</td>
<td>location</td>
</tr>
<%
i = 0;
while(i<intPageSize && sqlRst.next()){ %>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
<td><%=sqlRst.getString(3)%></td>
<td><%=sqlRst.getString(4)%></td>
<td><%=sqlRst.getString(4)%></td>
</tr>
<% i++; } %>
</table>
<%
sqlRst.close();
sqlStmt.close();
sqlCon.close();
%>
</body>
</html>