MySlaveVoicesServlet.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 MySlaveVoicesServlet extends CommonServlet
{
	@Override
	protected void execute(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException
	{
		try
		{
			
			String email = request.getParameter("email");
			String sql = "select v.* from t_kx_voices v "+
						" where binary email= ? and state = 0 order by time desc"; 
			PreparedStatement preparedStatement = mConnection.prepareStatement(sql);
			preparedStatement.setString(1, email);

			ResultSet rs = preparedStatement.executeQuery();
	
			List<VoiceResult> slaves = new ArrayList<VoiceResult>();
			while(rs.next())
			{
				VoiceResult slave = new VoiceResult();
				slave.setName(rs.getString("email"));
				slave.setVid(rs.getString("id"));
				slave.setUrl(rs.getString("filename"));
				slave.setTime(rs.getString("time"));
				slave.setInfo(rs.getString("calling_number") + "-" + rs.getString("called_number"));
				slaves.add(slave);
			}
			sendJSON(slaves, response);
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
		
	}

}