java查询mysql装载bean_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

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();

}

}

}