loginmanager.java

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

package com.logistic.business;

import com.logistic.dao.ILoginDAO;
import com.logistic.model.LoginInfo;
import java.util.Vector;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;

public class LoginManager  implements ILoginDAO{

	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
    public int AddLogin(String loginid,String loginname,String loginpassword,String loginpower,String employeeid){
	
    	int flag=-10;
    	try{
    		String id=loginid;
    		String name=loginname;
    		String password=loginpassword;
    		String power=loginpower;
    		String eid=employeeid;
    		System.out.println(eid);
    		String strsql="insert into logintable(LoginId,LoginName,LoginPassword,LoginPower,EmployeeId)values('"+id+"','"+name+"','"+password+"','"+power+"','"+eid+"')";
    		flag=dc.updata(strsql);
    		if(flag>0){
    			System.out.println("登陆信息插入成功!");
    		}else{
    			System.out.println("登陆信息插入失败!");
    		}
    		
    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
    return flag;
    }
	
	public Vector LoginSearch(String strsql,int page){
		
		Vector items=new Vector();
		try{
			
			stat=dc.getStmtread();
			rs=stat.executeQuery(strsql);
			PageAble pgb=new PageAble(rs);
			pgb.setPagesize(5);
			pgb.setCurrentpage(1);
			pgb.gotoPage(page);
			
			rs.absolute(pgb.getRowscount());
			int i=0;
			do{
				items.add(new LoginInfo(rs.getString("LoginId"),rs.getString("LoginName"),rs.getString("LoginPassword"),rs.getString("LoginPower"),rs.getString("EmployeeId")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}			
	return items;		
	}
	
	public int DelLogin(String loginid){
		
		String strsql="delete from logintable where LoginId="+loginid;
		
		int flag=0;
		
		try{
			flag=dc.updata(strsql);
			if(flag>0){
				System.out.println("编号="+loginid+"的登陆信息删除成功!");
			   }else{
				System.out.println("编号="+loginid+"的登陆信息删除失败!");
			         }
		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}			
	return flag;
	}
	
	public int ModifyLogin(String loginid,String loginname,String loginpassword,String loginpower,String employeeid){
		 
		  int flag=-10;
		  try{
	    	   String id=loginid;
	    	   String name=loginname;
	    	   String password=loginpassword;
	    	   String power=loginpower;
	    	   String eid=employeeid;
			   
	    	   String strsql="update logintable set LogiId='"+id+"',LoginName='"+name+"',LoginPassword='"+password+"',LoginPower='"+power+"',EmployeeId='"+eid+"' where LoginId="+id;
			  
	          flag=dc.updata(strsql); 
			  if(flag>0){
				  System.out.println("编号="+id+"的登陆信息更新成功!");
			  }else{
				  System.out.println("编号="+id+"的登陆信息更新失败!");
			  }
		  }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}		 
	return flag; 
	}
   
	public LoginInfo LoginSearchById(String loginid){
	
		String strsql="select * from logintable where LoginId="+loginid;
		LoginInfo li=new LoginInfo();
		try{
			stat=dc.getStmtread();
			rs  =stat.executeQuery(strsql);
			while(rs.next()){
				li.setLoginid(rs.getString("LoginId"));
				li.setLoginname(rs.getString("LoginName"));
				li.setLoginpassword(rs.getString("LoginPassword"));
				li.setLoginpower(rs.getString("LoginPower"));
				li.setEmployeeid(rs.getString("EmployeeId"));
			}
			
		}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	return li;
	}
}