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();
	}
}