Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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();
- PreparedStatement pStatement = connect.prepareStatement("DROP DATABASE IF EXISTS TTU");
- pStatement.execute();
- PreparedStatement pStatement = connect.prepareStatement("CREATE DATABASE TTU");
- pStatement.execute();
- PreparedStatement pStatement = connect.prepareStatement("USE TTU");
- pStatement.execute();
- 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");
- pStatement.execute();
- PreparedStatement pStatement = connect.prepareStatement("insert into students(TNumber, FirstName, LastName, DateOfBirth) values('00001234','Joe','Smith','19500812')");
- pStatement.execute();
- 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());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement