orderutil.java

使用servlet写的简单网上书店

package utils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import entity.Book;
import entity.Order;

public class OrderUtil {
	private Connection con=null;
	private PreparedStatement ps=null;
	private ResultSet rs=null;
	public OrderUtil(Connection con) {
		this.con = con;
	}
	public void insertOrder(){
		 try {		 
			 ps = con.prepareStatement("insert into order values(?,?,?)");
			 Order order=new Order();
			 Book book=new Book();
			 ps.setInt(1, book.getId());
			 ps.setInt(2, order.getId());
			 ps.setString(3, book.getName());
			 ps.setDouble(4, book.getPrice());
			 ps.executeUpdate();
			 
		 } catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				ps.close();
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}