基于Ajax+Servlet+JSP技术的学生信息管理系统.zip

资源文件列表(大概)

文件名

大小

javaweb/.gitignore

490B

javaweb/.idea/

javaweb/.idea/.gitignore

184B

javaweb/.idea/.name

14B

javaweb/.idea/compiler.xml

540B

javaweb/.idea/dataSources/

javaweb/.idea/encodings.xml

729B

javaweb/.idea/file.template.settings.xml

439B

javaweb/.idea/fileTemplates/

javaweb/.idea/fileTemplates/servlet.java

609B

javaweb/.idea/inspectionProfiles/

javaweb/.idea/inspectionProfiles/Project_Default.xml

635B

javaweb/.idea/jarRepositories.xml

880B

javaweb/.idea/libraries/

javaweb/.idea/libraries/lib.xml

314B

javaweb/.idea/libraries/mysql_connector_java_8_0_25.xml

276B

javaweb/.idea/libraries/mysql_connector_java_8_0_25__2_.xml

280B

javaweb/.idea/libraries/mysql_connector_java_8_0_25__3_.xml

280B

javaweb/.idea/libraries/mysql_connector_java_8_0_25__4_.xml

280B

javaweb/.idea/libraries/mysql_connector_java_8_0_25__5_.xml

280B

javaweb/.idea/misc.xml

526B

javaweb/.idea/uiDesigner.xml

8.71KB

javaweb/.idea/webContexts.xml

437B

javaweb/.idea/workspace.xml

17.06KB

javaweb/javaweb.sql

6.41KB

javaweb/pom.xml

1.25KB

javaweb/src/

javaweb/src/main/

javaweb/src/main/java/

javaweb/src/main/java/org/

javaweb/src/main/java/org/Controller/

javaweb/src/main/java/org/Controller/AddCourseServlet.java

2.37KB

javaweb/src/main/java/org/Controller/AddScoreServlet.java

1.86KB

javaweb/src/main/java/org/Controller/AddStudentServlet.java

2.27KB

javaweb/src/main/java/org/Controller/AddTeacherServlet.java

2.25KB

javaweb/src/main/java/org/Controller/ListCourseServlet.java

2.86KB

javaweb/src/main/java/org/Controller/ListScoreServlet.java

3.26KB

javaweb/src/main/java/org/Controller/ListStudentServlet.java

3.11KB

javaweb/src/main/java/org/Controller/ListTeacherServlet.java

3.12KB

javaweb/src/main/java/org/Controller/LoginServlet.java

1.94KB

javaweb/src/main/java/org/Controller/RegisterServlet.java

1.79KB

javaweb/src/main/java/org/Controller/UpdateCourseServlet.java

2.23KB

javaweb/src/main/java/org/Controller/UpdateScoreServlet.java

1.94KB

javaweb/src/main/java/org/Controller/UpdateStudentServlet.java

1.9KB

javaweb/src/main/java/org/Controller/UpdateTeacherServlet.java

1.94KB

javaweb/src/main/java/org/Dao/

javaweb/src/main/java/org/Dao/CourseDao.java

417B

javaweb/src/main/java/org/Dao/Impl/

javaweb/src/main/java/org/Dao/Impl/CourseDaoImpl.java

5.36KB

javaweb/src/main/java/org/Dao/Impl/ScoreDaoImpl.java

5.62KB

javaweb/src/main/java/org/Dao/Impl/StudentDaoImpl.java

4.77KB

javaweb/src/main/java/org/Dao/Impl/TeacherDaoImpl.java

4.7KB

javaweb/src/main/java/org/Dao/Impl/UserDaoImpl.java

4.78KB

javaweb/src/main/java/org/Dao/ScoreDao.java

381B

javaweb/src/main/java/org/Dao/StudentDao.java

338B

javaweb/src/main/java/org/Dao/TeacherDao.java

327B

javaweb/src/main/java/org/Dao/UserDao.java

493B

javaweb/src/main/java/org/Entity/

javaweb/src/main/java/org/Entity/CourseEntity.java

2.5KB

javaweb/src/main/java/org/Entity/ScoreEntity.java

2.14KB

javaweb/src/main/java/org/Entity/StudentEntity.java

2.77KB

javaweb/src/main/java/org/Entity/TeacherEntity.java

2.83KB

javaweb/src/main/java/org/Entity/UserEntity.java

993B

javaweb/src/main/java/org/Service/

javaweb/src/main/java/org/Service/CourseService.java

425B

javaweb/src/main/java/org/Service/Impl/

