checklogin.java

还是那个超市系统都是组员的成品

package superMarket;

import javabean.OracleBean;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

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

        String a = request.getParameter("select");
        System.out.println("111111111111111111111111111111111111111");
	//

        if(a.equals("管理")){
	         System.out.println("22222322222222222222222222222222222");
	         String sql = "SELECT username,password FROM login WHERE username='"+request.getParameter("username")+"' AND password = '"+request.getParameter("password")+"'"; 
 	         System.out.println(sql);
	//String sql1 = sql+"where job = 'renshi'";
	//System.out.println(sql1);
	ResultSet rs = conn.query(sql);
	HttpSession session =request.getSession();
try{
	
	if(rs.next()){
		session.setAttribute("name","ok");
		//getServletConfig().getServletContext().getRequestDispatcher("/guanli.jsp").forward(request,response);
	//	response.sendRedirect("guanli.jsp");
	}else{
	//	getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
		//response.sendRedirect("login.html");
	}
	}catch(Exception e){
	}	
}





System.out.println("3333333333333333333333333333333333333333");
//
if(a.equals("采购")){
	System.out.println("44444444444444444444444444444444444444444");
	String sql = "SELECT ename,password FROM emptable WHERE ename='"+request.getParameter("username")+"' AND password = '"+request.getParameter("password")+"'AND job='caigou'"; 
	System.out.println(sql);
	ResultSet rs = conn.query(sql);

HttpSession session =request.getSession();

try{
	if(rs.next()){
		session.setAttribute("name","ok");
		String sql1 ="SELECT emp_id AS dempid FROM emptable WHERE ename = '"+request.getParameter("username")+"'";
		int emp_id = rs.getInt("dempid");
		//getServletConfig().getServletContext().getRequestDispatcher("/caigou.jsp?bdate=new java.util.Date()&emp_id=emp_id&ename=username").forward(request,response);
		//response.sendRedirect("caigou.jsp");
	}else{
		//getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
		//response.sendRedirect("login.html");
	}
	}catch(Exception e){
		
	}
}	


            
              System.out.println(a);
	
             if(a.equals("销售")){
	                //session.setAttribute("name","ok");
	                String sql = "SELECT ename,password,emp_id FROM emptable WHERE ename='"+request.getParameter("username")+"' AND password = '"+request.getParameter("password")+"'"; 
	                System.out.println(sql);
	                ResultSet rs = conn.query(sql);
	                HttpSession session =request.getSession();
                    
	            try{
	            		
					if(rs.next()){
					session.setAttribute("id",rs);
		            System.out.println("$$$$$$$$$$$$$4444");
					getServletConfig().getServletContext().getRequestDispatcher("/tianjia1.jsp").forward(request,response);
					   System.out.println("$$$$$$$$$$$$$4444");
					//response.sendRedirect("xiaoshou.jsp");
					}else{
		
					getServletConfig().getServletContext().getRequestDispatcher("/checklogin.html").forward(request,response);
					//response.sendRedirect("login.html");
		 			System.out.println("%%%%%%%%%%%");
					}
				}catch(Exception e){
		
			}
		}	


	}
	
	public void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException,IOException{
		doGet(request,response);
	}
}