昨天写的内容: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();
}