mySQL数据库的连接(用Bean封装)

打包在Tomcat ->webapps 中自己的定义的文件夹中WEB-INF中classes中bean中

package bean;
import java.sql.*;
public class Deng{
 String dbdriver="com.mysql.jdbc.Driver";
 java.sql.Connection conn=null;
 java.sql.ResultSet rs=null;
 public Deng()
 {
  try{
   Class.forName(dbdriver);
  }
  catch(java.lang.ClassNotFoundException e){
   System.err.println(e.getMessage());
  }
 }
 public ResultSet executeQuery(String sql){
  rs=null;
  try{
   conn=DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
   Statement stmt=conn.createStatement();
   rs=stmt.executeQuery(sql);
  }
  catch(SQLException ex)
  {
   System.err.println(ex.getMessage());
  }
  return rs;
 }
 public void executeUpdate(String sql){
  rs=null;
  try{
   conn=DriverManager.getConnection("jdbc:mysql://localhost/test","root","");
   Statement stmt=conn.createStatement();
   stmt.executeUpdate(sql);
  }
  catch(SQLException ex)
  {
   System.err.println(ex.getMessage());
  }
  
 }
 
}