ds rmidb client server

//AP1
-------------------------------------

import java.rmi.*;
import java.sql.*;
import java.net.*;
import java.util.ArrayList;
public interface AP1 extends Remote
{
    //public String[] getResult() throws RemoteException;

    public void insert(int rn,String name,int t1,int t2) throws RemoteException;
    public void modify(int roll,int col,String newval) throws RemoteException;
    public void del(int r) throws RemoteException;
    public ArrayList<String> display() throws RemoteException;
}


//AP2
-----------------------------------------


import java.io.*;
import java.rmi.RemoteException;
import java.rmi.server.UnicastRemoteObject;
import java.sql.*;
import java.util.ArrayList;

public class AP2 extends UnicastRemoteObject implements AP1
{
    public AP2() throws RemoteException
    {}

    public static Connection connectionDB()
    {
        try
        {
            Connection conn=null;
            Class.forName("oracle.jdbc.OracleDriver");
            conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1522:apurva","hr","hr");
            return conn;
        }
        catch(Exception E)
        {
            System.out.print("\nEXCEPTION: "+E);
        }
        return null;
    }
    public void insert(int rn,String name,int t1,int t2) throws RemoteException
    {
        try
        {
            Connection conn=connectionDB();
            if(conn!=null)
                System.out.print("\nCONNECTION ESTABLISHED");

            String ins = "INSERT INTO STUD_AP (ROLLNO, NAME, T1, T2) VALUES"
                + "("+rn+",'"+name+"',"+t1+","+t2+")";
            Statement s1=conn.createStatement();
            s1.executeUpdate(ins);
            conn.close();
        }
        catch(Exception E)
        {
            System.out.println("EXCEPTION: "+E);
        }
    }
    public void del(int roll) throws RemoteException
    {
        try
        {
            Connection conn=connectionDB();
            if(conn!=null)
                System.out.print("\nCONNECTION ESTABLISHED");

            BufferedReader br=new BufferedReader(new InputStreamReader(System.in));

            String d = "DELETE FROM STUD_AP WHERE ROLLNO = "+roll;

            Statement s1=conn.createStatement();
            s1.execute(d);
            conn.close();
        }
        catch(Exception E)
        {
            System.out.println("EXCEPTION: "+E);
        }
    }
    public void modify(int roll,int col,String newval) throws RemoteException
    {
        try
        {
            Connection conn=connectionDB();
            if(conn!=null)
                System.out.print("\nCONNECTION ESTABLISHED");

            String stmt;
            switch(col)
            {
                case 1:stmt="NAME = '"+newval+"'";   break;
                case 2:stmt="T1 = '"+newval+"'";   break;
                case 3:stmt="T2 = '"+newval+"'";   break;
                default: stmt="";
            }
            String d = "UPDATE STUD_AP SET "+stmt+" WHERE ROLLNO = "+roll;

            Statement s1=conn.createStatement();
            s1.execute(d);
            conn.close();
        }
        catch(Exception E)
        {
            System.out.println("EXCEPTION: "+E);
        }
    }
    public ArrayList<String> display() throws RemoteException
    {
        ArrayList<String> arr=new ArrayList<String>();
        try
        {
            Connection conn=connectionDB();
            if(conn!=null)
                System.out.print("\nCONNECTION ESTABLISHED");
            Statement s=conn.createStatement();
            s.execute("SELECT * FROM STUD_AP");
            ResultSet rs=s.getResultSet();
            //System.out.print("\n\nSTUD_AP\n");
            int i=0,total=0;
            //System.out.print("\nID  NAME  T1  T2  TOTAL");
            while(rs.next())
            {
                i++;
                int t1=Integer.parseInt(rs.getString("T1"));
                int t2=Integer.parseInt(rs.getString("T2"));
                total=t1+t2;
                String str=rs.getString("ROLLNO")+"  "+rs.getString("NAME")+"  "+t1+"  "+t2+"   "+total;
                arr.add(str);
                //System.out.print("\n"+rs.getString("ROLLNO")+"  "+rs.getString("NAME")+"  "+t1+"  "+t2+"   "+total);
            }
            conn.close();
        }
        catch(Exception E)
        {
            System.out.println("EXCEPTION: "+E);
        }
        return arr;
    }
}


//APClient
----------------------------------------------

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.rmi.Naming;
import java.util.ArrayList;

