addservlet.java

它统一管理各个应用系统用户的身份验证

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;



import bean.DBConnBean;
import bean.StudentBean;

public class AddServlet extends HttpServlet {
	
	 public void doGet(HttpServletRequest request,HttpServletResponse response)
             throws ServletException,IOException
             {
		 request.setCharacterEncoding("GBK");
		 response.setContentType("text/html;charset=GBK");

		 String address = "unknownlist.jsp";
		 try
		 {  
			 String driverName="com.mysql.jdbc.Driver";
			 String userName="root";  			//数据库用户名
			 String userPasswd="123";			//密码	
			 String dbName="student";			//数据库名
			 String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;

			 try  {  
				 Class.forName(driverName);  
			 }  
			 catch(java.lang.ClassNotFoundException   e)   {  
				 System.err.println(e.getMessage()+"112"); 
			 }  
			 Connection conn = DriverManager.getConnection(url);

			 String sql = "insert into studentinfo values(?,?,?,?,?,?,?)";
			 PreparedStatement stmt = conn.prepareStatement(sql);
			 stmt.setString(1,request.getParameter("id"));
			 stmt.setString(2,request.getParameter("name"));
			 stmt.setString(3,request.getParameter("phone"));
			 stmt.setString(4,request.getParameter("mobile"));
			 stmt.setString(5,request.getParameter("address"));
			 stmt.setString(6,request.getParameter("email"));
			 stmt.setString(7,request.getParameter("qq"));			 
			 stmt.executeUpdate();
			 address="addResult.jsp";
			 stmt.close();
			 conn.close();
			 RequestDispatcher dis = request.getRequestDispatcher(address);
			 dis.forward(request,response);
		 }

		 catch(SQLException e)
		 {
			 System.err.println(e);
		 }
}
  
public void doPost(HttpServletRequest request,
     HttpServletResponse response)
     throws ServletException,IOException
     {
	         doGet(request,response);
     }
}