src/servlet/huanche_servlet.java

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

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

package servlet;

import gongong.DateUtils;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
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.TFeiyong;
import model.TZuche;
import db.DB;

public class huanche_servlet extends HttpServlet{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
        String type=req.getParameter("type");
		
		if(type.endsWith("zucheList"))
		{
			zucheList(req, res);
		}
		if(type.endsWith("toHuanche"))
		{
			toHuanche(req, res);
		}
		if(type.endsWith("huancheAdd"))
		{
			huancheAdd(req, res);
		}
	}
	public void zucheList(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		List zucheList=new ArrayList();
		String sql="select ta.id,convert(char,ta.zcrq,23)zcrq,tb.xingming,tc.chepai,tc.feiyong "+
				   "from t_zuche ta,t_kehu tb,t_cheliang tc where " +
				   "ta.khid = tb.id and ta.clid = tc.id and ta.hcrq is null";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
				TZuche zuche = new TZuche();
				zuche.setId(rs.getInt("id"));
				zuche.setStrZcrq(rs.getString("zcrq"));
				zuche.setKhxm(rs.getString("xingming"));
				zuche.setCphm(rs.getString("chepai"));
				zuche.setCldj(rs.getInt("feiyong"));
				zucheList.add(zuche);