JSP CRUD Example

We can easily create CRUD Example in JSP. Here, we are using DAO files for database and JSTL for traversing records.

Download jstl.jar and mysql-connector.jar Download jstl1.2.jar file
Download mysql-connector.jar

Download SQL File to Import in MySQL Download SQL File

Download Project download CRUD project in JSP

CRUD Example

Directory Structure in Eclipse

index.jsp

    <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>JSP CRUD Example</title>   
<h1>JSP CRUD Example</h1>
<p> <a href="../adduserform.jsp">Add User</a> <a href="../viewusers.jsp">View Users</a>    </p>

adduserform.jsp

    <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>Add User Form</title>        

userform.html

<a href="../viewusers.jsp">View All Records</a>  
<h1>Add New User</h1>
<form action="adduser.jsp" method="post">
<table>
<tr>
<td>Name:</td>
<td><input name="name" type="text"></td>
</tr>
<tr>
<td>Password:</td>
<td> <input name="password" type="password"></td>
</tr>
<tr>
<td>Email:</td>
<td><input name="email" type="email"></td>
</tr>
<tr>
<td>Sex:</td>
<td> <input name="sex" type="radio" value="male">Male  <input name="sex" type="radio" value="female">Female </td>
</tr>
<tr>
<td>Country:</td>
<td> <select name="country" style="width:155px"><option>India</option><option>Pakistan</option><option>Afghanistan</option><option>Berma</option><option>Other</option></select> </td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Add User"></td>
</tr>
</table></form>
<p> </p>

adduser.jsp

<%@page import=”com.tutoraspire.dao.UserDao”%>    <% int i=UserDao.save(u); if(i>0){ response.sendRedirect(“adduser-success.jsp”); }else{ response.sendRedirect(“adduser-error.jsp”); } %> 

