conn.java

来自「该源码为JSP的开发案例集锦」· Java 代码 · 共 32 行

package ch4;
import java.sql.*;
public class conn {
    	String dbUrl = "jdbc:mysql://localhost/csnews";
	String dbUser = "root";
 	String dbPassword = "";

	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;
	}
}