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();
}
}
}