最近学习完ssm框架就打算拿之前做过的老的学生成绩管理系统来练练手。
目标
- 导入ssm整合的所有jar包
- 在项目里打好ssm框架
- 创建好需要的配置文件
- 建立数据库
- 在项目组创建需要的持久化类
导入ssm整合的所有jar包
- 将如图所示的所有jar包放入WEB-INF/lib文件夹下
- com.stuos.controller:放控制层代码
- com.stuos.dao:放dao层代码
- com.stuos.po:放持久化类
- com.stuos.service:放服务层接口代码
- com.stuos.service.impl:放服务层的接口实现类
- config:放配置文件
applicationContext.xml(spring的配置文件)
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<context:component-scan base-package="com.stuos.service" />
<context:property-placeholder location="classpath:db.properties"/>
<bean id="dataSource"
class="org.apache.commons.dbcp2.BasicDataSource">
<property name="driverClassName"
value="${jdbc.driver}">property>
<property name="url" value="${jdbc.url}">property>
<property name="username" value="${jdbc.username}">property>
<property name="password" value="${jdbc.password}">property>
<property name="maxTotal" value="${jdbc.maxTotal}">property>
<property name="maxIdle" value="${jdbc.maxIdle}">property>
<property name="initialSize" value="${jdbc.initialSize}">property>
bean>
<bean id = "transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref = "dataSource">property>
bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
bean>
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.stuos.dao">property>
bean>
beans>
db.properties(数据库的属性,方便后续更改)
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/db1
jdbc.username=root
jdbc.password=123456
jdbc.maxTotal=30
jdbc.maxIdle=10
jdbc.initialSize=5
log4j.properties(日志文件配置信息)
log4j.rootLogger=ERROR, stdout
log4j.logger.com.stuos=DEBUG
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n
mybatis-config.xml(MyBatis核心配置文件)
DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<typeAliases>
<package name="com.stuos.po"/>
typeAliases>
<mappers>
mappers>
configuration>
springmvc-config.xml(用于加载Controller层)
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd">
<context:component-scan
base-package="com.stuos.controller" />
<mvc:annotation-driven />
<bean id="viewResolver"
class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/jsp/" />
<property name="suffix" value=".jsp">property>
bean>
beans>
web.xml:web相关配置
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"
version="3.1" metadata-complete="true">
<context-param>
<param-name>contextConfigLocationparam-name>
<param-value>classpath:applicationContext.xmlparam-value>
context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListenerlistener-class>
listener>
<servlet>
<servlet-name>springmvcservlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
<init-param>
<param-name>contextConfigLocationparam-name>
<param-value>classpath:springmvc-config.xmlparam-value>
init-param>
<load-on-startup>1load-on-startup>
servlet>
<servlet-mapping>
<servlet-name>springmvcservlet-name>
<url-pattern>/url-pattern>
servlet-mapping>
<filter>
<filter-name>CharacterEncodingFilterfilter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
<init-param>
<param-name>encodingparam-name>
<param-value>UTF-8param-value>
init-param>
filter>
<filter-mapping>
<filter-name>CharacterEncodingFilterfilter-name>
<url-pattern>/*url-pattern>
filter-mapping>
<welcome-file-list>
<welcome-file>login.jspwelcome-file>
welcome-file-list>
web-app>
建立数据库
使用之前系统数据库的sql文件重建数据库
这里使用navicat
根据数据库创建持久化类
课程类
package com.stuos.po;
/*
* 课程类
*
* */
public class Course {
private String courseId;//课程号
private String courseName;//课程名称
private String teaId;//授课教师
public Course() {
}
public Course(String id,String name,String teaid) {
this.courseId = id;
this.courseName = name;
this.teaId = teaid;
}
public String getCourseId() {
return courseId;
}
public void setCourseId(String courseId) {
this.courseId = courseId;
}
public String getCourseName() {
return courseName;
}
public void setCourseName(String courseName) {
this.courseName = courseName;
}
public String getTeaId() {
return teaId;
}
public void setTeaId(String teaId) {
this.teaId = teaId;
}
}
修改成绩类
package com.stuos.po;
/*
* 修改成绩请求类
*
* */
public class ModifyScore {
private int Id;//申请序号,主键
private String teaId;//申请老师
private String stuId;//修改的学生的学号
private String courseId;//修改的课程号
private int newScore;//新分数
private int flag1;//秘书处理结果
private int flag2;//专业负责人处理结果
public ModifyScore() {
}
public ModifyScore(String teaid,String stuid,String courseid,int newscore) {
this.teaId = teaid;
this.stuId = stuid;
this.courseId = courseid;
this.newScore = newscore;
this.flag1 = 0;
this.flag2 = 0;
}
public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
public String getTeaId() {
return teaId;
}
public void setTeaId(String teaId) {
this.teaId = teaId;
}
public String getStuId() {
return stuId;
}
public void setStuId(String stuId) {
this.stuId = stuId;
}
public String getCourseId() {
return courseId;
}
public void setCourseId(String courseId) {
this.courseId = courseId;
}
public int getNewScore() {
return newScore;
}
public void setNewScore(int newScore) {
this.newScore = newScore;
}
public int getFlag1() {
return flag1;
}
public void setFlag1(int flag1) {
this.flag1 = flag1;
}
public int getFlag2() {
return flag2;
}
public void setFlag2(int flag2) {
this.flag2 = flag2;
}
}
成绩类
package com.stuos.po;
/*
* 成绩类
*
* */
public class Score {
private int Id;//列表序号,主键
private String stuId;//学生学号
private String courseId;//课程号
private int score;//学生成绩
public Score() {
}
public Score(String stuid,String courseid,int s) {
this.stuId = stuid;
this.courseId = courseid;
this.score = s;
}
public int getId() {
return Id;
}
public void setId(int id) {
Id = id;
}
public String getStuId() {
return stuId;
}
public void setStuId(String stuId) {
this.stuId = stuId;
}
public String getCourseId() {
return courseId;
}
public void setCourseId(String courseId) {
this.courseId = courseId;
}
public int getScore() {
return score;
}
public void setScore(int score) {
this.score = score;
}
}
用户类
package com.stuos.po;
/*
* 用户类
*
* */
public class User {
private String userId;//用户身份标识符:1为管理员,2为专业负责人,3为班主任,4为教师,5为辅导员,6为秘书,7为学生
private String userAcc;//用户账号
private String userPwd;//用户密码
private String userName;//用户姓名
private int userAge;//用户年龄
private String userSex;//用户性别
public User(String id,String acc,String pwd) {//可以直接赋值的构造函数
this.userId = id;
this.userAcc = acc;
this.userPwd = pwd;
this.userName = "";
this.userAge = 0;
this.userSex = "";
}
public User() {
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public int getUserAge() {
return userAge;
}
public void setUserAge(int userAge) {
this.userAge = userAge;
}
public String getUserSex() {
return userSex;
}
public void setUserSex(String userSex) {
this.userSex = userSex;
}
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getUserAcc() {
return userAcc;
}
public void setUserAcc(String userAcc) {
this.userAcc = userAcc;
}
public String getUserPwd() {
return userPwd;
}
public void setUserPwd(String userPwd) {
this.userPwd = userPwd;
}
}
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)