public class APClient
{
    public static void main(String args[]) throws IOException
    {
        BufferedReader br=new BufferedReader(new InputStreamReader(System.in));
        try
        {
            System.out.print("\n1.INSERT\n2.MODIFY\n3.DELETE\n4.DISPLAY \nENTER YOUR CHOICE: ");
            int ch=Integer.parseInt(br.readLine());

            String s1="rmi://localhost/insert";
            AP1 a=(AP1)Naming.lookup(s1);

            String s2="rmi://localhost/modify";
            AP1 b=(AP1)Naming.lookup(s2);

            String s3="rmi://localhost/del";
            AP1 c=(AP1)Naming.lookup(s3);

            String s4="rmi://localhost/display";
            AP1 d=(AP1)Naming.lookup(s4);

            switch(ch)
            {
                case 1: //INSERT
                        System.out.print("\nINSERT\n");
                        String name;
                        int rn,t1,t2;
                        System.out.print("\nENTER VALUES: ");
                        System.out.print("\nROLL NO.: ");
                        rn=Integer.parseInt(br.readLine());
                        System.out.print("\nNAME: ");
                        name=br.readLine();
                        System.out.print("\nT1: ");
                        t1=Integer.parseInt(br.readLine());
                        System.out.print("\nT2: ");
                        t2=Integer.parseInt(br.readLine());
                        a.insert(rn,name,t1,t2);
                break;

                case 2: //MODIFY
                        System.out.print("\nUPDATE");
                        System.out.print("\nENTER ROLLNO.: ");
                        int roll=Integer.parseInt(br.readLine());
                        System.out.print("\nWHAT DO U WANT TO UPDATE? : 1.NAME 2. T1 3. T2 : ");
                        int col=Integer.parseInt(br.readLine());
                        System.out.print("\nENTER NEW VALUE: ");
                        String newval=br.readLine();
                        b.modify(roll,col,newval);
                break;

                case 3: //DELETE
                        System.out.print("\nDELETE");
                        System.out.print("\nENTER ROLL NO.: ");
                        int c1=Integer.parseInt(br.readLine());
                        c.del(c1);
                break;

                case 4: //DISPLAY
                        System.out.print("\nDISPLAY");
                        ArrayList<String> arr=new ArrayList<String>();
                        arr=d.display();
                        System.out.print("\nID  NAME  T1  T2  TOTAL");
                        for(String s:arr)
                        {
                            System.out.print("\n"+s);
                        }

                break;

                default:System.out.println("\nINVALID CHOICE");
            }
        }
        catch(Exception ex)
        {
            System.out.println("EXCEPTION OCCURED "+ex);
        }
    }
}


//APServer
-------------------------------------------

import java.rmi.Naming;
import java.rmi.RemoteException;

public class APServer
{
    public static void main(String args[]) throws RemoteException
    {
        try
        {
            AP2 a= new AP2();
            Naming.bind("insert", a);
            System.out.println("OBJECT REGISTERED");

            AP2 b= new AP2();
            Naming.bind("modify", b);
            System.out.println("OBJECT REGISTERED");

            AP2 c= new AP2();
            Naming.bind("del", c);
            System.out.println("OBJECT REGISTERED");

            AP2 d= new AP2();
            Naming.bind("display", d);
            System.out.println("OBJECT REGISTERED");
        }
        catch(Exception ex)
        {
            System.out.println("EXCEPTION OCCURED "+ex);
        }
    }
}


Output:
-------------------------------------

server

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Users\intel>cd C:\Program Files\Java\jdk1.8.0_25\bin

C:\Program Files\Java\jdk1.8.0_25\bin>start rmiregistry

C:\Program Files\Java\jdk1.8.0_25\bin>java APServer
OBJECT REGISTERED
OBJECT REGISTERED
OBJECT REGISTERED
OBJECT REGISTERED

CONNECTION ESTABLISHED
CONNECTION ESTABLISHED
CONNECTION ESTABLISHED
CONNECTION ESTABLISHED
CONNECTION ESTABLISHED
CONNECTION ESTABLISHED

---------------------------------------------------------------------------------
client

Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.

C:\Users\intel>cd C:\Program Files\Java\jdk1.8.0_25\bin

C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 4

DISPLAY
ID  NAME  T1  T2  TOTAL
1  A XYZ  15  13   28
2  B XYZ  14  12   26
3  C XYZ  12  15   27
4  D XYZ  12  12   24
5  E XYZ  14  14   28
6  F XYZ  13  15   28
99  APPY  15  15   30
C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 2

UPDATE
ENTER ROLLNO.: 1

WHAT DO U WANT TO UPDATE? : 1.NAME 2. T1 3. T2 : 1

ENTER NEW VALUE: apurva

C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 4

DISPLAY
ID  NAME  T1  T2  TOTAL
1  apurva  15  13   28
2  B XYZ  14  12   26
3  C XYZ  12  15   27
4  D XYZ  12  12   24
5  E XYZ  14  14   28
6  F XYZ  13  15   28
99  APPY  15  15   30
C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 3

DELETE
ENTER ROLL NO.: 99

C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 4

DISPLAY
ID  NAME  T1  T2  TOTAL
1  apurva  15  13   28
2  B XYZ  14  12   26
3  C XYZ  12  15   27
4  D XYZ  12  12   24
5  E XYZ  14  14   28
6  F XYZ  13  15   28
C:\Program Files\Java\jdk1.8.0_25\bin>java APClient

1.INSERT
2.MODIFY
3.DELETE
4.DISPLAY
ENTER YOUR CHOICE: 4

DISPLAY
ID  NAME  T1  T2  TOTAL
1  apurva  15  13   28
2  B XYZ  14  12   26
3  C XYZ  12  15   27
4  D XYZ  12  12   24
5  E XYZ  14  14   28
6  F XYZ  13  15   28
C:\Program Files\Java\jdk1.8.0_25\bin>