文章目录
一、在idea中配置好数据源
新建数据表、数据库,在idea中配置好数据源,实现与数据库的连接
二、完成添加、删除、修改操作的代码
增加
@Insert("insert into user(name, age, gender, phone) value (#{name},#{age},#{gender},#{phone})")
public void insert(User user);
删除
@Delete("delete from user where id = #{id}")
public void deleteById(int id);
修改
@Update("update user set name=#{name},gender=#{gender},age=#{age},phone=#{phone} where id=#{id}")
public void updateById(User user);
三、lombok库的使用
引入lombok依赖
import lombok.*;
@NoArgsConstructor
@AllArgsConstructor
@Data
public class User {
private Integer id;
private String name;
private short age;
private short gender;
private String phone;
}
四、学习idea的调试技巧,并尝试使用
添加断点,单步执行,使用debug解决问题
五、对poet案例使用mybatis进行添加、删除、修改、更新的操作
新建poet表格,输入信息
package com.liuxiaocan.springbootmybatis.data;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Poet {
private short id;
private String name;
private String gender;
private String dynasty;
private String title;
private String style;
}
编写PoetMapper接口,使用sql语句查询poet数据表信息
@Mapper
public interface PoetMapper {
@Select("select * from poet")
public List<Poet> selectall();
}
@SpringBootTest
class SpringbootMybatisApplicationTests {
@Autowired
PoetMapper poetMapper;
@Test
public void test1(){
List<Poet> poets=poetMapper.selectall();
for (Poet poet:poets
) {
System.out.println(poet);
}
}
}
添加
@Insert("insert into poet values(#{id},#{name},#{gender},#{dynasty},#{title},#{style})")
public void insert(Poet poet);
@Test
public void test2(){
Poet poet=new Poet((short) 8,"陆游","男","宋代","小李白","语言平易晓畅章法整饬谨严");
poetMapper.insert(poet);
test1();
删除
@Delete("delete from poet where name=#{name}")
public void delete(String name);
@Test
public void test5(){
poetMapper.delete("陆游");
test1();
}
修改
@Update("update poet set gender=#{gender} where id=#{id}")
public void update(String gender,short id);
@Test
public void test4(){
poetMapper.update("男",(short) 4);
test1();
}