package manage;
import java.sql.*;

public class JdbcBean {
  Connection con=null;
  ResultSet rs=null;
  int value=0;

//實例化，裝載JDBC驅動
  public JdbcBean() {
    try {
      Class.forName("org.gjt.mm.mysql.Driver");
    }
    catch (ClassNotFoundException e) {}
  }

  //查詢后返回的數據集
 public ResultSet executeQuery(String sql){
      try{
       con=DriverManager.getConnection("jdbc:mysql://localhost/secman","root","root");
       Statement stmt = con.createStatement ();
       rs=stmt.executeQuery(sql);
      }
     catch(SQLException e)
     {}
     return rs;
 }

   //更新數據庫
 public int executeUpdate(String sql){
      try{
       con=DriverManager.getConnection("jdbc:mysql://localhost/secman","root","root");
       Statement stmt = con.createStatement ();
	   System.out.println(11);
       value=stmt.executeUpdate(sql);
	   System.out.println(22);
      }
     catch(SQLException e)
     {e.printStackTrace();}
     return value;
 }

 //關閉數據庫
 public void closeDB(){
      try{
        rs.close();
        con.close();
      }catch(SQLException e)
      {}
    }

}