loginmanager.java

来自「有完整的毕业设计所需的文件和代码 没什么说的了」· Java 代码 · 共 79 行

import java.sql.ResultSet;

public class LoginManager {
	public boolean testUser(String username,String password,String type){
		boolean result=false;
		String sql="";
		testdata db=new testdata();
		if("1".equals(type)){
			sql="select count(*) from guanli where  username='"+username+"' and password='"+password+"'";
		}else if("2".equals(type)){
			sql="select count(*) from users where   userid='"+username+"' and pass='"+password+"'";
		}else{
			result=false;
		}
		try{
			ResultSet rs=db.exeQuery(sql);
			if(rs.next()){
				if(rs.getInt(1)>0){
					result=true;
				}else{
				    result=false;
				}
			}else{
				result=false;
			}
		}catch(Exception e){			
		}
		return result;
	}

	public String getImageurl(String code){
		String  result="";
		String sql="select myimageurl from product where  code='"+ code+"' ";
		testdata db=new testdata();
		try{
		ResultSet rs=db.exeQuery(sql);
		result = rs.getString("myimageurl");		
		}catch(Exception e){
		}
		return result;
	}
	public String getDescription(String code){
		String  result="";
		String sql="select description from product where  code='"+ code+"' ";
		testdata db=new testdata();
		try{
		ResultSet rs=db.exeQuery(sql);
		result = rs.getString("description");	
		}catch(Exception e){
		}
		return result;
	}
	public String getMarketprice(String code){
		String  result="";
		String sql="select marketprice from product where  code='"+ code+"' ";
		testdata db=new testdata();
		try{
		ResultSet rs=db.exeQuery(sql);
		result = rs.getString("marketprice");	
		}catch(Exception e){
		}
		return result;
	}
	public String getSaleprice(String code){
		String  result="";
		String sql="select saleprice from product where  code='"+ code+"' ";
		testdata db=new testdata();
		try{
		ResultSet rs=db.exeQuery(sql);
		result = rs.getString("saleprice");	
		}catch(Exception e){
		}
		return result;
	}

}