booksdao.java

网上书城 购物车 创建SESSION等 具体网上书城 类库

package com.wl.db.dao;
import java.sql.*;

import com.wl.db.DBManager;
import com.wl.db.vo.Books;
import java.util.*;


public class BooksDAO {
	public BooksDAO(){
		
	}
	//添加商品
	public void Add_book(Books book) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="insert into T_books values (?,?,?,?,?,?,?,?,?)";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setString(1, book.getBooks_name());
		pt.setInt(2, book.getType());
		pt.setFloat(3,book.getBooks_price());
		pt.setFloat(4, book.getBooks_discount());
		pt.setString(5, book.getBooks_dis());
		pt.setString(6, book.getSupplier());
		pt.setInt(7, book.getHavebooks());
		pt.setBoolean(8, book.isIspreferred());
		pt.setString(9, book.getBooks_pictuer());
		pt.executeUpdate();
		db.closeConnection();
	}
	//修改商品
	public void Updata_book(Books book) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="update T_books set books_name=?,type=?,books_price=?,books_discount=?," +
				"books_dis=?,supplier=?,havebooks=?,ispreferred=?,books_pictuer=?"+
				" where books_id="+book.getBooks_id()+"";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setString(1, book.getBooks_name());
		pt.setInt(2, book.getType());
		pt.setFloat(3,book.getBooks_price());
		pt.setFloat(4, book.getBooks_discount());
		pt.setString(5, book.getBooks_dis());
		pt.setString(6, book.getSupplier());
		pt.setInt(7, book.getHavebooks());
		pt.setBoolean(8, book.isIspreferred());
		pt.setString(9, book.getBooks_pictuer());
		pt.executeUpdate();
		db.closeConnection();
	}
	//删除商品
	public void Dele_book(int bookID) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="delete from T_books where books_id=?";
		PreparedStatement pt=db.getCallableStatement(sql);
		pt.setInt(1,bookID);
		pt.executeUpdate();
		db.closeConnection();
	}
	//查询所有商品
	public Vector showAllbooks() throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		Vector v1=new Vector();
		String sql="select * from T_books";
		ResultSet rs=db.executeQuery(sql);
		while(rs.next()){
			Books book=new Books();
			book.setBooks_id(rs.getInt("books_id"));
			book.setBooks_name(rs.getString("books_name"));
			book.setType(rs.getInt("type"));
			book.setBooks_price(rs.getFloat("books_price"));
			book.setBooks_discount(rs.getFloat("books_discount"));
			book.setBooks_dis(rs.getString("books_dis"));
			book.setSupplier(rs.getString("supplier"));
			book.setHavebooks(rs.getInt("havebooks"));
			book.setIspreferred(rs.getBoolean("ispreferred"));
			book.setBooks_pictuer(rs.getString("books_pictuer"));
			v1.add(book);
		}
		return v1;
	}
	//查询选择商品
	public Vector showSelectedbooks(int bookID) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		Vector v1=new Vector();
		String sql="select * from T_books where books_id="+bookID+"";
		Books book=new Books();
		ResultSet rs=db.executeQuery(sql);
		while(rs.next()){
			book.setBooks_id(rs.getInt("books_id"));
			book.setBooks_name(rs.getString("books_name"));
			book.setType(rs.getInt("type"));
			book.setBooks_price(rs.getFloat("books_price"));
			book.setBooks_discount(rs.getFloat("books_discount"));
			book.setBooks_dis(rs.getString("books_dis"));
			book.setSupplier(rs.getString("supplier"));
			book.setHavebooks(rs.getInt("havebooks"));
			book.setIspreferred(rs.getBoolean("ispreferred"));
			book.setBooks_pictuer(rs.getString("books_pictuer"));
			v1.add(book);
		}
		return v1;
	}
	public Books showSelectedbooks1(int bookID) throws ClassNotFoundException, SQLException{
		DBManager db=new DBManager();
		String sql="select * from T_books where books_id="+bookID+"";
		Books book=new Books();
		ResultSet rs=db.executeQuery(sql);
		while(rs.next()){
			book.setBooks_id(rs.getInt("books_id"));
			book.setBooks_name(rs.getString("books_name"));
			book.setType(rs.getInt("type"));
			book.setBooks_price(rs.getFloat("books_price"));
			book.setBooks_discount(rs.getFloat("books_discount"));
			book.setBooks_dis(rs.getString("books_dis"));
			book.setSupplier(rs.getString("supplier"));
			book.setHavebooks(rs.getInt("havebooks"));
			book.setIspreferred(rs.getBoolean("ispreferred"));
			book.setBooks_pictuer(rs.getString("books_pictuer"));
		}
		return book;
	}
}