AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  SQLUtil static class          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Dom Guest Posted: Thu Feb 03, 2005 4:48 pm    Post subject: SQLUtil static class Hi to everyone, I have to develop a 3-tier web application. The application accesses oracle db. Where can I find a sort of SQLUtil static class in JAVA encapsulating the most popular JDBC objects and operations, hiding all the tedium of initialization, exception handling, and cleanup. This sort of library should have the following operations (for example): -openConn (AutoCommit) -closeConn -select (query, params): returns an ArrayList or an HashMap -insert/update(query, params): returns a boolean or affeted rows... -callStoredProcedure(procedure, params, ...): .... thanks to all Dom Back to top JavaJava Guest Posted: Thu Feb 03, 2005 6:03 pm    Post subject: Re: SQLUtil static class Check out iBatis, and other then Hibernate, you'll never look back again. :) Download the http://www.ibatis.com/ Download: http://www.ibatis.com/common/download.html Josh Back to top Dom Guest Posted: Fri Feb 04, 2005 10:54 am    Post subject: Re: SQLUtil static class "JavaJava" <eckerman (AT) gmail (DOT) com> ha scritto nel messaggio news:1107453784.130899.185090 (AT) z14g2000cwz (DOT) googlegroups.com... Quote: Check out iBatis, and other then Hibernate, you'll never look back again. I'd like to find something more simple: I don't need persistence and I've not to return DTO ... any other suggestion? thanks Back to top Holger Samoht Guest Posted: Fri Feb 04, 2005 5:13 pm    Post subject: Re: SQLUtil static class Maybe you want to check for Butler -> butler.sf.net "Dom" <dom (AT) nospam (DOT) it> schrieb im Newsbeitrag news:6BsMd.14389$QG6.247194 (AT) twister2 (DOT) libero.it... Quote: Hi to everyone, I have to develop a 3-tier web application. The application accesses oracle db. Where can I find a sort of SQLUtil static class in JAVA encapsulating the most popular JDBC objects and operations, hiding all the tedium of initialization, exception handling, and cleanup. This sort of library should have the following operations (for example): -openConn (AutoCommit) -closeConn -select (query, params): returns an ArrayList or an HashMap -insert/update(query, params): returns a boolean or affeted rows... -callStoredProcedure(procedure, params, ...): .... thanks to all Dom Back to top JavaJava Guest Posted: Fri Feb 04, 2005 7:30 pm    Post subject: Re: SQLUtil static class Take a look at this article on IBM's devWorks. An easy JDBC wrapper by Greg Travis http://www-106.ibm.com/developerworks/java/library/j-jdbcwrap/ Back to top Dom Guest Posted: Mon Feb 07, 2005 1:15 pm    Post subject: Re: SQLUtil static class "JavaJava" <eckerman (AT) gmail (DOT) com> ha scritto nel messaggio news:1107545424.233664.3640 (AT) o13g2000cwo (DOT) googlegroups.com... Quote: Take a look at this article on IBM's devWorks. An easy JDBC wrapper by Greg Travis http://www-106.ibm.com/developerworks/java/library/j-jdbcwrap/ It uses Statement instead of PreparedStatement......I think it's not suitable for complex enterprise applications Thank dom Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.