loginbean.java

来自「自己做的一份在线考试系统」· Java 代码 · 共 58 行

package BeanPage;
import java.sql.*;
public class loginBean {
        String sDBDriver = "sun.odbc.JdbcOdbcDriver";
        String sConnStr = "jdbc:odbc:login";
        Connection connect = null;
        ResultSet rs = null;
    public loginBean() {
       try{
           Class.forName(sDBDriver);
       }
       catch(java.lang.ClassNotFoundException e){
        System.err.println(e.getMessage());
       }
    }
    public ResultSet executeQuery(String sql){
        try{
            connect = DriverManager.getConnection(sConnStr);
            Statement stmt = connect.createStatement();
            rs = stmt.executeQuery(sql);
        }
        catch(SQLException ex){
             System.err.println(ex.getMessage());
        }
        return rs;
    }//INSERT INTO 
    public void insertSql (String sql){
        try{
            connect = DriverManager.getConnection(sConnStr);
            Statement stmt = connect.createStatement();
            stmt.executeUpdate(sql);
            connect.close();
        }catch(SQLException ex){
           System.err.println(ex.getMessage());
        }
    }
    public void updateSql(String sql){
        try{
            connect = DriverManager.getConnection(sConnStr);
            Statement stmt = connect.createStatement();
            stmt.executeUpdate(sql);
            connect.close();
        }catch(SQLException ex){
            System.err.println(ex.getMessage());
        }
    }
    public void deleteSql(String sql){
        try{
            connect = DriverManager.getConnection(sConnStr);
            Statement stmt = connect.createStatement();
            stmt.executeUpdate(sql);
            connect.close();
        }catch(SQLException ex){
            System.err.println(ex.getMessage());
        }      
    }
}