database.java

来自「java做的学生管理系统」· Java 代码 · 共 39 行

package studentms;
import java.sql.*;


public class Database {
    ResultSet rs ;
    String strurl="jdbc:odbc:student";
    public Database() {
    }

    public  ResultSet getResult(String sql){
        try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
           Connection  conn=DriverManager.getConnection(strurl) ;
           Statement  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
           ResultSet  rs=stmt.executeQuery(sql);
           return rs;
         }
         catch(Exception e){
              System.out.println( "getResult--"+e.toString()  );
         }
          return rs;
     }
     public boolean executeSql(String sql){
          try{
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
             Connection  conn=DriverManager.getConnection(strurl) ;
             Statement  stmt=conn.createStatement();
             stmt.executeUpdate(sql);
             conn.commit();
             return true;
            }
            catch(Exception e){
             System.out.println( "executeSql---"+e.toString()  );
             return false;
            }
      }

}