Mybatis-Plus
配置文件
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.1</version>
</dependency>
实体类
TableId:主键不一致
TableField:字段不一致
package com.xyc.gdd_exam.po;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.sql.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
@TableId(value = "user_id",type = IdType.AUTO)
private Integer id;//id
@TableField(value = "user_name")
private String username;//用户名
@TableField("user_pass")
private String password;//密码
@TableField("user_status")
private Integer status;//用户状态
@TableField("user_phone")
private String phone;//电话
@TableField("user_addr")
private String address;//地址
@TableField("user_pic")
private String pic;//头像
@TableField("user_purview")
private Integer purview;//权限
private Date createtime;//日期
}
mapper文件
BaseMapper:继承之后可以直接调用其中的方法,其中没有的方法需要自己写
package com.xyc.gdd_exam.mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.xyc.gdd_exam.po.User;
public interface UserMapper extends BaseMapper<User> {
}
service
条件查询可以使用selectByMap,其中放入map集合
没有条件,查询所有用户使用selectList,参数为null
/**
* 查询所有用户
* @return
*/
@Override
public List<User> selectAll(){
List<User> users = userMapper.selectList(null);
System.out.println("service users = " + users);
if (users!=null){
return users;
}else{
return null;
}
}
/**
* 用户登录
* @param username
* @param password
* @return
*/
@Override
public User login(String username, String password) {
System.out.println("username = " + username);
System.out.println("password = " + password);
if (username != null && password != null) {
Map<String, Object> map = new HashMap<>();
map.put("user_name", username);
List<User> users = userMapper.selectByMap(map);
System.out.println("users = " + users);
for (User user : users) {
if (password.equals(user.getPassword())) {
return user;
} else {
return null;
}
}
}
return null;
}