• SpringMVC：SSM整合（动力）

     

    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.bjpowernode</groupId>
    8.   <artifactId>ch07-ssm</artifactId>
    9.   <version>1.0-SNAPSHOT</version>
    10.   <packaging>war</packaging>
    11.  
    12.   <properties>
    13.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    14.     <maven.compiler.source>1.8</maven.compiler.source>
    15.     <maven.compiler.target>1.8</maven.compiler.target>
    16.   </properties>
    17.  
    18.   <dependencies>
    19.     <dependency>
    20.       <groupId>junit</groupId>
    21.       <artifactId>junit</artifactId>
    22.       <version>4.11</version>
    23.       <scope>test</scope>
    24.     </dependency>
    25.     <!--Servlet依赖-->
    26.     <dependency>
    27.       <groupId>javax.servlet</groupId>
    28.       <artifactId>javax.servlet-api</artifactId>
    29.       <version>3.1.0</version>
    30.       <scope>provided</scope>
    31.     </dependency>
    32.     <!--jsp依赖-->
    33.     <dependency>
    34.       <groupId>javax.servlet.jsp</groupId>
    35.       <artifactId>jsp-api</artifactId>
    36.       <version>2.2.1-b03</version>
    37.       <scope>provided</scope>
    38.     </dependency>
    39.  
    40.     <!--springmvc依赖-->
    41.     <dependency>
    42.       <groupId>org.springframework</groupId>
    43.       <artifactId>spring-webmvc</artifactId>
    44.       <version>5.2.5.RELEASE</version>
    45.     </dependency>
    46.  
    47.     <!--事务依赖-->
    48.     <dependency>
    49.       <groupId>org.springframework</groupId>
    50.       <artifactId>spring-tx</artifactId>
    51.       <version>5.2.5.RELEASE</version>
    52.     </dependency>
    53.  
    54.     <!--jdbc-->
    55.     <dependency>
    56.       <groupId>org.springframework</groupId>
    57.       <artifactId>spring-jdbc</artifactId>
    58.       <version>5.2.5.RELEASE</version>
    59.     </dependency>
    60.  
    61.     <!--jackon依赖-->
    62.     <dependency>
    63.       <groupId>com.fasterxml.jackson.core</groupId>
    64.       <artifactId>jackson-databind</artifactId>
    65.       <version>2.9.0</version>
    66.     </dependency>
    67.  
    68.     <!--mybatis依赖-->
    69.     <dependency>
    70.       <groupId>org.mybatis</groupId>
    71.       <artifactId>mybatis</artifactId>
    72.       <version>3.5.1</version>
    73.     </dependency>
    74.  
    75.     <!--mybatis与spring整合-->
    76.     <dependency>
    77.       <groupId>org.mybatis</groupId>
    78.       <artifactId>mybatis-spring</artifactId>
    79.       <version>1.3.1</version>
    80.     </dependency>
    81.  
    82.     <!--mysql依赖-->
    83.     <dependency>
    84.       <groupId>mysql</groupId>
    85.       <artifactId>mysql-connector-java</artifactId>
    86.       <version>5.1.9</version>
    87.     </dependency>
    88.  
    89.     <!--阿里巴巴连接池依赖-->
    90.     <dependency>
    91.       <groupId>com.alibaba</groupId>
    92.       <artifactId>druid</artifactId>
    93.       <version>1.1.12</version>
    94.     </dependency>
    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>

    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.     <!--    声明，注册springmvc的核心对象DispatcherServlet-->
    7.     <servlet>
    8.         <servlet-name>myweb</servlet-name>
    9.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    10.  
    11.         <!--        自定义springmvc读取的配置文件的位置-->
    12.         <init-param>
    13.             <!--springmvc的配置文件属性-->
    14.             <param-name>contextConfigLocation</param-name>
    15.             <!-- 指定自定义文件的位置-->
    16.             <param-value>classpath:conf/dispatcherServlet.xml</param-value>
    17.         </init-param>
    18.  
    19.         <!--        在tomcat启动后，创建Servlet对象
    20.                        load-on-startup:表示tomcat启动后创建对象的顺序，它的值是正数，数值越小 tomacat创建对象越早
    21.         -->
    22.         <load-on-startup>1</load-on-startup>
    23.  
    24.     </servlet>
    25.  
    26.     <!--    所有的*..do请求交给myweb中央处理器处理-->
    27.     <servlet-mapping>
    28.         <servlet-name>myweb</servlet-name>
    29.         <url-pattern>*.do</url-pattern>
    30.     </servlet-mapping>
    31.  
    32.     <!--注册spring的监听器-->
    33.     <context-param>
    34.         <param-name>contextConfigLocation</param-name>
    35.         <param-value>classpath:conf/applicationContext.xml</param-value>
    36.     </context-param>
    37.     <listener>
    38.         <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    39.     </listener>
    40.  
    41.     <!--注册声明过滤器，解决post请求乱码问题-->
    42.     <filter>
    43.         <filter-name>characterEncodingFilter</filter-name>
    44.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    45.  
    46.         <!--设置项目中使用的编码-->
    47.         <init-param>
    48.             <param-name>encoding</param-name>
    49.             <param-value>utf-8</param-value>
    50.         </init-param>
    51.         <!--强制请求对象（HttpServletRequest）使用encoding编码的值-->
    52.         <init-param>
    53.             <param-name>forceRequestEncoding</param-name>
    54.             <param-value>true</param-value>
    55.         </init-param>
    56.         <!--强制应答对象（HttpServletResponse）使用encoding编码的值-->
    57.         <init-param>
    58.             <param-name>forceReponsetEncoding</param-name>
    59.             <param-value>true</param-value>
    60.         </init-param>
    61.     </filter>
    62.     <filter-mapping>
    63.         <filter-name>characterEncodingFilter</filter-name>
    64.         <!--
    65.            /*:表示强制所有的请求先通过过滤器处理
    66.          -->
    67.         <url-pattern>/*</url-pattern>
    68.     </filter-mapping>
    69. </web-app>

    springmvc配置文件：dispatcherServlet：

    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 http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/mvc https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    7.  
    8.     <!--springmvc配置文件，声明controller和其他web相关的对象-->
    9.  
    10.     <!--注解扫描器：包扫描-->
    11.     <context:component-scan base-package="com.bjpowernode.controller"/>
    12.  
    13.     <!--    声明springmvc框架中的视图解析器，帮助开发人员设置视图文件的路径-->
    14.      <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    15.          <!-- 前缀：视图文件的路径-->
    16.          <property name="prefix" value="/WEB-INF/jsp/"/>
    17.          <!-- 后缀：视图文件的扩展名-->
    18.          <property name="suffix" value=".jsp"/>
    19.      </bean>
    20.  
    21.     <!--注解驱动
    22.        1.响应ajax请求，返回json
    23.        2.解决静态资源访问问题
    24.     -->
    25.     <mvc:annotation-driven/>
    26. </beans>

    jdbc.properties:

    1. jdbc.url=jdbc:mysql://localhost:3306/springdb
    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.  
    7.     <!--spring的配置文件：声明Service dao 工具类等对象-->
    8.  
    9.  
    10.     <!--  声明数据库连接文件的位置-->
    11.     <context:property-placeholder location="classpath:conf/jdbc.properties"/>
    12.  
    13.  
    14.     <!--  声明数据源，连接数据库-->
    15.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource"
    16.           init-method="init" destroy-method="close">
    17.         <property name="url" value="${jdbc.url}"/>
    18.         <property name="username" value="${jdbc.username}"/>
    19.         <property name="password" value="${jdbc.password}"/>
    20.     </bean>
    21.  
    22.     <!-- 声明SqlSessionFactoryBean创建SqlSessionFactory-->
    23.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    24.         <property name="dataSource" ref="dataSource"/>
    25.         <property name="configLocation" value="classpath:conf/mybatis.xml"/>
    26.     </bean>
    27.  
    28.  
    29.     <!--  声明mybatis的扫描器，创建dao对象-->
    30.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    31.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    32.         <property name="basePackage" value="com.bjpowernode.dao"/>
    33.     </bean>
    34.  
    35.     <!--   声明service的注解@Service所在包名的位置-->
    36.     <context:component-scan base-package="com.bjpowernode.service"/>
    37.  
    38.     <!--事物的配置：注解的配置，aspectj的配置,这里没配置-->
    39.  
    40. </beans>

    mybatis主配置文件: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.     <!--设置日志-->
    7.     <!--<settings>
    8.         <setting name="logImpl" value="STDOUT_LOGGING"/>
    9.     </settings>-->
    10.  
    11.     <!--    设置别名-->
    12.     <typeAliases>
    13.         <!--name:实体类所在的包名（不是实体类的包名也可以）-->
    14.         <package name="com.bjpowernode.domain"/>
    15.     </typeAliases>
    16.  
    17.     <!--sql mapper（映射文件）的位置-->
    18.     <mappers>
    19.         <!--  name:是包名，这个包中的所有mapper.xml一次都能够加载
    20.         使用package的要求：
    21.         1.mapper文件名和dao接口名必须完全一样，包括大小写
    22.         2.mapping文件和dao接口必须在同一目录
    23.         -->
    24.         <package name="com.bjpowernode.dao"/>
    25.     </mappers>
    26.  
    27. </configuration>

    Student:

    1. package com.bjpowernode.domain;
    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.  
    41. }

    StudentDao：

    1. package com.bjpowernode.dao;
    2.  
    3.  
    4.  
    5. import com.bjpowernode.domain.Student;
    6.  
    7. import java.util.List;
    8.  
    9. public interface StudentDao {
    10.     //插入方法
    11.     int insertStudent(Student student);
    12.  
    13.     //查询方法
    14.     List<Student> selectStudents();
    15.  
    16. }

     Mapper文件：StudentDao.xml:

    1. <?xml version="1.0" encoding="UTF-8" ?>
    2. <!DOCTYPE mapper
    3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="com.bjpowernode.dao.StudentDao">
    6.     <!--使用insert，update，delete，select标签来写sql语句-->
    7.  
    8.     <select id="selectStudents" resultType="com.bjpowernode.domain.Student">
    9.         select id,name,age from student order by id desc
    10.     </select>
    11.  
    12.     <insert id="insertStudent">
    13.         insert into student(name,age) values(#{name},#{age})
    14.     </insert>
    15.  
    16. </mapper>

     StudentService:

    1. package com.bjpowernode.service;
    2.  
    3. import com.bjpowernode.domain.Student;
    4.  
    5. import java.util.List;
    6.  
    7. public interface StudentService {
    8.     int addStudent(Student student);
    9.  
    10.     List<Student> queryStudents();
    11.  
    12. }

    StudentServiceImpl:

    1. package com.bjpowernode.service;
    2.  
    3. import com.bjpowernode.dao.StudentDao;
    4. import com.bjpowernode.domain.Student;
    5. import org.springframework.stereotype.Service;
    6.  
    7. import javax.annotation.Resource;
    8. import java.util.List;
    9. @Service
    10. public class StudentServiceImpl implements StudentService {
    11.     //引用类型的自动注入，@Autowired,@Resource
    12.     @Resource
    13.     private StudentDao studentDao;
    14.  
    15.     @Override
    16.     public int addStudent(Student student) {
    17.         int nums = studentDao.insertStudent(student);
    18.         return nums;
    19.     }
    20.  
    21.     @Override
    22.     public List<Student> queryStudents() {
    23.         List<Student> students = studentDao.selectStudents();
    24.         return students;
    25.     }
    26.  
    27. }

    StudentController：

    1. package com.bjpowernode.controller;
    2.  
    3. import com.bjpowernode.domain.Student;
    4. import com.bjpowernode.service.StudentService;
    5. import org.springframework.stereotype.Controller;
    6. import org.springframework.web.bind.annotation.RequestMapping;
    7. import org.springframework.web.bind.annotation.ResponseBody;
    8. import org.springframework.web.servlet.ModelAndView;
    9.  
    10. import javax.annotation.Resource;
    11. import java.util.List;
    12.  
    13. @Controller
    14. @RequestMapping(value = "/student")
    15. public class StudentController {
    16.     @Resource
    17.     private StudentService service;
    18.  
    19.     @RequestMapping(value = "/addStudent.do")
    20.     public ModelAndView addStudent(Student student){
    21.         //调用service处理student
    22.         ModelAndView mv=new ModelAndView();
    23.         String tips="注册失败";
    24.  
    25.         //调用service处理student
    26.         int nums = service.addStudent(student);
    27.         if (nums>0){
    28.             //注册成功
    29.             tips="学生【"+student.getName()+"】注册成功！";
    30.         }
    31.         //添加数据
    32.         mv.addObject("tips",tips);
    33.         //指定结果页面
    34.         mv.setViewName("result");
    35.         return mv;
    36.     }
    37.  
    38.  
    39.     //处理学生的查询，响应ajax
    40.     @RequestMapping(value = "/queryStudent.do")
    41.     @ResponseBody
    42.     public List<Student> queryStudent(){
    43.         //参数检查，简单的数据处理
    44.         List<Student> students = service.queryStudents();
    45.         return students;
    46.     }
    47.  
    48. }

    index.jsp:

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: DELL
    4.   Date: 2022/6/23
    5.   Time: 22:09
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <%
    10.     String path = request.getContextPath();
    11.     String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
    12. %>
    13. <html>
    14. <head>
    15.     <title>Title</title>
    16.     <base href="<%=basePath%>">
    17. </head>
    18. <body>
    19. <div align="center">
    20.     <p>SSM整合的例子</p>
    21.     <img src="images/b.jpg">
    22.     <table>
    23.         <tr>
    24.             <td><a href="addStudent.jsp">注册学生</a></td>
    25.         </tr>
    26.         <tr>
    27.             <td><a href="listStudent.jsp">浏览学生</a></td>
    28.         </tr>
    29.     </table>
    30. </div>
    31. </body>
    32. </html>

    addStudent.jsp:

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: DELL
    4.   Date: 2022/6/23
    5.   Time: 21:31
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <%
    10.     String path = request.getContextPath();
    11.     String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
    12. %>
    13. <html>
    14.  
    15. <head>
    16.     <title>注册学生</title>
    17.     <base href="<%=basePath%>"/>
    18. </head>
    19. <body>
    20. <div align="center">
    21.     <form action="student/addStudent.do" method="post">
    22.         <table>
    23.             <tr>
    24.                 <td>姓名：</td>
    25.                 <td><input type="text" name="name"></td>
    26.             </tr>
    27.             <tr>
    28.                 <td>年龄：</td>
    29.                 <td><input type="text" name="age"></td>
    30.             </tr>
    31.             <tr>
    32.                 <td>
    33.                     <input type="submit" value="注册">
    34.                 </td>
    35.             </tr>
    36.         </table>
    37.     </form>
    38. </div>
    39. </body>
    40. </html>

    listStudent.jsp:

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: DELL
    4.   Date: 2022/6/23
    5.   Time: 22:35
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    9. <%
    10.     String path = request.getContextPath();
    11.     String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path + "/";
    12. %>
    13. <html>
    14. <head>
    15.     <title>查询学生ajax</title>
    16.     <base href="<%=basePath%>"/>
    17.     <script type="text/javascript" src="js/jquery-3.3.1.js"></script>
    18.     <script type="text/javascript">
    19.         $(function () {
    20.             //在当前页面dom对象加载后，执行loadStudentData()
    21.             loadStudentData();
    22.  
    23.             //点击按钮
    24.             $("#btnLoader").click(function () {
    25.                 loadStudentData();//调用函数
    26.             })
    27.  
    28.             //定义函数
    29.             function loadStudentData() {
    30.                 $.ajax({
    31.                     url:"student/queryStudent.do",
    32.                     type:"post",
    33.                     dataType:"json",
    34.                     success:function (data) {
    35.                         //清除旧的数据
    36.                         $("#info").html("");
    37.                         //增加新的数据
    38.                         $.each(data,function (i,n) {
    39.                             $("#info").append("<tr>")
    40.                                 .append("<td>"+n.id+"</td>")
    41.                                 .append("<td>"+n.name+"</td>")
    42.                                 .append("<td>"+n.age+"</td>")
    43.                                 .append("</tr>")
    44.                         })
    45.                     }
    46.                 })
    47.             }
    48.         })
    49.     </script>
    50. </head>
    51. <body>
    52. <div align="center">
    53.     <table>
    54.         <thead>
    55.         <tr>
    56.             <td>学号</td>
    57.             <td>姓名</td>
    58.             <td>年龄</td>
    59.         </tr>
    60.         </thead>
    61.         <tbody id="info">
    62.  
    63.         </tbody>
    64.         <input type="button" id="btnLoader"value="查询数据">
    65.     </table>
    66. </div>
    67. </body>
    68. </html>

    点击注册学生：

    点击浏览学生：

     

  • 相关阅读:
    Jmeter接口测试简易步骤
    Ribbon负载均衡
    教育管理系统功能点
    linux易忘命令（如：端口、进程、文件、内存、vim）持续更新
    setsockopt()函数的用法
    CNN RNN DNN transformer 区别以及音频信号处理适合方式
    gitlab+jenkins+k8s实现持续集成springboot+springcloud
    三子棋小游戏（简单详细）
    pgsql在navicate导出sql再去其他库导入时会遇到的小问题
    strcmp函数详解：字符串比较的利器
  • 原文地址：https://blog.csdn.net/dengfengling999/article/details/125433049