不能初始化,排除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();
}
}
依然没有解决