Scribd
Upload
12 views40 pages

Library Management System Code

The document describes the development of a library management system application in Java. It includes 3 practical assignments: 1. Developing the presentation layer with menus for master file, transaction file, search file, report screen, and help. 2. Designing a suitable database for the library management system with fields for book ID, name, author, price, ISBN number, and edition. 3. Developing the business logic layer to allow saving, retrieving and exiting book details by connecting to the MySQL database.

Uploaded by

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

Library Management System Code

The document describes the development of a library management system application in Java. It includes 3 practical assignments: 1. Developing the presentation layer with menus for master file, transaction file, search file, report screen, and help. 2. Designing a suitable database for the library management system with fields for book ID, name, author, price, ISBN number, and edition. 3. Developing the business logic layer to allow saving, retrieving and exiting book details by connecting to the MySQL database.

Uploaded by

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

NAME:SIDDESH KHARADE ROLL NO.

:92

PRACTICAL NO.1
Aim: Develop the presentation layer of Library Management software application with
suitable menus.

SOURCE CODE:

import [Link].*;
import [Link].*;
public class MenuTest extends JFrame{
JMenu menu1,menu2,menu3,menu4,menu5;
JMenuBar menubar1;
JMenuItem menuitem1,menuitem2,menuitem3,menuitem4,menuitem5,menuitem6;
JMenuItem menuitem7,menuitem8,menuitem9,menuitem10,menuitem11;
JMenuItem menuitem12,menuitem13,menuitem14,menuitem15;
public MenuTest(){
menubar1=new JMenuBar();
setJMenuBar(menubar1);
menu1=new JMenu("Master File");
menu2=new JMenu("Transaction File");
menu3=new JMenu("Search File");
menu4=new JMenu("Report Screen");
menu5=new JMenu("Help");
menuitem1=new JMenuItem("Book details");
menuitem2=new JMenuItem("Student master");
menuitem3=new JMenuItem("Library master");
menuitem4=new JMenuItem("Tearch Master");
menuitem5=new JMenuItem("Fine details");
menuitem6=new JMenuItem("Order Deatails");
menuitem7=new JMenuItem("Student search");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 1


NAME:SIDDESH KHARADE ROLL NO.:92

menuitem8=new JMenuItem("Tearch search");


menuitem9=new JMenuItem("Book search");
menuitem10=new JMenuItem("Student report");
menuitem11=new JMenuItem("Fine report");
menuitem12=new JMenuItem("Order report");
menuitem13=new JMenuItem("About us");
menuitem14=new JMenuItem("Exit");
menuitem15=new JMenuItem("logout");
[Link](menuitem1);[Link](menuitem2);
[Link](menuitem3);[Link](menuitem4);
[Link](menuitem5);[Link](menuitem6);
[Link](menuitem7);[Link](menuitem8);
[Link](menuitem9);[Link](menuitem10);
[Link](menuitem11);[Link](menuitem12);
[Link](menuitem13);[Link](menuitem14);
[Link](menuitem15);
[Link](menu1);[Link](menu2);
[Link](menu3);[Link](menu4);
[Link](menu5);
setDefaultCloseOperation(EXIT_ON_CLOSE);
setSize(800,400);
setVisible(true);
}
public static void main(String[] args) {
new MenuTest();
}
}

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 2


NAME:SIDDESH KHARADE ROLL NO.:92

Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 3


