in shardingsphere-benchmark/src/main/java/org/apache/shardingsphere/benchmark/jmeter/fullrouting/sharding/JMeterShardingJDBCFullRoutingShardingInsertUpdateDelete.java [32:69]
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 updateSql = (String) sqlConfig.get("ss.benchmark.fullrouting.sharding.update.sql");
List updateParams = convertParams((List) sqlConfig.get("ss.benchmark.fullrouting.sharding.update.values"));
JDBCDataSourceUtil.update(connection, updateSql, updateParams);
/*String deleteSql = (String)sqlConfig.get("ss.benchmark.fullrouting.sharding.delete.sql");
List deleteParams = convertParams((List)sqlConfig.get("ss.benchmark.fullrouting.sharding.delete.values"));
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;
}