javaweb/src/main/java/org/Service/Impl/CourseServiceImpl.java

1.21KB

javaweb/src/main/java/org/Service/Impl/ScoreServiceImpl.java

1.1KB

javaweb/src/main/java/org/Service/Impl/StudentServiceImpl.java

1.02KB

javaweb/src/main/java/org/Service/Impl/TeacherServiceImpl.java

1.01KB

javaweb/src/main/java/org/Service/Impl/UserServiceImpl.java

1.04KB

javaweb/src/main/java/org/Service/ScoreService.java

387B

javaweb/src/main/java/org/Service/StudentService.java

336B

javaweb/src/main/java/org/Service/TeacherService.java

335B

javaweb/src/main/java/org/Service/UserService.java

412B

javaweb/src/main/java/org/Utils/

javaweb/src/main/java/org/Utils/DbUtil.java

2.07KB

javaweb/src/main/resources/

javaweb/src/main/webapp/

javaweb/src/main/webapp/addCourse.jsp

4.63KB

javaweb/src/main/webapp/AddScore.jsp

4.99KB

javaweb/src/main/webapp/addStudent.jsp

5.57KB

javaweb/src/main/webapp/addTeacher.jsp

5.58KB

javaweb/src/main/webapp/css/

javaweb/src/main/webapp/css/admin.css

4.24KB

javaweb/src/main/webapp/css/login.css

1.69KB

javaweb/src/main/webapp/css/pintuer.css

110.58KB

javaweb/src/main/webapp/css/register.css

1.74KB

javaweb/src/main/webapp/home.jsp

2.82KB

javaweb/src/main/webapp/img/

javaweb/src/main/webapp/img/1.jpg

277.5KB

javaweb/src/main/webapp/img/2.jpg

173.99KB

javaweb/src/main/webapp/img/bg.jpg

101.08KB

javaweb/src/main/webapp/img/kcloud.JPG

25.22KB

javaweb/src/main/webapp/img/tmbg-white.png

1012B

javaweb/src/main/webapp/index.jsp

3.38KB

javaweb/src/main/webapp/js/

javaweb/src/main/webapp/js/jquery.js

94.12KB

javaweb/src/main/webapp/js/pintuer.js

16.46KB

javaweb/src/main/webapp/listCourse.jsp

7.46KB

javaweb/src/main/webapp/listScore.jsp

8.08KB

javaweb/src/main/webapp/listStudent.jsp

8.09KB

javaweb/src/main/webapp/listTeacher.jsp

8.38KB

javaweb/src/main/webapp/login.jsp

2.89KB

javaweb/src/main/webapp/register.jsp

2.86KB

javaweb/src/main/webapp/updateCourse.jsp

5.78KB

javaweb/src/main/webapp/updateScore.jsp

6.01KB

javaweb/src/main/webapp/updateStudent.jsp

6.25KB

javaweb/src/main/webapp/updateTeacher.jsp

6.26KB

javaweb/src/main/webapp/WEB-INF/

javaweb/src/main/webapp/WEB-INF/lib/

javaweb/src/main/webapp/WEB-INF/lib/mysql-connector-java-8.0.25.jar

2.32MB

javaweb/src/main/webapp/WEB-INF/web.xml

403B

javaweb/src/test/

javaweb/src/test/java/

javaweb/target/

javaweb/target/classes/

javaweb/target/classes/org/

javaweb/target/classes/org/Controller/

javaweb/target/classes/org/Controller/AddCourseServlet.class

2.89KB

javaweb/target/classes/org/Controller/AddScoreServlet.class

2.13KB

javaweb/target/classes/org/Controller/AddStudentServlet.class

3.33KB

javaweb/target/classes/org/Controller/AddTeacherServlet.class

3.34KB

javaweb/target/classes/org/Controller/ListCourseServlet.class

3.6KB

javaweb/target/classes/org/Controller/ListScoreServlet.class

3.73KB

javaweb/target/classes/org/Controller/ListStudentServlet.class

3.66KB

javaweb/target/classes/org/Controller/ListTeacherServlet.class

3.56KB

javaweb/target/classes/org/Controller/LoginServlet.class

2.74KB

javaweb/target/classes/org/Controller/RegisterServlet.class

2.72KB

javaweb/target/classes/org/Controller/UpdateCourseServlet.class

2.78KB

javaweb/target/classes/org/Controller/UpdateScoreServlet.class

2.43KB

javaweb/target/classes/org/Controller/UpdateStudentServlet.class

2.48KB

javaweb/target/classes/org/Controller/UpdateTeacherServlet.class

