@Override
public User mapRow(ResultSet rs, int index) throws SQLException {
User u = new User();
u.setId(rs.getLong("id"));
u.setType(rs.getInt("type"));
u.setUsername(rs.getString("username"));
u.setPassword(rs.getString("password"));
u.setWxuid(rs.getLong("wxuid"));
u.setNickname(rs.getString("nickname"));
u.setHeadimgurl(rs.getString("headimgurl"));
u.setCreatetime(rs.getTimestamp("createtime"));
u.setUpdatetime(rs.getTimestamp("updatetime"));
return u;
}
