Advertisement
Guest User

program1v2

a guest
Nov 21st, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.92 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class program1
  4. {
  5.     public static void main(String args[])
  6.     {
  7.         try
  8.         {
  9.             Class.forName("com.mysql.jdbc.Driver");
  10.             String url = "jdbc:mysql://" + args[0] + ":3306/";
  11.             Connection connect = DriverManager.getConnection(url, args[2], args[3]);
  12.            
  13.             Statement s = connect.createStatement();
  14.             PreparedStatement pStatement = connect.prepareStatement("DROP DATABASE IF EXISTS TTU");
  15.             pStatement.execute();
  16.             PreparedStatement pStatement = connect.prepareStatement("CREATE DATABASE TTU");
  17.             pStatement.execute();
  18.             PreparedStatement pStatement = connect.prepareStatement("USE TTU");
  19.             pStatement.execute();
  20.            
  21.             PreparedStatement pStatement = connect.prepareStatement("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");
  22.             pStatement.execute();
  23.             PreparedStatement pStatement = connect.prepareStatement("insert into students(TNumber, FirstName, LastName, DateOfBirth) values('00001234','Joe','Smith','19500812')");
  24.             pStatement.execute();
  25.            
  26.             ResultSet r = s.executeQuery("select * from students");
  27.             while (r.next())
  28.             {
  29.                 String tnum = r.getString("students.TNumber");
  30.                 String fname = r.getString("students.FirstName");
  31.                 String lname = r.getString("students.LastName");
  32.                 String dob = r.getString("students.DateOfBirth");
  33.                
  34.                 System.out.format("%8s %-20s %-20s %8s %n", tnum, fname, lname, dob);
  35.             }
  36.            
  37.             connect.close();
  38.         }
  39.         catch (Exception e)
  40.         {
  41.             System.out.println(e.getMessage());
  42.         }
  43.     }
  44. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement