Package sk.iway.iwcm.qa

Class QADB

java.lang.Object

sk.iway.iwcm.qa.QADB

public class QADB
extends Object

praca z databazou otazok a odpovedi

Field Summary

Fields

Modifier and Type	Field	Description
static final int	ORDER_DATE
static final int	ORDER_PRIORITY

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	QADB()

Method Summary

Modifier and Type	Method	Description
static String	addQuestion(QABean qa, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
static boolean	answer(QABean qa, javax.servlet.http.HttpServletRequest request)
static boolean	delete(QABean qa, javax.servlet.http.HttpServletRequest request)
static String	executeAnswer(QABean qa, javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response)
static List<QABean>	filterQaByGroups(List<QABean> original, Collection<LabelValueDetails> groups)	Vyfiltruje QA beany podla danych skupin, vrati tie tkore do danych skupin patria
protected static int	getNewPriority(String groupName)	Vrati novu prioritu pre qa pre danu grupu, najde doteraz najvyssiu + 10
static QABean	getQA(javax.servlet.http.HttpServletRequest request)	Ziska QABean pre admin cast (zadanie odpovede)
static QABean	getQAById(int questionId)
static List<QABean>	getQAList(String groupName, boolean onlyForWeb, boolean ascending, javax.servlet.http.HttpServletRequest request)
static List<QABean>	getQAList(String groupName, boolean onlyForWeb, int orderType, boolean ascending, int startPage, int pageSize, javax.servlet.http.HttpServletRequest request)
static List<QABean>	getQAList(String groupName, boolean onlyForWeb, int orderType, boolean ascending, int startPage, int pageSize, javax.servlet.http.HttpServletRequest request, String categoryName, String fullTextSearchString)
static List<QABean>	getQAList(String groupName, boolean onlyForWeb, int orderType, boolean ascending, javax.servlet.http.HttpServletRequest request)
static List<QABean>	getQAList(String groupName, boolean onlyForWeb, int orderType, boolean ascending, javax.servlet.http.HttpServletRequest request, String categoryName, String fullTextSearchString)	Vrati zoznam otazok a odpovedi v danej skupine
static int	getQAListSize(String groupName, boolean onlyForWeb, javax.servlet.http.HttpServletRequest request)	Vrati pocet otazok a odpovedi v danej skupine
static int	getQAListSize(String groupName, boolean onlyForWeb, javax.servlet.http.HttpServletRequest request, String categoryName, String fullTextSearchString)	Vrati pocet otazok a odpovedi v danej skupine
static List<LabelValueDetails>	getQARoots(javax.servlet.http.HttpServletRequest request)
static boolean	save(QABean qa, javax.servlet.http.HttpServletRequest request)	Description of the Method
static boolean	sendAdminMail(QABean qa, javax.servlet.http.HttpServletRequest request)

Methods inherited from class java.lang.Object

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

Field Details

ORDER_DATE

public static final int ORDER_DATE

See Also:

• Constant Field Values

ORDER_PRIORITY

public static final int ORDER_PRIORITY

See Also:

• Constant Field Values

Constructor Details

QADB

protected QADB()

Method Details

getQAList

public static List<QABean> getQAList(String groupName,
 boolean onlyForWeb,
 boolean ascending,
 javax.servlet.http.HttpServletRequest request)

getQAList

public static List<QABean> getQAList(String groupName,
 boolean onlyForWeb,
 int orderType,
 boolean ascending,
 int startPage,
 int pageSize,
 javax.servlet.http.HttpServletRequest request)

getQAList

public static List<QABean> getQAList(String groupName,
 boolean onlyForWeb,
 int orderType,
 boolean ascending,
 int startPage,
 int pageSize,
 javax.servlet.http.HttpServletRequest request,
 String categoryName,
 String fullTextSearchString)

getQAList

public static List<QABean> getQAList(String groupName,
 boolean onlyForWeb,
 int orderType,
 boolean ascending,
 javax.servlet.http.HttpServletRequest request)

filterQaByGroups

public static List<QABean> filterQaByGroups(List<QABean> original,
 Collection<LabelValueDetails> groups)

Vyfiltruje QA beany podla danych skupin, vrati tie tkore do danych skupin patria

Parameters:

original -

groups -

Returns:

getQAList

public static List<QABean> getQAList(String groupName,
 boolean onlyForWeb,
 int orderType,
 boolean ascending,
 javax.servlet.http.HttpServletRequest request,
 String categoryName,
 String fullTextSearchString)

Vrati zoznam otazok a odpovedi v danej skupine

Parameters:

groupName - - nazov skupiny

onlyForWeb - - ak true, iba tie co su urcene na web

orderType - - sposob usporiadania

ascending - - ak true, tak usporiada ASC

request -

categoryName - - kategoria

fullTextSearchString - - tento text hlada v question a answer

Returns:

- zoznam otazok a odpovedi

getQAListSize

public static int getQAListSize(String groupName,
 boolean onlyForWeb,
 javax.servlet.http.HttpServletRequest request)

Vrati pocet otazok a odpovedi v danej skupine

Parameters:

groupName - - nazov skupiny

onlyForWeb - - ak true spocita len tie, ktore su urcene na web

request -

Returns:

getQAListSize

public static int getQAListSize(String groupName,
 boolean onlyForWeb,
 javax.servlet.http.HttpServletRequest request,
 String categoryName,
 String fullTextSearchString)

Vrati pocet otazok a odpovedi v danej skupine

Parameters:

groupName - - nazov skupiny

onlyForWeb - - ak true spocita len tie, ktore su urcene na web

request -

categoryName - - kategoria

fullTextSearchString - - tento text hlada v question a answer

Returns:

getQARoots

public static List<LabelValueDetails> getQARoots(javax.servlet.http.HttpServletRequest request)

getQAById

public static QABean getQAById(int questionId)

getQA

public static QABean getQA(javax.servlet.http.HttpServletRequest request)

Ziska QABean pre admin cast (zadanie odpovede)

Parameters:

request -

Returns:

save

public static boolean save(QABean qa,
 javax.servlet.http.HttpServletRequest request)

Description of the Method

Parameters:

qa - Description of the Parameter

request - Description of the Parameter

Returns:

Description of the Return Value

answer

public static boolean answer(QABean qa,
 javax.servlet.http.HttpServletRequest request)

delete

public static boolean delete(QABean qa,
 javax.servlet.http.HttpServletRequest request)

getNewPriority

protected static int getNewPriority(String groupName)

Vrati novu prioritu pre qa pre danu grupu, najde doteraz najvyssiu + 10

Parameters:

groupName - groupName

Returns:

addQuestion

public static String addQuestion(QABean qa,
 javax.servlet.http.HttpServletRequest request,
 javax.servlet.http.HttpServletResponse response)
                          throws IOException,
javax.servlet.ServletException

Throws:

IOException

javax.servlet.ServletException

executeAnswer

public static String executeAnswer(QABean qa,
 javax.servlet.http.HttpServletRequest request,
 javax.servlet.http.HttpServletResponse response)
                            throws IOException,
javax.servlet.ServletException

Throws:

IOException

javax.servlet.ServletException

sendAdminMail

public static boolean sendAdminMail(QABean qa,
 javax.servlet.http.HttpServletRequest request)