创数据库

  1. create database ssmtest
  3. use ssmtest
  4. create table booklist(
  5. id int primary key AUTO_INCREMENT,
  6. title varchar(50),
  7. writer varchar(30),
  8. price decimal(6,2),
  9. count int
  10. )
  12. insert booklist values
  13. (null,'百年孤独','雨果',23.4,3),
  14. (null,'斗破苍穹','天蚕土豆',29.9,12),
  15. (null,'遮天','辰东',34,39),
  16. (null,'雪中悍刀行','烽火戏诸侯',49.8,123)

项目目录结构

下面的项目构建都看这个目录
image.png

pom.xml

导入依赖和静态资源导出需要配置

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.          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.     <parent>
  6.         <artifactId>Spring</artifactId>
  7.         <groupId>org.lyd</groupId>
  8.         <version>1.0-SNAPSHOT</version>
  9.     </parent>
  10.     <modelVersion>4.0.0</modelVersion>
  12.     <artifactId>demo6ssm</artifactId>
  14.     <properties>
  15.         <maven.compiler.source>8</maven.compiler.source>
  16.         <maven.compiler.target>8</maven.compiler.target>
  17.     </properties>
  18.     <dependencies>
  20.         <dependency>
  21.             <groupId>org.springframework</groupId>
  22.             <artifactId>spring-webmvc</artifactId>
  23.             <version>5.2.0.RELEASE</version>
  24.         </dependency>
  26.         <dependency>
  27.             <groupId>org.springframework</groupId>
  28.             <artifactId>spring-jdbc</artifactId>
  29.             <version>5.2.0.RELEASE</version>
  30.         </dependency>
  32.         <dependency>
  33.             <groupId>junit</groupId>
  34.             <artifactId>junit</artifactId>
  35.             <version>4.12</version>
  36.             <scope>test</scope>
  37.         </dependency>
  38.         <dependency>
  39.             <groupId>org.mybatis</groupId>
  40.             <artifactId>mybatis</artifactId>
  41.             <version>3.5.7</version>
  42.         </dependency>
  43.         <dependency>
  44.             <groupId>org.mybatis</groupId>
  45.             <artifactId>mybatis-spring</artifactId>
  46.             <version>2.0.7</version>
  47.         </dependency>
  49.         <dependency>
  50.             <groupId>mysql</groupId>
  51.             <artifactId>mysql-connector-java</artifactId>
  52.             <version>5.1.3</version>
  53.         </dependency>
  55.         <dependency>
  56.             <groupId>com.alibaba</groupId>
  57.             <artifactId>druid</artifactId>
  58.             <version>1.2.8</version>
  59.         </dependency>
  61.         <dependency>
  62.             <groupId>org.aspectj</groupId>
  63.             <artifactId>aspectjweaver</artifactId>
  64.             <version>1.9.1</version>
  65.         </dependency>
  66.         <dependency>
  67.             <groupId>javax.servlet</groupId>
  68.             <artifactId>javax.servlet-api</artifactId>
  69.             <version>3.1.0</version>
  70.         </dependency>
  72.         <dependency>
  73.             <groupId>com.alibaba</groupId>
  74.             <artifactId>fastjson</artifactId>
  75.             <version>1.2.80</version>
  76.         </dependency>
  78.         <dependency>
  79.             <groupId>org.projectlombok</groupId>
  80.             <artifactId>lombok</artifactId>
  81.             <version>RELEASE</version>
  82.             <scope>compile</scope>
  83.         </dependency>
  85.     </dependencies>
  87.     <!--静态资源导出问题-->
  88.     <build>
  89.         <resources>
  90.             <resource>
  91.                 <directory>src/main/java</directory>
  92.                 <includes>
  93.                     <include>**/*.properties</include>
  94.                     <include>**/*.xml</include>
  95.                 </includes>
  96.                 <filtering>false</filtering>
  97.             </resource>
  98.             <resource>
  99.                 <directory>src/main/resources</directory>
  100.                 <includes>
  101.                     <include>**/*.properties</include>
  102.                     <include>**/*.xml</include>
  103.                 </includes>
  104.                 <filtering>false</filtering>
  105.             </resource>
  106.         </resources>
  107.     </build>
  108. </project>

