Ajax-ajax实例1-动态加载的 FAQ

);return false;">
	
" style="display: none;">
	

package com.gordon.servlet;

import java.io.IOException;

import javax.servlet.Servlet;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.gordon.service.GetAnswerDetailService;

/**
 * 获取FAQ问题详情
 */
@WebServlet(urlPatterns = { "/GetFaqDetailServlet" })
public class GetFaqDetailServlet extends HttpServlet {
	
	private static final long serialVersionUID = 1L;

	/**
	 * @see HttpServlet#HttpServlet()
	 */
	public GetFaqDetailServlet() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * @see Servlet#init(ServletConfig)
	 */
	public void init(ServletConfig config) throws ServletException {
		// TODO Auto-generated method stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		
		String question = ""; 
		
		request.setCharacterEncoding("UTF-8");
		response.setContentType("text/text;charset=utf-8;");
		
		String answerid = request.getParameter("answerid");
		
		try {
			question = GetAnswerDetailService.getAnswerDetailById(answerid);
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		
		response.getWriter().print(question);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
	 *      response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

package com.gordon.service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.gordon.util.DBUtil;

public class GetAnswerDetailService {
	
	/**
	 * 根据问题id获取解答信息
	 * @param answerid
	 * @return
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public static String getAnswerDetailById(String answerid) throws ClassNotFoundException, SQLException {

		String result = "";

		Connection conn = DBUtil.getConnection();
		
		String sql = "SELECT question FROM faqdetail WHERE id = ?";
		
		PreparedStatement pst = conn.prepareStatement(sql);
		pst.setInt(1, Integer.valueOf(answerid));
		
		ResultSet rs = pst.executeQuery();
		while (rs.next()) {
			result = rs.getString("question");
		}

		rs.close();
		pst.close();
		conn.close();

		return result;
	}
}

package com.gordon.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtil {
	
	private static final String URL = "jdbc:mysql://localhost:3306/ajaxexample_1";
	private static final String DRIVER = "com.mysql.jdbc.Driver";
	private static final String USERNAME = "root";
	private static final String PASSWORD = "root";

	public static Connection getConnection() throws ClassNotFoundException, SQLException {
		Class.forName(DRIVER);
		return DriverManager.getConnection(URL, USERNAME, PASSWORD);
	}
}