utilcards.java

spring+struts+hibernate做的银行系统

/*
 * Created on 2006-3-25
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.tym.util.tablebean;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import cn.com.tym.admin.CardBean;
import cn.com.tym.pub.DB;
import cn.com.tym.util.text.DealText;
import cn.com.tym.util.text.ExchangeInput;

 

/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class UtilCards {
	
	
	//返回所有的卡号
	   public ArrayList cardIDAll(DB db)
	    throws SQLException
	{
	    
	     ArrayList list = new ArrayList();
	   	 	String strSql= "select card_id,card_name from mdh_cards"; 

	   	 	ResultSet rs = db.OpenSql(strSql);
 
	        while(rs.next())
	        {
	            CardBean bean=new CardBean();
	            bean.setCardId(rs.getInt("card_id"));
	            bean.setCardName(rs.getString("card_name"));
	   
	            list.add(bean);
	            bean = null;
	        }
	    return list; 
	}
	  
	 //删除卡号
	   
	   public boolean deleteCard(String id,DB db)
	    throws SQLException
	{
	   	int bid=ExchangeInput.StringToInt(id);
	       boolean bool=false;
	   	 	String strSql= "delete from mdh_cards where card_id='"+bid+"'"; 
	   	 	 if(db.ExecSql(strSql)!=0)
	   	 	 	bool=true;
	    return bool; 
	}
	   
	   //新增卡号
	   public boolean addCard(String cardName,DB db)
	    throws SQLException
	{
	    boolean bool=false;
	   	if(!cardName.equals("")){
	   	String name=ExchangeInput.StringToString(cardName);
	   			name=DealText.dealToSql(name);
	   
	   	 	String strSql= "insert into mdh_cards values('"+name+"')"; 
	   	 	 if(db.ExecSql(strSql)!=0)
	   	 	 	bool=true;
	   	}
	    return bool; 
	}
}