package com.example.crud;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
private static final String URL = "jdbc:mysql://localhost:3306/student_course?useSSL=false&serverTimezone=UTC";
private static final String USER = "root";
private static final String PASSWORD = "123456";
static {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(URL, USER, PASSWORD);
}
}
package com.example.crud.dao;
import com.example.crud.DBUtil;
import com.example.crud.model.Course;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class CourseDao {
public void addCourse(String cno, String cname, String cpno, int ccredit) throws SQLException {
String sql = "INSERT INTO c (Cno, Cname, Cpno, ccredit) VALUES (?, ?, ?, ?)";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, cno);
ps.setString(2, cname);
ps.setString(3, cpno);
ps.setInt(4, ccredit);
ps.executeUpdate();
}
}
public void deleteCourse(String cno) throws SQLException {
String sql = "DELETE FROM c WHERE Cno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, cno);
ps.executeUpdate();
}
}
public void updateCourse(String cno, String cname, String cpno, int ccredit) throws SQLException {
String sql = "UPDATE c SET Cname = ?, Cpno = ?, ccredit = ? WHERE Cno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, cname);
ps.setString(2, cpno);
ps.setInt(3, ccredit);
ps.setString(4, cno);
ps.executeUpdate();
}
}
public List<Course> getAllCourses() throws SQLException {
String sql = "SELECT * FROM c";
List<Course> courses = new ArrayList<>();
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery()) {
while (rs.next()) {
Course course = new Course();
course.setCno(rs.getString("Cno"));
course.setCname(rs.getString("Cname"));
course.setCpno(rs.getString("Cpno"));
course.setCcredit(rs.getInt("ccredit"));
courses.add(course);
}
}
return courses;
}
}
package com.example.crud.dao;
import com.example.crud.DBUtil;
import com.example.crud.model.Enrollment;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class EnrollmentDao {
public void addEnrollment(String sno, String cno, int grade) throws SQLException {
String sql = "INSERT INTO sc (Sno, Cno, grade) VALUES (?, ?, ?)";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, sno);
ps.setString(2, cno);
ps.setInt(3, grade);
ps.executeUpdate();
}
}
public void deleteEnrollment(String sno, String cno) throws SQLException {
String sql = "DELETE FROM sc WHERE Sno = ? AND Cno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, sno);
ps.setString(2, cno);
ps.executeUpdate();
}
}
public void updateEnrollment(String sno, String cno, int grade) throws SQLException {
String sql = "UPDATE sc SET grade = ? WHERE Sno = ? AND Cno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setInt(1, grade);
ps.setString(2, sno);
ps.setString(3, cno);
ps.executeUpdate();
}
}
public List<Enrollment> getAllEnrollments() throws SQLException {
String sql = "SELECT * FROM sc";
List<Enrollment> enrollments = new ArrayList<>();
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery()) {
while (rs.next()) {
Enrollment enrollment = new Enrollment();
enrollment.setSno(rs.getString("Sno"));
enrollment.setCno(rs.getString("Cno"));
enrollment.setGrade(rs.getInt("grade"));
enrollments.add(enrollment);
}
}
return enrollments;
}
}
package com.example.crud.dao;
import com.example.crud.DBUtil;
import com.example.crud.model.Student;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class StudentDao {
public void addStudent(String sno, String sname, String ssex, int sage, String sdept, String sbirthday) throws SQLException {
String sql = "INSERT INTO s (Sno, Sname, Ssex, Sage, sdept, Sbirthday) VALUES (?, ?, ?, ?, ?, ?)";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, sno);
ps.setString(2, sname);
ps.setString(3, ssex);
ps.setInt(4, sage);
ps.setString(5, sdept);
ps.setString(6, sbirthday);
ps.executeUpdate();
}
}
public void deleteStudent(String sno) throws SQLException {
String sql = "DELETE FROM s WHERE Sno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, sno);
ps.executeUpdate();
}
}
public void updateStudent(String sno, String sname, String ssex, int sage, String sdept, String sbirthday) throws SQLException {
String sql = "UPDATE s SET Sname = ?, Ssex = ?, Sage = ?, sdept = ?, Sbirthday = ? WHERE Sno = ?";
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql)) {
ps.setString(1, sname);
ps.setString(2, ssex);
ps.setInt(3, sage);
ps.setString(4, sdept);
ps.setString(5, sbirthday);
ps.setString(6, sno);
ps.executeUpdate();
}
}
public List<Student> getAllStudents() throws SQLException {
String sql = "SELECT * FROM s";
List<Student> students = new ArrayList<>();
try (Connection conn = DBUtil.getConnection();
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery()) {
while (rs.next()) {
Student student = new Student();
student.setSno(rs.getString("Sno"));
student.setSname(rs.getString("Sname"));
student.setSsex(rs.getString("Ssex"));
student.setSage(rs.getInt("Sage"));
student.setSdept(rs.getString("sdept"));
student.setSbirthday(rs.getDate("Sbirthday"));
students.add(student);
}
}
return students;
}
}
package com.example.crud.model;
public class Course {
private String cno;
private String cname;
private String cpno;
private int ccredit;
// Constructors
public Course() {}
public Course(String cno, String cname, String cpno, int ccredit) {
this.cno = cno;
this.cname = cname;
this.cpno = cpno;
this.ccredit = ccredit;
}
// Getters and Setters
public String getCno() {
return cno;
}
public void setCno(String cno) {
this.cno = cno;
}
public String getCname() {
return cname;
}
public void setCname(String cname) {
this.cname = cname;
}
public String getCpno() {
return cpno;
}
public void setCpno(String cpno) {
this.cpno = cpno;
}
public int getCcredit() {
return ccredit;
}
public void setCcredit(int ccredit) {
this.ccredit = ccredit;
}
}
package com.example.crud.model;
public class Enrollment {
private String sno;
private String cno;
private int grade;
// Constructors
public Enrollment() {}
public Enrollment(String sno, String cno, int grade) {
this.sno = sno;
this.cno = cno;
this.grade = grade;
}
// Getters and Setters
public String getSno() {
return sno;
}
public void setSno(String sno) {
this.sno = sno;
}
public String getCno() {
return cno;
}
public void setCno(String cno) {
this.cno = cno;
}
public int getGrade() {
return grade;
}
public void setGrade(int grade) {
this.grade = grade;
}
}
package com.example.crud.model;
import java.util.Date;
public class Student {
private String sno;
private String sname;
private String ssex;
private int sage;
private String sdept;
private Date sbirthday;
// Constructors
public Student() {}
public Student(String sno, String sname, String ssex, int sage, String sdept, Date sbirthday) {
this.sno = sno;
this.sname = sname;
this.ssex = ssex;
this.sage = sage;
this.sdept = sdept;
this.sbirthday = sbirthday;
}
// Getters and Setters
public String getSno() {
return sno;
}
public void setSno(String sno) {
this.sno = sno;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getSsex() {
return ssex;
}
public void setSsex(String ssex) {
this.ssex = ssex;
}
public int getSage() {
return sage;
}
public void setSage(int sage) {
this.sage = sage;
}
public String getSdept() {
return sdept;
}
public void setSdept(String sdept) {
this.sdept = sdept;
}
public Date getSbirthday() {
return sbirthday;
}
public void setSbirthday(Date sbirthday) {
this.sbirthday = sbirthday;
}
}
package com.example.crud.servlet;
import com.example.crud.dao.CourseDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/AddCourseServlet")
public class AddCourseServlet extends HttpServlet {
private CourseDao courseDao = new CourseDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String cno = request.getParameter("cno");
String cname = request.getParameter("cname");
String cpno = request.getParameter("cpno");
String ccredit = request.getParameter("ccredit");
try {
courseDao.addCourse(cno, cname, cpno, Integer.parseInt(ccredit));
response.sendRedirect("courses.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.CourseDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/AddCourseServlet")
public class AddCourseServlet extends HttpServlet {
private CourseDao courseDao = new CourseDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String cno = request.getParameter("cno");
String cname = request.getParameter("cname");
String cpno = request.getParameter("cpno");
String ccredit = request.getParameter("ccredit");
try {
courseDao.addCourse(cno, cname, cpno, Integer.parseInt(ccredit));
response.sendRedirect("courses.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.StudentDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/AddStudentServlet")
public class AddStudentServlet extends HttpServlet {
private StudentDao studentDao = new StudentDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sno = request.getParameter("sno");
String sname = request.getParameter("sname");
String ssex = request.getParameter("ssex");
String sage = request.getParameter("sage");
String sdept = request.getParameter("sdept");
String sbirthday = request.getParameter("sbirthday");
try {
studentDao.addStudent(sno, sname, ssex, Integer.parseInt(sage), sdept, sbirthday);
response.sendRedirect("students.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.CourseDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/DeleteCourseServlet")
public class DeleteCourseServlet extends HttpServlet {
private CourseDao courseDao = new CourseDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String cno = request.getParameter("cno");
try {
courseDao.deleteCourse(cno);
response.sendRedirect("courses.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.EnrollmentDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/DeleteEnrollmentServlet")
public class DeleteEnrollmentServlet extends HttpServlet {
private EnrollmentDao enrollmentDao = new EnrollmentDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sno = request.getParameter("sno");
String cno = request.getParameter("cno");
try {
enrollmentDao.deleteEnrollment(sno, cno);
response.sendRedirect("enrollments.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.StudentDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/DeleteStudentServlet")
public class DeleteStudentServlet extends HttpServlet {
private StudentDao studentDao = new StudentDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sno = request.getParameter("sno");
try {
studentDao.deleteStudent(sno);
response.sendRedirect("students.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.CourseDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/UpdateCourseServlet")
public class UpdateCourseServlet extends HttpServlet {
private CourseDao courseDao = new CourseDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String cno = request.getParameter("cno");
String cname = request.getParameter("cname");
String cpno = request.getParameter("cpno");
String ccredit = request.getParameter("ccredit");
try {
courseDao.updateCourse(cno, cname, cpno, Integer.parseInt(ccredit));
response.sendRedirect("courses.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.EnrollmentDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/UpdateEnrollmentServlet")
public class UpdateEnrollmentServlet extends HttpServlet {
private EnrollmentDao enrollmentDao = new EnrollmentDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sno = request.getParameter("sno");
String cno = request.getParameter("cno");
String grade = request.getParameter("grade");
try {
enrollmentDao.updateEnrollment(sno, cno, Integer.parseInt(grade));
response.sendRedirect("enrollments.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
package com.example.crud.servlet;
import com.example.crud.dao.StudentDao;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.
WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.SQLException;
@
WebServlet("/UpdateStudentServlet")
public class UpdateStudentServlet extends HttpServlet {
private StudentDao studentDao = new StudentDao();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sno = request.getParameter("sno");
String sname = request.getParameter("sname");
String ssex = request.getParameter("ssex");
String sage = request.getParameter("sage");
String sdept = request.getParameter("sdept");
String sbirthday = request.getParameter("sbirthday");
try {
studentDao.updateStudent(sno, sname, ssex, Integer.parseInt(sage), sdept, sbirthday);
response.sendRedirect("students.jsp");
} catch (SQLException e) {
e.printStackTrace();
response.sendRedirect("error.jsp");
}
}
}
<?xml version="1.0" encoding="UTF-8"?>
<
web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee "
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance "
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/
web-app_4_0.xsd "
version="4.0">
<servlet>
<servlet-name>AddStudentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.AddStudentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AddStudentServlet</servlet-name>
<url-pattern>/AddStudentServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DeleteStudentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.DeleteStudentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DeleteStudentServlet</servlet-name>
<url-pattern>/DeleteStudentServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>UpdateStudentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.UpdateStudentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UpdateStudentServlet</servlet-name>
<url-pattern>/UpdateStudentServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>AddCourseServlet</servlet-name>
<servlet-class>com.example.crud.servlet.AddCourseServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AddCourseServlet</servlet-name>
<url-pattern>/AddCourseServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DeleteCourseServlet</servlet-name>
<servlet-class>com.example.crud.servlet.DeleteCourseServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DeleteCourseServlet</servlet-name>
<url-pattern>/DeleteCourseServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>UpdateCourseServlet</servlet-name>
<servlet-class>com.example.crud.servlet.UpdateCourseServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UpdateCourseServlet</servlet-name>
<url-pattern>/UpdateCourseServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>AddEnrollmentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.AddEnrollmentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>AddEnrollmentServlet</servlet-name>
<url-pattern>/AddEnrollmentServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>DeleteEnrollmentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.DeleteEnrollmentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DeleteEnrollmentServlet</servlet-name>
<url-pattern>/DeleteEnrollmentServlet</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>UpdateEnrollmentServlet</servlet-name>
<servlet-class>com.example.crud.servlet.UpdateEnrollmentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>UpdateEnrollmentServlet</servlet-name>
<url-pattern>/UpdateEnrollmentServlet</url-pattern>
</servlet-mapping>
</
web-app>
<%@ page language="java" content
Type="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.util.List" %>
<%@ page import="com.example.crud.dao.CourseDao" %>
<%@ page import="com.example.crud.model.Course" %>
<!DOC
TYPE html>
<html>
<head>
<
title>Course List</
title>
</head>
<body>
<h2>Course List</h2>
<!-- Add Course Form -->
<h3>Add Course</h3>
<form action="AddCourseServlet" method="post">
<label for="cno">Cno:</label>
<
input type="text" id="cno" name="cno" required><br><br>
<label for="cname">Cname:</label>
<
input type="text" id="cname" name="cname" required><br><br>
<label for="cpno">Cpno:</label>
<
input type="text" id="cpno" name="cpno"><br><br>
<label for="ccredit">Ccredit:</label>
<
input type="number" id="ccredit" name="ccredit" required><br><br>
<
input type="submit" value="Submit">
</form>
<!-- Course List Table -->
<h3>Course List</h3>
<table border="1">
<tr>
<th>Cno</th>
<th>Cname</th>
<th>Cpno</th>
<th>Ccredit</th>
<th>Action</th>
</tr>
<%
CourseDao courseDao = new CourseDao();
List<Course> courses = null;
try {
courses = courseDao.getAllCourses();
} catch (Exception e) {
e.printStackTrace();
}
if (courses != null) {
for (Course course : courses) {
%>
<tr>
<td><%= course.getCno() %></td>
<td><%= course.getCname() %></td>
<td><%= course.getCpno() %></td>
<td><%= course.getCcredit() %></td>
<td>
<form action="DeleteCourseServlet" method="post">
<
input type="hidden" name="cno" value="<%= course.getCno() %>">
<
input type="submit" value="Delete">
</form>
<form action="UpdateCourseServlet" method="post">
<
input type="hidden" name="cno" value="<%= course.getCno() %>">
<
input type="hidden" name="cname" value="<%= course.getCname() %>">
<
input type="hidden" name="cpno" value="<%= course.getCpno() %>">
<
input type="hidden" name="ccredit" value="<%= course.getCcredit() %>">
<
input type="submit" value="Update">
</form>
</td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
<%@ page language="java" content
Type="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.util.List" %>
<%@ page import="com.example.crud.dao.EnrollmentDao" %>
<%@ page import="com.example.crud.model.Enrollment" %>
<!DOC
TYPE html>
<html>
<head>
<
title>Enrollment List</
title>
</head>
<body>
<h2>Enrollment List</h2>
<!-- Add Enrollment Form -->
<h3>Add Enrollment</h3>
<form action="AddEnrollmentServlet" method="post">
<label for="sno">Sno:</label>
<
input type="text" id="sno" name="sno" required><br><br>
<label for="cno">Cno:</label>
<
input type="text" id="cno" name="cno" required><br><br>
<label for="grade">Grade:</label>
<
input type="number" id="grade" name="grade" required><br><br>
<
input type="submit" value="Submit">
</form>
<!-- Enrollment List Table -->
<h3>Enrollment List</h3>
<table border="1">
<tr>
<th>Sno</th>
<th>Cno</th>
<th>Grade</th>
<th>Action</th>
</tr>
<%
EnrollmentDao enrollmentDao = new EnrollmentDao();
List<Enrollment> enrollments = null;
try {
enrollments = enrollmentDao.getAllEnrollments();
} catch (Exception e) {
e.printStackTrace();
}
if (enrollments != null) {
for (Enrollment enrollment : enrollments) {
%>
<tr>
<td><%= enrollment.getSno() %></td>
<td><%= enrollment.getCno() %></td>
<td><%= enrollment.getGrade() %></td>
<td>
<form action="DeleteEnrollmentServlet" method="post">
<
input type="hidden" name="sno" value="<%= enrollment.getSno() %>">
<
input type="hidden" name="cno" value="<%= enrollment.getCno() %>">
<
input type="submit" value="Delete">
</form>
<form action="UpdateEnrollmentServlet" method="post">
<
input type="hidden" name="sno" value="<%= enrollment.getSno() %>">
<
input type="hidden" name="cno" value="<%= enrollment.getCno() %>">
<
input type="hidden" name="grade" value="<%= enrollment.getGrade() %>">
<
input type="submit" value="Update">
</form>
</td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
<%@ page language="java" content
Type="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.util.List" %>
<%@ page import="com.example.crud.dao.StudentDao" %>
<%@ page import="com.example.crud.model.Student" %>
<!DOC
TYPE html>
<html>
<head>
<
title>Student List</
title>
</head>
<body>
<h2>Student List</h2>
<!-- Add Student Form -->
<h3>Add Student</h3>
<form action="AddStudentServlet" method="post">
<label for="sno">Sno:</label>
<
input type="text" id="sno" name="sno" required><br><br>
<label for="sname">Sname:</label>
<
input type="text" id="sname" name="sname" required><br><br>
<label for="ssex">Ssex:</label>
<
input type="text" id="ssex" name="ssex" required><br><br>
<label for="sage">Sage:</label>
<
input type="number" id="sage" name="sage" required><br><br>
<label for="sdept">Sdept:</label>
<
input type="text" id="sdept" name="sdept" required><br><br>
<label for="sbirthday">Sbirthday:</label>
<
input type="date" id="sbirthday" name="sbirthday" required><br><br>
<
input type="submit" value="Submit">
</form>
<!-- Student List Table -->
<h3>Student List</h3>
<table border="1">
<tr>
<th>Sno</th>
<th>Sname</th>
<th>Ssex</th>
<th>Sage</th>
<th>Sdept</th>
<th>Sbirthday</th>
<th>Action</th>
</tr>
<%
StudentDao studentDao = new StudentDao();
List<Student> students = null;
try {
students = studentDao.getAllStudents(); // 调用 getAllStudents 方法
} catch (Exception e) {
e.printStackTrace();
}
if (students != null) {
for (Student student : students) {
%>
<tr>
<td><%= student.getSno() %></td>
<td><%= student.getSname() %></td>
<td><%= student.getSsex() %></td>
<td><%= student.getSage() %></td>
<td><%= student.getSdept() %></td>
<td><%= student.getSbirthday() %></td>
<td>
<form action="DeleteStudentServlet" method="post">
<
input type="hidden" name="sno" value="<%= student.getSno() %>">
<
input type="submit" value="Delete">
</form>
<form action="UpdateStudentServlet" method="post">
<
input type="hidden" name="sno" value="<%= student.getSno() %>">
<
input type="hidden" name="sname" value="<%= student.getSname() %>">
<
input type="hidden" name="ssex" value="<%= student.getSsex() %>">
<
input type="hidden" name="sage" value="<%= student.getSage() %>">
<
input type="hidden" name="sdept" value="<%= student.getSdept() %>">
<
input type="hidden" name="sbirthday" value="<%= student.getSbirthday() %>">
<
input type="submit" value="Update">
</form>
</td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
我的所有代码为以上内容，数据库中的表为图中三张，想要实现在网页上对这三个表的增删改查，为什么我的http://localhost:8080/网页显示HTTP状态 404 - 未找到
类型 状态报告
描述 源服务器未能找到目标资源的表示或者是不愿公开一个已经存在的资源表示。
针对快应用1000版本中无法直接通过web组件上传文件的问题，本文提出了一种变通方案，利用titlereceive事件实现文件上传功能，支持用户选择图片或拍照上传，同时介绍了如何检测网络状态和上传进度。
扫一扫
1万+
到【灌水乐园】发言