NAME:SIDDESH KHARADE ROLL NO.:92

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 4


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.2
Aim: Design suitable database for Library Management System.
Source Code:
import [Link].*;
import [Link].*;
public class bookdetails extends JFrame{
JTextField
textfield_id,textfield_name,textfield_author,textfield_price,textfield_bn,textfield_edition;
JLabel label_id,label_name,label_author,label_price,label_bn,label_edition;
JButton button_save,button_retrive,button_Exit;
JTextArea textarea_d;
public bookdetails()
{
setLayout(null);
label_id=new JLabel("Book Id");
label_id.setBounds(10,10,100,30);
textfield_id=new JTextField(20);
textfield_id.setBounds(120,10,200,30);

label_name=new JLabel("Book Name");


label_name.setBounds(10,50,100,30);
textfield_name=new JTextField(20);
textfield_name.setBounds(120,50,200,30);

label_author=new JLabel("Author");
label_author.setBounds(10,110,100,30);
textfield_author=new JTextField(20);
textfield_author.setBounds(120,110,200,30);

label_price=new JLabel("price");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 5


NAME:SIDDESH KHARADE ROLL NO.:92

label_price.setBounds(10,160,100,30);
textfield_price=new JTextField(20);
textfield_price.setBounds(120,160,200,30);

label_bn=new JLabel("isbn_no");
label_bn.setBounds(10,220,100,30);
textfield_bn=new JTextField(20);
textfield_bn.setBounds(120,220,200,30);

label_edition=new JLabel("Book Edition");


label_edition.setBounds(10,270,100,30);
textfield_edition=new JTextField(20);
textfield_edition.setBounds(120,270,200,30);

button_save=new JButton("Save");
button_save.setBounds(10,400,100,50);
button_retrive=new JButton("Retrive");
button_retrive.setBounds(120,400,100,50);
button_Exit=new JButton("Exit");
button_Exit.setBounds(240,400,100,50);

textarea_d=new JTextArea(5,30);
textarea_d.setBounds(50,320,300,70);
JScrollPane sp1=new JScrollPane(textarea_d);
add(label_id);add(textfield_id);
add(label_name);add(textfield_name);
add(label_author);add(textfield_author);
add(label_price);add(textfield_price);
add(label_bn);add(textfield_bn);
add(label_edition);add(textfield_edition);

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 6


NAME:SIDDESH KHARADE ROLL NO.:92

add(textarea_d);add(button_retrive);add(button_save);add(button_Exit);

setSize(400,500);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
}
public static void main(String args[])
{
new bookdetails();
}
}
Output:

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 7


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.3
Aim: Develop business logic layer for Library Management System.
CONFIGURE:

Source Code:
package allpractical;

import [Link].*;
import [Link].*;
import [Link];
import [Link];
import [Link].*;
public class AllPractical extends JFrame{
JTextField
textfield_id,textfield_name,textfield_author,textfield_price,textfield_bn,textfield_edition;
JLabel label_id,label_name,label_author,label_price,label_bn,label_edition;
JButton button_save,button_retrive,button_Exit;
JTextArea textarea_d;
public AllPractical()
{
setLayout(null);
label_id=new JLabel("Book Id");
label_id.setBounds(10,10,100,30);
textfield_id=new JTextField(20);
textfield_id.setBounds(120,10,200,30);

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 8


NAME:SIDDESH KHARADE ROLL NO.:92

label_name=new JLabel("Book Name");


label_name.setBounds(10,50,100,30);
textfield_name=new JTextField(20);
textfield_name.setBounds(120,50,200,30);

label_author=new JLabel("Author");
label_author.setBounds(10,110,100,30);
textfield_author=new JTextField(20);
textfield_author.setBounds(120,110,200,30);

label_price=new JLabel("price");
label_price.setBounds(10,160,100,30);
textfield_price=new JTextField(20);
textfield_price.setBounds(120,160,200,30);

label_bn=new JLabel("isbn_no");
label_bn.setBounds(10,220,100,30);
textfield_bn=new JTextField(20);
textfield_bn.setBounds(120,220,200,30);

label_edition=new JLabel("Book Edition");


label_edition.setBounds(10,270,100,30);
textfield_edition=new JTextField(20);
textfield_edition.setBounds(120,270,200,30);

button_save=new JButton("Save");
button_save.setBounds(10,400,100,50);
button_retrive=new JButton("Retrive");
button_retrive.setBounds(120,400,100,50);

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 9


NAME:SIDDESH KHARADE ROLL NO.:92

button_Exit=new JButton("Exit");
button_Exit.setBounds(240,400,100,50);

textarea_d=new JTextArea(5,30);
textarea_d.setBounds(50,320,300,70);
JScrollPane sp1=new JScrollPane(textarea_d);

add(label_id);add(textfield_id);
add(label_name);add(textfield_name);
add(label_author);add(textfield_author);
add(label_price);add(textfield_price);
add(label_bn);add(textfield_bn);
add(label_edition);add(textfield_edition);
add(textarea_d);add(button_retrive);add(button_save);add(button_Exit);
button_save.addActionListener(new ActionListener(){
@Override
public void actionPerformed(ActionEvent e) {
try{
[Link]("[Link]");
String url="jdbc:mysql://localhost:3306/adv_java";
String username="root",pass="";
Connection conn=[Link](url,username,pass);
String sql="insert into Library(bid,bname,author,bprice,bn_no,bedition)
values(?,?,?,?,?,?)";
PreparedStatement pr=[Link](sql);
int id=[Link](textfield_id.getText());
String name,author,price,bn_no,edition;
name=textfield_name.getText();
author=textfield_author.getText();
price=textfield_price.getText();

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 10


NAME:SIDDESH KHARADE ROLL NO.:92

bn_no=textfield_bn.getText();
edition=textfield_edition.getText();
[Link](1,id);
[Link](2,name);
[Link](3,author);
[Link](4,price);
[Link](5,bn_no);
[Link](6,edition);
[Link]();
[Link]();
[Link]();
}
catch(Exception ex){
[Link]("ERROR:"+[Link]());
}
}
});

button_Exit.addActionListener(new ActionListener(){
@Override
public void actionPerformed(ActionEvent e) {
dispose();
}
});
button_retrive.addActionListener(new ActionListener(){
@Override
public void actionPerformed(ActionEvent e) {
try{
[Link]("[Link]");
String url="jdbc:mysql://localhost:3306/adv_java";

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 11


NAME:SIDDESH KHARADE ROLL NO.:92

String username="root",pass="";
Connection conn=[Link](url,username,pass);
Statement stmt=[Link]();
ResultSet rs=[Link]("select * from Library");
while([Link]())
[Link]([Link](1)+" "+[Link](2)+" "+[Link](3));
[Link]();
}
catch(Exception ex){
[Link]("ERROR:"+[Link]());
}
}
});

setSize(400,500);
setVisible(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
}
public static void main(String args[])
{
new AllPractical();
}
}
Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 12


NAME:SIDDESH KHARADE ROLL NO.:92

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 13


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.4
Aim: Develop Java application to store image in a database as well as retrieve image from
database.
Source Code:
 [Link]
import [Link].*;
import [Link];
import [Link];
import [Link].*;
import [Link];
import [Link];

public class imageDemo extends [Link] {


public imageDemo() {
initComponents();
}

String path=null;
public void save()
{
try {
FileInputStream fis=null;
File img=null;
img=new File(path);
fis=new FileInputStream(img);
if(new DBClass().add(img, fis))
{

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 14


NAME:SIDDESH KHARADE ROLL NO.:92

[Link](null,"Image Saved successfully");


[Link](null);
}
else
{
[Link](null,"Image Not saved");
}

}catch(Exception ex){}
}

public void retrieve()


{
String id=new DBClass().retrieve();
if(! [Link]("-1"))
{
[Link](null,"Image Retrieved");
[Link]( new ImageIcon(id+".sjpg"));
}
else
{
[Link](null,"Not Retrieved");
}

@SuppressWarnings("unchecked")

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 15


NAME:SIDDESH KHARADE ROLL NO.:92

// <editor-fold defaultstate="collapsed" desc="Generated Code">


private void initComponents() {

jLabel1 = new [Link]();


jLabel2 = new [Link]();
jButton1 = new [Link]();
jButton2 = new [Link]();
jButton3 = new [Link]();
jButton4 = new [Link]();

setDefaultCloseOperation([Link].EXIT_ON_CLOSE);

[Link]("db_label");

[Link]("select_label");

[Link]("Browse");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton1ActionPerformed(evt);
}
});

[Link]("Save");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton2ActionPerformed(evt);

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 16


NAME:SIDDESH KHARADE ROLL NO.:92

}
});

