Building web applications has become more dynamic with the integration of Java Server Pages (JSP) and Asynchronous JavaScript and XML (AJAX). This combination enables developers to create robust CRUD (Create, Read, Update, Delete) applications that enhance user experience through seamless interactions. In this blog post, we will explore the fundamentals of a JSP AJAX CRUD application, highlighting its benefits and how to implement it.
The use of JSP for server-side processing, coupled with AJAX for client-side interactions, allows developers to construct applications that respond quickly without the need for full page reloads. This not only improves performance but also enhances usability, making CRUD operations appear more fluid and intuitive. Moreover, incorporating AJAX into a JSP application simplifies data handling and allows for real-time updates, significantly boosting overall user satisfaction.
To create a JSP AJAX CRUD application, start by setting up a basic JSP framework. Next, implement AJAX calls using JavaScript or jQuery to handle data requests to the server. Create JSP pages to serve as views for data entry and display. For the CRUD functionality, ensure that your application can handle SQL operations effectively to manipulate the data stored in your database. The integration of JSP and AJAX ideally culminates in a smooth workflow and enhances data management capabilities.
<%@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>
<link href="bootstrap/css/bootstrap.css" rel="stylesheet" type="text/css"/>
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
<link href="datatable/datatables.min.css" rel="stylesheet" type="text/css"/>
</head>
<body>
<nav class="navbar navbar-dark bg-dark">
<h3 style="color:white;">Student Management Crud Ajax</h3>
</nav>
</br>
<div class="container">
<div class="row">
<div class="col-sm-4">
<form id="frmStudent" name="frmStuent">
<div class="form-group" align="left">
<label>Student Name</label>
<input type="text" id="stname" name="stname" placeholder="Student Name" class="form-control" required>
</div>
<div class="form-group" align="left">
<label>Course</label>
<input type="text" id="course" name="course" placeholder="Course" class="form-control" required>
</div>
<div class="form-group" align="left">
<label>Fee</label>
<input type="text" id="fee" name="fee" placeholder="Fee" class="form-control" required>
</div>
<div class="form-group" align="left">
<button type="button" class="btn btn-success" id="save" >
addstudent.jsp
<%@page import="org.json.simple.JSONObject"%>
<%@page import="org.json.simple.JSONArray"%>
<%@page import="java.sql.*" %>
<%
JSONArray list = new JSONArray();
String studentname = request.getParameter("stname");
String course = request.getParameter("course");
int fee = Integer.parseInt(request.getParameter("fee"));
Connection con;
PreparedStatement pst;
try
{
JSONObject obj = new JSONObject();
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
pst = con.prepareStatement("insert into records(stname,course,fee)values(?,?,?)");
pst.setString(1, studentname);
pst.setString(2, course);
pst.setInt(3, fee);
pst.executeUpdate();
obj.put("name", "success");
list.add(obj);
out.println(list.toJSONString());
out.flush();
}
catch(Exception ex)
{
}
%> all_student.jsp
<%@page import="org.json.simple.JSONObject"%>
<%@page import="org.json.simple.JSONArray"%>
<%@page import="java.sql.*" %>
<%
JSONArray list = new JSONArray();
Connection con;
PreparedStatement pst;
ResultSet rs;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
String query = "select * from records";
Statement stmt = con.createStatement();
rs = stmt.executeQuery(query);
while(rs.next())
{
JSONObject obj = new JSONObject();
int id = rs.getInt("id");
String stname = rs.getString("stname");
String course = rs.getString("course");
int fee = rs.getInt("fee");
obj.put("id", id);
obj.put("stname", stname);
obj.put("course", course);
obj.put("fee", fee);
list.add(obj);
}
out.print(list.toJSONString());
out.flush();
}
catch(Exception ex)
{
}
%> edit_return.jsp
<%@page import="org.json.simple.JSONObject"%>
<%@page import="org.json.simple.JSONArray"%>
<%@page import="java.sql.*"%>
<%
JSONArray list = new JSONArray();
Connection con;
PreparedStatement pst;
ResultSet rs;
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
int id = Integer.parseInt(request.getParameter("id"));
pst = con.prepareStatement("select id,stname,course,fee from records where id= ?");
pst.setInt(1, id);
rs = pst.executeQuery();
if(rs.next() == true)
{
int id1 = rs.getInt("id");
String stname = rs.getString("stname");
String course = rs.getString("course");
int fee = rs.getInt("fee");
JSONObject obj = new JSONObject();
obj.put("id", id1);
obj.put("stname", stname);
obj.put("course", course);
obj.put("fee", fee);
list.add(obj);
}
out.print(list.toJSONString());
out.flush();
}
catch(Exception ex)
{
}
%> editstudent.jsp
<%@page import="org.json.simple.JSONObject"%>
<%@page import="org.json.simple.JSONArray"%>
<%@page import="java.sql.*"%>
<%
JSONArray list = new JSONArray();
String stname = request.getParameter("stname");
String course = request.getParameter("course");
int fee = Integer.parseInt(request.getParameter("fee"));
int studid = Integer.parseInt(request.getParameter("studid"));
Connection con;
PreparedStatement pst;
try
{
JSONObject obj = new JSONObject();
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
pst = con.prepareStatement("update records set stname=?,course=?,fee=? where id = ?");
pst.setString(1, stname);
pst.setString(2, course);
pst.setInt(3, fee);
pst.setInt(4, studid);
pst.executeUpdate();
obj.put("name", "success");
list.add(obj);
out.println(list.toJSONString());
out.flush();
}
catch(Exception ex)
{
}
%>
delete_student.jsp
<%@page import="org.json.simple.JSONObject"%>
<%@page import="org.json.simple.JSONArray"%>
<%@page import="java.sql.*"%>
<%
JSONArray list = new JSONArray();
Connection con;
PreparedStatement pst;
int id = Integer.parseInt(request.getParameter("id"));
try
{
JSONObject obj = new JSONObject();
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/studcrud","root","");
pst = con.prepareStatement("delete from records where id = ?");
pst.setInt(1, id);
pst.executeUpdate();
obj.put("name", "Success");
list.add(obj);
out.println(list.toJSONString());
out.flush();
}
catch(Exception ex)
{
}
%> I attached the Video Below.do the work while watching the Video
Relationships: Hotel ↔ Rooms (One-to-Many) A hotel can have many rooms, but a room belongs…
Introduction to Grocery Inventory Apps Managing grocery inventory can be a daunting task, but with…
This article explain how to make a Fish Inventory Management App in Angular.this app explain…
Introduction to Fish Inventory Management In the aquaculture industry, managing fish inventory is crucial for…
Introduction to Java GUI CRUD Java is a powerful programming language widely used for building…
Introduction to Login Form Design Designing an effective and beautiful login form is crucial for…