thanks Ivelin, but now I'm right in front of a new problem, how to print out the document using cocoon? I couldn't find a generator that gets the input right from a stream? Do I have to write my own generator? If yes, can you point me to some documentation about this, because I couldn't found it.
thanks Lars > -----Ursprüngliche Nachricht----- > Von: Ivelin Ivanov [mailto:[EMAIL PROTECTED]] > Gesendet: Sonntag, 1. Dezember 2002 00:03 > An: [EMAIL PROTECTED] > Betreff: Re: XMLForm and Table output > > > Yes. You are on the right track. > Why don't you print the XML document once it is created to see what it > actually contains. > I suspect this might be a simple mistake due to misuse of the > API. It is not > very convenient. > Actually if you plan writing a lot of DOM code, you may want > to look at JDOM > or some of the O/R mapping frameworks. > > > Ivelin > > > > ----- Original Message ----- > From: "Kirchhoff, Lars" <[EMAIL PROTECTED]> > To: "Cocoon-Users (E-Mail)" <[EMAIL PROTECTED]> > Sent: Thursday, November 28, 2002 4:49 AM > Subject: XMLForm and Table output > > > > Hi, > > > > it's me again and I hope I'm still getting answers and not > starting to > > bother you all > > with all my questions. > > I've tried to create an application which simple should get > some user data > > from a > > database, by simply enter the name. So my first form is > just a text field > > where the name > > can be inserted. If the name is found all data will be > shown. so far so > > good. But now > > I would like to built something more. Because I do not look > at the exact > > name in the > > database it could be possible to get more then one entry. I > now want to > > create a page, > > where all possible names are shown and some more additional > information > > about them. > > So what I would like to have should be looking like this: > > ---------------------------------------------- > > | name | address | city | zip | > > ---------------------------------------------- > > | name1 | address1 | city1 | zip1 | > > | name2 | address2 | city2 | zip2 | > > | name3 | address3 | city3 | zip3 | > > | ... | ... | ... | ... | > > > > where the user has the possibility to click on the a name > to get the full > > detail. > > So what I thought is to write a method which get me the > data from the > > database and > > put this in a DOM Nodes. I thought this would enable me to > use them in the > > <xf:repeat> > > statement, but unfortunately it didn't worked out so far. > > > > Here is the code I used to create the DOM Nodes: > > > -------------------------------------------------------------- > ------------ > -- > > --------------- > > // ======================================================== > > // Use DOM nodes to store values > > // ======================================================== > > DOMImplementation impl; > > > > try { > > DocumentBuilderFactory factory = > > DocumentBuilderFactory.newInstance(); > > factory.setNamespaceAware( false ); > > factory.setValidating( false ); > > DocumentBuilder builder = factory.newDocumentBuilder(); > > impl = builder.getDOMImplementation(); > > } > > catch ( Exception e ) { > > throw new RuntimeException( "Failed to initialize DOM factory. Root > > cause: \n" + e ); > > } > > > > // ======================================================== > > // Use DOM nodes to store values > > // ======================================================== > > Document doc = impl.createDocument( null, "Users", null ); > > Node root = doc.getDocumentElement(); > > Node custname = null; > > Node address = null; > > Node zip = null; > > Node city = null; > > Node user = null; > > Text text; > > > > try { > > Class.forName( "org.postgresql.Driver" ); > > Connection con = > > DriverManager.getConnection( DB_URL, DB_USER, DB_PASS ); > > Statement stmt = con.createStatement(); > > String update = "select custname, busname, > > address, city, state, zip, pobox, pocode from customer > where custname like > > '%" + name + "%'"; > > ResultSet rs = stmt.executeQuery( update > > ); > > > > while ( rs.next() ) { > > user = doc.createElement( "user" ); > > root.appendChild( user ); > > > > custname = doc.createElement( "custname" ); > > > > text = doc.createTextNode( rs.getString( > > "custname" ) ); > > custname.appendChild( text ); > > user.appendChild( custname ); > > > > address = doc.createElement( "address" ); > > > > text = doc.createTextNode( rs.getString( > > "address" ) ); > > address.appendChild( text ); > > user.appendChild( address ); > > > > zip = doc.createElement( "zip" ); > > > > text = doc.createTextNode( rs.getString( "zip" ) > > ); > > zip.appendChild( text ); > > user.appendChild( zip ); > > > > city = doc.createElement( "city" ); > > > > text = doc.createTextNode( rs.getString( "city" ) > > ); > > city.appendChild( text ); > > user.appendChild( city ); > > > > system = root; > > } > > } > > catch( Exception e ) { } > > > -------------------------------------------------------------- > ------------ > -- > > --------------- > > > > I expected to create the following structure with it: > > > > <users> > > <user> > > <custname></custname> > > <address></address> > > <zip></zip> > > <city></city> > > </user> > > <user> > > <custname></custname> > > <address></address> > > <zip></zip> > > <city></city> > > </user> > > </users> > > > > So what I'm now wondering is, if I'm on the right track and > just doing > some > > beginner mistakes > > or if this won't work at all. > > > > Thanks in advance that you read up to here. > > > > ciao Lars > > > > > --------------------------------------------------------------------- > > Please check that your question has not already been > answered in the > > FAQ before posting. > <http://xml.apache.org/cocoon/faq/index.html> > > > > To unsubscribe, e-mail: > <[EMAIL PROTECTED]> > > For additional commands, e-mail: > <[EMAIL PROTECTED]> > > > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
