基于javaweb+mysql的教务选课管理系统(管理员、教师、学生)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
管理员:课程、教师、学生模板的增删改查管理
教师:查看授课、成绩、打分等
学生:查看课程、选课、退课等
管理员
学生
教师
技术框架
JavaBean MVC JSP SSM(Spring SpringMVC MyBatis) Maven MySQL Bootstrap JavaScript
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
<if test="userid != null" >
#{userid,jdbcType=INTEGER},
</if>
<if test="username != null" >
#{username,jdbcType=VARCHAR},
</if>
<if test="password != null" >
#{password,jdbcType=VARCHAR},
</if>
<if test="role != null" >
#{role,jdbcType=INTEGER},
</if>
</trim>
public Criteria andCollegeidEqualTo(Integer value) {
addCriterion("collegeID =", value, "collegeid");
return (Criteria) this;
}
public Criteria andCollegeidNotEqualTo(Integer value) {
addCriterion("collegeID <>", value, "collegeid");
return (Criteria) this;
}
public Criteria andCollegeidGreaterThan(Integer value) {
addCriterion("collegeID >", value, "collegeid");
return (Criteria) this;
}
public Criteria andCollegeidGreaterThanOrEqualTo(Integer value) {
addCriterion("collegeID >=", value, "collegeid");
return (Criteria) this;
}
public Criteria andCollegeidLessThan(Integer value) {
addCriterion("collegeID <", value, "collegeid");
return (Criteria) this;
}
public Criteria andCollegeidLessThanOrEqualTo(Integer value) {
addCriterion("collegeID <=", value, "collegeid");
<if test="permissions != null" >
permissions,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides="," >
<if test="roleid != null" >
#{roleid,jdbcType=INTEGER},
</if>
<if test="rolename != null" >
#{rolename,jdbcType=VARCHAR},
</if>
<if test="permissions != null" >
#{permissions,jdbcType=VARCHAR},
</if>
criteria = new ArrayList<Criterion>();
}
public boolean isValid() {
return criteria.size() > 0;
}
public List<Criterion> getAllCriteria() {
return criteria;
}
public List<Criterion> getCriteria() {
return criteria;
}
public Criteria andUsernameIsNull() {
addCriterion("userName is null");
return (Criteria) this;
}
public Criteria