DiariesServlet.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.Diary;

public class DiariesServlet extends CommonServlet
{

	@Override
	protected void execute(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException
	{
		List<Diary> diaries = new ArrayList<Diary>();
		try
		{
			String uid = request.getParameter("uid");
			String sql = "";
			PreparedStatement preparedStatement = null;
			if("".equals(uid)){
				sql = "select d.*, u.avatar from t_kx_diary d " +
						"left join t_kx_users u on u.email = d.email "+
						"where d.email=? order " +
						"by modify_date desc";
				preparedStatement = mConnection
							.prepareStatement(sql);
				preparedStatement.setString(1, mUsername);
			}else{
				sql = "SELECT d.*,u.id, u.avatar FROM t_kx_users u "+
							"inner join t_kx_diary d on d.email = u.email " + 
							"where u.id = ? order by modify_date desc";
				preparedStatement = mConnection
						.prepareStatement(sql);
				preparedStatement.setString(1, uid);
			}
			

			ResultSet rs = preparedStatement.executeQuery();

			while (rs.next())
			{
				Diary diary = new Diary();
				diary.setId(rs.getInt("id"));
				diary.setTitle(rs.getString("title"));
				diary.setFilename(rs.getString("filename"));
				diary.setUsername(rs.getString("username"));
				diary.setTime(rs.getString("modify_date"));
				diary.setContent(rs.getString("content"));
				diary.setComment_count(rs.getInt("comment_count"));
				diary.setLike_count(rs.getInt("like_count"));
				diary.setAvatar(rs.getString("avatar"));
				diaries.add(diary);
			}

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

}