loginaction.java

购物系统登陆界面的java文件。一套的。登陆界面其实都通用的

package shopping;
import shopping.connectionDB;
import java.sql.*;

public class LoginAction  {
	 private String username;
	 private String password;
	 private String nextjsp;
	 private String sql;
	 private Statement statement;
	 private ResultSet results;
	 private connectionDB connectiondb=new connectionDB();

    /**
     * 页面转向
     * @param mapping
     * @param theForm
     * @return 将要转向的页面
     */
    //从login.jsp界面获得登录用户名和密码
    public void setUsenameAndPassword(String jsp_username,
    		                           String jsp_password)
    {
    	username=jsp_username;
    	password=jsp_password;
    	System.out.println(username+"***"+password);
    }
    public String getNextJsp()
    {
    	return nextjsp;
    }
    public boolean checkUser()
    {
    	sql="select duty from users where name='"+username+
    	                             "' and password='"+password+"'";

    	System.out.println(sql);
    	try{
    		statement=connectiondb.setDBConnection();
    		results=statement.executeQuery(sql);
    		if(results.next())
    		{
    			String duty=results.getString(1);
    			duty=(duty==null)? "":duty.trim();
    			System.out.println("duty is "+duty);

    			nextjsp=duty;
    			return true;
    		}
            //登陆失败，回到登陆页面
        	else
        	{
        		return false;
        	}
    	}catch(Exception e)
    	{
    	  System.out.println("connect database is error");
    	  return false;
    	}
    }
}