indent.java

J2EE网络书店系统 采用JSP , servlet ,javabean开发 初学者可以参考

/*
 * 创建日期 2005-3-7
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package store;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.GregorianCalendar;
import java.util.Vector;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.sql.ResultSet;
import store.Basket;
import store.Book;
import store.IndentList;

/**
 * @author wwx
 *
 * TODO 要更改此生成的类型注释的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class Indent {
	private long id;
	private String indentno;
	private String username;
	private String submittime;
	private String consignmenttime;
	private String content;
	private float totalprice;
	private int ispayoff;
	private int issales;
	
	public void SetId(long l)
	{
		id = l;
	}
	
	public void SetIndentNO(String s)
	{
		indentno = s;
	}
	
	public void SetUsername(String s)
	{
		username = s;
	}
	
	public void SetSubmitTime(String s)
	{
		submittime = s;
	}
	
	public void SetConsignmentTime(String s)
	{
		consignmenttime = s;
	}

	public void SetContent(String s)
	{
		content = s;
	}
	
	public void SetTotalPrice(float f)
	{
		totalprice = f;
	}
	
	public void SetIsPayoff(int i)
	{
		ispayoff = i;
	}
	
	public void SetIsSales(int i)
	{
		issales = i;
	}
	
	public long GetId()
	{
		return id;
	}
	
	public String GetIndentNO()
	{
		return indentno;
	}
	
	public String GetUsername()
	{
		return username;
	}
	
	public String GetSubmitTime()
	{
		return submittime;
	}
	
	public String GetConsignmentTime()
	{
		return consignmenttime;
	}

	public String GetContent()
	{
		return content;
	}
	
	public String GetTolalPrice()
	{
		return String.valueOf(totalprice);
	}
	
	public String GetIsPayoff()
	{
		return String.valueOf(ispayoff);
	}
	
	public String GetIsSales()
	{
		return String.valueOf(issales);
	}

	public void AddIndent(HttpServletRequest httpservletrequest) throws Exception
	{
		String s = "";
		boolean flag = false;
		String s1 = ParamUtils.getString(httpservletrequest, "content", "");
		HttpSession httpsession = httpservletrequest.getSession(true);
		Basket basket = (Basket)httpsession.getAttribute("Basket");
		User user = (User)httpsession.getAttribute("wwx");
		
		if(basket==null)
		{
			s = s + "Your basket is empty!<br>";
			flag = true;
		}
		if(user==null)
		{
			s = s + "Your have not loged in!<br>";
			flag = true;
		}
		String basketrs[] = basket.getBooks();
		if (basketrs==null)
		{
			s = s + "Your basket is empty!<br>";
			flag = true;
		}
		if(s1.equals("") || s1==null)
		{
			s1 = "";
		}
		
		if(!flag)
		{
			SimpleDateFormat simpledateformat = new SimpleDateFormat("yyyyMMddmmss");
			Date date = new Date();
			String dateno = simpledateformat.format(date);
			java.sql.Date sdate = new java.sql.Date(date.getTime());
			GregorianCalendar adddate = new GregorianCalendar();
			adddate.setTime(date);
			adddate.add(5, 1);//把日期的天数加一，用来表示交货时间为一天内
			java.sql.Date sdate2 = new java.sql.Date(adddate.getTime().getTime());
			DBConnect dbconnect = new DBConnect();
			dbconnect.prepareStatement("insert into My_indent (indentno,username,submittime,consignmenttime,content,ispayoff,issales) values (?,?,?,?,?,?,?)");
			dbconnect.setString(1, dateno);
			dbconnect.setString(2, user.GetUsername());
			dbconnect.setDate(3, sdate);
			dbconnect.setDate(4, sdate2);
			dbconnect.setString(5, s1);
			dbconnect.setInt(6, 0);
			dbconnect.setInt(7, 0);
			dbconnect.executeUpdate();
			
			//生成账单的编号
			long l = 0;
			String no = "";
			dbconnect.prepareStatement("select id from My_indent where username=? and indentno=?");
			dbconnect.setString(1, user.GetUsername());
			dbconnect.setString(2, dateno);
			ResultSet resultset = dbconnect.executeQuery();
			if(resultset.next())
			{
				long l2 = 0;
				l = resultset.getLong("id");
				if(l<1000000)
				{
					l2 = l + 1000000;
				}
				no = dateno + String.valueOf(l2).substring(1,7);
			}
			else
			{
				s += "The indent data was lost!";
				flag = true;
			}
			
			//把购物车中各项货物入库，并统计价钱
			if(!flag)
			{
				IndentList indentlist;
				float totalprice = 0;
				for(int i=0; i<basketrs.length; i++)
				{
					if(basketrs[i]!=null)
					{
						indentlist = new IndentList();
						indentlist.SetIndentNO(no);
						indentlist.SetBookNO(basketrs[i]);
						indentlist.SetAmount(basket.getQuantity(basketrs[i]));
						indentlist.AddIndentList();
						Book book = new Book();
						book = Book.LoadBook("bookno",basketrs[i],false);
						totalprice += book.GetPrince() * basket.getQuantity(basketrs[i]);
					}
				}
				dbconnect.prepareStatement("update My_indent set indentno=?, totalprice=? where id=?");
				dbconnect.setString(1, no);
				dbconnect.setFloat(2, totalprice);
				dbconnect.setLong(3, l);
				dbconnect.executeUpdate();
			}
			dbconnect.close();
		}
		
		if(flag)
		{
			throw new Exception(s);
		}
	}
	
	public Vector LoadIndent() throws Exception
	{
		String s = "";
		boolean flag = false;
		Vector vector = new Vector();

		if(!flag)
		{
			DBConnect dbconnect = new DBConnect();
			dbconnect.prepareStatement("select * from My_indent");
			Indent indent;
			for(ResultSet resultset=dbconnect.executeQuery(); resultset.next();vector.add(indent))
			{
				indent = new Indent();
				indent.SetId(resultset.getLong("id"));
				indent.SetIndentNO(resultset.getString("indentno"));
				indent.SetUsername(resultset.getString("username"));
				indent.SetSubmitTime(resultset.getString("submittime"));
				indent.SetConsignmentTime(resultset.getString("consignmenttime"));
				indent.SetTotalPrice(resultset.getFloat("totalprice"));
				indent.SetContent(resultset.getString("content"));
				indent.SetIsPayoff(resultset.getInt("ispayoff"));
				indent.SetIsSales(resultset.getInt("issales"));
			}
			dbconnect.close();
		}
		
		if(flag)
		{
			throw new Exception(s);
		}
		else
		{
			return vector;
		}
	}	
	
	public Vector LoadIndent(HttpServletRequest httpservletrequest) throws Exception
	{
		Vector vector = new Vector();
		String s = "";
		boolean flag = false;
		
		String s1 = ParamUtils.getString(httpservletrequest, "field","");
		String s2 = ParamUtils.getString(httpservletrequest, "keyword","");
		if(s1.equals("") || s1==null)
		{
			s1 = (String)httpservletrequest.getAttribute("field");
			
		}
		if(s2.equals("") || s2==null)
		{
			s2 = (String)httpservletrequest.getAttribute("keyword");
		}
		
		if(s1.equals("") || s1==null)
		{
			s = s + "You have not input the field!<Br>";
			flag = true;
		}
		if(s2.equals("") || s2==null)
		{
			s = s + "You have not input the keyword!<br>";
			flag = true;
		}
		
		if(!flag)
		{
			DBConnect dbconnect = new DBConnect();
			dbconnect.prepareStatement("select * from My_indent where " + s1 + "=?");
			if (s1.equals("id"))
			{
				dbconnect.setLong(1, Long.parseLong(s2));
			}
			else
			{
				dbconnect.setString(1, s2);
			}
			Indent indent;
			for(ResultSet resultset=dbconnect.executeQuery(); resultset.next();vector.add(indent))
			{
				indent = new Indent();
				indent.SetId(resultset.getLong("id"));
				indent.SetIndentNO(resultset.getString("indentno"));
				indent.SetUsername(resultset.getString("username"));
				indent.SetSubmitTime(resultset.getString("submittime"));
				indent.SetConsignmentTime(resultset.getString("consignmenttime"));
				indent.SetTotalPrice(resultset.getFloat("totalprice"));
				indent.SetContent(resultset.getString("content"));
				indent.SetIsPayoff(resultset.getInt("ispayoff"));
				indent.SetIsSales(resultset.getInt("issales"));
			}
			dbconnect.close();
		}
		
		if(flag)
		{
			throw new Exception(s);
		}
		else
		{
			return vector;
		}
	}

	public void DelIndent(HttpServletRequest httpservletrequest) throws Exception
	{
		String s = "";
		boolean flag = false;
		String s1 = ParamUtils.getString(httpservletrequest, "field", "");
		String s2 = ParamUtils.getString(httpservletrequest, "keyword", "");
		if(s1.equals("") || s1==null)
		{
			s1 = (String)httpservletrequest.getAttribute("field");
			
		}
		if(s2.equals("") || s2==null)
		{
			s2 = (String)httpservletrequest.getAttribute("keyword");
		}
		
		if(s1.equals("") || s1==null)
		{
			s = s + "You have not input the field!<br>";
			flag = true;
		}
		if(s2.equals("") || s2==null)
		{
			s = s + "You have not input the keyword!<br>";
			flag = true;
		}
		
		if(!flag)
		{						
			DBConnect dbconnect = new DBConnect();
			//先删除IndentList中相应的项
			Vector vector = LoadIndent(httpservletrequest);
			for(int i=0; i<vector.size(); i++)
			{
				Indent indent = (Indent) vector.elementAt(i);
				IndentList indentlist = new IndentList();
				httpservletrequest.setAttribute("field","indentno");
				httpservletrequest.setAttribute("keyword",indent.GetIndentNO());
				indentlist.DelIndentList(httpservletrequest);
			}

			dbconnect.prepareStatement("delete from My_indent where " + s1 + "=?");
			if (s1.equals("id"))
			{
				dbconnect.setLong(1, Long.parseLong(s2));
			}
			else
			{
				dbconnect.setString(1, s2);
			}
			dbconnect.executeUpdate();
			dbconnect.close();
		}
		
		if(flag)
		{
			throw new Exception(s);
		}
	}
	
	public boolean UpdateIndent(HttpServletRequest httpservletrequest) throws Exception
	{
		String s = null;
		boolean flag = false;
		String s0 = ParamUtils.getString(httpservletrequest, "id", "");
		String s1 = ParamUtils.getString(httpservletrequest, "ispayoff", "");
		String s2 = ParamUtils.getString(httpservletrequest, "issales", "");
		
		if(s0.equals("") || s0 == null)
		{
			s = s + "You have not input the indent's id!<br>";
			flag = true;
		}
		if(s1.equals("") || s1 == null)
		{
			s = s + "You have not input the value of 'IsPayoff'!<br>";
			flag = true;
		}
		if(s2.equals("") || s2 == null)
		{
			s = s + "You have not select the value of 'IsSales'!<br>";
			flag = true;
		}

		if(!flag)
		{
			//更新账单的信息
			DBConnect dbconnect = new DBConnect();
			dbconnect.prepareStatement("update my_indent set ispayoff=?,issales=? where id=?");
			dbconnect.setInt(1, Integer.parseInt(s1));
			dbconnect.setInt(2, Integer.parseInt(s2));
			dbconnect.setLong(3, Long.parseLong(s0));
			dbconnect.executeUpdate();
			dbconnect.close();
		}
		if(flag)
			throw new Exception(s);
		else
			return true;
	}
}