newreply.java

Jsp实现的简单的论坛管理系统,对学习Jsp+Servlet+JavaBean很有帮助

package org.jetic.web.notepad;

/**
 * Title:        经天网络
 * Description:
 * Copyright:    Copyright (c) 2000<br>
 * Company:      www.jetic.com  经天<br>
 * @author hover
 * @version 1.0
 */

import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.jetic.util.Charset;

public class NewReply {

    private int noteid = 1;
    private String guest = "";
    private String email = "";
    private String ip = "";
    private String content = "";

    public void setNoteid(int noteid)       { this.noteid = noteid; }
    public int getNoteid()                  { return noteid; }
    public void setGuest(String guest)      { this.guest = Charset.NetworkToLocal(guest); }
    public String getGuest()                { return Charset.LocalToNetwork(guest); }
    public void setEmail(String email)      { this.email = Charset.NetworkToLocal(email); }
    public String getEmail()                { return Charset.LocalToNetwork(email); }
    public void setIp(String ip)            { this.ip = Charset.NetworkToLocal(ip); }
    public String getIp()                   { return Charset.LocalToNetwork(ip); }
    public void setContent(String content)  { this.content = Charset.NetworkToLocal(content); }
    public String getContent()              { return Charset.LocalToNetwork(content); }

    public boolean Check() {
        return !(
            guest.equals("") || guest == null ||
            content.equals("") || content == null
            );
    }

    public void AddNew() {
        DBConnect db;
        ResultSet rs;
        String strSql;
        String regdate;

        strSql =
            "insert into tbNotepadReply (fdiNote, fdcGuest, fdcEmail, fdcIP," +
            "fdcTime, fdcContent) values(?, ?, ?, ?, ?, ?)";

        // 取得当前时间
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        regdate = formatter.format(new Date());

        try {
            db = new DBConnect(strSql);
            db.setInt(1, noteid);
            db.setString(2, this.guest);
            db.setString(3, this.email);
            db.setString(4, this.ip);
            db.setString(5, regdate);
            db.setString(6, this.content);

            db.executeUpdate();

            // 回复数加一
            db.clearParameters();
            db.prepareStatement("update tbNotepad set fdiReply = fdiReply + 1 " +
                "where ID = ?");
            db.setInt(1, noteid);
            db.executeUpdate();
        }
        catch (Exception ex) {
            System.out.print("错误 (NewReply.AddNew())：");
            ex.printStackTrace(System.err);
        }
    }
}