adminaction.java

存款、取款、账户明细、系统备份、修改密码

package admin.services.action;

import DBManager.SQLserver2000;

public class AdminAction {

	//添加管理员
	public boolean addAdmin(String adminName,String adminPassword , String adminIDcard){
		String insertAdminSQL = "insert into admin (username , password , idcard) values('" +
								adminName+"','"+adminPassword+"','"+adminIDcard+"')";
		System.out.println(insertAdminSQL);
		String insertMoneySQL = "insert into moneyMessage (idcard , moneyMessage) values('" +
								adminIDcard+"','0')";
		System.out.println(insertMoneySQL);
		
		int count = new SQLserver2000().getCount("管理员", adminIDcard);
		if(count ==1||count>1){
			return false;
		}
		System.out.println(count);
		boolean result = false ;
		result = new SQLserver2000().excuteSQL(insertAdminSQL);
		if(result == false){
			System.out.println("insertAdminSQL这里rollback了");
		}
		result = new SQLserver2000().excuteSQL(insertMoneySQL);
		if(result == false){
			new SQLserver2000().excuteSQL("rollback");
			System.out.println("insertMoneySQL这里rollback了");
		}
		return result;
	}
}