administratorloginaction.java

电子商务网站使用MVC模式B/S结构功能不是很全适合初学者看

package Administrator;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import Common.DBConnectBean;
public class administratorLoginAction extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
		ServletContext application=getServletConfig().getServletContext(); 
		request.setCharacterEncoding("gb2312");
  		String username=request.getParameter("username");
		String password=request.getParameter("password");
		HttpSession session=request.getSession();
		session.removeAttribute("identify".toUpperCase());
		session.removeAttribute("username".toUpperCase());
		Hashtable table=null;
		boolean flag=false;
		DBConnectBean dbConnectBean=new DBConnectBean("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:shopping","","");
		String sql="select * from administrator where username=\'"+username+"\' and password=\'"+password+"\'";
		table=dbConnectBean.getOneRecord(sql);
		//System.out.println(sql);
		
		if( table.get("password".toUpperCase())!=null){
			if(table.get("password".toUpperCase()).toString().equals(password)){
				session=request.getSession();
				session.setAttribute("identify".toUpperCase(),"administrator");
				session.setAttribute("username".toUpperCase(),username);
				application.getRequestDispatcher("/index.jsp").forward(request,response);
			}	
		}
		else {
			application.getRequestDispatcher("/common/login_error.jsp").forward(request,response);
		}	
		
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)throws IOException,ServletException{
	   	doGet(request,response);
	}
}