MyBatis 通过Java Bean传递多个参数

示例【MyBatis 通过Java Bean传递多个参数】

创建User

package com.po;
public class User {
	private Integer uid;
	private String username;
	private String password;
	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;
	}
	@Override
	public String toString() {
		return "User [uid=" + uid + ", username=" + username + ", password=" + password + "]";
	}
}

创建UserMapper.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="com.mapper.UserMapper">	
	<!-- 根据用户名、密码查询用户 -->
	<select id="getUser" parameterType="com.po.User" resultType="com.po.User">
		select * from t_user where username=#{username} and password=#{password}
	</select>
</mapper>

创建UserDao

package com.dao;
import org.apache.ibatis.session.SqlSession;
import com.factory.SessionFactory;
import com.po.User;
public class UserDao {
	private SqlSession session=SessionFactory.getSqlSession();
	private User user;
	//根据用户名、密码查询用户
	public User getUser(User user) {
		user=session.selectOne("com.mapper.UserMapper.getUser", user);
		return user;
	}

}

创建Test

package com.test;
import com.dao.UserDao;
import com.po.User;
public class Test {
	public static void main(String[] args) {
		UserDao userDao=new UserDao();
		User user=new User();
		user.setUsername("admin");
		user.setPassword("123");
		User use=userDao.getUser(user);
		System.out.println(use);
	}
}

运行main方法控制台输出如下：