81,092
社区成员
发帖
与我相关
我的任务
分享
<td width="85%" height="20" class="menu">
<%
try
{
Con = DataBaseConnection.getConnection();
}
catch(Exception e)
{
e.printStackTrace();
}
sql="select channelname,tolocation from 某表名 order by 某字段 asc";
stmt=Con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
rs=stmt.executeQuery(sql);
while(rs.next())
{
channelname=rs.getString("channelname");
tolocation=rs.getString("tolocation");
%>
<a href="<%=tolocation%>"> <%=channelname%></a><span class="line">|</span>
<%
}
rs.close();
stmt.close();
%>