User.java

 package com.tutoraspire.bean; public class User { private int id; private String name,password,email,sex,country; //generate getters and setters } 

UserDao.java

 package com.tutoraspire.dao; import java.sql.*; import java.util.ArrayList; import java.util.List; import com.tutoraspire.bean.User; public class UserDao {  public static Connection getConnection(){ Connection con=null; try{ Class.forName(“com.mysql.jdbc.Driver”); con=DriverManager.getConnection(“jdbc:mysql://localhost:3306/test”,””,””); }catch(Exception e){System.out.println(e);} return con; } public static int save(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement( “insert into register(name,password,email,sex,country) values(?,?,?,?,?)”); ps.setString(1,u.getName()); ps.setString(2,u.getPassword()); ps.setString(3,u.getEmail()); ps.setString(4,u.getSex()); ps.setString(5,u.getCountry()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e);} return status; } public static int update(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement( “update register set name=?,password=?,email=?,sex=?,country=? where id=?”); ps.setString(1,u.getName()); ps.setString(2,u.getPassword()); ps.setString(3,u.getEmail()); ps.setString(4,u.getSex()); ps.setString(5,u.getCountry()); ps.setInt(6,u.getId()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e);} return status; } public static int delete(User u){ int status=0; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement(“delete from register where id=?”); ps.setInt(1,u.getId()); status=ps.executeUpdate(); }catch(Exception e){System.out.println(e);}  return status; } public static List getAllRecords(){ List list=new ArrayList();  try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement(“select * from register”); ResultSet rs=ps.executeQuery(); while(rs.next()){ User u=new User(); u.setId(rs.getInt(“id”)); u.setName(rs.getString(“name”)); u.setPassword(rs.getString(“password”)); u.setEmail(rs.getString(“email”)); u.setSex(rs.getString(“sex”)); u.setCountry(rs.getString(“country”)); list.add(u); } }catch(Exception e){System.out.println(e);} return list; } public static User getRecordById(int id){ User u=null; try{ Connection con=getConnection(); PreparedStatement ps=con.prepareStatement(“select * from register where id=?”); ps.setInt(1,id); ResultSet rs=ps.executeQuery(); while(rs.next()){ u=new User(); u.setId(rs.getInt(“id”)); u.setName(rs.getString(“name”)); u.setPassword(rs.getString(“password”)); u.setEmail(rs.getString(“email”)); u.setSex(rs.getString(“sex”)); u.setCountry(rs.getString(“country”)); } }catch(Exception e){System.out.println(e);} return u; } } 

adduser-success.jsp

    <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>Add User Success</title>    
<p>Record successfully saved!</p>
<p>     </p>

adduser-error.jsp

    <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>Add User Error</title>    
<p>Sorry, an error occurred!</p>
<p>     </p>

viewusers.jsp

     <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>View Users</title>    <%@page import=”com.tutoraspire.dao.UserDao,com.tutoraspire.bean.*,java.util.*”%> <%@ taglib uri=”http://java.sun.com/jsp/jstl/core” prefix=”c”%>  
<h1>Users List</h1>
<p>  <% List list=UserDao.getAllRecords(); request.setAttribute(“list”,list); %>  </p>
<table border="1" width="90%">
<tr>
<th>Id</th>
<th>Name</th>
<th>Password</th>
<th>Email</th>
<th>Sex</th>
<th>Country</th>
<th>Edit</th>
<th>Delete</th>
</tr>
<tr>
<td>${u.getId()}</td>
<td>${u.getName()}</td>
<td>${u.getPassword()}</td>
<td>${u.getEmail()}</td>
<td>${u.getSex()}</td>
<td>${u.getCountry()}</td>
<td><a href="../editform.jsp?id=%24%7Bu.getId()%7D">Edit</a></td>
<td><a href="../deleteuser.jsp?id=%24%7Bu.getId()%7D">Delete</a></td>
</tr>
</table>
<p><a href="../adduserform.jsp">Add New User</a>    </p>

editform.jsp

    <meta content="text/html; charset=utf-8" http-equiv="Content-Type"> <title>Edit Form</title>   <%@page import=”com.tutoraspire.dao.UserDao,com.tutoraspire.bean.User”%>  <% String id=request.getParameter(“id”); User u=UserDao.getRecordById(Integer.parseInt(id)); %>  
<h1>Edit Form</h1>
<form action="edituser.jsp" method="post"> <input name="id" type="hidden" value="<%=u.getId() %>"> 
<table>
<tr>
<td>Name:</td>
<td> <input name="name" type="text" value="<%= u.getName()%>"></td>
</tr>
<tr>
<td>Password:</td>
<td> <input name="password" type="password" value="<%= u.getPassword()%>"></td>
</tr>
<tr>
<td>Email:</td>
<td> <input name="email" type="email" value="<%= u.getEmail()%>"></td>
</tr>
<tr>
<td>Sex:</td>
<td> <input name="sex" type="radio" value="male">Male  <input name="sex" type="radio" value="female">Female </td>
</tr>
<tr>
<td>Country:</td>
<td> <select name="country"><option>India</option><option>Pakistan</option><option>Afghanistan</option><option>Berma</option><option>Other</option></select> </td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Edit User"></td>
</tr>
</table></form>
<p>    </p>

edituser.jsp

<%@page import=”com.tutoraspire.dao.UserDao”%>   <% int i=UserDao.update(u); response.sendRedirect(“viewusers.jsp”); %> 

deleteuser.jsp

<%@page import=”com.tutoraspire.dao.UserDao”%>   <% UserDao.delete(u); response.sendRedirect(“viewusers.jsp”); %> 

Download Project download CRUD project in JSP

Output
Next TopicRegistration Form in JSP

CRUD in JSP

JSP CRUD Example

Download jstl.jar and mysql-connector.jar Download jstl1.2.jar file Download mysql-connector.jar

Download SQL File to Import in MySQL Download SQL File

Download Project download CRUD project in JSP

CRUD Example

Download Project download CRUD project in JSP

PHP JSON

Best Android Emulator for Kali Linux

You may also like

Download jstl.jar and mysql-connector.jar Download jstl1.2.jar file
Download mysql-connector.jar