package com.KarryCode.config;

import com.alibaba.druid.pool.DruidDataSource;

import org.mybatis.spring.SqlSessionFactoryBean;

import org.mybatis.spring.annotation.MapperScan;

import org.springframework.beans.factory.annotation.Value;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.Configuration;

import org.springframework.context.annotation.PropertySource;

import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import org.springframework.transaction.PlatformTransactionManager;

import org.springframework.transaction.annotation.EnableTransactionManagement;

import javax.sql.DataSource;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @ClassName SpringConfig

 * @Description TODO Spring 核心配置类

 * @Version 1.0

 */

@Configuration                                  //TODO 核心配置唯一标识

@ComponentScan({"com.KarryCode.service","com.KarryCode.bean"})     //TODO 注解扫描指定包

@PropertySource("classpath:jdbc.properties")    //TODO 加载 JDBC 配置类

@MapperScan("com.KarryCode.mapper")             //TODO MyBatis 基于包扫描方式识别 Mapper

@EnableTransactionManagement                    //TODO 事务的自动代理，注解驱动

public class Spring_MybatisConfig {

    @Bean

    //TODO DruidDataSource 数据源的产生

    public DataSource dataSource(

            @Value("${jdbc.driver}") String driver,

            @Value("${jdbc.url}") String url,

            @Value("${jdbc.username}") String username,

            @Value("${jdbc.password}") String password

    ) {

        DruidDataSource dataSource = new DruidDataSource();

        dataSource.setDriverClassName(driver);

        dataSource.setUrl(url);

        dataSource.setUsername(username);

        dataSource.setPassword(password);

        // 里面还可以配置更多关于数据库连接池的选项.......

        return dataSource;

    }

    @Bean

    public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {

        //TODO sqlSessionFactoryBean MybatisBeans 加载

        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();

        sqlSessionFactoryBean.setDataSource(dataSource);

        return sqlSessionFactoryBean;

    }

    @Bean

    public PlatformTransactionManager transactionManager(DataSource dataSource) {

        //TODO 平台事务管理

        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();

        dataSourceTransactionManager.setDataSource(dataSource);

        return dataSourceTransactionManager;

    }

}

package com.KarryCode.config;

import org.springframework.context.annotation.ComponentScan;

import org.springframework.context.annotation.Configuration;

import org.springframework.web.servlet.config.annotation.EnableWebMvc;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @PackageName com.KarryCode.config

 * @ClassName SpringMvcConfig

 * @Description TODO

 * @Version 1.0

 */

@Configuration

@EnableWebMvc

@ComponentScan("com.KarryCode.controller")

public class SpringMvcConfig {

}

package com.KarryCode.config;

import org.springframework.web.servlet.support.AbstractAnnotationConfigDispatcherServletInitializer;

public class ServletConfig extends AbstractAnnotationConfigDispatcherServletInitializer {

    @Override

    protected Class<?>[] getRootConfigClasses() {

        return new Class[]{Spring_MybatisConfig.class};

    }

    @Override

    protected Class<?>[] getServletConfigClasses() {

        return new Class[]{SpringMvcConfig.class};

    }

    @Override

    protected String[] getServletMappings() {

        return new String[]{"/"};

    }

}

package com.KarryCode.bean;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @PackageName com.KarryCode.bean

 * @ClassName Book

 * @Description TODO

 * @Version 1.0

 */

public class Book {

    private Integer id;

    private String type;

    private String name;

    private String description;

    // 省略 getter/setter/ 构造器（有参 / 无参）/toString

}

package com.KarryCode.mapper;

import com.KarryCode.bean.Book;

import org.apache.ibatis.annotations.*;

import java.util.List;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @PackageName com.KarryCode.mapper

 * @ClassName BookMapper

 * @Description TODO

 * @Version 1.0

 */

public interface BookMapper {

    @Insert("insert into ssm_db.tb_book values (null,#{type},#{name},#{description})")

    int save(Book book);

    @Update("update ssm_db.tb_book set type=#{type},name=#{name},description=#{description} where id=#{id}")

    int update(Book book);

    @Delete("delete from ssm_db.tb_book where tb_book.id=#{id}")

    int delete(Integer id);

    @Select("select * from ssm_db.tb_book where id=#{id}")

    @ResultType(Book.class)

    Book getBookById(Integer id);

    @Select("select * from ssm_db.tb_book")

    List<Book> getBookList();

}

package com.KarryCode.service;

import com.KarryCode.bean.Book;

