javaweb学生成绩管理系统

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();

五、实训结果