<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.4.0</version>
</dependency>

server:
  port: 8889
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/boot_mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&AllowPublicKeyRetrieval=True
    username: root
    password: 123456
mybatis-plus:
  mapper-locations: mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true
  type-aliases-package: com.example.demo.entity

@Data
@TableName("t_user")
public class IUser {
    @TableId(value = "u_id", type = IdType.AUTO)
    private Integer uId;
    @TableField("user_name")
    private String userName;
    private String email;
    private String passWord;
    private Date birth;
    private int gender;
}

@Mapper
public interface IUserMapper extends BaseMapper<IUser> {}

@Autowired
private IUserMapper userMapper;

@Test
public void insertUser() {
    IUser user = new IUser();
    user.setUserName("曹操");
    user.setPassWord("88888888");
    user.setEmail("321@qin.com");
    userMapper.insert(user);
}

@Test
public void deleteUserById() {
    userMapper.deleteById(1001);
}

@Test
public void batchInsertUsers() {
    List<IUser> users = Arrays.asList(
        new IUser().setUserName("關(guān)羽").setPassWord("258"),
        new IUser().setUserName("關(guān)公").setPassWord("7530"),
        new IUser().setUserName("關(guān)項(xiàng)").setPassWord("159")
    );
    userMapper.insertBatch(users);
}

@Test
public void selectUsersByQueryWrapper() {
    QueryWrapper<IUser> queryWrapper = new QueryWrapper<>();
    queryWrapper.eq("user_name", "項(xiàng)羽").like("email", "123@163.com");
    userMapper.selectList(queryWrapper);
}

@Test
public void updateUserByUpdateWrapper() {
    UpdateWrapper<IUser> updateWrapper = new UpdateWrapper<>();
    updateWrapper.eq("user_name", "王小五").set("email", "wxw@qq.com");
    userMapper.update(null, updateWrapper);
}

@Service
public class UserService {

    @Autowired
    private IUserMapper userMapper;

    @Transactional
    public void updateUserAndSendEmail(String userName, String newEmail) {
        // 更新用戶信息
        IUser user = new IUser();
        user.setUserName(userName);
        user.setEmail(newEmail);
        userMapper.updateById(user);

        // 發(fā)送郵件操作（示例）
        sendEmailToUser(userName, newEmail);
    }

    private void sendEmailToUser(String userName, String email) {
        // 郵件發(fā)送邏輯
    }
}

public class SecurityUtils {

    public static String encryptPassword(String password) {
        // 加密密碼邏輯
    }

    public static boolean checkPassword(String rawPassword, String encryptedPassword) {
        // 驗(yàn)證密碼邏輯
    }
}

CREATE TABLE `t_user` (
    `u_id` int NOT NULL AUTO_INCREMENT COMMENT '主鍵',
    `user_name` varchar(10) NOT NULL COMMENT '用戶登錄名',
    `email` varchar(50) DEFAULT NULL COMMENT '郵箱',
    `pass_word` varchar(30) NOT NULL COMMENT '密碼',
    ...
    PRIMARY KEY (`u_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.4.0</version>
</dependency>
<dependency>
    <groupId>org.apache.velocity</groupId>
    <artifactId>velocity-engine-core</artifactId>
    <version>2.0</version>
</dependency>

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/generate?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&AllowPublicKeyRetrieval=True
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver

public class CodeGenerator {
    public static void main(String[] args) {
        AutoGenerator mpg = new AutoGenerator();
        mpg.setDataSource(new DataSourceConfig.Builder()
            .setUrl("jdbc:mysql://localhost:3306/generate?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&AllowPublicKeyRetrieval=True")
            .setDriverName("com.mysql.cj.jdbc.Driver")
            .setUsername("root")
            .setPassword("123456")
            .build());
        mpg.setGlobalConfig(new GlobalConfig.Builder()
            .setOutputDir(System.getProperty("user.dir") + "/src/main/java")
            .setAuthor("Your Name")
            .setOpen(false)
            .build());
        mpg.setPackageInfo(new PackageConfig.Builder()
            .setParent("com.example.demo")
            .setEntity("entity")
            .setMapper("mapper")
            .setService("service")
            .setController("controller")
            .build());
        mpg.setStrategy(new StrategyConfig.Builder()
            .setInclude("t_user")
            .build());
        mpg.execute();
    }
}

@Autowired
private TUserMapper userMapper;

@Test
public void testInsertUser() {
    TUser user = new TUser();
    user.setUserName("王中王");
    user.setPassWord("wzw123456");
    userMapper.insert(user);
}