insertservlet.java

用mysql

package com.wenhua.ser.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

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.wenhua.ser.dao.UserDao;

public class insertservlet extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public insertservlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	
	

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

		
		request.setCharacterEncoding("GBK");
		response.setCharacterEncoding("GBK");
		

		//第一步 ，从前台获得参数
		HttpSession session = request.getSession();
		String userName = (String)session.getAttribute("userName");
		String content = request.getParameter("content");
		
		
		Date date = new Date();
		date.getDate();
		
		java.util.Date date3 = new java.util.Date();
		
		
		String time=String.format("%1$tY-%1$tm-%1$te %1$tH:%1$tM:%1$tS", date3);
		
		
		UserDao userDao = new UserDao();
		userDao.insert(userName,content,time);
		
		//查询数据库
		List list = new ArrayList();
		list = userDao.findAll();
		request.setAttribute("result", list);
		
		request.getRequestDispatcher("wsuccess.jsp").forward(request, response);
	
	}

	
	public void init() throws ServletException {
		// Put your code here
	}

}