servlet-条件查询表（日期查询、模糊查询）

最新推荐文章于 2023-02-05 23:25:52 发布

回忆中贤

最新推荐文章于 2023-02-05 23:25:52 发布

阅读量1.5k

点赞数 2

分类专栏： JAVA

本文链接：https://blog.csdn.net/weixin_44540416/article/details/90894716

版权

JAVA 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

在这里插入图片描述
这两个是等会用条件查询
private String numbers;// 库存调拨单号
private String allotDate;// 审核日期

package com.luo.po;

public class RepertoryBright {
	private int RepertoryBrightID;// 库存调拨明细ID
	private int quantity;// 调拨数量
	private int money;// 调拨金额
	private String reason;// 调拨原因
	private String auditDate;// 调拨日期
	private String allotDate;// 审核日期
	private String numbers;// 库存调拨单号
	private String code;// 配件编码
	private String parts;// 配件名称
	private String barcode;// 条码
	private String specifications;// 配件规格
	private String brand;// 品牌
	private int purchase;// 进价
	private int price;// 销售价格
	private int trade;// 批发价
	private int openbill;// 开单价
	private String carType;// 车型名称 

}

第一步 dao

package com.luo.dao;
import java.io.Serializable;
import java.util.List;
import com.luo.po.RepertoryBright;
public interface RepertoryBrightDao<T, k extends Serializable> {
	/**RepertoryBright表查询  */
	List<RepertoryBright> selectTxg(Integer pagesize, Integer curPage ,String Numbers,String AllotDate,String AllotDatenot);
	
	/**求和页数 */
	public long sumBY(); 
}

第二步 lmpl

package com.luo.dao.impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.luo.dao.RepertoryBrightDao;
import com.luo.po.RepertoryBright;
import com.luo.util.DButil;
public class RepertoryBrightlmpl implements RepertoryBrightDao<RepertoryBright, Integer> {

	private Connection con=null;//连接
	private PreparedStatement ps=null;//准备声明
	private ResultSet rs=null;//结果集 
	//求和 sql语句
	private String sumBY="select count(repertorybrightid) conut " +
			" from PW_RepertoryBright rb,PW_Repertory r,SYS_Parts p ,SYS_CarType c  " +
			" where rb.RepertoryID=r.RepertoryID and rb.PartsID=p.PartsID and p.CarTypeID=c.CarTypeID";
	//查询
	@Override
	public List<RepertoryBright> selectTxg(Integer pagesize, Integer curPage 
			,String Numbers,String AllotDate,String AllotDatenot) {
		List<RepertoryBright> Bs=new ArrayList<RepertoryBright>();
		//当条件不为空时就执行if里面的条件查询语句 为空不查询
		String str="";
          if(Numbers!=null||AllotDate!=null||AllotDatenot!=null){
        	  str=" and r.Numbers like \'%"+Numbers+"%\'  and  r.AllotDate between \'"+AllotDate+"\' and \'"+AllotDatenot+"\' ";
		}
		//查询---分页
	   String selectTxg="select rb.*,r.*,p.*,c.* from PW_RepertoryBright rb,PW_Repertory r,SYS_Parts p ,SYS_CarType c "+
				"where rb.RepertoryID=r.RepertoryID and rb.PartsID=p.PartsID and p.CarTypeID=c.CarTypeID "+str+/* if语句不能空就执行添加在这*/
		"order by rb.RepertoryBrightID offset (? - 1) * ? rows fetch next ? rows only";
		//分页
		
		try {
			con=DButil.getConnection();
			ps=con.prepareStatement(selectTxg);
			ps.setInt(1, curPage);
			ps.setInt(2, pagesize);
			ps.setInt(3, pagesize);
			rs=ps.executeQuery();
			while(rs.next()){
				RepertoryBright bright=new RepertoryBright();
				bright.setQuantity(rs.getInt("quantity"));
				bright.setMoney(rs.getInt("money"));
				bright.setReason(rs.getString("reason"));
				bright.setAuditDate(rs.getString("auditDate"));
				bright.setAllotDate(rs.getString("allotDate"));
				bright.setNumbers(rs.getString("numbers"));
				bright.setCode(rs.getString("code"));
				bright.setParts(rs.getString("parts"));
				bright.setBarcode(rs.getString("barcode"));
				bright.setSpecifications(rs.getString("specifications"));
				bright.setBrand(rs.getString("brand"));
				bright.setPurchase(rs.getInt("purchase"));
				bright.setPrice(rs.getInt("price"));
				bright.setTrade(rs.getInt("trade"));
				bright.setOpenbill(rs.getInt("openbill"));
				bright.setCarType(rs.getString("carType"));
				Bs.add(bright);
			}
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DButil.close(con, ps, rs);
		}
		
		
		return Bs;
	}

