实现效果
项目结构
代码部分
NewInfo.java部分
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
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 util.SqlServerConnection;
@WebServlet("/NewInfo")
public class NewInfo extends HttpServlet {
private static final long serialVersionUID = 1L;
public NewInfo() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;charset=utf-8");
Connection conn = null;
PreparedStatement pst = null;
ResultSet rst = null;
int row = 10;
int start = 0;
PrintWriter out = response.getWriter();
String startpoint = request.getParameter("start");
// 输出数据格式
String output = "<tr style='height:100px'><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>";
try {
conn = SqlServerConnection.sql_connection();
// 要在ResultSet查询结果集中进行指针移动,那么在创建PreparedState