initialize.java

来自「基于corba的资源池,实现了实例池供客户端调用,并且实例池对实例的分配采用策略」· Java 代码 · 共 41 行

//初始化数据库数据程序
import database.*;

public class Initialize 
{
	public static void main(String[] args)
	{
		
		String DatabaseSource ="jdbc:odbc:BankingDataSource";
		DatabaseAccess da = new DatabaseAccess(DatabaseSource);		
		
		try{			
			for(int id = 0; id<10000; id++)	
			{
				int bal = (int)(Math.random() * 10000);
				String sql = null;
				if(id<10){
					sql = "INSERT INTO Accounts VALUES ('000000000" + id + "','000" + id  + "'," +  bal +");"; 
				}else if(id>=10&&id<100){
					sql = "INSERT INTO Accounts VALUES ('00000000" + id + "','00" + id  + "'," +  bal +");"; 
				}else if(id>=10&&id<1000){
					sql = "INSERT INTO Accounts VALUES ('0000000" + id + "','0" + id  + "'," +  bal +");"; 
				}else {
					sql = "INSERT INTO Accounts VALUES ('000000" + id + "','" + id  + "'," +  bal +");"; 
				}
				da.update(sql);
			}
			da.close();
		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
			try{
				da.close();
			}catch(Exception e){
				e.printStackTrace();
			}
		}
	}
}