BaseDao.util(虎大将军)

package logistics.util;

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

import javax.sql.DataSource;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

/**
 * @author �½�
 * @������dao������
 * 2018-10-25����2:54:57
 */
@Repository
public class BaseDao {
    private final static Logger logger = LoggerFactory.getLogger(BaseDao.class);
    @Autowired
    private DataSource dataSource;
    //��ȡ���ݿ�����
    public Connection getConnection() {
        try {
            return dataSource.getConnection();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return null;
    }
    //��ѯͨ�÷���
    public List<Map<String,Object>> executeQuery(String sql,Object...params) {
        List<Map<String,Object>> objList= new ArrayList<Map<String,Object>>();
        Connection conn = getConnection();
        PreparedStatement ps=null;
        ResultSet rs=null;
        try {
             ps = conn.prepareStatement(sql);
             ps = setParams(ps, params);
             //ִ��sql
              rs = ps.executeQuery();
              //��ȡ��Ԫ������Ϣ
              ResultSetMetaData metaData = rs.getMetaData();
              //���������
              while(rs.next()){
                  Map<String,Object> row= new HashMap<String, Object>();
                  //metaData.getColumnCount()��ȡ����
                  for (int i = 0; i < metaData.getColumnCount(); i++) {
                      row.put(metaData.getColumnLabel(i+1), rs.getObject(i+1));
                  }
                  objList.add(row);
              }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return objList;
    }
    //��ɾ��ͨ�÷���
    public boolean executeUpdate(String sql,Object...params) {
        Connection conn = getConnection();
        PreparedStatement ps=null;
        try {
             ps = conn.prepareStatement(sql);
             ps = setParams(ps, params);
             //ִ��sql
              int ret = ps.executeUpdate();
              if(ret>0){
                  logger.info("�����ɹ�");
                  return true;       
              }else
              {
                  logger.info("����ʧ��");
                  return false;
              }
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return false;
    }
    
    //订单返回
    public Integer executeUpdateGetPK(String sql,Object...params) {
        Connection conn = getConnection();
        PreparedStatement ps=null;
        try {
             ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
             ps = setParams(ps, params);
             //ִ��sql
              int ret = ps.executeUpdate();
              ResultSet set1 = ps.getGeneratedKeys();
              while(set1.next()){
                    return set1.getInt(1);
               }
              
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                conn.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return null;
    }
    //��ֵͨ�÷���
    public  PreparedStatement setParams(PreparedStatement ps,Object...params) {
            if(params!=null){
                for (int i = 0; i < params.length; i++) {
                    try {
                        ps.setObject(i+1, params[i]);
                    } catch (SQLException e) {
                        e.printStackTrace();
                    }        
                }
            }
            return ps;
    }
}