|
|
|
| |
resultset r4=prepare4.executequery();
vector friendno=new vector();//该矢量保存好友号码
while(r4.next()){
friendno.add(new integer(r4.getint(1)));
}
//read friend info
//以下告诉客户其好友的呢称，号码，ip地址，状态，头像，个人资料等信息
out.println(friendno.size());
for(int i=0;i<friendno.size();i++){
string friendinfo="select nickname,icqno,ip,status,pic,email,info from icq where icqno=?";
preparedstatement prepare5=c4.preparecall(friendinfo);
prepare5.clearparameters();
prepare5.setobject(1,friendno.get(i));
resultset r5=prepare5.executequery();
boolean status;
while(r5.next()){
out.println(r5.getstring("nickname"));
out.println(r5.getint("icqno"));
out.println(r5.getstring("ip"));
status=r5.getboolean("status");
if (status)out.println("1");
else {out.println("0");}
out.println(r5.getint("pic"));
out.println(r5.getstring("email"));
out.println(r5.getstring("info"));
} //while
r5.close();
}//for
//发送完毕
out.println("over");
system.out.println("over");
c4.close();r4.close();
}catch (exception e){e.printstacktrace();system.out.println("false");}
//socket.close();
}//end friend
//读取好友信息完毕
//以下处理用户添加好友
else if(str.equals("addfriend")){
system.out.println("add");
try{ class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection c6=drivermanager.getconnection("jdbc:odbc:javaicq"," "," ");
//连接数据库，根据接受的用户号码及好友号码向好友表添加记录
int friendicqno=integer.parseint(in.readline());
system.out.println(friendicqno);
int myicqno=integer.parseint(in.readline());
system.out.println(myicqno);
string addfriend="insert into friend values(?,?)";
preparedstatement prepare6=c6.preparecall(addfriend);
prepare6.clearparameters();
prepare6.setint(1,myicqno);
prepare6.setint(2,friendicqno);
int r6=0;
r6=prepare6.executeupdate();
if(r6==1) system.out.println("ok addfrien");
else system.out.println("false addfriend");
}catch (exception e){e.printstacktrace();system.out.println("false");}
//socket.close();
system.out.println("over addfriend");
}//end addfriend
//用户添加好友结束
//add new friend who add me
//以下处理其他用户如果加我，我就加他
else if(str.equals("addnewfriend")){
system.out.println("add");
try{ class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection c6=drivermanager.getconnection("jdbc:odbc:javaicq"," "," ");
//连接数据库，根据接受的用户号码及好友号码向好友表添加记录
int friendicqno=integer.parseint(in.readline());
system.out.println(friendicqno);
int myicqno=integer.parseint(in.readline());
system.out.println(myicqno);
string addfrie上一页 [1] [2] [3] [4] [5] [6] [7] [8] 下一页 |
|
|
|
|
|