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.PhotoDetailResult;
public class DiaryLikeServlet extends CommonServlet
{
@Override
protected void execute(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{
try
{
int diaryId = Integer.parseInt(request.getParameter("diaryId"));
System.out.println(diaryId + "==========dlike");
String sql = "update t_kx_diary set like_count = like_count + 1 where id = ? ";
PreparedStatement preparedStatement = mConnection
.prepareStatement(sql);
preparedStatement.setInt(1, diaryId);
preparedStatement.execute();
// sendObject(photoDetailResults, response);
response.getWriter().println("�ɹ�");
sql = "update t_kx_users set gold = gold + ? where email = ?";
preparedStatement = mConnection
.prepareStatement(sql);
preparedStatement.setInt(1, 5);
preparedStatement.setString(2, mUsername);
preparedStatement.execute();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}