chaxiu.jsp

来自「这是一个博客系统」· JSP 代码 · 共 37 行

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" %>
<%@ include file="Conn.jsp" %>
<%
  try{
  String id=(String)session.getAttribute("ID");
  ResultSet rs=getRs("select * from art where author_id='"+id+"'");
  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 ii=rs.getInt(1);
     String author=rs.getString(3);
     String title=rs.getString(4);
     String AddT=rs.getDate(6).toString(); 
     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("<date>"+AddT+"</date>");
     content.append("<id>"+ ii +"</id>");
     content.append("</content>");
          //out.print("fgdsfgdsfok"); 
     }
   content.append("</contents>");
   System.out.print(content);

  out.print(content);
  }
 catch(Exception e){
      e.printStackTrace();
   }
%>