143 、 ORACLE 大数据量下的分页解决方法。一般用截取 ID 方法，还有是三层嵌套方法。 答 : 一种分页方法

<%

  int i=1;

  int numPages=14;

  String pages = request.getParameter("page") ;

  int currentPage = 1;

  currentPage=(pages==null)?(1):{Integer.parseInt(pages)}

  sql = "select count(*) from tables";

  ResultSet rs = DBLink.executeQuery(sql) ;

  while(rs.next()) i = rs.getInt(1) ;

  int intPageCount=1;

  intPageCount=(i%numPages==0)?(i/numPages):(i/numPages+1);

  int nextPage ;

  int upPage;

  nextPage = currentPage+1;

  if (nextPage>=intPageCount) nextPage=intPageCount;

  upPage = currentPage-1;

  if (upPage<=1) upPage=1;

  rs.close();

  sql="select * from tables";

  rs=DBLink.executeQuery(sql);

  i=0;

  while((i<numPages*(currentPage-1))&&rs.next()){i++;}

%>

// 输出内容

// 输出翻页连接

合计 :<%=currentPage%>/<%=intPageCount%><a href="List.jsp?page=1"> 第一页 </a><a

href="List.jsp?page=<%=upPage%>"> 上一页 </a>

<%

  for(int j=1;j<=intPageCount;j++){

  if(currentPage!=j){

%>

  <a href="list.jsp?page=<%=j%>">[<%=j%>]</a>

<%

  }else{

  out.println(j);

  }

  }

%>

<a href="List.jsp?page=<%=nextPage%>"> 下一页 </a><a href="List.jsp?page=<%=intPageCount%>"> 最后页

</a>

144 、用 jdom 解析 xml 文件时如何解决中文问题 ? 如何解析 ? 答 : 看如下代码 , 用编码方式加以解决

package test;

import java.io.*;

public class DOMTest

{

private String inFile = "c:people.xml";

private String outFile = "c:people.xml";

public static void main(String args[])

{
     new DOMTest();
}

public DOMTest(){
  try{

      javax.xml.parsers.DocumentBuilder builder =
        javax.xml.parsers.DocumentBuilderFactory.newInstance().newDocumentBuilder();

      org.w3c.dom.Document doc = builder.newDocument();
      org.w3c.dom.Element root = doc.createElement(" 老师 ");
      org.w3c.dom.Element wang = doc.createElement(" 王 ");
      org.w3c.dom.Element liu = doc.createElement(" 刘 ");
      wang.appendChild(doc.createTextNode(" 我是王老师 "));
      root.appendChild(wang);
      doc.appendChild(root);

      javax.xml.transform.Transformer transformer =

      javax.xml.transform.TransformerFactory.newInstance().newTransformer();

      transformer.setOutputProperty(javax.xml.transform.OutputKeys.ENCODING, "gb2312");

      transformer.setOutputProperty(javax.xml.transform.OutputKeys.INDENT, "yes");  

      transformer.transform(new javax.xml.transform.dom.DOMSource(doc),

      new javax.xml.transform.stream.StreamResult(outFile));

     }

     catch (Exception e)

     {

      System.out.println (e.getMessage());

     }

    }

}