MyBatis 通过Java Bean传递多个参数

￡神魔★判官ぃ 2022-05-15 00:47 318阅读 0赞

**示例【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方法控制台输出如下：**

![70][]

[70]: /images/20220515/3b4f019de8124e16bc818e78b5fc86e7.png