package com.example.mapper; // 根據(jù)你的項目結(jié)構(gòu)調(diào)整包名

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.entity.User; // 你的User實體類所在的包
import org.apache.ibatis.annotations.Mapper;

// 使用@Mapper注解讓Spring管理這個接口，并生成實現(xiàn)類
@Mapper
public interface UserMapper extends BaseMapper<User> {
    // 不需要寫任何方法，就已經(jīng)繼承了BaseMapper中的所有CRUD方法
    
    // 但你也可以根據(jù)需要添加自定義方法
}

package com.example.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableField;

// 指定實體類對應的數(shù)據(jù)庫表名
@TableName("user")
public class User {
    // 主鍵字段
    @TableId
    private Long id;
    
    // 普通字段，如果字段名與數(shù)據(jù)庫列名一致，可以不加注解
    private String name;
    
    private Integer age;
    
    // 如果數(shù)據(jù)庫列名與字段名不一致，可以使用@TableField指定
    @TableField("email_address")
    private String email;
    
    // 省略構(gòu)造函數(shù)、getter和setter方法...
    
    public User() {
    }
    
    public User(Long id, String name, Integer age, String email) {
        this.id = id;
        this.name = name;
        this.age = age;
        this.email = email;
    }
    
    // getter 和 setter 方法
    public Long getId() {
        return id;
    }
    
    public void setId(Long id) {
        this.id = id;
    }
    
    public String getName() {
        return name;
    }
    
    public void setName(String name) {
        this.name = name;
    }
    
    // 其他getter和setter...
}

# 數(shù)據(jù)源配置
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/your_database?useUnicode=true&characterEncoding=utf-8&useSSL=false
    username: your_username
    password: your_password

# MyBatis-Plus 配置
mybatis-plus:
  mapper-locations: classpath*:mapper/**/*.xml  # 如果有自定義XML查詢文件，指定路徑
  type-aliases-package: com.example.entity      # 實體類包路徑
  configuration:
    map-underscore-to-camel-case: true          # 自動開啟駝峰命名轉(zhuǎn)換
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 打印SQL日志

package com.example.service;

import com.example.mapper.UserMapper;
import com.example.entity.User;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;

@Service
public class UserService {
    
    @Autowired
    private UserMapper userMapper;
    
    public List<User> getAllUsers() {
        // 查詢所有用戶
        return userMapper.selectList(null);
    }
    
    public User getUserById(Long id) {
        // 根據(jù)ID查詢用戶
        return userMapper.selectById(id);
    }
    
    public List<User> getUsersByName(String name) {
        // 條件查詢：使用Lambda表達式避免硬編碼字段名
        LambdaQueryWrapper<User> wrapper = new LambdaQueryWrapper<>();
        wrapper.like(User::getName, name);
        
        return userMapper.selectList(wrapper);
    }
    
    public int addUser(User user) {
        // 插入用戶
        return userMapper.insert(user);
    }
    
    public int updateUser(User user) {
        // 更新用戶
        return userMapper.updateById(user);
    }
    
    public int deleteUser(Long id) {
        // 刪除用戶
        return userMapper.deleteById(id);
    }
}

@Mapper
public interface UserMapper extends BaseMapper<User> {
    
    // 自定義查詢方法：查詢年齡大于指定值的用戶
    @Select("SELECT * FROM user WHERE age > #{minAge}")
    List<User> selectUsersOlderThan(@Param("minAge") Integer minAge);
    
    // 或者使用XML配置的方式
    List<User> selectUsersByComplexCondition(Map<String, Object> params);
}

<?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.example.mapper.UserMapper">
    
    <select id="selectUsersByComplexCondition" resultType="com.example.entity.User">
        SELECT * FROM user 
        WHERE name LIKE CONCAT('%', #{name}, '%')
        AND age BETWEEN #{minAge} AND #{maxAge}
    </select>
    
</mapper>