
import java.rmi.*;
import java.rmi.server.*;
import java.sql.*;
public class clientImp extends java.rmi.server.UnicastRemoteObject implements company
{
public clientImp() throws java.rmi.RemoteException
{
super();
}
public void add(String name,String pno,String address,String code,String phno) throws java.rmi.RemoteException
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:company","","");
Statement smt=con.createStatement();
String q="insert into one values('"+name+"','"+pno+"','"+address+"','"+code+"','"+phno+"')";
smt.executeUpdate(q);
}//try block
catch(Exception e){}
}
public void del(String pn) throws java.rmi.RemoteException
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:company","","");
Statement smt=con.createStatement();
String q="delete * from one where pno='"+pn+"'";
smt.executeUpdate(q);
}//try block
catch(Exception e){}
}
public String disp(String pn) throws java.rmi.RemoteException
{
String s=new String();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:company","","");
Statement smt=con.createStatement();
String q="select * from one where name='"+pn+"'";
ResultSet rs=smt.executeQuery(q);
if(rs.next())
{
s=s+"NAME:"+rs.getString(1);
s=s+"\nNUM:"+rs.getString(2);
s=s+"\nADDRESS:"+rs.getString(3);
s=s+"\nCODE:"+rs.getString(4);
s=s+"\nPHONE NUMBER:"+rs.getString(5);
}
}//try block
catch(Exception e){}
return s;
}
}
