searchorderlistdao.java

网上购物源代码

/**
 * 
 */
package com.chinaaccpDao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.chinaaccpbean.SeachOrderListBean;

/**
 * @author Administrator
 *
 */
public class SearchOrderListDao {

	public ArrayList GetOrderListInfo(String userid) {
		
		ArrayList list = new ArrayList();
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "select id,orderlistnum,userinfoid,orderdate,name,idnum,postcode,address,email,tel,totalfee,ispay,issend from orderlist where userinfoid="+"(select id from userinfo where logname='"+userid+"') "+"order by orderdate desc";
			ResultSet rs = st.executeQuery(sql);
			while(rs.next())
			{
				SeachOrderListBean orderlist = new SeachOrderListBean();
				orderlist.setId(rs.getInt(1));
				orderlist.setOrdernum(rs.getString(2));
				orderlist.setUserid(rs.getInt(3));
				orderlist.setOrderdate(rs.getString(4));
				orderlist.setName(rs.getString(5));
				orderlist.setIdnum(rs.getString(6));
				orderlist.setPostcode(rs.getString(7));
				orderlist.setAddress(rs.getString(8));
				orderlist.setEmail(rs.getString(9));
				orderlist.setTel(rs.getString(10));
				orderlist.setTotalfee(rs.getString(11));
				orderlist.setIsspay(rs.getInt(12));
				orderlist.setIssend(rs.getInt(13));
				list.add(orderlist);
			}
			st.close();
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	
	public SeachOrderListBean GetSimpleOrder(String ordernum)
	{
		SeachOrderListBean simpleorder = new SeachOrderListBean();
		Connection con = null;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "select id,orderlistnum,userinfoid,orderdate,name,idnum,postcode,address,email,tel,totalfee,ispay,issend from orderlist where orderlistnum='"+ordernum+"'";
			ResultSet rs = st.executeQuery(sql);
			//System.out.println(ordernum);
			if(rs.next())
			{
				simpleorder.setId(rs.getInt(1));
				simpleorder.setOrdernum(rs.getString(2));
				simpleorder.setUserid(rs.getInt(3));
				simpleorder.setOrderdate(rs.getString(4));
				simpleorder.setName(rs.getString(5));
				simpleorder.setIdnum(rs.getString(6));
				simpleorder.setPostcode(rs.getString(7));
				simpleorder.setAddress(rs.getString(8));
				simpleorder.setEmail(rs.getString(9));
				simpleorder.setTel(rs.getString(10));
				simpleorder.setTotalfee(rs.getString(11));
				simpleorder.setIsspay(rs.getInt(12));
				simpleorder.setIssend(rs.getInt(13));
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		return simpleorder;
	}
}