 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | JSP - A mailing list about Java Server Pages specification and reference | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | Separating SQL from code | Separating SQL from code 2004-04-07 - By Stefan Frank
Back
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859 (See http://ISO-8859.ora-code.com)-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
You may want to check out ibatis: <a class="moz-txt-link-freetext" href="http:/
/www.ibatis.com/">http://www.ibatis.com/</a><br>
They have a framework for externalizing sql. Similar approaches can be
found in hibernate(<a class="moz-txt-link-abbreviated" href="http://www
.hibernate.org">www.hibernate.org</a>), although most of the time you
don't have to write sql to get to your objects, just a mapping file: If
you have more complex demands, especially for queries, they have "named
queries", which also allows you to have your sql outside your code. <br>
<br>
hope this helps<br>
<br>
cheers<br>
stf<br>
Jean-Christian Imbeault wrote:<br>
<blockquote cite="mid001a01c41c85$a4c330a0$4f1c680a@(protected)"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<title>Message</title>
<meta content="MSHTML 6.00.2800.1400" name="GENERATOR">
<div><font face="ＭＳ Ｐゴシック"
color="#0000ff" size="2"><span
class="843014209-07042004">Thanks. Can you supply some online
references or perhaps books? I would like to study various ways of
implementing this and weight the pros and cons to see which would suit
us best.</span></font></div>
<div><font face="ＭＳ Ｐゴシック"
color="#0000ff" size="2"><span
class="843014209-07042004"></span></font> </div>
<div><font face="ＭＳ Ｐゴシック"
color="#0000ff" size="2"><span
class="843014209-07042004">Jc</span></font></div>
<div> </div>
<blockquote dir="ltr" style="margin-right: 0px;">
<div class="OutlookMessageHeader" lang="en-us" dir="ltr"
align="left"><font face="Tahoma" size="2">-- --Original Message-- --<br>
<b>From:</b> Umesh Singh [<a class="moz-txt-link-freetext" href="mailto
:USingh@(protected)">mailto:USingh@(protected)</a>] <br>
<b>Sent:</b> Wednesday, April 07, 2004 6:39 PM<br>
<b>To:</b> '<a class="moz-txt-link-abbreviated" href="mailto:jean-christian
.imbeault@(protected)">jean-christian.imbeault@(protected)</a>';
<a class="moz-txt-link-abbreviated" href="mailto:J2EEPATTERNS-INTEREST@(protected)
.COM">J2EEPATTERNS-INTEREST@(protected)</a><br>
<b>Subject:</b> RE: Separating SQL from code<br>
<br>
</font></div>
<p><font size="2">Hi You can use DAO with Properties file to keep
the SQL configurable. We are using SQL as Private String at class level
in the DAO. You can use this approach also so it is manageable.</font></p>
<p><font size="2">Regards,</font> <br>
<font size="2">Umesh</font></p>
</blockquote>
====================================================================
Companion Site: <a class="moz-txt-link-freetext" href="http://www
.corej2eepatterns.com">http://www.corej2eepatterns.com</a>
J2EE BluePrints: <a class="moz-txt-link-freetext" href="http://java.sun.com
/blueprints/corej2eepatterns">http://java.sun.com/blueprints/corej2eepatterns</a
>
List Archive:
<a class="moz-txt-link-freetext" href="http://archives.java.sun.com/archives
/j2eepatterns-interest.html">http://archives.java.sun.com/archives/j2eepatterns
-interest.html</a>
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
<a class="moz-txt-link-abbreviated" href="mailto:listserv@(protected)"
>listserv@(protected)</a>
</blockquote>
<br>
</body>
</html>
====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
|
|
|
