handleadd.java

纯粹jsp的留言板,使用了mvc

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package messagepad.servlets;
import messagepad.beans.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

/**
 *
 * @author Administrator
 */
public class handleAdd extends HttpServlet{
    public void init(ServletConfig config) throws ServletException{
        super.init(config);
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }
        catch(Exception e){
        }
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response)
            throws ServletException,IOException{
            Connection con;
            Statement sql;
            ResultSet rs;
            try{
                String url="jdbc:mysql://localhost/taotao";
                String user="taotao";
                String password=".nothing";
                con=DriverManager.getConnection(url,user,password);
                String strId=request.getParameter("id");
                //byte b[]=str.getBytes("UTF-8");
                //str=new String(b);
                String strContent=request.getParameter("content");
                strContent=strContent.replaceAll("<", "&lt;");
                //byte b[]=strContent.getBytes("UTF-8");
                //strContent=new String(b);
                String insertCondition="insert into messages values(null,"+"'"+strId+"'"+","+"'"+strContent+"'"+","+"null)";
                sql=con.createStatement();
                if(strId.length()>0||strContent.length()>0){
                    sql.executeUpdate(insertCondition);
                }
            }
            catch(SQLException e){
            }
            //response.encodeRedirectURL("index.jsp");
            RequestDispatcher dispatcher=request.getRequestDispatcher("helpReadRecord");
            dispatcher.forward(request, response);
    }
    public void doGet(HttpServletRequest request,HttpServletResponse response)
            throws ServletException,IOException{
            doPost(request,response);
    }
}