dbconnection.java

简单的留言版

package res;
import java.sql.*;

/**
 * <p>Title: 连接数据库的类</p>
 *
 * <p>Description: 用JDBC&ODBC桥实现</p>
 *
 * <p>Copyright: A1Q6073-未定义小组 2006</p>
 *
 * <p>Company: 北大青鸟Aptech(西安毕诚) </p>
 *
 * @author not 王亮　冯瑞　冯鹏　刘文涛 赵凡(按姓氏笔画排序)
 * @version 1.0
 */

public class DBconnection {
    String strDriver;
    String strCon;
    Connection con;
    Statement stmt;
    ResultSet rs;
    public DBconnection() {
        strDriver="sun.jdbc.odbc.JdbcOdbcDriver";
        strCon="jdbc:odbc:test";
    }
    /*有返回结果集的方法*/
    public ResultSet GetRs(String Sql) {
        try {
            Class.forName(strDriver);
            con = DriverManager.getConnection(strCon);
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
                                 ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(Sql);
        } catch (Exception ex) {
            rs=null;
            System.out.println(ex.getMessage()+"数据库连接失败");
        }
        return rs;
    }

    /*无返回结果集的方法*/
    public void ResultSql(String Sql) {
        try {
            Class.forName(strDriver);
            con = DriverManager.getConnection(strCon);
            stmt = con.createStatement();
            stmt.executeQuery(Sql);
            stmt.close();
            con.close();
        } catch (Exception ex) {

        }
    }

}