Question 2

(b) Explain the use of CallableStatement and PreparedStatement with example.

/*
create or replace procedure studentDataPro(enrollNumber number,name varchar2,branch varchar2,sem number,cpi number)
is
begin
insert into studentData values(enrollNumber,name,branch,sem,cpi);
end;

*/

import java.sql.*;
public class CallableStatementPreparedStatement
{
public static void main(String s[]) throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.123:1521:XE","scott","tiger");
CallableStatement cs= con.prepareCall ("{call
studentDataPro (?,?,?,?,?)}");
cs.setDouble(1, 6066);
cs.setString(2, "Jaydip Panchal");
cs.setString(3, "Information Technology");
cs.setInt(4, 7);
cs.setDouble(5, 7.01);
cs.execute();
System.out.println("1 Student Record Inserted!!!");
String query="insert into studentData values (?,?,?,?,?)";
PreparedStatement ps=con.prepareStatement (query); ;
ps.setDouble(1, 6050);
ps.setString(2, "Arpan Patel");
ps.setString(3, "Information Technology");
ps.setInt(4, 7);
ps.setDouble(5, 6.79);
int i=ps.executeUpdate();
System.out.println(i+" Student Record Inserted!!!");
ps.setDouble(1, 6061);
ps.setString(2, "Pratik Patel");
ps.setString(3, "Information Technology");
ps.setInt(4, 7);
ps.setDouble(5, 7.47);
i=ps.executeUpdate();
System.out.println("Query executed for the second time count : "+i);
con.close();
}
}

Question 3

(b) Consider Bank table with attributes AccountNo, CustomerName, Balance, Phone and Address. Write a database application which allows insertion, updation and deletion of records in Bank table. Print values of all customers whose balance is greater than 20,000.

import java.sql.*;
import java.util.*;
import java.io.*;
public class CallableStatementPreparedStatement
{
public static void main(String args[]) throws Exception,IOException
{
int n=0,ch=0;
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.123:1521:XE","scott","tiger");
Scanner input = new Scanner(System.in);
System.out.println("Enter Choice : ");
System.out.println("1. Insert Data");
System.out.println("2. Delete Data");
System.out.println("3. Update Data");
if(input.hasNextInt())
n = input.nextInt();
switch(n)
{
case 1 :
String query="insert into bankTable values (?,?,?,?,?)";
System.out.print("Enter Account Number : ");
if(input.hasNextInt()){
ps.setInt(1,input.nextInt());}
System.out.print("Enter Customer Name : ");
ps.setString(2,input.next());
System.out.print("Enter Balance : ");
ps.setString(3,input.next());
System.out.print("Enter Phone : ");
ps.setString(4,input.next());
System.out.print("Enter Address : ");
ps.setString(5,input.next());
int i=ps.executeUpdate();
System.out.println(i+" Account Record Inserted!!!");
break;
case 2 :
String query="delete * from bankTable where accountNumber = ?";
System.out.print("Enter Account Number : ");
if(input.hasNextInt()){
ps.setInt(1,input.nextInt());}
int i=ps.executeUpdate();
System.out.println(i+" Account Record Inserted!!!");
break;
case 3 :
System.out.println("What u want to update?");
System.out.println("1. Name");
System.out.println("2. Phone");
System.out.println("3. Address");
if(input.hasNextInt())
ch = input.nextInt();
switch(ch)
{
case 1 :
System.out.print("Enter New Name : ");
String str = input.next();
String query="update backTable set customerName = "+cname+" where accountNumber = ?";
System.out.print("Enter Account Number : ");
if(input.hasNextInt()){
ps.setInt(1,input.nextInt());}
int i=ps.executeUpdate();
System.out.println(i+" Account Record Updated!!!");
break;
case 2:
System.out.print("Enter New Phone : ");
String str = input.next();
String query="update backTable set phone = "+cname+" where accountNumber = ?";
System.out.print("Enter Account Number : ");
if(input.hasNextInt()){
ps.setInt(1,input.nextInt());}
int i=ps.executeUpdate();
System.out.println(i+" Account Record Updated!!!");
break;
case 3:
System.out.print("Enter New Address : ");
String str = input.next();
String query="update backTable set address = "+cname+" where accountNumber = ?";
System.out.print("Enter Account Number : ");
if(input.hasNextInt()){
ps.setInt(1,input.nextInt());}
int i=ps.executeUpdate();
System.out.println(i+" Account Record Updated!!!");
break;
default:
System.out.println("Wrong Choice");
break;
}
break;
default :
System.out.println("Wrong Choice");
break;
}
Statement st=con.createStatement();
String query = "select customerName from bankTabl e where balance > 20000";
ResultSet rs = st.executeQuery(query );
if(rs.next())
{
System.out.println("Customer Name : "+rs.getString(1));
}
con.close();
}
}

(a) Write an RMI application where client sends empno and server returns corresponding salary by querying database.

// ReceiveMessageInterface.java

