Ano, nebo zvolíte řešení typu iBatis ;-). To jsme se dostali daleko od původního tématu, co?
Petr -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rastislav Rehak Sent: Friday, August 25, 2006 10:40 AM To: Java Subject: Re: for vs. while - problemy s SQL Drivery Ked to takto pojde dalej, tak zistite, ze najlepsie by bolo pouzivat daku kniznicku, ktora to bude za vas vzdy zatvarat a ked mam PreparedStatement tak nech sa nestaram o cislovanie parametrov , pripadne nech cely riadok natiahne do pola alebo beanu. Napriklad : http://jakarta.apache.org/commons/dbutils/ a kod potom moze vyzerat takto : // Create a QueryRunner that will use connections from // the given DataSource QueryRunner run = new QueryRunner(dataSource); // Execute the query and get the results back from the handler Object[] result = (Object[]) run.query( "SELECT * FROM Person WHERE name=?", "John Doe", h); Samozrejme vam nestaci len prvy riadok ako pole, tak mozete pouzit ResulSetHandler objekt : new QueryRunner().query(conn, "select ........ ",new Object[]{id}, // v poli su dake parametre do PreparedStatement new ResultSetHandler() { public Object handle(ResultSet rs) throws SQLException { while( rs.next()){ // tu je daco uzitocne } return null; } } Bye Ra100