“ADVANCE JAVA LAB”
Subject Code: 5CS4-24
Course: Computer Science and Engineering
(Bikaner Technical University, Bikaner)
Vth Semester
SESSION (2022 – 2023)
SUBMITTED TO: SUBMITTED BY:
Mr. Gaurav Gupta Poornima Rathi
Assistant Professor (20EEMCS74)
(Dept. of Computer Engineering) [Link], V SEM
Department of Computer Engineering
Govt. Mahila Engineering College, Ajmer
Nasirabad Road, Makhupura, Ajmer-(305002)
1
MAHILA ENGINEERING COLLEGE, AJMER
Department: Computer Engineering
Program: Computer Science & Engineering
Vision of the Institution:
To attain excellence in imparting Technical Education to females.
Mission of the Institution:
To impart technical knowledge and infuse a sense of enthusiasm among students to design, create and
invent -who possess a knack to design create and develop products and services which will cater to the
needs of future generations thereby leading to sustainable development.
To promote women technocrats to make a meaningful contribution by creating a pool of talented human
resource - who are capable enough to resolve the problems faced by the country using the knowledge
imparted, talent inculcated and the research which we do.
To prepare self reliant females for the technological growth of the nation and society- to train and create
technical manpower by laying strong theoretical foundation accompanied by a wide practical training
which in turn will become a valuable resource for the society.
To facilitate and provide state-of-the-art facilities to women technocrats and faculty- to create an environment
where novel ideas blossom, research flourishes and becomes the knowledge house of tomorrow's leaders and
innovators.
Vision of the Department:
To produce quality human resource in computing science for empowerment of females.
Mission of Department:
To transfer fundamental knowledge on various subject areas and develop capability to analyze and solve
new problems.
To provide state of the art laboratory facilities and exposure to practical aspects of various computer
engineering principles and inculcate ability to analyze, design, test and implement solutions to various
problems in the field of computer engineering.
To provide opportunities to the students for improving interpersonal skills and holistic development, so
they become professionally competitive and responsible citizen.
2
To provide ample opportunities for training and placement
TABLE OF CONTENTS
[Link] Programs PageNo.
.
1. WAP in JAVA to implement the working of applet. 1
2. WAP in JAVA to implement Swing Components. 3
3. Database Design and Table Creation. 7
4. How to use My Sql with Java. 8
5. WAP in JAVA to show connection to database using JDBC. 10
6. Using basic networking features, WAP in JAVA to 17
accomplish it.
1) Write client server program in java to display the
message on both client and server side.
2)Write a client server program in java to input a string on
the client side and show on the server side.
3
7. WAP in JAVA to Design JSP. 21
Program No – 1
Objective:WAP in JAVA to implement the working of applet.
Program:Working of Applet using Appletviewer tool
import [Link].*;
import [Link].*;
public class apletdemo2 extends Applet {
String msg;
// set the foreground and background colors. public void init()
{setBackground([Link]);
setForeground([Link]);
msg = "Inside init( ) --";
}
// Initialize the string to be displayed. public void start()
{
msg += " Inside start( ) --";
}
// Display msg in applet window.
public void paint(Graphics g)
{
msg += " Inside paint( ).";
[Link](msg, 10, 30);
}
}
4
HTML Program to Show Applet Class
<html>
<title>The Hello, World Applet</title>
<hr>
<applet code = "[Link]" width = "320" height = "120"></applet>
<hr>
</html>
OUTPUT:
5
Program No – 2
Objective: WAP in JAVA to implement Swing Components.
Program:
import [Link].*;
import [Link].*;
public class marksheet
{
public static void main(String[] args)
{
JFramejf =new JFrame("Marks Sheet");
//Title Student Marks
JLabel jltitle1 = new JLabel();
[Link](150,10,200,20); //L-250,T-50,W-250,H-30
[Link]("Student Marks");
//Name
JLabeljlname = new JLabel();
[Link](50,40,250,20); //L-50,T-150,W-250,H-30
[Link]("Name");
JTextFieldjtname = new JTextField();
[Link](250,40,250,20); //L-250,T-150,W-250,H-30
//Age
JLabeljlage = new JLabel();
[Link](50,70,250,20); //L-50,T-200,W-250,H-30
[Link]("Age");
JTextFieldjtage = new JTextField();
6
[Link](250,70,100,20); //L-250,T-200,W-100,H-30
//Title Marks
JLabel jltitle2 = new JLabel();
[Link](150,100,250,20); //L-320,T-250,W-250,H30
[Link]("Marks Obtained");
//Hindi
JLabel jlm1 = new JLabel();
[Link](50,130,200,20); //L-50,T-250,W-250,H-30
[Link]("Hindi");
JTextField jtm1 = new JTextField();
[Link](250,130,100,20); //L-250,T-250,W-100,H-30
//English
JLabel jlm2 = new JLabel();
[Link](50,160,200,20); //L-50,T-350,W-200,H-30
[Link]("English");
JTextField jtm2 = new JTextField();
[Link](250,160,100,20); //L-250,T-350,W-100,H-30
//Maths
JLabel jlm3 = new JLabel();
[Link](50,190,200,20); //L-50,T-250,W-200,H-30
[Link]("Maths");
JTextField jtm3 = new JTextField();
[Link](250,190,100,20); //L-250,T-250,W-100,H-30
//Calculate Button
JButtonjbcalc = new JButton();
[Link](150,220,100,20); //L-250,T-450,W-150,H-30
[Link]("Calculate");
[Link]([Link]);
//Title Result
JLabel jltitle3 = new JLabel();
7
[Link](170,250,200,20); //L-320,T-500,W-200,H30
[Link]("Result");
JLabeljltotal = new JLabel();
[Link](50,280,200,20); //L-50,T-550,W-200,H-30
[Link]("Total");
JTextFieldjttotal = new JTextField();
[Link](250,280,100,20); //L-320,T-550,W-100,H-30
[Link](false);
JLabeljlper = new JLabel();
[Link](50,310,200,20); //L-50,T-600,W-200,H-30
[Link]("Percentage");
JTextFieldjtper = new JTextField();
[Link](250,310,100,20); //L-250,T-600,W-100,H-30
[Link](false);
JLabeljlres = new JLabel();
[Link](50,340,200,20); //L-50,T-750,W-250,H-30
[Link]("Result");
JTextFieldjtres = new JTextField();
[Link](250,340,100,20); //L-250,T-650,W-100,H-30
[Link](false);
[Link](jltitle1);
[Link](jltitle2);
[Link](jltitle3);
[Link](jlname);
[Link](jlage);
[Link](jtname);
[Link](jtage);
[Link](jlm1);
[Link](jlm2);
[Link](jlm3);
8
[Link](jtm1);
[Link](jtm2);
[Link](jtm3);
[Link](jbcalc);
[Link](jltotal);
[Link](jlper);
[Link](jlres);
[Link](jltitle3);
[Link](jttotal);
[Link](jtper);
[Link](jtres);
[Link](300,200,550,450);
[Link](null);
[Link](true);
[Link](JFrame.EXIT_ON_CLOSE);
}
}
OUTPUT:
9
Program No – 3
Database - Database Design and Table Creation
Creating a Database with MySql and process to setup a table have student records.
10
Program No – 4
Objective: How to use My Sql with Java
Program - Interact My Sql Database with Java
import [Link].*;
class mysqlcon
{
public static void main(String args[])
{
try
{
[Link]("[Link]");
Connection con =
[Link]("jdbc:mysql://localhost:3306/stdmarks",
"root", "root");
PreparedStatementps = [Link]("select * from
stddata where perc > 60");
ResultSetrs = [Link](); //execute
[Link]("Students having marks > 60 are:");
while([Link]())
[Link]([Link](1));
[Link]();
}
catch(Exception e)
{
[Link]("Error" + [Link]());
11
}
}
}
OUTPUT:
12
Program No- 5
Object: WAP in JAVA to show connection to database using JDBC.
CODE:
[Link]
import [Link].*;
import [Link];
public class MyJDBC {
private static Scanner scanner;
public static void main(String[] args) throws SQLException, ClassNotFoundException
//throws SQLException and ClassNotFoundException due to connectivity of SQL(JDBC)
{
student s = new student();//object of type student with name as "s".
int Choice=0;
do {
[Link]("Select an option\n1-Registration\n2-Update\n3-delete\n4-Search\n5-
Exit");
scanner = new Scanner([Link]);
Choice = [Link]();
switch (Choice) {
case 1:
s.get_student_details();//calls the method get_student_details from the student class
s.insert_details();//calls the method insert_details from the student class
break;
case 2:
s.update_student_name();//calls the method update_student_name from the student
13
class
break;
case 3:
s.delete_student_record();//calls the method delete_student_record from the student
class
break;
case 4:
s.search_details();//calls the method search_details from the student class
break;
case 5:
[Link]("Exiting the Application");//exits the application
break;
default:
[Link]("Choose a valid option");//in case of an invalid input(other than
1,2,3,4 and 5)
}
}while(Choice!=5);
}
}
[Link]
import [Link].*;
import [Link];
public class student {
String name;
int id;
private Scanner input;
private Scanner input2;
private Scanner input3;
private Scanner input4;
public void get_student_details()//gets the student details such as name and ID
14
{
input = new Scanner([Link]);
[Link]("Enter your name:");
name=[Link]();//gets ur name
[Link]("Enter your id:");
id=[Link]();//gets user ID
}
public void insert_details() throws SQLException, ClassNotFoundException//method to insert
the details of student
{
dbconnection connection=new
dbconnection("jdbc:mysql://localhost:3306/jdbc","shikha","password");//creates an object of
type dbconnection class with name [Link] of the database id jdbc-1,user id is root and
password is basketball30.
Connection con=[Link]();//establish the connection with the database
"jdbc-1"
String sql="insert into people values(?,?);";//sql statement for inserting the values given by
the user in the table people.
PreparedStatementstmt=[Link](sql);
[Link](1,id);//map the first ? from the sql statement to the id
[Link](2,name);//map the first ? from the sql statement to the name
[Link]();//execute the SQL statement
[Link]("Record inserted Successfully");
[Link](con,stmt);//close the dbconnection with the method
closeConnection in the dbconnection class
}
public void update_student_name() throws SQLException,ClassNotFoundException//method
to update the details of student
{
dbconnection connection=new
15
dbconnection("jdbc:mysql://localhost:3306/jdbc","shikha","password");//refer line 16
Connection con=[Link]();//refer line 17
input2 = new Scanner([Link]);
[Link]("Enter your id");
id=[Link]();//gets student ID from the user
[Link]("Enter your corrected name");
String cname=[Link]();//gets Student name from the user
String sql="update people set first_name=? where id=?;";//sql statement to update the
values in the table people.
PreparedStatementstmt=[Link](sql);
[Link](1,cname);//refer to line 21
[Link](2,id);//refer to line 20
int i = [Link]();
if(i>0)//if valid record
[Link]("Record updated successfully");
else//invalid record or record not found
[Link]("No such Record found");
[Link](con,stmt);//refer line 24
}
public void delete_student_record() throws SQLException, ClassNotFoundException//
method to delete the data record of the particular student
{
dbconnection connection=new
dbconnection("jdbc:mysql://localhost:3306/jdbc","shikha","password");//refer line 16
Connection con=[Link]();//refer line 17
input4 = new Scanner([Link]);
[Link]("Enter your id:");
id=[Link]();//gets StudentID from the user
String sql="delete from people where id=?;";//sql statement for deleting the record in people
where id=ID given by user in line above.
16
PreparedStatementstmt=[Link](sql);
[Link](1,id);//refer line 20
int i=[Link]();
if(i>0)//if valid record
{
[Link]("Record deleted Successfully");
}//if invalid record
else
[Link]("Record not found");
[Link](con,stmt);//refer line 24
}
public void search_details() throws SQLException, ClassNotFoundException //method to
search the details of the particular student
{
dbconnection connection=new
dbconnection("jdbc:mysql://localhost:3306/jdbc","shikha","password");//refer line 16
Connection con=[Link]();//refer line 17
input3 = new Scanner([Link]);
[Link]("Enter the id:");
id=[Link]();//gets StudentID from the user
String sql="select * from people where id=?;";//sql Statement for selecting the data where
id=StudentID given by user in line above.
PreparedStatement
stmt=[Link](sql,ResultSet.TYPE_SCROLL_INSENSITIVE,[Link]
R
_UPDATABLE);
[Link](1,id);//refer line 20
ResultSetrs=[Link]();
if([Link]()==false)//if no record is there
[Link]("There is no such record");
else//if a valid record exist
17
{
[Link]();
while ([Link]())
{
[Link]([Link](1) + [Link](2));//prints the record of the StudentID
entered
}
}
[Link](con,stmt);//refer line 24
}
}
[Link]
import [Link].*;
public class dbconnection {
String url;//url of the database in the local computer or localhost which is present in MySQL
with
name as jdbc-1
String user;//user ID of MySQL in the local computer
String password;//password of MySQL
dbconnection(String url,Stringuser,String password)//constructor of dbconnection
{
[Link]=url;
[Link]=user;
[Link]=password;
}
public Connection getConnection() throws ClassNotFoundException, SQLException//method
to establish connection with the database. Would return Connection which could be used in the
class Student while creating the object of dbconnection to establish conneection
{
Connection con=null;
[Link]("[Link]");//name of the Driver
18
con=[Link](url,user,password);//creating the connection with the
mentioned url,user,password
[Link]("Connection established");
return con;//would return the connection
public void closeConnection(Connection con,PreparedStatementstmt) throws
SQLException//method to close the connection
{
[Link]();//closes the SQL statement
[Link]();//closes dbconnection
[Link]("Connection is closed");}
}
Output:
19
Program No – 6
Object: Using basic networking features, WAP in JAVA to accomplish it.
1)Write client server program in java to display the message on both client and server
side.
Client-side program:
import [Link].*;
import [Link].*;
public class TCPclient
{
public static void main(String[] args) throws IOException
{
Socket s = new Socket("localhost",4999);
PrintWriter pr = new PrintWriter([Link]());
[Link]("Greetings from client");
[Link]();
InputStreamReader in = new InputStreamReader([Link]());
BufferedReader bf = new BufferedReader(in);
String str = [Link]();
[Link]("Server: " + str);
}
}
Server-side program:
import [Link].*;
import [Link].*;
public class TCPserver
{
20
public static void main(String[] args) throws IOException
{
ServerSocket ss = new ServerSocket(4999);
Socket s = [Link]();
[Link]("client connected");
InputStreamReader in = new InputStreamReader([Link]());
BufferedReader bf = new BufferedReader(in);
String str = [Link]();
[Link]("client : " + str);
PrintWriter pr = new PrintWriter([Link]());
[Link]("Greetings from Server");
[Link]();
}
}
OUTPUT:
2)Write a client server program in java to input a string on the client side and show on
theserver side.
21
Client-side program:
import [Link];
import [Link].*;
public class EchoClient {
public static void main(String[] args) {
//TODO Auto-generated mehod stub
try
{
[Link]("Client started");
Socket soc = new Socket("localhost", 9806);
BufferedReaderuserInput = new BufferedReader(new
InputStreamReader([Link]));
[Link]("Enter a string");
String str = [Link]();
PrintWriter out = new PrintWriter([Link]() , true);
[Link](str);
BufferedReader in = new BufferedReader(new
InputStreamReader([Link]()));
[Link]([Link]());
}
catch(Exception e)
{
[Link]();
}
}
}
Server-side program:
import [Link];
import [Link];
import [Link].*;
22
public class EchoServer {
public static void main(String[] args) {
//TODO Auto-generated method stub
try
{
[Link]("Waiting for client ......");
ServerSocket ss = new ServerSocket(9806);
Socket soc =[Link]();
[Link]("connection established");
BufferedReader in = new BufferedReader(new
InputStreamReader([Link]()));
String str = [Link]();
PrintWriter out = new PrintWriter([Link]() , true);
[Link]("Server says: " +str);
}
catch(Exception e)
{
[Link]();
}}}
Output:
23
Program No – 7
Objective: WAP in JAVA to Design JSP.
Program - JSP Main Page with method
File: [Link]
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<input type="hidden" id="status" value="<%= [Link]("status") %>">
<form action="reg" method="post">
<label for="name">Name</label><br>
<input type="text" name="uname" placeholder="Enter the Name"
required="required"><br><br>
<label for="email">Email</label><br>
<input type="email" name="uemail" placeholder="Enter the Email"
required="required"><br><br>
<label for="password">Password</label><br>
<input type="password" name="upass" placeholder="Enter the password"
required="required"><br><br>
<label for="contact">Contact</label><br>
24
<input type="tel" name="umobile" placeholder="Enter the contact" pattern="[0-9]{3}[0-
9]{3}[0-9]{4}" required="required"><br><br>
<input type="submit" value="Sign Up">
<a href="[Link]">Already an member</a>
</form>
<script src="[Link]
<script type="text/javascript">
var status=[Link]("status").value;
if(status=="success"){
swal("Congrats","Account Created Successfully","success");
}
if(status=="failed"){
swal("This email id is already registered","error");
}
</script>
</body>
</html>
File: [Link]
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<input type="hidden" id="status" value="<%= [Link]("status") %>">
<form action="log" method="post">
25
<label for="Email">Email</label><br>
<input type="email" name="uemail" placeholder="Enter your Email"
required="required"><br><br>
<label for="Password">Password</label><br>
<input type="password" name="upassword" placeholder="Enter your Password"
required="required"><br><br>
<input type="submit" value="Login">
<a href="[Link]">Create an account</a>
</form>
<script src="[Link]
<script type="text/javascript">
var status=[Link]("status").value;
if(status=="success"){
swal("Congrats","loginSuccessfully","success");
}
if(status=="failed"){
swal("Sorry","Wrong Username or Password","error");
}
</script>
</body>
</html>
File: [Link]
<%
if([Link]("name")==null){
[Link]("[Link]");
}
%>
<!DOCTYPE html>
<html>
<head>
26
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1>HELLo EVERYONE!!</h1>
</body>
</html>
File: [Link]
package aa;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
/**
* Servlet implementation class reg
*/
@WebServlet("/reg")
public class reg extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
// TODO Auto-generated method stub
String uname=[Link]("uname");
27
String uemail=[Link]("uemail");
String upwd=[Link]("upass");
String umobile=[Link]("umobile");
RequestDispatcher dispatcher=null;
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/company?
useSSL=false","root","root");
PreparedStatementps=[Link]("select * from users where
uemail=?");
[Link](1,uemail);
ResultSetrs=[Link]();
if([Link]()) {
[Link]("status","failed");
[Link]("[Link]").forward(request, response);
}
else {
PreparedStatementpst=[Link]("insert into
users(uname,upwd,uemail,umobile) values(?,?,?,?)");
[Link](1,uname);
[Link](2,upwd);
[Link](3,uemail);
[Link](4,umobile);
int rowcount=[Link]();
if(rowcount>0) {
[Link]("status","success");
dispatcher=[Link]("[Link]");
}
else {
[Link]("status","failed");
28
dispatcher=[Link]("[Link]");
}}
[Link](request, response);
}catch(Exception e) {
[Link]();
}}}
File: [Link]
package aa;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
@WebServlet("/log")
public class log extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws
ServletException, IOException {
String uemail=[Link]("uemail");
String upwd=[Link]("upassword");
HttpSession session=[Link]();
RequestDispatcher dispatcher=null;
29
try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/company?useSSL=false","root
","root");
PreparedStatementpst=[Link]("select * from users where
uemail = ? and upwd = ? ");
[Link](1,uemail);
[Link](2,upwd);
ResultSetrs=[Link]();
if([Link]()) {
[Link]("name",[Link]("uname"));
[Link]("status","success");
dispatcher=[Link]("[Link]");
}
else {
[Link]("status","failed");
dispatcher=[Link]("[Link]");
}
[Link](request, response);
}catch(Exception e) {
[Link]();
}}}
File: [Link]
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="[Link]
xmlns="[Link]
xsi:schemaLocation="[Link]
[Link] id="WebApp_ID" version="4.0">
<display-name>Aa</display-name>
<welcome-file-list>
30
<welcome-file>[Link]</welcome-file>
</welcome-file-list>
</web-app>
OUTPUT:
31