albumphoto.java

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

package huitong.javabean;

import java.sql.*;
public class AlbumPhoto 
{
	private String photoId;
	private String photo_albumId;
	private String photoName;
	private String photoAlt;
	private String serviceMessage;
	private String photoSuffix;
	private String photoPath;
	public static AlbumPhoto getPhoto(ResultSet result,String userName)
	{
		if (result == null || userName == null)
		{
			return null;
		}
		AlbumPhoto photo = new AlbumPhoto();
		try
		{   
			photo.setPhotoId(result.getString("photoId"));
			photo.setPhoto_albumId(result.getString("photo_albumId"));
			photo.setPhotoName(result.getString("photoName"));
			photo.setPhotoAlt(result.getString("photoAlt"));
			photo.setServiceMessage(result.getString("serviceMessage"));
			photo.setPhotoSuffix(result.getString("photoSuffix"));
			photo.setPhotoPath("\\photo\\_userRoot\\"+userName+"\\"+photo.photo_albumId.substring(0,14)+"\\"+photo.photoId+"."+photo.photoSuffix);
			System.out.println("int AlbumPhoto dgf getPhoto " + photo.getPhotoPath());
		}
		catch (SQLException e)
		{
			e.printStackTrace();
		}
		System.out.println("in AlbumPhoto getPhoto() " + photo);
		return photo;
	}
	public String getPhotoPath() {
		return photoPath;
	}
	public void setPhotoPath(String photoPath) {
		this.photoPath = photoPath;
	}
	public String getPhoto_albumId() {
		return photo_albumId;
	}
	public void setPhoto_albumId(String photo_albumId) {
		this.photo_albumId = photo_albumId;
	}
	public String getPhotoAlt() {
		return photoAlt;
	}
	public void setPhotoAlt(String photoAlt) {
		this.photoAlt = photoAlt;
	}
	public String getPhotoId() {
		return photoId;
	}
	public void setPhotoId(String photoId) {
		this.photoId = photoId;
	}
	public String getPhotoName() {
		return photoName;
	}
	public void setPhotoName(String photoName) {
		this.photoName = photoName;
	}
	public String getServiceMessage() {
		return serviceMessage;
	}
	public void setServiceMessage(String serviceMessage) {
		this.serviceMessage = serviceMessage;
	}
	public String getPhotoSuffix() {
		return photoSuffix;
	}
	public void setPhotoSuffix(String photoSuffix) {
		this.photoSuffix = photoSuffix;
	}

}