1.
Write a JDBC program to accept user’s details, store and display
to/from the database.
package Lab1;
import java.sql.*;
import java.io.*;
public class Main {
public static void main(String[] args) {
// TODO Auto-generated method stub
int id;
String nm,add;
try {
DataInputStream din=new DataInputStream(System.in);
System.out.println("Enter information of user.");
System.out.println("Enter ID of user.");
id=Integer.parseInt(din.readLine());
System.out.println("Enter Name of user.");
nm=din.readLine();
Class.forName("com.mysql.jdbc.Driver");
Connection
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/user",
"root","root");
PreparedStatement pst=con.prepareStatement("insert into deets
values(?,?)");
pst.setInt(1,id);
pst.setString(2,nm);
int n=pst.executeUpdate();
if(n>0)
{
System.out.println("Record is Inserted...!!!");
}
else {
System.out.println("Error...!!!");
}
pst.close();
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
2. Write a JDBC program to edit user’s details and display the records
package Lab2;
import java.sql.*;
public class practise {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection =
DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root",
"root");
// Create a statement
Statement statement = connection.createStatement();
// Execute a statement to edit user details
String sql = "UPDATE details SET name = 'prajapathi' WHERE id = 8";
statement.executeUpdate(sql);
// Execute a statement to display the records
sql = "SELECT * FROM details";
ResultSet resultSet = statement.executeQuery(sql);
// Iterate through the result set and print the records
while (resultSet.next()) {
System.out.println(resultSet.getInt("id") + ", " +
resultSet.getString("name"));
}
resultSet.close();
statement.close();
connection.close();
} catch (Exception e) { e.printStackTrace(); }
}
}
3. Write a Socket program to communicate between client and server.
SERVER CODE :-
package serveclient;
import java.net.*;
import java.io.*;
public class Myserver {
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
ServerSocket ss = new ServerSocket(4444);
Socket s = ss.accept();
DataInputStream din = new DataInputStream(s.getInputStream());
DataOutputStream dout = new DataOutputStream(s.getOutputStream());
BufferedReader br = new BufferedReader(new
InputStreamReader(System.in));
String str = " ", str2 = " ";
while(!str.equals("stop"))
{
str = din.readUTF();
System.out.println("Client says : " + str);
str2 = br.readLine();
dout.writeUTF(str2);
dout.flush();
}
din.close();
s.close();
ss.close();
}
CLIENT CODE :-
package serveclient;
import java.net.*;
import java.io.*;
public class Myclient {
public static void main(String[] args) throws Exception {
// TODO Auto-generated method stub
Socket s = new Socket ("localhost" , 4444);
DataInputStream din = new DataInputStream(s.getInputStream());
DataOutputStream dout = new DataOutputStream(s.getOutputStream());
BufferedReader br = new BufferedReader(new
InputStreamReader(System.in));
String str = " ", str2 = " ";
while(!str.equals("stop"))
{
str = br.readLine();
dout.writeUTF(str);
dout.flush();
str2 = din.readUTF();
System.out.println("server says : " + str2);
}
dout.close();
s.close();
}
}
4. Write a Socket program using URLConnection and InetAddress class.
CLASS 1 :-
package exercise4;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.lang.ClassNotFoundException;
import java.net.ServerSocket;
import java.net.Socket;
public class ser4 {
private static ServerSocket server ;
private static int port = 9876;
public static void main(String args[]) throws IOException,
ClassNotFoundException{
server = new ServerSocket(port);
while(true){
System.out.println("Waiting for the client request"); //creating socket and waiting
for client connection Socket socket server.accept();
Socket socket = server.accept();
ObjectInputStream ois = new ObjectInputStream(socket.getInputStream());
String message = (String) ois.readObject();
System.out.println("Message Received: "+ message);
ObjectOutputStream oos= new ObjectOutputStream(socket.getOutputStream());
oos.writeObject("Hi Client" + message);
ois.close();
oos.close();
socket.close();
if(message.equalsIgnoreCase("exit")) break;
}
System.out.println("Shutting down Socket server!!");
server.close();
}
}
CLASS 2 :-
package exercise4;
import java.io.IOException;
import java.io.ObjectInputStream;
import java.io.ObjectOutputStream;
import java.net. InetAddress;
import java.net.Socket;
import java.net.UnknownHostException;
public class cli4 {
public static void main(String[] args) throws UnknownHostException, IOException,
ClassNotFoundException, InterruptedException{
InetAddress host = InetAddress.getLocalHost();
Socket socket = null;
ObjectOutputStream oos = null;
ObjectInputStream ois = null;
for(int i=0; i<5;i++) {
socket = new Socket (host.getHostName(), 9876);
oos = new ObjectOutputStream(socket.getOutputStream());
System.out.println("Sending request to Socket Server");
if(i==4)oos.writeObject("exit");
else oos.writeObject(""+i);
ois = new ObjectInputStream(socket.getInputStream());
String message = (String) ois.readObject();
System.out.println("Message: " + message); //close resources
ois.close();
oos.close();
Thread.sleep(100);
}
}
}
5. Write a Servlet program to handle client request and generating
response from server.
(create dynamic project and then right click on that and create new servlet and run on
server i.e tomcat)
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Sample1")
public class Sample1 extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
PrintWriter out = response.getWriter();
out.print("<html> <body>");
out.print("<h3> Received Response from server </h3)");
out.print("</html> </body>");
}
}
6. Write a Servlet program to implement session tracking.
FirstServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class FirstServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response){
try{
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String n=request.getParameter("userName");
out.print("Welcome "+n);
HttpSession session=request.getSession();
session.setAttribute("uname",n);
out.print("<a href='servlet2'>visit</a>");
out.close();
}catch(Exception e){System.out.println(e);}
}
}
SecondServlet.java
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class SecondServlet extends HttpServlet {
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// TODO Auto-generated method stub
try{
response.setContentType("/text/html");
PrintWriter out = response.getWriter();
HttpSession session=request.getSession(false);
String n=(String)session.getAttribute("uname");
out.print("Hello "+n);
out.close();
}catch(Exception e){System.out.println(e);}
Index.html
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="servlet1">
Name:<input type="text" name="userName"/><br/>
<input type="submit" value="go"/>
</form>
</body>
</html>
Web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app>
<servlet>
<servlet-name>s1</servlet-name>
<servlet-class>FirstServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>s1</servlet-name>
<url-pattern>/servlet1</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>s2</servlet-name>
<servlet-class>SecondServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>s2</servlet-name>
<url-pattern>/servlet2</url-pattern>
</servlet-mapping>
</web-app>
7. Write a JSP program to implement a table.(Sample Order Form)
<HTML>
<HEAD>
<TITLE>A Catalog Order Form</TITLE>
</HEAD>
<BODY>
<H1 ALIGN="center">A Sample Order Form</H1>
<%!
String item[] = {"DVD", "CD", "Diskette"};
double price[] = {19.99, 12.99, 1.99};
int quantity[] = {2, 9, 24};
%>
<TABLE ALIGN="center" BGCOLOR="lightgray" BORDER="1" WIDTH="75%">
<TR><TD>Item</TD>
<TD>Price</TD>
<TD>Quantity</TD>
<TD>Total Price</TD>
</TR>
<% for (int i=0; i<3; i++) { %>
<TR><TD><%= item[i] %></TD>
<TD><%= price[i] %></TD>
<TD><%= quantity[i] %></TD>
<TD><%= price[i] * quantity[i] %></TD>
</TR>
<% } //end for loop %>
</TABLE>
</BODY>
</HTML>
8. Write a JSP program to implement the registration form.
RegistrationServlet.java(Write the program by creating a new Servlet)
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/registrationServlet")
public class RegistrationServlet extends HttpServlet {
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
String username = request.getParameter("username");
String password = request.getParameter("password");
String email = request.getParameter("email");
System.out.println("Username: " + username);
System.out.println("Password: " + password);
System.out.println("Email: " + email);
response.sendRedirect("registration.jsp");
}
}
Registration.jsp
(Create a JSP file for this program)
<!DOCTYPE html>
<html>
<head>
<title>Registration Form</title>
</head>
<body>
<h2>Registration Form</h2>
<form action="registrationServlet" method="get">
<label for="username">Username:</label>
<input type="text" id="username" name="username" required><br><br>
<label for="password">Password:</label>
<input type="password" id="password" name="password" required><br><br>
<label for="email">Email:</label>
<input type="email" id="email" name="email" required><br><br>
<input type="submit" value="Register">
</form>
</body>
</html>
