You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
128 lines
3.5 KiB
128 lines
3.5 KiB
package com.action;
|
|
|
|
import com.bean.electric_addBean;
|
|
import com.dao.electriDao;
|
|
import com.opensymphony.xwork2.ActionSupport;
|
|
import org.apache.struts2.ServletActionContext;
|
|
|
|
import javax.servlet.http.HttpServletResponse;
|
|
import javax.servlet.http.HttpSession;
|
|
import java.io.PrintWriter;
|
|
import java.util.List;
|
|
|
|
public class electricManager extends ActionSupport {
|
|
|
|
|
|
//下面是Action内用于封装用户请求参数的属性
|
|
private List<electric_addBean> list;
|
|
|
|
|
|
public List<electric_addBean> getList() {
|
|
return list;
|
|
}
|
|
|
|
public void setList(List<electric_addBean> list) {
|
|
this.list = list;
|
|
}
|
|
|
|
private String SearchRow;
|
|
private String SearchKey;
|
|
|
|
public String getSearchRow() {
|
|
return SearchRow;
|
|
}
|
|
|
|
public void setSearchRow(String searchRow) {
|
|
SearchRow = searchRow;
|
|
}
|
|
|
|
public String getSearchKey() {
|
|
return SearchKey;
|
|
}
|
|
|
|
public void setSearchKey(String searchKey) {
|
|
SearchKey = searchKey;
|
|
}
|
|
|
|
//处理用户请求的execute方法
|
|
public String execute() throws Exception {
|
|
|
|
//解决乱码，用于页面输出
|
|
HttpServletResponse response = null;
|
|
response = ServletActionContext.getResponse();
|
|
response.setContentType("text/html;charset=UTF-8");
|
|
response.setCharacterEncoding("UTF-8");
|
|
PrintWriter out = response.getWriter();
|
|
|
|
//创建session对象
|
|
HttpSession session = ServletActionContext.getRequest().getSession();
|
|
//验证是否正常登录
|
|
if(session.getAttribute("id")==null){
|
|
out.print("<script language='javascript'>alert('请重新登录！');window.location='Login.jsp';</script>");
|
|
out.flush();out.close();return null;
|
|
}
|
|
//查询条件
|
|
// String strWhere="1=1";
|
|
// if(!(isInvalid(SearchKey)))
|
|
// {
|
|
// strWhere+=" and "+SearchRow+"='"+SearchKey+"'";
|
|
// }
|
|
// if(!(isInvalid(State)))
|
|
// {
|
|
// strWhere+=" and Student_State='"+State+"'";
|
|
// }
|
|
// else
|
|
// {
|
|
// strWhere+=" and Student_State='入住'";
|
|
// }
|
|
//查询所有
|
|
if(session.getAttribute("type").toString().equals("3")){ String strWhere = "1=1";
|
|
if (!(isInvalid(SearchKey))) {
|
|
strWhere += " and " + SearchRow + "='" + SearchKey + "'";
|
|
}
|
|
// if(!(isInvalid(Integer.toString(repair_id))))
|
|
// {
|
|
// strWhere+=" and repair_id='"+repair_id+"'";
|
|
// }
|
|
|
|
//查询所有楼宇
|
|
//list=new RepairDao().GetList("","repair_id");
|
|
|
|
//查询所有
|
|
list = new electriDao().GetList(strWhere, "Electric_Dormitory_Number");
|
|
|
|
return ERROR;}
|
|
else{
|
|
String strWhere = "1=1";
|
|
if (!(isInvalid(SearchKey))) {
|
|
strWhere += " and " + SearchRow + "='" + SearchKey + "'";
|
|
}
|
|
// if(!(isInvalid(Integer.toString(repair_id))))
|
|
// {
|
|
// strWhere+=" and repair_id='"+repair_id+"'";
|
|
// }
|
|
|
|
//查询所有楼宇
|
|
//list=new RepairDao().GetList("","repair_id");
|
|
|
|
//查询所有
|
|
list = new electriDao().GetList(strWhere, "Electric_Dormitory_Number");
|
|
|
|
return SUCCESS;
|
|
|
|
}}
|
|
|
|
//判断是否空值
|
|
private boolean isInvalid(String value) {
|
|
return (value == null || value.length() == 0);
|
|
}
|
|
|
|
//测试
|
|
public static void main(String[] args) {
|
|
System.out.println();
|
|
}
|
|
|
|
}
|
|
|
|
|