jsp+javabean+servlet简单的BBS

package com.bbs.servlet; import javax.servlet.*; import javax.servlet.http.*; import java.sql.*; import java.io.*; import java.text.*; import java.util.*; import com.bbs.bean.JavaBean; import com.bbs.db.DataBase; public class Register extends HttpServlet { private static final String CONTENT_TYPE = "text/html; charset=gb2312"; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType(CONTENT_TYPE); HttpSession session=request.getSession(); PrintWriter out = response.getWriter(); try { DataBase con=new DataBase(); String userid=request.getParameter("userid"); String sql="select * from forumUser where userid=\'"+userid+"\'"; ResultSet rs=con.find(sql); System.out.println(sql); if(rs.next()) { out.println("<p>对不起!您选择的用户ID已经有人使用,请<a href=\"register.jsp\">重新填写</a>!</p>"); } else { JavaBean ub=new JavaBean(); ub.setUesrid(request.getParameter("userid")); ub.setPwd(request.getParameter("pwd")); ub.setNickname(request.getParameter("nickname")); ub.setGender(request.getParameter("gender")); ub.setRealname(request.getParameter("realname")); ub.setAddress(request.getParameter("address")); ub.setEmail(request.getParameter("email")); ub.setTel(request.getParameter("tel")); SimpleDateFormat f= new SimpleDateFormat("yyyy-MM-dd HH:mm:ss",Locale.getDefault()); ub.setBirth(new java.util.GregorianCalendar(Integer.parseInt(request.getParameter("year")), Integer.parseInt(request.getParameter("month"))-1, Integer.parseInt(request.getParameter("day"))).getTime()); ub.setSigh(request.getParameter("sigh")); java.util.Date m_date=new java.util.Date(); String today=f.format(m_date); //将用户注册信息加入数据库中 String sqlu="insert into forumUser(userid,pwd,nickname,gender,realname,address,email,tel,birth,sigh,logoncounts,publichcounts,lastAccessTime)values(\'" +ub.getUesrid()+"\',\'"+ub.getPwd()+"\',\'"+ub.getNickname()+"\',\'"+ub.getGender()+"\',\'"+ub.getRealname()+"\',\'" +ub.getAddress()+"\',\'"+ub.getEmail()+"\',\'"+ub.getTel()+"\',\'"+f.format(ub.getBirth())+"\',\'"+ub.getSigh()+"\','1','0','"+today+"')"; System.out.println(sqlu); con.add(sqlu); session.setAttribute("userid",ub.getUesrid()); //response.sendRedirect("registerok.jsp"); request.getRequestDispatcher("logon.jsp").forward(request,response); out.println("恭喜您注册成功请登陆"); } } catch(Exception e){System.out.println(e);} } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,java.io.IOException { doGet(request,response); } }