smbms项目环境搭建

 

 

 

 

 

 

 

 

 

 

 　　　　　　

public static int  execute(Connection connection, String sql, Object[] params, PreparedStatement preparedStatement) throws SQLException {
    preparedStatement = connection.prepareStatement(sql);
    for (int i = 0; i < params.length; i++) {
        preparedStatement.setObject(i+1,params[i]);
    }
    int updateRows = preparedStatement.executeUpdate();
    return updateRows;
}

public static boolean closeResource(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){
    boolean flag = true;

    if(resultSet!=null){
        try {
            resultSet.close();
            resultSet = null;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
            flag = false;
        }
    }
    if(connection!=null){
        try {
            connection.close();
            connection = null;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
            flag = false;
        }
    }
    if(preparedStatement!=null){
        try {
            preparedStatement.close();
            preparedStatement = null;
        } catch (SQLException throwables) {
            throwables.printStackTrace();
            flag = false;
        }
    }
    return flag;
}