我有以下方法...
我正在尝试在oracle DB中验证结果。结果并不是我所期望的,但我似乎不知道如何在不做map或list/map的情况下做正确的事情。
public static JSONArray verifyDRFromButton(String transactionId) {
JSONArray jsonArray = new JSONArray();
try {
ResultSet resultSet;
Constants.threadSleep(5000);
Constants.verifyOracle();
String databaseConnectionString = String.format("jdbc:oracle:thin:@%s:%s:%s", "*****", "****", "*****");
Connection conn = DriverManager.getConnection(databaseConnectionString,"*****","*****");
Statement stmt = conn.createStatement();
resultSet = stmt.executeQuery("SELECT * from ****** WHERE ***** = '" + transactionId + "'");
//Print DB Table
Constants.threadSleep(500);
//DBTablePrinter.printResultSet(rs);
//result = rs.toString();
while (resultSet.next()) {
int totalRows = resultSet.getMetaData().getColumnCount();
for (int i = 0; i < totalRows; i++) {
JSONObject obj = new JSONObject();
obj.put(resultSet.getMetaData().getColumnLabel(i + 1)
.toLowerCase(), resultSet.getObject(i + 1));
jsonArray.put(obj);
}
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
return jsonArray;
}
结果是这样的.
[
{"id": "idvalue"},
{"id2": "id2value"},
{"name": "namevalue"},
{"name2": "name2value"}
]
我希望是这样的。
[
{"id": "idvalue", "id2": "id2value"},
{"name": "namevalue", "name2": "name2value"}
]
https://stackoverflow.com/questions/50708283
复制相似问题