jdbcconn.java

用java实现的学生管理系统

package xscjgl;
import  java.sql.*;
import  java.io.*;
import  java.lang.*;

public class Jdbcconn
{
        private Connection  db=null;
        private Statement  stmt=null;
        ResultSet  result=null;

        public Jdbcconn(){}

        public void OpenConn(String dsn, String uid, String pwd) throws Exception {
            try {
                String strdsn =
                        "jdbc:odbc:mydb;DatabaseName=" +
                        dsn;
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                db = DriverManager.getConnection(strdsn, uid, pwd);
            } catch (Exception e) {
                e.printStackTrace();
            }
        }

        public ResultSet getResults(String sproc) throws Exception {
            Statement stmt = db.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
                                                ResultSet.CONCUR_READ_ONLY);
            ResultSet result = stmt.executeQuery(sproc);
            result.last();
            return result;
        }

        public void executeUpdate(String sql) {

    //stmt=null;
    //result=null;
            try {
                stmt = db.createStatement();
                stmt.executeQuery(sql);
                stmt.close();
                stmt = null;
            } catch (SQLException ex) {
                System.err.println("aq.executeQuery: " + ex.getMessage());
            }
        }



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


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


}