SSM整合实现学生管理系统

沉河不浮

已于 2022-04-30 11:31:19 修改

阅读量1.6k

点赞数 1

分类专栏：笔记 java 文章标签： spring

于 2022-04-24 14:28:57 首次发布

本文链接：https://blog.csdn.net/weixin_55850954/article/details/124381672

版权

笔记同时被 2 个专栏收录

48 篇文章 1 订阅

订阅专栏

java

29 篇文章 0 订阅

订阅专栏

SSM整合实现学生管理系统

我们这里使用的是IDEA社区版，通过maven项目进行整合
首先先创建一个maven项目，选择webapp的工件
项目创建完毕后，我们先在pom.xml引入相关依赖

<dependencies>
	<!--spring相关依赖-->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-context</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
     <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-tx</artifactId>
      <version>5.0.5.RELEASE</version>
    </dependency>
    <!--织入的相关依赖-->
    <dependency>
      <groupId>org.aspectj</groupId>
      <artifactId>aspectjweaver</artifactId>
      <version>1.8.4</version>
    </dependency>
    <!--c3p0连接池依赖-->
    <dependency>
      <groupId>c3p0</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.1.2</version>
    </dependency>
    <!--mysql数据库依赖-->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.27</version>
    </dependency>
    <!--mybatis依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.4.5</version>
    </dependency>
    <!--mybatis连接spring的依赖-->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>
    <!--Junit测试依赖-->
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.12</version>
    </dependency>
    <!--servlet的相关依赖-->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>2.5</version>
    </dependency>
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jsp-api</artifactId>
      <version>2.0</version>
    </dependency>
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
    </dependency>
  </dependencies>

我们在src/main/java目录下，创建一个包，用来保存我们的基本类型,我们创建一个软件包，假设命名为com.koyi.domain，包下创建Student.java类

/**
 * Student实体类
 * id：学号
 * name：姓名
 * grade：年级
 * major：专业
 */
