dbmanager.java~3~

这是一个图书管理系统

package bookmanager;
import java.sql.*;

public class DBManager {
      ResultSet rs ;
      String strurl="jdbc:odbc:myBook";
  public DBManager() {

                      }

  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;
            }
         }
         public int executeSqlupdate(String sql){
         try{
           int intreturn=0;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
            Connection  conn=DriverManager.getConnection(strurl) ;
            Statement  stmt=conn.createStatement();
         intreturn=   stmt.executeUpdate(sql);
            conn.commit();
                return intreturn;
           }
          catch(Exception e){
            System.out.println( "executeSql------"+e.toString()  );
                return 0;
           }
        }

  }