insertmemo.java

来自「我自己写的javabean+jsp+servlet」· Java 代码 · 共 61 行

package com.gke;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

public class InsertMemo extends HttpServlet{
	public void doPost(HttpServletRequest request,HttpServletResponse response){
		
		String sql = "insert into memo values(?,?)";
		Connection conn = null;
		PreparedStatement stmt = null;
		HttpSession session = request.getSession();
		String obj = request.getParameter("validate");
		String obj1= (String)session.getAttribute("myrand");
		try {
			request.setCharacterEncoding("gb2312");
		} catch (UnsupportedEncodingException e1) {
			e1.printStackTrace();
		} 

		
		if(obj1.equals(obj)){
			try {
				conn = DBUtil.getConnection();
				stmt = conn.prepareStatement(sql);
				
				stmt.setString(1, (String)session.getAttribute ( "UserName" ));
				stmt.setString(2, request.getParameter("content"));
				
				
				stmt.execute();
				
				try {
					response.sendRedirect("memodisplay.jsp");
				} catch (IOException e) {
					e.printStackTrace();
				}
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
			
		}
	}
	public void doGet(HttpServletRequest request,HttpServletResponse response){
		doPost(request,response);
	}
	
	
}