Java Doc for MSSqlQueryHandler.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       org.jamwiki.db.MSSqlQueryHandler MSSqlQueryHandler public class MSSqlQueryHandler extends AnsiQueryHandler (Code) Microsoft SQL Server-specific implementation of the QueryHandler interface. This class implements SQL Server-specific methods for instances where SQL Server does not support the default ASCII SQL syntax. Constructor Summary protected   MSSqlQueryHandler()      Constructor Detail MSSqlQueryHandler protected MSSqlQueryHandler()(Code) Fields inherited from org.jamwiki.db.AnsiQueryHandler final protected static String SQL_PROPERTY_FILE_NAME(Code)(Java Doc) protected static String STATEMENT_CONNECTION_VALIDATION_QUERY(Code)(Java Doc) protected static String STATEMENT_CREATE_CATEGORY_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_GROUP_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_RECENT_CHANGE_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_ROLE_MAP_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_ROLE_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_TOPIC_CURRENT_VERSION_CONSTRAINT(Code)(Java Doc) protected static String STATEMENT_CREATE_TOPIC_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_TOPIC_VERSION_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_VIRTUAL_WIKI_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_WATCHLIST_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_WIKI_FILE_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_WIKI_FILE_VERSION_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_WIKI_USER_INFO_TABLE(Code)(Java Doc) protected static String STATEMENT_CREATE_WIKI_USER_LOGIN_INDEX(Code)(Java Doc) protected static String STATEMENT_CREATE_WIKI_USER_TABLE(Code)(Java Doc) protected static String STATEMENT_DELETE_RECENT_CHANGES(Code)(Java Doc) protected static String STATEMENT_DELETE_RECENT_CHANGES_TOPIC(Code)(Java Doc) protected static String STATEMENT_DELETE_ROLE_MAP_GROUP(Code)(Java Doc) protected static String STATEMENT_DELETE_ROLE_MAP_USER(Code)(Java Doc) protected static String STATEMENT_DELETE_TOPIC_CATEGORIES(Code)(Java Doc) protected static String STATEMENT_DELETE_WATCHLIST_ENTRY(Code)(Java Doc) protected static String STATEMENT_DROP_CATEGORY_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_GROUP_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_RECENT_CHANGE_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_ROLE_MAP_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_ROLE_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_TOPIC_CURRENT_VERSION_CONSTRAINT(Code)(Java Doc) protected static String STATEMENT_DROP_TOPIC_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_TOPIC_VERSION_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_VIRTUAL_WIKI_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_WATCHLIST_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_WIKI_FILE_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_WIKI_FILE_VERSION_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_WIKI_USER_INFO_TABLE(Code)(Java Doc) protected static String STATEMENT_DROP_WIKI_USER_LOGIN_INDEX(Code)(Java Doc) protected static String STATEMENT_DROP_WIKI_USER_TABLE(Code)(Java Doc) protected static String STATEMENT_INSERT_CATEGORY(Code)(Java Doc) protected static String STATEMENT_INSERT_GROUP(Code)(Java Doc) protected static String STATEMENT_INSERT_RECENT_CHANGE(Code)(Java Doc) protected static String STATEMENT_INSERT_RECENT_CHANGES(Code)(Java Doc) protected static String STATEMENT_INSERT_ROLE(Code)(Java Doc) protected static String STATEMENT_INSERT_ROLE_MAP(Code)(Java Doc) protected static String STATEMENT_INSERT_TOPIC(Code)(Java Doc) protected static String STATEMENT_INSERT_TOPIC_VERSION(Code)(Java Doc) protected static String STATEMENT_INSERT_VIRTUAL_WIKI(Code)(Java Doc) protected static String STATEMENT_INSERT_WATCHLIST_ENTRY(Code)(Java Doc) protected static String STATEMENT_INSERT_WIKI_FILE(Code)(Java Doc) protected static String STATEMENT_INSERT_WIKI_FILE_VERSION(Code)(Java Doc) protected static String STATEMENT_INSERT_WIKI_USER(Code)(Java Doc) protected static String STATEMENT_INSERT_WIKI_USER_INFO(Code)(Java Doc) protected static String STATEMENT_SELECT_CATEGORIES(Code)(Java Doc) protected static String STATEMENT_SELECT_CATEGORY_TOPICS(Code)(Java Doc) protected static String STATEMENT_SELECT_GROUP_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_RECENT_CHANGES(Code)(Java Doc) protected static String STATEMENT_SELECT_RECENT_CHANGES_TOPIC(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLES(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLE_MAP_GROUP(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLE_MAP_GROUPS(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLE_MAP_LOGIN(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLE_MAP_ROLE(Code)(Java Doc) protected static String STATEMENT_SELECT_ROLE_MAP_USER(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPICS(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPICS_ADMIN(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_BY_TYPE(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_COUNT(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_LOWER(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_VERSION(Code)(Java Doc) protected static String STATEMENT_SELECT_TOPIC_VERSION_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_VIRTUAL_WIKIS(Code)(Java Doc) protected static String STATEMENT_SELECT_VIRTUAL_WIKI_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_WATCHLIST(Code)(Java Doc) protected static String STATEMENT_SELECT_WATCHLIST_CHANGES(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_FILE(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_FILE_COUNT(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_FILE_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_FILE_VERSIONS(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_FILE_VERSION_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USERS(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_CHANGES_ANONYMOUS(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_CHANGES_LOGIN(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_COUNT(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_INFO(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_LOGIN(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_PASSWORD(Code)(Java Doc) protected static String STATEMENT_SELECT_WIKI_USER_SEQUENCE(Code)(Java Doc) protected static String STATEMENT_UPDATE_GROUP(Code)(Java Doc) protected static String STATEMENT_UPDATE_ROLE(Code)(Java Doc) protected static String STATEMENT_UPDATE_TOPIC(Code)(Java Doc) protected static String STATEMENT_UPDATE_TOPIC_CURRENT_VERSION(Code)(Java Doc) protected static String STATEMENT_UPDATE_TOPIC_CURRENT_VERSIONS(Code)(Java Doc) protected static String STATEMENT_UPDATE_VIRTUAL_WIKI(Code)(Java Doc) protected static String STATEMENT_UPDATE_WIKI_FILE(Code)(Java Doc) protected static String STATEMENT_UPDATE_WIKI_USER(Code)(Java Doc) protected static String STATEMENT_UPDATE_WIKI_USER_INFO(Code)(Java Doc) Methods inherited from org.jamwiki.db.AnsiQueryHandler public String connectionValidationQuery()(Code)(Java Doc) public void createTables(Connection conn) throws Exception(Code)(Java Doc) public void deleteRecentChanges(int topicId, Connection conn) throws Exception(Code)(Java Doc) public void deleteRoleMapGroup(int groupId, Connection conn) throws Exception(Code)(Java Doc) public void deleteRoleMapUser(int userId, Connection conn) throws Exception(Code)(Java Doc) public void deleteTopicCategories(int childTopicId, Connection conn) throws Exception(Code)(Java Doc) public void deleteWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn) throws Exception(Code)(Java Doc) public void dropTables(Connection conn)(Code)(Java Doc) public String existenceValidationQuery()(Code)(Java Doc) public WikiResultSet getAllTopicNames(int virtualWikiId) throws Exception(Code)(Java Doc) public WikiResultSet getAllWikiFileVersions(WikiFile wikiFile, boolean descending) throws Exception(Code)(Java Doc) public WikiResultSet getCategories(int virtualWikiId, Pagination pagination) throws Exception(Code)(Java Doc) public WikiResultSet getRecentChanges(String virtualWiki, Pagination pagination, boolean descending) throws Exception(Code)(Java Doc) public WikiResultSet getRecentChanges(int topicId, Pagination pagination, boolean descending) throws Exception(Code)(Java Doc) public WikiResultSet getRoleMapByLogin(String loginFragment) throws Exception(Code)(Java Doc) public WikiResultSet getRoleMapByRole(String roleName) throws Exception(Code)(Java Doc) public WikiResultSet getRoleMapGroup(String groupName) throws Exception(Code)(Java Doc) public WikiResultSet getRoleMapGroups() throws Exception(Code)(Java Doc) public WikiResultSet getRoleMapUser(String login) throws Exception(Code)(Java Doc) public WikiResultSet getRoles() throws Exception(Code)(Java Doc) public WikiResultSet getTopicsAdmin(int virtualWikiId, Pagination pagination) throws Exception(Code)(Java Doc) public WikiResultSet getUserContributions(String virtualWiki, String userString, Pagination pagination, boolean descending) throws Exception(Code)(Java Doc) public WikiResultSet getVirtualWikis(Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet getWatchlist(int virtualWikiId, int userId) throws Exception(Code)(Java Doc) public WikiResultSet getWatchlist(int virtualWikiId, int userId, Pagination pagination) throws Exception(Code)(Java Doc) protected void init(Properties props)(Code)(Java Doc) public void insertCategory(Category category, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void insertRecentChange(RecentChange change, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void insertRole(Role role, Connection conn) throws Exception(Code)(Java Doc) public void insertRoleMap(int userId, int groupId, String role, Connection conn) throws Exception(Code)(Java Doc) public void insertTopic(Topic topic, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void insertTopicVersion(TopicVersion topicVersion, Connection conn) throws Exception(Code)(Java Doc) public void insertVirtualWiki(VirtualWiki virtualWiki, Connection conn) throws Exception(Code)(Java Doc) public void insertWatchlistEntry(int virtualWikiId, String topicName, int userId, Connection conn) throws Exception(Code)(Java Doc) public void insertWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void insertWikiFileVersion(WikiFileVersion wikiFileVersion, Connection conn) throws Exception(Code)(Java Doc) public void insertWikiGroup(WikiGroup group, Connection conn) throws Exception(Code)(Java Doc) public void insertWikiUser(WikiUser user, Connection conn) throws Exception(Code)(Java Doc) public void insertWikiUserInfo(WikiUserInfo userInfo, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupCategoryTopics(int virtualWikiId, String categoryName) throws Exception(Code)(Java Doc) public WikiResultSet lookupTopic(int virtualWikiId, String topicName, boolean caseSensitive, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupTopicByType(int virtualWikiId, int topicType, Pagination pagination) throws Exception(Code)(Java Doc) public WikiResultSet lookupTopicCount(int virtualWikiId) throws Exception(Code)(Java Doc) public WikiResultSet lookupTopicVersion(int topicVersionId, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiFile(int virtualWikiId, int topicId) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiFileCount(int virtualWikiId) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUser(int userId, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUser(String username, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUser(String username, String encryptedPassword, Connection conn) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUserCount() throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUserInfo(String username) throws Exception(Code)(Java Doc) public WikiResultSet lookupWikiUsers(Pagination pagination) throws Exception(Code)(Java Doc) public int nextTopicId(Connection conn) throws Exception(Code)(Java Doc) public int nextTopicVersionId(Connection conn) throws Exception(Code)(Java Doc) public int nextVirtualWikiId(Connection conn) throws Exception(Code)(Java Doc) public int nextWikiFileId(Connection conn) throws Exception(Code)(Java Doc) public int nextWikiFileVersionId(Connection conn) throws Exception(Code)(Java Doc) public int nextWikiGroupId(Connection conn) throws Exception(Code)(Java Doc) public int nextWikiUserId(Connection conn) throws Exception(Code)(Java Doc) public void reloadRecentChanges(Connection conn) throws Exception(Code)(Java Doc) public void updateRole(Role role, Connection conn) throws Exception(Code)(Java Doc) public void updateTopic(Topic topic, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void updateVirtualWiki(VirtualWiki virtualWiki, Connection conn) throws Exception(Code)(Java Doc) public void updateWikiFile(WikiFile wikiFile, int virtualWikiId, Connection conn) throws Exception(Code)(Java Doc) public void updateWikiGroup(WikiGroup group, Connection conn) throws Exception(Code)(Java Doc) public void updateWikiUser(WikiUser user, Connection conn) throws Exception(Code)(Java Doc) public void updateWikiUserInfo(WikiUserInfo userInfo, Connection conn) throws Exception(Code)(Java Doc) protected void validateCategory(Category category) throws WikiException(Code)(Java Doc) protected void validateRecentChange(RecentChange change) throws WikiException(Code)(Java Doc) protected void validateRole(Role role) throws WikiException(Code)(Java Doc) protected void validateRoleMap(String role) throws WikiException(Code)(Java Doc) protected void validateTopic(Topic topic) throws WikiException(Code)(Java Doc) protected void validateTopicVersion(TopicVersion topicVersion) throws WikiException(Code)(Java Doc) protected void validateVirtualWiki(VirtualWiki virtualWiki) throws WikiException(Code)(Java Doc) protected void validateWatchlistEntry(String topicName) throws WikiException(Code)(Java Doc) protected void validateWikiFile(WikiFile wikiFile) throws WikiException(Code)(Java Doc) protected void validateWikiFileVersion(WikiFileVersion wikiFileVersion) throws WikiException(Code)(Java Doc) protected void validateWikiGroup(WikiGroup group) throws WikiException(Code)(Java Doc) protected void validateWikiUser(WikiUser user) throws WikiException(Code)(Java Doc) protected void validateWikiUserInfo(WikiUserInfo userInfo) throws WikiException(Code)(Java Doc) 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)