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);
	}	
}