Java小项目之:相亲网站,来一起非诚勿扰!( 五 )

PreparedStatement prep =

conn.prepareStatement(\"select * from friend_user2 where username=?\");

prep.setString(1 username);

ResultSet rst = prep.executeQuery();

if(rst.next()){

user = new User(rst.getString(\"username\")

rst.getString(\"password\")rst.getString(\"name\")

rst.getInt(\"age\")rst.getString(\"gender\")

rst.getString(\"phone\"));

user.setId(rst.getLong(\"id\"));

DBUtil.close(conn);

return user;

public User findById(Long id) throws Exception{

推荐阅读