[Link]("Retrieve");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
jButton3ActionPerformed(evt);
}
});

[Link]("Clear");

[Link] layout = new [Link](getContentPane());


getContentPane().setLayout(layout);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(19, 19, 19)

.addGroup([Link]([Link])
.addGroup([Link]()
.addComponent(jLabel1, [Link].PREFERRED_SIZE, 136,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel2, [Link].PREFERRED_SIZE, 130,
[Link].PREFERRED_SIZE)
.addGap(27, 27, 27))
.addGroup([Link]()

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 17


NAME:SIDDESH KHARADE ROLL NO.:92

.addComponent(jButton2, [Link].PREFERRED_SIZE, 67,


[Link].PREFERRED_SIZE)
.addGap(28, 28, 28)
.addComponent(jButton3)
.addGap(64, 64, 64)

.addGroup([Link]([Link],
false)
.addComponent(jButton1, [Link].DEFAULT_SIZE, 83,
Short.MAX_VALUE)
.addComponent(jButton4, [Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE))
.addGap(84, 84, 84))))
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(26, 26, 26)

.addGroup([Link]([Link])
.addComponent(jLabel1, [Link].PREFERRED_SIZE, 120,
[Link].PREFERRED_SIZE)
.addComponent(jLabel2, [Link].PREFERRED_SIZE, 120,
[Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addComponent(jButton1, [Link].PREFERRED_SIZE, 31,
[Link].PREFERRED_SIZE)
.addGap(18, 18, 18)

.addGroup([Link]([Link])
.addComponent(jButton2)

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 18


NAME:SIDDESH KHARADE ROLL NO.:92

.addComponent(jButton3)
.addComponent(jButton4))
.addContainerGap(71, Short.MAX_VALUE))
);

pack();
}// </editor-fold>

private void jButton1ActionPerformed([Link] evt) {


FileDialog fd=new FileDialog(this);
[Link]();
path=[Link]()+[Link]();
[Link](new ImageIcon(path));
}

private void jButton2ActionPerformed([Link] evt) {


[Link]();
}

private void jButton3ActionPerformed([Link] evt) {


[Link]();
}

/**
* @param args the command line arguments
*/
public static void main(String args[]) {

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 19


NAME:SIDDESH KHARADE ROLL NO.:92

/* Set the Nimbus look and feel */


//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and
feel.
* For details see
[Link]
*/
try {
for ([Link] info :
[Link]()) {
if ("Nimbus".equals([Link]())) {
[Link]([Link]());
break;
}
}
} catch (ClassNotFoundException ex) {

[Link]([Link]()).log([Link]
.SEVERE, null, ex);
} catch (InstantiationException ex) {

[Link]([Link]()).log([Link]
.SEVERE, null, ex);
} catch (IllegalAccessException ex) {

[Link]([Link]()).log([Link]
.SEVERE, null, ex);
} catch ([Link] ex) {

[Link]([Link]()).log([Link]
.SEVERE, null, ex);
}

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 20


NAME:SIDDESH KHARADE ROLL NO.:92

//</editor-fold>

/* Create and display the form */


[Link](new Runnable() {
public void run() {
new imageDemo().setVisible(true);
}
});
}
private [Link] jButton1;
private [Link] jButton2;
private [Link] jButton3;
private [Link] jButton4;
private [Link] jLabel1;
private [Link] jLabel2;
// End of variables declaration
}

 Design:

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 21


