![]() |
#2
kingyor2008-02-29 09:44
import
import java.sql.*; public class PubSQL{ private Connection conn; public ResultSet rs; private String sDBDriver; private String sConnStr; public PubSQL() { conn = null; sDBDriver = "org.gjt.mm.mysql.Driver"; sConnStr = "jdbc:mysql://127.0.0.1:3306/"+dbname+"?user=root&password=123"; try { Class.forName(sDBDriver); } catch(ClassNotFoundException classnotfoundexception) { System.out.println("Jdbc_conn():" + classnotfoundexception.getMessage()); } } public ResultSet query(String s) throws Exception { try { s = new String(s.getBytes("UTF-8"), "ISO8859_1"); conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(); rs = statement.executeQuery(s); } catch(SQLException sqlexception) { System.out.print("sql.executeQuery:" + sqlexception.getMessage()); } return rs; } public void update(String sy) throws Exception { try { sy = new String(sy.getBytes("UTF-8"), "ISO8859_1"); conn = DriverManager.getConnection(sConnStr); Statement statement = conn.createStatement(); statement.executeUpdate(sy); } catch(SQLException sqlexception) { System.out.print("sql.executeQuery:" + sqlexception.getMessage()); } } } [[it] 本帖最后由 kingyor 于 2008-2-29 09:58 编辑 [/it]] |
conn.java文件如下:
package conn;
import java.sql.*;
public class conn {
String dbUrl = "jdbc:mysql://localhost:3306/user";
String dbUser = "root";
String dbPassword = "12345";
Connection connect = null;
ResultSet rs = null;
public conn() {
try {
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.println( e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
try {
connect = DriverManager.getConnection(dbUrl,dbUser,dbPassword);
Statement stm = connect.createStatement();
rs = stm.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
}
conn.jsp文件如下:
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="connBean" scope="page" class="conn.conn"/>
<html>
<head>
<title>使用Bean连接MYSQL数据库</title>
</head>
<body bgcolor="#FFCCCC">
<div align="center">
<table width="60%" border="1">
<tr>
<td width="50%" bgcolor="#CCCCFF">
<div align="center"><font color="#FF0033"><b>学号</b></font></div>
</td>
<td width="25%" bgcolor="#CCCCFF">
<div align="center"><font color="#FF0033"><b>姓名</b></font></div>
</td>
</tr>
<%
ResultSet rs = connBean.executeQuery("select * from info");
while (rs.next()){
%>
<tr>
<td width="50%">
<div align="center"><%=rs.getString(1)%></div>
</td>
<td width="25%">
<div align="center"><%=rs.getString(2)%></div>
</td>
</tr>
<%
}
rs.close();
%>
</table>
</body>
</html>
提示 while (rs.next()){ 这一行出错.
请问有没有好的连接方式.