<div>
although I prefer single quotes since there's no need for escape characters:<br />
<br />
ResultSet rs1 = stmt.executeQuery(&quot;select password from userdesc where password like '&quot;+pass+&quot;' and name like '&quot;+name+&quot;'&quot;);
</div>


although I prefer single quotes since there's no need for escape characters:

ResultSet rs1 = stmt.executeQuery("select password from userdesc where password like '"+pass+"' and name like '"+name+"'");

<div>
If you are doing a like... that I guess you need a % in there as well...<br />
<br />
<br />
ResultSet rs1 = stmt.executeQuery(&quot;select password from userdesc where password like '&quot;+pass+&quot;%' and name like '&quot;+name+&quot;%'&quot;);
</div>


If you are doing a like... that I guess you need a % in there as well...


ResultSet rs1 = stmt.executeQuery("select password from userdesc where password like '"+pass+"%' and name like '"+name+"%'");

<div>
<div class="content wysiwyg-content">
<br />
&nbsp;Is this syntax correct because it throwsan error for me: &nbsp; <br />
&nbsp;ResultSet rs1 = stmt.executeQuery(&quot;select password from userdesc where password like \&quot;&quot;+pass+&quot;\&quot;&quot; and name like \&quot;&quot;+name+&quot;\&quot;&quot;);
</div>
</div>



 Is this syntax correct because it throwsan error for me:   
 ResultSet rs1 = stmt.executeQuery("select password from userdesc where password like \""+pass+"\"" and name like \""+name+"\"");

jsp/mysql syntax

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.