用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) { 

 } 

 } 

}