?? queryborrowaction.java
字號(hào):
/*
* 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);
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -