Scribd
Upload
3 views33 pages

JDBC Programs for Employee Management

The document outlines a series of practical exercises related to JDBC programming and web development, including adding and deleting records from an employee table, navigating through a student table, and validating user credentials. It provides code snippets for various functionalities such as adding, deleting, and checking user validity, along with servlet examples for handling user input. Additionally, it includes HTML forms for user interaction and demonstrates the use of JSP for displaying multiplication tables.

Uploaded by

saara.siddiqui2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views33 pages

JDBC Programs for Employee Management

The document outlines a series of practical exercises related to JDBC programming and web development, including adding and deleting records from an employee table, navigating through a student table, and validating user credentials. It provides code snippets for various functionalities such as adding, deleting, and checking user validity, along with servlet examples for handling user input. Additionally, it includes HTML forms for user interaction and demonstrates the use of JSP for displaying multiplication tables.

Uploaded by

saara.siddiqui2003
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

G.

N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

PRACTICAL 1

AIM: JDBC program to add records to employee table

Table(eno,ename,edesignation) Eclipse IDE “ADD” BUTTON code

RESET BUTTON:

1
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

OUTPUT:

MySql:

2
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

PRACTICAL 2

AIM: JDBC program to delete records from employee table


ECLIPSE DELETE BUTTON CODE

Reset Button Code:-


JButton resetbtn = new JButton("Reset");
[Link](new ActionListener() {

public void actionPerformed(ActionEvent e) {


[Link]("");
}
});

MY SQL:-

3
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

OUTPUT

4
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

PRACTICAL 3
Aim: JDBC program to perform navigation(first,next,last
& previous) on students table.

package pract3;

import [Link];

import [Link];
import [Link];
import
[Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class navigation extends JFrame {

private static final long serialVersionUID = 1L;


private JPanel contentPane;
private JTextField t1;
private JTextField t2;
private JTextField t3;
Connection con;
Statement st;
ResultSet rs;
String query;

/**
* Launch the application.
*/
public static void main(String[] args) {
[Link](new Runnable()
{ public void run() {
try {

5
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

navigation frame = new navigation();


[Link](true);
} catch (Exception e) {
[Link]();
}
}
});
}

/**
* Create the frame.
*/
public void showdata(ResultSet rs) {
try
{
[Link]([Link]("eno"));
[Link]([Link]("ename"));
[Link]([Link]("designation"));
}
catch(Exception ex)
{
[Link](ex);
}
}
public navigation() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLO
SE); setBounds(100, 100, 450, 300);
contentPane = new JPanel();
[Link](new Color(0, 0, 0));
[Link](new Color(255, 255,
255)); [Link](new EmptyBorder(5, 5,
5, 5));

setContentPane(contentPane);
[Link](null);

JLabel lblNewLabel = new JLabel("eno");


[Link](new Color(0, 0, 0));
[Link](new Font("Tahoma", [Link],
14)); [Link](41, 34, 45, 13);
[Link](lblNewLabel);

JLabel lblNewLabel_1 = new JLabel("ename");


lblNewLabel_1.setFont(new Font("Tahoma", [Link],
14)); lblNewLabel_1.setForeground(new Color(0, 0, 0));
lblNewLabel_1.setBounds(41, 85, 72, 13);
[Link](lblNewLabel_1);

6
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

JLabel lblNewLabel_2 = new JLabel("edesignation ");


lblNewLabel_2.setFont(new Font("Tahoma", [Link],
14)); lblNewLabel_2.setForeground(new Color(0, 0, 0));
lblNewLabel_2.setBounds(41, 141, 109, 13);
[Link](lblNewLabel_2);

t1 = new JTextField();
[Link](220, 31, 96, 19);
[Link](t1);
[Link](10);

t2 = new JTextField();
[Link](220, 82, 96, 19);
[Link](t2);
[Link](10);

t3 = new JTextField();
[Link](220, 138, 96, 19);
[Link](t3);
[Link](10);

JButton btnNewButton = new JButton("FIRST");


[Link](new ActionListener() {
public void actionPerformed(ActionEvent e) { try {
[Link]();
showdata(rs);
}
catch(Exception ex)
{
[Link](ex);
}
}
});
[Link](10, 202, 85, 21);
[Link](btnNewButton);

JButton btnNewButton_1 = new JButton("LAST");


btnNewButton_1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) { try {
[Link]();
showdata(rs);
}
catch(Exception ex)
{
[Link](ex);
}
}

7
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

});
btnNewButton_1.setBounds(118, 202, 85, 21);
[Link](btnNewButton_1);

JButton btnNewButton_2 = new JButton("NEXT");


btnNewButton_2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) { try
{
[Link]();
if([Link]())
{
[Link](btnNewButton_2,"You are at the last");
[Link]();
showdata(rs);
}else {
showdata(rs);}
}
catch(Exception ex)
{
[Link](ex);
}
}
});
btnNewButton_2.setBounds(231, 202, 85, 21);
[Link](btnNewButton_2);

JButton btnNewButton_3 = new JButton("PREVIOUS");


