安装APP,随时看
文档分类
当前位置:首页 > javaweb学生成绩管理系统
} return rs; }
学生查分:
String scoreId=request.getParameter(\
String userId=request.getParameter(\
String coursecourseId=request.getParameter(\ String score=request.getParameter(\ Score sc=new Score(); sc.setSid(scoreId); sc.setUserId(userId);
sc.setCourseId(coursecourseId);
sc.setScore(score);
boolean flag=new ScoreDaoImpl().TeacherTOInsertStudentScore(sc); if(flag){
request.getRequestDispatcher(\st, response); } 数据库
public ResultSet StudentsTosearchScore(SMSuser user) { // TODO Auto-generated method stub con=db.getconnection();
String sql=\SMSuser.userId,userName,courseName,score from SMSuser,course,score where SMSuser.courseId=course.courseId and course.courseId=score.courseId and SMSuser.userId=?\try {
ps=con.prepareStatement(sql);
ps.setString(1, user.getUserId()); rs=ps.executeQuery(); } catch (SQLException e) {
// TODO Auto-generated catch block e.printStackTrace();
五、实训结果
共分享92篇相关文档