insertcolumn.java

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

/**
********************************
*   NTsky新闻发布系统V 1.0     *
*   功能：添加大栏目
*   代码编写：姚君林
*   编写日期：2003/4/1
*	代码修改：
*   修改日期：			
*******************************
*/
package ntsky.admin.column;
import ntsky.database.*;
import java.sql.*;
public class InsertColumn{
	
	private int classid;
	private String content = null;
	private ResultSet rs = null;

	DBConnect dbc = new DBConnect();
	
	//栏目ID
	public int classid(int classid){
		this.classid = classid;
		return this.classid;
	}
	//栏目
	public String content(String content){
		this.content = content;
		return this.content;
	}

	//判断有无重复记录的指针
	public ResultSet rs_insertcolumn() throws Exception{
		try{
			String sql = "select classid,content from class where classid=?;";
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,classid);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("Column:"+e.getMessage());
		}
		return rs;
	}
	//插入数据
	public void insertcolumn() throws Exception{
		String sql = "insert into class(classid,content) VALUES(?,?);";
		DBConnect dbc = new DBConnect(sql);
		dbc.setInt(1,classid);
		dbc.setString(2,content);
		dbc.executeUpdate();
 	}

	//清空指针
	public void close() throws Exception{
		if(rs != null){
			dbc.close();
			rs.close();
		}
	}
}