Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

org.sbugs.dao.defect
Class DefectDAO  view DefectDAO download DefectDAO.java

java.lang.Object
  extended byorg.sbugs.dao.DAO
      extended byorg.sbugs.dao.defect.DefectDAO

public class DefectDAO
extends org.sbugs.dao.DAO


Field Summary
protected static DefectDAO instance
           
 
Constructor Summary
protected DefectDAO()
           
 
Method Summary
 void addNote(int defectId, java.lang.String addedBy, long addedTime, java.lang.String noteText, java.sql.Connection connection)
           
private  java.lang.String buildInClause(java.lang.String tableName, java.lang.String[] array, boolean termsAdded)
           
 void createDefect(org.sbugs.model.defect.Defect defect, java.sql.Connection connection)
           
 java.util.List findDefects(org.sbugs.logic.defect.DefectSearchTerms searchTerms, java.sql.Connection connection)
           
static DefectDAO getInstance()
           
 org.sbugs.model.defect.Defect loadDefect(int defectId, java.sql.Connection connection)
           
private  void loadNotes(org.sbugs.model.defect.Defect defect, java.sql.Connection connection)
           
private  java.lang.String searchSql(java.lang.String base)
           
private  int setInClauseValues(java.sql.PreparedStatement statement, int startIndex, java.lang.String[] list)
           
 void updateDefect(int defectId, int severityId, int priorityId, long modifiedTime, java.sql.Connection connection)
           
 void updateDefectState(int defectId, java.lang.String newState, long time, java.sql.Connection connection)
           
private  boolean validSearchTerm(java.lang.String string)
           
private  boolean validSearchTerm(java.lang.String[] list)
           
 
Methods inherited from class org.sbugs.dao.DAO
closeConnection, closeStatement, getOptionalInteger, setOptionalInteger
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

instance

protected static DefectDAO instance
Constructor Detail

DefectDAO

protected DefectDAO()
Method Detail

getInstance

public static DefectDAO getInstance()

createDefect

public void createDefect(org.sbugs.model.defect.Defect defect,
                         java.sql.Connection connection)
                  throws java.sql.SQLException

findDefects

public java.util.List findDefects(org.sbugs.logic.defect.DefectSearchTerms searchTerms,
                                  java.sql.Connection connection)
                           throws java.sql.SQLException

loadDefect

public org.sbugs.model.defect.Defect loadDefect(int defectId,
                                                java.sql.Connection connection)
                                         throws java.sql.SQLException

loadNotes

private void loadNotes(org.sbugs.model.defect.Defect defect,
                       java.sql.Connection connection)
                throws java.sql.SQLException

updateDefect

public void updateDefect(int defectId,
                         int severityId,
                         int priorityId,
                         long modifiedTime,
                         java.sql.Connection connection)
                  throws java.sql.SQLException

updateDefectState

public void updateDefectState(int defectId,
                              java.lang.String newState,
                              long time,
                              java.sql.Connection connection)
                       throws java.sql.SQLException

addNote

public void addNote(int defectId,
                    java.lang.String addedBy,
                    long addedTime,
                    java.lang.String noteText,
                    java.sql.Connection connection)
             throws java.sql.SQLException

searchSql

private java.lang.String searchSql(java.lang.String base)

validSearchTerm

private boolean validSearchTerm(java.lang.String string)

validSearchTerm

private boolean validSearchTerm(java.lang.String[] list)

setInClauseValues

private int setInClauseValues(java.sql.PreparedStatement statement,
                              int startIndex,
                              java.lang.String[] list)
                       throws java.sql.SQLException

buildInClause

private java.lang.String buildInClause(java.lang.String tableName,
                                       java.lang.String[] array,
                                       boolean termsAdded)