?? newswind.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<%!
String id = "";
String sql = "";
ResultSet rs = null;
ResultSet rsTmp = null;
%>
<html>
<head>
<title>新聞</title>
<link rel="stylesheet" type="text/css" href="news.css">
</head>
<%
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) ;
}
id = request.getParameter("id");
sql="SELECT * from news where ID=" + id;
rs = stmt.executeQuery( sql );
if(!rs.next()) {
out.println("錯誤的ID號");
rs.close();
}else {
%>
<table width="100%" HEIGHT=30% border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr bgcolor="#FAD195">
<td height=20 align=center><b><%=rs.getString("title")%></b></td>
</tr>
<tr>
<td valign=top>
<p><%=rs.getString("content")%>
</tr>
</table>
<br><b>相關新聞：</b><ul>
<%
sql="SELECT * from news where ID<>"+id+" and keyw='" + rs.getString("keyw")+"' order by ID desc";
rs.close();
rs = stmt.executeQuery(sql);
while(rs.next()) {
%>
<li><a href=newswind.jsp?id=<%=rs.getInt("ID")%>><u>
<%=rs.getString("title")%></u></a>--
<%=rs.getString("author")%>
【<%=rs.getDate("times").toString()%>】
<%}%>
<hr>
<p align="left"><b>相關評論:</b></p>
<%
sql="SELECT * from gbook where ping=0 and news_id="+id+" order by news_id desc";
rs = stmt.executeQuery(sql);
while(rs.next()) {
%>
<li><%=rs.getString("name")%>-- 【<%=rs.getDate("gtime").toString()%>】<p>
<%=rs.getString("content")%>
<hr>
<%
}
}
%>
</ul>
<body bgcolor="lightyellow" text="#000000">
<center><font color="blue" size="6">發表評論</font></center>
<form action="gform.jsp" method="post">
<div align="center">
<table border="0" width="493">
<tr>
<td><img src="2.gif" width="16" height="16">您的姓名：</td>
<td colspan="2">
<input type="TEXT" name="Name" size="37" class="yk9">
</td>
</tr>
<tr>
<td colspan="3"><img src="2.gif" width="16" height="16">留言內容：</td>
</tr>
<tr>
<td colspan="3">
<textarea cols="50" rows="9" name="Memo" class="yk9"></textarea>
</td>
</tr>
<tr align="center">
<td colspan="3">
<input type="hidden" name="id" value="<%=id%>">
<font color="blue"><b>匿名發表</b></font><input type="checkbox" name="nm" value="yes"><br>
<input type="Submit" value="確定送出" class="yk9">
<input type="reset" value="擦掉重寫" class="yk9" name="Reset">
</td>
</tr>
</table>
</div>
</form>
<p> </p><center><a href="default.jsp"><b>查看新聞</b></a></center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -