<%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 %>
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 %>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货