<%@ page contentType="text/xml; charset=UTF-8"%>
<%@ page language="java"%>
<%@ page import="java.sql.*,ajax.db.DBUtils"%>
<%
    out.clear();                                                        //清空當(dāng)前的輸出內(nèi)容（空格和換行符）
    int offset = Integer.parseInt(request.getParameter("offset"));      //獲取起始id
    int pageSize = Integer.parseInt(request.getParameter("page_size")); //獲取要讀取的信息數(shù)量
%><?xml version="1.0" encoding="UTF-8"?>
<ajax-response>
<response type="object" id="data_grid_updater">
<rows update_ui="true">
<%
    String sql = "select * from live_grid where id between ? and ? order by id asc";   //定義查詢數(shù)據(jù)庫(kù)的SQL語(yǔ)句
    Connection conn = null;                 //聲明Connection對(duì)象
    PreparedStatement pstmt = null;         //聲明PreparedStatement對(duì)象
    ResultSet rs = null;                    //聲明ResultSet對(duì)象
    try {
        conn = DBUtils.getConnection();     //獲取數(shù)據(jù)庫(kù)連接
        pstmt = conn.prepareStatement(sql); //根據(jù)sql創(chuàng)建PreparedStatement
        pstmt.setInt(1, offset + 1);        //設(shè)置開(kāi)始id
        pstmt.setInt(2, offset + pageSize); //設(shè)置結(jié)束id
        rs = pstmt.executeQuery();          //執(zhí)行查詢，返回結(jié)果集
        while (rs.next()) {
            %>
            <tr>
                <td><%=rs.getInt("id")%></td>
                <td convert_spaces="true"><%=rs.getString("title")%></td>
                <td><%=rs.getFloat("price")%></td>
            </tr>
            <%
        }
    } catch (SQLException e) {
        System.out.println(e.toString());
    } finally {
        DBUtils.close(rs);                  //關(guān)閉結(jié)果集
        DBUtils.close(pstmt);               //關(guān)閉PreparedStatement
        DBUtils.close(conn);                //關(guān)閉連接
    }
%>
</rows>
</response>
</ajax-response>