?? edittopicservlet.java
字號:
package com.jspdev.servlet;
import com.jspdev.business.*;
import javax.servlet.http.*;
import com.jspdev.util.DatabaseConn;
import java.sql.*;
import java.io.*;
/**
*重新編輯指定的帖子
*/
public class EditTopicServlet extends javax.servlet.http.HttpServlet
{
public void doGet(HttpServletRequest request,HttpServletResponse response)
throws javax.servlet.ServletException,java.io.IOException
{
try
{
/**
*獲得請求中的參數(shù),動態(tài)生成SQL語句。
*/
String type=request.getParameter("type");
String id=request.getParameter("id");
String title=request.getParameter("title");
String author=request.getParameter("author");
String email=request.getParameter("email");
String content=request.getParameter("content");
String sql="";
if(type.equals("topic"))
sql="update topic set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";
else
sql="update reply set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";
Connection con=DatabaseConn.getConnection();
Statement stmt=con.createStatement();
/**
*執(zhí)行數(shù)據(jù)庫更新操作,更新的信息保存到數(shù)據(jù)庫中
*/
stmt.executeUpdate(sql);
stmt.close();
con.close();
PageBusiness pb=new ForumBean();
PageBean pageCtl = pb.listData("1");
request.setAttribute("pageCtl",pageCtl);
}
catch(Exception e)
{
e.printStackTrace();
}
/**
*把視圖派發(fā)到viewForum.jsp
*/
javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("/forum/viewForum.jsp");
dis.forward(request,response);
}
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws javax.servlet.ServletException,java.io.IOException
{
doGet(request,response);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -