[已解决]这个对象为什么创建不了

孤世星辰

1. E:\JAVAJDK\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\lib\idea_rt.jar=50939:E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\bin" -Dfile.encoding=UTF-8 -classpath "E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\lib\idea_rt.jar;E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\plugins\junit\lib\junit5-rt.jar;E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\plugins\junit\lib\junit-rt.jar;E:\JAVAJDK\jre\lib\charsets.jar;E:\JAVAJDK\jre\lib\deploy.jar;E:\JAVAJDK\jre\lib\ext\access-bridge-64.jar;E:\JAVAJDK\jre\lib\ext\cldrdata.jar;E:\JAVAJDK\jre\lib\ext\dnsns.jar;E:\JAVAJDK\jre\lib\ext\jaccess.jar;E:\JAVAJDK\jre\lib\ext\jfxrt.jar;E:\JAVAJDK\jre\lib\ext\localedata.jar;E:\JAVAJDK\jre\lib\ext\nashorn.jar;E:\JAVAJDK\jre\lib\ext\sunec.jar;E:\JAVAJDK\jre\lib\ext\sunjce_provider.jar;E:\JAVAJDK\jre\lib\ext\sunmscapi.jar;E:\JAVAJDK\jre\lib\ext\sunpkcs11.jar;E:\JAVAJDK\jre\lib\ext\zipfs.jar;E:\JAVAJDK\jre\lib\javaws.jar;E:\JAVAJDK\jre\lib\jce.jar;E:\JAVAJDK\jre\lib\jfr.jar;E:\JAVAJDK\jre\lib\jfxswt.jar;E:\JAVAJDK\jre\lib\jsse.jar;E:\JAVAJDK\jre\lib\management-agent.jar;E:\JAVAJDK\jre\lib\plugin.jar;E:\JAVAJDK\jre\lib\resources.jar;E:\JAVAJDK\jre\lib\rt.jar;C:\Users\a2032\Desktop\JAVA cod\mybatis_study\myabtis-1\target\test-classes;C:\Users\a2032\Desktop\JAVA cod\mybatis_study\myabtis-1\target\classes;C:\Users\a2032\.m2\repository\mysql\mysql-connector-java\5.1.47\mysql-connector-java-5.1.47.jar;C:\Users\a2032\.m2\repository\org\mybatis\mybatis\3.5.2\mybatis-3.5.2.jar;C:\Users\a2032\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\a2032\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 com.zwl.dao.UserDaoTest,test
   
2. 
   
3. java.lang.ExceptionInInitializerError
   
4.         at com.zwl.dao.UserDaoTest.test(UserDaoTest.java:13)
   
5.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
6.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
7.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
8.         at java.lang.reflect.Method.invoke(Method.java:498)
   
9.         at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
   
10.         at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    
11.         at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    
12.         at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    
13.         at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    
14.         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    
15.         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    
16.         at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    
17.         at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    
18.         at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    
19.         at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    
20.         at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    
21.         at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    
22.         at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    
23.         at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    
24.         at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
    
25.         at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
    
26.         at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
    
27.         at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
    
28.         at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
    
29. Caused by: org.apache.ibatis.exceptions.PersistenceException:
    
30. ### Error building SqlSession.
    
31. ### The error may exist in com/zwl/dao/UserMapper.java (best guess)
    
32. ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.GetUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
33.         at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    
34.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
    
35.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    
36.         at com.zwl.utils.MybatisUtils.<clinit>(MybatisUtils.java:18)
    
37.         ... 25 more
    
38. Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.GetUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
39.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:121)
    
40.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:98)
    
41.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
    
42.         ... 27 more
    
43. Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.GetUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
44.         at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:947)
    
45.         at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:903)
    
46.         at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:702)
    
47.         at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:297)
    
48.         at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parseStatement(MapperAnnotationBuilder.java:358)
    
49.         at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:139)
    
50.         at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72)
    
51.         at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:775)
    
52.         at org.apache.ibatis.builder.xml.XMLMapperBuilder.bindMapperForNamespace(XMLMapperBuilder.java:436)
    
53.         at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:96)
    
54.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:374)
    
55.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:119)
    
56.         ... 29 more
    
57. 
    
58. 
    
59. Process finished with exit code -1
    

复制代码

1. package com.zwl.dao;
   
2. 
   
3. import com.zwl.pojo.User;
   
4. import org.apache.ibatis.annotations.Select;
   
5. 
   
6. import java.util.List;
   
7. 
   
8. public interface UserMapper {
   
9. 
   
10.     @Select("select * from user")
    
11.     List<User> getUserList();
    
12. }
    

复制代码

1. <?xml version="1.0" encoding="UTF-8" ?>
   
