mybatisMaper.xml

 

1. 接口配置：

package com.itheima.dao;

import com.itheima.domain.Student;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentDao {
public List<Student> findAll();
public void add(Student student);

@Select("select * from t_student where id =#{suiyixie}")
public Student findOne(@param （“suiyixie”）Integer id);
@Select("update t_student set name=#{name},sex=#{sex},age=#{age},address=#{address} where id =#{id}")
public void update(Student student);

public void del(List list);

}

2. 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.itheima.dao.StudentDao">

<select id="findAll" resultType="com.itheima.domain.Student">
select * from t_student
</select>
<insert id="add" parameterType="com.itheima.domain.Student">
insert into t_student(id,name,sex,age,address)values(#{id},#{name},#{sex},#{age},#{address})
</insert>

<delete id="del" parameterType="java.util.ArrayList">
delete from t_student
where
<foreach collection="list" open="id in (" close=")" separator="," item="id">
#{id}
</foreach>

</delete>

</mapper>