uparticle.java

来自「NTsky新闻发布v1.0(提供JavaBean)」· Java 代码 · 共 111 行

package ntsky.news;

import java.sql.*;
import javax.servlet.http.*;
import ntsky.database.*;
import ntsky.common.*;

public class UpArticle{
	
	private int articleid;
	private int column;
	private int kind;
	private String title = null;
	private String content = null;
	private String articlefrom = null;
	private int getcolumn;
	
	//文章编号
	public int getarticleid(HttpServletRequest request, String Sarticleid){
		try{
			articleid = Integer.parseInt(request.getParameter(Sarticleid).trim());
       }
       catch(Exception e){
			System.out.println("delcolumn"+e.getMessage());	
	   }
       return articleid;
    }
	public int articleid(int articleid){
		this.articleid = articleid;
		return this.articleid;
	}
	//栏目
	public void setColumn(int column){
		this.column = column;
	}
	public int getColumn(){
		return this.column;
	}
	//类别
	public void setKind(int kind){
		this.kind = kind;
	}
	public int getKind(){
		return this.kind;
	}
	//标题
	public void setTitle(String title){
		this.title = CodeFilter.toHtml(title);
	}
	public String getTitle(){
		return this.title;
	}
	//文章内容
	public void setContent(String content){
		this.content = CodeFilter.toHtml(content);
	}
	public String getContent(){
		return this.content;
	}
	//出处
	public void setArticlefrom(String articlefrom){
		this.articlefrom = CodeFilter.toHtml(articlefrom);
	}
	public String getArticlefrom(){
		if(articlefrom == null){
			articlefrom = "";
			return articlefrom;
		}
		return this.articlefrom;
	}	
	/**
	*更新数据
	*/
	//类别匹配
	public int getcolumn() throws Exception{
		String sql = "select classid from kind where id=?;";
		DBConnect dbc = new DBConnect(sql);
		dbc.setInt(1,kind);
		ResultSet rs = dbc.executeQuery();
		rs.next();
		getcolumn = rs.getInt("classid");
		rs.close();
		rs = null;
		return getcolumn;
	}
	public void UpArticle(){
		String sql = "update article set classid=?,id=?,title=?,content=?,articlefrom=? where articleid=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,column);
			dbc.setInt(2,kind);
			dbc.setString(3,title);
			dbc.setString(4,content);
			dbc.setString(5,articlefrom);
			dbc.setInt(6,articleid);
			dbc.executeUpdate();
		}
		catch(Exception e){
			System.out.println("updateArticle" + e.getMessage());
		}		
	}
	//跳转
	public void backpsl(HttpServletResponse response, String url){
		try{
			response.sendRedirect(url);
	   }
       catch(Exception e){
			System.out.println("delcolumn"+e.getMessage());	
	   }
    }
}