sql多表查讯

/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package cn.jxcar.struts.action;

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 cn.jxcar.struts.form.SearchMeForm;

public class SearchMeAction extends Action {

public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
SearchMeForm sForm = (SearchMeForm) form;// TODO Auto-generated
// System.out.println("价格范围:"+sForm.getSelect()+"<br>"+"发布时间:"+sForm.getSelect2()+"<br>"+"品牌:"+sForm.getSelect3()+"<br>"+"车辆性质:"+sForm.getSelect4()+"<br>"+"类型:"+sForm.getSelect5()+"<br>"+"输入的字:"+sForm.getMsg()+"<br>");
String sql = "select username,userPro,carPro,abId,carName,firstYM, sellPrice,carShen,a.lastinttime from autobase as a inner join user as b on a.userId=b.userid where carName like '%"
+ sForm.getMsg() + "%'";
cn.jxcar.car.sqlRetrun re = new cn.jxcar.car.sqlRetrun();
if (null == sForm.getMsg() || "".equals(sForm.getMsg())) {
sql = "select all username,userPro,carPro,abId,carName,firstYM, sellPrice,carShen,a.lastinttime from autobase as a inner join user as b on a.userId=b.userid where beizhu='备注'";
}
if (!"0".equals(sForm.getSelect())) {// 选了这个 价钱
int r = re.getSe1(Integer.parseInt(sForm.getSelect()));
if (5 == r) {
sql = sql + "and sellPrice between 10000 and 50000";
} else if (15 == r) {
sql = sql + "and sellPrice between 50000 and 150000";
} else {
sql = sql + "and sellPrice >150000";
}
}
if (!"0".equals(sForm.getSelect2())) {// 选了这个时间
int r = re.getSe2(Integer.parseInt(sForm.getSelect2()));
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat(
"yyyy-MM-dd");
java.util.Date currentTime = new java.util.Date();
String[] bb = formatter.format(currentTime).split("-");
String s = bb[0] + bb[1] + bb[2];
int b = Integer.parseInt(s);
if (0 == r) {
sql = sql + " and a.lastinttime=" + b;
} else if (3 == r) {
sql = sql + " and a.lastinttime between " + b + " and "
+ (b - 3);
} else if (6 == r) {
sql = sql + " and a.lastinttime between " + b + " and "
+ (b - 7);
} else if (7 == r) {
sql = sql + " and a.lastinttime between " + b + " and "
+ (b - 365);
}
}
if (!"0".equals(sForm.getSelect3())) {// 选了这个厂商
sql = sql + " and a.fHome='" + sForm.getSelect3()+"'";
}
if (!"0".equals(sForm.getSelect4())) {// 选了这个车辆性质
sql = sql + " and a.carP='"
+ re.getSe4(Integer.parseInt(sForm.getSelect4()))+"'";
}
if (!"0".equals(sForm.getSelect5())) {// 选了这个车辆性质小车或大贷车
sql = sql + " and a.carPro='"
+ re.getSe5(Integer.parseInt(sForm.getSelect5()))+"'";
}
request.getSession().setAttribute("sql", sql);

return mapping.findForward("ok");
}
}