orderlist.java

来自「网上购物源代码」· Java 代码 · 共 55 行

package com.chinaaccpDao;

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

import com.chinaaccpbean.OrderListbeen;


public class OrderList {
	public ArrayList<OrderListbeen> getAllOrdeList()	{
		
		ArrayList<OrderListbeen> list=new ArrayList<OrderListbeen>();
		try {
			String sDBDriver="com.mivrosoft.jdbc.sqlserver.SQLServerDriver";
			Class.forName("sDBDriver");
			String sConnStr="jdbc.microsoft:sqlserver://127.0.0.1:1433:DatabaseName=shopping";
			String name="sa";
			Connection connshop=DriverManager.getConnection(sConnStr, name, "");
			Statement st=connshop.createStatement();
			String sql="select OrderListNum,UserInfoId,Orderdate,Name,IDNum,Postcode,Address,Email,Tel,Totalfee,Ispay,Issend form OrderList"; 
					
			ResultSet rs=st.executeQuery(sql);
			while(rs.next())
			{
				OrderListbeen ol=new OrderListbeen();
				ol.setID("ID");
				ol.setAddress("address");
				ol.setEmail("email");
				ol.setIDNum("num");
				ol.setIspay("ispay");
				ol.setIssend("issend");
				ol.setName("name");
				ol.setOrderdate("orderdate");
				ol.setOrderListNum("orderListNum");
				ol.setPostcode("postcode");
				ol.setTel("tel");
				ol.setTotalfee("totalfee");
				ol.setUserInfoId("userInfoId");
				list.add(ol);
			
			}
			rs.close();
			st.close();
		
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}

}