shoppinglistdao.java

系统分为用户模块和管理员模块两大部分。 普通用户只能查看、搜索和购买图书。搜索有按书籍的类别、书籍名称、出版社名称、上架时间等条件的查询。购买方式有选择邮递和特快等方式。购物车的设计有记录某用户购买

/**
 * 
 */
package com.jstu.dao;

import java.sql.*;

import bookshop.base.BaseDTO;
import bookshop.tools.exception.MyException;

import com.jstu.dto.ShoppingListDTO;
import com.jstu.util.DBUtil;

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

	Connection conn=DBUtil.getConnection();
	PreparedStatement ps=null;
	ResultSet rs=null;
	
	public ShoppingListDTO show() throws MyException{
		
		ShoppingListDTO shoppingList=new ShoppingListDTO();
		String sql="select * from shoppinglist";
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				shoppingList.setBaoZhuang(rs.getInt(9));
				shoppingList.setBookPrice(rs.getDouble(5));
				shoppingList.setDelflg(rs.getInt(7));
				shoppingList.setDeliverStyle(rs.getString(8));
				shoppingList.setId(rs.getInt(1));
				shoppingList.setPayPattern(rs.getString(10));
				shoppingList.setSubmitTime(rs.getDate(4));
				shoppingList.setTotalPrice(rs.getDouble(6));
				shoppingList.setUserId(rs.getInt(2));
				shoppingList.setUserName(rs.getString(3));
				
			}
		} catch (SQLException e) {
			throw new MyException("查询订单数据库时失败!");
			
		}
		return shoppingList;		
	}
	
	public void add(BaseDTO baseDTO) throws MyException{
		
		
	}
	
	public void delete(BaseDTO baseDTO) throws MyException{
		
		
	}
	
	public void update(BaseDTO baseDTO) throws MyException{
		
		
	}
}