btnNewButton_3.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
try
{
[Link]();
if([Link]())
{
[Link](btnNewButton_2,"You are at the first");
[Link]();
showdata(rs);
}else {
showdata(rs);}
}
catch(Exception ex)
{
[Link](ex);
}
}
});
btnNewButton_3.setBounds(341, 202, 85, 21);
[Link](btnNewButton_3);

8
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

try {
[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/employee","root","tiger" );
[Link]("Connection created");
query="select * from emp";
st=[Link](ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UP
DATABLE); rs=[Link](query);
[Link]();
showdata(rs);
}
catch(Exception ex) {
[Link](ex);
}
}
}

OUTPUT:

9
G.N KHALSA COLLEGE (AUTONOMOUS) B-292
Siddiqui Sara

10
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

PRACTICAL 4

AIM: JDBC program to check whether a user is valid or not.


ECLIPSE ADD BUTTON:

RESET BUTTON:

OUTPUT:

11
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

MySql:

12
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

Practical 5

5.a. Create a servlet program to check whether a user is


valid or not.

[Link]

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Even Odd</title>
</head>
<body>
<form action=Servlet1>
<pre>
Enter any number:<input type=text name=t1>
<input type=submit> <input type=reset>
</pre>
</form>
</body>
</html>

[Link]
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out=[Link]();
[Link]("text/html");
int num=[Link]([Link]("t1"));
if(num%2==0) {
[Link]("<h1>"+num+" Number is Even");
}
else {
[Link]("<h1>"+num+" Number is Odd");
}

13
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

14
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

5.b. Create a servlet program to check username and


password with predefined values. If it matches, display
login successful otherwise redirect user again to login
page.

[Link]
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action=Servlet2>
<pre>
Enter Username:
<input type="text" name="t1">
Enter Password:
<input type="password" name="t2">
<br>
<input type="submit"><input type="reset">
</pre>
</form>
</body>
</html>

15
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

[Link]
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out=[Link]();
[Link]("text/html");
String s = [Link]("t1");
String s2 = [Link]("t2");

if([Link]("Password") && [Link]("Users2005")) {


[Link]("<h1>" + "Welcome"+ t1);
}else {
[Link]("<h1>"+"Denied permission check username of
password");
[Link]("<br><a href=[Link]>Back Page!!</a>");
}
}

​ ​

16
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

Practical 6

File— Dynamic web project —multivale—6.0— finish


Window–show view–Project explore— select file —src–main–webApp–new html
file–[Link]

A] Create a JSP program to accept a number


from the user and display its multiplication
table .

[Link]

1.<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Registration </title>
</head>
<body bgcolor=cyan>
<center><h1>Registration form</h1></center>
<form action=MultivaluedServlet>
<pre>
Enter Name: <input type=text name=t1>

Enter Address: <textarea rows=5 cols=20


name=t2></textarea>

Enter Email: <input type=text name=t3>

Enter Mobile: <input type=text name=t4>

Select Degree: <select


name=hob><option>SSC</option><option>HSC</option>

<option>UG</option><option>PG</option>
</select>
Select Hobbies:<input type=checkbox value=Cricket
name=chk>Cricket
<input type=checkbox value=Music name=chk>Music
<input type=checkbox value=Travellling

17
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

name=chk>Travelling
<input type=submit value=Register> <input type=reset>
</pre>
</form>
</body>
</html>

[Link]
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
PrintWriter out=[Link]();
[Link]("text/html");
String n=[Link]("t1");
String addr=[Link]("t2");
String email=[Link]("t3");
String mob=[Link]("t4");
String age=[Link]("t5");
String degree=[Link]("hob");
String[] hobbies=[Link]("chk");
String msg="<h2>Thank you for
registration!<br>Name:"+n+"<br>Address:"+addr;
msg+="<br>Email:"+email+"<br>Mobile
No:"+mob+"<br>Age:"+age+"<br>Degree:"+degree;
msg+="<br>Hobbies:";
for(int i=0;i<[Link];i++)
msg+=hobbies[i]+",";
[Link](msg);

18
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

[Link]
<!DOCTYPE html>
<html>

19
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action=InsertServlet></form>
<pre>
Enter No: <input type=text name=t1>

Enter Name: <input type=text name=t2>

Enter Designation: <input type=text name=t3>

<input type=submit value=Insert> <input type=reset>

</pre>
</form>
</body>
</html>

