package com.costar.empdemo.action;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.costar.empdemo.dao.indao.InDeptDAO;
public class FindDeptsAC extends Action {
InDeptDAO deptDAO;
public void setDeptDAO(InDeptDAO deptDAO) {
this.deptDAO = deptDAO;
}
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
String dname = request.getParameter("dname");
if (dname == null)
dname = "";
List list = deptDAO.findDepts(dname.toUpperCase());
request.setAttribute("depts", list);
return mapping.findForward("success");
}
}
1、连接数据库
2、执行查询
3、根据查询结果设置文本
sql语句会吧?
查出个list,程序里request.setAttribute("mylist",list);
在页面上用标签提取。list.字段名。