https://forum.andowson.com/posts/list/7.page JForum - http://www.jforum.net 使用方式：
1.下載[url=http://www.jforum.net/download_file.jsp?type=zip]jforum-2.1.8.zip[/url]或[url=http://www.jforum.net/download_file.jsp?type=src]jforum-2.1.8-src.zip[/url]，並解壓縮到Tomcat的webapps目錄下，重新命名為jforum
2.下載附加檔案後，解開到JForum安裝的目錄下，會覆蓋掉原來的install.htm並新增sqlserver2000相關目錄及JDBC Driver jtds-1.2.2.jar等。
3.附加檔案內的class是以Java 5.0編譯而成，如果需要可自行重新編譯
4.在SQL Server 2000上建立jforum資料庫，可透過Enterprise Manager執行下列動作：
4.1. 資料庫=>新增資料庫=>名稱：jforum
4.2. 安全性=>登入=>新增登入=>
[一般]
名稱：jforum
SQL Server的帳戶驗證
密碼：jforum
資料庫：jforum
[伺服器角色]
Database Creators
[資料庫存取]
請指定此登入者可存取的資料庫
jforum
'jforum'的資料庫角色
db_owner
確定=>確認密碼：jforum=>確定
5.連到http://your_server_name/jforum/install.jsp，資料庫選擇SQL Server 2000，其他依照畫面操作即可。]]> https://forum.andowson.com/posts/preList/195/298.page https://forum.andowson.com/posts/preList/195/298.page GMT https://forum.andowson.com/posts/preList/195/568.page https://forum.andowson.com/posts/preList/195/568.page GMT http://www.andowson.com/posts/list/27.page]]> https://forum.andowson.com/posts/preList/195/569.page https://forum.andowson.com/posts/preList/195/569.page GMT UserModel.selectAllByGroup

getTotalUsersByGroup() 这两个要重写吧?不知斑竹做了没有?]]> https://forum.andowson.com/posts/preList/195/696.page https://forum.andowson.com/posts/preList/195/696.page GMT [code=sql]UserModel.selectAllByGroup = SELECT TOP %d \
user_email, u.user_id, user_posts, user_regdate, username, deleted, user_karma, user_from, \
user_website, user_viewemail \
FROM jforum_users u, jforum_user_groups ug \
WHERE u.user_id = ug.user_id \
AND ug.group_id = ?[/code]

[code=java] /**
* @see net.jforum.dao.UserDAO#selectAllByGroup(int, int, int)
*/
public List selectAllByGroup(int groupId, int startFrom, int count)
{
String sql = SystemGlobals.getSql("UserModel.selectAllByGroup");
sql = sql.replaceAll("%d", String.valueOf(startFrom + count));

PreparedStatement p = null;
ResultSet rs = null;
try {
p = JForumExecutionContext.getConnection().prepareStatement(sql);
p.setInt(1, groupId);

rs = p.executeQuery();

return this.processSelectAll(rs);
}
catch (SQLException e) {
throw new DatabaseException(e);
}
finally {
DbUtils.close(rs, p);
}
}[/code]]]> https://forum.andowson.com/posts/preList/195/697.page https://forum.andowson.com/posts/preList/195/697.page GMT https://forum.andowson.com/posts/preList/195/699.page https://forum.andowson.com/posts/preList/195/699.page GMT