[go: up one dir, main page]
Scribd
Upload
3 views5 pages

JSP Connectivity

The document outlines the creation of a backend database connectivity process for an E-Learning application using JSP. It includes source code for performing insert, update, delete, and retrieve operations on a MySQL database. The implementation successfully connects to the database and handles course management functionalities.

Uploaded by

71762207035
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
3 views5 pages

JSP Connectivity

The document outlines the creation of a backend database connectivity process for an E-Learning application using JSP. It includes source code for performing insert, update, delete, and retrieve operations on a MySQL database. The implementation successfully connects to the database and handles course management functionalities.

Uploaded by

71762207035
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
You are on page 1/ 5

Ex.

No:8 JSP Connectivity – E-Learning


Application 7/4/2025

Create a backend database connectivity process in choosen application


using JSP Connectivity (Include insert ,delete,update and retrieve Operation )

AIM:
To create a backend database connectivity process in choosen
application using JSP Connectivity
SOURCE CODE:
app.js
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-
8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>E-Learning Platform</title>
<style>
table {
border-collapse: collapse;
width: 100%;
}
th, td {
padding: 8px;
text-align: left;
border-bottom: 1px solid #ddd;
}
body {
font-family: Arial, sans-serif;
}
h2, h3 {
color: #0066cc;
}
</style>
</head>
<body>
<!-- Form for Insert and Update -->
<h2>E-Learning Platform</h2>
<form method="post">
<input type="text" name="courseId" placeholder="Course ID" required><br><br>
<input type="text" name="courseName" placeholder="Course Name" required><br><br>
<select name="category" required>
<option value="Programming">Programming</option>
<option value="Mathematics">Mathematics</option>
<option value="Science">Science</option>
</select><br><br>
<input type="date" name="startDate" required><br><br>
<input type="text" name="instructor" placeholder="Instructor" required><br><br>
<input type="number" name="duration" placeholder="Duration (weeks)" required><br><br>
<input type="number" name="enrollment" placeholder="Enrollment" required><br><br>
<input type="submit" name="insert" value="Add Course">
<input type="submit" name="update" value="Update Course">
</form>

<!-- Database Operations -->


<%
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/elearning_db",
"root", "");

// INSERT Operation
if (request.getParameter("insert") != null) {
String courseId = request.getParameter("courseId");
String courseName = request.getParameter("courseName");
String category = request.getParameter("category");
String startDate = request.getParameter("startDate");
String instructor = request.getParameter("instructor");
int duration = Integer.parseInt(request.getParameter("duration"));
int enrollment = Integer.parseInt(request.getParameter("enrollment"));

PreparedStatement ps = con.prepareStatement(
"INSERT INTO courses (course_id, course_name, category, start_date, instructor, duration,
enrollment) VALUES (?, ?, ?, ?, ?, ?, ?)");
ps.setString(1, courseId);
ps.setString(2, courseName);
ps.setString(3, category);
ps.setString(4, startDate);
ps.setString(5, instructor);
ps.setInt(6, duration);
ps.setInt(7, enrollment);

int i = ps.executeUpdate();
if (i > 0) {
out.println("<p>Course added successfully!</p>");
} else {
out.println("<p>Failed to add course!</p>");
}
}

// UPDATE Operation
if (request.getParameter("update") != null) {
String courseId = request.getParameter("courseId");
String courseName = request.getParameter("courseName");
String category = request.getParameter("category");
String startDate = request.getParameter("startDate");
String instructor = request.getParameter("instructor");
int duration = Integer.parseInt(request.getParameter("duration"));
int enrollment = Integer.parseInt(request.getParameter("enrollment"));

PreparedStatement ps = con.prepareStatement(
"UPDATE courses SET course_name=?, category=?, start_date=?, instructor=?, duration=?,
enrollment=? WHERE course_id=?");
ps.setString(1, courseName);
ps.setString(2, category);
ps.setString(3, startDate);
ps.setString(4, instructor);
ps.setInt(5, duration);
ps.setInt(6, enrollment);
ps.setString(7, courseId);

int i = ps.executeUpdate();
if (i > 0) {
out.println("<p>Course updated successfully!</p>");
} else {
out.println("<p>Failed to update course!</p>");
}
}

// DELETE Operation
if (request.getParameter("deleteId") != null) {
String deleteId = request.getParameter("deleteId");
PreparedStatement ps = con.prepareStatement(
"DELETE FROM courses WHERE course_id=?");
ps.setString(1, deleteId);
int i = ps.executeUpdate();
if (i > 0) {
out.println("<p>Course deleted successfully!</p>");
} else {
out.println("<p>Failed to delete course!</p>");
}
}

// RETRIEVE Operation
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM courses");
%>
<h3>All Courses</h3>
<table>
<tr>
<th>ID</th>
<th>Name</th>
<th>Category</th>
<th>Start Date</th>
<th>Instructor</th>
<th>Duration (weeks)</th>
<th>Enrollment</th>
<th>Action</th>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td><%= rs.getString("course_id") %></td>
<td><%= rs.getString("course_name") %></td>
<td><%= rs.getString("category") %></td>
<td><%= rs.getString("start_date") %></td>
<td><%= rs.getString("instructor") %></td>
<td><%= rs.getInt("duration") %></td>
<td><%= rs.getInt("enrollment") %></td>
<td><a href="?deleteId=<%= rs.getString("course_id") %>" onclick="return confirm('Are you
sure you want to delete this course?')">Delete</a></td>
</tr>
<%
}
%>
</table>
<%
con.close();
} catch (Exception e) {
out.println("Error: " + e.getMessage());
e.printStackTrace();
}
%>
</body>
</html>

RESULT:
The jsp connectivity for the chosen application is done successfully.

You might also like