Fetch.jsp
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body bgcolor="lightgreen">
<style>
.button{
padding: 5px;
width: 6%;
background: cornflowerblue;
color: white;
}
</style>
<h1 style="text-align: center"> Fetching single Record from database dynamically Using ArrayList</h1>
<form method="POST" action="fetch">
<center>
<br><br>
<table>
<tr>
<td> Student ID </td>
<td> <input type="text" name="sid" > </td>
</tr>
</table>
<div style="text-align: center;margin-left: 70px;margin-top: 10px;">
<input type="submit" name="submit" class="button" value="FETCH"/>
</div>
</center>
</form>
</body>
</html>
View.jsp
<%@page import="java.util.ArrayList"%>
<%@page import="model.student"%>
<%@page import="java.util.Iterator"%>
<%@page import="java.util.List"%>
<%@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 bgcolor="lightgreen">
<h1 style="text-align: center"> Single Record From Database </h1>
<style>
table,th,tr{
border:1px solid black;
}
th,td{
border-right:1px solid black;
}
</style>
<table align="center" width="800" style="border-collapse:collapse;cursor: default;">
<tr>
<TH bgcolor="#6CBFE8" >Studentid</TH>
<TH bgcolor="#6CBFE8" >NAME</TH>
<TH bgcolor="#6CBFE8">Marks</TH>
</tr>
<% ArrayList<student> mydata = (ArrayList) request.getAttribute("myArray");
Iterator<student> itr = mydata.iterator();
while (itr.hasNext()) {
student s = itr.next();%>
<tr>
<td align="center" width="15%"><%=s.getId()%></td>
<td align="center" width="15%"><%=s.getName()%></td>
<td align="center" width="15%"><%=s.getMarks()%></td>
</tr>
<%}%>
</table>
</body>
</html>
Fetch Servlet:
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import model.student;
@WebServlet(name = "fetch", urlPatterns = {"/fetch"})
public class fetch extends HttpServlet
{
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try
{
int sid = Integer.parseInt(request.getParameter("sid"));
student_impl s = new student_impl();
ArrayList<student> ar = s.getstudent_details(sid);
request.setAttribute("myArray", ar);
RequestDispatcher dispatcher = request.getRequestDispatcher("view.jsp");
dispatcher.forward(request, response);
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
Student_impl: class name
public class student_impl
{
Connection con;
Statement st;
ResultSet rs;
public student_impl()
{
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/student", "root", "root");
}
catch (Exception e)
{
e.printStackTrace();
}
}
public ArrayList<student> getstudent_details(int sid)
{
ArrayList<student> al = new ArrayList<student>();
try
{
st = con.createStatement();
String qry="select * from student where studentid='"+sid+"';";
rs = st.executeQuery(qry);
while (rs.next())
{
student p = new student();
p.setId(rs.getString("studentid"));
p.setName(rs.getString("sname"));
p.setMarks(rs.getString("smarks"));
al.add(p);
}
} catch (Exception e)
{
e.printStackTrace();
}
return al;
}
}
Class name: Student
public class student
{
String id;
String name;
String marks;
public String getId() {
return id;
}
public String getName() {
return name;
}
public String getMarks() {
return marks;
}
public void setId(String id) {
this.id = id;
}
public void setName(String name) {
this.name = name;
}
public void setMarks(String marks) {
this.marks = marks;
}
}
SQL:
create table student(
studentid int(10) NOT NULL AUTO_INCREMENT,
sname varchar(45) NOT NULL,
smarks varchar(45) NOT NULL,
PRIMARY KEY (studentid)
);
insert into student
values(0,'karthik','87');
(in the table student , the column studentid is primary key and it is auto incremented.
so while writing the query just enter 0 (zero) for the column. it wil be auto incremented in the table)
select * from student
