spring boot mybatis配置

￡神魔★判官ぃ 2022-05-27 12:19 220阅读 0赞

### SpringBoot中添加mybatis数据库 ###

1.  添加model

public class UserInfo {
        private String uid;
        private String login_name;
        private String username;
        private String worker_id;
        private String password;
        private String position;
        private String departments;
        private String email;
        private Integer status;
        private boolean is_admin;
        private String reserv2;
        private int reserv1;
        private String modifytime;
    
        // getter and setter ...
    }

1.  添加Mapper

public interface UserMapper { 
        @Select("SELECT * FROM user_info WHERE uid = #{userId}")
        UserInfo getUser(@Param("userId") String userId);
    }

1.  添加MapperScan

在Application配置中添加MapperScan

@MapperScan("com.example.demo.mapper")
    @SpringBootApplication
    public class DemoApplication { 
    
        public static void main(String[] args) {
            SpringApplication.run(DemoApplication.class, args);
        }
    }

1.  在Service应用层引用

@Autowired
        UserMapper userMapper;
    
    
        @Override
        public UserInfo getUserInfo() {
            UserInfo userInfo = userMapper.getUser("1");
            System.out.println("get UserInfo: " + userInfo);
            return userInfo;
        }

1.  数据库配置

spring:
      datasource:
        name: test
        url: jdbc:mysql://127.0.0.1:3306/wt
        username: wt
        password: wt

1.  数据库插入数据

DROP TABLE IF EXISTS `user_info`;
    CREATE TABLE `user_info` ( `uid` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `login_name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `username` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `worker_id` varchar(16) COLLATE utf8_unicode_ci DEFAULT '', `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `position` varchar(16) COLLATE utf8_unicode_ci DEFAULT '', `departments` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `status` int(11) NOT NULL, `is_admin` int(11) DEFAULT NULL, `reserv2` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `reserv1` int(11) DEFAULT NULL, `modifytime` datetime DEFAULT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    create unique index idx_user_username on user_info(login_name);
    
    INSERT INTO `user_info` VALUES ('1', 'login_name', '华通', '000', '1', '0', '', 'robin@email.com', 1, 1, '', 0, '2011-08-10 10:02:44');

在[mybatis文档][mybatis]中，有datasource配置．但是使用 MyBatis-Spring 之后, 你不再需要直接使用SqlSessionFactory了,因为你的bean可以通过一个线程安全的SqlSession来注入,基于Spring的事务配置 来自动提交,回滚,关闭 session。

### 错误 ###

`stablishing SSL connection without server's identity verification`

配置链接url时，需要在后面添加`useSSL=false`  
url: jdbc:mysql://127.0.0.1:3306/wt?useSSL=false

疑问:  
\- 用yaml配置文件如何配置事务

[mybatis]: http://www.mybatis.org/spring/zh/getting-started.html