Java Doc for AnsiQueryHandler.java in  » Wiki-Engine » JAMWiki » org » jamwiki » db » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Wiki Engine » JAMWiki » org.jamwiki.db   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.jamwiki.db.AnsiQueryHandler All known Subclasses:   org.jamwiki.db.MySqlQueryHandler,  org.jamwiki.db.PostgresQueryHandler,  org.jamwiki.db.MSSqlQueryHandler,  org.jamwiki.db.SybaseASAQueryHandler,  org.jamwiki.db.DB2400QueryHandler,  org.jamwiki.db.OracleQueryHandler,  org.jamwiki.db.HSqlQueryHandler,  org.jamwiki.db.DB2QueryHandler, AnsiQueryHandler public class AnsiQueryHandler implements QueryHandler(Code) Default implementation of the QueryHandler implementation for retrieving, inserting, and updating data in the database. This method uses ANSI SQL and should therefore work with any fully ANSI-compliant database. Field Summary final protected static  String SQL_PROPERTY_FILE_NAME      protected static  String STATEMENT_CONNECTION_VALIDATION_QUERY      protected static  String STATEMENT_CREATE_CATEGORY_TABLE      protected static  String STATEMENT_CREATE_GROUP_TABLE      protected static  String STATEMENT_CREATE_RECENT_CHANGE_TABLE      protected static  String STATEMENT_CREATE_ROLE_MAP_TABLE      protected static  String STATEMENT_CREATE_ROLE_TABLE      protected static  String STATEMENT_CREATE_TOPIC_CURRENT_VERSION_CONSTRAINT      protected static  String STATEMENT_CREATE_TOPIC_TABLE      protected static  String STATEMENT_CREATE_TOPIC_VERSION_TABLE      protected static  String STATEMENT_CREATE_VIRTUAL_WIKI_TABLE      protected static  String STATEMENT_CREATE_WATCHLIST_TABLE      protected static  String STATEMENT_CREATE_WIKI_FILE_TABLE      protected static  String STATEMENT_CREATE_WIKI_FILE_VERSION_TABLE      protected static  String STATEMENT_CREATE_WIKI_USER_INFO_TABLE      protected static  String STATEMENT_CREATE_WIKI_USER_LOGIN_INDEX      protected static  String STATEMENT_CREATE_WIKI_USER_TABLE      protected static  String STATEMENT_DELETE_RECENT_CHANGES      protected static  String STATEMENT_DELETE_RECENT_CHANGES_TOPIC      protected static  String STATEMENT_DELETE_ROLE_MAP_GROUP      protected static  String STATEMENT_DELETE_ROLE_MAP_USER      protected static  String STATEMENT_DELETE_TOPIC_CATEGORIES      protected static  String STATEMENT_DELETE_WATCHLIST_ENTRY      protected static  String STATEMENT_DROP_CATEGORY_TABLE      protected static  String STATEMENT_DROP_GROUP_TABLE      protected static  String STATEMENT_DROP_RECENT_CHANGE_TABLE      protected static  String STATEMENT_DROP_ROLE_MAP_TABLE      protected static  String STATEMENT_DROP_ROLE_TABLE      protected static  String STATEMENT_DROP_TOPIC_CURRENT_VERSION_CONSTRAINT      protected static  String STATEMENT_DROP_TOPIC_TABLE      protected static  String STATEMENT_DROP_TOPIC_VERSION_TABLE      protected static  String STATEMENT_DROP_VIRTUAL_WIKI_TABLE      protected static  String STATEMENT_DROP_WATCHLIST_TABLE      protected static  String STATEMENT_DROP_WIKI_FILE_TABLE      protected static  String STATEMENT_DROP_WIKI_FILE_VERSION_TABLE      protected static  String STATEMENT_DROP_WIKI_USER_INFO_TABLE      protected static  String STATEMENT_DROP_WIKI_USER_LOGIN_INDEX      protected static  String STATEMENT_DROP_WIKI_USER_TABLE      protected static  String STATEMENT_INSERT_CATEGORY      protected static  String STATEMENT_INSERT_GROUP      protected static  String STATEMENT_INSERT_RECENT_CHANGE      protected static  String STATEMENT_INSERT_RECENT_CHANGES      protected static  String STATEMENT_INSERT_ROLE      protected static  String STATEMENT_INSERT_ROLE_MAP      protected static  String STATEMENT_INSERT_TOPIC      protected static  String STATEMENT_INSERT_TOPIC_VERSION      protected static  String STATEMENT_INSERT_VIRTUAL_WIKI      protected static  String STATEMENT_INSERT_WATCHLIST_ENTRY      protected static  String STATEMENT_INSERT_WIKI_FILE      protected static  String STATEMENT_INSERT_WIKI_FILE_VERSION      protected static  String STATEMENT_INSERT_WIKI_USER      protected static  String STATEMENT_INSERT_WIKI_USER_INFO      protected static  String STATEMENT_SELECT_CATEGORIES      protected static  String STATEMENT_SELECT_CATEGORY_TOPICS      protected static  String STATEMENT_SELECT_GROUP_SEQUENCE      protected static  String STATEMENT_SELECT_RECENT_CHANGES      protected static  String STATEMENT_SELECT_RECENT_CHANGES_TOPIC      protected static  String STATEMENT_SELECT_ROLES      protected static  String STATEMENT_SELECT_ROLE_MAP_GROUP      protected static  String STATEMENT_SELECT_ROLE_MAP_GROUPS      protected static  String STATEMENT_SELECT_ROLE_MAP_LOGIN      protected static  String STATEMENT_SELECT_ROLE_MAP_ROLE      protected static  String STATEMENT_SELECT_ROLE_MAP_USER      protected static  String STATEMENT_SELECT_TOPIC      protected static  String STATEMENT_SELECT_TOPICS      protected static  String STATEMENT_SELECT_TOPICS_ADMIN      protected static  String STATEMENT_SELECT_TOPIC_BY_TYPE      protected static  String STATEMENT_SELECT_TOPIC_COUNT      protected static  String STATEMENT_SELECT_TOPIC_LOWER      protected static  String STATEMENT_SELECT_TOPIC_SEQUENCE      protected static  String STATEMENT_SELECT_TOPIC_VERSION      protected static  String STATEMENT_SELECT_TOPIC_VERSION_SEQUENCE      protected static  String STATEMENT_SELECT_VIRTUAL_WIKIS      protected static  String STATEMENT_SELECT_VIRTUAL_WIKI_SEQUENCE      protected static  String STATEMENT_SELECT_WATCHLIST      protected static  String STATEMENT_SELECT_WATCHLIST_CHANGES      protected static  String STATEMENT_SELECT_WIKI_FILE      protected static  String STATEMENT_SELECT_WIKI_FILE_COUNT      protected static  String STATEMENT_SELECT_WIKI_FILE_SEQUENCE      protected static  String STATEMENT_SELECT_WIKI_FILE_VERSIONS      protected static  String STATEMENT_SELECT_WIKI_FILE_VERSION_SEQUENCE      protected static  String STATEMENT_SELECT_WIKI_USER      protected static  String STATEMENT_SELECT_WIKI_USERS      protected static  String STATEMENT_SELECT_WIKI_USER_CHANGES_ANONYMOUS      protected static  String STATEMENT_SELECT_WIKI_USER_CHANGES_LOGIN      protected static  String STATEMENT_SELECT_WIKI_USER_COUNT      protected static  String STATEMENT_SELECT_WIKI_USER_INFO      protected static  String STATEMENT_SELECT_WIKI_USER_LOGIN      protected static  String STATEMENT_SELECT_WIKI_USER_PASSWORD      protected static  String STATEMENT_SELECT_WIKI_USER_SEQUENCE      protected static  String STATEMENT_UPDATE_GROUP      protected static  String STATEMENT_UPDATE_ROLE      protected static  String STATEMENT_UPDATE_TOPIC      protected static  String STATEMENT_UPDATE_TOPIC_CURRENT_VERSION      protected static  String STATEMENT_UPDATE_TOPIC_CURRENT_VERSIONS      protected static  String STATEMENT_UPDATE_VIRTUAL_WIKI      protected static  String STATEMENT_UPDATE_WIKI_FILE      protected static  String STATEMENT_UPDATE_WIKI_USER      protected static  String STATEMENT_UPDATE_WIKI_USER_INFO      Constructor Summary protected   AnsiQueryHandler()      Method Summary public  String connectionValidationQuery()      public  void createTables(Connection conn)      public  void deleteRecentChanges(int topicId, Connection conn)      public  void deleteRoleMapGroup(int groupId, Connection conn)      public  void deleteRoleMapUser(int userId, Connection conn)      public  void deleteTopicCategories(int childTopicId, Connection conn)      public  void deleteWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn)      public  void dropTables(Connection conn)      public  String existenceValidationQuery()      Return a simple query, that if successfully run indicates that JAMWiki tables have been initialized in the database. public  WikiResultSet getAllTopicNames(int virtualWikiId)      public  WikiResultSet getAllWikiFileVersions(WikiFile wikiFile, boolean descending)      public  WikiResultSet getCategories(int virtualWikiId, Pagination pagination)      public  WikiResultSet getRecentChanges(String virtualWiki, Pagination pagination, boolean descending)      public  WikiResultSet getRecentChanges(int topicId, Pagination pagination, boolean descending)      public  WikiResultSet getRoleMapByLogin(String loginFragment)      public  WikiResultSet getRoleMapByRole(String roleName)      public  WikiResultSet getRoleMapGroup(String groupName)      public  WikiResultSet getRoleMapGroups()      public  WikiResultSet getRoleMapUser(String login)      public  WikiResultSet getRoles()      public  WikiResultSet getTopicsAdmin(int virtualWikiId, Pagination pagination)      public  WikiResultSet getUserContributions(String virtualWiki, String userString, Pagination pagination, boolean descending)      public  WikiResultSet getVirtualWikis(Connection conn)      public  WikiResultSet getWatchlist(int virtualWikiId, int userId)      public  WikiResultSet getWatchlist(int virtualWikiId, int userId, Pagination pagination)      protected  void init(Properties props)      public  void insertCategory(Category category, int virtualWikiId, Connection conn)      public  void insertRecentChange(RecentChange change, int virtualWikiId, Connection conn)      public  void insertRole(Role role, Connection conn)      public  void insertRoleMap(int userId, int groupId, String role, Connection conn)      public  void insertTopic(Topic topic, int virtualWikiId, Connection conn)      public  void insertTopicVersion(TopicVersion topicVersion, Connection conn)      public  void insertVirtualWiki(VirtualWiki virtualWiki, Connection conn)      public  void insertWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn)      public  void insertWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn)      public  void insertWikiFileVersion(WikiFileVersion wikiFileVersion, Connection conn)      public  void insertWikiGroup(WikiGroup group, Connection conn)      public  void insertWikiUser(WikiUser user, Connection conn)      public  void insertWikiUserInfo(WikiUserInfo userInfo, Connection conn)      public  WikiResultSet lookupCategoryTopics(int virtualWikiId, String categoryName)      public  WikiResultSet lookupTopic(int virtualWikiId, String topicName, boolean caseSensitive, Connection conn)      public  WikiResultSet lookupTopicByType(int virtualWikiId, int topicType, Pagination pagination)      public  WikiResultSet lookupTopicCount(int virtualWikiId)      Return a count of all topics, including redirects, comments pages and templates, currently available on the Wiki. public  WikiResultSet lookupTopicVersion(int topicVersionId, Connection conn)      public  WikiResultSet lookupWikiFile(int virtualWikiId, int topicId)      public  WikiResultSet lookupWikiFileCount(int virtualWikiId)      Return a count of all wiki files currently available on the Wiki. public  WikiResultSet lookupWikiUser(int userId, Connection conn)      public  WikiResultSet lookupWikiUser(String username, Connection conn)      public  WikiResultSet lookupWikiUser(String username, String encryptedPassword, Connection conn)      public  WikiResultSet lookupWikiUserCount()      Return a count of all wiki users. public  WikiResultSet lookupWikiUserInfo(String username)      public  WikiResultSet lookupWikiUsers(Pagination pagination)      public  int nextTopicId(Connection conn)      public  int nextTopicVersionId(Connection conn)      public  int nextVirtualWikiId(Connection conn)      public  int nextWikiFileId(Connection conn)      public  int nextWikiFileVersionId(Connection conn)      public  int nextWikiGroupId(Connection conn)      public  int nextWikiUserId(Connection conn)      public  void reloadRecentChanges(Connection conn)      public  void updateRole(Role role, Connection conn)      public  void updateTopic(Topic topic, int virtualWikiId, Connection conn)      public  void updateVirtualWiki(VirtualWiki virtualWiki, Connection conn)      public  void updateWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn)      public  void updateWikiGroup(WikiGroup group, Connection conn)      public  void updateWikiUser(WikiUser user, Connection conn)      public  void updateWikiUserInfo(WikiUserInfo userInfo, Connection conn)      protected  void validateCategory(Category category)      protected  void validateRecentChange(RecentChange change)      protected  void validateRole(Role role)      protected  void validateRoleMap(String role)      protected  void validateTopic(Topic topic)      protected  void validateTopicVersion(TopicVersion topicVersion)      protected  void validateVirtualWiki(VirtualWiki virtualWiki)      protected  void validateWatchlistEntry(String topicName)      protected  void validateWikiFile(WikiFile wikiFile)      protected  void validateWikiFileVersion(WikiFileVersion wikiFileVersion)      protected  void validateWikiGroup(WikiGroup group)      protected  void validateWikiUser(WikiUser user)      protected  void validateWikiUserInfo(WikiUserInfo userInfo)      Field Detail SQL_PROPERTY_FILE_NAME final protected static String SQL_PROPERTY_FILE_NAME(Code) STATEMENT_CONNECTION_VALIDATION_QUERY protected static String STATEMENT_CONNECTION_VALIDATION_QUERY(Code) STATEMENT_CREATE_CATEGORY_TABLE protected static String STATEMENT_CREATE_CATEGORY_TABLE(Code) STATEMENT_CREATE_GROUP_TABLE protected static String STATEMENT_CREATE_GROUP_TABLE(Code) STATEMENT_CREATE_RECENT_CHANGE_TABLE protected static String STATEMENT_CREATE_RECENT_CHANGE_TABLE(Code) STATEMENT_CREATE_ROLE_MAP_TABLE protected static String STATEMENT_CREATE_ROLE_MAP_TABLE(Code) STATEMENT_CREATE_ROLE_TABLE protected static String STATEMENT_CREATE_ROLE_TABLE(Code) STATEMENT_CREATE_TOPIC_CURRENT_VERSION_CONSTRAINT protected static String STATEMENT_CREATE_TOPIC_CURRENT_VERSION_CONSTRAINT(Code) STATEMENT_CREATE_TOPIC_TABLE protected static String STATEMENT_CREATE_TOPIC_TABLE(Code) STATEMENT_CREATE_TOPIC_VERSION_TABLE protected static String STATEMENT_CREATE_TOPIC_VERSION_TABLE(Code) STATEMENT_CREATE_VIRTUAL_WIKI_TABLE protected static String STATEMENT_CREATE_VIRTUAL_WIKI_TABLE(Code) STATEMENT_CREATE_WATCHLIST_TABLE protected static String STATEMENT_CREATE_WATCHLIST_TABLE(Code) STATEMENT_CREATE_WIKI_FILE_TABLE protected static String STATEMENT_CREATE_WIKI_FILE_TABLE(Code) STATEMENT_CREATE_WIKI_FILE_VERSION_TABLE protected static String STATEMENT_CREATE_WIKI_FILE_VERSION_TABLE(Code) STATEMENT_CREATE_WIKI_USER_INFO_TABLE protected static String STATEMENT_CREATE_WIKI_USER_INFO_TABLE(Code) STATEMENT_CREATE_WIKI_USER_LOGIN_INDEX protected static String STATEMENT_CREATE_WIKI_USER_LOGIN_INDEX(Code) STATEMENT_CREATE_WIKI_USER_TABLE protected static String STATEMENT_CREATE_WIKI_USER_TABLE(Code) STATEMENT_DELETE_RECENT_CHANGES protected static String STATEMENT_DELETE_RECENT_CHANGES(Code) STATEMENT_DELETE_RECENT_CHANGES_TOPIC protected static String STATEMENT_DELETE_RECENT_CHANGES_TOPIC(Code) STATEMENT_DELETE_ROLE_MAP_GROUP protected static String STATEMENT_DELETE_ROLE_MAP_GROUP(Code) STATEMENT_DELETE_ROLE_MAP_USER protected static String STATEMENT_DELETE_ROLE_MAP_USER(Code) STATEMENT_DELETE_TOPIC_CATEGORIES protected static String STATEMENT_DELETE_TOPIC_CATEGORIES(Code) STATEMENT_DELETE_WATCHLIST_ENTRY protected static String STATEMENT_DELETE_WATCHLIST_ENTRY(Code) STATEMENT_DROP_CATEGORY_TABLE protected static String STATEMENT_DROP_CATEGORY_TABLE(Code) STATEMENT_DROP_GROUP_TABLE protected static String STATEMENT_DROP_GROUP_TABLE(Code) STATEMENT_DROP_RECENT_CHANGE_TABLE protected static String STATEMENT_DROP_RECENT_CHANGE_TABLE(Code) STATEMENT_DROP_ROLE_MAP_TABLE protected static String STATEMENT_DROP_ROLE_MAP_TABLE(Code) STATEMENT_DROP_ROLE_TABLE protected static String STATEMENT_DROP_ROLE_TABLE(Code) STATEMENT_DROP_TOPIC_CURRENT_VERSION_CONSTRAINT protected static String STATEMENT_DROP_TOPIC_CURRENT_VERSION_CONSTRAINT(Code) STATEMENT_DROP_TOPIC_TABLE protected static String STATEMENT_DROP_TOPIC_TABLE(Code) STATEMENT_DROP_TOPIC_VERSION_TABLE protected static String STATEMENT_DROP_TOPIC_VERSION_TABLE(Code) STATEMENT_DROP_VIRTUAL_WIKI_TABLE protected static String STATEMENT_DROP_VIRTUAL_WIKI_TABLE(Code) STATEMENT_DROP_WATCHLIST_TABLE protected static String STATEMENT_DROP_WATCHLIST_TABLE(Code) STATEMENT_DROP_WIKI_FILE_TABLE protected static String STATEMENT_DROP_WIKI_FILE_TABLE(Code) STATEMENT_DROP_WIKI_FILE_VERSION_TABLE protected static String STATEMENT_DROP_WIKI_FILE_VERSION_TABLE(Code) STATEMENT_DROP_WIKI_USER_INFO_TABLE protected static String STATEMENT_DROP_WIKI_USER_INFO_TABLE(Code) STATEMENT_DROP_WIKI_USER_LOGIN_INDEX protected static String STATEMENT_DROP_WIKI_USER_LOGIN_INDEX(Code) STATEMENT_DROP_WIKI_USER_TABLE protected static String STATEMENT_DROP_WIKI_USER_TABLE(Code) STATEMENT_INSERT_CATEGORY protected static String STATEMENT_INSERT_CATEGORY(Code) STATEMENT_INSERT_GROUP protected static String STATEMENT_INSERT_GROUP(Code) STATEMENT_INSERT_RECENT_CHANGE protected static String STATEMENT_INSERT_RECENT_CHANGE(Code) STATEMENT_INSERT_RECENT_CHANGES protected static String STATEMENT_INSERT_RECENT_CHANGES(Code) STATEMENT_INSERT_ROLE protected static String STATEMENT_INSERT_ROLE(Code) STATEMENT_INSERT_ROLE_MAP protected static String STATEMENT_INSERT_ROLE_MAP(Code) STATEMENT_INSERT_TOPIC protected static String STATEMENT_INSERT_TOPIC(Code) STATEMENT_INSERT_TOPIC_VERSION protected static String STATEMENT_INSERT_TOPIC_VERSION(Code) STATEMENT_INSERT_VIRTUAL_WIKI protected static String STATEMENT_INSERT_VIRTUAL_WIKI(Code) STATEMENT_INSERT_WATCHLIST_ENTRY protected static String STATEMENT_INSERT_WATCHLIST_ENTRY(Code) STATEMENT_INSERT_WIKI_FILE protected static String STATEMENT_INSERT_WIKI_FILE(Code) STATEMENT_INSERT_WIKI_FILE_VERSION protected static String STATEMENT_INSERT_WIKI_FILE_VERSION(Code) STATEMENT_INSERT_WIKI_USER protected static String STATEMENT_INSERT_WIKI_USER(Code) STATEMENT_INSERT_WIKI_USER_INFO protected static String STATEMENT_INSERT_WIKI_USER_INFO(Code) STATEMENT_SELECT_CATEGORIES protected static String STATEMENT_SELECT_CATEGORIES(Code) STATEMENT_SELECT_CATEGORY_TOPICS protected static String STATEMENT_SELECT_CATEGORY_TOPICS(Code) STATEMENT_SELECT_GROUP_SEQUENCE protected static String STATEMENT_SELECT_GROUP_SEQUENCE(Code) STATEMENT_SELECT_RECENT_CHANGES protected static String STATEMENT_SELECT_RECENT_CHANGES(Code) STATEMENT_SELECT_RECENT_CHANGES_TOPIC protected static String STATEMENT_SELECT_RECENT_CHANGES_TOPIC(Code) STATEMENT_SELECT_ROLES protected static String STATEMENT_SELECT_ROLES(Code) STATEMENT_SELECT_ROLE_MAP_GROUP protected static String STATEMENT_SELECT_ROLE_MAP_GROUP(Code) STATEMENT_SELECT_ROLE_MAP_GROUPS protected static String STATEMENT_SELECT_ROLE_MAP_GROUPS(Code) STATEMENT_SELECT_ROLE_MAP_LOGIN protected static String STATEMENT_SELECT_ROLE_MAP_LOGIN(Code) STATEMENT_SELECT_ROLE_MAP_ROLE protected static String STATEMENT_SELECT_ROLE_MAP_ROLE(Code) STATEMENT_SELECT_ROLE_MAP_USER protected static String STATEMENT_SELECT_ROLE_MAP_USER(Code) STATEMENT_SELECT_TOPIC protected static String STATEMENT_SELECT_TOPIC(Code) STATEMENT_SELECT_TOPICS protected static String STATEMENT_SELECT_TOPICS(Code) STATEMENT_SELECT_TOPICS_ADMIN protected static String STATEMENT_SELECT_TOPICS_ADMIN(Code) STATEMENT_SELECT_TOPIC_BY_TYPE protected static String STATEMENT_SELECT_TOPIC_BY_TYPE(Code) STATEMENT_SELECT_TOPIC_COUNT protected static String STATEMENT_SELECT_TOPIC_COUNT(Code) STATEMENT_SELECT_TOPIC_LOWER protected static String STATEMENT_SELECT_TOPIC_LOWER(Code) STATEMENT_SELECT_TOPIC_SEQUENCE protected static String STATEMENT_SELECT_TOPIC_SEQUENCE(Code) STATEMENT_SELECT_TOPIC_VERSION protected static String STATEMENT_SELECT_TOPIC_VERSION(Code) STATEMENT_SELECT_TOPIC_VERSION_SEQUENCE protected static String STATEMENT_SELECT_TOPIC_VERSION_SEQUENCE(Code) STATEMENT_SELECT_VIRTUAL_WIKIS protected static String STATEMENT_SELECT_VIRTUAL_WIKIS(Code) STATEMENT_SELECT_VIRTUAL_WIKI_SEQUENCE protected static String STATEMENT_SELECT_VIRTUAL_WIKI_SEQUENCE(Code) STATEMENT_SELECT_WATCHLIST protected static String STATEMENT_SELECT_WATCHLIST(Code) STATEMENT_SELECT_WATCHLIST_CHANGES protected static String STATEMENT_SELECT_WATCHLIST_CHANGES(Code) STATEMENT_SELECT_WIKI_FILE protected static String STATEMENT_SELECT_WIKI_FILE(Code) STATEMENT_SELECT_WIKI_FILE_COUNT protected static String STATEMENT_SELECT_WIKI_FILE_COUNT(Code) STATEMENT_SELECT_WIKI_FILE_SEQUENCE protected static String STATEMENT_SELECT_WIKI_FILE_SEQUENCE(Code) STATEMENT_SELECT_WIKI_FILE_VERSIONS protected static String STATEMENT_SELECT_WIKI_FILE_VERSIONS(Code) STATEMENT_SELECT_WIKI_FILE_VERSION_SEQUENCE protected static String STATEMENT_SELECT_WIKI_FILE_VERSION_SEQUENCE(Code) STATEMENT_SELECT_WIKI_USER protected static String STATEMENT_SELECT_WIKI_USER(Code) STATEMENT_SELECT_WIKI_USERS protected static String STATEMENT_SELECT_WIKI_USERS(Code) STATEMENT_SELECT_WIKI_USER_CHANGES_ANONYMOUS protected static String STATEMENT_SELECT_WIKI_USER_CHANGES_ANONYMOUS(Code) STATEMENT_SELECT_WIKI_USER_CHANGES_LOGIN protected static String STATEMENT_SELECT_WIKI_USER_CHANGES_LOGIN(Code) STATEMENT_SELECT_WIKI_USER_COUNT protected static String STATEMENT_SELECT_WIKI_USER_COUNT(Code) STATEMENT_SELECT_WIKI_USER_INFO protected static String STATEMENT_SELECT_WIKI_USER_INFO(Code) STATEMENT_SELECT_WIKI_USER_LOGIN protected static String STATEMENT_SELECT_WIKI_USER_LOGIN(Code) STATEMENT_SELECT_WIKI_USER_PASSWORD protected static String STATEMENT_SELECT_WIKI_USER_PASSWORD(Code) STATEMENT_SELECT_WIKI_USER_SEQUENCE protected static String STATEMENT_SELECT_WIKI_USER_SEQUENCE(Code) STATEMENT_UPDATE_GROUP protected static String STATEMENT_UPDATE_GROUP(Code) STATEMENT_UPDATE_ROLE protected static String STATEMENT_UPDATE_ROLE(Code) STATEMENT_UPDATE_TOPIC protected static String STATEMENT_UPDATE_TOPIC(Code) STATEMENT_UPDATE_TOPIC_CURRENT_VERSION protected static String STATEMENT_UPDATE_TOPIC_CURRENT_VERSION(Code) STATEMENT_UPDATE_TOPIC_CURRENT_VERSIONS protected static String STATEMENT_UPDATE_TOPIC_CURRENT_VERSIONS(Code) STATEMENT_UPDATE_VIRTUAL_WIKI protected static String STATEMENT_UPDATE_VIRTUAL_WIKI(Code) STATEMENT_UPDATE_WIKI_FILE protected static String STATEMENT_UPDATE_WIKI_FILE(Code) STATEMENT_UPDATE_WIKI_USER protected static String STATEMENT_UPDATE_WIKI_USER(Code) STATEMENT_UPDATE_WIKI_USER_INFO protected static String STATEMENT_UPDATE_WIKI_USER_INFO(Code) Constructor Detail AnsiQueryHandler protected AnsiQueryHandler()(Code) Method Detail connectionValidationQuery public String connectionValidationQuery()(Code) createTables public void createTables(Connection conn) throws Exception(Code) deleteRecentChanges public void deleteRecentChanges(int topicId, Connection conn) throws Exception(Code) deleteRoleMapGroup public void deleteRoleMapGroup(int groupId, Connection conn) throws Exception(Code) deleteRoleMapUser public void deleteRoleMapUser(int userId, Connection conn) throws Exception(Code) deleteTopicCategories public void deleteTopicCategories(int childTopicId, Connection conn) throws Exception(Code) deleteWatchlistEntry public void deleteWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn) throws Exception(Code) dropTables public void dropTables(Connection conn)(Code) existenceValidationQuery public String existenceValidationQuery()(Code) Return a simple query, that if successfully run indicates that JAMWiki tables have been initialized in the database. Returns a simple query that, if successfully run, indicatesthat JAMWiki tables have been set up in the database. getAllTopicNames public WikiResultSet getAllTopicNames(int virtualWikiId) throws Exception(Code) getAllWikiFileVersions public WikiResultSet getAllWikiFileVersions(WikiFile wikiFile, boolean descending) throws Exception(Code) getCategories public WikiResultSet getCategories(int virtualWikiId, Pagination pagination) throws Exception(Code) getRecentChanges public WikiResultSet getRecentChanges(String virtualWiki, Pagination pagination, boolean descending) throws Exception(Code) getRecentChanges public WikiResultSet getRecentChanges(int topicId, Pagination pagination, boolean descending) throws Exception(Code) getRoleMapByLogin public WikiResultSet getRoleMapByLogin(String loginFragment) throws Exception(Code) getRoleMapByRole public WikiResultSet getRoleMapByRole(String roleName) throws Exception(Code) getRoleMapGroup public WikiResultSet getRoleMapGroup(String groupName) throws Exception(Code) getRoleMapGroups public WikiResultSet getRoleMapGroups() throws Exception(Code) getRoleMapUser public WikiResultSet getRoleMapUser(String login) throws Exception(Code) getRoles public WikiResultSet getRoles() throws Exception(Code) getTopicsAdmin public WikiResultSet getTopicsAdmin(int virtualWikiId, Pagination pagination) throws Exception(Code) getUserContributions public WikiResultSet getUserContributions(String virtualWiki, String userString, Pagination pagination, boolean descending) throws Exception(Code) getVirtualWikis public WikiResultSet getVirtualWikis(Connection conn) throws Exception(Code) getWatchlist public WikiResultSet getWatchlist(int virtualWikiId, int userId) throws Exception(Code) getWatchlist public WikiResultSet getWatchlist(int virtualWikiId, int userId, Pagination pagination) throws Exception(Code) init protected void init(Properties props)(Code) insertCategory public void insertCategory(Category category, int virtualWikiId, Connection conn) throws Exception(Code) insertRecentChange public void insertRecentChange(RecentChange change, int virtualWikiId, Connection conn) throws Exception(Code) insertRole public void insertRole(Role role, Connection conn) throws Exception(Code) insertRoleMap public void insertRoleMap(int userId, int groupId, String role, Connection conn) throws Exception(Code) insertTopic public void insertTopic(Topic topic, int virtualWikiId, Connection conn) throws Exception(Code) insertTopicVersion public void insertTopicVersion(TopicVersion topicVersion, Connection conn) throws Exception(Code) insertVirtualWiki public void insertVirtualWiki(VirtualWiki virtualWiki, Connection conn) throws Exception(Code) insertWatchlistEntry public void insertWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn) throws Exception(Code) insertWikiFile public void insertWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn) throws Exception(Code) insertWikiFileVersion public void insertWikiFileVersion(WikiFileVersion wikiFileVersion, Connection conn) throws Exception(Code) insertWikiGroup public void insertWikiGroup(WikiGroup group, Connection conn) throws Exception(Code) insertWikiUser public void insertWikiUser(WikiUser user, Connection conn) throws Exception(Code) insertWikiUserInfo public void insertWikiUserInfo(WikiUserInfo userInfo, Connection conn) throws Exception(Code) lookupCategoryTopics public WikiResultSet lookupCategoryTopics(int virtualWikiId, String categoryName) throws Exception(Code) lookupTopic public WikiResultSet lookupTopic(int virtualWikiId, String topicName, boolean caseSensitive, Connection conn) throws Exception(Code) lookupTopicByType public WikiResultSet lookupTopicByType(int virtualWikiId, int topicType, Pagination pagination) throws Exception(Code) lookupTopicCount public WikiResultSet lookupTopicCount(int virtualWikiId) throws Exception(Code) Return a count of all topics, including redirects, comments pages and templates, currently available on the Wiki. This method excludes deleted topics. Parameters:   virtualWikiId - The virtual wiki id for the virtual wiki of the topicsbeing retrieved. lookupTopicVersion public WikiResultSet lookupTopicVersion(int topicVersionId, Connection conn) throws Exception(Code) lookupWikiFile public WikiResultSet lookupWikiFile(int virtualWikiId, int topicId) throws Exception(Code) lookupWikiFileCount public WikiResultSet lookupWikiFileCount(int virtualWikiId) throws Exception(Code) Return a count of all wiki files currently available on the Wiki. This method excludes deleted files. Parameters:   virtualWikiId - The virtual wiki id for the virtual wiki of the filesbeing retrieved. lookupWikiUser public WikiResultSet lookupWikiUser(int userId, Connection conn) throws Exception(Code) lookupWikiUser public WikiResultSet lookupWikiUser(String username, Connection conn) throws Exception(Code) lookupWikiUser public WikiResultSet lookupWikiUser(String username, String encryptedPassword, Connection conn) throws Exception(Code) lookupWikiUserCount public WikiResultSet lookupWikiUserCount() throws Exception(Code) Return a count of all wiki users. lookupWikiUserInfo public WikiResultSet lookupWikiUserInfo(String username) throws Exception(Code) lookupWikiUsers public WikiResultSet lookupWikiUsers(Pagination pagination) throws Exception(Code) nextTopicId public int nextTopicId(Connection conn) throws Exception(Code) nextTopicVersionId public int nextTopicVersionId(Connection conn) throws Exception(Code) nextVirtualWikiId public int nextVirtualWikiId(Connection conn) throws Exception(Code) nextWikiFileId public int nextWikiFileId(Connection conn) throws Exception(Code) nextWikiFileVersionId public int nextWikiFileVersionId(Connection conn) throws Exception(Code) nextWikiGroupId public int nextWikiGroupId(Connection conn) throws Exception(Code) nextWikiUserId public int nextWikiUserId(Connection conn) throws Exception(Code) reloadRecentChanges public void reloadRecentChanges(Connection conn) throws Exception(Code) updateRole public void updateRole(Role role, Connection conn) throws Exception(Code) updateTopic public void updateTopic(Topic topic, int virtualWikiId, Connection conn) throws Exception(Code) updateVirtualWiki public void updateVirtualWiki(VirtualWiki virtualWiki, Connection conn) throws Exception(Code) updateWikiFile public void updateWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn) throws Exception(Code) updateWikiGroup public void updateWikiGroup(WikiGroup group, Connection conn) throws Exception(Code) updateWikiUser public void updateWikiUser(WikiUser user, Connection conn) throws Exception(Code) updateWikiUserInfo public void updateWikiUserInfo(WikiUserInfo userInfo, Connection conn) throws Exception(Code) validateCategory protected void validateCategory(Category category) throws WikiException(Code) validateRecentChange protected void validateRecentChange(RecentChange change) throws WikiException(Code) validateRole protected void validateRole(Role role) throws WikiException(Code) validateRoleMap protected void validateRoleMap(String role) throws WikiException(Code) validateTopic protected void validateTopic(Topic topic) throws WikiException(Code) validateTopicVersion protected void validateTopicVersion(TopicVersion topicVersion) throws WikiException(Code) validateVirtualWiki protected void validateVirtualWiki(VirtualWiki virtualWiki) throws WikiException(Code) validateWatchlistEntry protected void validateWatchlistEntry(String topicName) throws WikiException(Code) validateWikiFile protected void validateWikiFile(WikiFile wikiFile) throws WikiException(Code) validateWikiFileVersion protected void validateWikiFileVersion(WikiFileVersion wikiFileVersion) throws WikiException(Code) validateWikiGroup protected void validateWikiGroup(WikiGroup group) throws WikiException(Code) validateWikiUser protected void validateWikiUser(WikiUser user) throws WikiException(Code) validateWikiUserInfo protected void validateWikiUserInfo(WikiUserInfo userInfo) throws WikiException(Code) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)