jdbcbean.java

mysql的jdbcbean mysql的jdbcbean

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)
      {}
    }

}