userregisterservlet.java

《j2ee应用开发祥解》一书的源代码

package com.j2ee14.ch8;

import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
import java.sql.*;

/**
 *演示在Servlet中更新数据库
 */
public class UserRegisterServlet extends com.j2ee14.ch8.DatabaseServletBase
{	
	
	/**
	 *处理Get请求
	 *获得初始参数-->把数据保存到数据库-->显示保存成功的信息
	 */
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
	    response.setContentType("text/html;charset=gb2312");
	    PrintWriter out = response.getWriter();
	    //获得初始参数
        String userName=request.getParameter("userName");
        String language=request.getParameter("language");
        int age=Integer.parseInt((String)request.getParameter("age"));
        //技巧：要获得一组参数，通过request.getParameterValues方法。
        String[] fav=request.getParameterValues("fav"); 
        String favstring="";
        for(int i=0;i<fav.length;i++)
        favstring+=","+fav[i];       

        try
        {        	
         	//创建执行语句，执行数据库操作
         	Statement stmt=con.createStatement();
			stmt.execute("insert into userregist values('"+userName+"','"+language+"',"+age+",'"+favstring+"')");			
        	stmt.close();
        	out.println("用户信息已经成功注册");
        	
        }
        catch(Exception e)
        {
        	out.println("注册失败，请重新注册");
        	out.println("发生了以下的异常<hr>");
        	out.println(e.getMessage());
        	e.printStackTrace();
        }
        
    }
    
    /**
     *处理post请求
     */
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}	
}