query problem

Here is a jsp code that displays the employee names from the database table who are Marketing Managers.

<%@page language="java"%>
<%@page import="java.sql.*"%>

<table border="1">

<%
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
String query = "select Ename from employee where Designation='Marketing Manager'";
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(query);
while(rs.next()){
%>
<tr>
<td><input type="text" name="name" value="<%=rs.getString("name")%>"></td>
</tr>
<%
}
}
catch(Exception e){}
%>
</table>