mybatis配置文件

mybatis-config.xml

用spring来配置数据源了，mybatis的配置文件作用不大，但是还是象征性的写两个东西

  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>
  7.     <!--配置数据源，交给Spring来做-->
  9.     <!--设置别名-->
  10.     <typeAliases>
  11.         <package name="com.lyd.pojo"/>
  12.     </typeAliases>
  14.     <!--引入映射文件-->
  15.     <mappers>
  16.         <package name="com.lyd.mapper"/>
  17.     </mappers>
  18. </configuration>

mybatis.properties

  1. jdbc.driver=com.mysql.jdbc.Driver
  2. jdbc.url=jdbc:mysql://localhost:3306/ssmtest?useUnicode=true&characterEncoding=utf8
  3. jdbc.username=root
  4. jdbc.password=123456

spring配置文件

applicationContext.xml

Spring的配置文件

  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.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  5.         https://www.springframework.org/schema/beans/spring-beans.xsd">
  7.     <import resource="classpath:spring-dao.xml"/>
  8.     <import resource="classpath:spring-service.xml"/>
  9.     <import resource="classpath:spring-mvc.xml"/>
  10. </beans>

spring-dao.xml

也是spring的配置文件，不过是dao层的，用来配置数据访问的

  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
  6.         https://www.springframework.org/schema/beans/spring-beans.xsd
  7.         http://www.springframework.org/schema/context
  8.         https://www.springframework.org/schema/context/spring-context.xsd">
  10.     <!--1.关连数据库配置文件-->
  11.     <context:property-placeholder location="classpath:mybatis.properties"/>
  12.     <!--2.连接池-->
  13.     <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
  14.         <property name="driverClassName" value="${jdbc.driver}" />
  15.         <property name="url" value="${jdbc.url}" />
  16.         <property name="username" value="${jdbc.username}" />
  17.         <property name="password" value="${jdbc.password}" />
  18.     </bean>
  20.     <!--3.sqlSessionFactory-->
  21.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  22.         <property name="dataSource" ref="dataSource" />
  23.         <!--绑定Mybatis配置文件-->
  24.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  25.         <property name="mapperLocations" value="classpath:com/lyd/mapper/*.xml"/>
  26.     </bean>
  28.     <!--4.配置dao接口扫描包，动态的实现dao接口可以注入到Spring容器中-->
  29.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  30.         <!--注入sqlSessionFactory-->
  31.         <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
  32.         <!--要扫描的dao包-->
  33.         <property name="basePackage" value="com.lyd.dao"/>
  34.     </bean>
  35. </beans>

spring-service.xml

这也是spring的配置文件，用来配置service层的

  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:tx="http://www.springframework.org/schema/tx"
  6.        xmlns:aop="http://www.springframework.org/schema/aop"
  7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.         https://www.springframework.org/schema/beans/spring-beans.xsd
  9.         http://www.springframework.org/schema/context
  10.         https://www.springframework.org/schema/context/spring-context.xsd
  11.         http://www.springframework.org/schema/tx
  12.         https://www.springframework.org/schema/tx/spring-tx.xsd
  13.         http://www.springframework.org/schema/aop
  14.         https://www.springframework.org/schema/aop/spring-aop.xsd">
  16.     <!--1.扫描service下的包-->
  17.     <context:component-scan base-package="com.lyd.service"/>
  19.     <!--2.将我们所有的业务类注入到Spring，可以通过配置，或者注解实现-->
  20.     <bean id="bookservice" class="com.lyd.service.BookListService">
  21.         <property name="bookmapper" ref="IBookListMapper"/>
  22.     </bean>
  24.     <!--3. 配置声明式事务-->
  25.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  26.         <property name="dataSource" ref="dataSource"/>
  27.     </bean>
  28.     <!--结合AOP实现事务的织入-->
  29.     <!--配置事务通知-->
  30.     <tx:advice id="txAdvice" transaction-manager="transactionManager">
  31.         <!--给哪些方法配置事务-->
  32.         <!---->
  33.         <tx:attributes>
  34.             <tx:method name="queryBookById" propagation="REQUIRED"/>
  35.             <tx:method name="queryBooks"/>
  36.         </tx:attributes>
  37.     </tx:advice>
  38.     <!--配置事务的切入-->
  39.     <aop:config>
  40.         <aop:pointcut id="txPointCut" expression="execution(* com.lyd.dao.*.*(..))"/>
  41.         <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
  42.     </aop:config>
  43. </beans>

