Advertisement
Kvarz

Database Derby saving URL

Sep 8th, 2014
239
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 3.55 KB | None | 0 0
  1. package myapp;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8. import java.sql.ResultSetMetaData;
  9.  
  10. /**
  11.  * @author Администратор
  12.  *
  13.  */
  14. public class Sites {
  15.     // private static String dbURL =
  16.     // "jdbc:derby://localhost:1527/MyDB;create=true;user=me;password=mine";
  17.     // private static String dbURL =
  18.     // "jdbc:derby://localhost:1527/C:/test/MyDB;create=true;user=mydb1;password=data";
  19.    
  20.     //it works
  21.      //private static String dbURL =
  22.      // "jdbc:derby:C:/test/MyDB;create=true;user=mydb1;password=data";
  23.    
  24.     //private static String dbURL = "jdbc:derby://localhost/webdb;create=true";
  25.    
  26.     private static String dbURL = "jdbc:derby:sampleDB;create=true";
  27.     static String driver = "org.apache.derby.jdbc.EmbeddedDriver";
  28.    
  29.     private static String tableName = "Sites2";
  30.     // jdbc Connection
  31.     private static Connection conn = null;
  32.     private static Statement stmt = null;
  33.  
  34.     public static void main(String[] args) {
  35.         createConnection();
  36.         createRestaurants();
  37.        
  38.         String idSiteUnique = "http://www.mnau.edu.ua/";
  39.         String innerSite = "http://www.mnau.edu.ua/en/index.html";
  40.         String externalSite = "https://plus.google.com/110005007396008363941";
  41.        
  42.          insertRestaurants(idSiteUnique, innerSite, externalSite);
  43.         selectRestaurants();
  44.         shutdown();
  45.     }
  46.  
  47.     private static void createConnection() {
  48.         try {
  49.             //Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
  50.             Class.forName(driver);
  51.             // Get a connection
  52.             conn = DriverManager.getConnection(dbURL);
  53.         } catch (Exception except) {
  54.             except.printStackTrace();
  55.         }
  56.     }
  57.    
  58.     private static void createRestaurants() {
  59.         try {
  60.             stmt = conn.createStatement();
  61.         //  stmt.execute("create table RESTAURANTS(id integer, name varchar(20), city varchar(50))");
  62.             //site:
  63.             stmt.execute("create table " + tableName + "(page varchar(2083), inner varchar(2083), external varchar(2083))");
  64.             stmt.close();
  65.         } catch (SQLException sqlExcept) {
  66.             sqlExcept.printStackTrace();
  67.         }
  68.     }
  69.  
  70.     //private static void insertRestaurants(int id, String restName,
  71.     private static void insertRestaurants(String page, String inner,
  72.             String external) {
  73.         try {
  74.             stmt = conn.createStatement();
  75.             stmt.execute("insert into " + tableName + " values (" + page + ",'"
  76.                     + inner + "','" + external + "')");
  77.             stmt.close();
  78.         } catch (SQLException sqlExcept) {
  79.             sqlExcept.printStackTrace();
  80.         }
  81.     }
  82.  
  83.     private static void selectRestaurants() {
  84.         try {
  85.             stmt = conn.createStatement();
  86.             ResultSet results = stmt.executeQuery("select * from " + tableName);
  87.             ResultSetMetaData rsmd = results.getMetaData();
  88.             int numberCols = rsmd.getColumnCount();
  89.             for (int i = 1; i <= numberCols; i++) {
  90.                 // print Column Names
  91.                 System.out.print(rsmd.getColumnLabel(i) + "\t\t");
  92.             }
  93.  
  94.             System.out
  95.                     .println("\n-------------------------------------------------");
  96.  
  97.             while (results.next()) {
  98.                 //int id = results.getInt(1);
  99.                 String page = results.getString(1);
  100.                 String inner = results.getString(2);
  101.                 String external = results.getString(3);
  102.                 System.out.println(page + "\t\t" + inner + "\t\t" + external);
  103.             }
  104.             results.close();
  105.             stmt.close();
  106.         } catch (SQLException sqlExcept) {
  107.             sqlExcept.printStackTrace();
  108.         }
  109.     }
  110.  
  111.     private static void shutdown() {
  112.         try {
  113.             if (stmt != null) {
  114.                 stmt.close();
  115.             }
  116.             if (conn != null) {
  117.                 DriverManager.getConnection(dbURL + ";shutdown=true");
  118.                 conn.close();
  119.             }
  120.         } catch (SQLException sqlExcept) {
  121.  
  122.         }
  123.  
  124.     }
  125. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement