/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package com.util;

import java.io.UnsupportedEncodingException;
import java.sql.*;

/**
*
* @author swing
*/
public class DbUtility {

    private Connection conn = null;
    private ResultSet set = null;
    private Statement st = null;
    // 数据库连接使用的参数；
    private String DBUrl = "jdbc:mysql://localhost/acctest?useUnicode=true&characterEncoding=gbk";
   //这里使用编码就可以解决mysql中文问题，其他得不需要设置
    private String DBUser = "root";// 用户名
    private String DBPass = "root";// 密码
    private String DBDriver = "org.gjt.mm.mysql.Driver";// mysql驱动
    public DbUtility() {

    }
    //获取数据库连接
    public Connection getAConnection(String DBDriver, String DBUrl, String DBUser, String DBPass) {
        try {
            Class.forName(DBDriver).newInstance();
        } catch (Exception e) {
            System.out.println("没有安装Mysql Java Connector或类路径未设置正确：   " + e);
            return null;
        }
        try {
            conn = DriverManager.getConnection(DBUrl, DBUser, DBPass);
        } catch (SQLException e) {
            System.out.println("com.util.DbUtility.getAConnection:数据库错误：   " + e);
            return null;
        }
        return conn;
    }
    //insert or update table
    public boolean execute(String sql) throws UnsupportedEncodingException {
        conn = getAConnection(DBDriver, DBUrl, DBUser, DBPass);
        if (conn == null) {
            System.out.println("连接数据库失败");
            return false;
        }
        try {
            st = conn.createStatement();
            st.execute(sql);
            st.close();
            conn.close();
            conn = null;