ru.bgcrm.dao

Class HelperDAO

java.lang.Object

ru.bgcrm.dao.CommonDAO

ru.bgcrm.dao.HelperDAO

public class HelperDAO
extends CommonDAO

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	TABLE_HELPER_ANSWER
static java.lang.String	TABLE_HELPER_BOOKMARK
static java.lang.String	TABLE_HELPER_NODE
static java.lang.String	TABLE_HELPER_NODE_ANSWER
static java.lang.String	TABLE_HELPER_NODE_QUESTION
static java.lang.String	TABLE_HELPER_PATTERN
static java.lang.String	TABLE_HELPER_QUESTION

Fields inherited from class ru.bgcrm.dao.CommonDAO

con, dateFormat_DDMMYYYY, dateFormat_DDMMYYYY_HHMM, log, SQL_AND, SQL_DELETE, SQL_DESC, SQL_FROM, SQL_GROUP_BY, SQL_INNER_JOIN, SQL_INSERT, SQL_LEFT_JOIN, SQL_LIMIT, SQL_ORDER_BY, SQL_REPLACE, SQL_SELECT, SQL_SELECT_ALL_FROM, SQL_SELECT_COUNT_ROWS, SQL_SET, SQL_UPDATE, SQL_WHERE

Constructor Summary

Constructors

Constructor and Description
HelperDAO(java.sql.Connection con)

Method Summary

Methods

Modifier and Type	Method and Description
void	deleteHelperBookmark(int id)
void	deleteHelperTreeNode(int nodeId)
HelperAnswer	getHelperAnswerById(int id)
HelperBookmark	getHelperBookmarkByNodeId(int nodeId)
HelperMapNode	getHelperMapNodeById(int id)
HelperPattern	getHelperPatternById(int id)
HelperQuestion	getHelperQuestionById(int id)
HelperTreeNode	getHelperTreeNodeById(int id, boolean loadChildList)
java.util.Map<java.lang.Integer,java.lang.Integer>	getTreeParentNodeMap()
void	searchAnswerList(SearchResult<HelperAnswer> searchResult)
void	searchBookmarkList(SearchResult<HelperBookmark> searchResult)
void	searchNodeList(SearchResult<HelperMapNode> searchResult)
void	searchPatternList(SearchResult<HelperPattern> searchResult)
void	searchQuestionList(SearchResult<HelperQuestion> searchResult)
void	updateHelperAnswer(HelperAnswer helperAnswer)
void	updateHelperBookmark(HelperBookmark helperBookmark)
void	updateHelperMapNode(HelperMapNode helperNode)
void	updateHelperPattern(HelperPattern helperPattern)
void	updateHelperQuestion(HelperQuestion helperQuestion)
void	updateHelperTreeNode(HelperTreeNode helperNode)
void	updateProblemAnswer(HelperAnswer helperAnswer)

Methods inherited from class ru.bgcrm.dao.CommonDAO

addLikeSql, convertDateToSqlDate, convertDateToTimestamp, deleteById, getFoundRows, getGroupedIds, getGroupedIds, getIds, getIds, getLikePattern, getMySQLLimit, getPeriodSql, lastInsertId, setPeriodParamValue, setRecordCount, sqlToBgException, updateColumn, updateIds, updateIds

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

TABLE_HELPER_ANSWER

public static final java.lang.String TABLE_HELPER_ANSWER

See Also:

Constant Field Values

TABLE_HELPER_QUESTION

public static final java.lang.String TABLE_HELPER_QUESTION

See Also:

Constant Field Values

TABLE_HELPER_NODE

public static final java.lang.String TABLE_HELPER_NODE

See Also:

Constant Field Values

TABLE_HELPER_NODE_ANSWER

public static final java.lang.String TABLE_HELPER_NODE_ANSWER

See Also:

Constant Field Values

TABLE_HELPER_NODE_QUESTION

public static final java.lang.String TABLE_HELPER_NODE_QUESTION

See Also:

Constant Field Values

TABLE_HELPER_BOOKMARK

public static final java.lang.String TABLE_HELPER_BOOKMARK

See Also:

Constant Field Values

TABLE_HELPER_PATTERN

public static final java.lang.String TABLE_HELPER_PATTERN

See Also:

Constant Field Values

Constructor Detail

HelperDAO

public HelperDAO(java.sql.Connection con)

Method Detail

getHelperTreeNodeById

public HelperTreeNode getHelperTreeNodeById(int id,
                                   boolean loadChildList)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getHelperMapNodeById

public HelperMapNode getHelperMapNodeById(int id)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getHelperQuestionById

public HelperQuestion getHelperQuestionById(int id)
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getHelperAnswerById

public HelperAnswer getHelperAnswerById(int id)
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperQuestion

public void updateHelperQuestion(HelperQuestion helperQuestion)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperAnswer

public void updateHelperAnswer(HelperAnswer helperAnswer)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

updateProblemAnswer

public void updateProblemAnswer(HelperAnswer helperAnswer)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperTreeNode

public void updateHelperTreeNode(HelperTreeNode helperNode)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperMapNode

public void updateHelperMapNode(HelperMapNode helperNode)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteHelperTreeNode

public void deleteHelperTreeNode(int nodeId)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

searchNodeList

public void searchNodeList(SearchResult<HelperMapNode> searchResult)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

searchQuestionList

public void searchQuestionList(SearchResult<HelperQuestion> searchResult)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

searchAnswerList

public void searchAnswerList(SearchResult<HelperAnswer> searchResult)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getTreeParentNodeMap

public java.util.Map<java.lang.Integer,java.lang.Integer> getTreeParentNodeMap()
                                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

searchBookmarkList

public void searchBookmarkList(SearchResult<HelperBookmark> searchResult)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getHelperBookmarkByNodeId

public HelperBookmark getHelperBookmarkByNodeId(int nodeId)
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperBookmark

public void updateHelperBookmark(HelperBookmark helperBookmark)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteHelperBookmark

public void deleteHelperBookmark(int id)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

searchPatternList

public void searchPatternList(SearchResult<HelperPattern> searchResult)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getHelperPatternById

public HelperPattern getHelperPatternById(int id)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

updateHelperPattern

public void updateHelperPattern(HelperPattern helperPattern)
                         throws java.sql.SQLException

Throws:

java.sql.SQLException