onClick button Search

[Lester Carmelotes]

Hi Guys,

I need help in achieving this onClick button Search if it works.
This is how it goes, when I click the search button a table will show with a data fetching from the database. But I have a null results. I've used only one jsp page.
I tried to works this code but don't have luck.

<script type="text/javascript">
<!--

function showStudent() {
    var ele = document.getElementById("studnt");
    if(ele.style.display == "none") {
               
        ele.style.display = "block";   
    }
}

//-->
</script>

<div class="stdh">Search Student</div>
		<form action="" method="post" name="stdform" >
		<table>	
			<tr><td>First Name:</td>	<td><input type="text" name="fname" id="fname" /></td></tr>
			<tr><td>Last Name:</td><td><input type="text" name="lname" id="lname" /></td></tr>			
			<tr><td>Student ID:</td>	<td><input type="text" name="stdid" id="stdid" /></td></tr>
			<tr style="display:none;"><td></td><td><input type="text" name="dte" id="dte" value=""></td></tr>
			<tr style="display:none;"><td></td><td><input type="text" name="std" id="std" value="Old Student" /></td></tr> 		
		</table>	
		<input type="button" value="Search Student" onclick="return showStudent();" />	
		</form>	
		
<div id="studnt" style="display:none;">
<div class="stdh">Student Records</div>
<div class="studh">
<ul>
	<li class="s1">Student ID</li>
	<li class="s2">Name</li>
	<li class="s3">Course</li>
	<li class="s4">Year Level</li>
	<li class="s5">Semester</li>
	<li class="s6">School Year</li>
</ul>
</div>
<div class="scrol">
	<table>
	
 <% 
 
 String stdid = request.getParameter("stdid");
 String lname = request.getParameter("lname");
 String fname = request.getParameter("fname");
 
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection conn = DriverManager
					.getConnection("jdbc:mysql://localhost/db_wbsb?user=root&password=");
			Statement stat = conn.createStatement();
			rset = stat
					.executeQuery("select * from users  where user ='"+ stdid +"' and fname = '"+ fname+ "' and lname'"+ lname +"'");
		while (rset.next()) {
		%>
		<tr>		
		<td><%=rset.getString("user")%></td>
		<td><%=rset.getString("fname")%> <%=rset.getString("mi")%>. <%=rset.getString("lname")%></td>
		<td><%=rset.getString("course")%></td>
		<td><%=rset.getString("YearLevel")%></td>
		<td><%=rset.getString("Semester")%></td>
		<td><%=rset.getString("SchoolYear")%></td>	
		</tr>	
		<%
				
		}
		%>
	
	<%
		//**Should I input the codes here?**
		} catch (Exception e) {
			out.println("wrong entry" + e);
		}
	%> 
	</table>	
	
</div>  		
</div>

Any ideas guys if it will work?


Thanks in Advanced

[Sam Jimzz]

Have you tried this ..??

 <td><%=rset.getString("user")!=null ? rset.getString("user") :""%></td>  

Read here in detail..

[Lester Carmelotes]

I tried it but it gives me null results or an error:

wrong entrycom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''null'' at line 1