<html><head><base href="x-msg://381/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><a href="http://www.javaworld.com/javaworld/jw-04-2007/jw-04-jdbc.html">http://www.javaworld.com/javaworld/jw-04-2007/jw-04-jdbc.html</a><div>Az első workaround, hogy változóban számolod, hogy hányadik behelyettesítésnél tartasz és akkor be tudsz szúrni egy ?-t simán (kajakra).</div><div>A második egy NamedPreparedStatement osztály teljes forráskóddal. Nem regexp-t használ!</div><div><br><div>
<div>Verhás István<br>JIRA szakértő<br>Verhás & Verhás Szoftver Manufaktúra Kft.<br><a href="mailto:istvan@verhas.com">istvan@verhas.com</a><br>t: +36(30)3997117<br>skype: verhasi</div>
</div>
<br><div><div>On Jan 3, 2012, at 5:02 PM, Keresztes Jozsef wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div lang="HU" link="blue" vlink="purple"><div class="WordSection1" style="page: WordSection1; "><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">Mert a „?” nagyon béna megoldás a JDBC-ben mivel szerepelhet egy sql stringben 20 kérdőjel,<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">és azt mondod hogy a 13. legyen behelyettesítve XY-nal.<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">Képzeld hogy ha átalakítod az sql-edet és bejön közé mégegy „?” rossz az egész<span class="Apple-converted-space"> </span></span><span style="font-size: 10pt; font-family: Wingdings; ">J</span><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">Én máig csodálkozok hogy maradt ez az ősrégi ?-es megoldás. <o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div><div style="border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-top-style: solid; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding-top: 3pt; padding-right: 0cm; padding-bottom: 0cm; padding-left: 0cm; "><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><b><span style="font-size: 10pt; font-family: Tahoma, sans-serif; ">From:</span></b><span style="font-size: 10pt; font-family: Tahoma, sans-serif; "><span class="Apple-converted-space"> </span><a href="mailto:istvan.ketler@lhsystems.com" style="color: blue; text-decoration: underline; ">istvan.ketler@lhsystems.com</a><span class="Apple-converted-space"> </span>[mailto:istvan.ketler@lhsystems.com]<span class="Apple-converted-space"> </span><br><b>Sent:</b><span class="Apple-converted-space"> </span>Tuesday, January 03, 2012 4:56 PM<br><b>To:</b><span class="Apple-converted-space"> </span><a href="mailto:javalist@lists.javaforum.hu" style="color: blue; text-decoration: underline; ">javalist@lists.javaforum.hu</a><br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [Javalist] 'Pattern'<o:p></o:p></span></div></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Az első és utolsó emailed között eltelt 19 perc (eddig), ennél hamarabb tudtál volna írni egy static metódust amelyik elvégzi neked ezt az egyszerű mutatványt. Pattern.compile(..).... helyett aztán használhatnád ezt a metódust nagyjából ugyanúgy.<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); ">Amúgy miért nem jó a ?, miért kell helyette :?<o:p></o:p></span></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">István Ketler<br></span></b><span style="font-size: 9pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">Team Leader </span><span style="color: rgb(31, 73, 125); "><o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">Lufthansa Systems Hungaria Kft.<span class="Apple-converted-space"> </span><br>Development Center Pest<span class="Apple-converted-space"> </span><br>- Team "Schedule & Revenue Management"<br>- Team "Business Intelligence & Database Solutions"<br>Neumann János u. 1/e<br>1117 Budapest<br>Hungary<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">Tel: +36 1 887-2815<span class="Apple-converted-space"> </span><br>Fax: +36 1 887-2977<br>Mobile: +36 30 600-4936</span><span style="color: rgb(31, 73, 125); "><o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">Room: Infopark E, Room LH1-31</span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 8pt; font-family: Arial, sans-serif; color: rgb(153, 153, 153); ">e-mail:<span class="Apple-converted-space"> </span><a href="mailto:istvan.ketler@lhsystems.com" style="color: blue; text-decoration: underline; ">istvan.ketler@lhsystems.com</a><span class="Apple-converted-space"> </span><br>Internet:<span class="Apple-converted-space"> </span><a href="http://www.lhsystems.hu/" style="color: blue; text-decoration: underline; ">www.LHsystems.hu</a></span><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p></o:p></span></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, 73, 125); "><o:p> </o:p></span></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "> <o:p></o:p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 8pt; font-family: Arial, sans-serif; color: gray; ">Sitz der Gesellschaft / Corporate Headquarters:<span class="Apple-converted-space"> </span></span><span lang="EN-GB" style="font-size: 8pt; font-family: Arial, sans-serif; color: gray; ">Lufthansa Systems Hungaria Kft, Budapest, Fövarosi Birosag 01-09-463417<br></span><span style="font-size: 8pt; font-family: Arial, sans-serif; color: gray; ">Geschaeftsfuehrung / Management Board: Monika Houck</span><o:p></o:p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div><div style="border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-top-style: solid; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding-top: 3pt; padding-right: 0cm; padding-bottom: 0cm; padding-left: 0cm; "><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; ">From:</span></b><span lang="EN-US" style="font-size: 10pt; font-family: Tahoma, sans-serif; "><span class="Apple-converted-space"> </span><a href="mailto:javalist-bounces@lists.javaforum.hu" style="color: blue; text-decoration: underline; ">javalist-bounces@lists.javaforum.hu</a><span class="Apple-converted-space"> </span><a href="mailto:[mailto:javalist-bounces@lists.javaforum.hu]" style="color: blue; text-decoration: underline; ">[mailto:javalist-bounces@lists.javaforum.hu]</a><span class="Apple-converted-space"> </span><b>On Behalf Of<span class="Apple-converted-space"> </span></b>Keresztes Jozsef<br><b>Sent:</b><span class="Apple-converted-space"> </span>Tuesday, January 03, 2012 4:40 PM<br><b>To:</b><span class="Apple-converted-space"> </span>Java lista<br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [Javalist] 'Pattern'<o:p></o:p></span></div></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">JDBC-ben csak „?”-lel lehet a változókat jelölni, ehelyett lenne a „:”-os váltózó használat:<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">UPDATE xxx SET datum = :date WHERE id = :id<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">ez így szép és jó, meg tudom találni a „:”-os változókat, helyettesítem „?”-re, megkapja<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">a JDBC az így átalakított stringet stb stb, minden jó, csak az a baj amikor a „:” nem jelent változót,<o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; ">mert egy stringen belül van. Ekkor nem kell „?”-re alakítani… <o:p></o:p></span></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 10pt; font-family: 'Courier New'; "><o:p> </o:p></span></div><div><div style="border-right-style: none; border-bottom-style: none; border-left-style: none; border-width: initial; border-color: initial; border-top-style: solid; border-top-color: rgb(181, 196, 223); border-top-width: 1pt; padding-top: 3pt; padding-right: 0cm; padding-bottom: 0cm; padding-left: 0cm; "><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><b><span style="font-size: 10pt; font-family: Tahoma, sans-serif; ">From:</span></b><span style="font-size: 10pt; font-family: Tahoma, sans-serif; "><span class="Apple-converted-space"> </span>Peter Verhas<span class="Apple-converted-space"> </span><a href="mailto:[mailto:peter@verhas.com]" style="color: blue; text-decoration: underline; ">[mailto:peter@verhas.com]</a><span class="Apple-converted-space"> </span><br><b>Sent:</b><span class="Apple-converted-space"> </span>Tuesday, January 03, 2012 4:31 PM<br><b>To:</b><span class="Apple-converted-space"> </span>Java lista<br><b>Subject:</b><span class="Apple-converted-space"> </span>Re: [Javalist] 'Pattern'<o:p></o:p></span></div></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">Ez csak azokat veszi ki, ahol az aposztróf közvetlenül a : előtt vagy mögötte van. A ' barmi : barmi ' esetén nem.<o:p></o:p></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">A look ahead és look back patternekkel az a ban, hogy lehet előtte és utána is ', csak a paritást is számolnia kellene. Ezért én sem küzdenék sokáig pattern-nel, inkább szétvágnám a stringet, utána keresnék, és aztán összefűzném.<o:p></o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">Amúgy mire kell?<o:p></o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div><div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: rgb(136, 136, 136); ">--<br>Verhás Péter<br>ügyvezető<br>Verhás & Verhás Szoftver Manufaktúra Kft.<br><a href="mailto:peter@verhas.com" style="color: blue; text-decoration: underline; ">peter@verhas.com</a><br>+36(30)9306805<br>skype: verhas</span><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: black; "><o:p></o:p></span></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><span style="font-size: 13.5pt; font-family: Helvetica, sans-serif; color: black; "><o:p> </o:p></span></div></div></div><p class="MsoNormal" style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 12pt; "><o:p> </o:p></p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div><div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">On 2012.01.03., at 16:24, Istvan Bencze wrote:<o:p></o:p></div></div><p class="MsoNormal" style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 12pt; "><o:p> </o:p></p><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">Szia!<o:p></o:p></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">Ezt a mintát próbáltad már?<o:p></o:p></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><br>[^']:[^']<o:p></o:p></div><div><div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><br>Üdv,<o:p></o:p></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">Bencze István<o:p></o:p></div></div><p class="MsoNormal" style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 12pt; "><o:p> </o:p></p><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">2012/1/3 OSTYÁNI Péter <<a href="mailto:panteros@dev-labs.com" style="color: blue; text-decoration: underline; ">panteros@dev-labs.com</a>><o:p></o:p></div><div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">Szia!<o:p></o:p></p><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">Szerintem akkor neked a lookahead/lookbehind patternek kellenek:<o:p></o:p></p><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; "><a href="http://www.regular-expressions.info/lookaround.html" target="_blank" style="color: blue; text-decoration: underline; ">http://www.regular-expressions.info/lookaround.html</a><o:p></o:p></p><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "> <o:p></o:p></div></div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">üdv: ostya<o:p></o:p></p><div><div><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "> <o:p></o:p></div></div><p style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; ">On Tue, 3 Jan 2012 16:10:27 +0100, Keresztes Jozsef wrote:<o:p></o:p></p><blockquote style="border-top-style: none; border-right-style: none; border-bottom-style: none; border-width: initial; border-color: initial; border-left-style: solid; border-left-color: rgb(16, 16, 255); border-left-width: 1.5pt; padding-top: 0cm; padding-right: 0cm; padding-bottom: 0cm; padding-left: 4pt; margin-left: 3.75pt; margin-top: 5pt; margin-bottom: 5pt; "><pre style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 12pt; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 10pt; font-family: 'Courier New'; ">Sziasztok !<br><br>Egy sql stringen belül keresek egy másik stringet, a Matcher és Pattern osztályok segítségével,<br>egyszerüsítsük a dolgot, csak a ":" karaktert keressük: <br><br>Matcher matcher = Pattern.compile(":").matcher(sqlString);<o:p></o:p></span></pre><pre style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 12pt; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 10pt; font-family: 'Courier New'; "><br>A probléma azzal van hogy csak azokat a ":" karaktereket szeretném megkeresni az sql stringben ami nem aposztrófok között van például:<br><br>SELECT 'ez nem'':kell' FROM valami WHERE id = :id and ':' = 'x'<o:p></o:p></span></pre><pre style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 12pt; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 10pt; font-family: 'Courier New'; "><br>Vagyis itt a 2. kettőspont lenne csak találat a többi nem.<br>Valaki foglalkozott már ilyen keresési minta megírásával ? <br>Én egyelőre nem tudom elképzelni... <br><br>Joe<br> <br><br>_______________________________________________<o:p></o:p></span></pre><pre style="margin-top: 0cm; margin-right: 0cm; margin-left: 0cm; margin-bottom: 12pt; font-size: 12pt; font-family: 'Times New Roman', serif; "><span style="font-size: 10pt; font-family: 'Courier New'; ">Javalist mailing list<br><a href="mailto:Javalist@lists.javaforum.hu" target="_blank" style="color: blue; text-decoration: underline; ">Javalist@lists.javaforum.hu</a><br><a href="http://lists.javaforum.hu/mailman/listinfo/javalist" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.javaforum.hu/mailman/listinfo/javalist</a><o:p></o:p></span></pre></blockquote><div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "> <o:p></o:p></div></div></div></div></div><p class="MsoNormal" style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 12pt; "><br>_______________________________________________<br>Javalist mailing list<br><a href="mailto:Javalist@lists.javaforum.hu" style="color: blue; text-decoration: underline; ">Javalist@lists.javaforum.hu</a><br><a href="http://lists.javaforum.hu/mailman/listinfo/javalist" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.javaforum.hu/mailman/listinfo/javalist</a><o:p></o:p></p></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; ">_______________________________________________<br>Javalist mailing list<br><a href="mailto:Javalist@lists.javaforum.hu" style="color: blue; text-decoration: underline; ">Javalist@lists.javaforum.hu</a><br><a href="http://lists.javaforum.hu/mailman/listinfo/javalist" style="color: blue; text-decoration: underline; ">http://lists.javaforum.hu/mailman/listinfo/javalist</a><o:p></o:p></div></div><div style="margin-right: 0cm; margin-left: 0cm; font-size: 12pt; font-family: 'Times New Roman', serif; margin-top: 0cm; margin-bottom: 0.0001pt; "><o:p> </o:p></div></div></div></div>_______________________________________________<br>Javalist mailing list<br><a href="mailto:Javalist@lists.javaforum.hu" style="color: blue; text-decoration: underline; ">Javalist@lists.javaforum.hu</a><br><a href="http://lists.javaforum.hu/mailman/listinfo/javalist" style="color: blue; text-decoration: underline; ">http://lists.javaforum.hu/mailman/listinfo/javalist</a><br></div></span></blockquote></div><br></div></body></html>