useraction.java

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

/*
 * UserAction.java
 *
 * Created on 2008年2月22日, 上午12:01
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package BankCheck.bean;
import com.myapp.struts.DataStore;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.lang.String;
/**
 *
 * @author Administrator
 */
public class UserAction {
    String UserName,URealName,email,UPhone,UPass,UCardID;

    /** Creates a new instance of UserAction */
    public UserAction() {
    }
    public void regesiter(UserBean userbean)
    {    
    String sql1="insert into Reginfo(UserName,ULogPass,URealName,UCardID,email,UPhone,UserGroups,Account) values('"+userbean.getUserName()+"','"+userbean.getUPass()+"','"+userbean.getURealName()+"','"+userbean.getUCardID()+"','"+userbean.getemail()+"','"+userbean.getUPhone()+"',0,0)";
    String sql2="insert into Cardinfo(UserName,CardState) values('"+userbean.getUserName()+"',0)";
    try {
           DataStore db=DataStore.getInstance();
            db.execute(sql1);
            db.execute(sql2);            
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }
 public void apply(String UserName,String Skey)
 {
     String sql="update Reginfo set Skey="+Skey+" where UserName='"+UserName+"'";
     try{
         DataStore db=DataStore.getInstance();
            db.execute(sql);           
     }catch(Exception ex){
         ex.printStackTrace();
     }     
 }
 public boolean checkname(String UserName)
 {
     String sql="select * from Reginfo where UserName='"+UserName+"'";
        boolean result=false;
     try{
         DataStore db=DataStore.getInstance();           
            ResultSet rs = db.read(sql);
            if(rs.next()){result=true;}
            rs.close();           
     }
        catch(Exception e){}   
        return result;
 }
 
public boolean checkapply(String UserName,String LetterNum,String LetterKey)
{
    String sql="select * from Reginfo where UserName='"+UserName+"' and LetterNum='"+LetterNum+"' and LetterKey='"+LetterKey+"'";
    boolean result=false;
    try{          
        DataStore db=DataStore.getInstance();    
        ResultSet rs = db.read(sql);
            if(rs.next())
            {              
                result=true;
            }
            rs.close();            
    }
      catch(Exception e){}   
        return result;
}
}