TKIConnect.java

import java.sql.*;

public class TKIConnect {

    public static void main(String[] args) {
        // TODO Auto-generated method stub
        String url = "jdbc:mysql://localhost:3306/";

        String user = "root";
        String password = "hansen59";

        try{
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            Connection con = DriverManager.getConnection(url, user, password);

            Statement stt = con.createStatement();

            stt.execute("CREATE DATABASE IF NOT EXISTS tki");
            stt.execute("USE tki");

            //stt.execute("DROP TABLE IF EXISTS TKI_PDF");
            //stt.execute("CREATE TABLE  TKI_PDF (ID INT( 100 ) NOT NULL AUTO_INCREMENT , Index INT( 100 ) , Data VARCHAR( 500 ) , PRIMARY KEY (  ID ))");

            //Generate auto ID
            int data = 0;
            ResultSet que = stt.executeQuery("SELECT COUNT(ID) FROM TKI_PDF");
            while(que.next()){
            data = que.getInt(1);
            }
            stt.execute("INSERT INTO tki_pdf (`ID`, `index`, `data`) VALUES ('" + data + "', '7', 'Hansen Dusenov');");
            ResultSet res = stt.executeQuery("SELECT * FROM TKI_PDF");

        while(res.next()){
            System.out.println(res.getString(2) + " " + res.getString(3));
        }
        System.out.println("");
        }
        catch (Exception e){
            e.printStackTrace();
        }
    }

}