数据库底层连接

package com.wen;

import java.sql.*;

/**
 * Title: 数据库底层连接
 * Description:
 * Copyright:    Copyright (c) 2004
 * Company:
 * @author  explorer
 * @version 1.0
 */
public class Linkdb {
  String strDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //加载驱动程序
  String strConn = "jdbc:odbc:dbserver";
  private Connection conn = null;
  private Statement stmt = null; //执行SQL语句
  ResultSet rs = null;

  public Linkdb() {
    try {
      Class.forName(strDriver).newInstance(); //**newInstance()什么意思？**//
    }
    catch (Exception e) {
      System.err.println("不能连接数据库！" + e.getMessage());
    }
  }

//执行Select语句
  public ResultSet executeQuery(String sql) {
    try {
      conn = DriverManager.getConnection(strConn, "sa", "sa"); //建立与数据源之间的连接
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                  ResultSet.CONCUR_READ_ONLY);
      rs = stmt.executeQuery(sql); //反回结果集
    }
    catch (SQLException ex) {
      System.err.println("执行SQL语句出错：" + ex.getMessage());
    }
    return rs;
  }

//执行Insert,Update语句
  public void executeUpdate(String sql) {
    try {
      conn = DriverManager.getConnection(strConn, "sa", "sa");
      stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                  ResultSet.CONCUR_READ_ONLY); //分页必加参数
      stmt.executeQuery(sql);
      stmt.close();
      conn.close();
    }
    catch (SQLException ex) {
      System.err.println("执行SQL语句出错: " + ex.getMessage());
    }
  }

  public void closeStmt() {
    try {
      stmt.close();
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public void closeConn() {
    try {
      conn.close();
    }
    catch (SQLException e) {
      e.printStackTrace();
    }
  }
}