package com.ntsky.note;

/**
 * 添加數據
 */

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

import com.ntsky.note.SQLDBOperator;
import com.ntsky.note.URLServlet;
import com.ntsky.note.CodeFilter;

public class AddInfo extends HttpServlet {
    private static final String CONTENT_TYPE = "text/html; charset=GBK";
    private SQLDBOperator sdbo=null;
    //Initialize global variables
    public void init() throws ServletException {
    }
    //Process the HTTP Post request
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        response.setContentType(CONTENT_TYPE);
        request.setCharacterEncoding("GBK");
        PrintWriter out = response.getWriter();
        //取值
        String userName=CodeFilter.toHtml(request.getParameter("userName"));
        int sex = Integer.parseInt(request.getParameter("sex"));
        String email = CodeFilter.toHtml(request.getParameter("email"));
        String qq = CodeFilter.toHtml(request.getParameter("qq"));
        String url = CodeFilter.toHtml(request.getParameter("url"));
        String headTitle = CodeFilter.toHtml(request.getParameter("headTitle"));
        String content = CodeFilter.toHtml(request.getParameter("content"));
        String image = request.getParameter("image");

        try {
            if (sdbo==null)
                sdbo = SQLDBOperator.getInstance("Connection");
            sdbo.executeUpdate("insert into guest(userName,sex,email,qq,url,headTitle,content,image,noteTime) values('" + userName + "'," + sex + ",'" + email + "','" + qq + "','" + url + "','" + headTitle + "','" + content + "','"+image+"',now());");
            Debug.writeLog("insert into guest(userName,sex,email,qq,url,headTitle,content,image) values('" + userName + "'," + sex + ",'" + email + "','" + qq + "','" + url + "','" + headTitle + "','" + content + "','"+image+"');");
            URLServlet.getUrl(response,"index.jsp");
        }
        catch(Exception e){
            System.out.println("AddInfo has error"+e);
        }
        finally{
            out.close();
        }
    }
    //Clean up resources
    public void destroy() {
    }
}