⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 modify.jsp.htm

📁 实现论坛的各种功能 有前后台的管理
💻 HTM
字号:
🔍 
<%@page contentType="text/html;charset=gb2312"%> 
<%@page import="java.sql.*"%>
<html>
<head>
<title>修改文章</title>
</head>

<body>
<%//防止某些用户不进行登陆，直接想进入此页面
  if (session.getAttribute("username")==null){
	response.sendRedirect("login1.jsp");	
   }%>
<%
  //得到文章的标识ID
  String id=request.getParameter("id");
  //得到当前所在讨论区的编号bid
  int bid=Integer.parseInt(request.getParameter("bid"));
  //得到要回复文章的标识ID
  int reid=Integer.parseInt(request.getParameter("reid"));
  //接收登陆用户的身份等级信息rankid
  int rankid=Integer.parseInt(request.getParameter("rankid"));
  String boardtitle="";
  if(bid==1) boardtitle="JSP技术";
  if(bid==2) boardtitle="音乐星空";
  //加载数据库驱动并用连接池连结数据库
  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(); 

  //查询要修改文章的详细信息
  sql="select PostTime,Title,Content,Emotion from Articles where ID="+id;
  ResultSet rs =stmt.executeQuery(sql);
  rs.next();
  String title=rs.getString("Title");
%>
&nbsp&nbsp&nbsp&nbsp&nbsp<%=boardtitle%>&gt;&gt;修改文章<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>&nbsp&nbsp&nbsp;修改文章&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp;
     <a href="javascript:FM.submit();">确定</a>
     &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp;<a href="javascript:history.back();">取消</a>  
  </td>
</tr>
<tr>
  <td bgcolor="#efefef" align="center">发表日期：</td>
  <td bgcolor="#efefef"><%=rs.getString("PostTime")%></td>
</tr>
<tr>
  <td bgcolor="#efefef" align="center">标题：</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">内容</td>
  <td bgcolor="#efefef">
    <textarea name="content" rows="10" cols="100"><%=rs.getString("Content")%></textarea>
  </td>
</tr>
</form>
</table>
<%//关闭连接
  rs.close();
  stmt.close(); 
 conn.close();
  
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -