问题一,找不到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
。