java高级,Mybatis框架的报错和解决

问题一,找不到map:

Exception in thread "main" org.apache.ibatis.builder.IncompleteElementException: Could not find parameter map  mybatis0506.pojo.Users
    at org.apache.ibatis.builder.MapperBuilderAssistant.getStatementParameterMap(MapperBuilderAssistant.java:315)
    at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:291)
    at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:113)
    at org.apache.ibatis.session.Configuration.lambda$buildAllStatements$2(Configuration.java:816)
    at java.util.Collection.removeIf(Collection.java:414)
    at org.apache.ibatis.session.Configuration.buildAllStatements(Configuration.java:815)
    at org.apache.ibatis.session.Configuration.hasStatement(Configuration.java:792)
    at org.apache.ibatis.session.Configuration.hasStatement(Configuration.java:787)
    at org.apache.ibatis.binding.MapperMethod$SqlCommand.resolveMappedStatement(MapperMethod.java:257)
    at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227)
    at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53)
    at org.apache.ibatis.binding.MapperProxy.lambda$cachedMapperMethod$0(MapperProxy.java:61)
    at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
    at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:61)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:56)
    at com.sun.proxy.$Proxy0.addUser(Unknown Source)
    at mybatis0506.pojo.part11_test.main(part11_test.java:17)
Caused by: java.lang.IllegalArgumentException: Parameter Maps collection does not contain value for  mybatis0506.pojo.Users
    at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:964)
    at org.apache.ibatis.session.Configuration.getParameterMap(Configuration.java:694)
    at org.apache.ibatis.builder.MapperBuilderAssistant.getStatementParameterMap(MapperBuilderAssistant.java:313)
    ... 16 more这个错误解析

更正:

<?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="mybatis0506.mapper.UsersMapper">

    <insert id="addUser" parameterMap="mybatis0506.pojo.Users">//将这里的map改为paramentertype
        insert into users(uname, uage) VALUES (#{uname},#{uage})
    </insert>


    <select id="findAllUser" resultType="mybatis0506.pojo.Users">
        select * from users order by uid desc
    </select>

</mapper>

错误2:

org.apache.ibatis.exceptions.PersistenceException: 
### Error building SqlSession.
### The error may exist in mapper/UsersMapper.xml
### The error occurred while processing mapper_resultMap[stuMap]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'mapper/UsersMapper.xml'. Cause: org.apache.ibatis.builder.BuilderException: Error resolving class. Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias ' mybatis0506.pojo.Users'.  Cause: java.lang.ClassNotFoundException: Cannot find class:  mybatis0506.pojo.Users...

这个错误是sqlSession出现错误,错误的原因在于MyBatis的执行器(Executor)已经被关闭了。具体来说,当你尝试通过MyBatis的映射器(Mapper)接口调用findAllUser方法时,MyBatis试图执行查询操作,但发现与它关联的执行器已经不再是活动的状态,即已经被关闭

我查看我我的代码,发现是代码关闭sqlSession后的代码,还再进行查询,但是此时的映射器(Mapper)已经失效了


       Users users=new Users();
       users.setUname("ll");
       users.setUage(111);
        int nRow=  usersMapper.addUser(users);
        sqlSession.commit();
        sqlSession.close();
       List<Users> list= usersMapper.findAllUser();//这个地方有问题
       for (Users users1:list){
           System.out.println(users1.getUid()+""+users1.getUage()+"");
       }


       if (nRow>0){
           System.out.println("insert sucu");
           return;
       }
        System.out.println("insert error");
    }
}

更正:

package mybatis0506.pojo;  
  
import mybatis0506.mapper.UsersMapper;  
import mybatis0506.utils.MyBatisUtils;  
import org.apache.ibatis.session.SqlSession;  
  
import java.util.List;  
  
public class part11_test {  
    public static void main(String[] args) {  
        try (SqlSession sqlSession = MyBatisUtils.getSession()) { // 使用try-with-resources自动管理SqlSession的生命周期  
            UsersMapper usersMapper = sqlSession.getMapper(UsersMapper.class);  
            Users users = new Users();  
            users.setUname("小明1");  
            users.setUage(18);  
            int nRow = usersMapper.addUser(users);  
            sqlSession.commit(); // 提交事务  
  
            // 在同一个SqlSession中查询  
            List<Users> list = usersMapper.findAllUser();  
            for (Users user : list) {  
                System.out.println(user.getUid() + " " + user.getUname() + " " + user.getUage());  
            }  
  
            if (nRow > 0) {  
                System.out.println("insert success");  
            } else {  
                System.out.println("insert error");  
            }  
        } // 这里SqlSession将自动关闭  
    }  
}

这段代码没有使用 .close 关闭sqlsession,而是使用try (SqlSession sqlSession = MyBatisUtils.getSession()) {  
    // ... 代码逻辑 ...  
} 来关闭,当执行离开 try 代码块时(无论是正常结束还是因为异常而退出),sqlSession 将自动关闭。这是通过 SqlSession 实现 AutoCloseable 接口来完成的。当 try-with-resources 语句结束时,它会自动调用 sqlSession.close() 方法来关闭 SqlSession

  • 9
    点赞
  • 20
    收藏
    觉得还不错? 一键收藏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值