orderoperation.java

主要是用net开发的 用mvc模式 有酒店管理

/*
 * y2javaee.sg.ch05.OrderOperation.java
 * 2007-6-13
 * 第5章的Java示例，将用户的订单存入数据库
 */
package com.apache.dao;

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

import com.apache.pojo.BookOrder;
import com.apache.pojo.Creditcart;

public class OrderOperation {
	/**
	 * 插入订单信息到数据库
	 * 
	 * @return
	 */
	public int saveOrder(BookOrder order) {
		int result = 0;
		Connection con = null;
		PreparedStatement pStatement = null;

		try {
			con = ConnectionManager.getConnction();
			String strSql = "insert into BookOrder(username,zipcode,phone,"
					+ "creditcard,total) values(?,?,?,?,?)";
			pStatement = con.prepareStatement(strSql);
			pStatement.setString(1, order.getUser().getName());
			pStatement.setString(2, order.getZipcode());
			pStatement.setString(3, order.getPhone());
			pStatement.setString(4,order.getCreditcart().getCreditcart());
			pStatement.setDouble(5,order.getTotal());
			System.out.println(strSql);
			result = pStatement.executeUpdate();
		} catch (SQLException sqlE) {
			sqlE.printStackTrace();
		} finally {
			ConnectionManager.closeStatement(pStatement);
			ConnectionManager.closeConnection(con);
		}
		return result;
	}
	//获得信用卡
	public Creditcart getCreditcartById(String cartId)
	{
		Creditcart cart=null;
		Connection con = null;
		PreparedStatement pStatement = null;
		ResultSet res=null;
		try {
			con = ConnectionManager.getConnction();
			String sql="select * from Account where creditcard=?";
			pStatement=con.prepareStatement(sql);
			pStatement.setString(1, cartId);
			res=pStatement.executeQuery();
			if(res.next())
			{
				cart=new Creditcart();
				cart.setId(res.getInt("id"));
				cart.setBalance(res.getDouble("balance"));
				cart.setCreditcart(res.getString("creditcard"));
				System.out.println("存在此卡号");
			}else
			{
				System.out.println("不存在此卡号");
			}
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}finally
		{
			ConnectionManager.closeResultSet(res);
			ConnectionManager.closeStatement(pStatement);
			ConnectionManager.closeConnection(con);
		}
		return cart;
	}
}