连接数据库的封装

package com.li72.ConDB;

import java.sql.*;

public class ConDB {
 Connection con = null;
 Statement stmt;
 ResultSet rs = null;
 private String driverName = "com.mysql.jdbc.Driver";
 private String driverManager = "jdbc:mysql://localhost:3306/shopping?"
   + "user=root&password=root&useUnicode=true&characterEncoding=GB2312";

 public ConDB() {
  try {
   Class.forName(driverName);
  } catch (ClassNotFoundException e) {
   System.err.println("ClassNotFoundException: " + e.getMessage());
  }
 }

 public Connection getConnection() {
  try {

   con = DriverManager.getConnection(driverManager);

  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }
  return con;
 }

 public Statement getStatement() {
  stmt = null;
  con = this.getConnection();
  try {
   stmt = con.createStatement();
  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }

  return stmt;
 }

 public ResultSet getResult(String sql) {
  rs = null;

  stmt = this.getStatement();
  try {
   rs = stmt.executeQuery(sql);
  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }
  return rs;
 }

 public int add(String sql) {
  int n = 0;
  stmt = this.getStatement();
  try {
   n = stmt.executeUpdate(sql);
  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }
  return n;
 }

 public int delet(String sql) {
  int n = 0;
  stmt = this.getStatement();
  try {
   n = stmt.executeUpdate(sql);
  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }
  return n;
 }

 public int moditfy(String sql){
  int n=0;
  stmt=this.getStatement();
  try{
   n=stmt.executeUpdate(sql);
  }catch(SQLException e){
   System.err.println("SQLException: " + e.getMessage());
  }
  return n;
 }

 public void close() {
  try {
   if (con != null) {
    con.close();
    con = null;
   }
   if (stmt != null) {
    stmt.close();
    stmt = null;
   }
   if (rs != null) {
    rs.close();
    rs = null;
   }
  } catch (SQLException e) {
   System.err.println("SQLException: " + e.getMessage());
  }
 }

}