【正文】 北京機(jī)械工業(yè)出版社 2020 [8] SwingDavid 圖形設(shè)計卷二 [M]Prentice HallPea1 致 謝 在論文完成之際我首先向關(guān)心幫助和指導(dǎo)我的指導(dǎo)老師表示感謝并致以崇高的敬意在學(xué)校的學(xué)習(xí)生活結(jié)束回顧四年來的學(xué)習(xí)經(jīng)歷面對現(xiàn)在的收獲我感到無限欣慰為此我向所有老師和同學(xué)表示由衷的感謝在論文工作中遇到了許許多多這樣那樣的問題有的是專業(yè)上的問題有的是論文格式上的問題老師的親切關(guān)懷和悉心指導(dǎo)使我的論文可以又快又好的完成老師以其淵博的學(xué)識嚴(yán)謹(jǐn)?shù)闹螌W(xué)態(tài)度求實的工作作風(fēng)和他敏捷的思維給我留下了深刻的印象我將終生難忘我的老師對我的親切關(guān)懷和悉心指導(dǎo)再一次向他表示衷心的感謝感謝 他為學(xué)生營造的濃郁學(xué)術(shù)氛圍以及學(xué)習(xí)生活上的無私幫助 值此論文完成之際謹(jǐn)向老師致以最崇高的謝意最后衷心地感謝在百忙之中評閱論文和參加答辯的各位專家教授 package dao import import InputStream import NotFoundException import ception import ltSetMetaData import xception import yList import or import jeDefaultTableModel import lFriendModel import lLogUnLogModel import lLoginModel import lMesModel import nVO import erVO import DBUtil import LoginIdSucessFrame public class Dao private DBUtil dbutil new DBUtil 驗證登陸 public boolean isEnter LoginModel lm String sql select num from user where num lmgetnum and pass lmgetpass dbutilsetSet dbutilexecuteQuary sql try if dbutilgetSet next return true catch SQLException e TODO Autogenerated catch block eprintStackTrace finally dbutilcloseAll return false 登陸列表 public DefaultTableModel getLoginModel String sql select lnum 號 qname 昵稱 ttypename 狀態(tài) llogip IPllogtime 登陸時間 from login llogtype tuser q where lnum qnum and ltypeid ttypeid return thisgetSqlModel sql 根據(jù) sql 語句返回表格模型 public DefaultTableModel getSqlModel String sql Vector Vector data new Vector Vector Vector colName new Vector dbutilsetSet dbutilexecuteQuary sql ResultSetMetaData msd null int colCount 0 獲得數(shù)據(jù) try msd dbutilgetSet getMetaData colCount msdgetColumnCount 獲得列數(shù)量 while dbutilgetSet next Vector rowData new Vector for int i 1 i colCount i rowDataadd dbutilgetSet getString i dataadd rowData catch SQLException e TODO Autogenerated catch block eprintStackTrace 獲得列名 try for int i 1 i colCount i colNameadd msdgetColumnName i 得到列名 catch SQLException e TODO Autogenerated catch block eprintStackTrace 關(guān)閉通道 dbutilcloseAll return new DefaultTableModel datacolName 注冊登陸 public void addLoginUser LoginModel lm String sql insert into login values lmgetnum lmgetLogtype lmgetip sysdate dbutilexecuteDML sql 返回指定號的好友列表 public ArrayList getFriendsList int num String sql select frinum from friends where num num dbutilsetSet dbutilexecuteQuary sql 1 得到其好友的號 ArrayList friends new ArrayList try while dbutilgetSet next friendsadd dbutilgetSet getInt 1 catch SQLException e TODO Autogenerated catch block eprintStackTrace 2 獲得其好友的 FriendModel 模型 ArrayList friList new ArrayList for Integer frinum friends FriendModel friModel new FriendModel UserVO user thisgetUserByID frinum friModelsetnum frinum friModelsetname usergetname friModelsetdesc usergetdesc friModelsetOlpic usergetolpic friModelsetOfpic usergetofpic friModelsetMespic usergetmespic friModelsetLogtype 10 先設(shè)置好友登陸狀態(tài)為離線 檢測是否在線如果在線的設(shè)定其登陸狀態(tài)和登錄 ip LoginVO login thisgetLoginVOByID frinum if login null friModelsetIp logingetLogip friModelsetLogtype logingetTypeid friListadd friModel 3 添加好友自己的信息到列表 FriendModel selfModel new FriendModel UserVO selUserVO thisgetUserByID num LoginVO selLoginVO thisgetLoginVOByID num selfModelsetnum num selfModelsetname selUserVOgetname selfModelsetdesc selUserVOgetdesc selfModelsetOlpic selUserVOgetolpic selfModelsetOfpic selUserVOgetofpic selfModelsetMespic selUserVOgetmespic selfModelsetIp selLoginVOgetLogip selfModelsetLogtype selLoginVOgetTypeid friListadd 0selfModel return friList 刪除登出的用戶 public void unLoginUser int num String sql delete login where num num dbutilexecuteDML sql 查詢指定號的在線好友的 LogUnLogModel public ArrayList getOnLineFriendModel int numint logType ArrayList list new ArrayList ArrayList onFris thisgetOnLineFriendList num for LoginVO fri onFris LogUnLogModel clog new LogUnLogModel clogsetChangenum num clogsetLogType logType clogsetFriIP frigetLogip listadd clog return list 得到所有在線好友 LoginVO public ArrayList getOnLineFriendList int num String sql select frinum from friends where num num dbutilsetSet dbutilexecuteQuary sql 1 得到其好友的號 ArrayList friends new ArrayList try while dbutilgetSet next friendsadd dbutilgetSet getInt 1 catch SQLException e TODO Autogenerated catch block eprintStackTrace finally dbutilcloseAll 2 得到在線好友的 號 ArrayList onLinefriends new ArrayList for Integer frinum friends LoginVO login thisgetLoginVOByID frinum if login null onLinefri