logincheck.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

package com.logistic.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;


public class LoginCheck extends HttpServlet {
	
	
	private static final long serialVersionUID = -2305260907601477327L;
	String username=null;
	String password=null;
	HttpSession session;
	Statement stat=null;
	ResultSet rs=null;
	DataConnect dc=new DataConnect();
	RequestDispatcher requestdispatcher=null;
	int temp;
	PrintWriter out;
	
	String loginname;
	String employeeid;
	String power;


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


	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
/*
 * 在doPost方法中，获取login.jsp页面提交的用户名和密码的参数
 * 从logintable表检索登陆的用户是否合法
 * 
 * 把用户名和用户ID保存到Session中，登陆成功跳转到mainframe.jsp页面
 * 否则返回登陆页面；
 * 
 * */
		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html; charset=gb2312");
		session=request.getSession();
		username=(String)request.getParameter("loginname").trim();
		password=(String)request.getParameter("loginpassword").trim();
		
		String sqls="select * from logintable where LoginName='"+username+"'and LoginPassword='"+password+"'";
		
		temp=-10;
		try{
			temp=dc.selectdata(sqls);
			//System.out.print(temp);
			if(temp>0){
				stat=dc.getStmtread();
				rs=stat.executeQuery(sqls);
				//rs.previous();
				while(rs.next()){
					employeeid=rs.getString("EmployeeId");
					loginname=rs.getString("LoginName");
					power=rs.getString("LoginPower");
					
					    }
				     if(loginname!=null){
				    	 session.setAttribute("loginname",(String)loginname);
				    	 System.out.print(loginname);
				    	 session.setAttribute("employeeid",(String)employeeid);
				    	 session.setAttribute("loginpower",(String)power);
				    	 session.setAttribute("ok","ok");
				    	 requestdispatcher=request.getRequestDispatcher("/viewpage/mainframe.jsp");
				    	 requestdispatcher.forward(request, response);}
				
				    }else{
				    	 //session.setAttribute("errors", "用户名或密码错误");
				    	 requestdispatcher=request.getRequestDispatcher("index.jsp");
				    	 requestdispatcher.forward(request, response);
				     		}
			
		}catch(Exception ex){
			ex.printStackTrace(); 
		   }finally{dc.close();}	   
	
	}

}