2.36KB

javaweb/target/classes/org/Dao/

javaweb/target/classes/org/Dao/CourseDao.class

436B

javaweb/target/classes/org/Dao/Impl/

javaweb/target/classes/org/Dao/Impl/CourseDaoImpl.class

5.2KB

javaweb/target/classes/org/Dao/Impl/ScoreDaoImpl.class

5.12KB

javaweb/target/classes/org/Dao/Impl/StudentDaoImpl.class

4.63KB

javaweb/target/classes/org/Dao/Impl/TeacherDaoImpl.class

4.64KB

javaweb/target/classes/org/Dao/Impl/UserDaoImpl.class

4.27KB

javaweb/target/classes/org/Dao/ScoreDao.class

360B

javaweb/target/classes/org/Dao/StudentDao.class

338B

javaweb/target/classes/org/Dao/TeacherDao.class

338B

javaweb/target/classes/org/Dao/UserDao.class

438B

javaweb/target/classes/org/Entity/

javaweb/target/classes/org/Entity/CourseEntity.class

2.82KB

javaweb/target/classes/org/Entity/ScoreEntity.class

2.26KB

javaweb/target/classes/org/Entity/StudentEntity.class

3.22KB

javaweb/target/classes/org/Entity/TeacherEntity.class

3.23KB

javaweb/target/classes/org/Entity/UserEntity.class

1.63KB

javaweb/target/classes/org/Service/

javaweb/target/classes/org/Service/CourseService.class

448B

javaweb/target/classes/org/Service/Impl/

javaweb/target/classes/org/Service/Impl/CourseServiceImpl.class

1.55KB

javaweb/target/classes/org/Service/Impl/ScoreServiceImpl.class

1.31KB

javaweb/target/classes/org/Service/Impl/StudentServiceImpl.class

1.33KB

javaweb/target/classes/org/Service/Impl/TeacherServiceImpl.class

1.32KB

javaweb/target/classes/org/Service/Impl/UserServiceImpl.class

1.36KB

javaweb/target/classes/org/Service/ScoreService.class

372B

javaweb/target/classes/org/Service/StudentService.class

350B

javaweb/target/classes/org/Service/TeacherService.class

350B

javaweb/target/classes/org/Service/UserService.class

474B

javaweb/target/classes/org/Utils/

javaweb/target/classes/org/Utils/DbUtil.class

2.5KB

javaweb/target/generated-sources/

javaweb/target/generated-sources/annotations/

javaweb/target/javaweb-1.0-SNAPSHOT/

javaweb/target/javaweb-1.0-SNAPSHOT/addCourse.jsp

4.63KB

javaweb/target/javaweb-1.0-SNAPSHOT/AddScore.jsp

4.99KB

javaweb/target/javaweb-1.0-SNAPSHOT/addStudent.jsp

5.57KB

javaweb/target/javaweb-1.0-SNAPSHOT/addTeacher.jsp

5.58KB

javaweb/target/javaweb-1.0-SNAPSHOT/css/

javaweb/target/javaweb-1.0-SNAPSHOT/css/admin.css

4.24KB

javaweb/target/javaweb-1.0-SNAPSHOT/css/login.css

1.69KB

javaweb/target/javaweb-1.0-SNAPSHOT/css/pintuer.css

110.58KB

javaweb/target/javaweb-1.0-SNAPSHOT/css/register.css

1.74KB

javaweb/target/javaweb-1.0-SNAPSHOT/home.jsp

2.82KB

javaweb/target/javaweb-1.0-SNAPSHOT/img/

javaweb/target/javaweb-1.0-SNAPSHOT/img/1.jpg

277.5KB

javaweb/target/javaweb-1.0-SNAPSHOT/img/2.jpg

173.99KB

javaweb/target/javaweb-1.0-SNAPSHOT/img/bg.jpg

101.08KB

javaweb/target/javaweb-1.0-SNAPSHOT/img/kcloud.JPG

25.22KB

javaweb/target/javaweb-1.0-SNAPSHOT/img/tmbg-white.png

1012B

javaweb/target/javaweb-1.0-SNAPSHOT/index.jsp

3.38KB

javaweb/target/javaweb-1.0-SNAPSHOT/js/

javaweb/target/javaweb-1.0-SNAPSHOT/js/jquery.js

94.12KB

javaweb/target/javaweb-1.0-SNAPSHOT/js/pintuer.js

16.46KB

javaweb/target/javaweb-1.0-SNAPSHOT/listCourse.jsp

7.46KB

