login.java

还是超市系统

/**@(#)Login.java*/
package test.login;

import java.io.IOException;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**验证系统用户的登陆
 * @version 0.1
 * @author Administrator
 * @date 20060731 pm 16:39
 */
public class Login extends HttpServlet{

	String sql;
	String driver = "oracle.jdbc.driver.OracleDriver";
	String url = "jdbc:oracle:thin:@eda24:1521:SMarket";

	
	ResultSet rs;
	//构造方法，注册数据库的驱动
	public Login(){
		
		try{
			Class.forName(driver);
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		sql = "SELECT operator_id,operator_name,operator_pass FROM table_operator WHERE operator_name=? AND operator_pass=?";
		
		try{
		    Connection conn = DriverManager.getConnection(url,"scott","tiger");
		    PreparedStatement pstmt = conn.prepareStatement(sql);
		    pstmt.setString(1,req.getParameter("name"));
		    pstmt.setString(2,req.getParameter("pass"));
		    rs = pstmt.executeQuery();

		    if(rs.next()){
		    	//System.out.println("111111111111111");
		    	//如果是超级用户，就直接登陆
		    	if(rs.getString("operator_name").equals("root") && rs.getString("operator_pass").equals("root")){
		    		System.out.println("111111111111111");
		    	   getServletConfig().getServletContext().getRequestDispatcher("/pages/root.jsp").forward(req,res);
		    	}else 
		    	//如果是一般的用户就登陆一般用户页面
		    	if(rs.getString("operator_name").equals("user") && rs.getString("operator_pass").equals("user")){
		    		System.out.println("222222222222222222");
		    	   getServletConfig().getServletContext().getRequestDispatcher("/pages/user.jsp").forward(req,res);
		    	}
		    	else{
		    		System.out.println("33333333333333333333");
		    		//获取该用户id以传递到下一个Servlet中，获得部门id
		    		Integer i = new Integer(rs.getInt("operator_id"));
		    		req.setAttribute("operatorId",i);
		    		getServletConfig().getServletContext().getRequestDispatcher("/selectdept").forward(req,res);
		    	  }
		    	   
		    }else{
		      //登陆失败
		      System.out.println("44444444444444444444");
		      getServletConfig().getServletContext().getRequestDispatcher("/pages/fail.html").forward(req,res);
		    
		    }  //
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
}