editkind.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 EditKind{
	private int id; 
	private ResultSet rs = null;

    //id的值
	public int getid(HttpServletRequest request, String Sid){
		try{
			id = Integer.parseInt(request.getParameter(Sid).trim());
       }
       catch(Exception e){
			System.out.println("editkind"+e.getMessage());	
	   }
       return id;
    }
	//编辑类别
	public ResultSet rs_editkind(){
		String sql = "select id,content,classid from kind where id=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,id);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("editkind:"+e.getMessage());
		}
		return rs;
 	}
	//栏目原值
	public ResultSet rs_column() throws Exception{
		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 void close() throws Exception{
		if(rs != null){
			rs.close();
		}
	}
}