import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.* ;

public class UserDataServlet extends HttpServlet 
{
  
	protected void doGet(HttpServletRequest request,HttpServletResponse response)
      		throws IOException, ServletException
	{

		//XML標頭
		response.setContentType("text/xml;charset=GB2312");
		PrintWriter pw = response.getWriter();
		pw.println("<?xml version=\"1.0\" encoding=\"GB2312\" ?>");

		String xsltName ;
		xsltName = request.getContextPath()+"/default.xslt";
		pw.println("<?xml-stylesheet type=\"text/xsl\" href=\"" + xsltName + "\" ?>");	
	
		pw.println("<用戶名單>") ;

		//XML數據內容
		
		Connection conn = null ;
		ResultSet rs = null ;
		Statement stmt = null ;
		try
		{
			AccessDAO da = new AccessDAO("enterprisedata") ;
			conn = da.getConnection() ;

			stmt = conn.createStatement() ;
		
			String command = "select * from user" ;
			rs = stmt.executeQuery(command) ;
			while(rs.next())
			{
				pw.println("	<用戶>") ;
				pw.println("		<代號>") ;
				pw.println("			"+ rs.getString("id") ) ;
				pw.println("		</代號>") ;
				pw.println("		<密碼>") ;
				pw.println("			"+ rs.getString("password") ) ;
				pw.println("		</密碼>") ;
				pw.println("		<描述>") ;
				pw.println("			"+ rs.getString("description") ) ;
				pw.println("		</描述>") ;

				pw.println("	</用戶>") ;
			}
			pw.println("</用戶名單>") ;
			rs.close() ;
			stmt.close() ;
			conn.close() ;	
		}catch(Exception e)
		{
		}
		
  	}
}	

//取得參數的方式
//String xxx = request.getParameter("xxx");