<dependency>
<groupId>com.github.chianghaojie</groupId>
<artifactId>psp4jdbc-core</artifactId>
<version>1.1.0</version>
</dependency>
public interface UserDao {
void addUser(User user);
void deleteUser(int userId);
void updateUser(User user);
User getUser(int userId);
}
@Sql("INSERT INTO user(name, age) VALUES(:user.name, :user.age)")
public void addUser(@Bind("user") User user);
@Sql("DELETE FROM user WHERE id=:userId")
public void deleteUser(@Bind("userId") int userId);
@Sql("UPDATE user SET name=:user.name, age=:user.age WHERE id=:user.id")
public void updateUser(@Bind("user") User user);
@Sql("SELECT * FROM user WHERE id=:userId")
public User getUser(@Bind("userId") int userId);
DaoFactory factory = new DaoFactory();
UserDao userDao = factory.createDao(UserDao.class);
User user = new User("Alice", 25);
userDao.addUser(user);
userDao.updateUser(user);
User retrievedUser = userDao.getUser(user.getId());
