上接入门案例(看之前的《mybatis基本介绍及入门案例》篇)文章来源地址https://www.toymoban.com/news/detail-767324.html
1、映射接口
public interface MonsterMapper {
//添加方法
public void addMonster(Monster monster);
public void delMonster(Integer monster_id);
public void updateMonster(Monster monster);
public Monster findById(Integer monster_id);
public List<Monster> findAllMonster();
}
2、映射文件
<mapper namespace="com.bin.mybatis.mapper.MonsterMapper">
<insert id="addMonster" parameterType="com.bin.mybatis.entity.Monster">
INSERT INTO mybatis_monster_ (monster_id,age,birthday,email,gender,name,salary)
VALUES (#{monster_id},#{age},#{birthday},#{email},#{gender},#{name},#{salary})
</insert>
<delete id="delMonster" parameterType="Integer">
DELETE FROM mybatis_monster_ WHERE monster_id=#{monster_id}
</delete>
<update id="updateMonster" parameterType="com.bin.mybatis.entity.Monster">
UPDATE mybatis_monster_ SET age=#{age},birthday=#{birthday},email=#{email},gender=#{gender},name=#{name},salary=#{salary}
WHERE monster_id=#{monster_id}
</update>
<select id="findById" parameterType="Integer" resultType="com.bin.mybatis.entity.Monster">
SELECT * FROM mybatis_monster_ WHERE monster_id=#{monster_id}
</select>
<select id="findAllMonster" resultType="com.bin.mybatis.entity.Monster">
SELECT * FROM mybatis_monster_
</select>
</mapper>
3、JUNIT测试
import com.bin.mybatis.entity.Monster;
import com.bin.mybatis.mapper.MonsterMapper;
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.After;
import org.junit.Before;
import org.junit.Test;
import java.io.InputStream;
import java.util.Date;
import java.util.List;
public class testMybatis {
private SqlSessionFactory sqlSessionFactory;
private SqlSession session;
private MonsterMapper monsterMapper;
@Before
public void init() throws Exception{
// 得到myBatis-config.xml,转换成一个inputStream
InputStream inputStream = Resources.getResourceAsStream("myBatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//通过sqlSessionFactory对象获取一个回话
session = sqlSessionFactory.openSession();
//通过session获取到 monsterMapper这个接口对象
monsterMapper = session.getMapper(MonsterMapper.class);
}
@Test
public void testAdd() {
Monster monster = new Monster();
for(int i=0;i<10;i++) {
monster.setAge(100+i);
monster.setBirthday(new Date());
monster.setEmail("123@qq.com");
monster.setGender(1);
monster.setSalary(8928.00);
monster.setName("银角"+i);
monsterMapper.addMonster(monster);
}
}
@Test
public void testDel() {
monsterMapper.delMonster(1);
}
@Test
public void testUpdate() {
Monster monster = new Monster();
monster.setMonster_id(2);
monster.setAge(200);
monster.setBirthday(new Date());
monster.setEmail("123@qq.com");
monster.setGender(1);
monster.setSalary(8928.00);
monster.setName("牛魔怪");
monsterMapper.updateMonster(monster);
}
@Test
public void testFindById(){
Monster monster = new Monster();
monster = monsterMapper.findById(11);
System.out.println(monster);
}
@Test
public void testFindAllMonster () {
List<Monster> allMonster = monsterMapper.findAllMonster();
for (Monster monster: allMonster){
System.out.println(monster);
}
}
@After
public void destory() throws Exception{
if (session != null) {
session.commit();
session.close();
}
}
}
文章来源:https://www.toymoban.com/news/detail-767324.html
到了这里,关于myBatis-CRUD的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!