下面是代码,用JSP连接MySQL数据库,但是为什么出来的结果网页中只显示数据库的标题栏,但是没有显示数据库里的具体数据,代码里面哪里出错了或者还是因为我少写了什么?希望前辈们给以解答~~谢谢大家了~~代码如下:
<%@ 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>
<title>数据库连接</title>
</head>
<body>
<table border="2" align="center">
<tr>
<td>num</td>
<td>name</td>
<td>sex</td>
<td>college</td>
</tr>
<%
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);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from information");
while(rs.next())
{
String num = rs.getString(1);
String name = rs.getString(2);
String sex = rs.getString(3);
String college = rs.getString(4);
}
out.print("恭喜你,数据库连接成功!");%><%stmt.close();
conn.close();
%>
</table>
</body>
</html>
<%@ 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>
<title>数据库连接</title>
</head>
<body>
<table border="2" align="center">
<tr>
<td>num</td>
<td>name</td>
<td>sex</td>
<td>college</td>
</tr>
<%
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);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from information");
while(rs.next())
{
String num = rs.getString(1);
String name = rs.getString(2);
String sex = rs.getString(3);
String college = rs.getString(4);
}
out.print("恭喜你,数据库连接成功!");%><%stmt.close();
conn.close();
%>
</table>
</body>
</html>
while(rs.next()){
out.print("<tr><td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getString(4)+"</td></tr>");
}
<%@ 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>
<title>数据库连接 </title>
</head>
<body>
<table border="2" align="center">
<tr>
<td>num </td>
<td>name </td>
<td>sex </td>
<td>college </td>
</tr>
<%
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);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=stmt.executeQuery("select * from information");
while(rs.next())
{
out.print("<tr><td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td>");
out.print("<td>"+rs.getString(4)+"</td></tr>");
}
out.print("恭喜你,数据库连接成功!");%> <%stmt.close();
conn.close();
%>
</table>
</body>
</html>