Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @POST
- @Produces(MediaType.APPLICATION_JSON)
- @Consumes(MediaType.APPLICATION_JSON)
- public String postJson(String podaci) {
- JsonReader reader = Json.createReader(new StringReader(podaci));
- javax.json.JsonObject jsonPodaci = reader.readObject();
- JsonObject jsonObject = new JsonObject();
- if (!jsonPodaci.containsKey("icao")) {
- jsonObject.addProperty("odgovor", "Nije poslan icao parametar");
- jsonObject.addProperty("status", "ERR");
- return jsonObject.toString();
- }
- String icao = jsonPodaci.getString("icao");
- try {
- BP_Konfiguracija bp_konf = (BP_Konfiguracija) sc.getAttribute("BP_Konfig");
- Class.forName(bp_konf.getDriverDatabase());
- String query = "SELECT * FROM AIRPORTS WHERE IDENT = '" + icao + "'";
- try (Connection c = DriverManager.getConnection(bp_konf.getServerDatabase() + bp_konf.getUserDatabase(), bp_konf.getUserUsername(), bp_konf.getUserPassword());) {
- Statement s = c.createStatement();
- ResultSet rs = s.executeQuery(query);
- rs.next();
- query = "INSERT INTO MYAIRPORTS (IDENT, NAME, ISO_COUNTRY, COORDINATES, STORED) VALUES ('" + rs.getString("IDENT") + "', '" + rs.getString("NAME") + "', '" + rs.getString("ISO_COUNTRY") + "', '" + rs.getString("COORDINATES") + "', CURRENT_TIMESTAMP)";
- s = c.createStatement();
- s.execute(query);
- jsonObject.addProperty("odgovor", "Aerodrom uspješno dodan");
- jsonObject.addProperty("status", "OK");
- } catch (SQLException ex) {
- jsonObject.addProperty("poruka", "Aerodrom je već dodan ili ne postoji");
- jsonObject.addProperty("status", "ERR");
- }
- } catch (ClassNotFoundException ex) {
- jsonObject.addProperty("poruka", "Greška kod spajanja na bazu");
- jsonObject.addProperty("status", "ERR");
- }
- return jsonObject.toString();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement