vipss.java

来自「spring+struts+hibernate做的银行系统」· Java 代码 · 共 233 行

/*
 * Created on 2006-4-12
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package cn.com.tym.admin;

import cn.com.tym.table.bean.RegisterBean;
import cn.com.tym.util.tablebean.UtilMyphotos;
import cn.com.tym.util.text.*;

import java.sql.ResultSet;
import java.sql.SQLException;

import java.util.ArrayList;
import java.util.Date;

import cn.com.tym.vip.*;

import javax.servlet.http.HttpServletRequest;

import cn.com.tym.pub.DB;
import cn.com.tym.pub.PageBean;

import java.text.*;


/**
 * @author jack_booth
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class VipSS {
	
 
	//�����Ա�� �б�
	public ArrayList  getViplist(HttpServletRequest request,DB db)throws SQLException{
		
	 
	 String strSql= "select register_id, rbusiness, rname,rsex,rcity,years,remail,rclient,marrage from mdh_register order by register_id desc"; 
		
	 ArrayList  list=new ArrayList();
	 	ResultSet rs = null;
PageBean pageBean=new PageBean(request);
pageBean.setPageSize(8);
pageBean.count();
int currRow=pageBean.getCurrentRow();
int lastRow=pageBean.getLastRow();

String csql="select count(*) from mdh_register   ";
String urlStr="MangerVipAction.do?method=lookVip";
try{ 
pageBean.count(db,rs,csql,urlStr);
}
catch(Exception e){}
strSql=" select  top "+lastRow+" *  from mdh_register order by register_id desc ";
try{
rs=db.OpenSql(strSql);
if(currRow>0)
	rs.absolute(currRow);
   while(rs.next())
    {	 
    	VipBean bean=new VipBean();
    		
    	bean.setRid(rs.getString("register_id")); //ֱ����rs.getString��ת���ַ�;
    	bean.setRname(rs.getString("rname"));
    	bean.setRsex(rs.getString("rsex"));
    	bean.setYear(setBirthday(rs.getString("years")));
    	bean.setBusiness(rs.getString("rbusiness"));
    	bean.setCity(rs.getString("rcity"));
    	bean.setRclient(this.lookViP(bean.getRid(),db));
    	bean.setRemail(rs.getString("remail"));
          list.add(bean);
          bean=null;
    }}
     	catch(SQLException e){
     
       	e.printStackTrace();
     	}
      finally{
      	db.close();
      }
		return   list;
}
	
//��ҳ�鿴��Ա����
	
	public ArrayList  getVipOP(HttpServletRequest request,String name,DB db)throws SQLException{
		
	 String rname=ExchangeInput.StringToString(name);
	 String strSql= "select register_id,  rname,rsex,rcity,years,remail,rclient,marrage from mdh_register where rname like '%"+rname+"%' order by register_id desc"; 
		
	 ArrayList  list=new ArrayList();
	 	ResultSet rs = null;
PageBean pageBean=new PageBean(request);
pageBean.setPageSize(8);
pageBean.count();
int currRow=pageBean.getCurrentRow();
int lastRow=pageBean.getLastRow();

String csql="select count(*) from mdh_register   ";
String urlStr="FindAction.do?method=findAct";
try{
pageBean.count(db,rs,csql,urlStr);
}
catch(Exception e){}
strSql=" select  top "+lastRow+" * from mdh_register where rname like '%"+rname+"%' order by register_id desc ";
try{
rs=db.OpenSql(strSql);
if(currRow>0)
	rs.absolute(currRow);
while(rs.next())
 {	 
 	RegisterBean bean=new RegisterBean();
 	bean.setRname(rs.getString("rname"));
 	bean.setRid(rs.getString("register_id"));
 	bean.setCity(rs.getString("rcity"));
 	bean.setYear(rs.getString("years"));
 	bean.setWork(UtilMyphotos.lookPhotoVisualize(bean.getRid(),db));

       list.add(bean);
       	bean=null;
 }
}
  	catch(SQLException e){
    	e.printStackTrace();
    	throw e;
  	}

		return   list;
}
 
	
	////////������Ϣҳ�� ɾ��
//	///////////////������Ϣ��ȫɾ, ת��һ����ձ��keyID
  public void deleteBKeyIDs(String[] keyIDs,DB db) throws SQLException {
 
 
	  String sqlStr="";
	 	ResultSet rs = null;
	  for (int i = 0; i < keyIDs.length; i++) {//{
		 sqlStr="delete  from mdh_register   where register_id='"+ExchangeInput.StringToInt(keyIDs[i])+"'";
	  try {
		  db.ExecSql(sqlStr);
	  } catch (SQLException e) {
		  db.close();
		 e.printStackTrace();
	  }   
  }
  }
	///�ܵ�����
  
  public String countALL(DB db)throws SQLException{
  	String sqlStr="select count(*) from mdh_register ";
  	String count="";
  	ResultSet rs=null;
  	try{
  		rs=db.OpenSql(sqlStr);
  		count=rs.getString(1);
  	}catch(SQLException e){
 
  		e.printStackTrace();
  	}
  	return count;
  }
	
	// 1,Ϊ��Աע��ʱ,���õ�, 2,Ϊ��̨���õ�

	 public String lookViP(String id,DB db)throws SQLException{

	 	String img="不是本行客户!";
	 	int ii=0;
	    String strSql =" select rclient from mdh_register  where register_id='"+id+"'";
	      try{
	      	ResultSet rs=db.OpenSql(strSql);
	        if(rs.next()){
	            ii=rs.getInt("rclient");
	            if(ii==1){
	            	img="审核中...";
	            }
	            if(ii==2){
	            	img="VIP会员";
	            }
	        }
	      }catch(SQLException e){
	      	  db.close();
	      	  throw e;
	      }
	   	return img;
	   }
	 
		//���óɻ�Ա
		
		public boolean inserVip(String id,DB db)throws SQLException{
			
			boolean checked=false;
			String strSql="update  mdh_register set rclient=2  where register_id='"+id+"'";
			
			if(db.ExecSql(strSql)!=0)
			{
				checked=true;
				
			}
				return checked;
		}
  
	//��ǰʱ��
	  public static String getNewTime()
	  {
		 SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
		Date date=new Date();
 			String strDate = sf.format(date);
	  	return strDate;
	  }
	//��������
	public String setBirthday(String years){
		
		String old=years.substring(0,4);
		String last=getNewTime().substring(0,4);

		int birthday=Integer.parseInt(last)-Integer.parseInt(old);

		String bith=new Integer(birthday).toString();

		return  bith;
	}
	
	

}