[Link] void doGet(HttpServletRequest request, HttpServletResponse


response) throws ServletException, IOException {
try
{

PrintWriter out=[Link]();
[Link]("text/html");

String no=[Link]("t1");
String name=[Link]("t2");
String desig=[Link]("t3");

[Link]("[Link]");
Connection
con=[Link]("jdbc:mysql://localhost:3306/sycs","root","ro
ot");
String query="insert into emp values(?,?,?)";
PreparedStatement ps=[Link](query);
[Link](1,no);
[Link](2,name);
[Link](3, desig);
[Link]();
[Link]("<h1>Record Added Successfully!");
[Link]("<br><a href=[Link]>Wants to add more

20
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

records?</a>");
}
catch(Exception ex)
{
[Link](ex);
}
}

21
G.N KHALSA COLLEGE (AUTONOMOUS) B-292
Siddiqui Sara

22
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

Practical no 7
Aim:- Create a web service to check a number is

even or odd

[Link]
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action=[Link]>
<pre>
Enter any no: <input type=text name=t1>
<input type=submit> <input type=reset>

</pre>
</form>
</body>
</html>

[Link]
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int n=[Link]([Link]("t1"));
for(int i=1; i<=10; i++)
[Link](n+"*"+i+"="+(n*i)+"</br>");
%>
</body>
</html>
Output

23
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

2.
[Link]
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action=[Link]>
<pre>
Enter First No: <input type=text name=t1>
Enter Second No: <input type=text name=t2>

<input type=submit> <input type=reset>

</pre>
</form>
</body>
</html>

[Link]
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
24
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int n1=[Link]([Link]("t1"));
int n2=[Link]([Link]("t2"));
[Link]("<h1>Addition is "+(n1+n2));
%>
</body>
</html>

[Link]
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action=[Link]>
<pre>
Enter Any No: <input type=text name=t1>

<input type=submit> <input type=reset>


</pre>
</body>
</html>

25
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

[Link]
<%@ page language="java" contentType="text/html;
charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
int n=[Link]([Link]("t1"));
int fact=1;
while(n>1)
{
fact=fact*n;
n--;
}
[Link]("<h1>Factorial is "+fact);
%>
</body>
</html>

Output:

4.
[Link]
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">

26
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

<title>Insert title here</title>


</head>
<body>
<form action="[Link]">
<pre>
Enter Number: <input type = text name = t1><br> Enter
Name: <input type = text name = t2><br> Enter
Designation: <input type = text name = t3><br> <input type
= submit> <input type = reset>
</pre>
</form>
</body>
</html>

[Link]
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@page import="[Link]"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
try
{
String no=[Link]("t1");
String name=[Link]("t2");
String desig=[Link]("t3");

[Link]("[Link]");
Connection con =
[Link]("jdbc:mysql://localhost:3306/sycs","root","root");

String query="insert into emp values(?,?,?)";


PreparedStatement ps=[Link](query);
[Link](1, no);
[Link](2, name);
[Link](3, desig);
[Link]();
[Link]("<h1>Record Added successfully!");
[Link]("<br><a href=[Link]>Wants to add more
records?</a>");

27
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

}
catch(Exception ex)
{
[Link](ex);
}
%>

</body>
</html>

Output:

28
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

PRACTICAL-8

AIM:Create and Consume Web services in Java.


NETBEANS:
[Link]
package server;
import [Link];
import [Link];
import [Link];
@WebService(serviceName = "evenoddws")
public class evenoddws {
/**
* Web service operation
*/
@WebMethod(operationName = "evenodd")
public String evenodd(@WebParam(name = "n") int n)
{
if(n%2==0)
return n+"is even";
else
return n+"is odd";
}
}
[Link]
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
29
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

<title>JSP Page</title>
</head>
<body>
<%-- start web service invocation --%><hr/>
<%
try {

client.Evenoddws_Service service = new


client.Evenoddws_Service();
[Link] port = [Link]();
// TODO initialize WS operation arguments here
int n = [Link]([Link]("t1"));
// TODO process result here
[Link] result = [Link](n);
[Link]("Result = "+result);
} catch (Exception ex) {
// TODO handle custom exceptions here
}
%>
</body>
</html>
<%-- end web service invocation --%><hr/>
[Link]
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>JSP Page</title>
</head>

30
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

<body>
<form action="[Link]">
<pre>
Enter any no: <input type="text" name="t1">
<input type="submit"><input type="reset"> </pre>
</form>
</body>
</html>
Output:

[Link]
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<%-- start web service invocation --%><hr/>
<%
try {
client.Additionws_Service service = new
31
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

client.Additionws_Service(); [Link] port =


[Link]();
// TODO initialize WS operation arguments here
int n1 = [Link]([Link]("t1"));
int n2 = [Link]([Link]("t2"));
// TODO process result here
[Link] result = [Link](n1, n2);
[Link]("Result = "+result);
} catch (Exception ex) {
// TODO handle custom exceptions here
}
%>
</body>
</html>
<%-- end web service invocation --%><hr/>
[Link]
package server;
import [Link];
import [Link];
import [Link];
@WebService(serviceName = "additionws")
public class additionws {
/**
* Web service operation
*/
@WebMethod(operationName = "addition")
public String addition(@WebParam(name = "n1") int
n1, @WebParam(name = "n2")
int n2) {
return "addition is"+(n1+n2);
}
}
32
G.N KHALSA COLLEGE (AUTONOMOUS) B-292 Siddiqui Sara

[Link]
<%@page contentType="text/html"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<form action="[Link]">
<pre>
Enter first no: <input type="text" name="t1">
Enter second no:<input type="text" name="t2">
<input type="submit"><input type="reset">
</pre>
</form>
</body>
</html>

33

You might also like