Guest User

Untitled

a guest
Dec 12th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. /******************ПОДКЛЮЧАЕМСЯ К БАЗЕ ДАННЫХ*********************/
  2. //JDBC URL, username and password of MySQL server
  3.  
  4. private static final String url = "jdbc:mysql:";
  5.  
  6. private static final String user = "";
  7.  
  8. private static final String password = "";
  9.  
  10. /**************************КОНЕЦ***************************/
  11.  
  12. // --------ДОБАВЛЕНИЕ ДАННЫХ--------
  13. try{
  14.  
  15. String query = " INSERT INTO coordinates_centre (id, la, lon"// добавляем данные в таблицу coordinates_centre
  16. +", ti, sp)n"
  17. + "VALUES('"+id+"', '"+la+"', '"+lo+"', '"+ti+"', '"+sp+"');";
  18.  
  19. // opening database connection to MySQL server
  20. con = DriverManager.getConnection(url, user, password);
  21.  
  22. // getting Statement object to execute query
  23. stmt = con.createStatement();
  24.  
  25. // executing SELECT query
  26. rs = stmt.executeUpdate(query);
  27.  
  28.  
  29. } catch (SQLException sqlEx) {
  30. sqlEx.printStackTrace();
  31. } finally {
  32. //close connection ,stmt and resultset here
  33. try { con.close(); } catch(SQLException se) { /*can't do anything */ }
  34. try { stmt.close(); } catch(SQLException se) { /*can't do anything */ }
  35. }
  36. // --------КОНЕЦ--------
  37.  
  38. CLASSPATH=/home/chubatiy/my/<ИМЯ>.jar:/home/chubatiy/my/libs/ java org.me.Start
Add Comment
Please, Sign In to add comment