• mybatis,spring,springmvc框架整合实例（SSM）

            SSM 编程，即 SpringMVC + Spring + MyBatis 整合，是当前最为流行的 JavaEE 开发技术架 构。其实 SSM 整合的实质，仅仅就是将 MyBatis 整合入 Spring 。因为 SpringMVC 原本就是 Spring
    的一部分，不用专门整合。
          SSM 整合的实现方式可分为两种：基于 XML 配置方式，基于注解方式。
    3.1 搭建 SSM 开发环境
    项目结构

     

    需求：完成学生注册和信息浏览。

    1 建表 Student

    数据库名称ssm1

     

     表名student，id属性设置为自增，其他属性默认保持不变

     2 新建 Web 工程

    工程名称ssm1

    3 maven 依赖 （pom.xml文件）

    1. <?xml version="1.0" encoding="UTF-8"?>
    2.  
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.   <modelVersion>4.0.0</modelVersion>
    6.  
    7.   <groupId>com.it</groupId>
    8.   <artifactId>ssm1</artifactId>
    9.   <version>1.0-SNAPSHOT</version>
    10.   <packaging>war</packaging>
    11.  
    12.  
    13.   <properties>
    14.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    15.     <maven.compiler.source>1.8</maven.compiler.source>
    16.     <maven.compiler.target>1.8</maven.compiler.target>
    17.   </properties>
    18.  
    19.   <dependencies>
    20.     <dependency>
    21.       <groupId>junit</groupId>
    22.       <artifactId>junit</artifactId>
    23.       <version>4.11</version>
    24.       <scope>test</scope>
    25.     </dependency>
    26. <!--servlet依赖-->
    27.     <dependency>
    28.       <groupId>javax.servlet</groupId>
    29.       <artifactId>javax.servlet-api</artifactId>
    30.       <version>3.1.0</version>
    31.       <scope>provided</scope>
    32.     </dependency>
    33.  
    34.     <!-- jsp依赖 -->
    35.     <dependency>
    36.       <groupId>javax.servlet.jsp</groupId>
    37.       <artifactId>jsp-api</artifactId>
    38.       <version>2.2.1-b03</version>
    39.       <scope>provided</scope>
    40.     </dependency>
    41. <!--springmvc依赖-->
    42.     <dependency>
    43.       <groupId>org.springframework</groupId>
    44.       <artifactId>spring-webmvc</artifactId>
    45.       <version>5.2.5.RELEASE</version>
    46.     </dependency>
    47. <!--事务的依赖-->
    48.     <dependency>
    49.       <groupId>org.springframework</groupId>
    50.       <artifactId>spring-tx</artifactId>
    51.       <version>5.2.5.RELEASE</version>
    52.     </dependency>
    53. <!--事务相关的依赖-->
    54.     <dependency>
    55.       <groupId>org.springframework</groupId>
    56.       <artifactId>spring-jdbc</artifactId>
    57.       <version>5.2.5.RELEASE</version>
    58.     </dependency>
    59. <!--jackson的依赖-->
    60.     <dependency>
    61.       <groupId>com.fasterxml.jackson.core</groupId>
    62.       <artifactId>jackson-core</artifactId>
    63.       <version>2.9.0</version>
    64.     </dependency>
    65.     <dependency>
    66.       <groupId>com.fasterxml.jackson.core</groupId>
    67.       <artifactId>jackson-databind</artifactId>
    68.       <version>2.9.0</version>
    69.   </dependency>
    70. <!--mybatis整合依赖-->
    71.     <dependency>
    72.       <groupId>org.mybatis</groupId>
    73.       <artifactId>mybatis-spring</artifactId>
    74.       <version>1.3.1</version>
    75.   </dependency>
    76. <!--mybatis依赖-->
    77.     <dependency>
    78.       <groupId>org.mybatis</groupId>
    79.       <artifactId>mybatis</artifactId>
    80.       <version>3.5.1</version>
    81.   </dependency>
    82. <!--mysql驱动的依赖-->
    83.     <dependency>
    84.       <groupId>mysql</groupId>
    85.       <artifactId>mysql-connector-java</artifactId>
    86.       <version>5.1.9</version>
    87.     </dependency>
    88. <!--druid数据库连接池依赖-->
    89.     <dependency>
    90.       <groupId>com.alibaba</groupId>
    91.       <artifactId>druid</artifactId>
    92.       <version>1.1.12</version>
    93.   </dependency>
    94.  
    95.   </dependencies>
    96.  
    97.   <build>
    98.     <resources>
    99.       <resource>
    100.         <directory>src/main/java</directory><!--所在的目录-->
    101.         <includes><!--包括目录下的.properties,.xml 文件都会扫描到-->
    102.           <include>**/*.properties</include>
    103.           <include>**/*.xml</include>
    104.         </includes>
    105.         <filtering>false</filtering>
    106.       </resource>
    107.     </resources>
    108.  
    109.     <plugins>
    110.       <plugin>
    111.         <artifactId>maven-compiler-plugin</artifactId>
    112.         <version>3.1</version>
    113.         <configuration>
    114.           <source>1.8</source>
    115.           <target>1.8</target>
    116.         </configuration>
    117.       </plugin>
    118.     </plugins>
    119.   </build>
    120. </project>
    4 定义包，组织程序的结构。

    jsp 文件：

     

    5 编写配置文件

    Jdbc 属性配置文件 jdbc.properties 

    1. jdbc.url=jdbc:mysql://localhost:3306/ssm1
    2. jdbc.username=root
    3. jdbc.password=123456

     Spring 配置文件 applicationContext.xml

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    6. <!--spring配置文件：声明service,dao,工具类等对象-->
    7.  
    8. <!--  声明数据库连接属性文件的位置-->
    9.     <context:property-placeholder location="classpath:conf/jdbc.properties"/>
    10. <!--  声明数据源，连接数据库-->
    11. <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
    12.       init-method="init" destroy-method="close">
    13.     <property name="url" value="${jdbc.url}"/>
    14.     <property name="username" value="${jdbc.username}"/>
    15.     <property name="password" value="${jdbc.password}"/>
    16. </bean>
    17.  
    18. <!-- 声明SqlSessionFactoryBean创建SqlSessionFactory-->
    19.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    20.         <property name="dataSource" ref="dataSource"/>
    21.         <property name="configLocation" value="classpath:conf/mybatis.xml"/>
    22.     </bean>
    23.  
    24. <!--  声明mybatis的扫描器，创建dao对象-->
    25.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    26.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    27.         <property name="basePackage" value="com.it.dao"/>
    28.     </bean>
    29.  
    30. <!--   声明service的注解@Service所在包名的位置-->
    31.     <context:component-scan base-package="com.it.service"/>
    32.  
    33. <!--  事物的配置：注解的配置，aspectJ的配置（二选一就可以了）-->
    34.  
    35.  
    36. </beans>
    Springmvc 配置文件： disaptcherServlet.xml 
    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <beans xmlns="http://www.springframework.org/schema/beans"
    3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.        xmlns:context="http://www.springframework.org/schema/context"
    5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7.         http://www.springframework.org/schema/beans/spring-beans.xsd
    8.          http://www.springframework.org/schema/context
    9.           https://www.springframework.org/schema/context/spring-context.xsd
    10.           http://www.springframework.org/schema/mvc
    11.           https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    12. <!--springmvc的配置文件，用来声明controller和其它web相关的对象-->
    13.  
    14. <!--  1.组件扫描器-->
    15. <context:component-scan base-package="com.it.controller"/>
    16. <!--   2.视图解析器-->
    17.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    18.         <property name="prefix" value="/WEB-INF/jsp/"/>
    19.         <property name="suffix" value=".jsp"/>
    20.     </bean>
    21. <!--  3.注解驱动，注意后缀是mvc结尾的注解驱动-->
    22.     <mvc:annotation-driven/>
    23. <!--该注解驱动的作用:
    24. 1.响应ajax请求，返回json
    25. 2.解决静态资源访问问题
    26. -->
    27. </beans>
    mybatis.xml 
    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6. <!-- settings：控制mybatis全局行为-->
    7.     <settings>
    8. <!--   设置mybatis输出日志-->
    9.         <setting name="logImpl" value="STDOUT_LOGGING"/>
    10.     </settings>
    11. <!--    设置别名,主要为了简化对于类名的指定-->
    12.     <typeAliases>
    13.         <package name="com.it.entity"/>
    14.     </typeAliases>
    15.  
    16. <!--sql映射文件的位置-->
    17.     <mappers>
    18. <!--  name:是包名，这个包中的所有mapper.xml一次都能够加载
    19. 使用package的要求：
    20. 1.mapper文件名和dao接口名必须完全一样，包括大小写
    21. 2.mapping文件和dao接口必须在同一目录
    22. -->
    23.         <package name="com.it.dao"/>
    24.     </mappers>
    25. </configuration>
    6 定义 web.xml 
    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
    5.          version="4.0">
    6. <!--  注册中央调度器-->
    7.     <servlet>
    8.         <servlet-name>springmvc</servlet-name>
    9.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    10.         <init-param>
    11.             <param-name>contextConfigLocation</param-name>
    12.             <param-value>classpath:conf/dispatcherServlet.xml</param-value>
    13.         </init-param>
    14.         <load-on-startup>1</load-on-startup>
    15.     </servlet>
    16.     <servlet-mapping>
    17.         <servlet-name>springmvc</servlet-name>
    18.         <url-pattern>*.do</url-pattern>
    19.     </servlet-mapping>
    20.  
    21. <!--  注册spring的监听器-->
    22.     <listener>
    23.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    24.     </listener>
    25.     <context-param>
    26.         <param-name>contextConfigLocation</param-name>
    27.         <param-value>classpath:conf/applicationContext.xml</param-value>
    28.     </context-param>
    29.  
    30.  
    31.     <!--    注册字符集过滤器-->
    32.     <filter>
    33.         <filter-name>characterEncodingFilter</filter-name>
    34.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    35.         <init-param>
    36.             <param-name>encoding</param-name>
    37.             <param-value>utf-8</param-value>
    38.         </init-param>
    39.         <init-param>
    40.             <param-name>forceRequestEncoding</param-name>
    41.             <param-value>true</param-value>
    42.         </init-param>
    43.         <init-param>
    44.             <param-name>forceResponseEncoding</param-name>
    45.             <param-value>true</param-value>
    46.         </init-param>
    47.     </filter>
    48.     <filter-mapping>
    49.         <filter-name>characterEncodingFilter</filter-name>
    50.         <url-pattern>/*</url-pattern>
    51.     </filter-mapping>
    52.  
    53. </web-app>
    7 实体类 Student 
    1. package com.it.entity;
    2.  
    3. public class Student {
    4.     private Integer id;
    5.     private String name;
    6.     private Integer age;
    7.  
    8.     public Integer getId() {
    9.         return id;
    10.     }
    11.  
    12.     public void setId(Integer id) {
    13.         this.id = id;
    14.     }
    15.  
    16.     public String getName() {
    17.         return name;
    18.     }
    19.  
    20.     public void setName(String name) {
    21.         this.name = name;
    22.     }
    23.  
    24.     public Integer getAge() {
    25.         return age;
    26.     }
    27.  
    28.     public void setAge(Integer age) {
    29.         this.age = age;
    30.     }
    31.  
    32.     @Override
    33.     public String toString() {
    34.         return "Student{" +
    35.                 "id=" + id +
    36.                 ", name='" + name + '\'' +
    37.                 ", age=" + age +
    38.                 '}';
    39.     }
    40. }
    8 Dao 接口和 sql 映射文件
    dao接口StudentDAO 
    1. package com.it.dao;
    2.  
    3. import com.it.entity.Student;
    4.  
    5. import java.util.List;
    6.  
    7. public interface StudentDao {
    8.     int insertStudent(Student student);
    9.     List<Student> selectStudents();
    10. }
    sql映射文件StudentDao.xml 
    1. <?xml version="1.0" encoding="UTF-8" ?>
    2.  
    3. <!DOCTYPE mapper
    4.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    5.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    6. <mapper namespace="com.it.dao.StudentDao">
    7.     <select id="selectStudents" resultType="com.it.entity.Student">
    8. select id,name,age from student order by id desc
    9.     </select>
    10.     <insert id="insertStudent">
    11.         insert into student(name,age) values(#{name},#{age})
    12.     </insert>
    13. </mapper>
    14.  
    15.
    9 Service 接口和实现类
    service接口StudentService 
    1. package com.it.service;
    2.  
    3. import com.it.entity.Student;
    4.  
    5. import java.util.List;
    6.  
    7. public interface StudentService {
    8.     int addStudent(Student student);
    9.     List<Student> queryStudents();
    10. }

    实现类StudentServiceImpl

    1. package com.it.service.impl;
    2.  
    3. import com.it.dao.StudentDao;
    4. import com.it.entity.Student;
    5. import com.it.service.StudentService;
    6. import org.springframework.stereotype.Service;
    7.  
    8. import javax.annotation.Resource;
    9. import java.util.List;
    10. @Service
    11. public class StudentServiceImpl implements StudentService {
    12.     //引用类型的自动注入，@Autowired,@Resource
    13.     @Resource
    14.     private StudentDao studentDao;
    15.  
    16.     @Override
    17.     public int addStudent(Student student) {
    18.         int i = studentDao.insertStudent(student);
    19.         return i;
    20.     }
    21.  
    22.     @Override
    23.     public List<Student> queryStudents() {
    24.         List<Student> students = studentDao.selectStudents();
    25.         return students;
    26.     }
    27. }
    10 处理器定义 
    1. package com.it.controller;
    2.  
    3. import com.it.entity.Student;
    4. import com.it.service.StudentService;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Controller;
    7. import org.springframework.web.bind.annotation.RequestMapping;
    8. import org.springframework.web.bind.annotation.ResponseBody;
    9. import org.springframework.web.servlet.ModelAndView;
    10.  
    11. import java.util.List;
    12.  
    13. @Controller
    14. @RequestMapping(value = "/student")
    15. public class StudentController {
    16. @Autowired
    17.     private StudentService service;
    18.  
    19.     //注册学生
    20.     @RequestMapping(value = "/addStudent.do")
    21.     public ModelAndView addStudent(Student student){
    22.         ModelAndView mv=new ModelAndView();
    23.         String tips="注册失败";
    24.         //调用service处理student
    25.         int i = service.addStudent(student);
    26.         if (i>0){
    27.             //注册成功
    28.             tips="学生【"+student.getName()+"】注册成功！";
    29.         }
    30.         //添加数据
    31.         mv.addObject("tips",tips);
    32.         //指定结果页面
    33.         mv.setViewName("result");
    34.         return mv;
    35.     }
    36.  
    37.     //处理学生的查询，响应ajax
    38.     @RequestMapping(value = "/queryStudent.do")
    39.     @ResponseBody
    40.     public List<Student> queryStudent(){
    41.         //参数检查，简单的数据处理
    42.         List<Student> students = service.queryStudents();
    43.         return students;
    44.     }
    45. }
    11 定义视图 - 首页文件 --- index.jsp 
    1.  
    2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    3. <%
    4.     String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()
    5.             +request.getServerName()+"/";
    6. %>
    7. <html>
    8. <head>
    9.     <title>用户操作的功能入口</title>
    10.     <base href="<%=basePath%>"/>
    11. </head>
    12. <body>
    13. <div align="center">
    14. <p>SSM整合的例子</p>
    15.     <img src="images/pic1.jpg" width="1000px" height="500px">
    16.     <table>
    17.         <tr>
    18.             <td><a href="addStudent.jsp">注册学生</a></td>
    19.         </tr>
    20.         <tr>
    21.             <td><a href="listStudent.jsp">浏览学生</a></td>
    22.         </tr>
    23.     </table>
    24. </div>
    25. </body>
    26. </html>
    12 注册学生页面 --- addStudent.jsp 
    1.  
    2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    3. <%
    4.     String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()
    5.     +request.getServerName()+"/";
    6. %>
    7. <html>
    8. <head>
    9.     <title>注册学生</title>
    10.     <base href="<%=basePath%>"/>
    11. </head>
    12. <body>
    13. <div align="center">
    14.     <form action="student/addStudent.do" method="post">
    15.         <table>
    16.             <tr>
    17.                 <td>姓名：</td>
    18.                 <td><input type="text" name="name"></td>
    19.             </tr>
    20.             <tr>
    21.                 <td>年龄：</td>
    22.                 <td><input type="text" name="age"></td>
    23.             </tr>
    24.             <tr>
    25.                 <td>
    26.                     <input type="submit" value="注册">
    27.                 </td>
    28.             </tr>
    29.         </table>
    30.     </form>
    31. </div>
    32. </body>
    33. </html>
    13 浏览学生页面 --- listStudent.jsp 
    1.  
    2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    3. <%
    4.     String basePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()
    5.             +request.getServerName()+"/";
    6. %>
    7. <html>
    8. <head>
    9.     <title>查询学生ajax</title>
    10.     <base href="<%=basePath%>"/>
    11.     <script type="text/javascript" src="js/jquery-3.3.1.min.js"></script>
    12.     <script type="text/javascript">
    13.         $(function () {
    14.             //在当前页面dom对象加载后，执行loadStudentData()
    15.             loadStudentData();
    16.             $("#btnLoader").click(function () {
    17.                 loadStudentData();
    18.             })
    19.             function loadStudentData() {
    20.                 $.ajax({
    21.                     url:"student/queryStudent.do",
    22.                     type:"post",
    23.                     dataType:"json",
    24.                     success:function (data) {
    25.                         //清除旧的数据
    26.                         $("#info").html("");
    27.                         //增加新的数据
    28.                         $.each(data,function (i,n) {
    29.                             $("#info").append("<tr>")
    30.                                 .append("<td>"+n.id+"</td>")
    31.                                 .append("<td>"+n.name+"</td>")
    32.                                 .append("<td>"+n.age+"</td>")
    33.                                 .append("</tr>")
    34.                         })
    35.                     }
    36.                 })
    37.             }
    38.         })
    39.     </script>
    40. </head>
    41. <body>
    42. <div align="center">
    43.     <table>
    44.     <thead>
    45.     <tr>
    46.         <td>学号</td>
    47.         <td>姓名</td>
    48.         <td>年龄</td>
    49.     </tr>
    50.     </thead>
    51.     <tbody id="info">
    52.  
    53.     </tbody>
    54.         <input type="button" id="btnLoader"value="查询数据">
    55.     </table>
    56. </div>
    57. </body>
    58. </html>
    14 注册结果页面 --- result.jsp 
    1.  
    2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    3. <html>
    4. <head>
    5.     <title>Title</title>
    6. </head>
    7. <body>
    8. result.jsp页面，注册结果是：${tips}
    9. </body>
    10. </html>

    项目结果

    运行项目后自动进入首界面

     1.点击注册学生链接

    这是数据库中原本存在的数据

     

    点击 注册

    查看数据库是否成功添加

    可以看到已经成功添加

    2.返回首页，点击浏览学生链接

  • 相关阅读:
    计算机网络(自顶向下方法)-应用层
    Java基于springboot+vue的共享电动车管理系统 nodejs
    【20221105】【每日一题】删除二叉搜索树中的节点
    【JavaScript】-- 继承
    npm发布vue3自定义组件库--方法一
    抗击疫情静态HTML网页作业作品 大学生抗疫感动专题页设计制作成品 简单DIV CSS布局网站
    记录C++类中的一次函数调用
    Vue学习笔记（六）回顾Object.defineproperty方法
    无胁科技-TVD每日漏洞情报-2022-11-15
    SpringBoot读取json文件
  • 原文地址：https://blog.csdn.net/weixin_59334478/article/details/125414719