毕业论文终稿1-09级-电子信息程(2)班-李毅113 (10)

安康学院本科生毕业论文（设计）

} /*

return new DefaultTableModel(data,colName);

* 注册登陆 */

public void addLoginUser(LoginModel lm){ } /*

* 返回指定qq号的好友列表 */

public ArrayList getFriendsList(int qqnum){

String sql=\

dbutil.executeDML(sql);

\lm.getQqip()+\

String sql=\dbutil.setSet(dbutil.executeQuary(sql)); //1- 得到其好友的qq号

ArrayList friends=new ArrayList(); try { }

//2- 获得其好友的FriendModel模型 ArrayList for (Integer frinum : friends) {

35

while(dbutil.getSet().next()){ }

// TODO Auto-generated catch block e.printStackTrace();

friends.add(dbutil.getSet().getInt(1));

} catch (SQLException e) {

friList=new

ArrayList();

附件

}

}

FriendModel friModel=new FriendModel(); QQUserVO user=this.getQQUserByID(frinum); friModel.setQqnum(frinum);

friModel.setQqname(user.getQqname()); friModel.setQqdesc(user.getQqdesc()); friModel.setOlpic(user.getQqolpic()); friModel.setOfpic(user.getQqofpic()); friModel.setMespic(user.getQqmespic());

friModel.setLogtype(10);//先设置好友登陆状态为离线 //检测是否在线，如果在线的设定其登陆状态和登录ip LoginVO login=this.getLoginVOByID(frinum); if(login!=null){ }

friList.add(friModel);

friModel.setIp(login.getLogip()); friModel.setLogtype(login.getTypeid());

// 3- 添加好友自己的信息到列表

FriendModel selfModel=new FriendModel();

QQUserVO selUserVO=this.getQQUserByID(qqnum); LoginVO selLoginVO=this.getLoginVOByID(qqnum); selfModel.setQqnum(qqnum);

selfModel.setQqname(selUserVO.getQqname()); selfModel.setQqdesc(selUserVO.getQqdesc()); selfModel.setOlpic(selUserVO.getQqolpic()); selfModel.setOfpic(selUserVO.getQqofpic()); selfModel.setMespic(selUserVO.getQqmespic()); selfModel.setIp(selLoginVO.getLogip()); selfModel.setLogtype(selLoginVO.getTypeid()); friList.add(0,selfModel); return friList;

36

安康学院本科生毕业论文（设计）

/*

* 删除登出的用户 */

public void unLoginUser(int qqnum){ } /*

* 查询指定qq号的在线好友的LogUnLogModel */

public ArrayList getOnLineFriendModel(int qqnum,int logType){ } /*

* 得到所有在线好友LoginVO */

public ArrayList getOnLineFriendQQList(int qqnum){

String sql=\dbutil.executeDML(sql);

ArrayList ArrayList for (LoginVO fri : onFris) { }

return list;

LogUnLogModel clog=new LogUnLogModel(); clog.setChangeQqnum(qqnum); clog.setLogType(logType); clog.setFriIP(fri.getLogip()); list.add(clog);

list=new

ArrayList();

onFris=this.getOnLineFriendQQList(qqnum);

String sql=\dbutil.setSet(dbutil.executeQuary(sql)); //1- 得到其好友的qq号

37

附件

}

ArrayList friends=new ArrayList(); try { }

//2- 得到在线好友的qq号 ArrayList for (Integer frinum : friends) { }

return onLinefriends;

LoginVO login=this.getLoginVOByID(frinum); if(login!=null){ }

onLinefriends.add(login);

onLinefriends=new

while(dbutil.getSet().next()){ }

// TODO Auto-generated catch block e.printStackTrace(); dbutil.closeAll();

friends.add(dbutil.getSet().getInt(1));

} catch (SQLException e) {

} finally{

ArrayList();

//--------------- 获取VO ----------------------------------- /*

* 返回指定qq号的 qquserVO */

public QQUserVO getQQUserByID(int qqnum){

String sql=

\

\\

QQUserVO vo=null;

dbutil.setSet(dbutil.executeQuary(sql));

38

安康学院本科生毕业论文（设计）

try { if(dbutil.getSet().next()){ vo=new QQUserVO(); vo.setQqnum(qqnum);

vo.setQqname(dbutil.getSet().getString(1)); vo.setQqpass(dbutil.getSet().getString(2)); vo.setQqdesc(dbutil.getSet().getString(3)); vo.setQqsex(dbutil.getSet().getInt(4)); vo.setQqbirthday(dbutil.getSet().getDate(5)); vo.setQqolpic(dbutil.getSet().getBytes(6)); vo.setQqofpic(dbutil.getSet().getBytes(7)); vo.setQqmespic(dbutil.getSet().getBytes(8));

}

} catch (SQLException e) {

// TODO Auto-generated catch block e.printStackTrace(); } finally{

dbutil.closeAll();

}

return vo;

} /*

* 根据qq号，得到LoginVO对象 */

public LoginVO getLoginVOByID(int qqnum){ String sql=\typeid,logip,logtime from login qqnum=\

dbutil.setSet(dbutil.executeQuary(sql)); LoginVO vo=null;

try {

39

where