Displaying differences for changeset |
@@ -21,6 +21,7 @@ |
import oms3.annotations.Name; |
import org.codehaus.jettison.json.JSONArray; |
import org.codehaus.jettison.json.JSONException; |
+import rhem.utils.DBQueries; |
import rhem.utils.DBResources; |
import static rhem.utils.DBResources.MSSQL_RHEM; |
@@ -48,11 +49,11 @@ |
try (Connection conn = getResourceJDBC(MSSQL_RHEM); |
Statement statement = conn.createStatement();) { |
- String query = "SELECT choice_id, choice_label " |
- + "FROM rhem.d_rhem_slope_shape " |
- + "WHERE obsolete = 'false';"; |
+// String query = "SELECT choice_id, choice_label " |
+// + "FROM rhem.d_rhem_slope_shape " |
+// + "WHERE obsolete = 'false';"; |
- try (ResultSet resultSet = statement.executeQuery(query)) { |
+ try (ResultSet resultSet = statement.executeQuery(DBQueries.RHEM05Query01())) { |
while (resultSet.next()) { |
int id = resultSet.getInt("choice_id"); |
String kind = "slope shape"; |