2. <!DOCTYPE mapper
   
3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
   
4.         "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
   
5. <mapper namespace="com.zwl.dao.UserMapper">
   
6.    <select id="getUserList" resultType="com.zwl.pojo.User">
   
7.        select * from mybaits.User
   
8.    </select>
   
9. 
   
10. </mapper>

复制代码

1. package com.zwl.pojo;
   
2. 
   
3. public class User {
   
4.    private int id;
   
5.     private String name;
   
6.     private String pwd;
   
7. 
   
8.     public User() {
   
9.     }
   
10. 
    
11.     public User(int id, String name, String pwd) {
    
12.         this.id = id;
    
13.         this.name = name;
    
14.         this.pwd = pwd;
    
15.     }
    
16. 
    
17.     public int getId() {
    
18.         return id;
    
19.     }
    
20. 
    
21.     public void setId(int id) {
    
22.         this.id = id;
    
23.     }
    
24. 
    
25.     public String getName() {
    
26.         return name;
    
27.     }
    
28. 
    
29.     public void setName(String name) {
    
30.         this.name = name;
    
31.     }
    
32. 
    
33.     public String getPwd() {
    
34.         return pwd;
    
35.     }
    
36. 
    
37.     public void setPwd(String pwd) {
    
38.         this.pwd = pwd;
    
39.     }
    
40. 
    
41.     @Override
    
42.     public String toString() {
    
43.         return "User{" +
    
44.                 "id=" + id +
    
45.                 ", name='" + name + '\'' +
    
46.                 ", pwd='" + pwd + '\'' +
    
47.                 '}';
    
48.     }
    
49. }
    

复制代码

1. package com.zwl.utils;
   
2. 
   
3. import org.apache.ibatis.io.Resources;
   
4. import org.apache.ibatis.session.SqlSession;
   
5. import org.apache.ibatis.session.SqlSessionFactory;
   
6. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
   
7. 
   
8. import java.io.IOException;
   
9. import java.io.InputStream;
   
10. 
    
11. //sqlSessionFactory-->sqlSession
    
12. public class MybatisUtils {
    
13.     private static SqlSessionFactory sqlSessionFactory;
    
14.     static {
    
15.         try {
    
16.             String resource = "Mybatis-config.xml";
    
17.             InputStream inputStream = Resources.getResourceAsStream(resource);
    
18.             sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    
19.         } catch (IOException e) {
    
20.             e.printStackTrace();
    
21.         }
    
22.     }
    
23. 
    
24.     public static SqlSession getSqlSession(){
    
25.         return sqlSessionFactory.openSession();
    
26.     }
    
27. 
    
28. }
    

复制代码

1. <?xml version="1.0" encoding="UTF-8" ?>
   
2. <!DOCTYPE configuration
   
3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
   
4.         "https://mybatis.org/dtd/mybatis-3-config.dtd">
   
5. <configuration>
   
6.     <environments default="development">
   
7.         <environment id="development">
   
8.             <transactionManager type="JDBC"/>
   
9.             <dataSource type="POOLED">
   
10.                 <property name="driver" value="com.mysql.jdbc.Driver"/>
    
11.                 <property name="url" value="jdbc:mysql://localhost:3306/mysql/mybaits?useSSL=true&amp;useUnicode=true&amp;characterEncoding=UTF8"/>
    
12.                 <property name="username" value="root"/>
    
13.                 <property name="password" value="18870025610"/>
    
14.             </dataSource>
    
15.         </environment>
    
16.     </environments>
    
17.     <mappers>
    
18.         <mapper resource="com/zwl/dao/UserMapper.xml"/>
    
19.     </mappers>
    
20. </configuration>

复制代码

1. package com.zwl.dao;
   
2. 
   
3. import com.zwl.pojo.User;
   
4. import com.zwl.utils.MybatisUtils;
   
5. import org.apache.ibatis.session.SqlSession;
   
6. import org.junit.Test;
   
7. 
   
8. import java.util.List;
   
9. 
   
10. public class UserDaoTest {
    
11.     @Test
    
12.     public void test(){
    
13.         SqlSession sqlSession = MybatisUtils.getSqlSession();
    
14.         UserMapper mapper = sqlSession.getMapper(UserMapper.class);
    
15.         List<User> usersist = mapper.getUserList();
    
16.         for (User user : usersist) {
    
17.             System.out.println(user);
    
18.         }
    
19. 
    
20.         sqlSession.close();
    
21. 
    
22.     }
    
23. }
    

复制代码

最佳答案

月排行榜 / 总排行榜

holistic杀手

2024-4-8 15:42:37

你的错误是既写了注解的sql语句，又写了mapper的sql语句，你把@select(......)接口的这个sql删了就行

