xingchen.rar_think0527

package test.db;//导入所需包 import java.io.*; import java.sql.*; public class conn { //声明类成员 public Connection con; public String URL = "jdbc:odbc:tx061xcdb"; public String Message; public boolean connection() { try{ //加载JDBC-ODBC桥驱动程序 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException ex) { Message = ex.getMessage(); System.exit(-1); } try { //试图通过JDBC-ODBC桥建立一个与tx061数据源的连接 con = DriverManager.getConnection(URL); //数据库连接成功 return true; } catch(SQLException ex) { Message = ex.getMessage(); return false; } } //关闭数据库连接 public boolean close() { try{ con.close(); return true; } catch(Exception ex) { Message = ex.getMessage(); return false; } } //执行sql查询语句，返回执行结果集 public ResultSet exeSQL(String sqlstr) { try{ connection(); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sqlstr); return rs; }catch(Exception ex) { Message = ex.getMessage(); } return null; } //从指定的结果集rs中返回某字段str的值 public String getString(ResultSet rs,String str) { try { return rs.getString(str); }catch(Exception ex){ Message = ex.getMessage(); } return null; } }