Core java assignment sem 4

You need to analyze the object and information structure in the given scenario and perform the following tasks:
-> Identify the primary classes and their relationships. The primary classes should model the rooms and room bookings.
-> Create the primary classes with their required fields and methods.


import java.util.*;
class Roomctagory
{
int RoomCatagoryId;
varchar Name;
varchar Description;
float Tarrif;
}


class Booking
{
int BookingId;
varchar CustomerName;
varchar CustomerAddress;
varchar CustomerPhone;
Int RoomId;
Timestamp BookingDateTime;
Timestamp CheckinDate;
Timestamp CheckoutDate;
}
class Room
{
int RoomId;
int RoomCatagoryId;
char Status;
}



class MyClass
{
public static void main(String[] args)
{
System.out.println("RoomCatagory, Booking and Room are the three classes.");
}
}

Core java Ans 3 Assignment

import java.sql.*;

import java.util.*;

class JoinTable

{

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");

Statement stmt=con.createStatement();

ResultSet rs=stmt.executeQuery("select Booking_id , Customer_Name, RoomCatagory_id,Room_id, Checkin_Date, Checkout_Date, Tariff");

while (rs.next())

{

System.outlprintln("\n"+rs.getInt(1)+"\t"+rs.getInt(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+

"\t"+rs.getString(5)+"\t"+rs.getString(6)+"\t"+rs.getString(7)+"\t"+rs.getInt(8)+);

}

con.close();

stmt.close();

}

catch(Exception e)

{

}

System.out.println("Records retreived successfully....");

}

}

Core java Ans 2 Assignment

import 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 !!!");

}

}

}