Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package Restaurants;
- import java.sql.*;
- public class Restaurant {
- private static String dbUrl = "jdbc:derby://localhost:1527/myDB;user=admin;password=123";
- private static Connection conn = null;
- private static Statement stmt = null;
- public static void main(String[] args) {
- createConnections();
- insertRestaurants(4, "LaLALA", "London");
- selectRestaurants();
- //shutdown();
- }
- private static void createConnections() {
- try {
- Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
- conn = DriverManager.getConnection(dbUrl);
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
- private static void insertRestaurants(int id, String name, String city) {
- try {
- stmt = conn.createStatement();
- stmt.execute("insert into restaurants values(" + id + ",'" + name + "','" + city + "')");
- stmt.close();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- }
- private static void selectRestaurants() {
- try {
- stmt = conn.createStatement();
- ResultSet results = stmt.executeQuery("select * from restaurants");
- ResultSetMetaData rsmd = results.getMetaData();
- int numberCols = rsmd.getColumnCount();
- System.out.println("NUM COLUMNS: " + rsmd.getColumnCount() + " TYPE " + rsmd.getColumnTypeName(1) + " TYPE " + rsmd.getColumnTypeName(2) + " TYPE " + rsmd.getColumnTypeName(3));
- 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 restName = results.getString(2);
- String cityName = results.getString(3);
- System.out.println(id + "\t\t" + restName + "\t\t" + cityName);
- }
- 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) {
- sqlExcept.printStackTrace();
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement