?? default.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<%!
String sql = "";
int totalRecords = 1;
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新聞</title>
<link rel="stylesheet" type="text/css" href="news.css">
<Script language="JavaScript">
//打開新窗口函數NewsWindow
function NewsWindow(id)
{
window.open('newswind.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</Script>
</head>
<body bgcolor="lightgreen">
<%
Connection conn=null;
Statement stmt= null;
ResultSet rs =null;
try
{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)}; DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn =DriverManager.getConnection(strurl);
stmt= conn.createStatement();
rs= stmt.executeQuery("select * from news");
}
catch(Exception e)
{
out.println("輸出錯誤!") ;
out.println(e) ;
}
rsTmp = stmt.executeQuery("select count(id) as countid from news");
rsTmp.next();
totalRecords = rsTmp.getInt("countid");
rsTmp.close();
sql="SELECT * from news order by ID desc";
rs = stmt.executeQuery( sql );
if(!rs.next()) {
out.println("<p>還 沒 有 任 何 新 聞</p>");
} else {
%>
<p><font size=5><strong><center>全部新聞</center></strong></font><table border=1 borderColorDark=#ffffec borderColorLight=#5e5e00 cellPadding=1 cellSpacing=0 width=100%>
<tr bgcolor=orange align=center><td>標題</td><td>作者</td><td>日期</td></tr>
<%
int cc = 1;
do {
if(cc % 2 == 1)
out.println("<tr bgcolor=lightyellow>");
else
out.println("<tr BGCOLOR=lightblue>");
%>
<td><a href="newswind.jsp?id=<%=rs.getInt("ID")%>"><u>
<%=rs.getString("title")%></u></a></td>
<td><%=rs.getString("author")%></td>
<td><%=rs.getDate("times").toString()%>
<%
out.println("</td></tr>");
cc++;
} while(rs.next());
out.println("</table><p>共" + totalRecords + "條新聞");
}
rs.close();
%>
<a href=login.jsp><center><b>管理員登陸</b></center></a>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -