从数据库中提取数据

qunqun886 2008-07-22 03:04:00

程序如下啊，运行也不报错，就算从不来数据啊，那为高人说说错在那啊，
<%--
Document : watch
Created on : 2008-7-10, 13:14:29
Author : Administrator
--%>

<%@page contentType="text/html" pageEncoding="UTF-8" import="java.sql.*"%>
<%@include file="include.jsp"%>
<!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=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center><h2>明日科技图书市场调研</h2></center>
<table width="576" height="176" align="center" border="1">
<tr>
<td><h3>调查结果：</h3></td>
</tr>
<%
try {
Class.forName(className);
}catch (ClassNotFoundException e) {
e.toString();
}
Connection conn1,conn2,conn3;
conn1 = DriverManager.getConnection(url, user, pwd);
conn2 = DriverManager.getConnection(url, user, pwd);
conn3 = DriverManager.getConnection(url, user, pwd);
Statement stmt1,stmt2,stmt3; //要分开来，就会抛出 java.sql.SQLException: ResultSet is closed 的异常
stmt1=conn1.createStatement();
stmt2=conn2.createStatement();
stmt3=conn3.createStatement();
ResultSet rs1 = stmt1.executeQuery("select * from tb_book where id=1");
if (!rs1.next()) {
%>
<tr>
<td><h4>您经常购买的图书属于哪一类：</h4></td>
</tr>
<tr>
<td>
开发手册得票：<%=rs1.getString("kaifa")%>票<br>
百例得票：<%=rs1.getString("baili")%>票<br>
技巧得票：<%=rs1.getString("jiqiao")%>票<br>
实例得票：<%=rs1.getString("shili")%>票<br>
教程得票：<%=rs1.getString("jiaocheng")%>票<br>
</td>
</tr>
<%
rs1.close();
stmt1.close();
conn1.close();
}
ResultSet rs2 = stmt2.executeQuery("select * from tb_language where id=1");
if (!rs2.next()) {
%>
<tr>
<td><h4>您使用那一种语言：</h4></td>
</tr>
<tr>
<td>
vb：<%=rs2.getString("vb")%>票<br>
vc：<%=rs2.getString("vc")%>票<br>
java：<%=rs2.getString("java")%>票<br>
delphi：<%=rs2.getString("delphi")%>票<br>
asp：<%=rs2.getString("asp")%>票<br>
aspnet：<%=rs2.getString("aspnet")%>票<br>
jsp：<%=rs2.getString("jsp")%>票<br>
other：<%=rs2.getString("other")%>票<br>
</td>
</tr>
<%
rs2.close();
stmt2.close();
conn2.close();
}
ResultSet rs3 = stmt3.executeQuery("select * from tb_borrowbook where id=1");
if (!rs3.next()) {
%>
<tr>
<td><h4>您愿意购买或者是借阅那类图书：</h4></td>
</tr>
<tr>
<td>
remen：<%=rs3.getString("remen")%>票<br>
jiangjie：<%=rs3.getString("jiangjie")%>票<br>
wanquan：<%=rs3.getString("wanquan")%>票<br>
baili：<%=rs3.getString("baili")%>票<br>
jiqiao：<%=rs3.getString("jiqiao")%>票<br>
</td>
</tr>
<%
rs3.close();
stmt3.close();
conn3.close();
}
%>
</table>
</body>
</html>
数据库中都分别有3个表，下付自己写的一个文件，也麻烦给直接啊，说说有那些bug啊，感觉好多冗余啊：
<%--
Document : look
Created on : 2008-7-21, 18:17:33
Author : Administrator
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="include.jsp"%>
<!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=UTF-8">
<title>JSP Page</title>
</head>
<%
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.toString();
}
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from tb_book where id=1");
while(rs.next()){
%>
<body>
<table width="576" height="176" border="1" align="center">
<tr>
<td align="center">调查结果</td>
</tr>
<tr>
<td>您经常购买的图书属于哪一类：</td>
</tr>
<tr>
<td>
kaifa:  <%=rs.getString(2)%><br>
baili:  <%=rs.getString(3)%><br>
jiqiao:  <%=rs.getString(4)%><br>
jiaocheng:  <%=rs.getString(5)%><br>
</td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
<tr>
<td>您使用那一种语言：</td>
</tr>
<tr>
<td>
<%
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.toString();
}
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from tb_language where id=1");
while(rs.next()){
%>
vb:  <%=rs.getString(2)%><br>
vc:  <%=rs.getString(3)%><br>
java:  <%=rs.getString(4)%><br>
delphi:  <%=rs.getString(5)%><br>
asp:  <%=rs.getString(6)%><br>
aspnet:  <%=rs.getString(7)%><br>
jsp:  <%=rs.getString(8)%><br>
qita:  <%=rs.getString(9)%><br>
</td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
<tr>
<td>您愿意购买或者是借阅那类图书:</td>
</tr>
<tr>
<td>
<%
try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.toString();
}
conn = DriverManager.getConnection(url, user, pwd);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from tb_borrowbook where id=1");
while(rs.next()){
%>
remen:  <%=rs.getString(2)%><br>
jiangjie:  <%=rs.getString(3)%><br>
wanquan:  <%=rs.getString(4)%><br>
baili:  <%=rs.getString(5)%><br>
jiqiao:  <%=rs.getString(6)%><br>
</td>
</tr>
<%}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>

...全文

158 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

qunqun886 2008-07-22

打赏
举报

就是写的第一个程序运行的时候并不能从数据库中提取出数据啊，不晓得错在那里啊，第二个就可以啊，但就是感觉程序很冗余啊，麻烦各位指出第一个错在那啊，第二个给改一下啊，要精简点啊

valen_jia 2008-07-22

打赏
举报

看着头疼，不过还是看完了，不知道LZ想问什么

lovewds2002 2008-07-22

打赏
举报

代码都在页面中写的,看得眼晕啊..

yezimo 2008-07-22

打赏
举报

try {
Class.forName(className);
} catch (ClassNotFoundException e) {
e.toString();
}
conn = DriverManager.getConnection(url, user, pwd);

你的className是空值.....
url还有user,pwd也都是空的.....所以就根本没连上库....