registimpl.java

来自「存款、取款、账户明细、系统备份、修改密码」· Java 代码 · 共 55 行

package database.regist.impl;

import DBManager.SQLserver2000;
import database.regist.dao.Regist;

public class RegistImpl implements Regist {

	public boolean regist(String type, String username, String password,
			String IDcard) {
		String insertcustomerSQL = "insert into customer (username , password , idcard) values('" +
		username+"','"+password+"','"+IDcard+"')";
		System.out.println(insertcustomerSQL);
		String insertMoneySQL = "insert into moneyMessage (idcard , moneyMessage) values('" +
		IDcard+"','0')";
		System.out.println(insertMoneySQL);
		
		int count = new SQLserver2000().getCount("普通用户", IDcard);
		if(count ==1||count>1){
		return false;
		}
		System.out.println(count);
		boolean result = false ;
		result = new SQLserver2000().excuteSQL(insertcustomerSQL);
		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;
//		// TODO Auto-generated method stub
//		StringBuffer registBuffer = new StringBuffer("insert into ");
//		if("管理员".equals(type)){
//			registBuffer.append("admin");
//		}
//		else if("普通用户".equals(type)){
//			registBuffer.append("customer");
//		}
//		registBuffer.append("(username , password , IDcard) values('");
//		registBuffer.append(username);
//		registBuffer.append("','");
//		registBuffer.append(password);
//		registBuffer.append("','");
//		registBuffer.append(IDcard);
//		registBuffer.append("')");
//		boolean result = new SQLserver2000().excuteSQL(registBuffer.toString());
//		return result;
	}

	public static void main(String[] args) {
	}
}