Java Doc for ThreadDAOImplJDBC.java in  » Forum » mvnforum-1.1 » com » mvnforum » db » jdbc » 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 » Forum » mvnforum 1.1 » com.mvnforum.db.jdbc   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    com.mvnforum.db.jdbc.ThreadDAOImplJDBC ThreadDAOImplJDBC public class ThreadDAOImplJDBC implements ThreadDAO(Code) Constructor Summary public   ThreadDAOImplJDBC()      Method Summary public  int createThread(int forumID, String memberName, String lastPostMemberName, String threadTopic, String threadBody, int threadVoteCount, int threadVoteTotalStars, Timestamp threadCreationDate, Timestamp threadLastPostDate, int threadType, int threadPriority, int threadOption, int threadStatus, int threadHasPoll, int threadViewCount, int threadReplyCount, String threadIcon, int threadDuration, int threadAttachCount)      public  void delete(int threadID)      public  void delete_inForum(int forumID)      public  void findByPrimaryKey(int threadID)      public  Collection getAllEnableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order)      public  Collection getDisableBeans_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order)      public  Collection getDisableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order)      public  Collection getEnableForumAnnouncements_inForum(int forumID)      public  Collection getEnableGlobalAnnouncements()      public  Collection getEnableStickies_inForum(int forumID)      public  Collection getEnableThreadsWithPendingPosts_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order)      public  Collection getEnableThreadsWithPendingPosts_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order)      public  Collection getEnableThreads_inCategory(int categoryID, Timestamp sinceDate)      public  Collection getEnableThreads_inForum(int forumID, Timestamp sinceDate)      public  Collection getEnableThreads_inGlobal(Timestamp sinceDate)      public  Collection getEnableThreads_inThread(int threadID, Timestamp sinceDate)      public  Collection getEnableThreads_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order, boolean onlyNoReply, int status, int category, int forum)      public  Collection getEnableThreads_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order, Timestamp from, Timestamp to)      public  int getNextEnableThread(int forumID, int threadID)      public  Collection getNormalEnableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order)      public  int getNumberOfDisableThreads()      public  int getNumberOfDisableThreads_inForum(int forumID)      public  int getNumberOfEnableThreads(boolean onlyNoReply, int status, int category, int forum)      public  int getNumberOfEnableThreadsWithPendingPosts()      public  int getNumberOfEnableThreadsWithPendingPosts_inForum(int forumID)      public  int getNumberOfEnableThreads_inForum(int forumID)      public  int getNumberOfNormalEnableThreads_inForum(int forumID)      public  int getPreviousEnableThread(int forumID, int threadID)      public  ThreadBean getThread(int threadID)      public  Collection getThreads_inFavorite_inMember(int memberID)      public  void increaseReplyCount(int threadID)      public  void increaseViewCount(int threadID)      protected static  boolean isDirty()      protected static  void setDirty(boolean dirty)      public  void updateForumID(int threadID, int forumID)      public  void updateLastPostDate(int threadID, Timestamp threadLastPostDate)      public  void updateLastPostMemberName(int threadID, String lastPostMemberName)      public  void updateReplyCount(int threadID, int threadReplyCount)      public  void updateThreadAttachCount(int threadID, int attachCount)      public  void updateThreadHasPoll(int threadID, int pollCount)      public  void updateThreadStatus(int threadID, int threadStatus)      public  void updateThreadType(int threadID, int threadType)      public  void updateTopic_Body_Icon(int threadID, String threadTopic, String threadBody, String threadIcon, int threadPriority)      Constructor Detail ThreadDAOImplJDBC public ThreadDAOImplJDBC()(Code) Method Detail createThread public int createThread(int forumID, String memberName, String lastPostMemberName, String threadTopic, String threadBody, int threadVoteCount, int threadVoteTotalStars, Timestamp threadCreationDate, Timestamp threadLastPostDate, int threadType, int threadPriority, int threadOption, int threadStatus, int threadHasPoll, int threadViewCount, int threadReplyCount, String threadIcon, int threadDuration, int threadAttachCount) throws ObjectNotFoundException, CreateException, DatabaseException, ForeignKeyNotFoundException(Code) delete public void delete(int threadID) throws DatabaseException, ObjectNotFoundException(Code) delete_inForum public void delete_inForum(int forumID) throws DatabaseException(Code) findByPrimaryKey public void findByPrimaryKey(int threadID) throws ObjectNotFoundException, DatabaseException(Code) getAllEnableThreads_inForum_withSortSupport_limit public Collection getAllEnableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException(Code) getDisableBeans_withSortSupport_limit public Collection getDisableBeans_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException(Code) getDisableThreads_inForum_withSortSupport_limit public Collection getDisableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException(Code) getEnableForumAnnouncements_inForum public Collection getEnableForumAnnouncements_inForum(int forumID) throws DatabaseException(Code) getEnableGlobalAnnouncements public Collection getEnableGlobalAnnouncements() throws DatabaseException(Code) getEnableStickies_inForum public Collection getEnableStickies_inForum(int forumID) throws DatabaseException(Code) getEnableThreadsWithPendingPosts_inForum_withSortSupport_limit public Collection getEnableThreadsWithPendingPosts_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException, ObjectNotFoundException(Code) This method is used to get enable threads that having at least one pending post (for moderation) Note: current implementation use the NOSCROLL method which is quite slow NOTE: This method is a hack for Oracle because of the error "Not a Group By expression" and when add to the group by clause, then it cannot group by a LONG column Parameters:   offset - Parameters:   rowsToReturn - Parameters:   sort - Parameters:   order - throws:   java.lang.IllegalArgumentException - if the arguments are not valid throws:   DatabaseException - getEnableThreadsWithPendingPosts_withSortSupport_limit public Collection getEnableThreadsWithPendingPosts_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException, ObjectNotFoundException(Code) This method is used to get enable threads that having at least one pending post (for moderation) Note: current implementation use the NOSCROLL method which is quite slow Parameters:   offset - Parameters:   rowsToReturn - Parameters:   sort - Parameters:   order - throws:   java.lang.IllegalArgumentException - if the arguments are not valid throws:   DatabaseException - getEnableThreads_inCategory public Collection getEnableThreads_inCategory(int categoryID, Timestamp sinceDate) throws DatabaseException(Code) getEnableThreads_inForum public Collection getEnableThreads_inForum(int forumID, Timestamp sinceDate) throws DatabaseException(Code) getEnableThreads_inGlobal public Collection getEnableThreads_inGlobal(Timestamp sinceDate) throws DatabaseException(Code) getEnableThreads_inThread public Collection getEnableThreads_inThread(int threadID, Timestamp sinceDate) throws DatabaseException(Code) getEnableThreads_withSortSupport_limit public Collection getEnableThreads_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order, boolean onlyNoReply, int status, int category, int forum) throws IllegalArgumentException, DatabaseException(Code) getEnableThreads_withSortSupport_limit public Collection getEnableThreads_withSortSupport_limit(int offset, int rowsToReturn, String sort, String order, Timestamp from, Timestamp to) throws IllegalArgumentException, DatabaseException(Code) getNextEnableThread public int getNextEnableThread(int forumID, int threadID) throws DatabaseException(Code) getNormalEnableThreads_inForum_withSortSupport_limit public Collection getNormalEnableThreads_inForum_withSortSupport_limit(int forumID, int offset, int rowsToReturn, String sort, String order) throws IllegalArgumentException, DatabaseException(Code) getNumberOfDisableThreads public int getNumberOfDisableThreads() throws DatabaseException(Code) getNumberOfDisableThreads_inForum public int getNumberOfDisableThreads_inForum(int forumID) throws DatabaseException(Code) getNumberOfEnableThreads public int getNumberOfEnableThreads(boolean onlyNoReply, int status, int category, int forum) throws DatabaseException(Code) getNumberOfEnableThreadsWithPendingPosts public int getNumberOfEnableThreadsWithPendingPosts() throws DatabaseException(Code) getNumberOfEnableThreadsWithPendingPosts_inForum public int getNumberOfEnableThreadsWithPendingPosts_inForum(int forumID) throws DatabaseException(Code) getNumberOfEnableThreads_inForum public int getNumberOfEnableThreads_inForum(int forumID) throws DatabaseException(Code) Note: this is a customized method getNumberOfNormalEnableThreads_inForum public int getNumberOfNormalEnableThreads_inForum(int forumID) throws DatabaseException(Code) getPreviousEnableThread public int getPreviousEnableThread(int forumID, int threadID) throws DatabaseException(Code) getThread public ThreadBean getThread(int threadID) throws ObjectNotFoundException, DatabaseException(Code) getThreads_inFavorite_inMember public Collection getThreads_inFavorite_inMember(int memberID) throws DatabaseException(Code) increaseReplyCount public void increaseReplyCount(int threadID) throws DatabaseException, ObjectNotFoundException(Code) This method should be call only when we can make sure that threadID is in database increaseViewCount public void increaseViewCount(int threadID) throws DatabaseException, ObjectNotFoundException(Code) This method should be call only when we can make sure that threadID is in database isDirty protected static boolean isDirty()(Code) setDirty protected static void setDirty(boolean dirty)(Code) updateForumID public void updateForumID(int threadID, int forumID) throws ObjectNotFoundException, DatabaseException, ForeignKeyNotFoundException(Code) updateLastPostDate public void updateLastPostDate(int threadID, Timestamp threadLastPostDate) throws ObjectNotFoundException, DatabaseException(Code) updateLastPostMemberName public void updateLastPostMemberName(int threadID, String lastPostMemberName) throws ObjectNotFoundException, DatabaseException, ForeignKeyNotFoundException(Code) updateReplyCount public void updateReplyCount(int threadID, int threadReplyCount) throws IllegalArgumentException, DatabaseException, ObjectNotFoundException(Code) updateThreadAttachCount public void updateThreadAttachCount(int threadID, int attachCount) throws ObjectNotFoundException, DatabaseException(Code) updateThreadHasPoll public void updateThreadHasPoll(int threadID, int pollCount) throws ObjectNotFoundException, DatabaseException(Code) updateThreadStatus public void updateThreadStatus(int threadID, int threadStatus) throws ObjectNotFoundException, DatabaseException(Code) updateThreadType public void updateThreadType(int threadID, int threadType) throws ObjectNotFoundException, DatabaseException(Code) updateTopic_Body_Icon public void updateTopic_Body_Icon(int threadID, String threadTopic, String threadBody, String threadIcon, int threadPriority) throws ObjectNotFoundException, DatabaseException(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)