addmessageservlet.java

来自「Internet 开发技术分章节代码和自己完成的课程设计全代码（在zuoye文件」· Java 代码 · 共 58 行

package message;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.io.*;
 public class AddMessageServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
 {
  //建立数据库的连接 
	 public AddMessageServlet() {
    	 String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //声JDBC驱动程序对象
		   String conURL="jdbc:odbc:message"; //定义JDBC的URL对象
		   try {
		     Class.forName(JDriver); //加载JDBC-ODBC桥驱动程序
		     con=DriverManager.getConnection(conURL); //连接数据库URL
		     }
		   catch(Exception e)
		     {  System.err.println(e.getMessage()); }
	}   	
    private Connection con;
    /* 接收GET请求 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response)
	     throws ServletException, IOException
	{
		byte b1[]=request.getParameter("name").getBytes("ISO-8859-1");
		String na=new String(b1);
		byte b2[]=request.getParameter("email").getBytes("ISO-8859-1");
		String em=new String(b2);
		byte b3[]=request.getParameter("title").getBytes("ISO-8859-1");
		String ti=new String(b3);
		byte b4[]=request.getParameter("content").getBytes("ISO-8859-1");
		String co=new String(b4);
		if(na==null)na="";
		if(ti==null)ti="";
		if(co==null)co="";
		if(em==null)em="";
		try
		 {
       //将获得的信息装入数据库
			PreparedStatement stm=con.prepareStatement("insert into MessageTable values(?,?,?,?)");
			stm.setString(1,ti);
			stm.setString(2,na);
			if(em.length()==0)stm.setString(3,null);
			else stm.setString(3,em);	
			stm.setString(4,co); 					
			try 
			  {	stm.executeQuery();	} 
			catch(Exception e){ 	}			
			//对于留言板中“查看留言”请求,访问另一个Servlet来实现
	    	RequestDispatcher requestDispatcher=request.getRequestDispatcher("ViewMessages_servlet");
		    requestDispatcher.forward(request,response);
    	}
	   catch(Exception e){e.printStackTrace();}
    }  	
	/* 接收POST请求 */
	   protected void doPost(HttpServletRequest request, HttpServletResponse response)
	       throws ServletException, IOException
	       {  doGet(request,response); }   	  	    
}