package basic_package;

import java.sql.Connection;
import java.util.ArrayList;

import main_package.DataBaseConnection;
import main_package.DataBaseMethods;
import main_package.UserInfo;

public class MyTestSavingAccountGenerate {

	public static void main(String[] args) 
	{
		DataBaseMethods obj=new DataBaseMethods();
		Connection conn=DataBaseConnection.JAVAConnection();
		int branchId=2;
		
		ArrayList<UserInfo> list = obj.allShareHolders(branchId,"all", conn);
		for(UserInfo uu: list)
		{
			String accountNo=obj.savingAccountNo(branchId); 
			
			obj.addSavingAcount(branchId,uu.getShareHolderNo(),accountNo,uu.getOffice_date(),0,0,0,0,0,uu.getDsaCode(),uu.getCenterId());
		}
		
		
		// three change 1. allShareHolders method me header bean, 2. order by desc, 3.  addSavingAcount method me session user id
	}

}
