MySQL数据库操作Bean - Java

Mysql数据库操作Bean，Java语言编写

package com.consql.db;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

public class ConnectDB {
	Connection con = null;
	Statement sta = null;
	PreparedStatement preSta = null;
	ResultSet rs = null;
	
	public ConnectDB() {}
	
	// Get Connection From DataBase
	public Connection getCon(){
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			String url = "jdbc:mysql://localhost:3306/test?user=root&password=123456&useUnicode=true&characterEncoding=gb2312";
			con = DriverManager.getConnection(url);
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return con;
	}
	
	// Execute SQL Query and Return Result
	public ResultSet getQuery(String sql){
		try{
			con = getCon();
			sta = con.createStatement();
			rs = sta.executeQuery(sql);
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return rs;
	}
	
	// Execute DataBase Update
	public void doUpdate(String sql){
		try{
			con = getCon();
			sta = con.createStatement();
			sta.executeUpdate(sql);
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
	
	// Execute DataBase Update By Set Parameter
	public void doUpdate(String sql, String[] args){
		try{
			con = getCon();
			preSta = con.prepareStatement(sql);
			for(int i=0; i<args.length; i++){
				preSta.setString(i, args[i]);
			}
			preSta.executeUpdate();
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
	
	// Close DataBase
	public void doClose(){
		try{
			if(rs != null)
				rs.close();
			if(sta != null)
				sta.close();
			if(preSta != null)
				preSta.close();
			if(con != null)
				con.close();
		}catch(Exception ex){
			ex.printStackTrace();
		}
	}
}