package test; 
import java.sql.*; 
public class mysql 
{ 
      Connection sqlCon=null; //數據庫連接對象 
      Statement sqlStmt=null; //SQL語句對象 
      ResultSet sqlRst=null;//結果集對象 
      public mysql(){ 
         try{ 
             Class.forName("org.gjt.mm.mysql.Driver").newInstance();; 
            } 
         catch(java.lang.ClassNotFoundException e){ 
            System.err.println("mssql()"+e.getMessage()); 
            } 
         catch(java.lang.InstantiationException e){ 
            System.err.println("mssql()"+e.getMessage()); 
            } 
         catch(java.lang.IllegalAccessException e){ 
            System.err.println("mssql()"+e.getMessage()); 
            } 
      } 
      public int Exec(String DataBase,String strSQL) 
      { 
         String url = "jdbc:mysql://localhost/test";
         String user="root";
         String password="why810707";   
         int NumRows=0; 
         try { 
                sqlCon= DriverManager.getConnection(url,user,password); 
                sqlStmt=sqlCon.createStatement(); //執行SQL語句并獲取結果集 
                NumRows=sqlStmt.executeUpdate(strSQL); 
                sqlStmt.close(); 
                sqlCon.close(); 
              } 
        catch(Exception e) { 
                e.printStackTrace(); 

              } 
       return NumRows; 
      } 
}