作者:MIKO_CHEUNG2011 | 来源:互联网 | 2023-05-21 09:56
所有的ORM框架学习曲线都是先来一个CRUD爽一爽,下面我们就来CRUD一下,所有的配置都是基于上一篇的配置。废话不多说,直接上代码。
insert into users(name, age) values(#{name}, #{age});
delete from users where id = #{id};
update users set name = #{name}, age = #{age} where id = #{id};
select * from users where id = #{id};
select * from users;
package com.bird.mybatis.bean;
import java.io.IOException;
import java.io.Reader;
import java.util.List;
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.Before;
import org.junit.Test;
public class MyTest {
private SqlSessionFactory factory;
@Before
public void init() {
String resource = "conf.xml";
Reader reader = null;
try {
reader = Resources.getResourceAsReader(resource);
} catch (IOException e) {
e.printStackTrace();
}
factory = new SqlSessionFactoryBuilder().build(reader);
}
@Test
public void testAdd() {
//默认是手动的
SqlSession session = factory.openSession();
String statement = "com.bird.mybatis.bean.userMapper.insertUser";
int rows = session.insert(statement, new Users(-1, "哈哈", 29));
//提交
session.commit();
System.out.println(rows);
session.close();
}
@Test
public void testUpdate() {
SqlSession session = factory.openSession();
String statement = "com.bird.mybatis.bean.userMapper.updateUser";
session.update(statement, new Users(4, "呵呵", 29));
session.commit();
session.close();
}
@Test
public void testDelete() {
SqlSession session = factory.openSession();
String statement = "com.bird.mybatis.bean.userMapper.deleteUser";
session.delete(statement, 1);
session.commit();
session.close();
}
@Test
public void testGetAllUser() {
SqlSession session = factory.openSession();
String statement = "com.bird.mybatis.bean.userMapper.getAllUser";
List list = session.selectList(statement);
System.out.println(list.size());
session.close();
}
}
Ok,so easy, 哪里不会点哪里Mybatis 简单的CRUD 基于XML文件配置