实体类:
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
@Component
@ToString
public class Student {
private int id;
private String name;
private String number;
private boolean gender;
}
接口:
@Repository
public interface StudentDao {
public int insert(Student student);
public void update(Student student);
void delete(Integer id);
Student detail(Integer id);
List<Student> list();
}
mapping下StudentDao.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.zparkep.dao.StudentDao">
<select id="list" resultType="user">
select * from tb_student;
</select>
<delete id="delete" parameterType="integer">
DELETE FROM tb_student where id = #{id}
</delete>
<insert id="insert" parameterType="student">
INSERT INTO tb_student
VALUES
(#{id},#{name},#{number},#{gender})
</insert>
<update id="update" parameterType="student">
update tb_student
set name =#{name},number = #{number}
where id = #{id}
</update>
<select id="detail" parameterType="int" resultType="student">
select * from tb_student where id = #{id}
</select>
</mapper>
测试:
@RunWith(SpringRunner.class)
@ContextConfiguration("classpath:app.xml")
public class StudentDaoTest {
@Autowired
private StudentDao studentDao;
@Test
public void insert(){
Student build = Student.builder().id(1).name("a").number("aa").gender(true).build();
int insert = studentDao.insert(build);
System.out.println("********* " + insert);
}
@Test
public void list(){
List<Student> list = studentDao.list();
for(Student stu: list){
System.out.println(stu);
}
}
@Test
public void update(){
Student student = new Student(1, "bb", "bbb", true);
studentDao.update(student);
}
@Test
public void detail(){
Student detail = studentDao.detail(1);
System.out.println(detail);
}
@Test
public void delete(){
studentDao.delete(1);
}
}