processcreditcard.java

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

/*
 * y2javaee.sg.ch09.ProcessCreditCard.java
 * 2007-6-16
 * 第9章的Java示例，演示Web服务
 */
package com.apache.dao;

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

import com.apache.pojo.Creditcart;

public class ProcessCreditCard {
	public int creditProcess(String creditCard, double total){
		int result = 0;
		Connection con = null;
		PreparedStatement pStatement = null;

		try {
			con = ConnectionManager.getConnction();
			String strSql = "update Account "
					+ "set balance = balance - ? where creditcard = ?";
			pStatement = con.prepareStatement(strSql);
			pStatement.setDouble(1, total);
			pStatement.setString(2, creditCard);
			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;
	}
	
}