sendservlet.java

简易java框架开源论坛系统源码easyjf_bbs0.1.rar

package servlet;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import conn.*;
import bean.*;
import face.*;
import java.util.List;
import java.util.Iterator;
import util.*;

public class SendServlet extends HttpServlet
{
	public void init(ServletConfig config) throws ServletException
	{
		super.init(config);
	}

	public void service(ServletRequest request, ServletResponse respone) throws ServletException,IOException
	{
		request.setCharacterEncoding("gb2312");
		String sends = request.getParameter("sends");
		PrintStream out = new PrintStream(respone.getOutputStream());
		if(sends == null)
		{
			try
			{
				FlashDbDao dd = FlashDbDao.instance(Constants.driver,
			Constants.url,Constants.username,Constants.password);
				String sql = "select edition_id,edition_title from bbs_edition";
				dd.setPstmt(sql);
				TwoBean tb = new TwoBean();
				String allId = "";
				String allTitle = "";
				List ls = dd.getList(tb);
				for(Iterator it = ls.iterator(); it.hasNext(); )
				{
					tb = (TwoBean)it.next();
					allId += tb.getId() + "#";
					allTitle += tb.getTitle() + "#";
				}
				out.print("&allId=" + allId.substring(0, allId.length() -1));
				out.print("&allTitle=" + allTitle.substring(0, allTitle.length() -1));
			}
			catch (Exception e)
			{
				System.out.println("加载send出现异常!");
			}
		}
		else
		{
			String edition = request.getParameter("editionId");
			String type = request.getParameter("type");
			String title = request.getParameter("titleText");
			String content = request.getParameter("contentArea");
			String username = request.getParameter("username");
			int editionId = Integer.parseInt(edition);
			try
			{
				FlashDbDao dd = FlashDbDao.instance("com.mysql.jdbc.Driver",
				"jdbc:mysql://127.0.0.1:3306/flashbbs","root","sy251033");
				String sql = "insert into bbs_tiezi (tiezi_type,tiezi_title,tiezi_content,tiezi_count,user_name,edition_id)"
					+ "values(?,?,?,?,?,?)";
				dd.setPstmt(sql);
				dd.setPstmtString(1,type);
				dd.setPstmtString(2,title);
				dd.setPstmtString(3,content);
				dd.setPstmtInt(4,0);
				dd.setPstmtString(5,username);
				dd.setPstmtInt(6,editionId);
				if(dd.insert())
				{
					out.println("&esate=ok");
				}
			}
			catch (Exception e)
			{
				System.out.println("发送出现数据异常!");
			}
		}
	}
}