import java.rmi.*;
public interface ReceiveMessageInterface extends Remote
{
void receiveMessage(String x) throws RemoteException;
}

// RmiServer.java

import java.rmi.*;
import java.rmi.registry.*;
import java.rmi.server.*;
import java.net.*;
import java.sql.*;
import java.util.*;
import java.io.*;
public class RmiServer extends java.rmi.server.UnicastRemoteObject implements ReceiveMessageInterface throws Exception,IOException
{
String address;
Registry registry;
public void receiveMessage(String x) throws RemoteException
{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.123:1521:XE","scott","tiger");
Statement st=con.createStatement();
String query = "select salary from employeeTable where empId = "+x;
ResultSet rs = st.executeQuery(query );
if(rs.next())
{
System.out.println("Employee's Salary whose Emp Id = "+x+" is : "+rs.getDouble(1));
}
con.close();
}
public RmiServer() throws RemoteException
{
try
{
address = (InetAddress.getLocalHost()).toString();
}
catch(Exception e)
{
System.out.println("Server can't get INET address.");
}
int port=3232;
System.out.println("Address = " + address + ",Port = " + port);
try
{
registry = LocateRegistry.createRegistry(port);
registry.rebind("rmiServer", this);
}
catch(RemoteException e)
{
System.out.println("Remote Exception"+ e);
}
}
static public void main(String args[])
{
try
{
RmiServer server = new RmiServer();
}
catch (Exception e)
{
e.printStackTrace();
System.exit(1);
}
}
}

// RmiClient.java

import java.rmi.*;
import java.rmi.registry.*;
import java.net.*;
public class RmiClient
{
static public void main(String args[])
{
ReceiveMessageInterface rmiServer;
Registry registry;
String serverAddress=args[0];
String serverPort=args[1];
String empNo=args[2];
System.out.println("Sending " + empNo + " to " + serverAddress + " : " + serverPort);
try
{
registry=LocateRegistry.getRegistry(serverAddress,(new Integer(serverPort)).intValue());
rmiServer=(ReceiveMessageInterface)(registry.lookup("rmiServer"));
rmiServer.receiveMessage(empNo);
}
catch(RemoteException e)
{
e.printStackTrace();
}
catch(NotBoundException e)
{
System.err.println(e);
}
}
}

(b) Write a program to demonstrate use of Internationalization for various language supports.

// InternationalizationLanguageSupport.java

import java.util.*;
import java.io.*;
public class InternationalizationLanguageSupport
{
public static void main(String s[]) throws Exception
{
String country,language;
Locale locale;
ResourceBundle rb;
int n=0;
Scanner input = new Scanner(System.in);
System.out.println("Select Your Language : ");
System.out.println("1. English");
System.out.println("2. France");
System.out.println("3. Spanish");
if(input.hasNextInt())
n = input.nextInt();
switch(n)
{
case 2 :
language = "fr";
country = "FR";
break;
case 3 :
language = "es";
country = "ES";
break;
default:
language = "en";
country = "US";
break;
}
locale = new Locale(language, country);
rb = ResourceBundle.getBundle("InternationalizationLanguageSupports", locale);
System.out.println(rb.getString("localeInfo") + " ( " + locale.getDisplayLanguage() + "," + locale.getDisplayCountry() + ").\n");
System.out.println(rb.getString("welcomeUser"));
System.out.println(rb.getString("exitUser"));
}
}

// InternationalizationLanguageSupports.properties

localeInfo = The text displayed is specific to locale
welcomeUser = Hello, how are you? Welcome To Help2Engg!! Gujarat's First Engineering Social Network!!
exitUser = Thanks to visit Help2Engg.

// InternationalizationLanguageSupports_es_ES.properties

localeInfo = El texto mostrado es específico al lugar
welcomeUser = ¿Hola, ¿cómo estás? Bienvenido a Help2Engg! Ingeniería de Redes Primera Gujarat Social!
exitUser = Gracias por visitar Help2Engg.

// InternationalizationLanguageSupports_fr_FR.properties

localeInfo = Le texte affiché est spécifique à la scène
welcomeUser = Bonjour, comment allez-vous? Bienvenue Help2Engg! Gujarat en technologie des réseaux sociaux d'abord!
exitUser = Merci de visiter Help2Engg.

Question 4

(b) Write a client program to send any string from its standard input to the server program. The server program reads the string, finds number of characters and digits and sends it back to client program. Use connection-oriented or connection-less communication.

// Server.java

