basedao.java

来自「简单的分页类」· Java 代码 · 共 51 行

package com.accp;

import java.sql.*;

public class BaseDao {
    private Connection conn;
    private Statement stmt;
    private ResultSet rs;


    public BaseDao() { //连接数据库
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            conn = DriverManager.getConnection(
                    "jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\accp.mdb",
                    "", "");
            stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                        ResultSet.CONCUR_UPDATABLE);
        } catch (Exception ex) {
            System.out.println(ex);
        }
    }

    public void executeUpdate(String sql) throws SQLException { //插入数据库
        stmt.executeUpdate(sql);
    }

    public ResultSet executeQuery(String sql) throws SQLException {
        rs = stmt.executeQuery(sql);
        return rs;
    }

    public void close() { //关闭数据库
        if (rs != null) {
            try {
                rs.close();
            } catch (Exception ex) {}
        }
        if (stmt != null) {
            try {
                stmt.close();
            } catch (Exception ex) {}
        }
        if (conn != null) {
            try {
                conn.close();
            } catch (Exception ex) {}
        }
    }
}