jsp+servlet同学录系统

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package addressbook.action; import java.util.ArrayList; import model.*; import java.sql.*; import javax.sql.*; import javax.servlet.ServletContext; 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 addressbook.form.SearchForm; /** * MyEclipse Struts * Creation date: 11-07-2008 * * XDoclet definition: * @struts.action path="/search" name="searchForm" input="/search.jsp" scope="request" validate="true" */ public class SearchAction extends Action { /* * Generated Methods */ /** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception{ SearchForm searchForm=(SearchForm)form; String name = searchForm.getName(); String phone = searchForm.getPhone(); String address = searchForm.getAddress(); AddressBean bean=new AddressBean(); bean.setName(name); bean.setPhone(phone); bean.setAddress(address); ServletContext application=servlet.getServletContext(); DataSource ds=(DataSource)application.getAttribute("mysql"); DBUtil db=new DBUtil(ds); String sql="select * from addressbook_table where "; if(bean.getName()!=null && bean.getName().length()>=1){ sql=sql+"name like '"+bean.getName()+"%' and"; } if(bean.getPhone() != null && bean.getPhone().length()>=1){ sql=sql+" phone like '"+bean.getPhone()+"%' and"; } if(bean.getAddress() != null && bean.getAddress().length()>=1){ sql=sql+" address like '"+bean.getAddress()+"%'"; }else{ sql=sql.substring(0, sql.length()-3); } sql=sql+"order by id"; System.out.println(sql); ArrayList<AddressBean> list=new ArrayList<AddressBean>(); list=bean.searchUser(db, sql); System.out.println(list.size()); if(list.isEmpty()){ return new ActionForward(mapping.getInput()); } db.close(); request.setAttribute("list", list); return mapping.findForward("display"); } }