sql.java

来自「虚拟银行」· Java 代码 · 共 43 行

package Tools;
import java.sql.*;
public class sql{  
    String dbDriver = "com.mysql.jdbc.Driver";    
      String ConnStr = "jdbc:mysql://localhost:3306/Bank";
      Connection Conn = null;
      ResultSet Rst = null;
   public sql(){
        try{
         Class.forName("com.mysql.jdbc.Driver"); 
        }catch(java.lang.ClassNotFoundException e){
                System.err.print(e.getMessage()); 
        }
   }
   public ResultSet sqlQuery(String cmdText){
       Rst = null;
       try{
           Conn = DriverManager.getConnection(ConnStr, "root", "wb");
           Statement stmt = Conn.createStatement();
           try{
           Rst = stmt.executeQuery(cmdText);
           }catch(java.sql.SQLException e){
              System.err.println("falier1"+e);
           }
           //Conn.close();
        }catch(java.sql.SQLException e){
              System.err.println("failer2"+e);
       }
       return Rst;
     }
     public void sqlUpdate(String cmdText){
         try{
              Conn = DriverManager.getConnection(ConnStr, "root", "wb");
              Statement stmt = Conn.createStatement();
              stmt.executeUpdate(cmdText);
             //Conn.close();
         }catch(java.sql.SQLException e){
              System.err.println(e);
         }
     }
   
}