MyBatis空指针异常

 不能初始化,排除config.xml的错误

猜测与静态代码块有关

package utils;
 
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 
public class MyBatisUtil {
	private static SqlSessionFactory factory;
	
	static{//在静态代码块下,factory只会被创建一次
		System.out.println("哈哈哈工厂来了===============");
		try {
			InputStream is = Resources.getResourceAsStream("MyBatis-config.xml");
			factory = new SqlSessionFactoryBuilder().build(is);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
	}

  
	public static SqlSession createSqlSession(){
		return factory.openSession(false);//true 为自动提交事务
	}
	
	public static void closeSqlSession(SqlSession sqlSession){
		if(null != sqlSession) 
			sqlSession.close();
	}
}

但不知道怎么解决

改成这个后又是另一个问题

 以下为所有代码

User.java

package pojo;

import java.util.Date;

public class User {
	private Integer id; //id 
	private String userCode; //鐢ㄦ埛缂栫爜
	private String userName; //鐢ㄦ埛鍚嶇О
	private String userPassword; //鐢ㄦ埛瀵嗙爜
	private Integer gender;  //鎬у埆
	private Date birthday;  //鍑虹敓鏃ユ湡
	private String phone;   //鐢佃瘽
	private String address; //鍦板潃
	private Integer userRole;    //鐢ㄦ埛瑙掕壊
	private Integer createdBy;   //鍒涘缓鑰?
	private Date creationDate; //鍒涘缓鏃堕棿
	private Integer modifyBy;     //鏇存柊鑰?
	private Date modifyDate;   //鏇存柊鏃堕棿
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getUserCode() {
		return userCode;
	}
	public void setUserCode(String userCode) {
		this.userCode = userCode;
	}
	public String getUserName() {
		return userName;
	}
	public void setUserName(String userName) {
		this.userName = userName;
	}
	public String getUserPassword() {
		return userPassword;
	}
	public void setUserPassword(String userPassword) {
		this.userPassword = userPassword;
	}
	public Integer getGender() {
		return gender;
	}
	public void setGender(Integer gender) {
		this.gender = gender;
	}
	public Date getBirthday() {
		return birthday;
	}
	public void setBirthday(Date birthday) {
		this.birthday = birthday;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
	public String getAddress() {
		return address;
	}
	public void setAddress(String address) {
		this.address = address;
	}
	public Integer getUserRole() {
		return userRole;
	}
	public void setUserRole(Integer userRole) {
		this.userRole = userRole;
	}
	public Integer getCreatedBy() {
		return createdBy;
	}
	public void setCreatedBy(Integer createdBy) {
		this.createdBy = createdBy;
	}
	public Date getCreationDate() {
		return creationDate;
	}
	public void setCreationDate(Date creationDate) {
		this.creationDate = creationDate;
	}
	public Integer getModifyBy() {
		return modifyBy;
	}
	public void setModifyBy(Integer modifyBy) {
		this.modifyBy = modifyBy;
	}
	public Date getModifyDate() {
		return modifyDate;
	}
	public void setModifyDate(Date modifyDate) {
		this.modifyDate = modifyDate;
	}
}

 UserMapper.java

package dao;
 import java.util.List;

import pojo.User;

public interface UserMapper {

	public int count();
}

UserMapper.xml 

<?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="dao.UserMapper">
	<select id="fromUserTable" parameterType="Integer" resultType="User">
    select * from userTable
       
	</select>
	<select id="count" resultType="int">
		select count(*) as count from smbms_user
	</select>
	

</mapper>

 UserMapperTest.java

package dao;


import java.util.List;
import java.util.ArrayList;

import org.apache.ibatis.session.SqlSession;
import pojo.User;
import dao.UserMapper;
import utils.MyBatisUtil;


public class UserMapperTest {
	public static void main(String[] args) {
		SqlSession sqlSession=null;
		int count=0;
		
			try {
				sqlSession = MyBatisUtil.createSqlSession();
				//调用getMapper(Mapper.class)执行dao接口方法来实现对数据库的查询操作
				count = sqlSession.getMapper(UserMapper.class).count();
			} catch (Exception e) {
				// TODO: handle exception
				e.printStackTrace();
			}finally{
				sqlSession.close();
			}
				System.out.println("UserMapperTest count---> " + count);
	}
}

			

	




 MyBtisUtil.java

 

package utils;
 
import java.io.IOException;
import java.io.InputStream;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
 
public class MyBatisUtil {
	private static SqlSessionFactory factory;
	
	static{//在静态代码块下,factory只会被创建一次
		System.out.println("哈哈哈工厂来了===============");
		try {
			InputStream is = Resources.getResourceAsStream("MyBatis-config.xml");
			factory = new SqlSessionFactoryBuilder().build(is);
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} 
	}
	public static SqlSessionFactory getSqlSessionFactory() {
//      返回静态代码块中获取的工厂
      return factory;
  }
	public static SqlSession createSqlSession(){
		return factory.openSession(false);//true 为自动提交事务
	}
	
	public static void closeSqlSession(SqlSession sqlSession){
		if(null != sqlSession) 
			sqlSession.close();
	}
}

依然没有解决 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值