photodao.java

我的博客

package com.yxq.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.yxq.toolsbean.DB;
import com.yxq.valuebean.PhotoBean;

public class PhotoDao
{
	private DB connection = null;

	public PhotoDao()
	{
		connection = new DB();
	}

	public boolean operationPhoto(String operation, PhotoBean single)
	{
		String sql = "";
		if (operation.equals("delete"))
			sql = "delete from tb_photo where id=" + single.getId();
		if (operation.equals("upload"))  // 上传
			sql = "insert into tb_photo values ('" + single.getPhotoAddr()
					+ "','" + single.getPhotoTime() + "','" + single.getPhotoInfo() + "')";
					
		boolean mark = connection.executeUpdate(sql);
		return mark;
	}
	
	// 根据 文章 的 id 查找
	public PhotoBean queryPhoto(int id)
	{
		PhotoBean photoBean = null;
		String sql = "select * from tb_photo where id=" + id;
		ResultSet rs = connection.executeQuery(sql);
		try
		{
			if (rs.next())
			{
				photoBean = new PhotoBean();
				photoBean.setId(rs.getInt(1));
				photoBean.setPhotoAddr(rs.getString(2));
				photoBean.setPhotoInfo(rs.getString(3));
				photoBean.setPhotoTime(rs.getString(4));
			}
		} catch (SQLException e)
		{
			e.printStackTrace();
		}
		return photoBean;
	}

	@SuppressWarnings("unchecked")
	public List queryPhoto(String type)
	{
		if (type == null || type.equals(""))
			type = "sub";
		String sql = "";
		if (type.equals("all"))
			sql = "select * from tb_photo order by photo_sdTime DESC";
		else
			sql = "select top 8 * from tb_photo order by photo_sdTime DESC";

		List list = null;
		PhotoBean photoBean = null;
		ResultSet rs = connection.executeQuery(sql);
		if (rs != null)
		{
			list = new ArrayList();
			try
			{
				while (rs.next())
				{
					photoBean = new PhotoBean();
					photoBean.setId(rs.getInt(1));
					photoBean.setPhotoAddr(rs.getString(2));
					photoBean.setPhotoTime(rs.getString(3));
					photoBean.setPhotoInfo(rs.getString(4));
					list.add(photoBean);
				}
			} catch (SQLException e)
			{
				e.printStackTrace();
			}
		}
		return list;
	}

	public int queryMaxId() // 查找最后一张照片
	{
		int maxId = 0;
		String sql = "select max(id) from tb_photo";
		ResultSet rs = connection.executeQuery(sql);
		if (rs != null)
		{
			try
			{
				if (rs.next())
					maxId = rs.getInt(1);
			} catch (SQLException e)
			{
				e.printStackTrace();
			} finally
			{
				connection.closed();
			}
		}
		return maxId;
	}
}