chaservlet.java

用jsp和ajax做的留言板系统。其中还有css样式表

package test;
import java.sql.*;
import java.util.*;
import javax.servlet.ServletException;
import javax.servlet.http.*;
public class ChaServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, java.io.IOException {
                response.setContentType("application/xml; charset=utf-8");
                response.setHeader("Cache-Control","no-cache");
		java.io.PrintWriter out = response.getWriter();
                try{
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	
		Connection con = DriverManager.getConnection("jdbc:odbc:gBook");	
                Statement stmt = con.createStatement();
                String sql="select * from data";
                ResultSet rs=stmt.executeQuery(sql);
                System.out.println(sql);
                
                Vector vData =new Vector();
                TempO tt=null;
                 while(rs.next()){
                      tt=new TempO(); 
                      int id=rs.getInt("id");
                      String title=rs.getString("title");
                      tt.setId(id);
                      tt.setTitle(title);
                      vData.add(tt);
                     
                     }
                     StringBuffer buf=new StringBuffer();
                     buf.append("<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
                     buf.append("<yans>");
                     for(int i=0;i<vData.size();i++)
                        {  
                      TempO t=(TempO)vData.get(i);	
                      buf.append("<yan>");
                      buf.append("<id>" + t.getId() + "</id>");
	              buf.append("<title>" + t.getTitle() + "</title>");
                      buf.append("</yan>");
                       }
                buf.append("</yans>");
                out.println(buf.toString());
                System.out.println(buf.toString());  
                  }
         catch(Exception eee){
              System.out.println(eee);
              eee.printStackTrace();
           }
	}
}