ordersdao.java

网上订餐系统

package com.newer.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

import com.newer.bean.OrdersBean;

public class OrdersDao {
	public Vector getAllOrders(){
		Vector vc=new Vector();
		Connection conn =ctxUtil.getConn();
		PreparedStatement pstmt=null;
		String sql="select * from orders";
		try {
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			int temp=0;
			while(rs.next()){
				OrdersBean ob=new OrdersBean();
				ob.setOrderID(rs.getInt("orderID"));
				ob.setOrderTitle(rs.getString("orderTitle"));
				ob.setOriginPrice(rs.getFloat("originPrice"));
				ob.setNowPrice(rs.getFloat("nowPrice"));
				ob.setOrderMemo(rs.getString("orderMemo"));
				ob.setOrderDetails(rs.getString("orderDetails"));
				ob.setPicURL(rs.getString("picURL"));
				ob.setOrderAddTime(rs.getString("orderAddTime"));
				vc.add(temp++,ob);
				
			}
		} catch (Exception e) {
			e.printStackTrace();
			return null;
			// TODO: handle exception
		}
		return vc;
		
	}

}