delcolumn.java

NTsky新闻发布v1.0(提供JavaBean)

package ntsky.admin.column;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.HttpServletRequest;
import ntsky.database.DBConnect;

public class DelColumn{
	private int classid; 
    //获取classid的值
	public int getclassid(HttpServletRequest request, String Sclassid){
		try{
			classid = Integer.parseInt(request.getParameter(Sclassid).trim());
       }
       catch(Exception e){
			System.out.println("delcolumn"+e.getMessage());	
	   }
       return classid;
    }
	// 删除
	public void delcolumn() throws Exception{
		String sql_class = "delete from class where classid=?;";
		String sql_kind = "delete from kind where classid=?;";
		String sql_article = "delete from article where classid=?;";
		DBConnect dbc_class = new DBConnect(sql_class);
		dbc_class.setInt(1,classid);
		DBConnect dbc_kind = new DBConnect(sql_kind);
		dbc_kind.setInt(1,classid);
		DBConnect dbc_article = new DBConnect(sql_article);
		dbc_article.setInt(1,classid);
		dbc_class.executeUpdate();
		dbc_kind.executeUpdate();
		dbc_article.executeUpdate();
	}
}