deletedb.java

一个小型的BBS系统

package bean.deleteDB;
import java.sql.*;
import java.util.*;
import bean.condb.*;
public class DeleteDB {
	Statement stmt;
	ResultSet rs;
	Connection con;
	public DeleteDB(){
		Condb condb = new Condb();
		this.con = condb.con();
	}
	public void DDB(){
		String sql="delete from bbsform1";
		String sql1="update bbsstate set [num]=0";
		String sql2="delete from formcontent";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			stmt.executeUpdate(sql1);
			stmt.executeUpdate(sql2);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//删除用户
	public void DeleteUserDB(String id){
		String sql="delete from UserID where ID='"+id+"'";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//级联删除版主信息
	public void DeleteState(String id,String state){
		
		String sql="";
		String tempstate="";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			//查询出版块信息
			StringTokenizer t = new StringTokenizer(state, " ");//以空格为划分进行版块筛选
			Vector a = new Vector();
			while(t.hasMoreTokens()){
		//		a.addElement(t.nextToken());
				tempstate = t.nextToken();
				System.out.println(tempstate+"  "+state);
				sql = "select master from bbsstate where bbs_entry ='"+tempstate+"'";
				String temp="";
				String res="";
				rs = stmt.executeQuery(sql);
				while(rs.next()){
					temp = rs.getString(1);
					System.out.println(temp);
				}
				int s = temp.indexOf(id);
				if(s!=-1){
				//要删字段在中间
				if((temp.length()-1-s) > id.length()&&s!=0){
					res = temp.substring(0, s-1);
					res = res +temp.substring(s+id.length()+1);
				}
				//要删字段在开头 且不是最后一个
				else if(s==0 && (temp.length()-1-s) > id.length()){
					res = temp.substring(id.length()+1);
				}
				//要删字段在末尾 且不是开头
				else if(s!=0 && (temp.length()-s) == id.length()){
					res = temp.substring(0, s-2);
				}
				//要删字段就是整个字段
				else {
					res = "*";
				}
				res = res.trim();
				sql ="update bbsstate set [master] ='"+res+"' where bbs_entry='"+tempstate+"'";
				stmt.executeUpdate(sql);
				}
			}
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString()+"错误出现在DeleteState()中");
		}
	}
	//清空版主信息
	public void DeleteMaster(String id){
		String sql="update UserID set [state] ='*' where ID ='"+id+"'";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			
			stmt.executeUpdate(sql);
			sql= "update UserID set [Control] =0 where ID ='"+id+"'";
			stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//删除帖子
	public void DeletePost(String id,String floor){
		String sql="update formcontent set [content]='该贴已被删除' where url='"+id+"' and floor ="+floor;
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);		
			stmt.executeUpdate(sql);//删贴		
			
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//被删内容帖子del位置1
	public void UpdateDel(String id,String floor){
		String sql= "update formcontent set [del] = 1 where url ='"+id+"' and floor="+floor;
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//被删内容帖子DEL为置0
	public void UpdateUnDel(String id,String floor){
		String sql= "update formcontent set [del] = 0 where url ='"+id+"' and floor="+floor;
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//bbsform1中del位 置1 
	public void UpdateDelForm(String id){
		String sql= "update bbsform1 set [del] = 1 where url ='"+id+"'";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		//	sql ="update bbsform1 set [title] = '[封]'+[title] where url= '"+id+"'";
		//	stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//解封帖子
	public void UpdateUnDelForm(String id){
		String sql= "update bbsform1 set [del] = 0 where url ='"+id+"'";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//删除版块,恢复版块
	public void DelState(String bbs_entry,int n){
		String sql= "update bbsstate set [del] = "+n+" where bbs_entry ='"+bbs_entry+"'";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
		
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	
}