Java assignment 2

1.

Ansmport java.sql.*;

import java.util.*;

class RoomCatagory

{

public static void main(String args[]) throws SQLException

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:SQL","sa","password@123");

PreparedStatement stmt=con.prepareStatement("insert into RoomCatagory values(?,?,?,?)");

Scanner sc=new Scanner(System.in);

System.out.println("Enter RoomCatagory ID");

int pid=sc.nextInt();

System.out.println("Enter Name ");

String pn=sc.next():

System.out.println("Enter Description");

int did=sc.nextInt();

System.out.println("Enter Tarrif");

String pad=sc.next():

stmt.setInt(C001, Katrina kaif, Delux, 10% );

stmt.setInt(C002, Amir Khan, Super Delux, 5%);

stmt.setInt(C003, Sharukh Khan, Economic, 2%);

stmt.setInt(C004, Deepika Padukone, Premium, 25%);

stmt.executeUpdate();

con.close();

stmt.close();

}

Catch(Exception e)

{

}

System.out.println("Records Inserted Successfully !!!");

}

class Booking

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:SQL","sa","password@123");

PreparedStatement stmt=con.prepareStatement("insert into Booking values(?,?,?,?,?,?,?,?)");

Scanner sc=new Scanner(System.in);

System.out.println("Enter Booking ID");

int pid=sc.nextInt();

System.out.println("Enter Customer Name");

String pn=sc.next();

System.out.println("Enter Customer Address");

int did=sc.nextInt();

System.out.println("Enter Customer Phone");

String pad=sc.next();

System.out.println("Enter Room ID");

String pg=sc.next();

System.out.println("Enter Booking DateTime");

String pg=sc.next();

System.out.println("Enter Checkin Date");

String pg=sc.next();

System.out.println("Enter Checkout Date");

String pg=sc.next():

stmt.setInt(B001, Sandeep, Malviya nagar, 8800225588, R001, 3th March 2015 10:30AM, 8 March 2015, 15 March 2015 );

stmt.setInt(B002, Mohit, Punjabi Bhag, 8800115588, R002, 4th March 2015 10:00AM, 9 March 2015, 16 March 2015 );

stmt.setInt(B003, Perpendicular, Harsh Vihar, 8800225577, R003, 5th March 2015 09:30AM, 10 March 2015, 17 March 2015 );

stmt.setInt((B004, Tangent, Patel Chowk, 8800227788, R004, 7th March 2015 11:00AM, 12 March 2015, 18 March 2015 );

stmt.setSting();

con.close();

stmt.close();

}

Catch(Exception e)

{

}

System.out.println("Records Inserted Successfully !!!");

}

}

class Room

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con=DriverManager.getConnection("jdbc:odbc:SQL","sa","password@123");

PreparedStatement stmt=con.prepareStatement("insert into Room values(?,?)");

Scanner sc=new Scanner(System.in);

System.out.println("Enter Room ID");

int pid=sc.nextInt();

System.out.println("Enter RoomCatagory ID");

String pn=sc.next();

System.out.println("Enter Status ID");

String pn=sc.next();

stmt.setInt(R001, C001, Available);

stmt.setInt(R002, C002, Not Available);

stmt.setInt(R003, C003, Available);

stmt.setInt(R004, C004, Available);

stmt.setSting();

con.close();

stmt.close();

}

Catch(Exception e)

{

}

System.out.println("Records Inserted Successfully !!!");

}

}

}