adminfreezdaccount.java

基于struts的电子银行系统,为网上用户提供存款,取款,转帐等服务,拥有后台处理系统

/*
 * Created on 2005-7-26
 *
 */
package banksystem.business;

/**
 * @author 曲本盛
 *
 * TODO Struts 项目实践
 */
import javax.sql.*;
import java.sql.*;

import banksystem.Constants;
public class AdminFreezdAccount {
    
    /**
	 * @param dataSource 数据源.
	 * @param gene 查询语句生成器.
	 */
	public void setAccountStatus(DataSource dataSource,SearchGene gene)throws SQLException,Exception{
		Connection con = null;
		PreparedStatement stat = null;
		try{
			con= dataSource.getConnection();
			stat = con.prepareStatement(gene.getFreezedUpdateStr());
			int rows = stat.executeUpdate();
			if(rows==0){
				throw new SQLException(Constants.UPDATE_FAILED);
			}
		}
		catch(SQLException e){
			throw e;
		}
		catch(Exception e){
			throw e;
		}
		finally{
			try{
				
				if(con!=null){
					con.close();
				}
				if(stat!=null){
					stat.close();
				}
			}
			catch(SQLException e){
				throw new SQLException(e.getMessage());
			}	
		}
	}
}