spring-mvc.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:mvc="http://www.springframework.org/schema/mvc"
  5.        xmlns:context="http://www.springframework.org/schema/context"
  6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
  7.         https://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/mvc
  9.         http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.         http://www.springframework.org/schema/context
  11.         https://www.springframework.org/schema/context/spring-context.xsd">
  13.     <!--1.注解驱动并且解决json乱码问题-->
  14.         <mvc:annotation-driven>
  15.         <mvc:message-converters>
  16.             <bean class="org.springframework.http.converter.StringHttpMessageConverter">
  17.                 <constructor-arg value="UTF-8"/>
  18.             </bean>
  19.             <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
  20.                 <property name="objectMapper">
  21.                     <bean class="org.springframework.http.converter.json.Jackson2ObjectMapperFactoryBean">
  22.                         <property name="failOnEmptyBeans" value="false"/>
  23.                     </bean>
  24.                 </property>
  25.             </bean>
  26.         </mvc:message-converters>
  27.     </mvc:annotation-driven>
  28.     <!--2.静态资源过滤-->
  29.     <mvc:default-servlet-handler/>
  30.     <!--3.扫描包-->
  31.     <context:component-scan base-package="com.lyd.*"/>
  32.     <!--4.视图解析器-->
  33.     <!--视图解析器-->
  34.     <bean class = "org.springframework.web.servlet.view.InternalResourceViewResolver" id="internalResourceViewResolver">
  35.         <!--加上前后缀，就只用访问名字就行了，会主动拼接上前后缀的-->
  36.         <!--前缀-->
  37.         <property name="prefix" value="/WEB-INF/jsp/"/>
  38.         <!--后缀-->
  39.         <property name="suffix" value=".jsp"/>
  40.     </bean>
  41. </beans>

Web配置

