Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. String json = "{"DATA":{"CAR_NO":123123},"USER_ID":300,"USER_NAME":"user1"}";
  2. ResultSet resultSet = null;
  3. long begin = System.currentTimeMillis();
  4.  
  5. for (int j = 0; j < 1000; j++) {
  6. Statement statement = connection.createStatement();
  7.  
  8. rootSchema.add("testDB", new JsonSchema("testTAB", json));
  9.  
  10. resultSet = statement.executeQuery(
  11. "select * from "testDB"."testTAB" where USER_ID =300 order by USER_ID desc ");
  12.  
  13. while (resultSet.next()) {
  14. JSONObject jo = new JSONObject();
  15. int n = resultSet.getMetaData().getColumnCount();
  16. for (int i = 1; i <= n; i++) {
  17. jo.put(resultSet.getMetaData().getColumnName(i), resultSet.getObject(i));
  18. }
  19. }
  20.  
  21. resultSet.close();
  22. statement.close();
  23. connection.close();
  24. }
  25.  
  26. System.out.println("Time elapsed:" + (System.currentTimeMillis() - begin));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement