@Test
public void add() throws IOException {
// 1.通過Resources對象加載配置檔案
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
// 2.擷取SqlSessionFactory對象
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream );
// 3.通過SqlSessionFactory對象擷取SQLSession對象
SqlSession session = factory.openSession();
User user = new User();
user.setName("dpb");
user.setAge(22);
// dpb.addUser 是映射檔案中 namespace的内容加 id的内容，定位要執行的SQL
int count = session.insert("dpb.addUser", user);
System.out.println("影響的行數："+count);
// 需要顯示的送出
session.commit();
session.close();
}
}
mybatis教程1(基本使用)
mybatis教程1(基本使用)
public class Test02 {
private SqlSession sqlSession;
@Before
public void before() throws IOException {
// 1. 加載配置檔案
InputStream is = Resources.getResourceAsStream("mybatis-config.xml");
// 2. 根據配置檔案擷取一個SqlSessionFactory對象，這個對象相當于連接配接工廠
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(is);
// 3. 擷取一個sqlsession，sqlsession類似于之前學過的Connection
sqlSession = sqlSessionFactory.openSession();
}
@After
public void after() {
sqlSession.commit();
sqlSession.close();
}
@Test
public void test1() {
User user = new User();
user.setId(7);
user.setName("裡斯1");
int update = sqlSession.update("dpb.updateUserById", user);
System.out.println(update);
}
@Test
public void test2() {
int delete = sqlSession.delete("dpb.deleteUserById", 7);
System.out.println(delete);
}
@Test
public void test3() {
User user = (User) sqlSession.selectOne("dpb.getUserById", 8);
System.out.println(user);
}
}
mybatis教程1(基本使用)
/**
* 工具類 對外提供SqlSessionFactory的單例對象
* @author dengp
*
*/
public class DbUtils {
private static SqlSessionFactory factory ;
public static SqlSessionFactory getInstace(){
if(factory ==null){
InputStream in = null;
try{
in = Resources.getResourceAsStream("mybatis-config.xml");
}catch(Exception e){
e.printStackTrace();
}
synchronized (DbUtils.class) {
if(factory ==null){
factory = new SqlSessionFactoryBuilder().build(in);
}
}
}
return factory;
}
}
mybatis教程1(基本使用)
public interface UserMapper {
public int addUser(User user);
public int updateById(User user);
public int deleteById(int id);
public User queryById(int id);
}
public class UserDao implements UserMapper {
@Override
public int addUser(User user) {
return DBUtils.getInstall().openSession().insert("com.sxt.dao.UserMapper.addUser", user);
}
@Override
public int updateById(User user) {
// TODO Auto-generated method stub
return DBUtils.getInstall().openSession().update("com.sxt.dao.UserMapper.updateById", user);
}
@Override
public int deleteById(int id) {
// TODO Auto-generated method stub
return DBUtils.getInstall().openSession().delete("com.sxt.dao.UserMapper.deleteById", id);
}
@Override
public User queryById(int id) {
// TODO Auto-generated method stub
return DBUtils.getInstall().openSession().selectOne("com.sxt.dao.UserMapper.queryById", id);
}
}
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.sxt.dao.UserMapper">
<insert id="addUser" parameterType="com.sxt.bean.User">
insert into t_user(name,age)values(#{name},#{age})
</insert>
<delete id="deleteById" parameterType="java.lang.Integer">
delete from t_user where id=#{id}
</delete>
<update id="updateById" parameterType="com.sxt.bean.User">
update t_user
set name=#{name},age=#{age}
where id=#{id}
</update>
<select id="queryById" parameterType="java.lang.Integer"
resultType="com.sxt.bean.User">
select * from t_user where id=#{id}
</select>
</mapper>
/**
* 代理方式
*/
@Test
public void test(){
UserMapper mapper = (UserMapper) Proxy.newProxyInstance(UserMapper.class.getClassLoader()
, new Class[]{UserMapper.class},new InvocationHandler() {
@Override
public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
System.out.println(UserMapper.class.getName()+"."+method.getName());
Object id = null;
for (Object object : args) {
System.out.println(object);
id = object;
}
// 實作邏輯
return DBUtils.getInstall().openSession().selectOne(UserMapper.class.getName()+"."+method.getName(), id);
}
} );
System.out.println(mapper.queryById(5));
}
mybatis教程1(基本使用)
public interface UserMapper {
public int addUser(User user);
}
