?? newsedit.jsp
字號:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<%!
String sql = "";
int id = 1;
ResultSet rs = null;
ResultSet rsTmp = null;
Statement stmt= null;
Connection conn=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">
function NewsWindow(id)
{
window.open('newswind.jsp?id='+id,'infoWin', 'height=400,width=600,scrollbars=yes,resizable=yes');
}
</script>
</head>
<body bgcolor="lightyellow">
<%
request.setCharacterEncoding("GBK");
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();
}
catch(Exception e)
{
out.println("語句輸入錯誤!");
}
if(request.getParameter("del")!=null) stmt.executeUpdate("delete * from news where id=" + request.getParameter("del"));
stmt.executeUpdate("delete * from gbook where news_id=" + request.getParameter("del"));
sql="SELECT * from news order by ID desc";
rs = stmt.executeQuery(sql);
if(!rs.next())
out.println("<p>還 沒 有 任 何 新 聞</p>");
else {
%>
<p><font size=6 color="green"><strong><center>全部新聞</center></strong></font><table width=100%>
<%
do {
id = rs.getInt("ID");
%>
<tr><td><a href="newswind.jsp?id=<%=id%>"><u>
<%=rs.getString("title")%></u></a>--
<%=rs.getString("author")%>
【<%=rs.getDate("times").toString()%>】
</td><td align=right><img src=1.gif><a href=newsedit2.jsp?id=<%=id%>>編輯</a>
<img src=2.gif><a href=newsedit.jsp?del=<%=id%>>刪除</a>
<a href=index.jsp?id=<%=id %>>管理留言</a></td></tr>
</td></tr>
<%
}while(rs.next());
}
rs.close();
%>
</table></p></body></link></head><br>
<a href=newsadd.jsp><b>添加新聞</b></a> <a href="default.jsp"><b>查看新聞</b></a><br>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -