How do i divide drop down menu codes into servlet, dao and jsp

See more:

Java

JSP

servlet

DropDownList

I am trying to avoid java code in jsp file. but i couldnt figure the solution. so i ended up mixing the codes :( how can i divide this code? PLEASEEE HELPPP...

Thank you very much.

What I have tried:

<select>
<option selected disabled>Lecturers Name</option>
<%
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:xe";
String username="sys as sysdba";
String password="sys";
String query="select lecturerFullname from lecturer";
Connection con=DriverManager.getConnection(url,username,password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{

%>

<option><%=rs.getString("lecturerFullname") %></option>

<%

}
%>
<%
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
%>

</select>