bbscs 分析一


com.laoer.bbscs.service层下有众多的接口:
AgreeAgainstService,它有三个方法:
AgreeAgainst saveAgreeAgainst(AgreeAgainst agreeAgainst) throws BbscsException;
AgreeAgainst findAgreeAgainstByUidPidBid(String userID,String postID,long bid);
void removeOutTime(long time)throws BbscsException;
AgreeAgainstImp为其实现:
首先定义了一个logger,设置好agreeAgainstDAO;getAgreeAgainstDAO及setAgreeAgainstDAO;
public AgreeAgainst saveAgreeAgainst(AgreeAgainst agreeAgainst) throws BbscsException{
try{
return this.getAgreeAgainstDAO().saveAgreeAgainst(agreeAgainst);
(注:此处为合写,也可写成:
agreeAgainst=this.getAgreeAgainstDAO().saveAgreeAgainst(agreeAgainst);
return agreeAgainst;我这里啰嗦了一下,以后源代码中会用到,别问我为什么~~~)
}catch(Exception ex) {
logger.error(ex);
throw new BbscsException(ex);
}
}
注意的是getAgreeAgainstDAO返回的是AgreeAgainstDAO来自于com.laoer.bbscs.dao包中的interface;
它有三个接口方法:
public AgreeAgainst saveAgreeAgainst(AgreeAgainst agreeAgainst);
public AgreeAgainst findAgreeAgainstByUidPidBid(String userID,String postID,long bid);
public void removeOutTime(long time);
而实现上注入到service方法中的是其实现类:
com.laoer.bbscs.dao.hibernate.AgreeAgainstHibernateDAO,其注入了:
<property name="sessionFactory">
   <ref local="sessionFactory" />
  </property>
一个sessinFacotry唯一,用于获得可操作的session,让我们看看其实现:
它将两个HQL语句都重构成private static final String  了.一个是LOAD_BY_UID_PID_BID,一个是ROMOVE_OUTTIME,注意其extends HibernateDAOSupport抽象类(得到了org.springframework.orm.hibernate3.support.HibernateDAOSupport的支持哦~)这样我们就可以不用get和set这个sessionFacotry了,另外可能使用this.getHibernateTemplate()来进行实际操作了.
saveorupdate(agreeAgainst);对于查找:
先构造一个Object[] o={postID,userID,new Long(bid)};
List list=this.getHibernateTemplate().find(LOAD_BY_UID_PID_BID,o);
if(l==null||l.isEmpty()){
return null;
}
else{
return (AgreeAgaist) l.get(0);
}
}
最后removeOutTime(final long time) {
getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session)   throws HibernateException, SQLException{
Query query=s.createQuery(REMOVE_OUTTIME);
query.setLong(0,time);
query.executeUpdate();
return null;
}
});
};
}
我们看看hbm.xml文件和bean文件,先是bean(AgreeAgainst.java)
它有如下属性:
private String id;
private String userID;
private String postID;
private long boardID;
private int voteType;
private long createTime;
及其set/get方法的一个构造.
看下AgreeAgainst.hbm.xml文件:
<hibernate-mapping package="com.laoer.bbscs.bean">
  <class name="AgreeAgainst" table="bbscs_agreeagainst">
    <id name="id" column="ID" type="string" unsaved-value="null">
      <generator class="uuid"/>
    </id>
    <property column="UserID" length="40" name="userID" not-null="true" type="string"/>
    <property column="PostID" length="60" name="postID" not-null="true" type="string"/>
    <property column="BoardID" length="13" name="boardID" not-null="true" type="long"/>
    <property column="VoteType" length="1" name="voteType" type="int"/>
    <property column="CreateTime" name="createTime" not-null="true" type="long"/>
  </class>
</hibernate-mapping>
id为主键uuid算法,还要其长度的定义等等!其它不是......
看下数据库表!!! Null Default
ID varchar(40) NO 
UserID varchar(40) No
PostID varchar(40)No
BoardID bigint(20)No  0
VoteType tinyint(1)Yes  0
CreateTime bigint(20)No  0
我们来看下实现:
在帖子的支持和反对处选择!
Hibernate: insert into bbscs_agreeagainst (UserID, PostID, BoardID, VoteType, CreateTime, ID) values (?, ?, ?, ?, ?, ?)
Hibernate: select agreeagain0_.ID as ID24_, agreeagain0_.UserID as UserID24_, agreeagain0_.PostID as PostID24_, agreeagain0_.BoardID as BoardID24_, agreeagain0_.VoteType as VoteType24_, agreeagain0_.CreateTime as CreateTime24_ from bbscs_agreeagainst agreeagain0_ where agreeagain0_.PostID=? and agreeagain0_.UserID=? and agreeagain0_.BoardID=?
数据库中的数据:
ID:402881 e513bd c85501 13be01 e70d00 1f(32位)
UserID:4028818208ed006b0108ed020bd50001
PostID:402881e513bdc8550113bdefb43c0014
BoardID:2(第2个建的)
VoteType:1(反对)0(支持)
CreateTime:1184303802125
对比一下,就OK了




BoardAuthUserService(版块授权的用户)
有public BoardAuthUser saveBoardAuthUser(BoardAuthUser boardAuthUser) throws BbscsException;
punlic BoardAuthUser findBoardAuthUserById(String id);
public BoardAuthUser findBoardAuthUserByBidUid(long bid,String uid);
public BoardAuthUser findBoardAuthUserByBidUserName(long bid,String userName);
public List findBoardAuthUserByBid(long bid);
public void removeBoardAuthUser(BoardAuthUser boardAuthUser);
public void removeBoardAuthuserByBidUid(long bid,String uid) throws BbscsException;
public void removeBoardAuthUserByBidUserName(long bid,String userName) throws BbscsExeption;
同样,imp里BoardAuthUserServiceImp中,注入DAO
由DAO来完成对应方法的实际工作.注意:有Exception方法的写法,例如:
public void removeBoardAuthUserByBidUserName(long bid, String userName) throws BbscsException {
    try {
      this.getBoardAuthUserDAO().removeBoardAuthUserByBidUserName(bid, userName);
    }
    catch (Exception ex) {
      logger.error(ex);
      throw new BbscsException(ex);
    }
  }
来到DAO接口层,没有一个Exception方法哦!!!同样实现它的HibernateDAO也没有Ecxeption,可见,Serivce层有Exception.而DAO层没有Exception(一般情况下),除了没有Exception外,接口层与Serivce接口层好象.说说Exception:这里用到的只不过是一个BbscsException而已,在专门的com.laoer.bbscs.exception包中有这个类:原来它也继承了Exception而已,有三个重载的方法:
public BbscsException(String message) {
  super(message);
}

public BbscsException(String message, Throwable cause) {
  super(message, cause);
}

public BbscsException(Throwable cause) {
  super(cause);
}
自定义异常类的主要作用是区分异常发生的位置,当用户遇到异常时,根据异常名就可以知道哪里有异常,根据异常提示信息进行修改。

看其hibernate实现:
整个源码重构过似的,上面为HQL语句字串常量定义:
private static final String LOAD_BY_BID_UID = "from BoardAuthUser where boardID = ? and userID = ?";
private static final String LOADS_BY_BID = "from BoardAuthUser where boardID = ? order by createTime asc";
看看方法吧:
public BoardAuthUser findBoardAuthUserById(String id) {
    return (BoardAuthUser)this.getHibernateTemplate().get(BoardAuthUser.class, id);
  }
这个ID明显是对象标识!
public BoardAuthUser findBoardAuthUserByBidUserName(long bid, String userName) {
    Object[] o = {new Long(bid), userName};
    List l = this.getHibernateTemplate().find(LOAD_BY_BID_USERNAME, o);
    if (l == null || l.isEmpty()) {
      return null;
    }
    else {
      return (BoardAuthUser) l.get(0);
    }
  }
  public List findBoardAuthUsersByBid(long bid) {
    return this.getHibernateTemplate().find(LOADS_BY_BID, new Long(bid));
  }
需要注意的是Object数组中的元素必为对象;我们来看看是怎么删除操作的:
  public void removeBoardAuthUser(BoardAuthUser boardAuthUser) {
    this.getHibernateTemplate().delete(boardAuthUser);
  }
而不是一个BoradAuthUser对象,是通过以下代码实现:
public void removeBoardAuthUserByBidUid(final long bid, final String uid) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        Query query = s.createQuery(REMOVE_BY_BID_UID);
        query.setLong(1, bid);
        query.setString(0, uid);
        query.executeUpdate();
        return null;
      }
    });
  }

