editarticle.java

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

package ntsky.news;

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

public class EditArticle{
	private int articleid;
	private ResultSet rs = null;
    //articleid的值
	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 ResultSet rs_editarticle(){
		String sql = "select classid,id,title,content,articlefrom from article where articleid=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,articleid);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("rs_column:" + e.getMessage());
		}
		return rs;
	}
	//栏目
	public ResultSet rs_column(){
		String sql = "select classid,content from class;";
		try{
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("rs_column:" + e.getMessage());
		}
		return rs;
	}
	//类别
	public ResultSet rs_kind(){
		String sql = "select id,content,classid from kind;";
		try{
			DBConnect dbc = new DBConnect();
			rs = dbc.executeQuery(sql);
		}
		catch(Exception e){
			System.out.println("rs_kind:" + e.getMessage());
		}
		return rs;
	}	
	//关闭指针
	public void close() throws Exception{
		if(rs != null){
			rs.close();
		}
	}
}