MyBatils学习四删除数据

来源：互联网发布：删除淘宝差评的链接编辑：程序博客网时间：2024/06/05 08:44

在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

0 0