类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page contenttype="text/html;charset=8859_1"%>
<%
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.Resultset sqlRst;
Class.forName("org.gjt.mm.mysql.Driver").newsInstance();
sqlConn=Java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/dbname","accounts","password");
sqlstmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
sqlRst=sqlStmt.executeQuery("SELECT title,name from message");
%>
<html>
<body>
<% while(sqlRst.next()){ %>
<%=sqlRst.getString(1)%>,<%=sqlRst.getString(2)%><br><br>
<%}%>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
网友回答：
你把错误的代码给我呀
错误显示不出来，因为没有扑捉错误，改成这样扑捉错误，然后再看看了
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page contenttype="text/html;charset=8859_1"%>
<%
try{
java.sql.Connection sqlConn;
java.sql.Statement sqlStmt;
java.sql.Resultset sqlRst;
Class.forName("org.gjt.mm.mysql.Driver").newsInstance();
sqlConn=Java.sql.DriverManager.getConnection("jdbc:mysql://127.0.0.1/dbname","accounts","password");
sqlstmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
sqlRst=sqlStmt.executeQuery("SELECT title,name from message");
%>
<html>
<body>
<% while(sqlRst.next()){ %>
<%=sqlRst.getString(1)%>,<%=sqlRst.getString(2)%><br><br>
<%}%>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
}catch(Excepiton ex)
{System.out.print(ex);}
%>
怎么不写代码啊