spring boot mybatis配置

最新推荐文章于 2022-03-23 22:03:12 发布

原创最新推荐文章于 2022-03-23 22:03:12 发布 · 160 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#java #springboot

java 专栏收录该内容

41 篇文章

订阅专栏

本文介绍如何在SpringBoot项目中集成MyBatis框架，包括创建实体类、编写Mapper接口、配置数据源及事务管理等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SpringBoot中添加mybatis数据库

添加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 ...
}

添加Mapper

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

添加MapperScan

在Application配置中添加MapperScan

@MapperScan("com.example.demo.mapper")
@SpringBootApplication
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }
}

在Service应用层引用

    @Autowired
    UserMapper userMapper;


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

数据库配置

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

数据库插入数据

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');