Filter Option on drop down menu

I want filter USER table (from mysql) by username to retrieve record after selecting drop down (User Name) menu.

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>

<%@ page import="java.io.*,java.sql.*" %>
	<%@ page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>myAdmin Panel</title>
</head>
<body>
<%
<%
response.setContentType("text/xml");
 
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/shipping_order","root","root");
Statement st = con.createStatement();

String username = request.getParameter("q");

ResultSet rs = st.executeQuery("select * from USER where username="+username);
	      
	if(rs.next())
	{
	 
		out.println("<user>");
		out.println("<username>"+rs.getString(1)+"</username>");
		out.println("<city>"+rs.getString(2)+"</city>");
		out.println("<contact>"+rs.getInt(3)+"</contact>");
		out.println("</user>");
	 
	}
 
rs.close();
st.close();
con.close();
 
%>

So what's the problem?

And, please be sure to use code tags when posting code to the forums. Unformatted or unindented code is extremely hard to read and many people that might be able to help you will just move along to posts that are easier to read. Please click this link ⇒ UseCodeTags ⇐ for more information. Properly indented and formatted code greatly increases the probability that your question will get quicker, better answers.

Hello All,

I got my solution, there was an syntax error inline var xmlDoc = xmlHttp.responseXML.documentElement;
Thanks.