Advertisement
Guest User

getdata (DBEngine)

a guest
Apr 24th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.05 KB | None | 0 0
  1.         public Map<String,String> getdata(String id) {
  2.         Map<String,String> dataMap = new HashMap<>();
  3.  
  4.         Statement stmt = null;
  5.         try
  6.         {
  7.             Connection conn = ds.getConnection();
  8.             String queryString = null;
  9.  
  10.             queryString = "SELECT * FROM data WHERE id='" + id + "'";
  11.  
  12.             stmt = conn.createStatement();
  13.  
  14.             ResultSet rs = stmt.executeQuery(queryString);
  15.  
  16.             while (rs.next()) {
  17.                 String patient_id = rs.getString("patient_id");
  18.                 String service_id = rs.getString("service_id");
  19.                 dataMap.put("id", id);
  20.                 dataMap.put("ts", ts);
  21.                 dataMap.put("patient_id", patient_id);
  22.                 dataMap.put("service_id", service_id);
  23.                 dataMap.put("some_data", some_data);
  24.             }
  25.  
  26.             rs.close();
  27.             stmt.close();
  28.             conn.close();
  29.  
  30.         }
  31.         catch(Exception ex)
  32.         {
  33.             ex.printStackTrace();
  34.         }
  35.  
  36.         return dataMap;
  37.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement