String sql = "select code, id where code in (?);";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1, account_code);
ResultSet resultSet = preparedStatement.executeQuery();
ResultSetMetaData resultSetMetaData = resultSet.getMetaData();
int columnsNumber = resultSetMetaData.getColumnCount();
while (resultSet.next()) {
for (int i = 1; i <= columnsNumber; i++) {
if (i > 1) System.out.print(", ");
String columnName = resultSetMetaData.getColumnName(i);
String columnValue = resultSet.getString(i);
System.out.print(columnName + " " + columnValue);
}
System.out.println("");
}