<%@ page import = "java.util.*"%>
<%@ page import = "java.sql.*" %>
<%@ page contentType="text/html;charset=8859_1"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
try
{
Connection sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","123456");
Statement sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet sqlRst = sqlStmt.executeQuery("SELECT * from help_topic"); }
catch (Exception E) {
out.println("Unable to load driver.");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content = "text/html; charset=gb2312">
<title>好好学习 </title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>姓名</th>
<th>年龄</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
感觉挺简单的课就是不行,大家帮看看,
<%@ page import = "java.sql.*" %>
<%@ page contentType="text/html;charset=8859_1"%>
<%
Class.forName("org.gjt.mm.mysql.Driver");
try
{
Connection sqlConn = java.sql.DriverManager.getConnection("jdbc:mysql://localhost/mysql","root","123456");
Statement sqlStmt = sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet sqlRst = sqlStmt.executeQuery("SELECT * from help_topic"); }
catch (Exception E) {
out.println("Unable to load driver.");
}
%>
<html>
<head>
<meta http-equiv="Content-Type" content = "text/html; charset=gb2312">
<title>好好学习 </title>
</head>
<body>
<table border="1" cellspacing="0" cellpadding="0" align="center">
<tr>
<th>姓名</th>
<th>年龄</th>
</tr>
<%while(sqlRst.next()){%>
<tr>
<td><%=sqlRst.getString(1)%></td>
<td><%=sqlRst.getString(2)%></td>
</tr>
<%}%>
</table>
</body>
</html>
<%
sqlRst.close();
sqlStmt.close();
sqlConn.close();
%>
感觉挺简单的课就是不行,大家帮看看,
out.println("Unable to load driver.");
}
果然牛啊
可是为什么把try删了就好用了呢?
难道不能抛异常 ?