我的驱动包都配置好了,数据库感觉应该连接上了,但是就是没有显示数据,只是显示了个表头,数据库里的数据没有显示,以下是我的代码:
<%@page contentType="text/html;chaset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%!
public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";
public static final String DBURL="jdbc:oracle:thin:@localhost:1521:ORCL";
public static final String DBUSER="vendition";
public static final String DBPASS="vendition";
%>
<%
try{
Class.forName(DBDRIVER);
}catch(ClassNotFoundException e){
out.print(e);
}
try{
Connection con;
Statement sql;
ResultSet rs;
con=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
sql=con.createStatement();
rs=sql.executeQuery("select * from goods");
%><center>
<table border=2>
<tr>
<td>GOODID</td>
<td>GOODNAME</td>
<td>STOCKID</td>
<td>AREA</td>
</tr>
<%
while(rs.next()){
out.print("<tr>");
out.print("<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>");
out.print("</tr>");
}
rs.close(); sql.close();
con.close();
%>
</table>
</center>
<%
}catch(SQLException e){
out.print(e);
}
%>
</body>
</html>
感觉可能代码哪个地方错了,但是找不出来,求大神帮我找出来,或者找到解决办法!
<%@page contentType="text/html;chaset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<body>
<%!
public static final String DBDRIVER="oracle.jdbc.driver.OracleDriver";
public static final String DBURL="jdbc:oracle:thin:@localhost:1521:ORCL";
public static final String DBUSER="vendition";
public static final String DBPASS="vendition";
%>
<%
try{
Class.forName(DBDRIVER);
}catch(ClassNotFoundException e){
out.print(e);
}
try{
Connection con;
Statement sql;
ResultSet rs;
con=DriverManager.getConnection(DBURL,DBUSER,DBPASS);
sql=con.createStatement();
rs=sql.executeQuery("select * from goods");
%><center>
<table border=2>
<tr>
<td>GOODID</td>
<td>GOODNAME</td>
<td>STOCKID</td>
<td>AREA</td>
</tr>
<%
while(rs.next()){
out.print("<tr>");
out.print("<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>");
out.print("</tr>");
}
rs.close(); sql.close();
con.close();
%>
</table>
</center>
<%
}catch(SQLException e){
out.print(e);
}
%>
</body>
</html>
感觉可能代码哪个地方错了,但是找不出来,求大神帮我找出来,或者找到解决办法!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货