insertservlet.java

我自己写的javabean+jsp+servlet

package com.gke;

import java.io.IOException;
import java.sql.*;

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

public class InsertServlet extends HttpServlet{
	public void doPost(HttpServletRequest request,HttpServletResponse response){
		String sql = "Insert into userinfo value(?,?)";
		Connection conn = null;
		PreparedStatement stmt = null;
		HttpSession session = request.getSession();
		String obj = request.getParameter("validate");
		String obj1= (String)session.getAttribute("myrand");
		
		if(obj1.equals(obj)){
		
			try {
				conn = DBUtil.getConnection();
				stmt = conn.prepareStatement(sql);
			
				stmt.setString(1,request.getParameter("rgUsername"));
				stmt.setString(2, request.getParameter("rgPassword"));
			
				stmt.execute();
			
					response.sendRedirect("regist_success.jsp");
				} catch (ClassNotFoundException e) {
					e.printStackTrace();
				} catch (SQLException e) {
					e.printStackTrace();
				} catch (IOException e) {
					e.printStackTrace();
				}
			
			if(conn!=null){
				try {
					DBUtil.closeConnection(conn);
				} catch (SQLException e) {
					e.printStackTrace();
				}
				}
			if(stmt!=null){
				try {
					DBUtil.closeStatement(stmt);
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}else{
			try {
				response.sendRedirect("regist_failure.jsp");
			} catch (IOException e) {
				e.printStackTrace();
			}
			
		}
		
	}
	public void doGet(HttpServletRequest request,HttpServletResponse response){
		doPost(request,response);
	}
}