reply.java

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

package ntsky.news;

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

public class Reply{
	public int articleid;
	public String user = null;
	public String content = null;
	public ResultSet rs = null;
	//articleid的值
	public int getarticleid(HttpServletRequest request,String Sid){
		try{
			articleid = Integer.parseInt(request.getParameter(Sid).trim());
		}
		catch(Exception e){
			System.out.println("articleid" +e.getMessage());
		}
		return articleid;
	}
	//发表人
	public void setUser(String user){
		this.user = user; 
	}
	public String getUser(){
		return user;
	}
	//发表文章
	public void setContent(String content){
		this.content = content;
	}
	public String getContent(){
		return CodeFilter.toHtml(content);
	}
	//插入记录
	public void insReply(){
		String sql = "insert into reply(articleid,user,content,date,time) VALUES(?,?,?,now(),now());";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,articleid);
			dbc.setString(2,user);
			dbc.setString(3,content);
			dbc.executeUpdate();
		}
		catch(Exception e){
			System.out.println("insertArticle" + e.getMessage());
		}		
	}
	//修改哪条纪录(获取传递的参数)
	public ResultSet rs_Reply(){
		String sql = "select * from reply where articleid=? order by time desc limit 0,1;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,articleid);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("insertArticle" + e.getMessage());
		}	
		return rs;
	}
	//修改纪录
	public ResultSet rs_Replyid(){
		String sql = "select * from reply where id=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setInt(1,articleid);
			rs = dbc.executeQuery();
		}
		catch(Exception e){
			System.out.println("insertArticle" + e.getMessage());
		}	
		return rs;
	}
	//更新记录 
	public void UPReply(){
		String sql = "update reply set user=?,content=? where id=?;";
		try{
			DBConnect dbc = new DBConnect(sql);
			dbc.setString(1,user);
			dbc.setString(2,content);
			dbc.setInt(3,articleid);
			dbc.executeUpdate();
		}
		catch(Exception e){
			System.out.println("insertArticle" + e.getMessage());
		}	
	}
	//跳转
	public void backlae(HttpServletResponse response, String url){
		try{
			response.sendRedirect(url);
	   }
       catch(Exception e){
			System.out.println("delcolumn"+e.getMessage());	
	   }
    }
	//关闭
	public void close() throws Exception{
		if(rs != null){
			rs.close();
			rs = null;
		}
	}
}