import java.sql.Statement;
import javax.naming.InitialContext;
import javax.sql.DataSource;
import javax.servlet.*;
import java.io.*;
import javax.servlet.http.*;

public class exUser extends HttpServlet{
        public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException{
        String cus_id = req.getParameter("id");
        ResultSet result = null;
        res.setContentType("text/xml; charset=utf-8");
        PrintWriter out = null;

        try{
                out = res.getWriter();

                result = getInfoFromTable(cus_id);
                        try{
                                if(result != null){
                                        out.println("<?xml version='1.0' encoding='UTF-8'?>");

                                        out.println("<users>");
                                        while(result.next()){
                                        out.println("<user>");
                                        out.println("<idnum>"+ result.getString(1)+"</idnum>");
                                        out.println("<name>" + result.getString(2)+"</name>");
                                        out.println("<age>"  + result.getString(3)+"</age>");
                                        out.println("<callnumber>" + result.getString(4)+"</callnumber>");
                                        out.println("<address>"+ result.getString(5)+"</address>");
                                        out.println("<id>"+result.getString(6)+"</id>");
                                        out.println("<password>"+ result.getString(7)+ "</password>");
                                        out.println("<inputId>"+ cus_id+ "</inputId>");
                                        out.println("</user>");
                                        }
                                        out.println("<sql>"+"select * from customer where id="+cus_id +"</sql>");
                                        out.println("</users>");
                                }
                       }catch(Exception e){
                                e.printStackTrace();
                }
                }catch(IOException ioe){
                                ioe.printStackTrace();
                }finally{
                                try{if(out != null) out.close();} catch(Exception e) {}
                }

                }

                private ResultSet getInfoFromTable(String cus_id){
                ResultSet rs = null;
                try{
                        InitialContext initContext = new InitialContext();
                        DataSource dataSource = (DataSource)initContext.lookup("datasource1");
                        Connection conn = dataSource.getConnection();
                        Statement stmt = conn.createStatement();

                        String sql = new String("select * from customer where id ="+cus_id );
                        rs = stmt.executeQuery(sql);

                   }catch(Exception e){
                        e.printStackTrace();
                        }
                        return rs;
                   }
                }


 


 

풀소스..