inserttopicservlet.java

java写的一个简单的bbs系统

package com.ibm.control;

import java.io.IOException;
import java.sql.Connection;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.ibm.dao.BoardDAO;
import com.ibm.dao.TopicDAO;
import com.ibm.dto.*;
import com.ibm.vo.*;
import com.ibm.service.*;
import com.ibm.common.DBConnection;

public class InsertTopicServlet extends HttpServlet {

	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		int boardid=Integer.parseInt(request.getParameter("boardid"));  //这个boardid是通过隐藏域获得的
		String title=request.getParameter("title");      //在表单中获得的数据：title
		String content=request.getParameter("content");  //在表单中获得的数据：content
		
		//获取session的值，其封装的是UsersVO对象
		HttpSession session = request.getSession(true);
		UsersVO usersvo=(UsersVO)session.getAttribute("uvo");
		int uid=usersvo.getUid();
		
		//获得发表时间
		Date date = new Date();//获得系统时间.
        String nowTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);//将时间格式转换成符合Timestamp要求的格式.
        Timestamp topicTime = Timestamp.valueOf(nowTime);//把时间转换
        Timestamp modifytime=topicTime;
        Timestamp publishtime=topicTime;
        
        //把数据封装到UsersDTO中
        TopicDTO topicdto=new TopicDTO();
//        TopicDTO topicdto=TopicDTO.getInstance();
        topicdto.setTitle(title);
        topicdto.setContent(content);
        topicdto.setModifytime(modifytime);
        topicdto.setPublishtime(publishtime);
        topicdto.setBoardid(boardid);
        topicdto.setUid(uid);
        
        Connection con=DBConnection.getInstance().getConnection();
        TopicDAO topicdao=new TopicDAO();
        boolean falg=topicdao.insertTopic(con, topicdto);
        
        if(falg == true)
        {
        	
        	response.sendRedirect("index.jsp");
        	System.out.println("插入成功");
        }else
        {
        	response.sendRedirect("index.jsp");
        	System.out.println("插入失败");
        }
		
	}

	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		this.doGet(request, response);
	}

}