BoardPermissionService是版区(版块)的权限对应服务;其BEAN BoardPermission如下:

private String id;
  private long boardID;
  private int groupID;
  private List permissions = new ArrayList(); //特殊的哦~~~
再看下其hbm.xml文件:
<hibernate-mapping package="com.laoer.bbscs.bean">
  <class name="BoardPermission" table="bbscs_boardpermission">
    <id name="id" column="ID" type="string" unsaved-value="null">
      <generator class="uuid"/>
    </id>
    <property column="BoardID" length="20" name="boardID" not-null="true" type="long"/>
    <property column="GroupID" length="11" name="groupID" not-null="true" type="int"/>
    <property column="Permissions" name="permissions" type="com.laoer.bbscs.ext.hibernate.SplitList"/>
  </class>
</hibernate-mapping>
注意到:permissions对应于表的Permssions,而其type为com.laoer.bbscs.ext.hibernate.SplitList;
让我们看看SplitList这个类:(它在ext.hibernate包中):

[转自网络:
使用Hibernate自定义UserType遇到的一个问题
    Hibernate自定义UserType可以使设计更为优雅,逻辑更为清晰。第一次使用遇到了问题。Rule表中有一个字段methods,类型为VARCHAR(30),not null, 允许有多个method,中间用逗号分开,之所以这么设计是不想为此增加一个关联表。为methods实现了一个自定义UserType叫MethodsList,该类对用户隐藏了实现细节,使用户不用处理method的连接和拆分,而使用List来操作就行了,非常直观。在保存Rule实体的时候,Hibernate报methods字段不允许为空,说明methods在持久化的时候还是null,DEBUG发现在调用session.saveOrUpdate()方法的时候methods不为空,但在调用MethodsList的nullSafeSet(PreparedStatement st, Object value, int index)时显示value的值为null,Google了很久仍然没有找到原因 后来发现只要把methods字段的not null属性设为false(即允许为空)问题就不复存在了,很是奇怪...
     据此猜测,Hibernate在应用自定义UserType(即MethodsList)之前进行字段是否为空之类的检查,而这时methods字段还是null,所以出现以上错误,把该字段改为允许为空之后自然就没有问题了。个人愚见,仅供参考,有空研究一下Hibernate源码一探究
robbin:
1、UserType不是用来做主键的(虽然也可以,但是那样和复合主键没有区别了,并且复合主键是非常不推荐的做法)
2、UserType比Component更加灵活,适用性更强,封装的更透明。
]
其中有以下方法:assembledeepCopy(重要)disassmbleequals(重要)hashCodeisMutable ullSafeGet eplace eturnedClasssqlTypes等方法需要实现(不一定)!
rs--->Object
public Object nullSafeGet(ResultSet resultSet, String[] stringArray, Object object) throws HibernateException,
   SQLException {
  String value = (String) Hibernate.STRING.nullSafeGet(resultSet, stringArray[0]);
  if (value != null) {
   return parse(value);
  } else {
   return new ArrayList();
  }
}
用了parse方法:
private List parse(String value) {
  String[] strs = StringUtils.split(value, SPLITTER);
  List set = new ArrayList();
  for (int i = 0; i < strs.length; i++) {
   if (!StringUtils.isBlank(strs[i])) {
    set.add(Long.valueOf(strs[i]));
    // System.out.println(strs[i]);
    // set.add(new Long(Long.parseLong(strs[i])));
   }
  }
  return set;
}

object--->rs
public void nullSafeSet(PreparedStatement preparedStatement, Object object, int _int) throws HibernateException,
   SQLException {
  if (object != null) {
   String str = assemble((List) object);
   Hibernate.STRING.nullSafeSet(preparedStatement, str, _int);
  } else {
   Hibernate.STRING.nullSafeSet(preparedStatement, "", _int);
  }
}
用了assemble方法:
private String assemble(List set) {
  StringBuffer sb = new StringBuffer();
  Iterator it = set.iterator();
  while (it.hasNext()) {
   sb.append(it.next());
   sb.append(SPLITTER);
  }
  String fs = sb.toString();
  if (fs != null && fs.length() > 0 && fs.endsWith(SPLITTER)) {
   fs = fs.substring(0, fs.length() - 1);
  }
  return fs;
}
附参考资料:http://blog.csdn.net/ckangtai/archive/2007/05/23/1622396.aspx
好,看完这个后,我们进入到服务内容:
public BoardPermission saveBoardPermission(BoardPermission bp) throws BbscsException;
public BoardPermission updateBoardPermission(BoardPermission bp) throws BbscsException;
  public BoardPermission findBoardPermissionByID(String id);
  public BoardPermission findBoardPermissionByBidGid(long bid, int gid);
  public List findBoardPermissionsByBid(long bid);
public List findBoardPermissionsByGid(int gid);
public void removeBoardPermissionsByBid(long bid) throws BbscsException;
  public void removeBoardPermissionsByGid(int gid) throws BbscsException;
实际是由注入的boardPermissionDAO其实现类完成的.
注意这里引入了  private Cache userPermissionCache;这个缓存类!
我们从applicationContext.xml看看是什么东东:
<bean id="userPermissionCache"
  class="com.laoer.bbscs.service.imp.OsCacheImp">
  <constructor-arg>
   <value>${cacheup.config}</value>
  </constructor-arg>
</bean>
哦,原来是另外一个服务,${cacheup.config}指的是cacheup.config=oscache_up.properties;
在classes下有许多配置文件,是用不同的配置文件是为了方便集群,以区分是不同的缓存。 
我们从com.laoer.bbscs.serivce.Cache接口看起,它提供了如下方法:
public void add(Object key,Object value);
public Object get(Object key);
public void remove(Object key);
public void removeAll();
再看imp:
由于spring中的bean带construtctor-arg:
将调用构造方法:
public OsCacheImp(String profile) {
  Properties properties = new Properties();
  ClassPathResource classPathResource = new ClassPathResource(profile);
//这个类标识从classpath获得的资源
  try {
   logger.info("Init Cache...");
   properties.load(classPathResource.getInputStream());//使用Properties的load(InputStream   inStream)   来读取配置文件的时候 
   admin = new GeneralCacheAdministrator(properties);
  } catch (Exception ex) {
   logger.error(ex);
   admin = new GeneralCacheAdministrator();
  }
}
注意,这个admin对象来自OSCache包,用于管理Cache内容吧.另外,我们看看其对Cache的实现:
public void add(Object key, Object value) {
  logger.debug("Add into cache [Key:" + key + "]");
  this.admin.putInCache(String.valueOf(key), value);
}
  public Object get(Object key) {
  try {
   logger.debug("Get from cache [Key:" + key + "]");
   return this.admin.getFromCache(String.valueOf(key));
  } catch (NeedsRefreshException ex) {
   logger.debug("Object not in cache, return null");
   this.admin.cancelUpdate(String.valueOf(key));
   return null;
  }
}
public void remove(Object key) {
  logger.debug("Remove from cache [Key:" + key + "]");
  this.admin.flushEntry(key.toString());
}
public void removeAll() {
  logger.debug("Remove all");
  this.admin.flushAll();
}
这样就可以对缓存内容进行控制操作了(就用这几个方法)!让我们回到BoardPermissionSerivceImp类中:
注入了DAO和Cache(userPermissionCache)后,进行方法实现时,主要还是DAO去做,不过在saveBoardPermission和updateBoardPermission,还有各种remove方法中还用了this.clearPermissionCache();(除了find),让我们来看看它的代码吧:
  private void clearPermissionCache() {
    if (Constant.USE_PERMISSION_CACHE) {
//public static final boolean USE_PERMISSION_CACHE = true;
      this.getUserPermissionCache().removeAll();//调用Cache中的方法哦!removeALL看上面this.admin.flushAll();!
    }
  }
555555,这个服务类也了Cache服务(与别的服务结合了),下面是DAO实现:
private static final String LOAD_BY_BID_GID ="from BoardPermission where boardID = ? and groupID = ?";
  private static final String LOADS_BY_BID = "from BoardPermission where boardID = ?";
  private static final String LOADS_BY_GID = "from BoardPermission where groupID = ?";
  private static final String REMOVE_BY_BID = "delete from BoardPermission where boardID = ?";
  private static final String REMOVE_BY_GID = "delete from BoardPermission where groupID = ?";
我们看update:
  public BoardPermission updateBoardPermission(BoardPermission bp) {
    //System.out.println("update bp");
    this.getHibernateTemplate().update(bp);
    return bp;
  }
再看:
/**
   * 根据GroupID删除BoardPermission对象
   *
   * @param gid int
   * @todo Implement this com.laoer.bbscs.dao.BoardPermissionDAO method
   */
  public void removeBoardPermissionsByGid(final int gid) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        Query query = s.createQuery(REMOVE_BY_GID);
        query.setLong(0, gid);
        query.executeUpdate();
        return null;
      }
    });
  }

接下来,是BoardSaveService:
先看bean吧,它实现了implements Serializable...,加入private static final long serialVersionUID = 5390014211916049604L;它有三个属性:
private String id;
private String userID;
private long boardID;
[
Java的JavaBeans. Bean的状态信息通常是在设计时配置的。Bean的状态信息必须被存起来,以便当程序运行时能恢复这些状态信息。这也需要serializaiton机制。
总之如果在网络的环境下做类传输,应该还是implements Serializable。
]
再看其hbm.xml:
<hibernate-mapping package="com.laoer.bbscs.bean">
  <class name="BoardSave" table="bbscs_boardsave">
    <id name="id" column="ID" type="string" unsaved-value="null">
      <generator class="uuid"/>
    </id>
    <property column="UserID" length="40" name="userID" not-null="true" type="string"/>
    <property column="BoardID" length="13" name="boardID" not-null="true" type="long"/>
  </class>
</hibernate-mapping>
从这样便知是用于收藏版区的对象模型啊!那接下来看其接口中的方法:
public BoardSave saveBoardSave(BoardSave boardSave) throws BbscsException;
  public BoardSave findBoardSaveById(String id);
public BoardSave findBoardSaveByUidBid(String userId, long bid);
  public List findBoardSavesByUid(String userId);
  public List findBoardSaveBidsByUid(String userId);//找Bid的List
  public void removeBoardSave(BoardSave boardSave) throws BbscsException;
  public void removeBoardSaveByUidBid(String userId, long bid) throws BbscsException;
  public void removeBoardSaveByBid(long bid) throws BbscsException;
  public void removeBoardSaveByBidsUid(String userId, List ids) throws BbscsException;
对于imp调用dao-->daoimp我们直接进入dao的imp中:
其中的常量定义如下:
  private static final String LOAD_BY_UID_BID = "from BoardSave where userID = ? and boardID = ?";
  private static final String LOADS_BY_USERID = "from BoardSave where userID = ?";
  private static final String LOADS_BOARDID_BY_USERID = "select boardID from BoardSave where userID = ?";//很特别哦!(其实也没什么,相对而已)
  private static final String REMOVE_BY_UID_BID = "delete from BoardSave where userID = ? and boardID = ?";
  private static final String REMOVE_BY_BID = "delete from BoardSave where boardID = ?";
  private static final String REMOVE_IN_IDS_BY_UID =
      "delete from BoardSave where userID = :userID and boardID in (:ids)";
我们来看方法实现吧.
public BoardSave saveBoardSave(BoardSave boardSave) {
    this.getHibernateTemplate().saveOrUpdate(boardSave);
    return boardSave;
  }
可用于保存,也可以用于更新!
public List findBoardSaveBidsByUid(String userId) {
    return this.getHibernateTemplate().find(LOADS_BOARDID_BY_USERID, userId);
//一个参数
public void removeBoardSaveByBidsUid(final String userId, final List ids) {
    getHibernateTemplate().execute(new HibernateCallback() {
      public Object doInHibernate(Session s) throws HibernateException, SQLException {
        Query query = s.createQuery(REMOVE_IN_IDS_BY_UID);
        query.setString("userID", userId);
        query.setParameterList("ids", ids);
        query.executeUpdate();
        return null;
      }
    });
  }
OK!

接下来,是BoardService,先看其相关的Bean!它也实现了可序列化操作...它的属性特别多..
很关键哦!
private Long id;//主键
private long parentID;//父级版区ID
private List parentIDs;//所有父级版区ID列表
private List childIDs;
private String boardName;//版区名称
private String explains;(说明)
private String bulletin;(公告)
private String boardPic;//图片
private int useStat;(使用状态)
private int orders;//序
private int needPasswd;//是否需要密码访问
private String passwd;//访问密码
private int level;---->数据库中的BoardLevel//级别
private int boardType;(类型1,2,3)//版区类型
private int allowHTML;//HTML是否支持
private int allowUBB;//UBB...
private int auditPost; (帖子是否需要审核)
private int auditAttach;//附件是否需要审核
private int addUserPostNum;//是否增加用户发贴数
private int isHidden;
private int isAuth;//是否需要论证用户才能访问
private long mainPostNum;//主贴数
private long postNum;//帖子数量
private Map boardMaster=new HashMap();
private Set boardTag=new HashSet();
我们看看Board.hbm.xml,错了,我们应该看看applicationCotext.xml中的内容是不是这个,经查看:
<value>com/laoer/bbscs/bean/Board-${datasource.type}.hbm.xml</value>,我用mysql当然是Board-mysql.hbm.xml,其内容主要如下:
<hibernate-mapping package="com.laoer.bbscs.bean">
  <class name="Board" table="bbscs_board">
    <id name="id" column="ID" type="long" unsaved-value="null">
      <generator class="identity"/> //long类型的identity!
    </id>
    <property column="ParentID" length="20" name="parentID" not-null="true" type="long"/>
    <property column="ParentIDs" name="parentIDs" type="com.laoer.bbscs.ext.hibernate.SplitList"/>//parentIDs有用了userType
    <property column="ChildIDs" name="childIDs" type="com.laoer.bbscs.ext.hibernate.SplitList"/>
    <property column="BoardName" length="60" name="boardName" not-null="true" type="string"/>
    <property column="Explains" name="explains" type="text"/>//text类型
    <property column="Bulletin" name="bulletin" type="text"/>
    <property column="BoardPic" length="200" name="boardPic" type="string"/>
    <property column="UseStat" length="1" name="useStat" type="int"/>//一个开关的功能
    <property column="Orders" length="11" name="orders" type="int"/>//论坛排序
    <property column="NeedPasswd" length="1" name="needPasswd" type="int"/>//开关
    <property column="Passwd" length="100" name="passwd" type="string"/>
    <property column="BoardLevel" length="11" name="level" type="int"/>
    <property column="BoardType" length="2" name="boardType" type="int"/>
    <property column="AllowHTML" length="1" name="allowHTML" type="int"/>
    <property column="AllowUBB" length="1" name="allowUBB" type="int"/>
    <property column="AuditPost" length="1" name="auditPost" type="int"/>
    <property column="AuditAttach" length="1" name="auditAttach" type="int"/>//不懂???
    <property column="AddUserPostNum" length="1" name="addUserPostNum" type="int"/>//应该是一个开关吧
    <property column="IsHidden" length="1" name="isHidden" type="int"/>
    <property column="IsAuth" length="1" name="isAuth" type="int"/>
    <property column="MainPostNum" length="11" name="mainPostNum" type="long"/>
    <property column="PostNum" length="11" name="postNum" type="long"/>
  //关键点,boardMaster和boardTag均为one-to-many类型!
    <map name="boardMaster" inverse="true" cascade="all-delete-orphan" lazy="false">
      <key column="boardID"/>
      <map-key column="UserName" type="string"/>
      <one-to-many class="BoardMaster"/>
    </map>
    <set name="boardTag" inverse="true" cascade="all-delete-orphan" lazy="false" order-by="orders asc">
      <key column="boardID"/>
      <one-to-many class="BoardTag"/>
    </set>
  </class>
</hibernate-mapping>
看完这些后,我们就知道这个bean是用于版区操作了,让我们看看方法:(先看接口BoardService)
public Board saveBoard(Board board) throws BbscsException;//保存或更新Board对象
public Board createBoard(Board board) throws BbscsException;
public Board updateBoard(Board board, long oldParentID) throws BbscsException;
public Board getBoardByID(long id);
public List findBoardsByParentID(long pid, int useStat, int hidden, int orderType);
public List findBoardsAllTree(long pid, List topList, int useStat, int hidden, int orderType);
public int getNextOrder(long pid);
public int getPostSumNum(int mainorall, int useStat, int hidden);
public void removeBoard(Board board) throws BbscsException;
public Map[] getBoardPermission(long bid, int groupID);
public Map[] getBoardMasterPermission(int roleID);
public boolean isBoardMaster(Board board, String userName);
public List findBoardsInIDs(List ids);
public void removeBoardTag(Board board, String tagID) throws BbscsException;
public List getBoardIDs(List boards);
public void saveBoardsPostNumCount() throws BbscsException;
这里方法有16个左右,注意我们进行除了查询后的其它CURD操作都可能会产生异常.对于具体方法我们需要去了解其实现才能理清其作用.看下服务实现层:(注BoardServiceCacheImp为其实现类,可能是加入了许多缓存的原因吧):
首先仍是logger(这里发现了原来其实在service层和dao层只有这里需要logger,其它地方都没,对于异常也只有service接口和实现层有BbscsException这个异常处理,而对于DAO层的异常则已经由HibernateTemplate完全抛出了,如:  
public void saveOrUpdate(final Object entity)
        throws DataAccessException
    {
        execute(new HibernateCallback() {

            public Object doInHibernate(Session session)
                throws HibernateException
            {
                checkWriteOperationAllowed(session);
                session.saveOrUpdate(entity);
                return null;
            }

        }
, true);
    }
)
我们回到正题上,除了logger,还有boardDAO(当然要了)
,userGroupDAO,boardPermissionDAO(讲过的),permissionDAO,roleDAO,forumDAO,forumHistoryDAO,还有一些Cache服务:sysListObjCache,boardCache,userPermissionCache(以前用过),还有一个额外的服务类:sysStatService;对他们进行getter/setter方法一下...
我们分析下sysStatService:(applicationContext.xml) 系统统计服务
<bean id="sysStatService"
  class="com.laoer.bbscs.service.imp.SysStatServiceImp"
  scope="prototype"> //每次请求都产生一个对象
  <property name="userConfig">
   <ref bean="userConfig" />
  </property>
</bean>
userConfig指:
<bean id="userConfig"
  class="com.laoer.bbscs.service.config.UserConfig">
  <property name="safePath">
   <value>${bbscs.safePath}</value> //安全目录我的指的是D:/safe/
  </property>
</bean>

UserConfig是一个config配置服务,在服务类中首先注入了safePath 这个String对象,它向外提供了String getUserFilePath(String userID)[简单,最终得到一个用户文件Path,见实际目录就可知道其原理]和String getIndexPath()和File getIndexFilePath()以及boolean indexExist()四个对外公共方法.详细看方法实现:
public String getIndexPath() {     //好象没用到过
  StringBuffer sb = new StringBuffer();
  sb.append(this.getSafePath());
  sb.append("index/");
  return sb.toString();
}
public File getIndexFilePath() {
  File indexFilePath = new File(this.getIndexPath());//构造一个File对象
  if (!indexFilePath.exists()) {
   indexFilePath.mkdirs();
  }
  return indexFilePath;
}
public boolean indexExist() {
  File file = new File(this.getIndexPath() + "segments");
  return file.exists();//使用文件是否存在的方法作判断!
}
可见config服务类较简单(没用到logger)!提供一个常用服务!而com.laoer.bbscs.service.imp.SysStatService是怎么用到它的呢?它继承了抽象类SysStatService,在这个抽象类中,有一个东西是私有的:
private long onlineNum = 0;
  private long appearTime = 0; 发表时间long类型
  private String appearTimeStr = "";
  private long allUserNum = 0;
  private String lastRegUser = "";
  private long postMainNum = 0;
  private long postNum = 0;
(这个东西和safe文件夹下的sysstat.properties好像啊,看看先:

#sysstat.properties
#Mon Jul 16 11:35:16 CST 2007   //appearTimeStr ??
onlineNum=2
postMainNum=1
allUserNum=2
appearTime=963209825828
postNum=1
lastRegUser=sgwood

)下面有其get/set方法,子类可以继承哦!当然,还有一个子类需实现的方法:
public abstract void load();
  public abstract void saveOnline(long nowonlinenum);//在线数
  public abstract void saveAllUserNum(long allusernum, String lastreguser);//所有用户数和最后注册用户名
  public abstract void savePostNum(long main, long all); //存入主题贴和总数
接着我们看下SysStatServiceImp.java文件好了:它加入了logger和UserConfig对象先,看下面的load方法:

public void load() {
  Properties prop = new Properties();
  File f = new File(this.getUserConfig().getSafePath() + "sysstat.properties");  //getSafePath()当然会暴露出来!
  if (f.exists()) {
   try {
    FileInputStream fis = new FileInputStream(f);
    prop.load(fis);
/**只需传递这个文件的 InputStream 给 load() 方法,就会将每一个键-值对添加到 Properties 实例中。然后用 list() 列出所有属性或者用 getProperty() 获取单独的属性。
list() 方法的输出中键-值对的顺序与它们在输入文件中的顺序不一样。 Properties 类在一个散列表(hashtable,事实上是一个 Hashtable 子类)中储存一组键-值对,所以不能保证顺序。
*/
    this.setOnlineNum(Long.parseLong(prop.getProperty("onlineNum", "0").trim()));//继承过来的!!!
    this.setAppearTime(Long.parseLong(prop.getProperty("appearTime", "0").trim()));
    this.setAllUserNum(Long.parseLong(prop.getProperty("allUserNum", "0").trim()));
    this.setLastRegUser(prop.getProperty("lastRegUser", ""));
    this.setPostMainNum(Long.parseLong(prop.getProperty("postMainNum", "0").trim()));
    this.setPostNum(Long.parseLong(prop.getProperty("postNum", "0").trim()));
    this.setAppearTimeStr(Util.formatDateTime(new Date(this.getAppearTime())));//写时间用
    fis.close();
   } catch (NumberFormatException ex) {
    logger.error(ex);
   } catch (FileNotFoundException ex) {
    logger.error(ex);
   } catch (IOException ex) {
    logger.error(ex);
   }
  } else {
   save(); //文件不存在时!内部private方法哦
  }
}

private void save() {
  String path = this.getUserConfig().getSafePath() + "sysstat.properties";
  Properties prop = new Properties();
  prop.setProperty("onlineNum", String.valueOf(this.getOnlineNum()));
  prop.setProperty("appearTime", String.valueOf(this.getAppearTime()));
  prop.setProperty("allUserNum", String.valueOf(this.getAllUserNum()));
  prop.setProperty("lastRegUser", this.getLastRegUser());
  prop.setProperty("postNum", String.valueOf(this.getPostNum()));
  prop.setProperty("postMainNum", String.valueOf(this.getPostMainNum()));
  try {
   FileOutputStream fos = new FileOutputStream(path);//写入新文件中
   prop.store(fos, "sysstat.properties");
   fos.close();
  } catch (FileNotFoundException ex) {
   logger.error(ex);
  } catch (IOException ex) {
   logger.error(ex);
  }
}

我们看下对抽象类的实现吧:(先load一下资源文件,再set相关的key值,最后用私有的save一下)
public void saveAllUserNum(long allusernum, String lastreguser) {
  this.load();
  this.setAllUserNum(allusernum);
  this.setLastRegUser(lastreguser);
  this.save();
}
public void saveOnline(long nowonlinenum) {
  this.load();
  if (nowonlinenum > this.getOnlineNum()) {  //好象不太对,不然只有多没有少!
   long atime = System.currentTimeMillis();
   this.setOnlineNum(nowonlinenum);
   this.setAppearTime(atime);
   this.setAppearTimeStr(Util.formatDateTime(new Date(atime)));
   this.save();
  }
}
public void savePostNum(long main, long all) {
  this.load();
  this.setPostMainNum(main);
  this.setPostNum(all);
  this.save();
}
OK!终于可以回到BoardServiceCachImp实现类中了,绕了好大一个弯!由于还有许多东西没用过,只能推测一下其用法了哦~~~还是先看几个,createBoard(Board board)先:
@SuppressWarnings("unchecked")
public Board createBoard(Board board) throws BbscsException {
  try {
   Board pboard = this.getBoardDAO().getBoardByID(board.getParentID()); // 取得父级版区
   if (pboard != null) { // 父级版区存在
    List pboards = new ArrayList();
    pboards.addAll(pboard.getParentIDs());//父的祖先
    pboards.add(pboard.getId());//父
/** addAll(Collection c)
add(int index,Elelemt e)
注意parentIDs和childIDs均为List是由自定义userType的
public Class returnedClass() {
  return List.class;
}
决定返回是List类型的!
*/
    board.setParentIDs(pboards); // 设置父级版区列表字段
    board.setLevel(pboard.getLevel() + 1); // 设置级别,在父级别上+1
   }
   board = this.getBoardDAO().saveBoard(board);//这里的其它参数由添加时决定,不需要改变,或由其它因素相关!由DAO完成实质的工作

   if (pboard != null) {
    List pcboards = this.getBoardDAO().findBoardsByParentID(board.getParentID(), 1, -1,
      Constant.FIND_BOARDS_BY_ORDER);
/** 取得父级半区的所有子版区列表pcboard,1是useStat,-1是hidden,FIND_BOARD_BY_ORDER=0另外有,
public static final int FIND_BOARDS_BY_MAINPOSTNUM = 1;
public static final int FIND_BOARDS_BY_POSTNUM = 2;
/*

    List cids = this.getBoardIDs(pcboards);//得到子版ID的List
/**
public List getBoardIDs(List boards) {
  List<Long> l = new ArrayList<Long>();
  for (int i = 0; i < boards.size(); i++) {
   Board b = (Board) boards.get(i);
   l.add(b.getId());
  }
  return l;
}

*/
    pboard.setChildIDs(cids); // 设置父级版区的所有子版区列表字段
    this.getBoardDAO().saveBoard(pboard);//更新父信息
    this.getBoardCache().remove(pboard.getId());
/**从Board Cache中清除, 我们看下BoardCache的bean定义:
<bean id="boardCache"
  class="com.laoer.bbscs.service.imp.OsCacheImp"> 仍然是这个,以前讲过!
  <constructor-arg>
   <value>${cache.config}</value> cache.config=oscache.properties
  </constructor-arg>
</bean>
public void remove(Object key) {
  logger.debug("Remove from cache [Key:" + key + "]");
  this.admin.flushEntry(key.toString());
}
从oscache.properties配置处的Cache内容中去掉key=pboard.getID()的对象,让OSCache自动缓存内容吧!
*/
   }

   this.clearBoradListSysListCache(board.getParentID());
/**它其实是一私有方法哦!需要注意的是实质用了SysListOjbCache,它其中的对象标识竟是[][][][][],5555,可能有些对象后三者可不用:
private void clearBoradListSysListCache(long pid) {
  String[] useStats = { "-1", "0", "1" };
  String[] hiddens = { "-1", "0", "1" };
  String[] orderTypes = { "0", "1", "2" };
  for (int i = 0; i < useStats.length; i++) {
   for (int j = 0; j < hiddens.length; j++) {
    for (int x = 0; x < orderTypes.length; x++) {
     this.getSysListObjCache().remove(
       "[B][" + pid + "][" + useStats[i] + "][" + hiddens[j] + "][" + orderTypes[x] + "]");
    }
   }
  }
}
*/

   // 为版区增加用户组版区权限
   List gl = this.getUserGroupDAO().findUserGroupsAll();
/**取得用户组列表
public List findUserGroupsAll() {
  return this.getHibernateTemplate().find(LOADS_ALL);
}
private static final String LOADS_ALL = "from UserGroup order by id";
原始数据为6个记录的表(见数据库),id1---6,以GroupName区分之,TypeID表示代表类型,默认是系统类型的,不能删除,用户自己建的就是另外一个类型了。
*/
   BoardPermission bp;

   for (int i = 0; i < gl.size(); i++) {
    UserGroup ug = (UserGroup) gl.get(i);
    bp = new BoardPermission();
    bp.setBoardID(board.getId().longValue());//冗余字段
    bp.setGroupID(ug.getId().intValue());//冗余字段

    switch (ug.getId().intValue()) {
    case 1:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_1);
/**<property column="Permissions" name="permissions" type="com.laoer.bbscs.ext.hibernate.SplitList"/>
     break;
    case 2:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_2);
     break;
    case 3:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_3);
     break;
    case 4:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_4);
     break;
    case 5:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_5);
     break;
    case 6:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_6);
     break;
    default:
     bp.setPermissions(Constant.BOARD_PERMISSION_GROUP_LIST_1);
    }
    this.getBoardPermissionDAO().saveBoardPermission(bp);
/**而在Constant.java中有段static段:
for (int i = 0; i < BOARD_PERMISSION_GROUP_1.length; i++) {
   BOARD_PERMISSION_GROUP_LIST_1.add(new Long(BOARD_PERMISSION_GROUP_1[i]));
  }

  for (int i = 0; i < BOARD_PERMISSION_GROUP_2.length; i++) {
   BOARD_PERMISSION_GROUP_LIST_2.add(new Long(BOARD_PERMISSION_GROUP_2[i]));
  }

  for (int i = 0; i < BOARD_PERMISSION_GROUP_3.length; i++) {
   BOARD_PERMISSION_GROUP_LIST_3.add(new Long(BOARD_PERMISSION_GROUP_3[i]));
  }

  for (int i = 0; i < BOARD_PERMISSION_GROUP_4.length; i++) {
   BOARD_PERMISSION_GROUP_LIST_4.add(new Long(BOARD_PERMISSION_GROUP_4[i]));
  }

  for (int i = 0; i < BOARD_PERMISSION_GROUP_5.length; i++) {
   BOARD_PERMISSION_GROUP_LIST_5.add(new Long(BOARD_PERMISSION_GROUP_5[i]));
  }
*/
   }

   return board;

  } catch (Exception e) {
   logger.error(e);
   throw new BbscsException(e);
  }

}
从创建中可以知道,它调用了两个cache(sysListObjCache和boardCache,对父级和本级的相关项进行更新(或产生),再保存.还有就是对此分版区(论坛)的用户权限的写入.总的来说,原则上,要数据服务(保存和查找)从DAO层来,要Cache从服务层来,要常用服务也从服务层来(因为它不参与DAO工作)

接下来,我们继续看findBoardAllTree:
@SuppressWarnings("unchecked")//类型安全问题
public List findBoardsAllTree(long pid, List topList, int useStat, int hidden, int orderType) {
  List l = this.getBoardDAO().findBoardsByParentID(pid, useStat, hidden, orderType);//这个pid指的是当前论坛,与前面的pid不一样哦

  for (int i = 0; i < l.size(); i++) {
   Board b = (Board) l.get(i);
   topList.add(b);
   this.findBoardsAllTree(b.getId().longValue(), topList, useStat, hidden, orderType);//由于topList是一个引用类型,可递归得到All子论坛及子论坛的子论坛...
  }
  return topList;
}
而这个服务类的findBoardByParentID(非DAO)它首先是查询SysListObjCache里面有没有,若没有的话再由DAO从数据库中找,且放入到SysListObjCache中,用了add方法,需注意的是其命名有点怪哦!

public List findBoardsByParentID(long pid, int useStat, int hidden, int orderType) {
  List l = (List) this.getSysListObjCache().get(
    "[B][" + pid + "][" + useStat + "][" + hidden + "][" + orderType + "]");
  if (l == null) {
   // l = this.getBoardDAO().findBoardsByParentID(pid, useStat, hidden,
   // orderType);
   l = this.getBoardDAO().findBoardIdsByParentID(pid, useStat, hidden, orderType);
   this.getSysListObjCache().add("[B][" + pid + "][" + useStat + "][" + hidden + "][" + orderType + "]", l);
  }
  List<Board> bl = new ArrayList<Board>();
  if (l != null && !l.isEmpty()) {
   for (int i = 0; i < l.size(); i++) {
    // Board b = this.getBoardByID(((Long)l.get(i)).longValue());
    Board b = this.getBoardByID((Long) l.get(i));
    if (b != null) {
     bl.add(b);
    }
   }
  }
由于Cache中不一定是Borad对象了,由于add进的是list,便由List<Board>类型的bl重新加载一次为Board的List.findBoardInIDs根据IDs一个取一个,边放入到l中!
public List findBoardsInIDs(List ids) {
  List<Board> l = new ArrayList<Board>();
  if (ids != null && !ids.isEmpty()) {
   for (int i = 0; i < ids.size(); i++) {
    // Board b = this.getBoardByID(((Long) ids.get(i)).longValue());
    Board b = this.getBoardByID((Long) ids.get(i));
    if (b != null) {
     l.add(b);
    }
   }
  }
  return l;
}
  return bl;
}
与其相反的方法是:
public List getBoardIDs(List boards) {
  List<Long> l = new ArrayList<Long>();
  for (int i = 0; i < boards.size(); i++) {
   Board b = (Board) boards.get(i);
   l.add(b.getId());
  }
  return l;
}
注意以上都有this.getBoardByID(),它是带Cache的哦!从BoardCache中取!
public Board getBoardByID(long id) {
  Board board = (Board) this.getBoardCache().get(new Long(id));
  if (board == null) {
   board = this.getBoardDAO().getBoardByID(id);
   if (board != null) {
    this.getBoardCache().add(board.getId(), board);
   }
  }
  return board;
}
另外,对于Permission,有以下几个方法:
public Map[] getBoardMasterPermission(int roleID)
public Map[] getBoardPermission(long bid, int groupID)
private Map[] getPermissionMaps(long bid, int groupID)
private Map[] getPermissionMaps(int roleID)
前面2个是公开的方法,后2个是被调用的..
public Map[] getBoardMasterPermission(int roleID) {
  if (Constant.USE_PERMISSION_CACHE) {
   Map[] mapPermission = (Map[]) this.getUserPermissionCache().get("R_" + String.valueOf(roleID));
   if (mapPermission == null) {
    mapPermission = this.getPermissionMaps(roleID);
    this.getUserPermissionCache().add("R_" + String.valueOf(roleID), mapPermission);
   }
   return mapPermission;
  } else {
   return this.getPermissionMaps(roleID);
  }
}
private Map[] getPermissionMaps(int roleID) {
  Map[] mapPermission = { new HashMap(), new HashMap() }; //MAP数组,555

  Role role = this.getRoleDAO().findRoleByID(roleID);//得到id为roleID的角色对象
  List permissions = role.getPermissions(); // 取得角色的权限ID列表(ID的List)
  if (permissions != null && !permissions.isEmpty()) {
   List permissionList = this.getPermissionDAO().findPermissionnIDs(permissions); // 取得权限列表Permission对象的List
   for (int i = 0; i < permissionList.size(); i++) {
    Permission permission = (Permission) permissionList.get(i);
    if (permission.getTypeID() == 2) {
     mapPermission[0].put(permission.getResource() + "," + permission.getAction(), permission);
    }
    if (permission.getTypeID() == 3) {
     mapPermission[1].put(permission.getId(), permission);
    }  //这段需理解!!!
   }
  }
  return mapPermission;
}
另外,除了版主外,还有版区权限:
public Map[] getBoardPermission(long bid, int groupID) {
  if (Constant.USE_PERMISSION_CACHE) {
   Map[] mapPermission = (Map[]) this.getUserPermissionCache().get(
     "BG_" + String.valueOf(bid) + "_" + String.valueOf(groupID));
   if (mapPermission == null) {
    mapPermission = this.getPermissionMaps(bid, groupID);
    this.getUserPermissionCache().add("BG_" + String.valueOf(bid) + "_" + String.valueOf(groupID),
      mapPermission);
   }
   return mapPermission;
  } else {
   return this.getPermissionMaps(bid, groupID);
  }
}
同样,它用了类似的重载方法:
private Map[] getPermissionMaps(long bid, int groupID) {
  Map[] boardPermission = { new HashMap(), new HashMap() };
  BoardPermission bp = this.getBoardPermissionDAO().findBoardPermissionByBidGid(bid, groupID);//用的是BoardPermissionDAO
  List permissions = bp.getPermissions(); // 取得权限ID列表
  if (permissions != null && !permissions.isEmpty()) {
   List permissionList = this.getPermissionDAO().findPermissionnIDs(permissions); // 取得权限列表Permission对象的List
   for (int i = 0; i < permissionList.size(); i++) {
    Permission permission = (Permission) permissionList.get(i);
    if (permission.getTypeID() == 2) {
     boardPermission[0].put(permission.getResource() + "," + permission.getAction(), permission);
    }
    if (permission.getTypeID() == 3) {
     boardPermission[1].put(permission.getId(), permission);
    }
   }
  }
  return boardPermission;
}
接下来,看看getNextOrder(long pid),getPostSumNum(int mainorall,int usStat,int hidden),它们完全由DAO去查询数据库!我们看下remove系列:
public void removeBoard(Board board) throws BbscsException {
  try {
   Long lbid = board.getId();
   long pbid = board.getParentID();
   Board pboard = this.getBoardDAO().getBoardByID(board.getParentID()); // 取得父版区

   this.getBoardDAO().removeBoard(board); // 删除版区
   this.getBoardPermissionDAO().removeBoardPermissionsByBid(board.getId().longValue());//删除对应版区的权限

   if (pboard != null) { // 父版区存在,对ChildIDs字段做矫正
    List pcboards = this.getBoardDAO().findBoardsByParentID(pboard.getId().longValue(), 1, 0,
      Constant.FIND_BOARDS_BY_ORDER);//pcboards是子对象
    List cids = this.getBoardIDs(pcboards);//cids是子IDs
    pboard.setChildIDs(cids);
    this.getBoardDAO().saveBoard(pboard);
   }

   this.getBoardCache().remove(lbid);
   this.clearBoradListSysListCache(pbid);
//清理本id的BoardCache,清理父id的SysListObjectCache,而userPermission中出现过去2类:R_ BG_的..都不好清理!
  } catch (Exception ex) {
   logger.error(ex);
   throw new BbscsException(ex);
  }
}
public void removeBoardTag(Board board, String tagID) throws BbscsException {
  BoardTag bt = null;
  Iterator it = board.getBoardTag().iterator(); //由Iterator遍历查找,找到后remove掉
  while (it.hasNext()) {
   bt = (BoardTag) it.next();
   if (bt.getId().equals(tagID)) {
    board.getBoardTag().remove(bt);
    break;
   }
  }
  try {
   board = this.getBoardDAO().saveBoard(board); //保存修改结果
   this.getForumDAO().updateForumsTag(tagID, "0", "");//帖子TAG
   this.getForumHistoryDAO().updateForumsTag(tagID, "0", "");//历史贴TAG
   this.getBoardCache().remove(board.getId());//BoardCache清理一次
  } catch (Exception e) {
   logger.error(e);
   throw new BbscsException(e);
  }

}
最后再看两个方法:
public Board updateBoard(Board board, long oldParentID) throws BbscsException {
  try {
   Board pboard = this.getBoardDAO().getBoardByID(board.getParentID());

   if (pboard != null) {
    List pboards = new ArrayList();
    pboards.addAll(pboard.getParentIDs());
    pboards.add(pboard.getId());
    board.setParentIDs(pboards);
    board.setLevel(pboard.getLevel() + 1);
   } else {
    board.setParentIDs(new ArrayList());//hbm.xml决定需List对象
    board.setLevel(0);
   }
/**
数据库中的数据id /parentID/ParentIDs/ChildIDs
1/  0/     /2,3
2/  1/    1/
3/  1/    1/
*/
   board = this.getBoardDAO().saveBoard(board);

   if (pboard != null) {
    List pcboards = this.getBoardDAO().findBoardsByParentID(board.getParentID(), 1, -1,
      Constant.FIND_BOARDS_BY_ORDER);
    List cids = this.getBoardIDs(pcboards);
    pboard.setChildIDs(cids);
    this.getBoardDAO().saveBoard(pboard);
    this.getBoardCache().remove(pboard.getId());
   }
   this.clearBoradListSysListCache(board.getParentID());

   if (oldParentID != -1) { // 父级版区改变。修正父级版区数据 关键点,由传入的oldParentID决定是否改变ParentID
    Board pboardOld = this.getBoardDAO().getBoardByID(oldParentID);
    if (pboardOld != null) {
     List pcboards = this.getBoardDAO().findBoardsByParentID(pboardOld.getId().longValue(), 1, -1,
       Constant.FIND_BOARDS_BY_ORDER);
     List cids = this.getBoardIDs(pcboards);
     pboardOld.setChildIDs(cids);
     this.getBoardDAO().saveBoard(pboardOld);
     this.getBoardCache().remove(pboardOld.getId());
     this.clearBoradListSysListCache(oldParentID);
    }
   }
   this.getBoardCache().remove(board.getId()); // 从Cache中清除

   return board;
  } catch (Exception ex) {
   logger.error(ex);
   throw new BbscsException(ex);
  }
}
最后一个方法了:
public void saveBoardsPostNumCount() throws BbscsException {
  long totalNum = 0;
  long totalMainNum = 0;
  List bl = findBoardsByParentID(0, 1, -1, Constant.FIND_BOARDS_BY_ORDER);//从0继承的版区有显示主题数和贴子数的需求
  for (int i = 0; i < bl.size(); i++) {
   Board b = (Board) bl.get(i);
   if (b.getBoardType() == 3) { //可发贴的版区吧!
    b.setMainPostNum(this.getForumDAO().getForumNum(b.getId(), 1, 0, 0, -1)
      + this.getForumHistoryDAO().getForumNum(b.getId(), 1, 0, 0, -1));
    b.setPostNum(this.getForumDAO().getForumNum(b.getId(), -1, 0, 0, -1)
      + this.getForumHistoryDAO().getForumNum(b.getId(), -1, 0, 0, -1));
//isNew=-1表示非主题贴,而1则相反!
    try {
     b = this.getBoardDAO().saveBoard(b);
     totalNum = totalNum + b.getPostNum();
     totalMainNum = totalMainNum + b.getMainPostNum();
     // if (Constant.USE_CLUSTER) {
     this.getBoardCache().remove(b.getId()); // 从Cache中清除
     // } else {
     // this.getBoardCache().add(b.getId(), b);
     // }
    } catch (Exception ex1) {
     logger.error(ex1);
     throw new BbscsException(ex1);
    }
   }
   List bl2 = findBoardsByParentID(b.getId(), 1, -1, Constant.FIND_BOARDS_BY_ORDER); //子论坛的更新
   if (!bl2.isEmpty()) {
    for (int j = 0; j < bl2.size(); j++) {
     Board b2 = (Board) bl2.get(j);
     if (b2.getBoardType() == 3) {
      b2.setMainPostNum(this.getForumDAO().getForumNum(b2.getId(), 1, 0, 0, -1)
        + this.getForumHistoryDAO().getForumNum(b2.getId(), 1, 0, 0, -1));
      b2.setPostNum(this.getForumDAO().getForumNum(b2.getId(), -1, 0, 0, -1)
        + this.getForumHistoryDAO().getForumNum(b2.getId(), -1, 0, 0, -1));
      try {
       b2 = this.getBoardDAO().saveBoard(b2);
       totalNum = totalNum + b2.getPostNum();
       totalMainNum = totalMainNum + b2.getMainPostNum();
       // if (Constant.USE_CLUSTER) {
       this.getBoardCache().remove(b2.getId()); // 从Cache中清除
       // } else {
       // this.getBoardCache().add(b2.getId(), b2);
       // }
      } catch (Exception ex1) {
       logger.error(ex1);
       throw new BbscsException(ex1);
      }
     }
    }
   }
  }
  logger.info("postMainNum:" + totalMainNum + " postNum:" + totalNum);//打印
  this.getSysStatService().savePostNum(totalMainNum, totalNum);//SysStatService服务终于用上了!
}
OK!我们直接进入DAO层:先看接口,发现与service接口层的方法并不相同,主要是由于service层有些方法是业务处理用,而不是用于数据处理,如createBoard,updateBoard,findBoardsAllTree,getBoardPermission,getBoardMasterPermission,isBoardMaster,当然DAO接口层也有一些方法是没有的:findBoardsNeedCount,findBoardsInIDsfindBoardsIdByParentIDInUse等等,我们看其实现吧:
进入com.laoer.bbscs.BoardHibernateDAO中首先是一些字符常量:
private static final String LOADS_BY_PARENTID_BY_ORDER = "from Board where parentID = ? order by orders";
private static final String LOADS_ALL = "from Board";
public static final String[] FIND_BOARDS = new String[3];
public static final String LOAD_NEXT_ORDER = "select max(orders) from Board where parentID = ?";
private static final String LOAD_IDS_IN_USE = "select id from Board where parentID = ? and useStat = 1";
我们看几个重点的实现方法:
public List findBoardsByParentID(long pid) {
  return this.getHibernateTemplate().find(LOADS_BY_PARENTID_BY_ORDER, new Long(pid));
}
其重载方法:
public List findBoardsByParentID(final long pid, final int useStat, final int hidden, final int orderType) {
  return getHibernateTemplate().executeFind(new HibernateCallback() {
   public Object doInHibernate(Session s) throws HibernateException {
    Criteria c = s.createCriteria(Board.class);
    c.add(Restrictions.eq("parentID", new Long(pid)));
    if (useStat != -1) {
     c.add(Restrictions.eq("useStat", new Integer(useStat)));
    }
    if (hidden != -1) {
     c.add(Restrictions.eq("isHidden", new Integer(hidden)));
    }
    if (orderType != -1) {
     if (orderType == Constant.FIND_BOARDS_BY_ORDER) {
      c.addOrder(Order.asc("orders"));
     }
     if (orderType == Constant.FIND_BOARDS_BY_MAINPOSTNUM) {
      c.addOrder(Order.desc("mainPostNum"));
     }
     if (orderType == Constant.FIND_BOARDS_BY_POSTNUM) {
      c.addOrder(Order.desc("postNum"));
     }
    }

    return c.list();
   }
  });
}
其中用到了条件查询(Criteria Query),参考http://blog.sina.com.cn/u/4a5e7dc401000878  和http://hi.baidu.com/yaolihui/blog/item/7c77b58286a56792f703a663.html,而public List findBoardIdsByParentID(final long pid, final int useStat, final int hidden, final int orderType)采用了构造HQL语句的方式来完成查询!根据parentID预取得Board序列:
public int getNextOrder(long pid) {
  List l = getHibernateTemplate().find(LOAD_NEXT_ORDER, new Long(pid));
  if (l != null && !l.isEmpty()) {
   if (l.get(0) == null) {
    return 5;
   } else {
    return ((Integer) l.get(0)).intValue() + 5;
   }
  } else {
   return 5;
  }
}
public int getPostSumNum(final int mainorall, final int useStat, final int hidden) {
  int sum = 0;

  List list = getHibernateTemplate().executeFind(new HibernateCallback() {
   public Object doInHibernate(Session s) throws HibernateException {
    Criteria c = s.createCriteria(Board.class);
    if (mainorall == 0) {
     c.setProjection(Projections.projectionList().add(Projections.sum("mainPostNum")));  //求mainPostNum的和为结果
    }
    if (mainorall == 1) {
     c.setProjection(Projections.projectionList().add(Projections.sum("postNum")));//求postNum的和为结果
    }
    if (useStat != -1) {
     c.add(Restrictions.eq("useStat", new Integer(useStat)));
    }
    if (hidden != -1) {
     c.add(Restrictions.eq("isHidden", new Integer(hidden)));
    }
    return c.list();
   }
  });
  if (!list.isEmpty()) {
   Object obj = (Object) list.get(0);//注:结果集只有一个字段
   if (obj != null) {
    sum = ((Integer) obj).intValue();
   }
  }
  return sum;
}

public List findBoardsInIDs(final List ids, final int useStat, final int hidden) {
  return getHibernateTemplate().executeFind(new HibernateCallback() {
   @SuppressWarnings("unchecked")
   public Object doInHibernate(Session s) throws HibernateException {
    Criteria c = s.createCriteria(Board.class);
    if (ids == null) {  //ids为空
     List idss = new ArrayList();
     idss.add(new Long(0));
     c.add(Restrictions.in("id", idss));
    } else if (ids.isEmpty()) {//ids为empty
     ids.add(new Long(0));
     c.add(Restrictions.in("id", ids));
    } else {
     c.add(Restrictions.in("id", ids));//Restrictions.in
    }
    if (useStat != -1) {
     c.add(Restrictions.eq("useStat", new Integer(useStat)));
    }
    if (hidden != -1) {
     c.add(Restrictions.eq("isHidden", new Integer(hidden)));
    }
    c.addOrder(Order.asc("orders"));
    return c.list();
   }
  });
}

public List findBoardsNeedCount(final int useStat, final int hidden) {
  return getHibernateTemplate().executeFind(new HibernateCallback() {
   public Object doInHibernate(Session s) throws HibernateException {
    Criteria c = s.createCriteria(Board.class);

    c.add(Restrictions.or(Restrictions.eq("boardType", new Integer(3)), Restrictions.eq("boardType",
      new Integer(4))));//Restrictions.or 3,4的都需要count

    if (useStat != -1) {
     c.add(Restrictions.eq("useStat", new Integer(useStat)));
    }
    if (hidden != -1) {
     c.add(Restrictions.eq("isHidden", new Integer(hidden)));
    }
    c.addOrder(Order.desc("mainPostNum"));
    c.addOrder(Order.desc("postNum"));
    return c.list();
   }
  });
}

public List findBoardsByParentID(final long pid, final int useStat, final int hidden) {
  return getHibernateTemplate().executeFind(new HibernateCallback() {
   public Object doInHibernate(Session s) throws HibernateException {
    Criteria c = s.createCriteria(Board.class);
    c.add(Restrictions.eq("parentID", new Long(pid)));//条件!
    if (useStat != -1) {
     c.add(Restrictions.eq("useStat", new Integer(useStat)));//附加条件!
    }
    if (hidden != -1) {
     c.add(Restrictions.eq("isHidden", new Integer(hidden)));
    }
    return c.list();
   }
  });
}

public List findBoardsIdByParentIDInUse(long pid) {
  return this.getHibernateTemplate().find(LOAD_IDS_IN_USE, new Long(pid));
}
OK!分析完毕!当然,对于具体的方法是怎么被用上的,要看web层了.
接下来,看下BookMarkFactory接口,是个工厂接口.它只有一个一个公有方法, public BookMark getInstance(String userId);其实现为BookMarkFactoryImp,它产生一个BookMark bean,不过是同步的! public synchronized BookMark getInstance(String userId) {
    return new BookMark();//返回的是com.laoer.bbscs.bean.BookMark
  }
另有一个实现:BookMarksFactoryImp:(有个私有属性:int modNum及其get/set方法)
public synchronized BookMark getInstance(String userId) {
    try {
      return (BookMark) Class.forName(BBSCSUtil.getClassName("BookMark", userId, this.getModNum())).
          newInstance();
    }
    catch (ClassNotFoundException ex) {
      logger.error(ex);
      return null;
    }
    catch (IllegalAccessException ex) {
      logger.error(ex);
      return null;
    }
    catch (InstantiationException ex) {
      logger.error(ex);
      return null;
    }

  }
这里用到了com.laoer.bbscs.common包中的工具类:BBSCSUtil.java
public static String getClassName(String className, String userID) {
  int num = Math.abs(userID.hashCode());
  className = Constant.BEANPERFIX + className + (num % 10);//public static String BEANPERFIX = "com.laoer.bbscs.bean.";
  return className;
}

public static String getClassName(String className, String userID, int modnum) {
  int num = Math.abs(userID.hashCode());
  className = Constant.BEANPERFIX + className + (num % modnum);
  return className; //应该返回是就是com.laoer.bbscs.bean.BookMark0~~~9之间的class了
}

public static String getClassName(String className, long bid, int modnum) {
  className = Constant.BEANPERFIX + className + (bid % modnum);
  return className;
}

而BookMarkService则完全负责这个业务!先看BEAN:
private String id;
private String userID;
private String bookMarkName;
private String url;
private String alt;
private int isShare;
private Date createTime;
<hibernate-mapping package="com.laoer.bbscs.bean">
  <class name="BookMark" table="bbscs_bookmark">
    <id name="id" column="ID" type="string" unsaved-value="null">
      <generator class="uuid"/>
    </id>
    <property column="UserID" length="40" name="userID" not-null="true" type="string"/>
    <property column="BookMarkName" length="255" name="bookMarkName" not-null="true" type="string"/>
    <property column="Url" length="255" name="url" type="string"/>
    <property column="Alt" length="255" name="alt" type="string"/>
    <property column="IsShare" length="1" name="isShare" type="int"/>
    <property column="CreateTime" name="createTime" not-null="true" type="timestamp"/>//timestamp类型!
  </class>
</hibernate-mapping>
看service接口中的方法:
public BookMark findBookMarkByIDUserID(String id, String userID);
public BookMark saveBookMark(BookMark bm) throws BbscsException;
  public long getBookMarkNumByUserID(String userID);
public PageList findBookMarks(String userID, Pages pages);
public PageList findBookMarksByUserIDShare(String userID, int isShare, Pages pages);
public void removeBookMark(BookMark bm) throws BbscsException;
public void removeBookMarkByIDUserID(String id, String userID) throws BbscsException;
我们看实现层:先注入BookMarkDAO对象.特别的是:
public PageList findBookMarks(String userID, Pages pages) {
    PageList pl = new PageList();
    if (pages.getTotalNum() == -1) {
      pages.setTotalNum(this.getBookMarkDAO().getBookMarkNumByUserID(userID));
    }
    pages.executeCount();

    List l = this.getBookMarkDAO().findBookMarks(userID, pages.getSpage(), pages.getPerPageNum()); //DAO层方法,Service层没有
    pl.setObjectList(l);
    pl.setPages(pages);
    return pl;
  }

  public PageList findBookMarksByUserIDShare(String userID, int isShare, Pages pages) {
    PageList pl = new PageList();
    if (pages.getTotalNum() == -1) {
      pages.setTotalNum(this.getBookMarkDAO().getBookMarkNumByUserIDShare(userID, isShare));
    }
    pages.executeCount();

    List l = this.getBookMarkDAO().findBookMarksByUserIDShare(userID, isShare, pages.getSpage(),
        pages.getPerPageNum());//DAO层方法,Service层没有
    pl.setObjectList(l);
    pl.setPages(pages);
    return pl;
  }
这里用到了2个分页功能的类:它们都在com.laoer.bbscs.service.web包中,一个Page一个PageList;
两个都是javaBEAN,不过可以带少量的业务逻辑处理功能.先看Pages:
int page=1;//页号
long totalNum=-1;//记录总数
int perPageNum=1;//每页显示记录数
int allPage=1;//总页数
int cpage=1;//当前页
int spage=1;//开始记录数
String fileName="";
boolean useUrlRewirte=false;
public Pages(int page, long totalNum, int perPageNum) {
  this.page = page;
  this.totalNum = totalNum;
  this.perPageNum = perPageNum;
  this.executeCount();
}

public void executeCount() {
  this.allPage = (int) Math.ceil((this.totalNum + this.perPageNum - 1) / this.perPageNum);
  int intPage = this.page;
  if (intPage > this.allPage) { // pages == 0
   this.cpage = 1;
  } else {
   this.cpage = intPage;
  }
  this.spage = (this.cpage - 1) * this.perPageNum;
}
而PageList包括一个pages和List类型的objectList 及其set/get方法

  public PageList() {
  }
我们回到findBookMarks,先得到totalNum,再执行executeCount(),设置其值后,用this.getBookMarkDAO().findBookMark(userID,pages.getspage,pages.getPerPageNum())得到后赋给PageList的objectList和page对象.这样,就可以给web层用List去遍历了,当然也要配合page.
我们直接进入DAO接口层:(其实它完全为service层服务,整体上差不多不过有些方法却不一样)
public BookMark saveBookMark(BookMark bm);
public BookMark findBookMarkByIDUserID(String id,String userID);
public long getBookMarkNumByUserID(String userID);
public List findBookMark(final String userID,final int firstResult,final int maxResults);
public long getBookMarkNumByUserIDShare(String userID, int isShare);
public List findBookMarksByUserIDShare(final String userID, final int isShare, final int firstResult,final int maxResults);//final int类型,方法体里不可改变
public void removeBookMark(BookMark bm);
public void removeBookMarkByIDUserID(String id, String userID);
看它的实现BookMarkHibernateDAO.java:(private static final String类型)
private static final String LOAD_BY_ID_USERID = "from BookMark where id = ? and userID = ?";
  private static final String GET_NUM_BY_USERID = "select count(*) from BookMark where userID = ?";
  private static final String LOADS_BY_USERID =
      "from BookMark where userID = ? order by createTime desc";
  private static final String REMOVE_BY_ID_USERID =
      "delete from BookMark where id = ? and userID = ?";
  private static final String GET_NUM_BY_USERID_ISSHARE =
      "select count(*) from BookMark where userID = ? and isShare = ?";
  private static final String LOADS_BY_USERID_ISSHARE =
      "from BookMark where userID = ? and isShare = ? order by createTime desc";
我们看其中的一些方法(根据UserID取得BookMark数量)
public long getBookMarkNumByUserID(String userID) {
    List l = this.getHibernateTemplate().find(GET_NUM_BY_USERID, userID);
    if (l == null || l.isEmpty()) {
      return 0;
    }
    else {
      return ( (Long) l.get(0)).longValue();
    }
  }
另外一个方法:(根据UserID和isShare取得BookMark列表)
  public List findBookMarksByUserIDShare(final String userID, final int isShare,
                      

转载于:https://my.oschina.net/iqoFil/blog/221576

  • 0
    点赞
  • 0
    评论
  • 0
    收藏
  • 扫一扫,分享海报

参与评论 您还未登录,请先 登录 后发表或查看评论
©️2022 CSDN 皮肤主题:编程工作室 设计师:CSDN官方博客 返回首页
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值