mybatis利用mapper代理的方法实现多条件查询

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);
	}
}

整个项目框架图：