NAME:SIDDESH KHARADE ROLL NO.:92

 [Link]
package imagedb1;

import [Link].*;

import [Link].*;

public class DBClass

String username="root";

String url="jdbc:mysql://localhost:3306/db2";

String pass="12345";

public Boolean add(File img,FileInputStream fis)

try{

String sql="insert into imagedb(Image) values(?)";

Connection con= [Link](url,username,pass);

PreparedStatement ps=[Link](sql);

[Link](1, fis,(int)[Link]());

[Link]();

return true;

}catch(Exception ex){

return false;

public String retrieve()

try{

FileOutputStream fos=null;

String sql="select * from imagedb";

Connection con=[Link](url,username,pass);

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 22


NAME:SIDDESH KHARADE ROLL NO.:92

PreparedStatement ps=[Link](sql);

ResultSet rs=[Link]();

[Link]();

Blob b=[Link]("Image");

String id=[Link]("ID");

fos=new FileOutputStream(id+".jpg");

int len=(int)[Link]();

byte[]buf=[Link](1, len);

[Link](buf,0,len);

return id;

}catch(Exception ex){}

return "-1";

Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 23


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.5
Aim: Write a Java application to demonstrate servlet life cycle.
Source Code:
 [Link]
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;

public class helloServlet extends HttpServlet


{

protected void doGet(HttpServletRequest request,HttpServletResponse response)


throws ServletException, IOException
{
PrintWriter out = [Link]();
try {
String a,b,c;
String url="jdbc:mysql://localhost:3306/student";
String username="root";
String pass="12345";
a=[Link]("rollno");
b=[Link]("sname");
c=[Link]("STD");
[Link]("[Link]");
Connection con=[Link](url,username,pass);
PreparedStatement p=[Link]("insert into student values(?,?,?)");
[Link](1,a);
[Link](2,b);
[Link](3,c);
[Link]();
ResultSet rs=[Link]("Select * from student");
[Link]("<table border=1
width=50%><tr><th>Rollno</th><th>Sname</th><th>STD</th></tr>");
while([Link]())
{
[Link]("<tr>");
[Link]("<td>"+[Link](1)+"</td>");
[Link]("<td>"+[Link](2)+"</td>");
[Link]("<td>"+[Link](3)+"<td>");
[Link]("</tr>");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 24


NAME:SIDDESH KHARADE ROLL NO.:92

[Link]("</table>");
} catch(Exception ex){

[Link]("ggg="+[Link]());
}
}
}

[Link]
<body>
<form action="helloServlet">
Enter Roll No:<input type="text" name="rollno"><br>
Enter Sname:<input type="text" name="sname"><br>
Enter STD:<input type="text" name="STD"><br>
<input type="submit" name="btn" value="SAVE"><br>
</form>
</body>
</html>

Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 25


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.6
Aim: Design database for student administration. Develop servlet(s) to perform CRUD
operations.
Source Code:
<%@page contentType="text/html" import="[Link].*" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>CRUD Operation</title>
</head>
<body>
<form action="[Link]">
ROLL NO:<input type="text" name="roll"><br>
NAME:<input type="text" name="name"><br>
STD:<input type="text" name="std"><br>
<input type="submit" name="btn1" value="CREATE">
<input type="submit" name="btn2" value="READ"><br><br>
<input type="submit" name="btn3" value="UPDATE">
<input type="submit" name="btn4" value="DELETE"><br>

</form>
<%
int a;
String b,c,id;
String url="jdbc:mysql://localhost:3306/adv_java";
String username="root";
String pass="";
try{

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 26


NAME:SIDDESH KHARADE ROLL NO.:92

if([Link]("btn1").equals("CREATE")){
a=[Link]([Link]("roll"));
b=[Link]("name");
c=[Link]("std");
[Link]("[Link]");
Connection con=[Link](url, username, pass);
PreparedStatement p=[Link]("insert into student
values(?,?,?)");
[Link](1,a);
[Link](2,b);
[Link](3,c);
[Link]();
}
}catch(Exception ex){
[Link]([Link]());
}
try{
if([Link]("btn2").equals("READ")){
[Link]("[Link]");
Connection con=[Link](url, username, pass);
Statement p=[Link]();
ResultSet rs=[Link]("select * from student");
[Link]("<table border=1 width='60%'><tr><th>Roll
No</th><th>Name</th><th>STD</th></tr>");
while([Link]()){
[Link]("<tr>");
[Link]("<td>"+[Link](1)+"</td>");
[Link]("<td>"+[Link](2)+"</td>");
[Link]("<td>"+[Link](3)+"</td>");
[Link]("</tr>");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 27


NAME:SIDDESH KHARADE ROLL NO.:92

}
[Link]("</table>");
}

}catch(Exception ex){
[Link]([Link]());
}
try{
if([Link]("btn3").equals("UPDATE")){
a=[Link]([Link]("roll"));
b=[Link]("name");
c=[Link]("std");
[Link]("[Link]");
Connection con=[Link](url, username, pass);
PreparedStatement p=[Link]("update student set
rollno=?,sname=?,std=? where rollno=?");
[Link](1,a);
[Link](2,b);
[Link](3,c);
[Link](4,a);
[Link]();
}
}catch(Exception ex){
[Link]([Link]());
}

try{
if([Link]("btn4").equals("DELETE")){
id=[Link]("roll");
[Link]("[Link]");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 28


NAME:SIDDESH KHARADE ROLL NO.:92

Connection con=[Link](url, username, pass);


Statement st=[Link]();
[Link]("delete from student where rollno='"+id+"'");
}
}catch(Exception ex){
[Link]([Link]());
}
%>
</body>
</html>
Output:-
After Run:-

After Create:

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 29


NAME:SIDDESH KHARADE ROLL NO.:92

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 30


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.7
Aim: Create Employees table in EMP database. Perform select, insert, update, and delete
operations on Employee table using JSP.
Source Code:
<%@page contentType="text/html" import="[Link].*" 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]">

Enter EmpNo:<input type="text" name="eno"><br>

Enter Ename:<input type="text" name="ename"><br>

Enter Salary:<input type="text" name="sal"><br>

<input type="submit" name="btn1" value="SAVE">

<input type="submit" name="btn2" value="DELETE"><br>

</form>

<%

int a;

String b,c,id;

String url="jdbc:mysql://localhost:3306/adv_java";

String username="root";

String pass="";

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 31


NAME:SIDDESH KHARADE ROLL NO.:92

try{

if([Link]("btn1").equals("SAVE")){

a=[Link]([Link]("eno"));

b=[Link]("ename");

c=[Link]("sal");

[Link]("[Link]");

Connection con=[Link](url, username, pass);

PreparedStatement p=[Link]("insert into emp values(?,?,?)");

[Link](1,a);

[Link](2,b);

[Link](3,c);

[Link]();

ResultSet rs=[Link]("select * from emp");

[Link]("<table border=1
width='60%'><tr><th>Empno</th><th>Ename</th><th>Salary</th></tr>");

while([Link]()){

[Link]("<tr>");

[Link]("<td>"+[Link](1)+"</td>");

[Link]("<td>"+[Link](2)+"</td>");

[Link]("<td>"+[Link](3)+"</td>");

[Link]("</tr>");

[Link]("</table>");

}catch(Exception ex){

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 32


NAME:SIDDESH KHARADE ROLL NO.:92

[Link]([Link]());

try{

if([Link]("btn2").equals("DELETE")){

id=[Link]("eno");

[Link]("[Link]");

Connection con=[Link](url, username, pass);

Statement st=[Link]();

[Link]("delete from emp where id='"+id+"'");

}catch(Exception ex){

[Link]([Link]());

%>

</body>

</html>

Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 33


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.8
Aim: Write a Student class with three properties. The useBean action declares a JavaBean
for use in a JSP. Write Java application to access JavaBeans Properties.
Source Code:

 HTML Code:

<html>

<head>

<title>TODO supply a title</title>

<meta charset="UTF-8">

<meta name="viewport" content="width=device-width, initial-scale=1.0">

</head>

<body>

<h1>Student database</h1>

<form action="[Link]">

<table border="1">

<tr>

<td>RollNo:</td>

<td><input type="text" name="rollno"></td>

</tr>

<tr>

<td>SName</td>

<td><input type="text" name="sname"></td>

</tr>

<tr>

<td>Mobile:</td>

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 34


NAME:SIDDESH KHARADE ROLL NO.:92

<td><input type="text" name="mobile"></td>

</tr>

<tr>

<td><input type="submit" value="Submit"></td>

<td><input type="reset" value="Clear"></td>

</tr>

</table>

</form>

</body>

</html>

JSP Code:

<%@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>

<h1>Student Details</h1>

<hr color="black" size="5">

<jsp:useBean id="stud" scope="session" class="[Link]">

</jsp:useBean>

<jsp:setProperty name="stud" property="*"></jsp:setProperty>

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 35


NAME:SIDDESH KHARADE ROLL NO.:92

<jsp:getProperty name="stud" property="rollno"/>

<br>

Sname:<jsp:getProperty name="stud" property="sname"/>

<br>

Mobile<jsp:getProperty name="stud" property="mobile"/>

<br>

<hr>

</body>

</html>

 Java Code

package studBean;

public class student{

int rollno;

String sname,mobile;S

public int getRollno(){

return rollno;

public void setRollno(int n) {

[Link]=n;

public String getSname(){

return sname;

public void setSname(String str){

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 36


NAME:SIDDESH KHARADE ROLL NO.:92

[Link]=str;

public String getMobile(){

return mobile;

public void setMobile(String no) {

[Link]=no;

Outputs:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 37


NAME:SIDDESH KHARADE ROLL NO.:92

PRACTICAL NO.9
Aim: Write Java application to encoding and decoding JSON in Java.
CONFIGURE:

Source Code:

 Encode
package allpractical;
import [Link];
import [Link];
import [Link].*;
public class EncoderJson {
public static void main(String a[])throws IOException{
JSONObject js=new JSONObject();
[Link]("Roll No.",new Integer(21));
[Link]("Name", "Ashish");
[Link]("STD","SYCS");
[Link]("Mark",new Double(87.45));
[Link]("pass",new Boolean(true));
StringWriter st=new StringWriter();
[Link](st);
String jt=[Link]();
[Link](jt);
}

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 38


NAME:SIDDESH KHARADE ROLL NO.:92

Output:-

 B. Decode
import [Link];
import [Link];
import [Link];
import [Link];

public class JsonDecodeDemo {


public static void main(String [] args){
JSONParser parser=new JSONParser();
String s="[0,{\"1\":{\"2\":{\"3\":{\"4\":[5,:{\"6\":7}]}}}}]";

try{
Object obj=[Link](s);
JSONArray array=(JSONArray)obj;

[Link]("The 2nd element of array");


[Link]([Link](1));
[Link]();

JSONObject obj2=(JSONObject)[Link](1);
[Link]("Field \"1\"");

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 39


NAME:SIDDESH KHARADE ROLL NO.:92

[Link]([Link](1));

s="{}";
obj=[Link](s);
[Link](obj);

s="[5,]";
obj=[Link](s);
[Link](obj);

s="[5,2]";
obj=[Link](s);
[Link](obj);

}catch (ParseException pe){


[Link]("position: "+[Link]());
[Link](pe);
}
}
}

Output:-

ADVANCED JAVA [Link].(COMPUTER SCIENCE)SEM-IV pg. 40

You might also like