跳转到最佳答案楼层

holistic杀手

你的错误是既写了注解的sql语句，又写了mapper的sql语句，你把@select(......)接口的这个sql删了就行

FishC

根据你提供的错误信息和代码，问题出在`UserMapper`接口和`UserMapper.xml`文件的定义上。错误提示中指出 `Mapped Statements collection already contains value for com.zwl.dao.UserMapper.GetUserList.` 这意味着在同一个接口中重复定义了相同的方法。

解决办法是，检查你的`UserMapper`接口和对应的`UserMapper.xml`文件，确保没有重复定义相同的方法。根据你提供的代码，你可以尝试将`UserMapper`接口中的`GetUserList()`方法重命名为`getUserList()`（注意首字母小写），然后在`UserMapper.xml`文件中对应的SQL语句也做相应的修改。

修改后的`UserMapper`接口如下：

1. package com.zwl.dao;
   
2. 
   
3. import com.zwl.pojo.User;
   
4. import org.apache.ibatis.annotations.Select;
   
5. 
   
6. import java.util.List;
   
7. 
   
8. public interface UserMapper {
   
9. 
   
10.     @Select("select * from user")
    
11.     List<User> getUserList();
    
12. }

复制代码

然后，在`UserMapper.xml`文件中，将SQL语句修改为：

1. <select id="getUserList" resultType="com.zwl.pojo.User">
   
2.   select * from user
   
3. </select>

复制代码

同时，确保`UserMapper.xml`文件的命名空间和接口路径一致，即：`com.zwl.dao.UserMapper`。

这样修改之后，重新运行你的测试代码即可。希望能帮到你！

以上回复来自 FishC AI 小助理，如未能正确解答您的问题，请继续追问。

孤世星辰

