subsystemlist.java

一个关于商业的网站

package com.everstar.usermanage;

import java.sql.*;
import java.io.*;
import java.util.ArrayList;
import com.everstar.database.*;

public class SubSystemList {

//	private static final String DELETE_SYSTEM_BY_ID = "delete from subsystem where subsystemid=?";
//	private static final String LOAD_SUBSYSTEM_ID = "select subsystemid from subsystem";

	private Database dbConn;

	public SubSystemList(Database dbConn)
	{
		this.dbConn = dbConn;
	}

	public  SubSystem createSubSystem(String subSystemName)
	{
		return new SubSystem(subSystemName, this,dbConn);
	}

	public SubSystem getSubSystem(int subSystemID)
	{
		return new SubSystem(subSystemID,  this,dbConn);
	}


	public  void removeSubSystem(int subSystemID)
	{
	   deletedb(subSystemID);
	}

	//return a SubSystemid list

	public int[] subSystemList()
	{
   	 	String LOAD_SUBSYSTEM_ID = "select systemid from subsystem";
        ArrayList tempArrayList = new ArrayList();
        try
        {
        	ResultSet rs =dbConn.select(LOAD_SUBSYSTEM_ID);
        	while(rs.next())
        	{
	        	tempArrayList.add(new Integer(rs.getInt(1)));
        	}
        	rs.close();
        	dbConn.close();
		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();
        }

		int[] listSystemArray = new int[tempArrayList.size()];
		for (int i = 0;i < listSystemArray.length; i++  )
		{
			listSystemArray[i] = ((Integer)tempArrayList.get(i)).intValue();
		}
		return listSystemArray;

	}


	//delete from Userid
	private void deletedb(int ID)
	{
        try
        {
			 String DELETE_SYSTEM_BY_ID = "delete from subsystem where systemid="+ID;
        	int i=dbConn.delete(DELETE_SYSTEM_BY_ID);
		}
        catch( Exception sqle )
        {
            sqle.printStackTrace();
        }
	}



}