dbmanager.java

来自「用java 写的学生信息管理系统」· Java 代码 · 共 37 行

package prjsystementer;

import java.sql.*;

public class DBManager {
    Connection cnn;
    public DBManager() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            cnn = DriverManager.getConnection("jdbc:odbc:test", "sa", "");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public void ExecuteUpdate(String sql) {
        try {
            Statement st = cnn.createStatement();
            st.executeUpdate(sql);
          } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public ResultSet ExecuteQuery(String sql) {
        try {
            Statement st = cnn.createStatement();
            return st.executeQuery(sql);
        } catch (SQLException ex) {
            ex.printStackTrace();
            return null;
        }
    }
}