FishC 发表于 2024-4-8 15:42
根据你提供的错误信息和代码，问题出在`UserMapper`接口和`UserMapper.xml`文件的定义上。错误提示中指出 ` ...

1. E:\JAVAJDK\bin\java.exe -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\lib\idea_rt.jar=59138:E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\bin" -Dfile.encoding=UTF-8 -classpath "E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\lib\idea_rt.jar;E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\plugins\junit\lib\junit5-rt.jar;E:\IDEA Community\IntelliJ IDEA Community Edition 2021.3.1\plugins\junit\lib\junit-rt.jar;E:\JAVAJDK\jre\lib\charsets.jar;E:\JAVAJDK\jre\lib\deploy.jar;E:\JAVAJDK\jre\lib\ext\access-bridge-64.jar;E:\JAVAJDK\jre\lib\ext\cldrdata.jar;E:\JAVAJDK\jre\lib\ext\dnsns.jar;E:\JAVAJDK\jre\lib\ext\jaccess.jar;E:\JAVAJDK\jre\lib\ext\jfxrt.jar;E:\JAVAJDK\jre\lib\ext\localedata.jar;E:\JAVAJDK\jre\lib\ext\nashorn.jar;E:\JAVAJDK\jre\lib\ext\sunec.jar;E:\JAVAJDK\jre\lib\ext\sunjce_provider.jar;E:\JAVAJDK\jre\lib\ext\sunmscapi.jar;E:\JAVAJDK\jre\lib\ext\sunpkcs11.jar;E:\JAVAJDK\jre\lib\ext\zipfs.jar;E:\JAVAJDK\jre\lib\javaws.jar;E:\JAVAJDK\jre\lib\jce.jar;E:\JAVAJDK\jre\lib\jfr.jar;E:\JAVAJDK\jre\lib\jfxswt.jar;E:\JAVAJDK\jre\lib\jsse.jar;E:\JAVAJDK\jre\lib\management-agent.jar;E:\JAVAJDK\jre\lib\plugin.jar;E:\JAVAJDK\jre\lib\resources.jar;E:\JAVAJDK\jre\lib\rt.jar;C:\Users\a2032\Desktop\JAVA cod\mybatis_study\myabtis-1\target\test-classes;C:\Users\a2032\Desktop\JAVA cod\mybatis_study\myabtis-1\target\classes;C:\Users\a2032\.m2\repository\mysql\mysql-connector-java\5.1.47\mysql-connector-java-5.1.47.jar;C:\Users\a2032\.m2\repository\org\mybatis\mybatis\3.5.2\mybatis-3.5.2.jar;C:\Users\a2032\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\a2032\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar" com.intellij.rt.junit.JUnitStarter -ideVersion5 -junit4 com.zwl.dao.UserDaoTest,test
   
2. 
   
3. java.lang.ExceptionInInitializerError
   
4.         at com.zwl.dao.UserDaoTest.test(UserDaoTest.java:13)
   
5.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
6.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   
7.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   
8.         at java.lang.reflect.Method.invoke(Method.java:498)
   
9.         at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
   
10.         at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    
11.         at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
    
12.         at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    
13.         at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325)
    
14.         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78)
    
15.         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57)
    
16.         at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
    
17.         at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
    
18.         at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
    
19.         at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
    
20.         at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
    
21.         at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
    
22.         at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    
23.         at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    
24.         at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
    
25.         at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
    
26.         at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
    
27.         at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
    
28.         at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
    
29. Caused by: org.apache.ibatis.exceptions.PersistenceException:
    
30. ### Error building SqlSession.
    
31. ### The error may exist in com/zwl/dao/UserMapper.java (best guess)
    
32. ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.getUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
33.         at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
    
34.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
    
35.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
    
36.         at com.zwl.utils.MybatisUtils.<clinit>(MybatisUtils.java:18)
    
37.         ... 25 more
    
38. Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.getUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
39.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:121)
    
40.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:98)
    
41.         at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
    
42.         ... 27 more
    
43. Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.zwl.dao.UserMapper.getUserList. please check com/zwl/dao/UserMapper.xml and com/zwl/dao/UserMapper.java (best guess)
    
44.         at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:947)
    
45.         at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:903)
    
46.         at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:702)
    
47.         at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:297)
    
48.         at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parseStatement(MapperAnnotationBuilder.java:358)
    
49.         at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:139)
    
50.         at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72)
    
51.         at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:775)
    
52.         at org.apache.ibatis.builder.xml.XMLMapperBuilder.bindMapperForNamespace(XMLMapperBuilder.java:436)
    
53.         at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:96)
    
54.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:374)
    
55.         at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:119)
    
56.         ... 29 more
    
57. 
    
58. 
    
59. Process finished with exit code -1
    

复制代码

修改之后这样了

FishC

孤世星辰 发表于 2024-04-08 16:25
E:\JAVAJDK\bin\java.exe -ea -Didea.test.cyclic.buf ...

根据你提供的错误信息和代码，问题出在`UserMapper`接口和`UserMapper.xml`文件的定义上。错误提示中指出 `Mapped Statements collection already contains value for com.zwl.dao.UserMapper.getUserList.` 这意味着在同一个接口中重复定义了相同的方法。

解决办法是，检查你的`UserMapper`接口和对应的`UserMapper.xml`文件，确保没有重复定义相同的方法。根据你提供的代码，你可以尝试将`UserMapper`接口中的`getUserList()`方法重命名为`getUserList2()`（或其他不重复的名称），然后在`UserMapper.xml`文件中对应的SQL语句也做相应的修改。修改后的`UserMapper`接口如下：

1. package com.zwl.dao;
   
2. 
   
3. import com.zwl.pojo.User;
   
4. import org.apache.ibatis.annotations.Select;
   
5. import java.util.List;
   
6. 
   
7. public interface UserMapper {
   
8.     @Select("select * from user")
   
9.     List<User> getUserList2();
   
10. }

复制代码

然后，在`UserMapper.xml`文件中，将SQL语句修改为：

1. <select id="getUserList2" resultType="com.zwl.pojo.User">
   
2.     select * from user
   
3. </select>

复制代码

同时，确保`UserMapper.xml`文件的命名空间和接口路径一致，即：`com.zwl.dao.UserMapper`。

这样修改之后，重新运行你的测试代码即可。希望能帮到你！

以上回复来自 FishC AI 小助理，如未能正确解答您的问题，请继续追问。

孤世星辰

FishC 发表于 2024-4-8 16:25
根据你提供的错误信息和代码，问题出在`UserMapper`接口和`UserMapper.xml`文件的定义上。错误提示中指 ...

还是一样的

FishC

孤世星辰 发表于 2024-04-08 19:08
还是一样的

根据你提供的错误信息和代码，问题出在`UserMapper`接口和`UserMapper.xml`文件的定义上。错误提示中指出 `Mapped Statements collection already contains value for com.zwl.dao.UserMapper.getUserList.` 这意味着在同一个接口中重复定义了相同的方法。

问题可能出在你的`UserMapper.xml`文件中重复定义了同一个方法。请检查你的`UserMapper.xml`文件，确保只有一个`select`语句定义了`com.zwl.dao.UserMapper.getUserList`。

另外，还要注意确保`UserMapper`接口和`UserMapper.xml`文件的命名空间和路径一致，即`com.zwl.dao.UserMapper`。

如果你仍然遇到相同的问题，可以考虑重新构建整个项目，确保所有依赖库和配置文件都正确引入，并且没有重复定义的问题。

希望能帮到你！

以上回复来自 FishC AI 小助理，如未能正确解答您的问题，请继续追问。