Java小项目之：相亲网站，来一起非诚勿扰！王囧草

Java小项目之：相亲网站，来一起非诚勿扰！

部分代码展示：

packagedao;

importjava.sql.Connection;

importjava.sql.PreparedStatement;

importjava.sql.ResultSet;

importjava.sql.Statement;

importjava.util.ArrayList;

importjava.util.List;

importutil.DBUtil;

importentity.User;

publicclassUserDAO{

publicListlist()throwsException{

Listusers=

newArrayList();

Connectionconn=DBUtil.getConnection();

Statementstat=conn.createStatement();

ResultSetrst=stat.executeQuery("select*fromfriend_user2");

while(rst.next()){

Useruser=newUser(rst.getString("username"),

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

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

rst.getString("phone"));

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

users.add(user);

}

DBUtil.close(conn);

returnusers;

publiclongsave(Useruser)throwsException{

longid=-1;

PreparedStatementprep=

conn.prepareStatement(

"insertintofriend_user2(username,password,name,age,gender,phone)"+

"values(,,,,,)",java.sql.Statement.RETURN_GENERATED_KEYS);

prep.setString(1,user.getUsername());

prep.setString(2,user.getPwd());

prep.setString(3,user.getName());

prep.setInt(4,user.getAge());

prep.setString(5,user.getGender());

prep.setString(6,user.getPhone());

prep.executeUpdate();

ResultSetrst=prep.getGeneratedKeys();

if(rst.next()){

id=rst.getLong(1);

returnid;

publicUserfindByUsername(Stringusername)throwsException{

Useruser=null;

conn.prepareStatement("select*fromfriend_user2whereusername=");