private void onLoad() throws EnjoyException {
logger.info("[onLoad][Begin]");
try {
this.initialCombo();
} catch (EnjoyException e) {
throw new EnjoyException(e.getMessage());
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("onLoad is error");
} finally {
logger.info("[onLoad][End]");
}
}
private void initialCombo() throws EnjoyException {
logger.info("[initialCombo][Begin]");
try {
this.setColumnList();
this.setOrderByList();
this.setSortByList();
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("initialCombo is error");
} finally {
logger.info("[initialCombo][End]");
}
}
private void lp_getPage() {
logger.info("[lp_getPage][Begin]");
int pageNum = 1;
List<DemoLookUpBean> list = new ArrayList<DemoLookUpBean>();
try {
pageNum = Integer.parseInt(this.request.getParameter("pageNum"));
this.form.setPageNum(pageNum);
list = (List<DemoLookUpBean>) this.form.getHashTable().get(pageNum);
this.form.setDataList(list);
} catch (Exception e) {
e.printStackTrace();
} finally {
logger.info("[lp_getPage][End]");
}
}
private void setSortByList() throws EnjoyException {
logger.info("[setSortByList][Begin]");
List<DemoLookUpBean> sortByList = null;
try {
sortByList = new ArrayList<DemoLookUpBean>();
sortByList.add(new DemoLookUpBean("ASC", "ASC"));
sortByList.add(new DemoLookUpBean("DESC", "DESC"));
this.form.setSortByList(sortByList);
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("setSortByList is error");
} finally {
logger.info("[setSortByList][End]");
}
}
private void setOrderByList() throws EnjoyException {
logger.info("[setOrderByList][Begin]");
List<DemoLookUpBean> orderByList = null;
try {
orderByList = new ArrayList<DemoLookUpBean>();
orderByList.add(new DemoLookUpBean("pageCodes", "รหัสหน้าจอ"));
orderByList.add(new DemoLookUpBean("pageNames", "ชื่อหน้าจอ"));
this.form.setOrderByList(orderByList);
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("setOrderByList is error");
} finally {
logger.info("[setOrderByList][End]");
}
}
private void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
logger.info("[execute][Begin]");
String pageAction = null;
try {
pageAction = EnjoyUtil.nullToStr(request.getParameter("pageAction"));
this.enjoyUtil = new EnjoyUtil(request, response);
this.request = request;
this.response = response;
this.session = request.getSession(false);
this.userBean = (UserDetailsBean) session.getAttribute("userBean");
this.form = (DemoLookUpForm) session.getAttribute(FORM_NAME);
this.dao = new DemoLookUpDao();
logger.info("[execute] pageAction : " + pageAction);
if (this.form == null || pageAction.equals("new")) this.form = new DemoLookUpForm();
if (pageAction.equals("") || pageAction.equals("new")) {
this.onLoad();
request.setAttribute("target", Constants.PAGE_URL + "/zoom/DemoLookUpScn.jsp");
} else if (pageAction.equals("search")) {
this.onSearch();
} else if (pageAction.equals("getPage")) {
this.lp_getPage();
}
session.setAttribute(FORM_NAME, this.form);
} catch (EnjoyException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
logger.info(e.getMessage());
} finally {
logger.info("[execute][End]");
}
}
public class DemoLookUpServlet extends EnjoyStandardSvc {
static final long serialVersionUID = 1L;
private static final EnjoyLogger logger = EnjoyLogger.getLogger(DemoLookUpServlet.class);
private static final String FORM_NAME = "demoLookUpForm";
private EnjoyUtil enjoyUtil = null;
private HttpServletRequest request = null;
private HttpServletResponse response = null;
private HttpSession session = null;
private UserDetailsBean userBean = null;
private DemoLookUpDao dao = null;
private DemoLookUpForm form = null;
@Override
public void execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
// TODO Auto-generated method stub
doProcess(request, response);
}
private void doProcess(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
logger.info("[execute][Begin]");
String pageAction = null;
try {
pageAction = EnjoyUtil.nullToStr(request.getParameter("pageAction"));
this.enjoyUtil = new EnjoyUtil(request, response);
this.request = request;
this.response = response;
this.session = request.getSession(false);
this.userBean = (UserDetailsBean) session.getAttribute("userBean");
this.form = (DemoLookUpForm) session.getAttribute(FORM_NAME);
this.dao = new DemoLookUpDao();
logger.info("[execute] pageAction : " + pageAction);
if (this.form == null || pageAction.equals("new")) this.form = new DemoLookUpForm();
if (pageAction.equals("") || pageAction.equals("new")) {
this.onLoad();
request.setAttribute("target", Constants.PAGE_URL + "/zoom/DemoLookUpScn.jsp");
} else if (pageAction.equals("search")) {
this.onSearch();
} else if (pageAction.equals("getPage")) {
this.lp_getPage();
}
session.setAttribute(FORM_NAME, this.form);
} catch (EnjoyException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
logger.info(e.getMessage());
} finally {
logger.info("[execute][End]");
}
}
private void onLoad() throws EnjoyException {
logger.info("[onLoad][Begin]");
try {
this.initialCombo();
} catch (EnjoyException e) {
throw new EnjoyException(e.getMessage());
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("onLoad is error");
} finally {
logger.info("[onLoad][End]");
}
}
private void initialCombo() throws EnjoyException {
logger.info("[initialCombo][Begin]");
try {
this.setColumnList();
this.setOrderByList();
this.setSortByList();
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("initialCombo is error");
} finally {
logger.info("[initialCombo][End]");
}
}
private void setColumnList() throws EnjoyException {
logger.info("[setColumnList][Begin]");
List<DemoLookUpBean> columnList = null;
try {
columnList = new ArrayList<DemoLookUpBean>();
columnList.add(new DemoLookUpBean("", "กรุณาระบุ"));
columnList.add(new DemoLookUpBean("pageCodes", "รหัสหน้าจอ"));
columnList.add(new DemoLookUpBean("pageNames", "ชื่อหน้าจอ"));
this.form.setColumnList(columnList);
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("setColumnList is error");
} finally {
logger.info("[setColumnList][End]");
}
}
private void setOrderByList() throws EnjoyException {
logger.info("[setOrderByList][Begin]");
List<DemoLookUpBean> orderByList = null;
try {
orderByList = new ArrayList<DemoLookUpBean>();
orderByList.add(new DemoLookUpBean("pageCodes", "รหัสหน้าจอ"));
orderByList.add(new DemoLookUpBean("pageNames", "ชื่อหน้าจอ"));
this.form.setOrderByList(orderByList);
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("setOrderByList is error");
} finally {
logger.info("[setOrderByList][End]");
}
}
private void setSortByList() throws EnjoyException {
logger.info("[setSortByList][Begin]");
List<DemoLookUpBean> sortByList = null;
try {
sortByList = new ArrayList<DemoLookUpBean>();
sortByList.add(new DemoLookUpBean("ASC", "ASC"));
sortByList.add(new DemoLookUpBean("DESC", "DESC"));
this.form.setSortByList(sortByList);
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("setSortByList is error");
} finally {
logger.info("[setSortByList][End]");
}
}
private void onSearch() throws EnjoyException {
logger.info("[onSearch][Begin]");
SessionFactory sessionFactory = null;
Session session = null;
int cou = 0;
int pageNum = 1;
int totalPage = 0;
int totalRs = 0;
List<DemoLookUpBean> list = new ArrayList<DemoLookUpBean>();
List<DemoLookUpBean> listTemp = new ArrayList<DemoLookUpBean>();
HashMap hashTable = new HashMap();
String find = null;
String column = null;
String orderBy = null;
String sortBy = null;
String likeFlag = null;
List<DemoLookUpBean> dataList = null;
try {
find = EnjoyUtils.nullToStr(this.request.getParameter("find"));
column = EnjoyUtils.nullToStr(this.request.getParameter("column"));
orderBy = EnjoyUtils.nullToStr(this.request.getParameter("orderBy"));
sortBy = EnjoyUtils.nullToStr(this.request.getParameter("sortBy"));
likeFlag = EnjoyUtils.chkBoxtoDb(this.request.getParameter("likeFlag"));
sessionFactory = HibernateUtil.getSessionFactory();
session = sessionFactory.openSession();
session.beginTransaction();
logger.info("[onSearch] find :: " + find);
logger.info("[onSearch] column :: " + column);
logger.info("[onSearch] orderBy :: " + orderBy);
logger.info("[onSearch] sortBy :: " + sortBy);
logger.info("[onSearch] likeFlag :: " + likeFlag);
this.form.setFind(find);
this.form.setColumn(column);
this.form.setOrderBy(orderBy);
this.form.setSortBy(sortBy);
this.form.setLikeFlag(likeFlag);
dataList = this.dao.getLookUpList(session, this.form);
if (dataList.size() > 0) {
hashTable.put(pageNum, list);
for (DemoLookUpBean bean : dataList) {
if (cou == 10) {
cou = 0;
list = new ArrayList<DemoLookUpBean>();
pageNum++;
}
list.add(bean);
hashTable.put(pageNum, list);
cou++;
totalRs++;
}
totalPage = hashTable.size();
logger.info("[onSearch] totalPage :: " + totalPage);
this.form.setTotalPage(totalPage);
this.form.setTotalRecord(EnjoyUtils.convertFloatToDisplay(String.valueOf(totalRs), 0));
this.form.setHashTable(hashTable);
this.form.setPageNum(1);
listTemp = (List<DemoLookUpBean>) this.form.getHashTable().get(this.form.getPageNum());
logger.info("[onSearchUserDetail] listTemp :: " + listTemp.size());
this.form.setDataList(listTemp);
} else {
this.form.setTotalPage(1);
this.form.setTotalRecord(EnjoyUtils.convertFloatToDisplay("0", 0));
this.form.setHashTable(hashTable);
this.form.setPageNum(1);
this.form.setDataList(dataList);
throw new EnjoyException("ไม่พบรายการตามเงื่อนไขที่ระบุ");
}
} catch (EnjoyException e) {
throw new EnjoyException(e.getMessage());
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("onSearch is error");
} finally {
session.close();
sessionFactory = null;
session = null;
this.initialCombo();
logger.info("[onSearch][End]");
}
}
private void lp_getPage() {
logger.info("[lp_getPage][Begin]");
int pageNum = 1;
List<DemoLookUpBean> list = new ArrayList<DemoLookUpBean>();
try {
pageNum = Integer.parseInt(this.request.getParameter("pageNum"));
this.form.setPageNum(pageNum);
list = (List<DemoLookUpBean>) this.form.getHashTable().get(pageNum);
this.form.setDataList(list);
} catch (Exception e) {
e.printStackTrace();
} finally {
logger.info("[lp_getPage][End]");
}
}
@Override
public void destroySession() {
// TODO Auto-generated method stub
}
@Override
public void commit() {
// TODO Auto-generated method stub
}
@Override
public void rollback() {
// TODO Auto-generated method stub
}
}
private void onSearch() throws EnjoyException {
logger.info("[onSearch][Begin]");
SessionFactory sessionFactory = null;
Session session = null;
int cou = 0;
int pageNum = 1;
int totalPage = 0;
int totalRs = 0;
List<DemoLookUpBean> list = new ArrayList<DemoLookUpBean>();
List<DemoLookUpBean> listTemp = new ArrayList<DemoLookUpBean>();
HashMap hashTable = new HashMap();
String find = null;
String column = null;
String orderBy = null;
String sortBy = null;
String likeFlag = null;
List<DemoLookUpBean> dataList = null;
try {
find = EnjoyUtils.nullToStr(this.request.getParameter("find"));
column = EnjoyUtils.nullToStr(this.request.getParameter("column"));
orderBy = EnjoyUtils.nullToStr(this.request.getParameter("orderBy"));
sortBy = EnjoyUtils.nullToStr(this.request.getParameter("sortBy"));
likeFlag = EnjoyUtils.chkBoxtoDb(this.request.getParameter("likeFlag"));
sessionFactory = HibernateUtil.getSessionFactory();
session = sessionFactory.openSession();
session.beginTransaction();
logger.info("[onSearch] find :: " + find);
logger.info("[onSearch] column :: " + column);
logger.info("[onSearch] orderBy :: " + orderBy);
logger.info("[onSearch] sortBy :: " + sortBy);
logger.info("[onSearch] likeFlag :: " + likeFlag);
this.form.setFind(find);
this.form.setColumn(column);
this.form.setOrderBy(orderBy);
this.form.setSortBy(sortBy);
this.form.setLikeFlag(likeFlag);
dataList = this.dao.getLookUpList(session, this.form);
if (dataList.size() > 0) {
hashTable.put(pageNum, list);
for (DemoLookUpBean bean : dataList) {
if (cou == 10) {
cou = 0;
list = new ArrayList<DemoLookUpBean>();
pageNum++;
}
list.add(bean);
hashTable.put(pageNum, list);
cou++;
totalRs++;
}
totalPage = hashTable.size();
logger.info("[onSearch] totalPage :: " + totalPage);
this.form.setTotalPage(totalPage);
this.form.setTotalRecord(EnjoyUtils.convertFloatToDisplay(String.valueOf(totalRs), 0));
this.form.setHashTable(hashTable);
this.form.setPageNum(1);
listTemp = (List<DemoLookUpBean>) this.form.getHashTable().get(this.form.getPageNum());
logger.info("[onSearchUserDetail] listTemp :: " + listTemp.size());
this.form.setDataList(listTemp);
} else {
this.form.setTotalPage(1);
this.form.setTotalRecord(EnjoyUtils.convertFloatToDisplay("0", 0));
this.form.setHashTable(hashTable);
this.form.setPageNum(1);
this.form.setDataList(dataList);
throw new EnjoyException("ไม่พบรายการตามเงื่อนไขที่ระบุ");
}
} catch (EnjoyException e) {
throw new EnjoyException(e.getMessage());
} catch (Exception e) {
logger.info(e.getMessage());
throw new EnjoyException("onSearch is error");
} finally {
session.close();
sessionFactory = null;
session = null;
this.initialCombo();
logger.info("[onSearch][End]");
}
}