昨天刚做好连接数据库的例子,今天继续做遍历与定位的方法,错误很多,请前辈们帮忙~~代码:
<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage=""%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>everyrecord</title>
</meta>
</head>
<% Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url="jdbc:mysql://localhost/big?user=user&password=1234&useUnicode=true&characterEncoding=8859_1";
Connection conn=DriverManager.getConnection(url);
int rowcount;
int introw;
int row;
java.lang.String.strrow;
strrow=request.getParameter("row");
if(strrow==null){
introw=1;
}else{
introw=java.lang.Integer.parseInt(strrow);
if(introw<1)introw=1;
}
Statement stmt=conn.creatStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select *from information");
re.last();
rowcount=rs.getRow();
if(introw>rowcount)
introw=rowcount;
if(rowcount>0)
{
rs.absolute(introw);
}
%>
<!--显示数据-->
  <tr>
<td><%=rs.getString("num")%></td>
<td><%=rs.getString("name")%></td>
<td><%=rs.getString("sex")%></td>
<td><%=rs.getString("college")%></td>
  </td>
</table>
<hr>
 <div align="center">
<p>information表中共有<font size="4" color="#FF0000"><%=rowcount%></font>条记录,这是第<font size="4" color="#FFoooo"><%=introw%></font>条记录</p>
<p><a herf="e.jsp?row=1">第一条记录</a>&nbsp;&nbsp;
<%if(introw<rowcount){%>
<a herf="e.jsp?row=<%=introw+1%>">下一条记录&nbsp;&nbsp;</a>
<%}%>
<%if(introw>1){%>
<a herf="e.jsp?row=<%=introw-1%>">上一条记录</a>
&nbsp;&nbsp;
<%}%>
<a herf="e.jsp?row=<%=rowcount%>">最后一条记录</a>
<%rs.close();
stmt.close();
conn.close();
%>
</div>
</body>
</html>