AuthMessageServlet.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.VoiceResult;

public class AuthMessageServlet extends CommonServlet
{
	@Override
	protected void execute(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException
	{
		String mid = request.getParameter("mid");
		try
		{
			String sql = "select gold from t_kx_users where email = ?";
			PreparedStatement preparedStatement = mConnection.prepareStatement(sql);
			preparedStatement.setString(1, mUsername);
			ResultSet rs = preparedStatement.executeQuery();
			if(rs.next()){
				if(rs.getInt("gold") < 10){
					sendJSON(false, "��Ҳ���,��ǰ�����Ŀ"+ rs.getInt("gold") +"��ȥ������ͼƬ׬��Ұɣ�", response);
					return;
				}
				sql = "update t_kx_users set gold = gold - ? where email = ?";
				preparedStatement = mConnection.prepareStatement(sql);
				preparedStatement.setInt(1, 10);
				preparedStatement.setString(2, mUsername);
				preparedStatement.execute();
				sql = "update t_kx_sms set state = 1 where id = ? ";
				preparedStatement = mConnection.prepareStatement(sql);
				preparedStatement.setString(1, mid);
				preparedStatement.execute();
			}
			
			sendJSON(true, "��Ҽ���10����Ϣ�ĺ󼴷�", response);
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		
	}

}