关键代码
private SqlSession sqlSession;
{
String resource = "mybatis-config.xml";
Reader reader = null;
try{
reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
sqlSession= sqlSessionFactory.openSession();
}catch(IOException e) {
e.printStackTrace();
}
//调用和关闭
List<ccc> cccs= session.selectList("findCustomerByXxx",ccc);
session.close();
}
工具类
package MybatisUtils;
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 java.io.Reader;
public class MybatisUtils {
private static SqlSessionFactory sqlSessionFactory = null;
static {
try{
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
}catch (Exception e){
e.printStackTrace();
}
}
//获取session对话对象
public static SqlSession getSeesion(){
return sqlSessionFactory.openSession();
}
}
调用工具类
SqlSession session = MybatisUtils.getSeesion();
//.............
session.close();
注意: String resource = "mybatis-config.xml"; mybatis-config.xml要放在recourses目录下并且resources被声明为资源目录,也就是图标有四条黄色杠。
如此才能正常运行:
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");