forum_oper.java

使用jsp+java开发的bbs论坛源码

package com.bbs.forum;

import java.io.UnsupportedEncodingException;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import com.bbs.util.*;

public class Forum_Oper extends ForumParent {
	private Connection conn = null;

	private Statement state = null;

	private ResultSet rs = null;

	private PreparedStatement pst = null;

	public Forum_Oper() {
		conn = DBconnection.getConnect();

	}

	public String insertForum() {
		String returnstr = "error";

		String sql = "insert into forum(forum_title,forum_disc,forum_manager_id,forum_sort_id) values('"
				+ this.getForuminfo().getForum_title()
				+ "','"
				+ this.getForuminfo().getForum_disc()
				+ "',"
				+ this.getForuminfo().getForum_manager_id()
				+ ","
				+ this.getForuminfo().getForum_sort_id() + ")";
		try {
			state = conn.createStatement();
			int i = state.executeUpdate(sql);
			if (i == 1) {
				returnstr = "success";

			} else {
				returnstr = "error";
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}

		return returnstr;

	}

}