import java.sql.*;

public class program1
{
    public static void main(String args[])
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://" + args[0] + ":3306/";
            Connection connect = DriverManager.getConnection(url, args[2], args[3]);

            Statement s = connect.createStatement();
            s.executeQuery("DROP DATABASE IF EXISTS TTU");
            s.executeQuery("CREATE DATABASE TTU");
            s.executeQuery("USE TTU");
            s.executeQuery("create table students(TNumber char(8) not null primary key, FirstName varchar(20) not null, LastName varchar(20) not null, DateOfBirth date, index(LastName)) ENGINE=INNODB");
            s.executeQuery("insert into students(TNumber, FirstName, LastName, DateOfBirth) values('00001234','Joe','Smith','19500812')");

            ResultSet r = s.executeQuery("select * from students");
            while (r.next())
            {
                String tnum = r.getString("students.TNumber");
                String fname = r.getString("students.FirstName");
                String lname = r.getString("students.LastName");
                String dob = r.getString("students.DateOfBirth");

                System.out.format("%8s %-20s %-20s %8s %n", tnum, fname, lname, dob);
            }

            connect.close();
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
        }
    }
}