SpringBoot笔记：（3）Druid+Mybatis+Mysql 配置

项目结构

pom依赖配置

application.yml配置

Druid bean配置

@Configuration
public class DruidConfig {

    @Primary
    @Bean(name="dataSource")
    public DataSource druidDataSource(){
        return DruidDataSourceBuilder.create().build();
    }

}

测试用例

1、user实体类

public class User {
    
    private String userid;

    private String username;

    public String getUserid() {
        return userid;
    }

    public void setUserid(String userid) {
        this.userid = userid == null ? null : userid.trim();
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username == null ? null : username.trim();
    }
}

2、编写userMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.ultimate.springboot.dao.UserMapper">
  <resultMap id="BaseResultMap" type="cn.ultimate.springboot.domain.User">
    <result column="userId" jdbcType="VARCHAR" property="userid" />
    <result column="username" jdbcType="VARCHAR" property="username" />
  </resultMap>
  <insert id="insert" parameterType="cn.ultimate.springboot.domain.User">
    insert into user (userId, username)
    values (#{userid,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="cn.ultimate.springboot.domain.User">
    insert into user
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="userid != null">
        userId,
      </if>
      <if test="username != null">
        username,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="userid != null">
        #{userid,jdbcType=VARCHAR},
      </if>
      <if test="username != null">
        #{username,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>
  <resultMap id="BaseResultMap" type="cn.ultimate.springboot.domain.User">
    <result column="userId" jdbcType="VARCHAR" property="userid" />
    <result column="username" jdbcType="VARCHAR" property="username" />
  </resultMap>

  <insert id="insert" parameterType="cn.ultimate.springboot.domain.User">
    insert into user (userId, username)
    values (#{userid,jdbcType=VARCHAR}, #{username,jdbcType=VARCHAR})
  </insert>
  <insert id="insertSelective" parameterType="cn.ultimate.springboot.domain.User">
    insert into user
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="userid != null">
        userId,
      </if>
      <if test="username != null">
        username,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="userid != null">
        #{userid,jdbcType=VARCHAR},
      </if>
      <if test="username != null">
        #{username,jdbcType=VARCHAR},
      </if>
    </trim>
  </insert>

    <select id="getUser" resultType="cn.ultimate.springboot.domain.User">

          select * from user;

    </select>

</mapper>

3、编写Mapper接口

@Mapper
public interface UserMapper {

    int insert(User record);

    int insertSelective(User record);

    List getUser();
}

4、编写Service

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper  userMapper;

    @Override
    public List<User> getUser() {
        return userMapper.getUser();
    }
    

    @Override
    @Transactional(rollbackFor=Exception.class)
    public int insert(User user) throws Exception {

        int rs =  userMapper.insert(user);

        return rs;
    }
}

5、编写Controller

@RestController
public class UserController {

    @Autowired
    UserService userService;

    @RequestMapping("/")
    public List home() throws Exception {

       List list =  userService.getUser();

       return list;

    }
}

6、运行结果