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");	
		String url = "jdbc:oracle:thin:@eda21:1521:Evilsun";
		
		HttpSession session =request.getSession();
		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")+"'"; 
			String sql = "SELECT username,password FROM login WHERE username=? AND password =?"; 
			System.out.println(sql);
		try{
			Connection conn1 = DriverManager.getConnection(url,"scott","tiger");
			PreparedStatement pstmt = conn1.prepareStatement(sql);
			pstmt.setString(1,request.getParameter("username"));
			pstmt.setString(2,request.getParameter("password"));
			ResultSet rs = pstmt.executeQuery();
			//String sql1 = sql+"where job = 'renshi'";
			//System.out.println(sql1);
			
			//HttpSession session =request.getSession();
		
				if(rs.next()){
					session.setAttribute("name","ok");
					getServletConfig().getServletContext().getRequestDispatcher("/admin.html").forward(request,response);
					//	response.sendRedirect("guanli.jsp");
				}else{
					getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
					//response.sendRedirect("login.html");
				}
			}catch(Exception e){
				e.printStackTrace();
			}	
		}




		String b = request.getParameter("select");
		System.out.println("3333333333333333333333333333333333333333");

		if(b.equals("采购")){
			System.out.println("44444444444444444444444444444444444444444");
			String sql = "SELECT ename,password FROM emptable WHERE ename=? AND password =? AND job='采购'"; 
			System.out.println(sql);
			try{
			Connection conn2 = DriverManager.getConnection(url,"scott","tiger");
			PreparedStatement pstmt = conn2.prepareStatement(sql);
			pstmt.setString(1,request.getParameter("username"));
			pstmt.setString(2,request.getParameter("password"));
			ResultSet rs = pstmt.executeQuery();
			//ResultSet rs = conn.query(sql);

			//HttpSession session =request.getSession();

			
				if(rs.next()){
					session.setAttribute("name","ok");
					String sql1 ="SELECT emp_id AS dempid FROM emptable WHERE ename = '"+request.getParameter("username")+"'";
					//javabean.OracleBean conn = new javabean.OracleBean();
					Statement stmt = conn2.createStatement();
					ResultSet rs1 = stmt.executeQuery(sql1);
					String emp_id = ""+rs1.getInt("dempid");
					session.setAttribute("emp_id", emp_id);
					session.setAttribute("ename", request.getParameter("username"));
					getServletConfig().getServletContext().getRequestDispatcher("/buy.jsp").forward(request,response);
					//response.sendRedirect("caigou.jsp");
					//?bdate=new java.util.Date()&emp_id=emp_id&ename=username
				}else{
					getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
					//response.sendRedirect("login.html");
				}
			}catch(Exception e){
				e.printStackTrace();
		
			}
		}	


		String c = request.getParameter("select");
		System.out.println("5555555555555555555555555555555555555555555");
		
		if(c.equals("销售")){
			System.out.println("6666666666666666666666666666666666666666666666");
			String sql = "SELECT ename,password FROM emptable WHERE ename=? AND password = ?AND job='销售'";
			System.out.println(sql);
			try{
					Connection conn3 = DriverManager.getConnection(url,"scott","tiger");
			PreparedStatement pstmt = conn3.prepareStatement(sql);
			pstmt.setString(1,request.getParameter("username"));
			pstmt.setString(2,request.getParameter("password"));
			ResultSet rs = pstmt.executeQuery();
			
			//ResultSet rs = conn.query(sql);
			//HttpSession session =request.getSession();
			System.out.print("xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx");
		
				if(rs.next()){
		
					session.setAttribute("name","ok");
					getServletConfig().getServletContext().getRequestDispatcher("/xiaoshou.jsp").forward(request,response);
					//response.sendRedirect("xiaoshou.jsp");
				}else{
		
					getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
					//response.sendRedirect("login.html");
				}
			}catch(Exception e){
				e.printStackTrace();
			}
		}	


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