?? delinf.java
字號:
package com.service;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.data.Bbs;
import com.db.DataProcess;
public class delInf extends HttpServlet {
/**
* Constructor of the object.
*/
public delInf() {
super();
}
/**
* Destruction of the servlet. <br>
*/
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
// Put your code here
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/xml;charset=utf-8");
response.setHeader("Cache-Control","no-cache");
PrintWriter out = response.getWriter();
request.setCharacterEncoding("UTF-8");
StringBuffer backInf=new StringBuffer();
HttpSession sess=request.getSession(true);
String del=request.getParameter("del");//讀要刪除的用戶類型
if(del.equals("banz")){//刪除版主
System.out.println("刪除斑主要");
int board_id=Integer.parseInt(request.getParameter("board_id"));//讀取版面id
deleboard(board_id);//刪除斑竹信息
//查詢版主帖子
String sql="select * from bbs where board_id="+board_id;
Connection con=DataProcess.getConnection();
Statement pStmt=null;
ResultSet rs=null;
Bbs bbs=new Bbs();
try{
pStmt=con.createStatement();
rs=pStmt.executeQuery(sql);
if(rs.next()){
int bbs_id=rs.getInt("bbs_id");
delebbs(bbs_id);//刪除帖子信息
}
}catch(Exception e){
e.printStackTrace();
}finally{
try {
rs.close();
pStmt.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}else{
//刪除帖子
int bbs_id=Integer.parseInt(request.getParameter("bbs_id"));//讀取bbs_id
delebbs(bbs_id);//調用刪除函數
}
out.print(backInf.toString());
out.flush();
out.close();
}
/**
* Initialization of the servlet. <br>
*
* @throws ServletException if an error occure
*/
public void deleboard(int board_id){//刪除斑竹
String sql="delete from board where board_id="+board_id;
DataProcess.ExeQuery(sql);
}
public void delebbs(int bbs_id){//刪除帖子
String sql1="delete from bbs where bbs_id="+bbs_id;
String sql2="delete from bbsub where bbs_id="+bbs_id;
if(DataProcess.ExeQuery(sql1)){
System.out.println("true");
}
DataProcess.ExeQuery(sql2);
}
public void init() throws ServletException {
// Put your code here
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -