Question

JSP+MySql+BBS问题

这是根据分页大小和页数读取留言列表功能的getAllMessages
数据库连接代码如下：
String sql = "select bbsitems.*,bbsitems1.ITEM_ID ITEM_ID1,bbsitems1.AUTHOR REPLYER,"
+ "bbsitems1.COMPOSE_DATE REPLYED_LATEST_DATE from bbsitems "
+ "inner join bbsitems bbsitems1 on bbsitems.ITEM_ID="
+ "bbsitems1.FATHERS_ID and bbsitems.LATEST_REPLICATION_ID="
+ "bbsitems1.ITEM_ID where bbsitems.IS_ORIGIONAL = 1 "
+ "order by ITEM_ID desc limit "
+ (page - 1)
* pagesiz+ ","
+ pagesize;
请问这段，表的自身连接有什么问题么？如果问题解决多加分数~~~~

Answer 1

好象没有