通过ajax/servlet将数据库数据显示在页面上
-
数据库信息
-
web.xml
<servlet>
<description>This is the description of my J2EE component</description>
<display-name>This is the display name of my J2EE component</display-name>
<servlet-name>GetAllDesignReportServlet</servlet-name>
<servlet-class>SERVLET.GetAllDesignReportServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>GetAllDesignReportServlet</servlet-name>
<url-pattern>/GetAllDesignReportServlet.do</url-pattern>
</servlet-mapping>
- GetAllDesignReportServlet
package SERVLET;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.json.JSONException;
import org.json.JSONObject;
import DAO.DesignReportDAO;
public class GetAllDesignReportServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
DesignReportDAO dao=new DesignReportDAO();
ArrayList<JSONObject> array = null;
try {
array = dao.select_all();
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
response.setContentType("text/html;charset=utf-8");
PrintWriter pw = response.getWriter();
pw.print(array.toString());
}
}