怎样读取数据库中的值到下拉列表框中?请帮我看下代码

Question

<select size="1" name="D12">
<%
String driver="com.microsoft.jdbc.sqlserver.SQLSeverDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Job";
 Connection conn=null;
Class.forName( driver ); 
conn = DriverManager.getConnection(url,"sa","");
Statement stmt=null; ResultSet rs=null;
stmt=conn.createStatement("select Trade from Position_Table" );
rs=stmt.executeQuery();
while(rs.next()){
%>
<option> <%=rs.getString("Trade")"%></option> 
<%
}
%>
</select>

Answer 1

while(rs.next()){
<%
尖括号写错方向了