SQLMapperConfig.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">
<!-- 配置JDBC事务控制,由mybatis进行管理 -->
<transactionManager type="JDBC"></transactionManager>
<!-- 配置数据源,采用mybatis连接池 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/spring"/>
<property name="username" value="root" />
<property name="password" value="5315314sd" />
</dataSource>
</environment>
</environments>
<mappers>
<!-- 加载 usermapper.xml 文件 -->
<mapper resource="usermapper.xml"/>
</mappers>
</configuration>
usermapper.xml信息:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- mapper 的 namespace 的值要等于 usermapper 接口的地址(包名.接口名) -->
<mapper namespace="duotiaojianchaxun.usermapper">
<!-- 查询用户
id 名字要等于 userdao 接口里面对应的方法名, parameterType 的类型等于对应方法里面的输入参数类型, resultType是对应
方法里面的返回值类型,例如 usermapper 接口里面的方法:finduserlist 的返回值类型 UserCustomer
usercustomer: 是在 UserQueryVo 类里面定义的 UserCustomer 的引用名,而并不是 UserCustomer 类名
-->
<select id="finduserlist" parameterType="duotiaojianchaxun.UserQueryVo" resultType="duotiaojianchaxun.UserCustomer">
select * from user where id =#{usercustomer.id} and name=#{usercustomer.name}
</select>
</mapper>
user类:
package test;
public class user {
private int id;
private String name;
private String password;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
@Override
public String toString() {
return "user [id=" + id + ", name=" + name + ", password=" + password + "]";
}
}
user的包装类(一般在关联查询的时候,不仅需要user 的信息,还需要比如订单等其他信息,所以把user 类包装在另一个类中)
package duotiaojianchaxun;
import test.user;
public class UserCustomer extends user{
//....
}
userqueryVo类:
package duotiaojianchaxun;
public class UserQueryVo {
private UserCustomer usercustomer;
public UserCustomer getUsercustomer() {
return usercustomer;
}
public void setUsercustomer(UserCustomer usercustomer) {
this.usercustomer = usercustomer;
}
}
usermapper接口类:
package duotiaojianchaxun;
import java.util.List;
import test.user;
public interface usermapper {
public List<UserCustomer> finduserlist(UserQueryVo userqueryvo);
public void inserUser(user user);
}
测试程序:
package duotiaojianchaxun;
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;
public class Test {
public static void main(String[]args) throws IOException{
UserQueryVo userqueryvo = new UserQueryVo();
UserCustomer uc = new UserCustomer();
//设置查询条件:查询id=2并且名字为:ml 的用户
uc.setId(2);
uc.setName("ml");
userqueryvo.setUsercustomer(uc);
String resource = "SqlMapConfig.xml";
InputStream is = Resources.getResourceAsStream(resource);
SqlSessionFactory sf = new SqlSessionFactoryBuilder().build(is);
SqlSession sqlsession = sf.openSession();
usermapper ud = sqlsession.getMapper(usermapper.class);
List<UserCustomer> list = ud.finduserlist(userqueryvo);
System.out.println(list);
}
}
整个项目框架图: