insarticle.java

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

package ntsky.news;

import java.sql.*;
import ntsky.database.*;
import ntsky.common.*;

public class InsArticle{

	private int column;
	private int kind;
	private String title = null;
	private String content = null;
	private String articlefrom = null;
	private int top;
	private ResultSet rs = null;
	private int getcolumn;
	/**
	*参数的获取
	*/
	//栏目
	public int column(int column){
		this.column = column;
		return this.column;
	}
	//类别
	public int kind(int kind){
		this.kind = kind;
		return this.kind;
	}
	//标题
	public String title(String title){
		this.title = CodeFilter.toHtml(title);
		return this.title;
	}
	//文章内容
	public String content(String content){
		this.content = CodeFilter.toHtml(content);
		return this.content;
	}
	//出处
	public String articlefrom(String articlefrom){
		this.articlefrom = CodeFilter.toHtml(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);
		rs = dbc.executeQuery();
		rs.next();
		getcolumn = rs.getInt("classid");
		return getcolumn;
	}
	public void insArticle(String sessionuser){
		String sql = "insert into article(classid,id,title,content,author,articlefrom,top,state,tag,date,time) VALUES(?,?,?,?,'"+sessionuser+"',?,0,0,1,now(),now());";
		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.executeUpdate();
		}
		catch(Exception e){
			System.out.println("insertArticle" + e.getMessage());
		}		
	}
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}	
	}
}