mybatis模糊查询

用户信息类

package com.atguigu.mybatis.pojo;

import java.util.Objects;

public class user {
    private int id;
    private String userName;
    private String password;
    private int age ;
    private String gender;
    private String email;

    public user(int id, String userName, String password, int age, String gender, String email) {
        this.id = id;
        this.userName = userName;
        this.password = password;
        this.age = age;
        this.gender = gender;
        this.email = email;
    }
    public user(){}

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    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 int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getGender() {
        return gender;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    @Override
    public String toString() {
        return "user{" +
                "id=" + id +
                ", userName='" + userName + '\'' +
                ", password='" + password + '\'' +
                ", age=" + age +
                ", gender='" + gender + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

Mapper接口:

package com.atguigu.mybatis.pojo.mapper;

import com.atguigu.mybatis.pojo.user;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface UserMapper {
   int insertUser();
   int deleteUser();
   int updateUser();
  user selectUser();
   List<user>getUserLisr();
    List<Map<String,Object>>getAllUserInfor(int id);
//根据用户输入数据模糊查询
    List<user>select(@Param("username") String username);
}
mmapper中sql语句

</select>
<select id="select" resultType="user">
    select * from t_user where username like "%"#{username}"%"
</select>

测试类：

package com.atguigu.mybatis.text;

import com.atguigu.mybatis.pojo.mapper.UserMapper;
import com.atguigu.mybatis.pojo.untils.SqlSessionUtil;
import com.atguigu.mybatis.pojo.user;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;

import java.util.List;

public class selectTexr {
    @Test
    public void text(){
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        UserMapper mapper = sqlSession.getMapper(UserMapper.class);
        List<user> ad = mapper.select("ad");
        System.out.println(ad);
    }
}

总结：

在模糊查询中返回值要设置为list集合，因为查询结果数目不确定，且模糊查询语句中like后可写“%”#{要查询关键字属性}%“”