mybatis SqlSession Factory报空指针异常求大神帮忙解惑

weixin_44285038

于 2020-03-01 22:38:45 发布

612

文章标签： mybatis

本文链接：https://blog.csdn.net/weixin_44285038/article/details/104602186

版权

主配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>
      <dataSource type="POOLED">
        <property name="driver" value="com.mysql.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql:///class1"/>
        <property name="username" value="root"/>
        <property name="password" value="123"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="StudentMapper.xml"/>
    <mapper resource="PersonMapper.xml"/>
  </mappers>
</configuration

2映射配置

<?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.gg.dao.StudentMapper">
  <insert id="insertStudent">
  insert into student1 values(#{sid},#{sname},#{sage})
 
  </insert>
  
  <insert id="insertStudent2">
  insert into student1 values(#{sid},#{sname},#{sage})
 
  </insert>
  
  <insert id="insertStudent3" >
  <selectKey KeyProperty="sid" resultType="String" order="BEFORE">
  select replace(uuid(),"-","") from dual
  </selectKey>
  insert into student1 values(#{sid}, #{sname}, #{sage})

  </insert>
  
</mapper>

3测试类`

package com.zz.demo;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import com.zz.dao.StudentMapper;
import com.zz.helpers.DBHelper;

public class TestDemo {
	@Test
	public void testInsertStudent2() {
		SqlSession session = DBHelper.getSessionFactory().openSession(false);
		StudentMapper mapper = session.getMapper(StudentMapper.class);
		mapper.insertStudent2("1039", "zhaoliu", "5");
		session.commit();
	}
}

4控制台``

java.lang.NullPointerException
	at com.zz.demo.TestdDemo.testInsertStudent2(TestdDemo.java:12)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
	at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
	at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
	at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:538)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:760)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:460)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:206)

5手写工具类

package com.zz.helpers;

import java.io.InputStream;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class DBHelper {
		private static String rescource="mybatis.xml";
		private static SqlSessionFactory factory=null;
		static {
			try {
				InputStream inputStream;
				inputStream = Resources.getResourceAsStream(rescource);
				 factory = new SqlSessionFactoryBuilder().build(inputStream);
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		public static SqlSessionFactory getSessionFactory() {
			
			return factory;
		}
}