配置mybatis的时候,异常找不到问题...,求大佬给看看
mybatis.xml里的代码:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/jdbctest"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="src/main/resources/usersMapper.xml"/>
</mappers>
</configuration>usersMapper.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="src/main/java/mybatis/Users">
<select id="usersList" resultType="src/main/java/mybatis/Users">
select * from user
</select>
</mapper>
Users.java里的代码:
package mybatis;public class Users {
private Integer uid;
private String username;
private String password;
private String name;
public Users() {
super();
// TODO Auto-generated constructor stub
}
public Users(Integer uid, String username, String password, String name) {
super();
this.uid = uid;
this.username = username;
this.password = password;
this.name = name;
}
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}TestDeml.java里的代码:
package mybatis;import java.io.IOException;
import java.io.InputStream;
import java.util.List;import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;public class TestDeml {
@Test
public void testDemo() throws IOException {
//初始化mybatis配置环境
String resource = "mybatis.xml";
InputStream is = Resources.getResourceAsStream(resource);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(is);
//打开数据库
SqlSession session = factory.openSession();
List<Users> ulist = session.selectList("usersList");
for(Users user:ulist) {
System.out.println(user);
}
session.close();
}
}
<mappers>
<mapper resource="src/main/resources/usersMapper.xml"/>
</mappers>
改成如下试试<mappers>
<mapper resource="usersMapper.xml"/>
</mappers>2. 这个地方也有问题
<select id="usersList" resultType="src/main/java/mybatis/Users">
select * from user
</select>
改为如下<select id="usersList" resultType="mybatis.Users">
select * from user
</select>
改为试试吧,不一定对