Advertisement
Guest User

Untitled

a guest
Dec 1st, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.64 KB | None | 0 0
  1. package Restaurants;
  2.  
  3. import java.sql.*;
  4.  
  5. public class Restaurant {
  6. private static String dbUrl = "jdbc:derby://localhost:1527/myDB;user=admin;password=123";
  7. private static Connection conn = null;
  8. private static Statement stmt = null;
  9.  
  10. public static void main(String[] args) {
  11. createConnections();
  12. insertRestaurants(4, "LaLALA", "London");
  13. selectRestaurants();
  14. //shutdown();
  15. }
  16.  
  17. private static void createConnections() {
  18. try {
  19. Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
  20. conn = DriverManager.getConnection(dbUrl);
  21. } catch (Exception e) {
  22. e.printStackTrace();
  23. }
  24. }
  25.  
  26. private static void insertRestaurants(int id, String name, String city) {
  27. try {
  28. stmt = conn.createStatement();
  29. stmt.execute("insert into restaurants values(" + id + ",'" + name + "','" + city + "')");
  30. stmt.close();
  31. } catch (SQLException e) {
  32. e.printStackTrace();
  33. }
  34. }
  35.  
  36. private static void selectRestaurants() {
  37. try {
  38. stmt = conn.createStatement();
  39. ResultSet results = stmt.executeQuery("select * from restaurants");
  40. ResultSetMetaData rsmd = results.getMetaData();
  41. int numberCols = rsmd.getColumnCount();
  42. System.out.println("NUM COLUMNS: " + rsmd.getColumnCount() + " TYPE " + rsmd.getColumnTypeName(1) + " TYPE " + rsmd.getColumnTypeName(2) + " TYPE " + rsmd.getColumnTypeName(3));
  43. for (int i=1; i<=numberCols; i++) {
  44. //print Column Names
  45. System.out.print(rsmd.getColumnLabel(i)+"\t\t");
  46. }
  47.  
  48. System.out.println("\n-------------------------------------------------");
  49.  
  50. while(results.next()) {
  51. int id = results.getInt(1);
  52. String restName = results.getString(2);
  53. String cityName = results.getString(3);
  54. System.out.println(id + "\t\t" + restName + "\t\t" + cityName);
  55. }
  56.  
  57. results.close();
  58. stmt.close();
  59. }
  60. catch (SQLException sqlExcept)
  61. {
  62. sqlExcept.printStackTrace();
  63. }
  64. }
  65.  
  66. private static void shutdown() {
  67. try {
  68. if (stmt != null) {
  69. stmt.close();
  70. }
  71. if (conn != null) {
  72. DriverManager.getConnection(dbUrl + ";shutdown=true");
  73. conn.close();
  74. }
  75. } catch (SQLException sqlExcept) {
  76. sqlExcept.printStackTrace();
  77. }
  78. }
  79. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement