使用MyBatis优化Java持久层操作

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.8</version>
</dependency>

package cn.juwatech.config;
import org.apache.ibatis.datasource.pooled.PooledDataSource;
import org.apache.ibatis.mapping.Environment;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import javax.sql.DataSource;
public class MyBatisConfig {
    public SqlSessionFactory createSqlSessionFactory() {
        DataSource dataSource = new PooledDataSource("com.mysql.jdbc.Driver",
                                                     "jdbc:mysql://localhost:3306/mydatabase",
                                                     "username", "password");
        Environment environment = new Environment("development", dataSource);
        Configuration configuration = new Configuration(environment);
        configuration.addMapper(UserMapper.class);
        return new SqlSessionFactoryBuilder().build(configuration);
    }
}

package cn.juwatech.mapper;
import cn.juwatech.model.User;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import java.util.List;
public interface UserMapper {
    @Select("SELECT * FROM users")
    @Results({
        @Result(property = "id", column = "user_id"),
        @Result(property = "username", column = "user_name"),
        @Result(property = "password", column = "user_password")
    })
    List<User> findAllUsers();
}

package cn.juwatech.mapper;
import cn.juwatech.model.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Update;
public interface UserMapper {
    @Insert("INSERT INTO users(user_name, user_password) VALUES(#{username}, #{password})")
    void insertUser(User user);
    @Update("UPDATE users SET user_name=#{username}, user_password=#{password} WHERE user_id=#{id}")
    void updateUser(User user);
    @Delete("DELETE FROM users WHERE user_id=#{id}")
    void deleteUserById(Long id);
}

package cn.juwatech.mapper;
import cn.juwatech.model.User;
import org.apache.ibatis.annotations.CacheNamespace;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import java.util.List;
@CacheNamespace
public interface UserMapper {
    @Select("SELECT * FROM users WHERE user_id=#{id}")
    @Options(useCache = true)
    User findUserById(Long id);
}

package cn.juwatech.plugin;
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.*;
@Intercepts({
    @Signature(type = Executor.class, method = "update", args = {MappedStatement.class, Object.class})
})
public class MyInterceptor implements Interceptor {
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        // 实现自定义逻辑
        return invocation.proceed();
    }
}

<plugin type="org.mybatis.generator.plugins.SerializablePlugin"/>