dbconn.java

来自「关于JVAA连接数据库」· Java 代码 · 共 34 行

import java.sql.*;
import java.util.*;
public class DBconn {
String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String ConnStr = "jdbc:odbc:Customers";
Connection conn = null;
ResultSet rs = null;

public  DBconn() {
try {
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   //加载数据库驱动程序
}
catch(Exception e) {
   System.err.println("DBco1nn (): " + e.getMessage());
}
}

public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(ConnStr);
//与DBMS建立链接
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
}