/**
* Method execute
*
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward displaylocations(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) {
LoginForm loginForm = (LoginForm) form;
Connection geconn = ConnectionFactory.getConnection();
String sql1 = "Select * from GE_LOCATION";
ArrayList ar1_id = new ArrayList();
ArrayList ar2_name = new ArrayList();
try {
Statement st = geconn.createStatement();
ResultSet rs = st.executeQuery(sql1);
while (rs.next()) {
ar1_id.add(rs.getString("LOCATION_ID") + "-" + rs.getString("LOCATION_NM"));
ar2_name.add(rs.getString("LOCATION_ID") + "-" + rs.getString("LOCATION_NM"));
}
loginForm.setAr1_id(ar1_id);
loginForm.setAr2_name(ar2_name);
} catch (SQLException e) {
e.printStackTrace();
}
return mapping.findForward("logout");
}
