基于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对应一个Form表单的输入项 List list = upLoad.parseRequest(request); // List list=upLoad.parseRequest(request); // 如果fileitem中封装的是普通输入项的数据 for (FileItem item : list) { if (item.isFormField()) { String name = item.getFieldName(); } 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;
}
<% String path = request.getContextPath(); String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/"; %>教师界面
Severity: Notice
Message: Trying to get property of non-object
Filename: views/demo.php
Line Number: 40



