📄 link.jsp
字号:
<%@page pageEncoding="gb2312"%>
<%@page contentType="text/html;charset=gb2312" %>
<%@include file="conn.jsp"%>
<%
java.sql.PreparedStatement preparedStmt;
java.sql.ResultSet sqlRst;
try
{
request.setCharacterEncoding("gb2312");
preparedStmt = conn.prepareStatement("select link_id,link_name,link_url,link_logo,link_info from icefish_link");
sqlRst = preparedStmt.executeQuery();
%>
<html>
<head>
<title>友情链接论坛</title>
</head>
<body>
<table width="100%" cellpadding=6 height="100" border="1" bordercolorlight="#7777ff" bordercolordark="#7777ff" style="border-collapse:collapse">
<tr>
<td height="25" colspan="2" background="images/skin/1/bg_td.gif">
<font color=#FFFFFF><b>友情链接论坛</b></font>
</td>
</tr>
<tr>
<td bgcolor=#dff2ed align=center height="30">
<font color=#333333>友情链接论坛</font>
</td>
</tr>
<br>
<%
while(sqlRst.next())
{
String link_id = sqlRst.getString(1);
String link_name = sqlRst.getString(2);
String link_url = sqlRst.getString(3);
String link_logo = sqlRst.getString(4);
String link_info = sqlRst.getString(5);
%>
<tr>
<td>
<b>论坛编号</b>: <%=link_id%><br>
<b>论坛名称</b>: <%=link_name%><br>
<b>论坛地址</b>: <%=link_url%><br>
<b>论坛图标</b>: <%=link_logo%><br>
<b>论坛说明</b>: <%=link_info%><br>
<br><a href="linkedit.jsp?link_id=<%=sqlRst.getString("link_id")%>">修改</a> | <a href="linkdelete.jsp?&link_name=<%=sqlRst.getString("link_name")%>">删除</a>
</td>
</tr>
<%}%>
<tr>
<td bgcolor=#dff2ed align=center height="30">
<font color=#333333>
<a href="linkadd.jsp?action=add">增加链接论坛</a>
</font>
</td>
</tr>
</table>
</body>
</html>
<%
sqlRst.close();
preparedStmt.close();
conn.close();
}
catch(java.sql.SQLException e)
{
out.println(e.toString());
}
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -