/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package kignbi.dong.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

import kignbi.dong.*;
//import kignbi.dong.Users;
import kignbi.dong.form.QueryBorrowForm;
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 org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

/** 
 * MyEclipse Struts
 * Creation date: 01-31-2008
 * 
 * XDoclet definition:
 * @struts.action path="/queryBorrow" name="queryBorrowForm" input="/admin/borrowlist.jsp" scope="request" validate="true"
 * @struts.action-forward name="success" path="/admin/borrowlist.jsp"
 * @struts.action-forward name="false" path="/admin/borrowlist.jsp"
 */
public class QueryBorrowAction 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) {
		QueryBorrowForm queryBorrowForm = (QueryBorrowForm) form;// TODO Auto-generated method stub
		 String searchType=queryBorrowForm.getSearchType().trim();
		    String condition=queryBorrowForm.getCondition().trim();
		//HttpSession session = request.getSession(true);
		ActionMessages errors = new ActionMessages();
		String PageForward = "false";
		ServletContext context = servlet.getServletContext();
		DataSource dataSource = (DataSource) context.getAttribute(Constants.DATASOURCE_KEY);
		DB db = new DB(dataSource);
		String sql="select * from borrow  where not_num!=0 and state!=0 and "+searchType+" like '%"+condition+"%'";
		System.out.print("查詢類型:"+searchType+"");
		System.out.print("條件:"+condition+"");
		System.out.print("語(yǔ)句:"+sql+"");
		try{ ResultSet rs=db.OpenSql(sql);
		      int i=0;
		    if(rs.next())
		     {
                rs.previous();//外條件使指針后移
		    	ArrayList res=new ArrayList();
		        while (rs.next()){
		    		i=i+1;  
		    		Borrow borrow = new Borrow();
		    		borrow.setId(rs.getString("id"));
					borrow.setUid(rs.getString("uid"));
					borrow.setBid(rs.getString("bid"));
				    borrow.setDt_borrow(rs.getString("dt_borrow"));
					borrow.setDt_return(rs.getString("dt_return"));
		            borrow.setNumber(rs.getInt("number"));
		            borrow.setNot_num(rs.getInt("not_num"));
		            borrow.setDays(rs.getInt("days"));
		            borrow.setRemark(rs.getString("remark"));
		            res.add(borrow);
	             }
	          String count=Integer.toString(i);
	          request.setAttribute("count", count);
	          request.setAttribute("borrows",res);
	          PageForward="success";
	          
		      }
		 
		else {
			  errors.add(ActionMessages.GLOBAL_MESSAGE, new ActionMessage(
			   "search.borrow.noresult"));
	      if (!errors.isEmpty()) {
		     saveErrors(request, errors);
		  }
	   }
	}
		catch(SQLException e ){
			e.printStackTrace();
		}
	      

		db.close();
		return mapping.findForward(PageForward);
}
}