基于javaweb+JSP+Servlet学生成绩管理系统(管理员、教师、学生)
开发工具:eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
+ score.getStuName()
+ "%' and score.stu_class like '%"
+ score.getStuClass()
+ "%' and score.stu_num like '%"
+ score.getStuNum()
+ "'";
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 Score(scoreID, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
rs = dbCon.find(sqlCount);
while (rs.next()) {
xmlHttpRequest.send();
xmlHttpRequest.onreadystatechange=function(){
if(xmlHttpRequest.readyState==4 && xmlHttpRequest.status==200){
var text = xmlHttpRequest.responseText;
//alert(text);
document.getElementById("stuNumcheck").innerHTML = text;
}
};
}
}
}
function namecheck(){
var stuName=document.getElementById("stuName").value;
var rename=/^[\u4e00-\u9fa5]+$/gi; //中文判断
if(stuName==""){
document.getElementById("stuNamecheck").innerHTML = "用户名不能为空";
}
else if (!rename.test(stuName))
{
document.getElementById("stuNamecheck").innerHTML = "请输入中文名,如:王文军";
}else{
// 4、使用ServletFileUpload解析器解析上传数据,解析结果返回的是一个List<FileItem>集合,
// 每一个FileItem对应一个Form表单的输入项
List<FileItem> list = upLoad.parseRequest(request);
// List<FileItem> list=upLoad.parseRequest(request);
// 如果fileitem中封装的是普通输入项的数据
for (FileItem item : list) {
if (item.isFormField()) {
String name = item.getFieldName();
/*// 解决普通输入项的数据中文乱码
String value = item.getString("utf-8");
System.out.println(name + "=" + value);*/
} else {
// 吐过fileitem中封装的是上传文件
// 得到上传的文件名称
import model.Course;
import model.PageBean;
import dao.CourseDao;
import db.DBCon;
public class CourseDaoImpl implements CourseDao {
private DBCon dbCon = new DBCon();
private Course course;
private PageBean pageBean;
public int addCos(Course course, String courseDate) {
System.out.println(courseDate);
// Date courseDate=(Date) course.getCourseDate();
// DateFormat
// data=DateFormat.getDateTimeInstance(DateFormat.MEDIUM,DateFormat.MEDIUM);
String sql = "insert into course(course_name,course_credit,course_hours,course_teacher,coursedate) values('"
+ course.getCourseName()
+ "',"
+ course.getCourseCredit()
+ ","
+ course.getCourseHours()
+ ",'"
+ course.getCourseTeacher() + "',DATE('" + courseDate + "'))";
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 score = new Score(scoreid, stuNum, stuName, stuClass,
courseName, scoreGrade, major);
list.add(score);
}
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
margin-left: 15px;
margin-right: 15px;
background: #ccc;
}
.btn1{
background: #afc5d6;
}
font{
font-size: .7rem;
float: left;
}
</style>
<link rel="stylesheet" href="https://cdn.bootcss.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<script src="js/jquery-3.3.1.min.js"></script>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>教师界面</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<link rel="stylesheet" href="css/bootstrap.min.css">
<p>Severity: Notice</p>
<p>Message: Trying to get property of non-object</p>
<p>Filename: views/demo.php</p>
<p>Line Number: 40</p>
</div>" class="btn btn-primary btn-small"><span class="iconfa-shopping-cart"></span> Purchase Theme</a>
<a href="_div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">
<h4>A PHP Error was encountered</h4>
<p>Severity: Notice</p>
<p>Message: Trying to get property of non-object</p>
<p>Filename: views/demo.php</p>
<p>Line Number: 41</p>
teaCourse, major, department);
list.add(teacher);
}
rs=dbCon.find(sqlCount);
while(rs.next()){
totalCount=rs.getInt(1);
}
} catch (SQLException e) {
dbCon.close();
e.printStackTrace();
}
pageBean=new PageBean(list,totalCount,pageNo,pageCount);
return pageBean;
}
}
package servlet;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.net.URLEncoder;
} catch (SQLException e) {
e.printStackTrace();
}
return course;
}
public PageBean courseListPage(int pageNo, int pageCount) {
int totalCount=0;
List<Course> list = new ArrayList<Course>();
String sql = "select * from course limit "+((pageNo-1)*pageCount)+","+pageCount;
String sqlCount="select count(*) from course";
user = new User(userID, userNum, userName, pwd, phone, roleID);
}
} catch (SQLException e) {
e.printStackTrace();
}
return user;
}
public int editPwd(User user) {
String sql = "update user set password='" + user.getPassword()
+ "' where user_num='" + user.getUserNum() + "'";
int rs = dbCon.query(sql);
return rs;
}
public int addUser(User user) {
String sql = "insert into user(user_num,user_name,password,phone,role_id) values('"
+ user.getUserNum()
+ "','"
+ user.getUserName()
+ "','"
+ user.getPassword()
+ "',"
运行环境
Java≥8、Tomcat≥8.0、MySQL≥5.7
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
技术框架
JSP Servlet MySQL JDBC Tomcat CSS JavaScript bootstrap jquery
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
管理员:个人信息、课程管理、成绩管理、教师管理、学生管理
教师:个人信息、课程管理、成绩管理、学生信息查看
学生:人个信息管理、成绩查询
管理员
教师
学生