editcolumn.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 EditColumn{
	private int classid; 
	private ResultSet rs = null;
    //获取classid的值
	public int getclassid(HttpServletRequest request, String Sclassid){
		try{
			classid = Integer.parseInt(request.getParameter(Sclassid).trim());
       }
       catch(Exception e){
			System.out.println("delcolumn"+e.getMessage());	
	   }
       return classid;
    }
	//获得指针
	public ResultSet rs_editcolumn() 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 close() throws Exception{
		if(rs != null){
			rs.close();
		}
	}
}