Store query result in a xml file

[reeba]

I want to store the query result, in an servlet, into an xml file and display the contents of the xml file on the browser......

my code is as follows:

public void doPost(HttpServletRequest request, HttpServletResponse response)
                                   throws ServletException,IOException{
//      List dataList = new ArrayList();
      response.setContentType("text/html");
    PrintWriter pw = response.getWriter();
 
   String contextPath = request.getContextPath();
   HttpSession session = request.getSession(true);
 
 String branchId = null;
 String orgId = null;
 String stateId = null;
 String regionId = null;
 String lot_ref="";
 String lot_wt="";
 String item="";
 
 
 
 
  PrintWriter out = response.getWriter();
    //Establish connection to MySQL database
     String url="jdbc:mysql://192.168.1.3:3306/APMC?user=apmc&password=apmc";
    Connection con = null;
    ResultSet rs=null;
    Statement st=null;
    try {
 
 
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       System.out.println("driver regristration success!");
       con=DriverManager.getConnection(url);
       System.out.println("connected tendring............     ");
 
      String sql = "select SQL_CALC_FOUND_ROWS lot.n_lot_ref_no,bidact.c_item_name,"+
                            " bidact.m_lot_wieght FROM t_bidding_activation bidact, t_lot_master lot, t_stakeholder_master stakeholder"+
                           " where bidact.c_active='Y' and "+
                            "bidact.n_lot_id=lot.n_lot_id and stakeholder.n_stakeholder_id=lot.n_stakeholder_id  and bidact.c_bidded!='Y'"+
                            "and bidact.c_branch_id='" + branchId + "' and bidact.c_org_id='"+ orgId +"' and bidact.c_state_id='" + stateId + "' "+
                            "and bidact.c_region_id='" + regionId + "'  order by bidact.c_item_name,"+
                            "bidact.d_bid_end_date, bidact.d_bid_end_time";
 
System.out.println("Output from dopost..........................");
System.out.println("after query..................................");
      st = con.createStatement();
      st.executeQuery (sql);
      rs = st.getResultSet();
      System.out.println("result" +rs);
 
      System.out.print("before while");
      while (rs.next()){
        //Add records into data list
          System.out.println("Hello....................................");
        lot_ref= rs.getString(1);
        System.out.print("refnum"+lot_ref);
        lot_wt=rs.getString(2);
       System.out.print("lotwt"+lot_wt);
        item= rs.getString(3);
       System.out.print("item"+item);
//       dataList.add(rs.getString("lot.n_lot_ref_no"));
//        dataList.add(rs.getString("bidact.c_item_name"));
//        dataList.add(rs.getString("bidact.m_lot_wieght"));
 
 
      }
System.out.print("after while");
 
 
 
 
      }catch(Exception e){
      System.out.println("Exception is ;"+e);
      }
 
 
 
  /*if(request.getParameter("strUserName")!=null && request.getParameter("strPassword")!=null)
    {
        String username = request.getParameter("strUserName").toString();
       String passwd = request.getParameter("strPassword").toString();
    }*/
    // if (uName.equals(userName) && passwd.equals(password)){
 
  try
  {
    DocumentBuilderFactory builderFactory = DocumentBuilderFactory.newInstance();
        DocumentBuilder docBuilder = builderFactory.newDocumentBuilder();
        //creating a new instance of a DOM to build a DOM tree.
        Document doc = docBuilder.newDocument();
        new xmlServlet().createXmlTree(doc,lot_ref, lot_wt,item);
 
 
    pw.println("<b>Xml File Created Successfully</b>");
  }
  catch(Exception e)
  {
    System.out.println(e);
  }
    try{
    rs.close ();
      st.close ();
      con.close();
    }catch(Exception e){
      e.printStackTrace();
    }
    /* }
     else
     {
     System.out.println("Invalid User");
     }*/
 
  }
 
  public void createXmlTree(Document doc, String lot_ref, String lot_wt, String item) throws Exception {
        //This method creates an element node
        Element root = doc.createElement("User");
        //adding a node after the last child node of the specified node.
        doc.appendChild(root);
 
 
 
        Element child1 = doc.createElement("lot_ref");
        root.appendChild(child1);
 
        Text text = doc.createTextNode(lot_ref);
        child1.appendChild(text);
 
 
 
        Element element = doc.createElement("lot_wt");
        root.appendChild(element);
 
        Text text1 = doc.createTextNode(lot_wt);
        element.appendChild(text1);
 
        Element element1 = doc.createElement("item");
        root.appendChild(element1);
 
        Text text2 = doc.createTextNode(item);
        element.appendChild(text2);
 
 
 
 
     //TransformerFactory instance is used to create Transformer objects.
        TransformerFactory factory = TransformerFactory.newInstance();
        Transformer transformer = factory.newTransformer();
 
        transformer.setOutputProperty(OutputKeys.INDENT, "yes");
 
 
        // create string from xml tree
        StringWriter sw = new StringWriter();
        StreamResult result = new StreamResult(sw);
        DOMSource source = new DOMSource(doc);
        transformer.transform(source, result);
        String xmlString = sw.toString();
 
        File file = new File("c:/temp/tender.xml");
        BufferedWriter bw = new BufferedWriter
                      (new OutputStreamWriter(new FileOutputStream(file)));
        bw.write(xmlString);
        bw.flush();
        bw.close();
 
    }
 
 
}

Here I am able to create a xml file ... but i need to use some array ... to store large number of data... which i am not able to do.....
could u help me regarding this,
once i do tat ... i need to display the content of the xml file in the browser.

regards,
reebeca

[Dheeraj Joshi]

First of all, you have posted your question in the wrong place.

Have you tried to code? What problem you are getting?

Regards
Dheeraj Joshi

* When i was typing this question Dormilich moved this thread

[jkmyoung]

It seems you can create each row in the while(rs.next() ) loop. Why not add your nodes there? Have a function kind of like createXmlTree() , say instead createXMLBranch (), and add the node created to your main document node.

Also, let's focus on making the xml file before you get caught up in display.