7

package ques7;

import java.util.*;
import java.sql.*;
public class Customer
{

	 static Connection con=null;
		static Statement st=null;
		static ResultSet rs=null;
		public static void display(int i)
		{
			try
			{
			if(i==1)
			{
				RegularCustomer.show();
			}
			if(i==2)
			{
				CorporateCustomer.show();
			}

			}catch(Exception e)
			{
				System.out.println(e);
			}
		}
		public static void main(String args[])
		 {
			Scanner sc = new Scanner(System.in);
			int i,id,ch;
			String name,address;
			try
			 {
			 Class.forName("oracle.jdbc.driver.OracleDriver");
				con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
				st=con.createStatement();
				System.out.println("if you are going to run this class for first time then press 1 for creating table else press 2");
				ch=sc.nextInt();
				if(ch==1)
				{
			    st.execute("create table RegularCustomer(id number primary key,name varchar2(20),address varchar2(20))");
				st.execute("create table CorporateCustomer(id number primary key,name varchar2(20),address varchar2(20))");
			    ch=2;
				}
				if(ch==2)
				{
				while(true)
				{
				System.out.println("enter 1 for insertion in regular employee and 2 for corporate employee and 3 for display");
				i=sc.nextInt();
				if(i==1)
				{
					System.out.println("enter id");
					id=sc.nextInt();
					System.out.println("Enter name");
					name=sc.next();
					System.out.println("Enter address");
					address=sc.next();
					RegularCustomer r=new RegularCustomer(id,name,address);
					r.DB();
				}
				if(i==2)
				{
					System.out.println("enter id");
					id=sc.nextInt();
					System.out.println("Enter name");
					name=sc.next();
					System.out.println("Enter address");
					address=sc.next();
					CorporateCustomer c=new CorporateCustomer(id,name,address);
					c.DB();
				}
				if(i==3)
				{
					System.out.println("enter 1 for regular employee and 2 for corporate employee");
					i=sc.nextInt();
					display(i);
				}
				System.out.println("enter 1 for more insert 2 for display 3 for quit");
				ch=sc.nextInt();
				if(ch==3)
				{
					con.close();
					break;
				}
				else if(ch==2)
				{
					System.out.println("enter 1 for regular employee and 2 for corporate employee");
					i=sc.nextInt();
					display(i);
				}
				}
				}
			 }catch(Exception e){System.out.println(e);}
		 }
}

-------------------------------------------
package ques7;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class RegularCustomer
{

	 static Connection con=null;
		static Statement st=null;
		static ResultSet rs=null;
		int id;
		String name;
		String address;


 RegularCustomer(int id,String name,String address)
 {
	 this.id=id;
	 this.name=name;
	 this.address=address;
 }
 public void DB()
 {
	 try
	 {
		 Class.forName("oracle.jdbc.driver.OracleDriver");
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
			st=con.createStatement();
			st.execute("insert into RegularCustomer values("+id+",'"+name+"','"+address+"')");
	 }catch(Exception e){System.out.println(e);}
 }
 public static void show()
 {
	 try
	 {

		 Class.forName("oracle.jdbc.driver.OracleDriver");
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
			st=con.createStatement();
	 rs=st.executeQuery("select * from RegularCustomer");
		while(rs.next())
		{
			System.out.println("Id = "+rs.getInt(1)+" name = "+rs.getString(2)+" address = "+rs.getString(3));
		}
	 }catch(Exception e){System.out.println(e);}
 }
}

----------------------------------------
package ques7;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;


public class CorporateCustomer
{

	    static Connection con=null;
		static Statement st=null;
		static ResultSet rs=null;
		int id;
		String name;
		String address;


 CorporateCustomer(int id,String name,String address)
 {
	 this.id=id;
	 this.name=name;
	 this.address=address;
 }
 public void DB()
 {
	 try
	 {
		 Class.forName("oracle.jdbc.driver.OracleDriver");
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
			st=con.createStatement();
			st.execute("insert into RegularCustomer values("+id+",'"+name+"','"+address+"')");
	 }catch(Exception e){System.out.println(e);}
 }
 public static void show()
 {
	 try
	 {
		 Class.forName("oracle.jdbc.driver.OracleDriver");
			con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE","hr","hr");
			st=con.createStatement();
	 rs=st.executeQuery("select * from RegularCustomer");
		while(rs.next())
		{
			System.out.println("Id = "+rs.getInt(1)+" name = "+rs.getString(2)+" address = "+rs.getString(3));
		}
	 }catch(Exception e){System.out.println(e);}
 }
}