javaweb/target/javaweb-1.0-SNAPSHOT/listScore.jsp

8.08KB

javaweb/target/javaweb-1.0-SNAPSHOT/listStudent.jsp

8.09KB

javaweb/target/javaweb-1.0-SNAPSHOT/listTeacher.jsp

8.38KB

javaweb/target/javaweb-1.0-SNAPSHOT/login.jsp

2.89KB

javaweb/target/javaweb-1.0-SNAPSHOT/META-INF/

javaweb/target/javaweb-1.0-SNAPSHOT/META-INF/MANIFEST.MF

119B

javaweb/target/javaweb-1.0-SNAPSHOT/register.jsp

2.86KB

javaweb/target/javaweb-1.0-SNAPSHOT/updateCourse.jsp

5.78KB

javaweb/target/javaweb-1.0-SNAPSHOT/updateScore.jsp

6.01KB

javaweb/target/javaweb-1.0-SNAPSHOT/updateStudent.jsp

6.25KB

javaweb/target/javaweb-1.0-SNAPSHOT/updateTeacher.jsp

6.26KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/com/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/com/example/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/AddCourseServlet.class

2.89KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/AddScoreServlet.class

2.13KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/AddStudentServlet.class

3.33KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/AddTeacherServlet.class

3.34KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/ListCourseServlet.class

3.6KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/ListScoreServlet.class

3.73KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/ListStudentServlet.class

3.66KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/ListTeacherServlet.class

3.56KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/LoginServlet.class

2.74KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/RegisterServlet.class

2.72KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/UpdateCourseServlet.class

2.78KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/UpdateScoreServlet.class

2.43KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/UpdateStudentServlet.class

2.48KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Controller/UpdateTeacherServlet.class

2.36KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/CourseDao.class

436B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/CourseDaoImpl.class

5.2KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/ScoreDaoImpl.class

5.12KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/StudentDaoImpl.class

4.63KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/TeacherDaoImpl.class

4.64KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/Impl/UserDaoImpl.class

4.27KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/ScoreDao.class

360B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/StudentDao.class

338B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/TeacherDao.class

338B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Dao/UserDao.class

438B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/CourseEntity.class

2.82KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/ScoreEntity.class

2.26KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/StudentEntity.class

3.22KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/TeacherEntity.class

3.23KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Entity/UserEntity.class

1.63KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/example/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/example/test.class

1.16KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Model/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/CourseService.class

448B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/CourseServiceImpl.class

1.55KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/ScoreServiceImpl.class

1.31KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/StudentServiceImpl.class

1.33KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/TeacherServiceImpl.class

1.32KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/Impl/UserServiceImpl.class

1.36KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/ScoreService.class

372B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/StudentService.class

350B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/TeacherService.class

350B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Service/UserService.class

474B

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Utils/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/classes/org/Utils/DbUtil.class

2.5KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/fastjson-2.0.0.jar

128.48KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/fastjson2-2.0.0.jar

1.06MB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/fastjson2-extension-2.0.0.jar

17.21KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/gson-2.8.9.jar

252.03KB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/mysql-connector-java-8.0.25.jar

2.32MB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/lib/poi-3.9-20121203.jar

1.78MB

javaweb/target/javaweb-1.0-SNAPSHOT/WEB-INF/web.xml

403B

资源内容介绍

基于Ajax+Servlet+JSP技术开发的学生信息管理系统，是一种经典的Web应用架构，结合了前端与后端技术，旨在提供动态、交互式的用户体验。下面是对这个系统在资源管理方面的概述，包括主要组成部分、工作原理及优势。主要组成部分Ajax :负责在后台与服务器交换数据，这意味着用户可以在不重新加载整个网页的情况下，获取并更新部分网页内容。Ajax使得页面能够异步通信，提升用户体验。Servlet:作为Java Web应用程序中的服务器端组件，负责处理HTTP请求并返回响应。在学生信息管理系统中，Servlet接收来自Ajax的请求，处理业务逻辑（如查询数据库、更新记录等），然后将结果以JSON或其他格式返回给前端。JSP :用于生成动态网页内容。JSP页面中可以嵌入Java代码，便于展示从Servlet获取的数据。在学生信息管理系统中，JSP页面展示学生列表、详细信息等界面，并通过Ajax调用与后台交互。

