javaweb学生成绩管理系统

3．分工描述

姓名 范浩 完成模块 学生查询 及添加学生查看全部课程，查看班级基本信息 学生查询 及添加学生查看全部课程，查看班级基本信息 学生查询 及添加学生查看全部课程，查看班级基本信息 好 完成情况 备注 李文哲 好 王玮 好 四．核心部分源代码

此处罗列设计中的核心类代码，列出类的成员变量和成员方法，类请加上如下注释

用户类：private String userId; private String userName; private String userPassword; private String userSex; private String userType; private String courseId; private String classId; public String getUserId() { returnuserId; }

publicvoid setUserId(String userId) { this.userId = userId; }

public String getUserName() { returnuserName; }

publicvoid setUserName(String userName) { this.userName = userName; }

public String getUserPassword() { returnuserPassword; }

publicvoid setUserPassword(String userPassword) { this.userPassword = userPassword;

}

public String getUserSex() { returnuserSex; }

publicvoid setUserSex(String userSex) { this.userSex = userSex; }

public String getUserType() { returnuserType; }

publicvoid setUserType(String userType) { this.userType = userType; }

public String getCourseId() { returncourseId; }

publicvoid setCourseId(String courseId) { this.courseId = courseId; }

public String getClassId() { returnclassId; }

publicvoid setClassId(String classId) { this.classId = classId; }

分数类 private String Sid; private String userId; private String score; private String courseId; public String getSid() { return Sid; }

publicvoid setSid(String sid) { Sid = sid; }

public String getUserId() { return userId; }

publicvoid setUserId(String userId) { this.userId = userId; }

public String getScore() { return score; }

publicvoid setScore(String score) { this.score = score; }

public String getCourseId() { return courseId; }

publicvoid setCourseId(String courseId) { this.courseId = courseId; }：

课程类private String courseId; private String courseName; public String getCourseId() { return courseId; }

publicvoid setCourseId(String courseId) { this.courseId = courseId; }

public String getCourseName() { return courseName; }

publicvoid setCourseName(String courseName) { this.courseName = courseName; }

班级表：private String classId; private String className; public String getClassId() { returnclassId; }

publicvoid setClassId(String classId) { this.classId = classId; }

public String getClassName() { returnclassName; }

publicvoid setClassName(String className) { this.className = className; }

登录处理：String userid=request.getParameter(\

String userpassword=request.getParameter(\ String usertype=request.getParameter(\ SMSuser user=new SMSuser(); user.setUserId(userid);

user.setUserPassword(userpassword);

user.setUserType(usertype);

ResultSet rs=new SMSuserdaoImpl().LoginJudgmentType(user); try {

if(rs.next()){

HttpSession session=request.getSession(); session.setAttribute(\ String useid=rs.getString(\ String pwd=rs.getString(\ String userType=rs.getString(\if(\

request.getRequestDispatcher(\ } else

if(\

response.sendRedirect(\ } else

if(\

response.sendRedirect(\ }

}

} catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace(); }

数据库：

public ResultSet LoginJudgmentType(SMSuser user) { // TODO Auto-generated method stub

con=db.getconnection();

String sql=%userType=?\try {

ps=con.prepareStatement(sql);

ps.setString(1, user.getUserId());

ps.setString(2, user.getUserPassword()); ps.setString(3, user.getUserType()); rs=ps.executeQuery(); } catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace();