typetable.java

这是基于jsp的相册管理系统。数据库是mysql

package huitong.util.db;

import java.util.*;
import java.sql.*;
import huitong.javabean.*;
import huitong.util.db.*;
public class TypeTable 
{
    public void addType(int albumTypeId,String albumName)
    {
    	if (albumName == null)
    	{
    		return;
    	}
    	String insertSQL = "insert into album_type(albumTypeId,albumName)" +
    			"values(" +albumTypeId+",'"+albumName+"'"+")";
    	System.out.println("in TypeTable addType() " + insertSQL);
    	new Connecter().insert(insertSQL);    	
    }
    
    public Iterator<AlbumType> getAlbumTypes()
    {
    	String querySQL = "select * from album_type";
    	System.out.println(" in TypeTable getAlbumType() " + querySQL);
    	ResultSet result = new Connecter().getResultSet(querySQL);
    	if (result == null )
    	{
    		return null;
    	}
    	try
    	{
    		HashSet set = new HashSet();
    		while (result.next())
        	{
        		set.add(AlbumType.getAlbumType(result));
        	}
    		return set.iterator();
    	}
    	catch (SQLException e)
    	{
    		e.printStackTrace();
    	}
    	
    	return null;
    }
    public static void main(String[] agrs)
    {
    	Iterator<AlbumType>  iter = new TypeTable().getAlbumTypes();
    	if (iter != null)
    	{
    		while (iter.hasNext())
    		{
    			System.out.println(iter.next().getAlbumTypeId());
    		}
    	}
    	
    }
}