📄 list_pro.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<html>
<head>
<title>北京演出票务网管理中心——公告列表</title>
</head>
<script language="JavaScript">
function check(mark)
{
if(mark==0)
{
alert("删除情况！");
return;
}
}
</script>
<body>
<%
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:TicketSystem";
Connection Con = null;
Statement Stmt = null;
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try
{
Con = DriverManager.getConnection(sConnStr);
}
catch(SQLException e)
{
out.print(e.toString());
}
String editno = null;
Stmt = Con.createStatement(); /*创建JDBC声明*/
ResultSet RS= Stmt.executeQuery("SELECT BulletinID,BulletinTitle,BulletinContents,InputDate,UpdateDate,IsValid FROM Bulletin_table");
String tt;
int i=1;
out.print("<center><font size=5><b>所有公告列表</b><font></center><p><p>");
out.print("<hr size=8 width=85%/><p>");
out.print("<table align=center border=0 cellpadding=0 cellspacing=8 style=color:#666666>");
out.print("<tr><td align=center>序号</td><td align=center>标题</td><td align=center>内容</td><td align=center>插入时间</td><td align=center>更改时间</td><td align=center>是否有效</td>);
while (RS.next()) {
out.print("<tr ><td align=center>");
out.print(i);
out.print("</td><td align=center width=150>");
i++;
editno=RS.getString("BulletinID");
tt = RS.getString("BulletinTitle");
out.print(tt);
out.print("</td><td align=center>");
tt = RS.getString("BulletinContents");
out.print(tt);
out.print("</td><td align=center>");
tt=RS.getString("InputDate");
out.print(tt);
out.print("</td><td align=center width=150>");
tt=RS.getString("UpdateDate");
out.print(tt);
out.print("</td><td align=center>");
tt=RS.getString("IsValid");
out.print(tt);
%>
</td><td align=center>
<a href="del_iden.jsp?delno=<%=editno%>">删除</a> <a href="upd_iden.jsp?updno=<%=editno%>">修改</a>
</td><tr>
<%
}
out.print("</table>");
RS.close();
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -