QueryRunner封装数据库增、删、改、查语句

最新推荐文章于 2023-06-07 16:52:05 发布

Z_唐

最新推荐文章于 2023-06-07 16:52:05 发布

阅读量1.6k

点赞数 1

分类专栏： JDBC 文章标签：数据库

本文链接：https://blog.csdn.net/xmz1996/article/details/78931809

版权

JDBC 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

import java.sql.Connection;
import java.sql.SQLException;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;

public class QRUtil extends QueryRunner{

    @Override
    public int[] batch(String sql, Object[][] params) throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        int[] i = super.batch(conn, sql, params);
        JDBCUtil.closeConnection(conn);
        return i;
    }

    @Override
    public <T> T query(String sql, ResultSetHandler<T> rsh, Object... params)
            throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        T t = super.query(conn, sql, rsh, params);
        JDBCUtil.closeConnection(conn);
        return t;
    }

    @Override
    public <T> T query(String sql, ResultSetHandler<T> rsh) throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        T t = super.query(conn, sql, rsh);
        JDBCUtil.closeConnection(conn);
        return t;
    }

    @Override
    public int update(String sql, Object... params) throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        int i = super.update(conn, sql, params);
        JDBCUtil.closeConnection(conn);
        return i;
    }

    @Override
    public int update(String sql, Object param) throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        int i = super.update(conn, sql, param);
        JDBCUtil.closeConnection(conn);
        return i;
    }

    @Override
    public int update(String sql) throws SQLException {
        Connection conn =  JDBCUtil.getConnection();
        int i = super.update(conn, sql);
        JDBCUtil.closeConnection(conn);
        return i;
    }

}