src/servlet/zuche_servlet.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package servlet;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

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

import model.TCheLiang;
import model.TFeiyong;
import model.TKeHu;
import model.TZuche;
import db.DB;

public class zuche_servlet extends HttpServlet
{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
        String type=req.getParameter("type");
		
		if(type.endsWith("kehuList"))
		{
			kehuList(req, res);
		}
		if(type.endsWith("toZuche"))
		{
			toZuche(req, res);
		}
		if(type.endsWith("zucheAdd"))
		{
			zucheAdd(req, res);
		}
		if(type.endsWith("zucheQuery"))
		{
			zucheQuery(req, res);
		}
		if(type.endsWith("zucheDetail"))
		{
			zucheDetail(req, res);
		}
	}
	
	public void zucheQuery(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		String cphm = req.getParameter("cphm")==null?"":req.getParameter("cphm");
		String st = req.getParameter("st")==null?"":req.getParameter("st");
		String et = req.getParameter("et")==null?"":req.getParameter("et");
		
		List zucheList=new ArrayList();
		String sql = "select ta.id,tb.chepai,convert(char,zcrq,23)zcrq,isnull(convert(char,hcrq,23),'')hcrq,isnull(zfy,0)zfy "+
					 "from t_zuche ta,t_cheliang tb where ta.clid = tb.id";
		if(!("".equals(cphm))){
			sql += " and tb.chepai like '%"+cphm+"%' ";
		}