conn.java

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· Java 代码 · 共 28 行

package student;
import java.sql.*;
public class conn {
	String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	String sConnStr="jdbc:odbc:sqlodbc";
	Connection connect=null;
	ResultSet rs=null;
	public conn() {
		try {
			Class.forName(sDBDriver); 
		}
		catch(java.lang.ClassNotFoundException e) {
			System.err.println( e.getMessage());
		}
	}
	public ResultSet executeQuery(String sql) {
		try {
			connect=DriverManager.getConnection(sConnStr); 
			Statement stmt=connect.createStatement();
			rs=stmt.executeQuery(sql);
		} 
		catch(SQLException ex) { 
			System.err.println(ex.getMessage());
		}
		return rs;
	}
}