BaseDao

最新推荐文章于 2018-09-17 12:30:24 发布
最新推荐文章于 2018-09-17 12:30:24 发布
阅读量455 收藏 1
点赞数
分类专栏： java基础 javaweb java工具类 文章标签： JdbcTemplate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/whiteblack_dream/article/details/71908517
版权 
package com.whiteblack.ebookbusniss.dao.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class BaseDao {
    private static String driverClass = "com.mysql.jdbc.Driver";
    private static String url = "jdbc:mysql://localhost:3306/tb_user";
    private static String user = "root";
    private static String password = "123456";

    public int update(String sql, Object ... params) throws SQLException {      
        Connection conn = null;
        PreparedStatement pstmt = null;

        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);

            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }
            int count = pstmt.executeUpdate();
            return count;

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }

        }finally{
            close(conn, pstmt, null);
        }       
    }

    public int insert(String sql, Object ... params) throws SQLException {      
        Connection conn = null;
        PreparedStatement pstmt = null;

        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);

            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }
            int count = pstmt.executeUpdate();
            if(count > 0){
                String idSql = "SELECT LAST_INSERT_ID()";
                ResultSet rs = conn.createStatement().executeQuery(idSql);
                if(rs.next()){
                    return rs.getInt(1);
                }
            }
        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }

        }finally{
            close(conn, pstmt, null);
        }

        return 0;
    }

    @SuppressWarnings("unchecked")
    public <T> T queryForObject(Class<T> clazz, String sql, Object ... params) throws SQLException{     
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);


            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            if(rs.next()){
                Object value = rs.getObject(1);
                return (T)value;
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return null;
    }

    public int queryForInt(String sql, Object ... params) throws SQLException{      
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);


            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            if(rs.next()){
                return rs.getInt(1);
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return -1;
    }
    public <T> T queryForBean(Class<? extends ParseResultSet<T>> clazz, String sql, Object ... params) throws SQLException{     
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);


            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            if(rs.next()){  
                ParseResultSet<T> bean = clazz.newInstance();
                return bean.readResultSetValues(rs);
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return null;
    }

    @SuppressWarnings("unchecked")
    public <T> List<T> query(String sql, Object ... params) throws SQLException{    
        List<T> list = null;

        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);


            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            list = new ArrayList<T>();
            while(rs.next()){
                Object value = rs.getObject(1);
                list.add((T)value);
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return list;
    }

    public <T> List<T> query(Class<? extends ParseResultSet> clazz, String sql, Object ... params) throws SQLException{     

        List<T> list = null;

        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);            

            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            list = new ArrayList<T>();
            while(rs.next()){   
                ParseResultSet<T> bean = clazz.newInstance();

                list.add(bean.readResultSetValues(rs));
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return list;
    }


    public List<Map<String, Object>> queryForList(String sql, Object ... params) throws SQLException{       

        List<Map<String, Object>> list = null;

        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);            

            pstmt = conn.prepareStatement(sql);
            if(params != null){
                for (int i = 0; i < params.length; i++) {
                    pstmt.setObject(i + 1, params[i]);
                }
            }

            rs = pstmt.executeQuery();

            ResultSetMetaData rsmd = rs.getMetaData();
            int colCount = rsmd.getColumnCount();

            list = new ArrayList<Map<String, Object>>();
            while(rs.next()){
                Map<String, Object> rowMap = new HashMap<String, Object>();
                for (int i = 1; i <= colCount; i++) {
                    String name = rsmd.getCatalogName(i).toLowerCase();
                    Object value = rs.getObject(i);
                    if(value != null) rowMap.put(name, value);
                }
                list.add(rowMap);
            }

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }
        }finally{
            close(conn, pstmt, rs);
        }

        return list;
    }


    public int[] executeBatch(String sql, Object[][] paramsAry) throws SQLException {

        Connection conn = null;
        PreparedStatement pstmt = null;

        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);

            pstmt = conn.prepareStatement(sql);
            if(paramsAry != null){              
                for (int i = 0; i < paramsAry.length; i++) {
                    Object[] params = paramsAry[i];
                    for (int j = 0; j < params.length; j++) {
                        pstmt.setObject(j + 1, params[j]);
                    }
                    pstmt.addBatch();
                }
            }
            int[] counts = pstmt.executeBatch();
            return counts;

        } catch (Exception e) {
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }

        }finally{
            close(conn, pstmt, null);
        }


    }

    public int[] executeBatch(String[] sqlAry, Object[][] paramsAry) throws SQLException {

        int[] counts = new int[sqlAry.length];

        Connection conn = null;
        PreparedStatement pstmt = null;

        try {           
            Class.forName(driverClass);         
            conn = DriverManager.getConnection(url, user, password);
            conn.setAutoCommit(false);

            for (int i = 0; i < sqlAry.length; i++) {
                String sql = sqlAry[i];
                pstmt = conn.prepareStatement(sql);
                if(paramsAry != null){
                    Object[] params = paramsAry[i];
                    if(params != null){
                        for (int j = 0; j < params.length; j++) {
                            pstmt.setObject(j + 1, params[j]);
                        }
                    }
                }
                counts[i] = pstmt.executeUpdate();
                pstmt.close();
            }

            conn.commit();
            return counts;

        } catch (Exception e) {
            conn.rollback();
            if(e instanceof SQLException){
                throw (SQLException)e;
            }else{
                throw new SQLException(e);
            }

        }finally{
            close(conn, null, null);
        }


    }



    private void close(ResultSet rs, PreparedStatement pstmt, Connection conn) {
        if(rs != null){             
            try {
                rs.close();
            } catch (SQLException e) {
                // log ....
            }
        }
        if(pstmt != null){
            try {
                pstmt.close();
            } catch (SQLException e) {
                // log ....
            }
        }
        if(conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                // log ....
            }
        }
    }





    private void close(Connection conn, PreparedStatement pstmt, ResultSet rs) {
        if(rs != null){
            try {
                rs.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if(pstmt != null){
            try {
                pstmt.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        if(conn != null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}
一杯红酒配电影
关注
专栏目录
NC65通过BaseDAO操作数据库
03-01
NC65通过BaseDAO操作数据库，包含接口类及接口实现类： /** * 获取baseDAO * @return */ public BaseDAO getBaseDAO() { if(baseDAO == null){ baseDAO = new BaseDAO(); } return baseDAO; } public ...
基于JDBC封装的BaseDao(实例代码)
09-02
在构造函数中，通过`JdbcUtil.getConnection()`获取数据库连接，并通过反射机制获取`BaseDao`的父类泛型类型，从而得到`persistentClass`，这样我们就可以知道这个`BaseDao`实例对应的是哪个实体类。 `BaseDao`的...
basedao_basedao数据库_
09-30
手动实现BaseDao 自动写数据库操作
basedao
qpy520的专栏
07-02 365
<br />package com.comm;<br />import java.io.Serializable;<br />import java.sql.SQLException;<br />import java.util.List;<br />import org.hibernate.HibernateException;<br />import org.hibernate.Query;<br />import org.hibernate.Session;<br />import org.sprin
BaseDAO
ywj_316的博客
11-30 112
sql package org.epet.dao.impl;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import javax.naming.Cont...
BaseDAO（反射泛型）
zxiang248的专栏
07-17 1564
利用baseDAO实现增删查改public class BaseDao<T>{ // 保存当前运行类的参数化类型中的实际的类型 private Class clazz; // 表名 private String tableName; // 构造函数： 1. 获取当前运行类的参数化类型； 2. 获取参数化类型中实际类型的定义(class) public Ba
Basedao
热门推荐
儒雅随和丶mata坤的博客
09-17 1万+
Basedao   为什么要建立basedao： 若有新的功能需要添加,但是该功能与现有的dao层的接口的功能无关, 就需要新建一个dao层,实现要添加的方法，如果有和userdao或者recorddao相类似,但是参数类型不同的方法,也得再写一遍方法,这样大大提高了代码的工作量。所以建立basedao，把通用的方法放到里面，让其他的dao层接口继承该接口，其他的dao层实现类也继承该实现...
mybatis basedao
12-07
MyBatis BaseDAO 是一种基于 MyBatis 框架的工具类库，它旨在简化数据库操作，通过封装常见的CRUD（Create、Read、Update、Delete）方法，为开发者提供便利，减少重复代码，提高开发效率。在Java Web 开发中，...
BaseDao的封装
07-31
在IT行业中，数据库操作是应用程序的核心部分，而`BaseDao`的封装则是一种常见的设计模式，用于简化数据库访问层（DAO）的实现。这个模式的主要目的是提高代码的可复用性和可维护性，减少重复的SQL操作代码。下面...
BaseDAO.js
04-04
NULL 博文链接：https://zhaopeinow.iteye.com/blog/1271002
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值