	//分页求和 
	@Override
	public long sumBY() {
		long t=0;
		try {
			con=DButil.getConnection();
			ps=con.prepareStatement(sumBY);
			rs=ps.executeQuery();
			while(rs.next()){
				t=rs.getLong("conut");
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			DButil.close(con, ps, rs);
		}
		return t;
	}

	
	
}

第三步servlet

package com.luo.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import net.sf.json.JSONArray;
import net.sf.json.JSONObject;

import com.luo.dao.RepertoryBrightDao;
import com.luo.dao.impl.RepertoryBrightlmpl;
import com.luo.po.RepertoryBright;

public class ReBrigServlet extends HttpServlet {

	private RepertoryBrightDao<RepertoryBright, Integer> brightDao=new RepertoryBrightlmpl();
	private static final long serialVersionUID = 1L;
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		doPost(request, response);
		
	}
	
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("UTF-8");
		String type=request.getParameter("type");
		if("selectTxg".equals(type)){
			selectTxg(request, response);
			
		}
	}
	
	public void selectTxg(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=UTF-8");
		String limit = (request.getParameter("limit")==null)?"1":request.getParameter("limit");
		String page = (request.getParameter("page")==null)?"2":request.getParameter("page");
		String Numbers=request.getParameter("Numbers");
		String AllotDate=(request.getParameter("AllotDate"));
		String AllotDatenot=(request.getParameter("AllotDatenot"));
		System.out.println(Numbers + "\n" + AllotDate + "\n" + AllotDatenot);
		//页面查询条件Numbers  AllotDate  AllotDatenot
		List<RepertoryBright> rb=brightDao.selectTxg(Integer.parseInt(limit),Integer.parseInt(page),  Numbers,AllotDate,AllotDatenot);
		int count=(int) brightDao.sumBY();
		PrintWriter writer = response.getWriter();
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("code", 0);
		jsonObject.put("msg","");
        jsonObject.put("count",count);//分页
        JSONArray result = JSONArray.fromObject(rb);
        jsonObject.put("data",result);
        writer.println(jsonObject.toString());
        writer.flush();
        writer.close();
	} 
}

jsp

<div id="Luo_motaikunag" style="display: none;">
        	<form action=""  method="post" id="Luo_Form">
        		&nbsp;&nbsp;单号：<input class="layui-input" id="Numbers" name="Numbers" style="width: 300px;display: inline-block;"/><br>
        		&nbsp;&nbsp;日期：<input class="layui-input"  name="AllotDate" id="test17" placeholder="日期"/>
								 <input class="layui-input"  name="AllotDatenot" id="test18" placeholder="日期"/>
			</form>
			<button onclick="selecting()"  class="layui-btn layui-btn-danger layui-btn-radius layui-icon xixi">查询</button>
    	</div>


function selecting(){
  		var table = layui.table;
  		var Numbers=$("#Numbers").val();
  		if(Numbers==undefined){
  			Numbers="";
  		}
  		var AllotDate=$("#test17").val();
  		if(AllotDate==undefined){
  			AllotDate="";
  		}
  		var AllotDatenot=$("#test18").val();
  		if(AllotDatenot==undefined){
  			AllotDatenot="";
  		}
  		 table.reload("Luo_GGng", {
                where: {
                    Numbers: Numbers,
                    AllotDate: AllotDate,
                    AllotDatenot: AllotDatenot,
                }
            });
  	}