<%
response.setCharacterEncoding("UTF-8");
response.setHeader("Content-type", "text/xml");
// 模仿server.php提供的參數...待處理.
String _sPage = request.getParameter("page"); // get the requested page
String _sLimit = request.getParameter("rows"); // get how many rows we want to have into the grid
String _sIndex = request.getParameter("sidx"); // get index row - i.e. user click to sort
String _sOrder = request.getParameter("sord"); // get the direction
if (_sPage == null) _sPage = "1";
if (_sIndex == null) _sIndex = "1";
if (_sLimit == null) _sLimit = "10";
int _iLimit = Integer.parseInt(_sLimit);
if (_iLimit == 0) _iLimit = 10;
int _iPage = Integer.parseInt(_sPage);
Class.forName("net.sourceforge.jtds.jdbc.Driver"); // 使用jTDS連接MS SQL Server
java.sql.Connection _oConn = java.sql.DriverManager.getConnection(
"jdbc:jtds:sqlserver://localhost/your_DB", "userid", "password");
double _dTotalPages = 0;
try {
String _sSQL = "select top 20 USERID,USERNAME,PASSWD from Users order by USERID";
java.sql.PreparedStatement _oStmt = _oConn.prepareStatement(_sSQL);
java.sql.ResultSet rs = _oStmt.executeQuery();
int _iCount = 0;
StringBuffer _sbXml = new StringBuffer(); // 把記錄存起來，最後一齊輸出
while (rs.next()) {
_iCount++;
_sbXml.append("");
_sbXml.append(" | ");
_sbXml.append(" | ");
_sbXml.append(" | ");
_sbXml.append("
\n");
}
if( _iCount >0 ) {
_dTotalPages = Math.ceil(_iCount/_iLimit);
} else {
_dTotalPages = 0;
}
if (_iPage > _dTotalPages) _iPage = (int) _dTotalPages;
int _iStart = _iLimit * _iPage - _iLimit; // do not put $limit*($page - 1)
out.println("");
out.println("");
out.println("" + _iPage + "");
out.println("" + ((int) _dTotalPages) + "");
out.println("" + _iCount + "");
out.print(_sbXml.toString());
out.println("");
} catch (Exception e) {
out.println("Exception: " + e.getMessage());
} finally {
if (_oConn != null) _oConn.close();
}
%>