ssm整合（注解web3.0）

最近重新学习了一遍ssm，记录一下
1、首先，导入pom.xml坐标

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

  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.11</version>
      <scope>test</scope>
    </dependency>
    <dependency>
<!--   springmvc   -->
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.2.10.RELEASE</version>
    </dependency>
<!-- jdbc   -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.2.10.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>5.2.10.RELEASE</version>
    </dependency>
<!--  mybatis  -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.5</version>
    </dependency>

    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>1.3.1</version>
    </dependency>
<!-- mysql   -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>5.1.47</version>
    </dependency>
<!--  druid连接池  -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.16</version>
    </dependency>
<!--  servlet核心配置  -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>3.1.0</version>
        <scope>provided</scope>
    </dependency>
<!--  jackson  -->
    <dependency>
      <groupId>com.fasterxml.jackson.core</groupId>
      <artifactId>jackson-databind</artifactId>
      <version>2.9.0</version>
    </dependency>
 </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.tomcat.maven</groupId>
                <artifactId>tomcat7-maven-plugin</artifactId>
                <version>2.2</version>
                <configuration>
                    <port>80</port>
                    <path>/</path>
                </configuration>
            </plugin>
        </plugins>
    </build>

2、加入一些朴实无华的配置
2.1Spring的核心配置

@Configuration
@ComponentScan(value = "com.ypy",excludeFilters = @ComponentScan.Filter(type = FilterType.ANNOTATION,
        classes = Controller.class))//表示扫包除了controller
@PropertySource("classpath:jdbc.properties")
@Import({JdbcDataSource.class,MybatisConfig.class})//创建bean
@EnableTransactionManagement//开启spring事务管理
public class SpringConfig {
}

2.2、springmvc配置

@Configuration
@ComponentScan("com.ypy.controller")
@EnableWebMvc
public class SpringMvcConfig {
}

2.3数据连接池的配置

 @Value("${jdbc.driver}")
    private String driver;
    @Value("${jdbc.url}")
    private String url;
    @Value("${jdbc.username}")
    private String username;
    @Value("${jdbc.password}")
    private String password;
//配置连接池
    @Bean
    public DataSource getDataSource(){
        DruidDataSource druidDataSource=new DruidDataSource();
        druidDataSource.setDriverClassName(driver);
        druidDataSource.setUrl(url);
        druidDataSource.setUsername(username);
        druidDataSource.setPassword(password);
        return druidDataSource;
    }
    //Spring事务管理需要的平台事务管理器对象
    @Bean
    public PlatformTransactionManager transactionManager(DataSource dataSource){
        DataSourceTransactionManager ds = new DataSourceTransactionManager();
        ds.setDataSource(dataSource);
        return ds;
    }

properties的文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql:///ssm_db?useSSL=false&useServerPrepStmts=true&useUnicode=true&characterEncoding=utf-8
jdbc.username=******
jdbc.password=*****

2.4、mybatis的配置

public class MybatisConfig {
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(JdbcDataSource jdbcDataSource){
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(jdbcDataSource.getDataSource());
        sqlSessionFactoryBean.setTypeAliasesPackage("com.ypy.domain");//实体类映射
        return sqlSessionFactoryBean;
    }
    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setBasePackage("com.ypy.dao");//配置接口扫描位置
        return mapperScannerConfigurer;
    }

}

2.5、我把web.xml干掉了新建了一个类用于替代

public class MybatisConfig {
    @Bean
    public SqlSessionFactoryBean sqlSessionFactoryBean(JdbcDataSource jdbcDataSource){
        SqlSessionFactoryBean sqlSessionFactoryBean=new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(jdbcDataSource.getDataSource());
        sqlSessionFactoryBean.setTypeAliasesPackage("com.ypy.domain");//实体类映射
        return sqlSessionFactoryBean;
    }
    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer(){
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setBasePackage("com.ypy.dao");//配置接口扫描位置
        return mapperScannerConfigurer;
    }

}

至此配置结束，直接跟之前一样写代码就行了
3、dao层

public interface BookMapper {
    //查询所有
    @Select("select * from tbl_book")
    public List<Book> selectAll();
    //查询所有
    @Select("select * from tbl_book where id=#{id}")
    public Book selectBookById(int id);
    //修改
    @Update("update tbl_book set TYPE=#{type},NAME=#{name},description=#{description} where id=#{id}")
    public boolean update(Book book);
    //添加
    @Insert("insert into tbl_book values(null,#{type},#{name},#{description})")
    public boolean insert(Book book);
    //删除
    @Delete("delete from tbl_book where id=#{id}")
    public boolean delete(int id);

}

3.1、service层及实现类

@Transactional
public interface BookService {


    public List<Book> selectAll();

    public boolean update(Book book);

    public boolean insert(Book book);

    public boolean delete(int id);

    public Book selectBookById(int id);
}

impl

@Service
public class BookServiceImpl implements BookService {
    @Autowired(required = false)
    private BookMapper bookMapper;
    @Override
    public List<Book> selectAll() {
        return bookMapper.selectAll();
    }

    @Override
    public boolean update(Book book) {

        bookMapper.update(book);
        return true;
    }

    @Override
    public boolean insert(Book book) {
        bookMapper.insert(book);
        return true;
    }

    @Override
    public boolean delete(int id) {
        bookMapper.delete(id);
        return true;
    }

    @Override
    public Book selectBookById(int id) {
        return bookMapper.selectBookById(id);
    }
}

3.3、controller

@RestController
@RequestMapping("/books")
@ResponseBody//按照需求来
public class BookController {

    @Autowired
    private BookService bookService;
    @GetMapping
    public List<Book> selectAll(){
        return bookService.selectAll();
    }

    @GetMapping("/{id}")
    public Book selectBookById(@PathVariable int id){
        return bookService.selectBookById(id);
    }
    @PostMapping
    public String addBook(@RequestBody Book book){
        bookService.insert(book);

        return "{'addStatus':'success'}";
    }
    @PutMapping
    public  String updateBook(@RequestBody Book book){
        bookService.update(book);
        System.out.println(book);
        return "{'updateStatus':'success'}";

    }
    @DeleteMapping("/{id}")
    public String deleteBook(@PathVariable Integer id){
        bookService.delete(id);
        return "{'deleteStatus':'success'}";

    }

}

最后用postman测试即可