ExpressPersistJDBC持久層框架

Express-Persist 是 ExpressMe 建站系統(tǒng)所用的 JDBC 持久層框架，目標(biāo)是封裝JDBC并提 供簡(jiǎn)單的數(shù)據(jù)庫(kù)操作接口。

示例代碼：

public interface UserDao {
    @Unique
    @MappedBy(UserRowMapper.class)
    @Query("select * from User u where u.id=:id")
    User queryUser(@Param("id") String id);

    @MappedBy(UserRowMapper.class)
    @Query("select * from User u order by u.name desc")
    List<User> queryUsers(@FirstResult int first, @MaxResults int max);

    @Update("insert into User(id, password, name) values(:u.id, :u.password, :u.name)")
    void createUser(@Param("u") User user);

    @Update("update User set password=:u.password, name=:u.name where id=:u.id")
    void updateUser(@Param("u") User user);
}

UserDao dao = createUserDao(); // discuss later
User u1 = new User("id-12345", "password", "Michael");
dao.createUser(u1);

User u2 = queryUser("abc1234");
u2.setName("Michael Liao");
u2.setPassword("abcdefg");
dao.updateUser(u2);