java / lab7 (1) / lab7 / src / App

import java.sql.*;
/**
 * Created by Anton on 14.06.2016.
 */
public class App {
        static final String DB_URL = "jdbc:mysql://localhost/information_schema?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC";

        static final String USER = "root";
        static final String PASS = "";

        public static void main(String[] args) {
            Connection conn = null;
            Statement stmt = null;
            try{
                Class.forName("com.mysql.cj.jdbc.Driver");

                System.out.println("Connecting to database...");
                conn = DriverManager.getConnection(DB_URL,USER,PASS);

                System.out.println("Creating statement...");
                stmt = conn.createStatement();
                String sql;
                sql = "SELECT * FROM COLUMNS";
                ResultSet rs = stmt.executeQuery(sql);

                while(rs.next()){
                    int ORDINAL_POSITION  = rs.getInt("ORDINAL_POSITION");
                    String TABLE_NAME = rs.getString("TABLE_NAME");

                    System.out.print("ORDINAL_POSITION: " + ORDINAL_POSITION);
                    System.out.println(", TABLE_NAME: " + TABLE_NAME);
                }
                rs.close();
                stmt.close();
                conn.close();
            }catch(SQLException se){
                    se.printStackTrace();
            }catch(Exception e){
                    e.printStackTrace();
            }finally{
                try{
                    if(stmt!=null)
                        stmt.close();
                }catch(SQLException se2){
                }
                try{
                    if(conn!=null)
                        conn.close();
                }catch(SQLException se){
                    se.printStackTrace();
                }
            }
            System.out.println("Goodbye!");
        }
    }