Mybatis实现数据CURD操作实例--续

来源：互联网发布：eclipse导入jar包源码编辑：程序博客网时间：2024/06/05 08:15

昨天写的内容：http://blog.csdn.net/u013821825/article/details/51617108

续写：修改数据库记录

1、修改mapper映射接口

package org.xsx.entity;public interface EmpMapper{    public void addEmp(Emp emp);    public void updateEmp(Emp emp);    public Emp findById(int id);    public void deleteById(int id);}

2、修改映射配置文件EmpSQL.xml

增加代码：<update id="updateEmp" parameterType="org.xsx.entity.Emp">    update emp set name=#{name},age=#{age} where id=#{id}</update><select id="findById" parameterType="int" resultType="org.xsx.entity.Emp">    select name,age from emp where id=#{id}</select><delete id="deleteById" parameterType="int">    delete from emp where id=#{id}</delete>

3、添加测试方法（这里因为要频繁测试所以使用静态代码块加载配置文件）

MybatisHelper.java类：package org.xsx.test;import java.io.IOException;import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Before;public class MybatisHelper {    public static String conf ;    public static Reader reader;    public static SqlSessionFactoryBuilder builder;    public static SqlSessionFactory factory;    @Before    public void startMybatis() throws Exception{        reader = Resources.getResourceAsReader(conf);        builder = new SqlSessionFactoryBuilder();        factory = builder.build(reader);    }}在测试类中继承MybatisHelper类：package org.xsx.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 org.junit.Test;import org.xsx.entity.Emp;public class TestEmp extends MybatisHelper {    static{        conf =  "SqlMapConfig.xml";    }    @Test    public void testDatasource() throws Exception{        String conf = "SqlMapConfig.xml";        Reader reader = Resources.getResourceAsReader(conf);        //SessionFactoryBuilder对象        SqlSessionFactoryBuilder builder  = new SqlSessionFactoryBuilder();        SqlSessionFactory factory = builder.build(reader);        //Session        SqlSession session = factory.openSession();        System.out.println(session);        session.close();    }    @Test    public void testAddEmp() throws Exception{//      String conf = "SqlMapConfig.xml";//      Reader reader = Resources.getResourceAsReader(conf);//      //SessionFactoryBuilder对象//      SqlSessionFactoryBuilder builder  = new SqlSessionFactoryBuilder();//      SqlSessionFactory factory = builder.build(reader);        //Session        SqlSession session = factory.openSession();        Emp emp = new Emp();        emp.setId(4);        emp.setName("da");        emp.setAge(91);        session.insert("addEmp", emp);        session.commit();        session.close();    }    @Test    public void testUpdate(){        //Session                SqlSession session = factory.openSession();                Emp emp = (Emp)session.selectOne("findById", 3);                emp.setId(3);                emp.setName("ccc");                emp.setAge(100);                session.update("updateEmp", emp);                session.commit();                session.close();    }    @Test    public void testFindById(){        //Session                SqlSession session = factory.openSession();                Emp emp = (Emp)session.selectOne("findById", 3);                System.out.println(emp.getName());                session.close();    }}@Test    public void testDeleteById(){        //Session                SqlSession session = factory.openSession();                session.delete("deleteById", 4);                session.commit();                session.close();    }

1 0