在myBatils学习一查询数据,myBatils学习二更新数据,myBatils学习三插入数据的基础上增加新的代码:
1.在com.abc.mapper.StudentMapper增加按id删除学生的方法
public void delete(int id);
2、在对应的resources/com/abc/mapper/StudentMapper.xml文件中增加delete方法的映射实现:
<delete id="delete" parameterType="int">
DELETE FROM student WHERE id = #{id}
</delete>
3.TestMyBatils.java中代码如下:
package com.test;
import java.io.IOException;
import java.io.Reader;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import com.abc.mapper.StudentMapper;
public class TestMyBatils {
public static void main(String[] args) throws IOException{
String resource = "resources/com/abc/mapper/configuration.xml";
Reader reader = null;
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory factory = new
SqlSessionFactoryBuilder()
.build(reader);
SqlSession session = factory.openSession();
StudentMapper mapper = session.getMapper(
StudentMapper.class);
mapper.delete(2);
session.commit();
}
}
TestMybatils.java执行前:
SQL> SELECT * FROM student;
ID NAME GENDER MAJOR GRAD
---------- ---------- -------------------- -------------------- ----
1 李林 男 数学与应用数学 2010
2 王小帅 男 电子工程 2005
TestMybatils.java执行后:
SQL> SELECT * FROM student;
ID NAME GENDER MAJOR GRAD
---------- ---------- -------------------- -------------------- ----
1 李林 男 数学与应用数学 2010