我做一个这样的程序代码:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<!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>无标题文档</title>
</head>
<%!
String stu_name,sex,stu_id;
%>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:stu","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("select*from student");
%>
<table border="1" width="300" align="center">
<tr align="center" bgcolor="pink">
<td> 学号</td>
<td> 姓名</td>
<td> 年龄</td>
</tr>
<%
while(rs.next()){
stu_id=rs.getString("stu_id");
stu_name=rs.getString("stu_name");
sex=rs.getString("sex");
%>
<tr align="center" >
<td><%=stu_id%> </td>
<td><%=stu_name%> </td>
<td><%=sex%> </td>
</tr>
<%}%>
</table>
<table border="0" width="300" align="center">
<tr>
<td align="right">上页下页</td>
</tr>
</table>
<%
con.close();
}
catch(SQLException e1){}
%>
</body>
</html>
我的数据库里有15条记录,为什么界面显示只有14条啊,请大家这是什么回事?
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<!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>无标题文档</title>
</head>
<%!
String stu_name,sex,stu_id;
%>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:stu","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("select*from student");
%>
<table border="1" width="300" align="center">
<tr align="center" bgcolor="pink">
<td> 学号</td>
<td> 姓名</td>
<td> 年龄</td>
</tr>
<%
while(rs.next()){
stu_id=rs.getString("stu_id");
stu_name=rs.getString("stu_name");
sex=rs.getString("sex");
%>
<tr align="center" >
<td><%=stu_id%> </td>
<td><%=stu_name%> </td>
<td><%=sex%> </td>
</tr>
<%}%>
</table>
<table border="0" width="300" align="center">
<tr>
<td align="right">上页下页</td>
</tr>
</table>
<%
con.close();
}
catch(SQLException e1){}
%>
</body>
</html>
我的数据库里有15条记录,为什么界面显示只有14条啊,请大家这是什么回事?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货