數(shù)據(jù)庫(kù)jdbc封裝

經(jīng)過幾天的努力終于搞好了，這個(gè)類可以不用管數(shù)據(jù)庫(kù)字段，不用寫dao類，直接map添加，添加刪除和修改，jdbc鏈接，分享給大家，用的話記得加上連接池，尊重原創(chuàng)，轉(zhuǎn)載請(qǐng)注明

package jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.HashMap;import java.util.List;import java.util.Map;/**
 * 操作數(shù)據(jù)庫(kù)工具類
 *
 *
 */public class domain {

    /**
     * 連接數(shù)據(jù)
     *
     * @return conn
     */
    public static Connection getConnection(String url, String username, String password) {
        Connection conn = null;        
        try {
            Class.forName("com.mysql.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + url, username, password);
        } catch (Exception e) {
            e.printStackTrace();
        }        return conn;
    }    /**
     * 關(guān)閉連接對(duì)象
     *
     * @param conn
     *            連接對(duì)象
     * @param pstmt
     *            預(yù)編譯對(duì)象
     * @param rs
     *            結(jié)果集
     */
    public static void closeAll(Connection conn, PreparedStatement pstmt, ResultSet rs) {        
    try {            
    if (rs != null) {
                rs.close();
            }            
            if (pstmt != null) {
                pstmt.close();
            }            
            if (conn != null) {
                conn.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }    /**
     * 增刪改操作
     *
     * @param sql
     *            SQL命令
     * @param param
     *            參數(shù)
     * @return
     */
    public static int executUpdate(Connection conn, String sql, Object[] param) {        
    int result = 0;
        PreparedStatement pstmt = null;        
        try {
            System.out.println(sql);
            pstmt = conn.prepareStatement(sql);            
            if (param != null) {                
            for (int i = 0; i < param.length; i++) {
                    pstmt.setObject(i + 1, param[i]);
                }
            }
            result = pstmt.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            closeAll(conn, pstmt, null);
        }        return result;
    }    /**
     * 查詢
     *
     * @return int
     * @date 2015-7-25 上午11:10:06
     */
    public static ResultSet executQuery(Connection conn, String sql, String[] param) {
        PreparedStatement pstmt = null;
        ResultSet result = null;        
        try {
            pstmt = conn.prepareStatement(sql);            
            if (param != null) {                
            for (int i = 0; i < param.length; i++) {
                    pstmt.setString(i + 1, param[i]);
                }
            }
            result = pstmt.executeQuery();
        } catch (Exception e) {
            e.printStackTrace();
        }        return result;
    }    /**
     * 簡(jiǎn)單增刪改SQL語(yǔ)句執(zhí)行，復(fù)雜sql執(zhí)行executUpdate方法
     * 字符串類型需要加單引號(hào)
     * @param url
     *            數(shù)據(jù)庫(kù)
     * @param username
     *            數(shù)據(jù)庫(kù)用戶名
     * @param password
     *            數(shù)據(jù)庫(kù)密碼
     * @param map
     *            參數(shù)列，值
     * @param tableName
     *            表名
     * @param typeSql
     *            SQL類型 insert,dell,update
     * @param oldLine
     *            刪除時(shí)為要?jiǎng)h除的列名，更新的時(shí)候?yàn)閣here前的條件列名(僅當(dāng)且使用dell和update時(shí)填寫，insert時(shí)不作用)
     * @param newLine
     *            更新時(shí)where候的條件列名(僅當(dāng)且使用update時(shí)填寫，dell,insert時(shí)不作用)
     * @param oldCondition
     *            刪除時(shí)為要?jiǎng)h除的條件，更新的時(shí)候?yàn)閣here前的條件(僅當(dāng)且使用dell和update時(shí)填寫，insert時(shí)不作用)
     * @param newCondition
     *            更新的時(shí)候?yàn)閣here后的條件(僅當(dāng)且使用update時(shí)填寫，dell,insert時(shí)不作用)
     */

    public static void sql(String url, String username, String password, Map<String, Object> map, String tableName,
            String typeSql, String oldLine, String oldCondition, String newLine, String newCondition) {
        String sql = "";
        Connection conn = getConnection(url, username, password);
        Object[] valueArray = null;        if (typeSql.equals("insert")) {
            List<Object> key = new ArrayList<Object>();
            List<Object> value = new ArrayList<Object>();
            StringBuffer sb = new StringBuffer();
            StringBuffer wen = new StringBuffer();            for (Object string : map.keySet()) {
                key.add(string);
                value.add(map.get(string));
            }

            Object[] keyArray = key.toArray();
            valueArray = value.toArray();            for (int i = 0; i < keyArray.length; i++) {
                sb.append(keyArray[i] + ",");
                wen.append("?,");
            }
            String string = sb.toString();
            string = string.substring(0, string.length() - 1);
            String wenStr = wen.toString();
            wenStr = wenStr.substring(0, wenStr.length() - 1);

            sql = "INSERT INTO " + tableName + "(" + string + ") VALUES (" + wenStr + ")";
        } else if (typeSql.equals("dell")) {
            sql = "DELETE FROM " + tableName + " WHERE " + oldLine + " = " + oldCondition;
        } else if (typeSql.equals("update")) {
            sql = "UPDATE " + tableName + " SET " + oldLine + "= " + oldCondition + " WHERE " + newLine + " = "
                    + newCondition;
        }        int executUpdate = executUpdate(conn, sql + ";", valueArray);
        System.out.println(executUpdate);
    }//測(cè)試
    public static void main(String[] args) {
        Map<String, Object> map = new HashMap<String, Object>();
        map.put("appid", "lisi");         for (int i = 0; i < 100; i++) {
         System.out.println(i);
         map.put("id",i);         // 增加
          sql("test", "root", "", map, "user", "insert", "", "", "", "");          // 刪除
          sql("test", "root", "", map, "user", "dell", "id", i+"","", "");          // 修改//        
          sql("test", "root", "", map, "user", "update", "appid", "'zhang'", "id", "0");

         }        // map.put("password", "123");

    }
}

以上就是數(shù)據(jù)庫(kù)jdbc封裝的詳細(xì)內(nèi)容，更多請(qǐng)關(guān)注php中文網(wǎng)其它相關(guān)文章！