articleadd.java

一些数据库的java开发编程

package jdbcbook.msgboard;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;

import jdbcbook.pub.util.*;

/**
 * 发布和处理留言的方法
 */
public class ArticleAdd extends HttpServlet 
{

	public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws IOException, ServletException
	{
		// 取得当前登录用户的信息
		HttpSession session = request.getSession();
		UserInfo userinfo = (UserInfo)session.getAttribute( "session_userinfo" );

		if( userinfo==null )
		{
			// 用户没有登录
			RequestUtil.setMsg( this, request, "notlogon" );
			RequestDispatcher dispatcher = request.getRequestDispatcher( "logon.jsp" );
			dispatcher.forward( request, response );
			return;
		}

		// 取得用户提交的数据
		String title = request.getParameter( "title" );
		String content = request.getParameter( "content" );
		int nArticleID = RequestUtil.getInt( request, "articleid", 0 );
		// 进行权限判断
		if( nArticleID > 0 && !AuthorityBean.hasAuthority( nArticleID, request ) )
		{
			// 用户没有权限
			RequestUtil.setMsg( this, request, "notfundarticle" );
			RequestDispatcher dispatcher = request.getRequestDispatcher( "logon.jsp" );
			dispatcher.forward( request, response );
			return;
		}
		int nFarticleID = RequestUtil.getInt( request, "farticleid", 0 );

		// 构造留言对象，并赋值，然后增加到数据库中
		Article article = new Article();
		article.setArticleID( nArticleID );
		article.setTitle( title );
		article.setContent( content );
		article.setUserID( userinfo.getUserID() );
		article.setHostIP( request.getRemoteAddr() );
		article.setFarticleID( nFarticleID );
		ArticleBean.updateArticle( article );

		// 设置提示信息
		if( nArticleID > 0 )
			RequestUtil.setMsg( this, request, "updatemsgsuccess" );
		else if ( nFarticleID > 0 )
			RequestUtil.setMsg( this, request, "replymsgsuccess" );
		else
			RequestUtil.setMsg( this, request, "leavemsgsuccess" );

		// 跳转到留言列表页面
		RequestDispatcher dispatcher = request.getRequestDispatcher( "articlelist" );
		dispatcher.forward( request, response );
	}
}