selectdept.java

还是超市系统

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

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

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

/**
 * @version 0.1
 * @author kyle
 * @date 20060801 am 9:30
 */
public class SelectDept extends HttpServlet{

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

	
	ResultSet rs;
	//构造方法，注册数据库的驱动
	public SelectDept(){
		
		try{
			Class.forName(driver);
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		sql = "SELECT dept_id FROM table_dept WHERE operator_id="+(Integer)req.getAttribute("operatorId");
		
		try{
		    Connection conn = DriverManager.getConnection(url,"scott","tiger");
		    Statement stmt = conn.createStatement();
		    rs = stmt.executeQuery(sql);

		    if(rs.next()){
				HttpSession session = req.getSession();
				System.out.println(rs.getInt("dept_id"));
		    	session.setAttribute("deptId",new Integer(rs.getInt("dept_id")));
		    	System.out.println("5555555555555555555555555");
		    	getServletConfig().getServletContext().getRequestDispatcher("/hh").forward(req,res);
		   		System.out.println("=================================");
		    }else{
		    //登陆失败
		    System.out.println("6666666666666666666666");
		    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);
	}
}