admin.jsp
来自「JSP+oracle开发实例精粹》随书光盘」· JSP 代码 · 共 74 行
JSP
74 行
<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="yhgl.connectDB" />
<html>
<head>
<title>投票管理</title>
</head>
<body>
<table>
<tr>
<td><a href="index_add.jsp">新建投票</a></td>
</tr>
</table>
<%
String sql = "select * from WSTP_LANMU";
ResultSet rs = null;
try
{
rs = db.executeQuery(sql);
if(rs.next())
{
%>
<table>
<tr>
<td width="60%">栏目</td>
<td width="40%">操作</td>
</tr>
<tr>
<%
String id = rs.getInt("id");
%>
<td width="60%"><%=rs.getString("TOPIC")%></td>
<td width="40%"><a href="delete.jsp?id=<%=id%>">删除</a><a href="update.jsp?id=<%=id%>">修改</a></td>
</tr>
<%
while(rs.next())
{
id = rs.getInt("id");
%>
<td width="60%"><%=rs.getString("TOPIC")%></td>
<td width="40%"><a href="delete.jsp?id=<%=id%>">删除</a><a href="update.jsp?id=<%=id%>">修改</a></td>
</tr>
<%
}
%>
</table>
<%
}
else
{
%>
目前没有投票项目!
<%
}
}
catch(Exception e)
{
e.printStackTrace();
}
finally
{
try
{
db.closeDB();
rs.close();
}
catch(Exception ee)
{
ee.printStackTrace();
}
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?