dbshopcart.java

本系统实现了网上书店功能

package com.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Vector;

import javax.sql.DataSource;

import com.bean.Book;

public class DBShopCart {
	private DataSource ds;
	public DBShopCart(DataSource dataSource){
		this.ds= dataSource;
	}
	public int addItem(String bookId) throws SQLException{
		Connection con = ds.getConnection();
		String presql="select max(orderid) maxid from orderdetail";
		PreparedStatement pstmt = con.prepareStatement(presql);
		ResultSet rs = pstmt.executeQuery();
		int maxID=0;
		if(rs.next()){
			maxID=rs.getInt("maxid")+1;
		}
		rs.close();
		String presql_2 = "insert into orderdetail(orderid,bookid,amount) values(?,?,?)";
		pstmt = con.prepareStatement(presql_2);
		pstmt.setInt(1,maxID);
		pstmt.setString(2,bookId);
		pstmt.setInt(3,1);
		int flag = pstmt.executeUpdate();
		return flag;		
	}

}