package com.gyf.test;
import com.gyf.model.User;
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 javax.annotation.Resource;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Demo01 {
@Test
public void test1() throws IOException {
//读取配置文件
InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
//通过SqlSessionFactoryBuilder创建SqlSessionFactory会话工厂
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(is);
//通过SqlSessionFactory创建SqlSession
SqlSession session = sessionFactory.openSession();
//调用SqlSession的操作数据库方法
//查询一条结果
User user = session.selectOne("findUserById",10);
System.out.println(user);
//查询多条结果
List<User> users = session.selectList("findUserByName", "张");
System.out.println(users);
//关闭session
session.commit();
}
}
mybatis操作数据库代码示例
最新推荐文章于 2022-04-18 11:12:07 发布