简单的封装-封装增删改查-任何表都适用

 直接上代码，里面有注释，主要用到java的反射，可以看我上一篇关于反射的（转载的），

import com.study.entity.UserInfo;

import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.sql.*;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

//封装基础查询
public class BaseDao {
    public PreparedStatement getPreparedStatement(String sql) throws Exception {
        Connection connection= null;
        PreparedStatement pstmt = null;
        //1、建立连接
        connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "Wzl19970316");
        //2、创建pstmt对象
        pstmt = connection.prepareStatement(sql);
        return pstmt;
    }
    public void colse(PreparedStatement pstmt,Connection connection,ResultSet resultSet){
        try {
            pstmt.close();
            connection.close();
            resultSet.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
    public void colse(PreparedStatement pstmt,ResultSet resultSet){
        try {
            pstmt.close();
            resultSet.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
    public void colse(PreparedStatement pstmt,Connection connection){
        try {
            pstmt.close();
            connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    public void colse(PreparedStatement pstmt){
        try {
            pstmt.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
    public void colse(Connection connection){
        try {
            connection.close();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    /*
     * 统一删除表方法
     * */
    public void deleteDate(String sql,Object[] params) throws Exception {
        System.out.println(sql);
        PreparedStatement pstmt = getPreparedStatement(sql);
        //3、给sql语句填充参数，这里用setObject，可以传入任意类型
        if(params!=null){
            for (int i=0;i<params.length;i++){
                pstmt.setObject(i+1,params[i]);
            }
        }
        pstmt.execute();
        colse(pstmt);
    }
    /*
    * 统一更新表方法
    * */
    public void upDate(String sql,Object[] params) throws Exception {
        System.out.println(sql);
        PreparedStatement pstmt = getPreparedStatement(sql);
        //3、给sql语句填充参数，这里用setObject，可以传入任意类型
        if(params!=null){
            for (int i=0;i<params.length;i++){
                pstmt.setObject(i+1,params[i]);
            }
        }
        pstmt.executeUpdate();
        colse(pstmt);
    }
    /*
     * 统一插入表的方法
     * @param sql 不同的sql语句
     * @param params sql语句的参数,占位符
     * */
    public void saveDate(String sql,Object[] params) throws Exception {
        System.out.println(sql);
        PreparedStatement pstmt = getPreparedStatement(sql);
        //3、给sql语句填充参数，这里用setObject，可以传入任意类型
        if(params!=null){
            for (int i=0;i<params.length;i++){
                pstmt.setObject(i+1,params[i]);
            }
        }
        pstmt.executeUpdate();
        colse(pstmt);
        pstmt.close();
    }

    /*
    *
    * 统一查询表的方法
    * @param sql 不同的sql语句
    * @param params sql语句的参数,占位符
    * @param clazz sql语句查询返回的对象
    * */
    public List getRows(String sql,Object[] params, Class clazz) throws Exception {
        List<Object> list = new ArrayList<Object>();
        PreparedStatement pstmt = getPreparedStatement(sql);
        ResultSet resultSet = null;
        //3、给sql语句填充参数，这里用setObject，可以传入任意类型
        if(params!=null){
            for (int i=0;i<params.length;i++){
                pstmt.setObject(i+1,params[i]);
            }
        }
        //开始执行查询操作，resultset中有返回的结果，需要将返回的结果放置到不同的对象找那个
        resultSet = pstmt.executeQuery();
        //获取结果集合的元数据对象
        ResultSetMetaData metaData = resultSet.getMetaData();
        //判断查询到的每一行记录中包含多少个列
        int columnCount = metaData.getColumnCount();
        //循环遍历resultSet
        while (resultSet.next()){
            //创建放置具体结果属性的对象
            Object obj = clazz.newInstance();
            System.out.println("obj-----"+obj);
            for(int i=0;i<columnCount;i++){
                //从结果集合中获取单一列的值
                Object objValue = resultSet.getObject(i+1);
                System.out.println("objValue----"+objValue);
                //获取列的名称
                String columName = metaData.getColumnName(i + 1).toLowerCase();
                System.out.println("clumName----"+columName);
                //获取类中的属性
                Field declaredField = clazz.getDeclaredField(columName);
                System.out.println("declaredField-----"+declaredField);
                System.out.println("declaredField.getType()-----"+declaredField.getType());
                //获取类中属性对应的set方法
                Method method = clazz.getMethod(getSetName(columName),declaredField.getType());
                if (objValue instanceof Number){
                    Number number = (Number) objValue;
                    String fname = declaredField.getType().getName();
                    System.out.println("fname-----"+ fname);
                    if("int".equals(fname)||"java.lang.Integer".equals(fname)){
                        method.invoke(obj,number.intValue());
                    }else if("byte".equals(fname)||"java.lang.Byte".equals(fname)){
                        method.invoke(obj,number.byteValue());
                    }else if("short".equals(fname)||"java.lang.Short".equals(fname)){
                        method.invoke(obj,number.shortValue());
                    }else if("long".equals(fname)||"java.lang.Long".equals(fname)){
                        method.invoke(obj,number.longValue());
                    }else if("float".equals(fname)||"java.lang.Float".equals(fname)){
                        method.invoke(obj,number.floatValue());
                    }
                    else if("double".equals(fname)||"java.lang.Double".equals(fname)){
                        method.invoke(obj,number.doubleValue());
                    }
                }else{
                    method.invoke(obj,objValue);
                }
            }
            list.add(obj);
        }
        colse(pstmt,resultSet);
        return list;
    }

    public String getSetName(String name){
        return "set"+name.substring(0,1).toUpperCase()+name.substring(1);
    }

    public static void main(String[] args) throws Exception {
        BaseDao baseDao = new BaseDao();

        //insert 方法
      /*  for(int i=0;i<10;i++){
            baseDao.saveDate("insert into USERINFO VALUES (?,?,?,?)",new Object[]{"小明"+i,"00"+i,"21"+i,"男"});
        }
        for(int i=0;i<10;i++){
            baseDao.saveDate("insert into USERINFO VALUES (?,?,?,?)",new Object[]{"小红"+i,"00"+i,"21"+i,"女"});
        }*/

        //update 方法
  /*      for (int i=0;i<10;i++){
            baseDao.upDate("UPDATE USERINFO SET USERNAME = ? WHERE USERID = ?",new Object[]{"小冰"+i,"00"+i});
        }*/
        //delete 方法
        for (int i=0;i<10;i++){
            baseDao.deleteDate("DELETE FROM USERINFO WHERE USERID = ?",new Object[]{"00"+i});
        }
        /*
         * sql:查询sql
         * new Object[]{} : 查询条件
         * UserInfo.class : 反射类
         * */
        List rows = baseDao.getRows("select USERNAME,USERID,AGE,SEX FROM USERINFO WHERE USERID =?",new Object[]{001},UserInfo.class);
        for(Iterator it = rows.iterator();it.hasNext();){
            UserInfo userInfo = (UserInfo) it.next();
            System.out.println(userInfo);
        }
    }

}