?<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="" %>
<%@ include file="Conn.jsp" %>
<%
  try{
  ResultSet rs=getRs("select * from art");
  StringBuffer content=new StringBuffer(""); 
  response.setContentType("text/xml"); 
  response.setHeader("Cache-Control","no-cache");
  content.append("<?xml version=\"1.0\"   encoding=\"UTF-8\" ?>");
  content.append("<contents>");
  while(rs.next()){
     int id=rs.getInt(1);
     String author=rs.getString(3);
     String title=rs.getString(4); 
     String cla= rs.getString(7);
     content.append("<content>");
     content.append("<author>"+ author +"</author>");
     content.append("<title>"+ title +"</title>");
     content.append("<class>"+ cla +"</class>");
     content.append("<id>"+ id +"</id>");
     content.append("</content>");
     }
   content.append("</contents>");
   out.print(content);
  }
 catch(Exception e){
      e.printStackTrace();
   }
%>