in shardingsphere-benchmark/src/main/java/org/apache/shardingsphere/benchmark/jmeter/rangerouting/encrypt/JMeterShardingJDBCRangeRoutingEncryptInsertUpdateDelete.java [32:86]
public SampleResult runTest(JavaSamplerContext context) {
ResultSet rs = null;
SampleResult results = new SampleResult();
results.setSampleLabel("SJPerformanceMSSelect");
results.sampleStart();
Connection connection = null;
try {
connection = dataSource.getConnection();
String insertSql = (String) sqlConfig.get("ss.benchmark.rangerouting.encrypt.insert.sql");
List insertParams = convertParams((List) sqlConfig.get("ss.benchmark.rangerouting.encrypt.insert.values"));
String insertSqlBatch = (String) sqlConfig.get("ss.benchmark.rangerouting.shardingmasterslaveencrypt.insert.sql");
int insertCount = getInsertCount(insertSqlBatch);
/*
List insertBatchParams = convertParams((List) sqlConfig.get("ss.benchmark.rangerouting.shardingmasterslaveencrypt.insert.values"));
rs = JDBCDataSourceUtil.insert(connection, insertSqlBatch, insertParams);
List batchIds = batchInsert(rs, insertCount);*/
List batchIds = batchInsert(insertCount, connection, insertSql, insertParams);
String updateSql = (String) sqlConfig.get("ss.benchmark.rangerouting.encrypt.update.sql");
List updateParams = convertParams((List) sqlConfig.get("ss.benchmark.rangerouting.encrypt.update.values"));
updateParams = appendIds(batchIds, updateParams);
JDBCDataSourceUtil.update(connection, updateSql, updateParams);
String deleteSql = (String) sqlConfig.get("ss.benchmark.rangerouting.encrypt.delete.sql");
List deleteParams = convertParams((List) sqlConfig.get("ss.benchmark.rangerouting.encrypt.delete.values"));
deleteParams = appendIds(batchIds, deleteParams);
JDBCDataSourceUtil.delete(connection, deleteSql, deleteParams);
results.setSuccessful(true);
} catch (SQLException e) {
results.setSuccessful(false);
e.printStackTrace();
} catch (Exception e) {
results.setSuccessful(false);
e.printStackTrace();
} finally {
try {
if (rs != null && !rs.isClosed()) {
rs.close();
}
connection.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
results.sampleEnd();
}
return results;
}