用JavaBean编写SQL Server数据库连接类

//类conn.db.conndb.java 



package conn.db; 



import java.sql.*; 



public class conndb { 



 Connection conn; 



 ResultSet rs; 



 private int count; 



 public conndb() { 



 try { 



 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 



 



 } catch (Exception ex) {} 



 } 



 public ResultSet executeQuery(String sql){ 



 try { 



 conn=DriverManager.getConnection("Jdbc:Odbc:mysql","dxaw","123"); 



 Statement stat=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, 



ResultSet.CONCUR_UPDATABLE); 



 rs=stat.executeQuery(sql); 



 } catch (Exception ex1) { 



 } 



 return rs; 



 } 



 public void executeUpdate(String sql){ 



 try { 



 conn = DriverManager.getConnection("Jdbc:Odbc:mysql", "dxaw","123"); 



 Statement stat=conn.createStatement(); 



 stat.executeQuery(sql); 



 } catch (Exception ex2) { 



 } 



 } 



}