给项目添加web框架，称为一个web项目

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">
  7.     <!--配置DispatchServlet：这个是SpringMVC的核心，请求分发器，前端控制器-->
  8.     <servlet>
  9.         <servlet-name>springmvc</servlet-name>
  10.         <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  11.         <!--DispatcherServlet要绑定Spring的配置文件-->
  12.         <init-param>
  13.             <param-name>contextConfigLocation</param-name>
  14.             <param-value>classpath:applicationContext.xml</param-value>
  15.         </init-param>
  16.         <!--启动级别：1.服务器一启动它就自己启动-->
  17.         <load-on-startup>1</load-on-startup>
  18.     </servlet>
  20.     <servlet-mapping>
  21.         <servlet-name>springmvc</servlet-name>
  22.         <url-pattern>/</url-pattern>
  23.     </servlet-mapping>
  25.     <!--配置SpingMVC的乱码过滤器-->
  26.     <filter>
  27.         <filter-name>encoding</filter-name>
  28.         <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  29.         <init-param>
  30.             <param-name>encoding</param-name>
  31.             <param-value>utf-8</param-value>
  32.         </init-param>
  33.     </filter>
  34.     <filter-mapping>
  35.         <filter-name>encoding</filter-name>
  36.         <url-pattern>/*</url-pattern>
  37.     </filter-mapping>
  38. </web-app>

java

pojo|数据实体类

  1. package com.lyd.pojo;
  4. import lombok.AllArgsConstructor;
  5. import lombok.Data;
  6. import lombok.NoArgsConstructor;
  8. @Data
  9. @AllArgsConstructor
  10. @NoArgsConstructor
  11. public class BookList {
  12.     private int id;
  13.     private String title;
  14.     private String writer;
  15.     private double price;
  16.     private int count;
  17. }

dao|Mapper接口

  1. package com.lyd.dao;
  3. import com.lyd.pojo.BookList;
  4. import org.apache.ibatis.annotations.Param;
  6. import java.util.List;
  9. public interface IBookListMapper {
  10.     //增删改查
  11.     int addBook(BookList book);
  12.     int deleteBookById(@Param("id") int id);
  13.     int updateBook(BookList book);
  14.     BookList queryBookById(@Param("id") int id);
  15.     List<BookList> queryBooks();
  16. }

service|业务层

service首先有接口，约定了某些方法，然后实现类实现了这些方法，service层调用dao层，需要注入到service层，可以用自动装配的注解

  1. package com.lyd.service;
  4. import com.lyd.pojo.BookList;
  7. import java.util.List;
  9. public interface IBookListService {
  10.     int addBook(BookList book);
  11.     int deleteBookById(int id);
  12.     int updateBook(BookList book);
  13.     BookList queryBookById(int id);
  14.     List<BookList> queryBooks();
  15. }
  1. package com.lyd.service;
  3. import com.lyd.dao.IBookListMapper;
  4. import com.lyd.pojo.BookList;
  5. import org.springframework.beans.factory.annotation.Autowired;
  6. import org.springframework.stereotype.Service;
  8. import java.util.List;
  10. @Service
  11. public class BookListService implements IBookListService{
  13.     //service层调dao层
  14.     IBookListMapper bookmapper;
  15.     public void setBookmapper(IBookListMapper bookmapper) {
  16.         this.bookmapper = bookmapper;
  17.     }
  19.     @Override
  20.     public int addBook(BookList book) {
  21.         return bookmapper.addBook(book);
  22.     }
  24.     @Override
  25.     public int deleteBookById(int id) {
  26.         return bookmapper.deleteBookById(id);
  27.     }
  29.     @Override
  30.     public int updateBook(BookList book) {
  31.         return bookmapper.updateBook(book);
  32.     }
  34.     @Override
  35.     public BookList queryBookById(int id) {
  36.         return bookmapper.queryBookById(id);
  37.     }
  39.     @Override
  40.     public List<BookList> queryBooks() {
  41.         return bookmapper.queryBooks();
  42.     }
  43. }

controller|控制器层

  1. package com.lyd.controller;
  3. import com.alibaba.fastjson.JSON;
  4. import com.lyd.pojo.BookList;
  5. import com.lyd.service.BookListService;
  6. import com.lyd.service.IBookListService;
  7. import org.springframework.beans.factory.annotation.Autowired;
  8. import org.springframework.beans.factory.annotation.Qualifier;
  9. import org.springframework.stereotype.Controller;
  10. import org.springframework.ui.Model;
  11. import org.springframework.web.bind.annotation.*;
  13. import java.util.List;
  15. @RestController
  16. @RequestMapping("/book")
  17. public class BookController {
  18.     //controller层 调 service层
  19.     @Autowired
  20.     @Qualifier("bookservice")
  21.     private BookListService bookserv;
  23.     //查询全部书籍，并且返回全部书籍的json字符串
  24.     @RequestMapping("/allbook")
  25.     public String list(Model model){
  26.         List<BookList> list = bookserv.queryBooks();
  27.         return JSON.toJSONString(list);
  28.     }
  29.     @RequestMapping("/addbook")
  30.     //加上@RequestBody注解表示，前端传过来的json值映射成这个对象，json值得键要和对象的属性名一致
  31.     public int add(@RequestBody BookList booklist){
  32.         return bookserv.addBook(booklist);
  33.     }
  34.     @RequestMapping("/updatebook")
  35.     public int update(@RequestBody BookList booklist){
  36.         return bookserv.updateBook(booklist);
  37.     }
  38.     @PostMapping("/deletebook")
  39.     public int delete(@RequestParam("id") int id){
  40.         return bookserv.deleteBookById(id);
  41.     }
  42.     @PostMapping("/selectbook")
  43.     public String book(@RequestParam("id") int id){
  44.         return JSON.toJSONString(bookserv.queryBookById(id));
  45.     }
  46. }