Y
ydiandian
Unregistered / Unconfirmed
GUEST, unregistred user!
<html>
<body>
<%@ page contentType="text/html;charset=Big5" language="java" import="java.sql.*" %>
<%
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc
dbc:jspdb","","");
Statement statement=con.createStatement();
ResultSet rs=statement.executeQuery("select * from itemTab");
%>
<table border="1">
<tr><th>编号</th><th>名称</th><th>单价</th><th>数量</th></tr>
<%
while (rs.next())
{
out.println("<tr><td>"+rs.getObject("id")+"</td>");
out.println("<td>"+rs.getObject("desc")+"</td>");
out.println("<td>"+rs.getObject("price")+"</td>");
out.println("<td>"+rs.getObject("qty")+"</td></tr>");
}
rs.close();
con.close();
}
%>
<%
catch (Exception e)
{
out.print(e.getMessage());
}
%>
</table>
</body>
</html>
上述代码有了
try
与
<%
catch (Exception e)
{
out.print(e.getMessage());
}
%>
回出错，希望大侠能指点一二！！！
而没有，数据表中的数据就能正常的显示出来？？？？
<body>
<%@ page contentType="text/html;charset=Big5" language="java" import="java.sql.*" %>
<%
Connection con=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc
dbc:jspdb","","");Statement statement=con.createStatement();
ResultSet rs=statement.executeQuery("select * from itemTab");
%>
<table border="1">
<tr><th>编号</th><th>名称</th><th>单价</th><th>数量</th></tr>
<%
while (rs.next())
{
out.println("<tr><td>"+rs.getObject("id")+"</td>");
out.println("<td>"+rs.getObject("desc")+"</td>");
out.println("<td>"+rs.getObject("price")+"</td>");
out.println("<td>"+rs.getObject("qty")+"</td></tr>");
}
rs.close();
con.close();
}
%>
<%
catch (Exception e)
{
out.print(e.getMessage());
}
%>
</table>
</body>
</html>
上述代码有了
try
与
<%
catch (Exception e)
{
out.print(e.getMessage());
}
%>
回出错，希望大侠能指点一二！！！
而没有，数据表中的数据就能正常的显示出来？？？？