?? userin.java
字號:
package com.laoer.bbscs.user;import java.sql.*;import java.io.*;import java.util.*;import com.laoer.bbscs.db.*;import com.laoer.bbscs.txthtml.*;import com.laoer.bbscs.admin.BBSConf;/** * <p>Title: BBS-CS</p> * <p>Description: BBS-CS(BBS式虛擬社區系統)</p> * <p>Copyright: Copyright (c) 2002</p> * <p>Company: loveroom.com.cn</p> * @author 龔天乙（laoer） * @version 3.0 */public class UserIn { String SQL = ""; DbTrans DBSQL; ResultSet rs = null; UserInfo myUserInfo; DoText myDoText; BBSConf myBBSConf; int UserExp = 0; int power = 0; int hpower = 0; String jibie = ""; public UserIn() { this.DBSQL = new DbTrans(); this.myUserInfo = new UserInfo(); this.myDoText = new DoText(); this.myBBSConf = new BBSConf(); } //public void setUserInfo(String strUserID) { // myUserInfo.setUserInfo(strUserID); //} public void setUserIn(String strUserID) { getUserLevel(strUserID); SQL = "update userdata set exp="+ this.UserExp +",power="+ this.power +",hpower="+ this.hpower +" where UID="+strUserID; try { DBSQL.executeQuery(SQL); } catch (SQLException e) { } } public int getUserExp(String strUserID) { int cishu = 0; int bx = 0; int artunm = 0; int staytime = 0; myUserInfo.setUserInfo(strUserID); cishu = myUserInfo.getUserCiShu(); UserData myUserData = new UserData(); myUserData.setUserData(strUserID); bx = myUserData.getUserBx(); artunm = myUserData.getUserArtNum(); staytime = myUserData.getUserStatyTime(); this.power = myUserData.getUserPower(); this.UserExp = (cishu/4)+artunm+(staytime/3600)+bx; return this.UserExp; } public String getUserLevel(String strUserID) { int exp = getUserExp(strUserID); String jibie = ""; if (exp>=0 && exp<=10) { this.hpower=10; jibie="新手上路"; } if (exp>=11 && exp<=50) { this.hpower=15; jibie="初出江湖"; } if (exp>=51 && exp<=130) { this.hpower=20; jibie="一般站友"; } if (exp>=131 && exp<=260) { this.hpower=30; jibie = "中級站友"; } if (exp>=261 && exp<=450) { this.hpower = 40; jibie="高級站友"; } if (exp>=451 && exp<=700) { this.hpower = 50; jibie = "老 站 友"; } if (exp>=701 && exp<=1100) { this.hpower=60; jibie="青銅長老"; } if (exp>=1101 && exp<=1900) { this.hpower = 80; jibie = "白銀長老"; } if (exp>=1901 && exp<=3000) { this.hpower = 100; jibie = "黃金長老"; } if (exp>=3001 && exp<=4500) { this.hpower = 120; jibie = "白金長老"; } if (exp>=4501 && exp<=6500) { this.hpower = 140; jibie = "鉆石長老"; } if (exp>=6501 && exp<=9000) { this.hpower = 170; jibie = "本站元老"; } if (exp>=9001) { this.hpower=200; jibie="開國大老"; } return jibie; } public int getUserPower() { return this.power; } public int getUserHPower() { return this.hpower; } public int getSumNote(String strUserID) { int znote = 0; SQL = "select count(*) as znote from guestbook where UID="+ strUserID; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { znote = rs.getInt("znote"); } rs.close(); } catch (SQLException e){ } return znote; } public int getSumNewNote(String strUserID) { int wnote = 0; SQL = "select count(*) as wnote from guestbook where UID="+ strUserID +" and yd=0"; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { wnote = rs.getInt("wnote"); } rs.close(); } catch (SQLException e){ } return wnote; } public int getNumMyFriend(String strUserID) { int myfriend = 0; SQL = "select count(*) as myfriend from friend where UID="+ strUserID; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { myfriend = rs.getInt("myfriend"); } rs.close(); } catch (SQLException e){ } return myfriend; } public int getNumOMyFriend(String strUserID) { int friendonlie = 0; SQL = "select count(*) as friendonlie from user,friend where friend.UID="+ strUserID +" and user.ID=friend.FID and (UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(user.logintime))<=180"; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { friendonlie = rs.getInt("friendonlie"); } rs.close(); } catch (SQLException e){ } return friendonlie; } public String getAdv() { String strAdv = ""; Random r = new Random(); int rnum; rnum = r.nextInt(2)+1; if (rnum == 1) { strAdv = "<a href=http://www.loveroom.com.cn target=_blank><img src=images/shmail.gif width=468 height=60 border=0></a>"; } else if (rnum == 2) { strAdv = "<script src=http://mysms.163.com/person?username=laoer&type=1></script>"; } else { strAdv = "<a href=http://www.loveroom.com.cn target=_blank><img src=images/shmail.gif width=468 height=60 border=0></a>"; } return strAdv; } public String getHotArt() { String strHotArt = ""; String tablecolor = ""; int n = 2; int i = 1; SQL = "select id2,board,title,time,click from forum where (UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(time))<=604800 and new=1 and delsign = 0 order by click desc limit 0,10"; try { rs = DBSQL.executeQuery(SQL); while (rs.next()) { if ((i %= n)==1) { tablecolor = myBBSConf.gettabletintcolor(); } else { tablecolor = myBBSConf.gettabledarkcolor(); } strHotArt += "<tr>\n"; strHotArt += "<td bgcolor="; if ((i %= n)==1) { strHotArt += tablecolor; } else { strHotArt += tablecolor; } strHotArt += "><a href='showdoc.jsp?bid="+rs.getString("board")+"&recid="+rs.getString("id2")+"&pages=1'>"; strHotArt += "<span class=bt>"+myDoText.iso2gb(rs.getString("title"))+"</span></a>"; strHotArt += "<font color=#FF0000> [點擊"+rs.getInt("click")+"次 發表于"+rs.getString("time")+"]</font></td>\n"; strHotArt += "</tr>\n"; i++; } rs.close(); } catch (SQLException e){ } return strHotArt; } public String getNewArt() { String strHotArt = ""; String tablecolor = ""; int n = 2; int i = 1; SQL = "select id2,board,boardname,title,time,havepic from forum where new=1 and delsign = 0 order by time desc limit 0,10"; try { rs = DBSQL.executeQuery(SQL); while (rs.next()) { if ((i %= n)==1) { tablecolor = myBBSConf.gettabletintcolor(); } else { tablecolor = myBBSConf.gettabledarkcolor(); } strHotArt += "<tr>\n"; strHotArt += "<td bgcolor="; if ((i %= n)==1) { strHotArt += tablecolor; } else { strHotArt += tablecolor; } strHotArt += "><a href='showdoc.jsp?bid="+rs.getString("board")+"&recid="+rs.getString("id2")+"&pages=1'>"; strHotArt += "<span class=bt>"+myDoText.iso2gb(rs.getString("title"))+"</span></a>"; strHotArt += "<font color=#FF0000> ["+myDoText.iso2gb(rs.getString("boardname"))+"]</font></td>\n"; strHotArt += "</tr>\n"; i++; } rs.close(); } catch (SQLException e){ } return strHotArt; } public String getUserPH() { String strUserPH = ""; String tablecolor = ""; int n = 2; int i = 1; SQL = "select user.name,user.nick,userdata.UID,userdata.exp from user,userdata where user.ID=userdata.UID order by userdata.exp desc limit 0,10"; try { rs = DBSQL.executeQuery(SQL); while (rs.next()) { if ((i %= n)==1) { tablecolor = myBBSConf.gettabletintcolor(); } else { tablecolor = myBBSConf.gettabledarkcolor(); } strUserPH += "<tr>\n"; strUserPH += "<td bgcolor="; if ((i %= n)==1) { strUserPH += tablecolor; } else { strUserPH += tablecolor; } strUserPH += "><a href='userinfo.jsp?UID="+rs.getInt("UID")+"'><span class=bt>"; strUserPH += myDoText.iso2gb(rs.getString("name"))+"</span></a>[經驗值："+rs.getInt("exp")+"]</td>\n"; strUserPH += "</tr>\n"; i++; } rs.close(); } catch (SQLException e){ } return strUserPH; } public String getHotBoard() { String strHotBoard = ""; SQL = "select ID,boardname from board order by xu"; try { rs = DBSQL.executeQuery(SQL); while (rs.next()) { strHotBoard += "["+myDoText.iso2gb(rs.getString("boardname"))+"]<br>"; strHotBoard += getHotBoards(rs.getString("ID")); } rs.close(); } catch (SQLException e){ } return strHotBoard; } public String getHotBoards(String bid) { String strHotBoards = ""; SQL = "select ID,boardsname from boards where boardID = "+bid+" order by artcount desc limit 0,3"; ResultSet rs1 = null; try { rs1 = DBSQL.executeQuery(SQL); while (rs1.next()) { strHotBoards += "<a href='right.jsp?bid="+rs1.getString("ID")+"&pages=1'>"+myDoText.iso2gb(rs1.getString("boardsname"))+"</a> "; } rs1.close(); } catch (SQLException e){ } strHotBoards += "<br>"; return strHotBoards; } public String getUserPic(String strUserID) { String strUserPic = ""; int photonum = 0; String picname = ""; SQL = "select count(*) as photonum from photo where UID="+strUserID; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { photonum = rs.getInt("photonum"); } rs.close(); } catch (SQLException e){ } if (photonum!=0) { SQL = "select picname from photo where UID="+strUserID; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { picname = rs.getString("picname"); strUserPic = "<a href='upload/"+picname+"' target='_blank'><img src=upload/"+ picname +" width=200 height=150 border=0></a>"; } rs.close(); } catch (SQLException e){ } } else { strUserPic = "<img src=images/photo.gif width=200 height=150>"; } return strUserPic; } public boolean isHaveStar() { int numStar = 0; SQL = "select count(*) as numStar from photo where isstart = 1"; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { numStar = rs.getInt("numStar"); } rs.close(); } catch (SQLException e){ } if (numStar != 0) { return true; } else { return false; } } public String getStarPic() { String strStarPic = ""; SQL = "select picname from photo where isstart = 1"; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { strStarPic = rs.getString("picname"); } rs.close(); } catch (SQLException e){ } return strStarPic; } public String getStarBrief() { String strStarBrief = ""; UserMyData StarUserMyData = new UserMyData(); String StarUID = ""; SQL = "select UID from photo where isstart = 1"; try { rs = DBSQL.executeQuery(SQL); if (rs.next()) { StarUID = rs.getString("UID"); } rs.close(); } catch (SQLException e){ return ""; } StarUserMyData.setUserMyData(StarUID); strStarBrief = StarUserMyData.getBrief(); StarUserMyData.close(); return strStarBrief; } public void close() { try { DBSQL.close(); } catch (SQLException e){ } myUserInfo.close(); myBBSConf.close(); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -