SpringBoot整合Mybatis
1.在pom.xml添加依赖
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>2.1.4</version> </dependency>
2.application.properties里添加mybatis相关配置
mybatis.type-aliases-package=com.xiaoxiangzi.pojo mybatis.mapper-locations=classpath:mybatis/mapper/*.xml
3.添加实体类，目录com.xiaoxiangzi.pojo
package com.xiaoxiangzi.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Sms {
private int id;
private int times;
private int createTime;
private String event;
private String mobile;
private String code;
private String ip;
}4.添加接口，com.xiaoxiangzi.mapper目录
package com.xiaoxiangzi.mapper;
import com.xiaoxiangzi.pojo.Sms;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;
import java.util.List;
@Mapper
@Repository
public interface SmsMapper {
List<Sms> querySmsList();
Sms querySmsById(int id);
int addSms(Sms sms);
int updateSms(Sms sms);
int deleteSms(int id);
}5.添加mapper.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="com.xiaoxiangzi.mapper.SmsMapper">
<select id="querySmsList" resultType="Sms">select * from yzn_sms</select>
<select id="querySmsById" resultType="Sms">select * from yzn_sms from #{id}</select>
<insert id="addSms" parameterType="Sms">insert into yznsms (event,mobile,code,times,ip,create_time) values (#{event},#{mobile},#{code},#{times},#{ip},#{create_time})</insert>
<update id="updateSms" parameterType="Sms">update yzn_sms set code=#{code} where id = #{id}</update>
<delete id="deleteSms" parameterType="int">delete from yzn_sms where id = #{id}</delete>
</mapper>6.在controller中调用获取
@Autowired
private SmsMapper smsMapper;
@ResponseBody
@RequestMapping("/smslist")
public HashMap<String,Object> smslist(){
List<Sms> list = smsMapper.querySmsList();
HashMap<String,Object> map = new HashMap<String,Object>();
map.put("code",1);
map.put("data",list);
return map;
}
