albumtable.java

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

package huitong.util.db;

import huitong.javabean.*;
import huitong.util.*;
import java.util.*;
import java.sql.*;
public class AlbumTable 
{
	public boolean addAlbum(UserAlbum album)
	{//添加到数据库中，并建立相应的文件夹
        if (album == null)
        {
        	System.out.println("in AlbumTable on addAlbum: param is null.");
        	return false;
        }
		String insertSQL = "insert into album (albumId,ownerId,albumName,albumDesc," +
				           "albumType,albumState,albumCheck) " +
				           "values ("+"'"+album.getAlbumId()+"',"+"'"+album.getOwnerId()+"',"+
				           "'"+album.getAlbumName()+"',"+"'"+album.getAlbumDesc()+"',"+
				           album.getAlbumType()+","+album.getAlbumState()+","+album.getAlbumCheck()+
				           ")";
		System.out.println("AlbumTable in addAlbum() "+insertSQL);
		if (new Connecter().insert(insertSQL))
		{
			new Folder().create(album.getOwnerId()+"\\"+album.getAlbumId());
			return true;
		}
		return false;
	}
    public boolean delAlbum(String albumId,String ownerId)
    {//把访问状态设置为-1，
    	if (albumId== null ){return false;}
    	String delSQL = "delete from album where albumId='"+albumId+"' and ownerId='"+ownerId+"'";
    	System.out.println("AlbumTable in delAlbum() "+delSQL);
    	if (new Connecter().delete(delSQL))
    	{
    		new Folder().del(ownerId+"\\"+albumId);
    		return true;
    	}
    	return false;
    }
    public boolean update(UserAlbum album)
    {
    	
    	return false;
    }
    public Iterator<UserAlbum> getAlbums(String userName)
    {
    	if (userName == null) return null;
    	
    	HashSet set = new HashSet();
    	String querySQL = "select * from album where ownerId='"+userName+"'";
    	System.out.println("AlbumTable in getAlbums() "+querySQL);
    	ResultSet result = new Connecter().getResultSet(querySQL);
    	UserAlbum album = null;
    	try 
    	{
    		int count = 0;
    		if (result == null) return null;
    		while (result.next())
    		{
    			count++;
    			album = UserAlbum.getAlbum(result);
    			set.add(album);
    		}
    		System.out.println(count+" count");
    	}
    	catch (SQLException e)
    	{
    		e.printStackTrace();
    	}
    	return set.iterator();
    }
    public UserAlbum getAlbum(String albumId,String userName)
    {
    	if (albumId == null && userName == null)
    	{
    		return null;
    	}
    	String sql = " select * from album where albumId like '"+ albumId+"%' and ownerId like '"+ userName+"%'";
    	System.out.println(" AlbumTable in getAlbum " + sql);
    	ResultSet result = new Connecter().getResultSet(sql);
    	UserAlbum album = null;
    	try
    	{
    		if (result != null && result.next())
        	{
        		 album =  UserAlbum.getAlbum(result);
        		 System.out.println(" AlbumTable in getAlbum " +album.getAlbumName());
        		 return album;
        	}
    	}
    	catch (SQLException e)
    	{
    		e.printStackTrace();
    	}
    	return null;
    }
    public boolean setAccess(UserAlbum album,String accessPwd,int check)
    {
    	return false;
    }
    public void setState(UserAlbum album,int state)
    {
    	if (album == null) return;
    	album.setAlbumState(state);
    }
    public Iterator<UserAlbum> getAlbumNames(String userName)
    {
    	if (userName == null)
    	{
    		return null;
    	}
    	HashSet set = new HashSet();
    	String sql = "select albumId,albumName from album where ownerId='"+userName+"'";
    	System.out.println(" AlbumTable in getAlbumNames " + sql);
    	ResultSet result = new Connecter().getResultSet(sql);
    	try
    	{
    		UserAlbum album = null;
    		while (result.next())
        	{
    			album = new UserAlbum(result.getString("albumId"));
    			album.setAlbumName(result.getString("albumName"));
        	    set.add(album);	
        	}	
    	}
    	catch (SQLException e)
    	{
    		e.printStackTrace();
    	}
    	
    	return set.iterator();
    }
    
    public int  modify(UserAlbum album,String userName)
    {
    	if (album == null || userName == null)
    	{
    		return  0;
    	}
        String sql = " update album set albumName='"+album.getAlbumName()+"',albumDesc='"+album.getAlbumDesc()+"',albumType='"+album.getAlbumType()+"'" +
        		"   where albumId like '"+album.getAlbumId()+"%' and ownerId like '"+ album.getOwnerId()+"%'";
        System.out.println(" AlbumTable in modify " + sql);
        return new Connecter().update(sql);
    }
    public String encoding(String str)
	{
		try
		{
			return str = new String(str.getBytes("iso-8859-1"));
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		return null;
	}
    
}