import java.io.*;
import java.net.*;
class Server
{
public static void main(String args[]) throws Exception
{
ServerSocket ss = new ServerSocket(888);
Socket s = ss.accept();
System.out.println("Connection established");
PrintStream ps = new PrintStream(s.getOutputStream());
BufferedReader br = new BufferedReader(new InputStreamReader(s.getInputStream()));
BufferedReader kb = new BufferedReader(new InputStreamReader(System.in));
while(true)
{
String str,str1;
while((str = br.readLine()) != null)
{
System.out.println("Counting Characters and Digits from String...");
int countChar = 0,countNumber = 0;
for(int i=0;i<str.length();i++)
{
if( (str.charAt(i) >= 'a' && str.charAt(i) <= 'z') || (str.charAt(i) >= 'a' && str.charAt(i) <= 'z'))
countChar++;
else if(str.charAt(i) >= '0' && str.charAt(i) <= '9')
countNumber++;
}
str1 = "Total Number Of Characters = " + countChar;
str1 += "Total Number Of Digits = " + countNumber;
ps.println(str1);
}
ps.close();
br.close();
kb.close();
ss.close();
s.close();
System.exit(0);
}
}
}

// Client.java

import java.io.*;
import java.net.*;
class Client
{
public static void main(String args[]) throws Exception
{
Socket s = new Socket("localhost", 888);
int stop = 1;
DataOutputStream dos = new DataOutputStream(s.getOutputStream());
BufferedReader br = new BufferedReader(new InputStreamReader(s.getInputStream()));
BufferedReader kb = new BufferedReader(new InputStreamReader(System.in));
String str="",str1="";
do
{
str = kb.readLine();
dos.writeBytes(str+"\n");
str1 = br.readLine();
System.out.println(str1);
}while(stop != 1);
dos.close();
br.close();
kb.close();
s.close();
}
}

(a) Explain Socket, ServerSocket, InetAddress classes. Write a java program to find an IP address of the machine on which the program runs.

import java.util.*;
import java.lang.*;
import java.net.*;
public class getIP
{
public static void main(String args[])
{
try
{
InetAddress IPAddressOfMachine = InetAddress.getLocalHost();
System.out.println("IP of Your system is : " + IPAddressOfMachine.getHostAddress());
}
catch (Exception e)
{
System.out.println("Exception : " + e.getMessage());
}
}
}

Question 5

(a) Explain object serialization in detail with example.

import java.io.*;
class sampleClass implements Serializable
{
String str;
int no;
public sampleClass(String str, int no)
{
this.str = str;
this.no = no;
}
public String toString()
{
return "String is : " + str + "; Number is : " + no;
}
}
public class objectSerialization
{
public static void main(String args[])
{
try
{
sampleClass object = new sampleClass("Help2Engg | GTU Paper Solution", 420);
System.out.println("object of sampleClass : " + object);
FileOutputStream fos = new FileOutputStream("objectSerialixationFile.txt");
ObjectOutputStream oos = new ObjectOutputStream(fos);
oos.writeObject(object);
oos.flush();
oos.close();
}
catch(Exception e)
{
System.out.println("Exception : " + e);
System.exit(0);
}
}
}

Make Comments..!!


Variya Hemal
Thanks you
Like · Comment ·
Advait patel
koini pase advance java , DWDM. DDAS, ni paper solutions hoy to plz mane "rajeshp412@gmail.com" par mail karo plzz
Like · Comment ·
Mohit Wadhwani
Wow Thankyou
Like · Comment ·
Vadhel Krupali and Joydip Panchal like this
Vadhel Krupali
in which branch you study
Like ·
Hiren Bhut
than you sir ,Please upload new paper solution program
Like · Comment ·
Rohit Patel
thank u so much
Like · Comment ·
Joydip Panchal likes this
Pradip Asodariya
thanx
Like · Comment ·
Joydip Panchal likes this
Meera Dave
really thanx.....
Like · Comment ·
Rohit Patel and 4 other like this
Vyas Malhar
hi
Like ·
Rakesh Ranjan
thx........ a lot.
Like · Comment ·
Kinjal Patel
thnkQ.!
Like · Comment ·
Rohit Patel and 4 other like this
Jigisha Parmar
thank u so much
Like · Comment ·
Vadhel Krupali and 8 other like this
Avani Soneji
thankxx.........
Like · Comment ·
Karan Jadav and Joydip Panchal like this
Karan Jadav
Hi. Avani....
Like ·
Student Of It Engineering
are u in which branch?
Like ·
Avani Soneji
computer
Like ·
Student Of It Engineering
in which semester?
Like ·
Avani Soneji
7th
Like ·
Student Of It Engineering
ok.. in which subject u want material?
Like ·
Student Of It Engineering
i have lots off material but..
Like ·
Avani Soneji
what but???
Like ·
Avani Soneji
all subject specially java, .net and act
Like ·
Student Of It Engineering
i m in IT,, so i have .net ebook and java ppt material
Like ·
Avani Soneji
ok.... can u give me that material???
Like ·
Student Of It Engineering
ok i dont have problem.. but its too large in size..
Like ·
Student Of It Engineering
contact me- chetan200891@yahoo.com i am trying to upload now
Like ·
Student Of It Engineering
whats ur email?
Like ·
Avani Soneji
avani.soneji@gmail.com
Like ·
Nidhi Amin
thanksssss
Like · Comment ·
Vadhel Krupali and Joydip Panchal like this
Download Android App