<%getTeainfoList()%><%Function getTeainfoList()
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
String sql="select Teainfo_AutoID,Teainfo_Teaname from Teainfo order by Teainfo_AutoID asc"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {%> 
    <option value="<%=rs.getString("Teainfo_AutoID")%>"><%=rs.getString("Teainfo_Teaname")%></option>
<%}%> 
<%rs.close(); 
stmt.close(); 
conn.close();
End Function %>