connectdbbean.java~1~

这里有好几个关于SQL Server 2000 开发的项目代码

package XsglSys;

/**
 * <p>Title: 销售管理信息系统</p>
 * <p>Description: 销售管理信息系统，企业好帮手！</p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: ios</p>
 * @author dragon
 * @version 1.0
 */

import java.sql.*;

public class ConnectDBBean {
  String MyDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
  String ConnStr = "jdbc:odbc:XsglSys";
  Connection conn = null;
  ResultSet rs = null;
  public ConnectDBBean() {
    try {
      Class.forName(MyDriver); //指定使用的JDBC-ODBC桥驱动程序
    }
    catch (ClassNotFoundException ex) {
      System.err.println("连接数据库出错： " + ex.getMessage());
    }
  }

  public ResultSet executeQuery(String sql) {
    rs = null;
    try { //连接数据库
      conn = DriverManager.getConnection(ConnStr,"sa","sa");
      Statement stmt = conn.createStatement();
      rs = stmt.executeQuery(sql); //执行查询

    }
    catch (SQLException ex) {
      System.err.println("查询出错： " + ex.getMessage());
    }
    return rs; //返回结果集
  }

}