Method execute

src/main/java/smbms/dao/BaseDao.java:73–81

查询操作 获取service层统一的connection对象，补充预编译sql语句，返回结果集 @param connection @param pstm @param resultSet @param sql @param params @return @throws Exception

(Connection connection, PreparedStatement pstm,ResultSet resultSet, String sql, Object[] params)

     * @throws Exception
     */
    public static ResultSet execute(Connection connection, PreparedStatement pstm,ResultSet resultSet, String sql, Object[] params) throws Exception {
        //预编译SQL语句，返回一个PreparedStatement实例
        pstm = connection.prepareStatement(sql);
        for (int i = 0; i < params.length; i++) {
            pstm.setObject(i+1,params[i]);
        }
        resultSet = pstm.executeQuery();
        return resultSet;
    }

    /**
     * 更新操作,返回受影响的行数