package org.Dao.Impl;import org.Dao.ScoreDao;import org.Entity.ScoreEntity;import org.Utils.DbUtil;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;public class ScoreDaoImpl implements ScoreDao { private ScoreEntity score; private DbUtil dbCon = new DbUtil(); // 添加成绩 public int addScore(ScoreEntity score) { String sql = "insert into score(stu_num,stu_name,stu_class,course_name,score_grade,major) values('" + score.getStuNum() + "','" + score.getStuName() + "','" + score.getStuClass() + "','" + score.getCourseName() + "'," + score.getScoreGrade() + ",'" + score.getMajor() + "')"; int rs = dbCon.query(sql); return rs; } // 删除成绩 public int deleteScore(int scoreID) { String sql = "delete from score where score_id=" + scoreID; int rs = dbCon.query(sql); return rs; } // 修改成绩 public int editCos(ScoreEntity score) { String sql = "update score set stu_num='" + score.getStuNum() + "',stu_name='" + score.getStuName() + "',stu_class='" + score.getStuClass() + "',course_name='" + score.getCourseName() + "',score_grade=" + score.getScoreGrade() + ",major='" + score.getMajor() + "' where score_id=" + score.getScoreID(); int rs = dbCon.query(sql); return rs; } // 查询所有成绩 public List findAll() { List<ScoreEntity> list = new ArrayList<ScoreEntity>(); String sql = "select * from score"; ResultSet rs = dbCon.find(sql); try { while (rs.next()) { int scoreID = rs.getInt("score_id"); String stuNum = rs.getString("stu_num"); String stuName = rs.getString("stu_name"); String stuClass = rs.getString("stu_class"); String courseName = rs.getString("course_name"); double scoreGrade = rs.getDouble("score_grade"); String major = rs.getString("major"); score = new ScoreEntity(scoreID, stuNum, stuName, stuClass, courseName, scoreGrade, major); list.add(score); } } catch (SQLException e) { e.printStackTrace(); } return list; } //根据学生学号查询成绩 public List selectStudentId(String stunum) { List<ScoreEntity> list = new ArrayList<ScoreEntity>(); String sql = "select * from score where stu_num='" + stunum +"'"; ResultSet rs = dbCon.find(sql); try { while (rs.next()) { int scoreid = rs.getInt("score_id"); String stuNum = rs.getString("stu_num"); String stuName = rs.getString("stu_name"); String stuClass = rs.getString("stu_class"); String courseName = rs.getString("course_name"); double scoreGrade = rs.getDouble("score_grade"); String major = rs.getString("major"); score = new ScoreEntity(scoreid, stuNum, stuName, stuClass, courseName, scoreGrade, major); list.add(score); } } catch (SQLException e) { e.printStackTrace(); } return list; } //根据学生姓名查询成绩 public List selectStudentName(String stuNames) { List<ScoreEntity> list = new ArrayList<ScoreEntity>(); String sql = "select * from score where stu_name='" + stuNames +"'"; ResultSet rs = dbCon.find(sql); try { while (rs.next()) { int scoreid = rs.getInt("score_id"); String stuNum = rs.getString("stu_num"); String stuName = rs.getString("stu_name"); String stuClass = rs.getString("stu_class"); String courseName = rs.getString("course_name"); double scoreGrade = rs.getDouble("score_grade"); String major = rs.getString("major"); score = new ScoreEntity(scoreid, stuNum, stuName, stuClass, courseName, scoreGrade, major); list.add(score); } } catch (SQLException e) { e.printStackTrace(); } return list; } //根据课程名称查询成绩 public List selectCourseName(String courseNames) { List<ScoreEntity> list = new ArrayList<ScoreEntity>(); String sql = "select * from score where course_name='" + courseNames +"'"; ResultSet rs = dbCon.find(sql); try { while (rs.next()) { int scoreid = rs.getInt("score_id"); String stuNum = rs.getString("stu_num"); String stuName = rs.getString("stu_name"); String stuClass = rs.getString("stu_class"); String courseName = rs.getString("course_name"); double scoreGrade = rs.getDouble("score_grade"); String major = rs.getString("major"); score = new ScoreEntity(scoreid, stuNum, stuName, stuClass, courseName, scoreGrade, major); list.add(score); } } catch (SQLException e) { e.printStackTrace(); } return list; }}

用户评论 (0)

发表评论

您的昵称:

评分

评论内容:

验证码:

基于Ajax+Servlet+JSP技术的学生信息管理系统.zip

资源文件列表(大概)

资源内容介绍

用户评论 (0)

发表评论

相关资源

GDE230 demo文件

529379-基于STM32无线蓝牙大棚温湿度监测控制系统设计

STM32单片机车牌识别摄像头图像识别系统设计

436762-基于STM32闭环步进电机控制系统设计（仿真，程序，说明）