post.java

JAVA+JSP程序系统-华源网络科技论坛

package org.jetic.web.techbbs;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import java.sql.*;
import org.jetic.util.Format;

/**
 * Title:        华源技术论坛
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      GBSOURCE
 * @author fainter
 * @version 1.0
 */

public class post {

    /**
     * 检查用户输入是否有效
     */
    public boolean
    Check(HttpServletRequest request) {
        String title = request.getParameter("title");
        String content = request.getParameter("content");

        return !(title.equals("") || title == null ||
            content.equals("") || content == null);
    }

    /**
     * 插入数据库
     */
    public boolean
    AddNew(HttpServletRequest request,HttpSession session) {
        Format format = new Format();
        String userid = (String) session.getValue("userid");
        String title = request.getParameter("title").trim();
        title = format.toSql(title);
        String icon = request.getParameter("iconid");
        String content = request.getParameter("content");
        content = format.toSql(content) + " ";
        String mainid = request.getParameter("boardID");
        try {
            Mssql conn = new Mssql();
            conn.executeUpdate("insert into tbtopic(fdimain,fdcwriter,fdctitle,fdiicon,fdcmemo) values(" + mainid + ",'" + userid + "','" + title + "'," + icon + ",'" +content + "') ");
            conn.close();
            return true;
        }
        catch (Exception ex) {
            System.err.print("Post.AddNew():");
            ex.printStackTrace(System.err);
            return false;
        }
    }
    public boolean  AddRe(HttpServletRequest request,HttpSession session) {
        Format format = new Format();
        String userid = (String) session.getValue("userid");
        String title = request.getParameter("title").trim();
        title = format.toSql(title);
        String icon = request.getParameter("iconid");
        String content = request.getParameter("content");
        content = format.toSql(content) + " ";
        String topicid = request.getParameter("articleID");
        String mainid = request.getParameter("boardID");
        try {
            Mssql conn = new Mssql();
            conn.executeUpdate("insert into tbtopic(fditopic,fdimain,fdcwriter,fdctitle,fdiicon,fdcmemo) values(" + topicid + "," + mainid + ",'" + userid + "','" + title + "'," + icon + ",'" +content + "') ");
            return true;
        }
        catch (Exception ex) {
            System.err.print("Post.AddNew():");
            ex.printStackTrace(System.err);
            return false;
        }
    }

}