import org.springframework.transaction.annotation.Transactional;

import java.util.List;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @ClassName BookService

 * @Description TODO

 * @Version 1.0

 */

@Transactional

public interface BookService {

    /**

     * @param book

     * @return boolean

     * @Author KarryLiu_刘珂瑞

     * @Date 2023/8/14 下午 10:58

     * @Description TODO 保存

     */

    boolean save(Book book);

    /**

     * @param book

     * @return boolean

     * @Author KarryLiu_刘珂瑞

     * @Date 2023/8/14 下午 10:58

     * @Description TODO 修改

     */

    boolean update(Book book);

    /**

     * @param id

     * @return boolean

     * @Author KarryLiu_刘珂瑞

     * @Date 2023/8/14 下午 10:58

     * @Description TODO 根据 id 删除

     */

    boolean delete(Integer id);

    /**

     * @param id

     * @return edu.beihua.bean.Book

     * @Author KarryLiu_刘珂瑞

     * @Date 2023/8/14 下午 10:59

     * @Description TODO 根据 id 查询

     */

    Book getBookById(Integer id);

    /**

     * @param

     * @return java.util.List<edu.beihua.bean.Book>

     * @Author KarryLiu_刘珂瑞

     * @Date 2023/8/14 下午 10:59

     * @Description TODO 查询全部

     */

    List<Book> getBookList();

}

package com.KarryCode.service.impl;

import com.KarryCode.bean.Book;

import com.KarryCode.mapper.BookMapper;

import com.KarryCode.service.BookService;

import org.springframework.stereotype.Service;

import javax.annotation.Resource;

import java.util.List;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @Date 2023/8/14 下午 10:43

 * @ClassName BookServiceImpl

 * @Description TODO

 * @Version 1.0

 */

@Service

public class BookServiceImpl implements BookService {

    @Resource

    private BookMapper bookMapper;

    @Override

    public boolean save(Book book) {

        System.out.println("save=====>Service");

        int save = bookMapper.save(book);

        if (save>0){

            return true;

        }else {

            return false;

        }

    }

    @Override

    public boolean update(Book book) {

        System.out.println("update=====>Service");

        bookMapper.update(book);

        return true;

    }

    @Override

    public boolean delete(Integer id) {

        System.out.println("delete=====>Service");

        bookMapper.delete(id);

        return true;

    }

    @Override

    public Book getBookById(Integer id) {

        System.out.println("getBookById=====>Service");

        Book book = bookMapper.getBookById(id);

        return book;

    }

    @Override

    public List<Book> getBookList() {

        System.out.println("getBookList=====>Service");

        return bookMapper.getBookList();

    }

}

import com.KarryCode.bean.Book;

import com.KarryCode.config.Spring_MybatisConfig;

import com.KarryCode.service.BookService;

import org.junit.Test;

import org.springframework.context.annotation.AnnotationConfigApplicationContext;

import java.util.List;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @PackageName PACKAGE_NAME

 * @ClassName mybatisTest

 * @Description TODO

 * @Version 1.0

 */

public class mybatisSpringTest {

    @Test

    public void testMybatisSpring(){

        AnnotationConfigApplicationContext annotationConfigApplicationContext = new AnnotationConfigApplicationContext(Spring_MybatisConfig.class);

        BookService bookService = annotationConfigApplicationContext.getBean(BookService.class);

        List<Book> bookList = bookService.getBookList();

        System.out.println(bookList);

    }

}

package com.KarryCode.controller;

import com.KarryCode.bean.Book;

import com.KarryCode.service.BookService;

import org.springframework.transaction.annotation.Transactional;

import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;

import java.util.List;

/**

 * @Author KarryLiu

 * @Creed may all the beauty be blessed

 * @PackageName com.KarryCode.controller

 * @ClassName BookController

 * @Description TODO

 * @Version 1.0

 */

@RestController

@Transactional

@RequestMapping("/books")

public class BookController {

    @Resource

    private BookService bookService;

    @PostMapping

    public boolean save(@RequestBody Book book) {

        return bookService.save(book);

    }

    @PutMapping

    public boolean update(@RequestBody Book book) {

        return bookService.update(book);

    }

    @DeleteMapping("/{id}")

    public boolean delete(@PathVariable Integer id) {

        return bookService.delete(id);

    }

    @GetMapping("/{id}")

    public Book getBookById(@PathVariable Integer id) {

        return bookService.getBookById(id);

    }

    @GetMapping

    public List<Book> getBookList() {

        return bookService.getBookList();

    }

}