Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package myapp;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSetMetaData;
- /**
- * @author Администратор
- *
- */
- public class Sites {
- // private static String dbURL =
- // "jdbc:derby://localhost:1527/MyDB;create=true;user=me;password=mine";
- // private static String dbURL =
- // "jdbc:derby://localhost:1527/C:/test/MyDB;create=true;user=mydb1;password=data";
- //it works
- //private static String dbURL =
- // "jdbc:derby:C:/test/MyDB;create=true;user=mydb1;password=data";
- //private static String dbURL = "jdbc:derby://localhost/webdb;create=true";
- private static String dbURL = "jdbc:derby:sampleDB;create=true";
- static String driver = "org.apache.derby.jdbc.EmbeddedDriver";
- private static String tableName = "Sites2";
- // jdbc Connection
- private static Connection conn = null;
- private static Statement stmt = null;
- public static void main(String[] args) {
- createConnection();
- createRestaurants();
- String idSiteUnique = "http://www.mnau.edu.ua/";
- String innerSite = "http://www.mnau.edu.ua/en/index.html";
- String externalSite = "https://plus.google.com/110005007396008363941";
- insertRestaurants(idSiteUnique, innerSite, externalSite);
- selectRestaurants();
- shutdown();
- }
- private static void createConnection() {
- try {
- //Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
- Class.forName(driver);
- // Get a connection
- conn = DriverManager.getConnection(dbURL);
- } catch (Exception except) {
- except.printStackTrace();
- }
- }
- private static void createRestaurants() {
- try {
- stmt = conn.createStatement();
- // stmt.execute("create table RESTAURANTS(id integer, name varchar(20), city varchar(50))");
- //site:
- stmt.execute("create table " + tableName + "(page varchar(2083), inner varchar(2083), external varchar(2083))");
- stmt.close();
- } catch (SQLException sqlExcept) {
- sqlExcept.printStackTrace();
- }
- }
- //private static void insertRestaurants(int id, String restName,
- private static void insertRestaurants(String page, String inner,
- String external) {
- try {
- stmt = conn.createStatement();
- stmt.execute("insert into " + tableName + " values (" + page + ",'"
- + inner + "','" + external + "')");
- stmt.close();
- } catch (SQLException sqlExcept) {
- sqlExcept.printStackTrace();
- }
- }
- private static void selectRestaurants() {
- try {
- stmt = conn.createStatement();
- ResultSet results = stmt.executeQuery("select * from " + tableName);
- ResultSetMetaData rsmd = results.getMetaData();
- int numberCols = rsmd.getColumnCount();
- for (int i = 1; i <= numberCols; i++) {
- // print Column Names
- System.out.print(rsmd.getColumnLabel(i) + "\t\t");
- }
- System.out
- .println("\n-------------------------------------------------");
- while (results.next()) {
- //int id = results.getInt(1);
- String page = results.getString(1);
- String inner = results.getString(2);
- String external = results.getString(3);
- System.out.println(page + "\t\t" + inner + "\t\t" + external);
- }
- results.close();
- stmt.close();
- } catch (SQLException sqlExcept) {
- sqlExcept.printStackTrace();
- }
- }
- private static void shutdown() {
- try {
- if (stmt != null) {
- stmt.close();
- }
- if (conn != null) {
- DriverManager.getConnection(dbURL + ";shutdown=true");
- conn.close();
- }
- } catch (SQLException sqlExcept) {
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement