insertservlet.java~16~

jsp设计的留言板,供大家参考,使用的是文本文件作为数据库

package bookservlets;
import bookutil.DataDo;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.text.SimpleDateFormat;
public class InsertServlet extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=Big5";
  public void init() throws ServletException {
  }
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    if(request.getParameter("Submit")==""||request.getParameter("Submit")==null){
      out.println("<script>windiw.close();</script>");
      return;
    }
    //--------get paraments
    String g_name = request.getParameter("g_name").trim();
    String g_sex = request.getParameter("g_sex");
    String g_qq = request.getParameter("g_qq").trim();
    String g_mail = request.getParameter("g_mail").trim();
    String g_title = request.getParameter("g_title").trim();
    String g_content = request.getParameter("g_content").trim();
    String g_age=request.getParameter("g_age").trim();
    Date temp_time = new Date();
//----------process Chinese
    g_name = new String(g_name.getBytes("ISO8859_1"));
    g_title = new String(g_title.getBytes("ISO8859_1"));
    g_content = new String(g_content.getBytes("ISO8859_1"));
//---------process date format
    SimpleDateFormat df=new SimpleDateFormat("yyyy/MM/dd  hh:mm",Locale.CHINA);
    String g_time=df.format(temp_time);
    g_time=new String(g_time.getBytes("ISO8859_1"));
//--------insert data
    DataDo db=new DataDo();
    String sql="insert into book(g_name,g_qq,g_mail,g_title,g_content,g_sex,g_age,g_time)"+
                    " values('"+g_name+"','"+g_qq+"','"+g_mail+"','"+g_title+"','"+g_content+"','"+g_sex+"','"+g_age+"','"+g_time+"')";
    if(db.dataUpdate(sql)>0){
      out.println("<script>window.alert(\"Victory !\");</script>");
      out.println("<meta http-equiv=refresh content=\"2;url=disp.beyondplus\">");
      db.dataClose();
    }
  }
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doGet(request, response);
  }
  public void destroy() {
  }
}