DEPARTMENT OF

COMPUTER SCIENCE & ENGINEERING

Experiment- 3.2

Student Name: Lakshay Sindhu UID: 21BCS10420

Branch: CSE Section/Group: 21BCS CC 628 - B
Semester: 6th (Sixth) Date of Performance: 28/03/24
Subject Name: Project Based Learning in Java Lab Subject Code: 21CSH-319

1. Aim : Create an application for online auction using Servlet and JSP.

2. Objective : To learn about Java Server Pages JSP.

• To learn about various JSP tags.

3. Procedure :
1. Begin by initiating a Dynamic Web Project in Eclipse IDE.
2. Develop a JSP le within the project.
3. Launch the Tomcat server and deploy the project.
4. Initiate a Dynamic Web Project.
5. Develop a JSP le.
6. 6. Launch the Tomcat server and deploy the project..

4. Code and Output :

Program Code :
package [Link];
import [Link].*;
import [Link];
import [Link];
import [Link].*;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
fi
fi
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

import [Link];
import [Link];
import [Link].*;
import [Link];
import [Link];
import [Link];
public
class Admin {
private JButton startButton;
private JLabel timerLabel;
privateJPanel adminPanel;
private JButton ADDITEMButton;
Private JTable table1;
private JTextField nameData;
private JTextField priceData;
private JTextField path;
private JButton SELECTIMAGEButton;
private JLabel imageLabel;
private JButton CLOSEButton;
public static String adminNameData = "";
public static String adminPriceData = "";
public static ImageIcon adminImageData;
JFrame adminF = new JFrame();
Timer timer;
public static int sec = 60;
public Admin() {
[Link](adminPanel);
[Link]();
tableData();
[Link](true);
[Link](new ActionListener() {
@Override public void actionPerformed(ActionEvent e) {
startTimer();
[Link]();
}
});
[Link](new ActionListener() {
@Override public void actionPerformed(ActionEvent e) {
if ([Link]().equals("") || [Link]().equals("") ||
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

[Link]().equals("")) {
[Link](
null, "Please Fill All Fields to add Record.”);
} else {
String sql = "insert into auction" + "(ITEM_NAME,IMAGE,PRICE)" + "values
(?,?,?)";
try {
File f = new File([Link]());
InputStream inputStream = new FileInputStream(f);
[Link]("[Link]");
Connection connection = [Link](
"jdbc:mysql://localhost:3306/intern", "root", "root");
PreparedStatement statement = [Link](sql);
[Link](1, [Link]());
[Link](2, inputStream);
[Link](3, [Link]());
[Link]();
[Link](null, "DETAILS ADDED SUCCESSFULLY");
[Link]("");
[Link]("");
[Link](null);
[Link]("");
} catch (Exception ex) {
[Link](null, [Link]());
}
tableData();
}
}
});
[Link](new ActionListener() {
@Override public void actionPerformed(ActionEvent e) {
JFileChooser fileChooser = new JFileChooser();
FileNameExtensionFilter filter =
new FileNameExtensionFilter("*.IMAGE", "jpg", "png");
[Link](filter);
int rs = [Link](null);
if (rs == JFileChooser.APPROVE_OPTION) {
File selectedImage = [Link]();
[Link]([Link]());
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

[Link](resize([Link]()));
}
}
});
[Link](new MouseAdapter() {

@Override public void mouseClicked(MouseEvent e) {

DefaultTableModel dm = (DefaultTableModel)[Link]();
int selectedRow = [Link]();
adminNameData = [Link](selectedRow, 0).toString();
[Link](adminNameData);
byte[] img = (byte[])[Link](selectedRow, 1);
ImageIcon imageIcon = new ImageIcon(img);
Image im = [Link]();
Image newimg = [Link](200, 200, Image.SCALE_SMOOTH);
ImageIcon finalPic = new ImageIcon(newimg);
adminImageData = finalPic;
[Link](adminImageData);
adminPriceData = [Link](selectedRow, 2).toString();
[Link](adminPriceData);
}
});
[Link](new ActionListener() {
@Override public void actionPerformed(ActionEvent e) {
[Link]();
}
});
}
public
ImageIcon resize(String path) {
ImageIcon myImg = new ImageIcon(path);
Image image = [Link]();
Image newImage = [Link](200, 200, Image.SCALE_SMOOTH);
ImageIcon finalImage = new ImageIcon(newImage);
return finalImage;
}
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

public
void startTimer() {
timer = new Timer(
1000, new ActionListener() {
@Override public void actionPerformed(ActionEvent e) {
sec--;
if (sec == -1) {
[Link]();
tableData();
} else if (sec >= 0 && sec < 10)
[Link]("00:0" + sec);
else
[Link]("00:" + sec);
}
});
}
public
void tableData() {
try {
String a = "Select* from auction";
[Link]("[Link]");
Connection connection = [Link](
"jdbc:mysql://localhost:3306/intern", "root", "root");
Statement statement = [Link]();
ResultSet rs = [Link](a);
[Link](buildTableModel(rs));
} catch (Exception ex1) {
[Link](null, [Link]());
}
}
public
static DefaultTableModel buildTableModel(ResultSet rs) throws SQLException {
ResultSetMetaData metaData = [Link]();
// names of columns
Vector<String> columnNames = new Vector<String>();
int columnCount = [Link]();
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

for (int column = 1; column <= columnCount; column++) {

[Link]([Link](column));
}
// data of the table
Vector<Vector<Object>> data = new Vector<Vector<Object>>();
while ([Link]()) {
Vector<Object> vector = new Vector<Object>();
for (int columnIndex = 1; columnIndex <= columnCount; columnIndex++) {
[Link]([Link](columnIndex));
}
[Link](vector);
}
return new DefaultTableModel(data, columnNames);
}
}

Output :
 DEPARTMENT OF
COMPUTER SCIENCE & ENGINEERING

4. Learning Outcomes :

1. Learnt about JSP(Java Server Pages) and Servlet in Java .

2. Learnt about servlet in java.

3. Learnt about managing data within web application.

4. Learnt about Client-side and Server-side form validation to ensure data integrity.