Advertisement
Guest User

Untitled

a guest
Apr 7th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. try
  2. {
  3. out.println("into try block...");
  4. Class.forName(driver);
  5. out.println("found the driver....");
  6. conn=DriverManager.getConnection("jdbc:postgresql:postgres",
  7. "postgres",
  8. "12345");
  9. out.println("connection");
  10.  
  11. sql=conn.createStatement();
  12. out.println("statement created");
  13. String insert = "insert into spatial_ref_sys(point, coordinates) values(type, "+ ")";
  14. out.println("not a problem...");
  15. //System.out.println(fst);
  16. }
  17. catch(SQLException | ClassNotFoundException e)
  18. {
  19. e.printStackTrace();
  20. System.out.println(e.getClass().getName()+" "+e.getMessage());
  21. }
  22. try
  23. { Class.forName("org.postgresql.Driver");
  24. conn=DriverManager.getConnection(url,username, password);
  25. sql=conn.createStatement();
  26. //result1 = "insert into test(feature) values(ST_GeomFromText("+data+"))";
  27. //result1 = "insert into test(feature,lat,lan) values(ST_GeomFromText('"+feature+"),"+lat+","+lan+"')";
  28. //result1 = "insert into test(feature) values(ST_GeomFromText('POINT("+lat+" "+lan+")', 4326))";
  29. result1 = "insert into test(feature) values(ST_GeomFromText('"+feature+"("+lat+" "+lan+")'))";
  30. sql.executeUpdate(result1);
  31. out.println("data inserted...");
  32.  
  33. String nextJSP = "/index.jsp";
  34. RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(nextJSP);
  35. dispatcher.forward(request,response);
  36.  
  37. out.println("forwarding...");
  38. //System.out.println(fst);
  39. }
  40. catch(SQLException | ClassNotFoundException e)
  41. {
  42. e.printStackTrace();
  43. }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement