pageservlet.java

这是一个留言板系统

package test;

import java.sql.*;
import java.util.Vector;

import javax.servlet.ServletException;
import javax.servlet.http.*;

public class pageServlet extends HttpServlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, java.io.IOException {
		// 获得请求中page的值
                response.setContentType("text/xml");
		java.io.PrintWriter out = response.getWriter();
                try{
                 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	//载入驱动程式类别
		Connection con = DriverManager.getConnection("jdbc:odbc:gBook","sa","");	//建立数据库连接
		//建立Statement变量
                Statement stmt = con.createStatement();
                String sql="select * from data";
                ResultSet rs=stmt.executeQuery(sql);
                System.out.println(sql);
		// 定义保存数据的向量
		Vector vData = new Vector();
		try {
			// 将游标移动到当前页的第一条记录上
			//rs.absolute((currentPage - 1) * PAGE_SIZE + 1);
                        //System.out.println(PAGE_SIZE);
			// 定义Student实体类
			StudentEO student = null;
			int i = 0;
			// 循环记录集,将记录集中的数据保存到实体类中
			//while (i < 15) {
                        while(rs.next())
				student = new StudentEO();
				student.setId(rs.getInt("id"));
				student.setStudentName(rs.getString("title"));
				student.setStudentClass(rs.getString("content"));
				// 将保存数据后的student实体类保存到向量中
                               System.out.println("ok");
                               System.out.println(i); 
				vData.add(student);
				//rs.next();
				i++;
			//}
			// 最后释放Connection对象
		} catch (SQLException e) {
			e.printStackTrace();
                        System.out.println(e);
		}
		// 设置返回数据为xml格式

		// 调用parasToXML方法组织XML数据
		out.print(parasToXML(vData));
            }
         catch(Exception eee){
              System.out.println(eee);
              eee.printStackTrace();
           }
	}
	public String parasToXML(Vector v) {
		StringBuffer buf = new StringBuffer();
		// 将向量中的数据组织成XML数据
		buf.append("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
		buf.append("<students>");
		for (int i = 0; i < v.size(); i++) {
			StudentEO s = (StudentEO) v.get(i);
			buf.append("<student>");
			buf.append("<id>" + s.getId() + "</id>");
			buf.append("<name>" + s.getStudentName() + "</name>");
			buf.append("<class>" + s.getStudentClass() + "</class>");
			buf.append("</student>");
		}
		buf.append("</students>");
                System.out.println(buf.toString());
                
		return buf.toString();
	}
}