shangdian/src/com/action/dingdan_servlet.java

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

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

package com.action;

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 com.dao.DB;
import com.orm.Txitong;
import com.orm.Tdingdan;

public class dingdan_servlet extends HttpServlet
{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
        String type=req.getParameter("type");
		if(type.endsWith("dingdanMana"))
		{
			dingdanMana(req, res);
		}
		if(type.endsWith("dingdanShouli"))
		{
			dingdanShouli(req, res);
		}
	}


	public void dingdanMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
	{
		List dingdanList=new ArrayList();
		String sql="select a.*,b.xfzxingming,b.xfzdianhua,b.xfzdizhi from dingdan a left join xiaofeizhe b on a.xiaofeizheID=b.xfzID order by dingdanZhuangtai desc";
		Object[] params={};
		DB mydb=new DB();
		try
		{
			mydb.doPstm(sql, params);
			ResultSet rs=mydb.getRs();
			while(rs.next())
			{
                  Tdingdan dingdan=new Tdingdan();
				
				dingdan.setDingdanID(rs.getString("dingdanID"));
				dingdan.setDingdanHao(rs.getString("dingdanHao"));
				dingdan.setDingdanShijian(rs.getString("dingdanShijian"));
				dingdan.setDingdanZhuangtai(rs.getString("dingdanZhuangtai"));
				dingdan.setDingdanZonger(rs.getInt("dingdanZonger"));
				dingdan.setXiaofeizheID(rs.getInt("xiaofeizheiD"));
				dingdan.setxfzxingming(rs.getString("xfzxingming"));
				dingdan.setXfzdianhua(rs.getString("xfzdianhua"));
				dingdan.setXfzdizhi(rs.getString("xfzdizhi"));
				
				dingdanList.add(dingdan);