private int executeUpdate(String sql, Object... params) { PreparedStatement ps = null; Connection connection = null; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) { for (int i = 0; i < params.length; i++) { ps.setObject((i + 1), params[i]); } } int rs = ps.executeUpdate(); return rs; } catch (SQLException e) { logger.error("executeUpdate->" + e.getMessage()); } finally { try { if (ps != null) { ps.close(); } if(connection!=null){ connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } return 0; } private long executeQueryInt(String sql, Object... params) {
private int executeUpdate(String sql, Object... params) { PreparedStatement ps = null; Connection connection = null; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) { for (int i = 0; i < params.length; i++) { ps.setObject((i + 1), params[i]); } } int rs = ps.executeUpdate(); return rs; } catch (SQLException e) { logger.error("executeUpdate->" + e.getMessage()); } finally { try { if (ps != null) { ps.close(); } if(connection!=null){ connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } return 0; } private long executeQueryInt(String sql, Object... params) {
long count = 0; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) {
long count = 0; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) {
List<Map<String, Object>> list = null; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) {
List<Map<String, Object>> list = null; try { connection = compensateDataSource.getConnection(); ps = connection.prepareStatement(sql); if (params != null) {