package mybank.com.user;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 1999</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class user {
  private String userName="";
  private String password="";
  private int chMoney;
  private int money;
  private boolean flag=false;
  private java.sql.Connection con=null;
  private java.sql.Statement stat=null;
  private java.sql.ResultSet rs=null;
  private String db="com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=HYGJ";
  private String sql="select passwd from cunkuan where mname=";
  public void setName(String userName)
  {
    this.userName=userName;
  }
  public void setpassword(String password)
  {
    this.password=password;
  }
  public void setmoney(int money)
  {
    this.money=money;
  }
  public void setchMoney(int chMoney)
  {
   this.chMoney=chMoney;
  }
  public boolean ischeck()
  {
      this.delu();
      return flag;
  }
  private void delu()
  {
   try {
     Class.forName(db);
     con = java.sql.DriverManager.getConnection(url, "sa", "qaz123");
     stat = con.createStatement();
     sql = sql + "'" + userName + "'";
     rs = stat.executeQuery(sql);
     if (rs.next()) {
       if (rs.getString("passwd").equals(password)) {
         flag = true;
    }
   }
   rs.close();
   stat.close();
   con.close();
   }
   catch (Exception e) {
     System.out.println(e.getMessage());

   }finally
       {
         try {
         if(rs!=null)
         {
           rs.close();
         }
         if(stat!=null)
         {
          stat.close();
         }
         if(con!=null)
         {
          con.close();
         }

         }
         catch (Exception ex) {

         }


   }
  }
  public void qukuan()throws Exception
  {
   Class.forName(db);
   con=java.sql.DriverManager.getConnection(url,"sa","qaz123");
   stat=con.createStatement();
   String sqld="select money from cunkuan where mname='"+userName+"' ";
   rs=stat.executeQuery(sqld);
   //System.out.println(rs.toString());
   if(rs.next())
   {
     String userMoney=rs.getString(1);
     try {
       int users=Integer.parseInt(userMoney);
       if(users>=money)
       {
         int yMoney=users-money;
         System.out.println("請保管好你的錢"+money);System.out.println("余額為"+yMoney);
         String sqlcharu="update cunkuan set money='"+yMoney+"' where mname='"+userName+"' ";
         stat.executeUpdate(sqlcharu);
         System.out.println("更新成功");
       }
       else
       {
        System.out.println("您的存款余額不足,不能進行次操作");
       }
       rs.close();
       stat.close();
       con.close();

     }
     catch (Exception ex) {
       System.out.println(ex.getMessage());

     }
   }
  }
  public user() {

  }
  /*public static void main(String[]args) throws Exception
  {
    user u=new user();

    u.setName("張三");
    u.setpassword("123");
   u.setmoney(3);
    u.qukuan();
   System.out.println(u.ischeck());

  }*/
  public void quary() throws Exception
  {
     Class.forName(db);
     con=java.sql.DriverManager.getConnection(url,"sa","qaz123");
     stat=con.createStatement();
     String sqld="select money from cunkuan where mname='"+userName+"' and passwd='"+password+"' ";
     rs=stat.executeQuery(sqld);
     if(rs.next())
     {
      String quarymoney=rs.getString(1);
      System.out.println("您的存款為"+quarymoney+"元");
     }

  }
  public void chunKuan() throws Exception
  {
     Class.forName(db);
     con=java.sql.DriverManager.getConnection(url,"sa","qaz123");
     stat=con.createStatement();
     String sqld="insert into cunkuan(mname,money,passwd) values('"+userName+"','"+chMoney+"','"+password+"')";
     rs=stat.executeUpdate(sqld);
     if(rs.next())
     {
     // String quarymoney=rs.getString(1);
      System.out.println("存款成功,謝謝使用");
     }

  }

}