java.lang.Object
org.sbugs.dao.DAO
org.sbugs.dao.defect.DefectDAO
- public class DefectDAO
- extends org.sbugs.dao.DAO
|
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 java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
instance
protected static DefectDAO instance
DefectDAO
protected DefectDAO()
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)