>code>package com.example; import java.sql.*; import com.google.gson.JsonArray; import com.google.gson.JsonObject; import com.google.gson.JsonPrimitive; public class DbMapper { public static JsonArray select(String sql) throws Exception{ Connection dbConnection = CommonConstant.getDbConn(); Statement getFromDb = dbConnection.createStatement(); ResultSet rs = getFromDb.executeQuery(sql); ResultSetMetaData rsmd = rs.getMetaData(); JsonArray recordsArray = new JsonArray(); int numColumns = rsmd.getColumnCount(); String[] arrColumnNames = new String[numColumns]; int[] columnTypes = new int[numColumns]; for (int i = 0; i < arrColumnNames.length; i++) { arrColumnNames[i] = rsmd.getColumnLabel(i + 1); columnTypes[i] = rsmd.getColumnType(i + 1); /*System.out.print(i + " : "); System.out.print(columnNames[i]); System.out.print(i + " = "); System.out.print(columnTypes[i...