public class Student {
    private Integer id;
    private String name;
    private String grade;
    private String major;
    public Integer getId() {
        return id;
    }
    public void setId(Integer id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getGrade() {
        return grade;
    }
    public void setGrade(String grade) {
        this.grade = grade;
    }
    public String getMajor() {
        return major;
    }
    public void setMajor(String major) {
        this.major = major;
    }
    @Override
    public String toString(){
        return "Student{id="+id+",name="+name+",grade="+grade+
                ",major="+major+"}";
    }
}

在src/main/java目录下，在创建一个包，名为com.koyi.service,在该包下创建StudentService.java

/**
 * StudentService接口
 * saveStudent:保存学生
 * updateStudent：更新学生
 * deleteStudent：删除学生
 * getById：通过id获取学生信息
 * listStudent：获取学生列表
 */
public interface StudentService {
    void saveStudent(Student student);
    void updateStudent(Student student);
    void deleteStudent(Integer id);
    Student getById(Integer id);
    List<Student>listStudent();
}

在该包下再创建一个包impl,在impl包下创建StudentServiceImpl,代码如下：

/**
 * StudentService的实现类
 */
@Service("studentService")
public class StudentServiceImpl implements StudentService {
    //注入StudentMapper
    @Autowired
    private StudentMapper studentMapper;
    public void saveStudent(Student student) {
        studentMapper.saveStudent(student);
    }
    public void updateStudent(Student student) {
        studentMapper.updateStudent(student);
    }
    public void deleteStudent(Integer id) {
        studentMapper.deleteStudent(id);
    }
    public Student getById(Integer id) {
        return studentMapper.getById(id);
    }
    public List<Student> listStudent() {
        return studentMapper.listStudent();
    }
}

在src/main/java目录下，创建com.young.mapper包，包下创建StudentMapper

/**
 * StudentMapper接口
 */
public interface StudentMapper {
    void saveStudent(Student student);
    void updateStudent(Student student);
    void deleteStudent(Integer id);
    Student getById(Integer id);
    List<Student> listStudent();
}

在src/main/java目录下，创建com.young.controller软件包，在包下创建StudentController.java

/**
 * 控制层
 */
@Controller
@RequestMapping("/student")
public class StudentController {
    @Autowired
    private StudentService studentService;
    //添加学生
    @RequestMapping("/saveStudent")
    public String saveStudent(Student student){
        studentService.saveStudent(student);
        return "forward:/student/listStudent";
    }
    //编辑学生
    @RequestMapping("/editStudent")
    public ModelAndView editStudent(HttpServletRequest request){
        Integer id=Integer.parseInt(request.getParameter("id"));
        Student student=studentService.getById(id);
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.addObject("student",student);
        modelAndView.setViewName("/student/editStudent");
        return modelAndView;
    }
    //更新学生
    @RequestMapping("/updateStudent")
    public String updateStudent(Student student){
        studentService.updateStudent(student);
        return "forward:/student/listStudent";
    }
    //删除学生
    @RequestMapping("/deleteStudent")
    public String deleteStudent(HttpServletRequest request){
        Integer id=Integer.parseInt(request.getParameter("id"));
        studentService.deleteStudent(id);
        return "forward:/student/listStudent";
    }
    //展示学生
    @RequestMapping("/listStudent")
    public ModelAndView listStudent(){
        List<Student>studentList=studentService.listStudent();
        ModelAndView modelAndView=new ModelAndView();
        modelAndView.addObject("studentList",studentList);
        modelAndView.setViewName("/student/listStudent");
        return modelAndView;
    }
}

在src/main/resource目录下，创建com/koyi/maper目录，在该目录下，创建StudentMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.koyi.mapper.StudentMapper">
    <insert id="saveStudent" parameterType="com.koyi.domain.Student">
        insert into student values(#{id},#{name},#{grade},#{major})
    </insert>
    <delete id="deleteStudent" parameterType="int">
        delete from student where id=#{id}
    </delete>
    <update id="updateStudent" parameterType="com.koyi.domain.Student">
        update student set name=#{name},grade=#{grade},major=#{major}
        where id=#{id}
    </update>
    <select id="getById" parameterType="int" resultType="com.koyi.domain.Student">
        select * from student
        where id=#{id}
    </select>
    <select id="listStudent" resultType="com.koyi.domain.Student">
        select * from student
    </select>
</mapper>

在src/main/resource目录下，创建jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/young?useSSL=false&serverTimezone=UTC
jdbc.username=root
jdbc.password=3fa4d180

创建sqlMapConfig-spring.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <package name="com.koyi.domain"/>
    </typeAliases>
</configuration>

创建sqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--加载properties文件-->
    <properties resource="jdbc.properties"/>
    <!--定义别名-->
    <typeAliases>
        <package name="com.koyi.domain"/>
    </typeAliases>
    <!--环境-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/> 
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载映射-->
    <mappers>
        <package name="com.koyi.mapper"/>
    </mappers>
</configuration>

创建applicationContext.xml

<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:tx="http://www.springframework.org/schema/tx"
       xmlns:aop="http://www.springframework.org/schema/aop"
       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/tx http://www.springframework.org/schema/tx/spring-tx.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
    <!--组件扫描-->
    <context:component-scan base-package="com.koyi">
        <!--排除controller扫描-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <!--加载properties文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <!--配置数据源信息-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>
    <!--配置SessionFactory-->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
        <!--加载mybatis核心文件-->
        <property name="configLocation" value="classpath:sqlMapConfig.xml"/>
    </bean>
    <!--扫描mapper所在的包，为mapper创建实现类-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.koyi.mapper"/>
    </bean>
    <!--声明事务控制-->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    <!--配置事务增强-->
    <tx:advice id="txAdvice">
        <tx:attributes>
            <tx:method name="*"/>
        </tx:attributes>
    </tx:advice>
    <!--事务的aop织入-->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.koyi.service.impl.*.*(..))"/>
    </aop:config>
</beans>

添加spring-mvc.xml

<?xml version="1.0" encoding="UTF-8" ?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:context="http://www.springframework.org/schema/context"
       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">
    <!--组件扫描 主要扫描controller-->
    <context:component-scan base-package="com.young.controller"></context:component-scan>
    <!--配置MVC注解驱动-->
    <mvc:annotation-driven/>
    <!--内部资源视图解析器-->
    <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages"/>
        <property name="suffix" value=".jsp"/>
    </bean>
    <!--开放静态资源访问权限-->
    <mvc:default-servlet-handler/>
</beans>

修改webapp/WEB-INF/web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app version="2.4"
         xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <servlet>
        <servlet-name>DispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
 <filter>
   <filter-name>CharacterEncodingFilter</filter-name>
   <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
   <init-param>
     <param-name>encoding</param-name>
     <param-value>UTF-8</param-value>
   </init-param>
   <init-param>
     <param-name>forceEncoding</param-name>
     <param-value>true</param-value>
   </init-param>
 </filter>
  <filter-mapping>
    <filter-name>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
  </filter-mapping>
</web-app>

在webapp目录下，创建index.jsp

<%response.sendRedirect(request.getContextPath()+"/student/listStudent.action");%>

在WEB-INF目录下，创建pages目录，在pages目录下，创建student目录，在该目录下创建editStudent.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" pageEncoding="UTF-8"%>
<html>
<head>
<title>修改学生页面</title>
<base href="${pageContext.request.contextPath}/pages/student/editStudent.jsp">
</head>
<body>
    <form action="${pageContext.request.contextPath}/student/updateStudent" method="post">
    姓名：<input type="text" name="name" value="${student.name}"><br>
    年级：<input type="text" name="grade" value="${student.grade}"><br>
    专业：<input type="text" name="major" value="${student.major}"><br>
    <input type="text" name="id" value="${student.id}" hidden><br>
    <input type="submit" value="修改">
    <button style="width:50px;height:30px;"><a href="student/listStudent.action">返回</a></button>
    </form>
</body>
</html>

listStudent.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
<title>学生列表</title>
<style>
    td{
        border:1px solid;
    }
</style>
</head>
<body>
    <form action="${pageContext.request.contextPath}/student/saveStudent" method="post">
    姓名：<input type="text" name="name"><br>
    年级：<input type="text" name="grade"><br>
    专业：<input type="text" name="grade"><br>
    <input type="submit" value="添加"/>
    </form>
    <hr>
    <table style="width:100%;border:1px solid;">
    <tr>
    <td>学号</td>
    <td>姓名</td>
    <td>年级</td>
    <td>专业</td>
    <td>编辑</td>
    <td>删除</td>
    </tr>
    <c:forEach items="${studentList}" var="student">
    <tr>
        <td>${student.id}</td>
        <td>${student.name}</td>
        <td>${student.grade}</td>
        <td>${student.major}</td>
        <td><a href="${pageContext.request.contextPath}/student/editStudent.action?id=${student.id}">编辑</a></td>
        <td><a href="${pageContext.request.contextPath}/student/deleteStudent.action?id=${student.id}">删除</a></td>
    </tr>
    </c:forEach>
    </table>
</body>
</html>

配置Tomcat，完整结构目录如下：
在这里插入图片描述
效果如下：

沉河不浮

关注

1
点赞
踩
29

收藏

觉得还不错? 一键收藏
2
评论
SSM整合实现学生管理系统

SSM整合实现学生管理系统我们这里使用的是IDEA社区版，通过maven项目进行整合首先先创建一个maven项目，选择webapp的工件项目创建完毕后，我们先在pom.xml引入相关依赖<dependencies>  <dependency> <groupId>org.springframework</groupId> <artifactId>spring-co
复制链接

扫一扫