generatepkiaction.java

是一个用VB编写得银行ATM机交易的程序

package com.myapp.struts.forvenus;

import com.myapp.struts.*;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.Date;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.ArrayList;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForward;

/**
 *
 * @author Administrator
 */
public class GeneratePKIAction extends Action {
     public ArrayList al = new ArrayList();
    /** Creates a new instance of AccountChecked */
    public ActionForward execute(ActionMapping mapping, ActionForm  form,
            HttpServletRequest request, HttpServletResponse response)
            throws Exception {
        try{
            DB db=new DB();

            String sql_1 ="select * from Reginfo where Skey!='' and username in (select ui.UserName from Reginfo ui,cardinfo ci where ui.username=ci.username and ci.cardstate=1) and (PKI is NULL or PKI='')";
            ResultSet rs = db.Select(sql_1);
            while(rs.next()){
                String userName=rs.getString("UserName");
                String skey=rs.getString("Skey");

                String pki =getPKI(skey);
                String sql_2 = "update Reginfo set PKI='"+pki+"' where UserName = '"+userName+"'";
                String sql_3 = "update cardinfo set cardstate=2 where UserName='"+userName+"'";
                db.ExcuteSql(sql_2);
                db.ExcuteSql(sql_3);
            }
        }catch(Exception e){
            
        }
        ArrayList al = getList();
        if(al==null){
            return mapping.findForward("Error");
        }else{
            request.getSession().setAttribute("AccountList",al);
            return mapping.findForward("NoSkeyList");
        }     
        
    }
    
    
    private String getPKI(String skey){
        String pki=new String();
        String pp="";
        int num;
        //私钥生成公钥的逻辑:
       // pki = skey + 1;
        for(int i=0;i<skey.length();i++){
            
            int tt=skey.charAt(i)-48;
            num=ChangeNum(tt);      
            pp=pp+num;
        }
        return pp;
    }
    
    private ArrayList getList(){
        ArrayList al=new ArrayList();
        String sql = "select * from Reginfo where Skey!='' and PKI=''  in (select ui.UserName from Reginfo ui,cardinfo ci where ui.username=ci.username and ci.cardstate=1)";
             
        DB conn=new DB();
        
       
        try{
            ResultSet rs=(ResultSet)conn.Select(sql);            
            while(rs.next()) {
                UserinfoBean ub = new UserinfoBean(
                        rs.getString("UserName"),
                        rs.getString("ULogPass"),
                        rs.getString("UpayPass"),
                        rs.getString("UserGroups"),
                        rs.getString("URealName"),
                        rs.getString("UCardID"),
                        rs.getString("PKI"),
                        rs.getString("SKey"),
                        rs.getString("email"),
                        rs.getString("UPhone"),
                        rs.getDouble("Account"),
                        rs.getString("LetterNum"),
                        rs.getString("LetterKey")
                        );
                al.add(ub);
            }
            return al;
        } catch(Exception e) {
            return null;
        }
    }
    
    private int ChangeNum(int tmp){
       if(tmp==1){
           tmp=6;
       }   
       else if(tmp==2){
           tmp=3;
       }
       else if(tmp==3){
           tmp=9;
       }
       else if(tmp==4){
           tmp=1;
       }
       else if(tmp==5){
           tmp=8;
       }
       else if(tmp==6){
           tmp=0;
       }
       else if(tmp==7){
           tmp=5;
       }
       else if(tmp==8){
           tmp=2;
       }
       else if(tmp==9){
           tmp=4;
       }
       else if(tmp==0){
           tmp=7;
       }
       return tmp;
    }
    
}