AlbumServlet.java

package service.servlet;

import java.io.IOException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import service.Album;

public class AlbumServlet extends CommonServlet
{

	@Override
	protected void execute(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException
	{

		try
		{
			
			String uid = request.getParameter("uid");
			PreparedStatement preparedStatement = null;
			String sql = "";
			List<Album> albums = new ArrayList<Album>();
			if("".equals(uid)){
				sql = "select distinct(al.id),al.*,p.photo_filename from t_kx_albums al"+
								" left join t_kx_photos p on p.album_id = al.id" +
								" where email= ? " + 
								" group by al.id";
				preparedStatement = mConnection
						.prepareStatement(sql);
				preparedStatement.setString(1, mUsername);
				ResultSet rs = preparedStatement.executeQuery();
				if(!rs.next()){
					String create_sql = "insert into t_kx_albums(email, album_name, description) values(?,?,?)";
					preparedStatement = mConnection
							.prepareStatement(create_sql);
					String albumName = "�ֻ����";
					String description = "�ֻ����";

					preparedStatement.setString(1, mUsername);
					preparedStatement.setString(2, albumName);
					preparedStatement.setString(3, description);

					preparedStatement.execute();
					preparedStatement = mConnection
							.prepareStatement(sql);
					preparedStatement.setString(1, mUsername);
				}
			}else{
				sql = "select distinct(al.id), al.*, p.photo_filename from t_kx_users u"+
					        " left join t_kx_albums al ON al.email = u.email"+
					        " left join t_kx_photos p ON p.album_id = al.id"+
							" where u.id = ?"+
							" group by al.id";
				preparedStatement = mConnection
						.prepareStatement(sql);
				preparedStatement.setString(1, uid);
			}
			
			ResultSet rs = preparedStatement.executeQuery();
			while (rs.next())
			{
				Album album = new Album();
				album.setId(rs.getInt("id"));
				album.setName(rs.getString("album_name"));
				album.setEmail(rs.getString("email"));
				album.setDescription(rs.getString("description"));
				album.setImage(rs.getString("photo_filename"));
				albums.add(album);
			}

//			sendObject(albums, response);
			sendJSON(albums, response);
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}

}