?? modify.jsp.htm
字號:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<html>
<head>
<title>修改文章</title>
</head>
<body>
<%//防止某些用戶不進(jìn)行登陸，直接想進(jìn)入此頁面
if (session.getAttribute("username")==null){
response.sendRedirect("login1.jsp");
}%>
<%
//得到文章的標(biāo)識ID
String id=request.getParameter("id");
//得到當(dāng)前所在討論區(qū)的編號bid
int bid=Integer.parseInt(request.getParameter("bid"));
//得到要回復(fù)文章的標(biāo)識ID
int reid=Integer.parseInt(request.getParameter("reid"));
//接收登陸用戶的身份等級信息rankid
int rankid=Integer.parseInt(request.getParameter("rankid"));
String boardtitle="";
if(bid==1) boardtitle="JSP技術(shù)";
if(bid==2) boardtitle="音樂星空";
//加載數(shù)據(jù)庫驅(qū)動并用連接池連結(jié)數(shù)據(jù)庫
String sql="";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{
out.print(e);
}
String strDirPath=application.getRealPath(request.getRequestURI());
strDirPath=strDirPath.substring(0,strDirPath.lastIndexOf('\\'))+"\\";
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+strDirPath+"forum.mdb";
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
//查詢要修改文章的詳細(xì)信息
sql="select PostTime,Title,Content,Emotion from Articles where ID="+id;
ResultSet rs =stmt.executeQuery(sql);
rs.next();
String title=rs.getString("Title");
%>
     <%=boardtitle%>>>修改文章<p></p>
<table width="90%" align="center" cellpadding="3" cellspacing="1">
<form name="FM" method="post" action="chktodb.jsp">
<input type="hidden" name="id" value="<%=id%>">
<input type="hidden" name="bid" value="<%=bid%>">
<input type="hidden" name="reid" value="<%=reid%>">
<input type="hidden" name="rankid" value="<%=rankid%>">
<input type="hidden" name="exe" value="modify">
<tr>
<td bgcolor="#009933" colspan=2>   修改文章     
<a href="javascript:FM.submit();">確定</a>
      <a href="javascript:history.back();">取消</a>
</td>
</tr>
<tr>
<td bgcolor="#efefef" align="center">發(fā)表日期：</td>
<td bgcolor="#efefef"><%=rs.getString("PostTime")%></td>
</tr>
<tr>
<td bgcolor="#efefef" align="center">標(biāo)題：</td>
<td bgcolor="#efefef"><%=title%></td>
<input type="hidden" name="title" value="Re <%=title%>">
</tr>
<tr>
<td bgcolor="#efefef" align="center">心情</td>
<td bgcolor="#efefef"><img src="<%=rs.getString("Emotion")%>"></td>
</tr>
<tr>
<td bgcolor="#efefef" align="center">內(nèi)容</td>
<td bgcolor="#efefef">
<textarea name="content" rows="10" cols="100"><%=rs.getString("Content")%></textarea>
</td>
</tr>
</form>
</table>
<%//關(guān)閉連接
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -