import java.io.*;
import java.awt.*;
import java.awt.event.*;
import java.net.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;
import javax.swing.event.*;
public class Project{   //메인Project클래스
 public Project(){
  Title t = new Title();
 }  
 public static void main(String args[]){ //메인메소드
  new Project();
 }
 public static void Message(Component a,String b,String c,int i){   //메시지 쓰기 쉽게하기위해..Default메시지
  if(i==0){
   JOptionPane.showConfirmDialog(a,b,c,JOptionPane.DEFAULT_OPTION,JOptionPane.ERROR_MESSAGE);
  }
  else if(i==1){
   JOptionPane.showConfirmDialog(a,b,c,JOptionPane.DEFAULT_OPTION,JOptionPane.INFORMATION_MESSAGE);
  }
 }
 public static boolean Message2(Component a,String b,String c){   //메시지 쓰기쉽게 하기위해.. static으로 불러올수잇게하였다.
  int yesno=JOptionPane.showConfirmDialog(a,b,c,JOptionPane.YES_NO_OPTION,JOptionPane.WARNING_MESSAGE);
  if(yesno==JOptionPane.YES_OPTION){
   return true;
  }
  else{
   return false;
  }
  
 }
   
}
class Admin_Date extends JFrame implements ActionListener,Runnable{
 private Choice chi;
 private JButton jb,jb2;
 private Vector invevc,depovc;
 private JTextField jtf;
 private boolean a=true;
 private JLabel jl;
 private float de= 0;
 private Thread thre = new Thread(this);
 public Admin_Date(){
  super("날짜 지남 모드.");
  Container contentPane = getContentPane();
  dateinvestment();datedeposit();
  jl=new JLabel("몇초당 하루씩 지나게 하시겠습니까? 소수점사용가능.");
  jtf = new JTextField(5);
  jb = new JButton("시작");jb.addActionListener(this);
  jb2 = new JButton("닫기");jb2.addActionListener(this);
  JPanel jp = new JPanel();
  jp.add(jtf);jp.add(jb);jp.add(jb2);
  contentPane.add(jl,"North");
  contentPane.add(jp,"Center");
  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("시작")){
   try{   
   de=Float.parseFloat(jtf.getText());
   jb.setText("중지");
   jb2.setEnabled(false);
   thre.start();
   }catch(Exception ee){Project.Message(this,"숫자만 입력해라?","입력오류",0);}
  }
  else if(str.equals("중지")){
   thre.stop();
   a=false;
   jtf.setText("");
   jl.setText("몇초당 하루씩 지나게 하시겠습니까? 소수점사용가능.");
   jb.setText("시작");
   jb2.setEnabled(true);
  }
  else if(str.equals("닫기")){
   setVisible(false);
   new Admin_frame();
  }
 }
 public void run(){
  int str=(int)(de*1000)/1;
  int i=1;
  while(a){
  try{Thread.sleep(str);}catch(Exception ee){}
  jl.setText(i+++"일 이 지났습니다.");
  date();
  reSaveAll();
  }
 }  
 public void dateinvestment(){
  invevc=new Vector();;
  String query = "select account,value,min,max from investment";  
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   while(rs.next()){
    Investment inve = new Investment(rs.getString(1),rs.getInt(2),rs.getInt(3),rs.getInt(4));
    invevc.add(inve);
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("주식");}
 }

 public void datedeposit(){
  depovc=new Vector();
  String query = "select usedeposit.id,usedeposit.account,usedeposit.money,deposit.rate from usedeposit inner join deposit on usedeposit.account = deposit.account";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   while(rs.next()){
    UserDepo depo = new UserDepo(rs.getString(1),rs.getString(2),rs.getInt(3),rs.getInt(4));
    depovc.add(depo);
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("예금");}
 }
 public void date(){
  for(int i=0; i<invevc.size();i++){
   Investment inve = (Investment)invevc.get(i);
   inve.dateInve();
   invevc.remove(i);
   invevc.add(i,inve);
  }
  for(int i=0; i<depovc.size();i++){
   UserDepo depo = (UserDepo)depovc.get(i);
   depo.dateDepo();
   depovc.remove(i);
   depovc.add(i,depo);
  } 
 }
 public void reSaveAll(){
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  String update;
  String update2;
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   for(int i=0; i<invevc.size(); i++){
    Investment inve = (Investment)invevc.get(i);
    if(inve.delInve()){
     update="delete from investment where account ='"+inve.getAccount()+"'";
    }
    else{
     update="update investment set value ="+inve.getValue()+" where account ='"+inve.getAccount()+"'";
    }
    stmt.executeUpdate(update);
   }
   for(int i=0; i<depovc.size(); i++){
    UserDepo depo = (UserDepo)depovc.get(i);
    update2="update usedeposit set money ="+depo.getMoney()+" where account ='"+depo.getAccount()+"' and id='"+depo.getID()+"'";
    stmt.executeUpdate(update2);
   }
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("예금");}
 }
} 

class Admin_frame extends JFrame implements ActionListener{   //Admin메인창
 private JButton b5,b6;
 private JTabbedPane adminjtp;
 private Container contentPane;
 public Admin_frame(){
  setTitle("Administrator");
  contentPane = getContentPane();
  adminjtp = new JTabbedPane(JTabbedPane.LEFT,JTabbedPane.WRAP_TAB_LAYOUT);
  adminjtp.add("신규주식",new New_Ju());
  adminjtp.add("신규예금",new New_Ye());
  adminjtp.add("주식리스트",new Ju_List());
  adminjtp.add("예금리스트",new Ye_List());
  b5 = new JButton("← Login Mode");
  b5.addActionListener(this);
  b6 = new JButton("새로고침");
  b6.addActionListener(this);
  JButton b7=new JButton("날짜지남");
  b7.addActionListener(this);
  JPanel bp = new JPanel();
  bp.add(b5);
  bp.add(b6);
  bp.add(b7);
  contentPane.add(adminjtp, "Center");
  contentPane.add(bp,"South");
  pack();
  setVisible(true);
 }
 public void restart(){   //새로고침을 눌렀을시..실행될내용
  new Admin_frame();
  setVisible(false);
 }
 public void actionPerformed(ActionEvent ae){
  String str=ae.getActionCommand();
  if(str.equals("새로고침")){restart();}
  else if(str.equals("날짜지남")){
   setVisible(false);
   new Admin_Date();
  }
  else{setVisible(false);new Title();}
 }

}

class New_Ju extends JInternalFrame implements ActionListener{

 private JLabel lb1, lb2, lb3, lb4, lb5;
 private JPanel jp1, jp2, jp3, jp4, jp5;
 private JPanel jp_total, jbp; // JPanel 통합, 버튼 통합용.
 private JTextField jtf1, jtf2, jtf3, jtf4, jtf5;
 private JButton jbt1; // 확인
 public New_Ju() {
  super("신규주식");
  // setTitle("신규주식"); // 주식명,주식개수,현재주가,최소값,최대값

  jp_total = new JPanel();
  jp_total.setLayout(new GridLayout(5, 1)); // 총 추가되야할.

  jp1 = new JPanel();
  lb1 = new JLabel("주 식 명       : ");
  jtf1 = new JTextField(10); // 주식명 관련 텍스트 필드
  jp1.setLayout(new FlowLayout()); // 첫번째 패널
  jp1.add(lb1);// 라벨붙이고
  jp1.add(jtf1); // 패널에 추가 텍스트필드

  jp2 = new JPanel();
  lb2 = new JLabel("현 재 주 가  : ");
  jtf2 = new JTextField(10);
  jp2.setLayout(new FlowLayout());
  jp2.add(lb2);
  jp2.add(jtf2);

  jp3 = new JPanel();
  lb3 = new JLabel("주 식 개 수  : ");
  jtf3 = new JTextField(10);
  jp3.setLayout(new FlowLayout());
  jp3.add(lb3);
  jp3.add(jtf3);

  jp4 = new JPanel();
  lb4 = new JLabel("최소값(－) : ");
  jtf4 = new JTextField(10);
  jp4.setLayout(new FlowLayout());
  jp4.add(lb4);
  jp4.add(jtf4);

  jp5 = new JPanel();
  lb5 = new JLabel("최대값(＋) : ");
  jtf5 = new JTextField(10);
  jp5.setLayout(new FlowLayout());
  jp5.add(lb5);
  jp5.add(jtf5);

  jbt1 = new JButton("확인"); // 확인 취소
  jbt1.addActionListener(this);

  jbp = new JPanel(); // 버튼 패널.
  jbp.setLayout(new FlowLayout());
  jbp.add(jbt1);

  jp_total.add(jp1);
  jp_total.add(jp2);
  jp_total.add(jp3);
  jp_total.add(jp4);
  jp_total.add(jp5);

  add(jp_total, "Center");
  add(jbp, "South");

  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){
  String str=ae.getActionCommand();
  if(str.equals("확인")){
   newJuDB();
  }
 }
 public void newJuDB(){
  String update = "insert into investment values('"+jtf1.getText()+"',"+jtf2.getText()+","+jtf3.getText()+","+jtf4.getText()+","+jtf5.getText()+")";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  if(!jtf1.getText().replace(" ","").equals("")){
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   conn.close();
   stmt.close();
   clear();
  }catch(SQLException ee){if(ee.getSQLState().equals("23000")){Project.Message(this,"중복된 주식이 있습니다.","Error",0);}
   else if(ee.getSQLState().equals("42000")){Project.Message(this,"빈공간없이 입력해주십시오.","Error",0);}
   else if(ee.getSQLState().equals("42S22")){Project.Message(this,"주식명외엔 숫자만 입력해주세요.","Error",0);}}
  }
  else{Project.Message(this,"주식명을 입력해주세요.","Error",0);}
 }
 public void clear(){
  jtf1.setText("");
  jtf2.setText("");
  jtf3.setText("");
  jtf4.setText("");
  jtf5.setText("");
 }     
}

class New_Ye extends JInternalFrame implements ActionListener{  //예금화면 클래스
 private JTextArea jta;
 private JButton jbt1;
 private JPanel jp1, jp_total, jp2, jbp;
 private JLabel lb1, lb2;
 private JTextField jtf1, jtf2;
 public New_Ye() {
  super("신규예금"); // 이율, 예금명
  lb1 = new JLabel("예금명       : ");
  jtf1 = new JTextField(10);
  jp1 = new JPanel();
  jp1.setLayout(new FlowLayout());
  jp1.add(lb1);
  jp1.add(jtf1);

  lb2 = new JLabel("연이율 (%) : ");
  jtf2 = new JTextField(10);
  jp2 = new JPanel();
  jp2.setLayout(new FlowLayout());
  jp2.add(lb2);
  jp2.add(jtf2);

  jp_total = new JPanel();
  jp_total.setLayout(new GridLayout(3, 1));
  jp_total.add(new JLabel("     ※ 주의해서 입력하세요※"));
  jp_total.add(jp1);
  jp_total.add(jp2);

  jbt1 = new JButton("확인");
  jbt1.addActionListener(this);
  jbp = new JPanel(); // 버튼 패널.
  jbp.setLayout(new FlowLayout());
  jbp.add(jbt1);
  add(jp_total, "Center");
  add(jbp, "South");
  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){
  String str=ae.getActionCommand();
  if(str.equals("확인")){
   newJuDB();
  }
 }
 public void newJuDB(){
  String update = "insert into deposit values('"+jtf1.getText()+"',"+jtf2.getText()+")";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  if(!jtf1.getText().replace(" ","").equals("")){
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   conn.close();
   stmt.close();
   clear();
  }catch(SQLException ee){Project.Message(this,"연이율에 값이입력이 안되었거나 문자가 입력되었습니다.","Error",0);}
  }
  else{Project.Message(this,"예금명을 입력해주세요.","Error",0);}
 }
 public void clear(){
  jtf1.setText("");
  jtf2.setText("");
 }
}

class Ju_List extends JInternalFrame implements ListSelectionListener,ActionListener{  //주식리스트 클래스.
 private JList jl;
 private JTextField accounttf,valuetf,numbertf,mintf,maxtf;
 private JButton check,change,del;
 private String listr[]=null;
 private JPanel jp5;
 public Ju_List(){
  super("주식리스트");
  check = new JButton("확인");change = new JButton("수정");del = new JButton("삭제");
  check.setEnabled(false);del.setEnabled(false);change.setEnabled(false);
  check.addActionListener(this);change.addActionListener(this);del.addActionListener(this);
  JPanel jp4 = new JPanel();jp4.add(check);jp4.add(change);jp4.add(del);
  accounttf = new JTextField(10);valuetf= new JTextField(10);numbertf= new JTextField(10);mintf= new JTextField(10);maxtf= new JTextField(10);
  accounttf.setEditable(false);valuetf.setEditable(false);numbertf.setEditable(false);mintf.setEditable(false);maxtf.setEditable(false);
  JPanel jp2 = new JPanel();
  jp2.setLayout(new GridLayout(5,1));
  jp2.add(accounttf);jp2.add(valuetf);jp2.add(numbertf);jp2.add(mintf);jp2.add(maxtf);
  JPanel jp3 = new JPanel();
  jp3.setLayout(new GridLayout(5,1));
  jp3.add(new JLabel("  주 식 명      : "));jp3.add(new JLabel("  현 재 주 가:  "));
  jp3.add(new JLabel("  주 식 개 수 : "));jp3.add(new JLabel("  최소값(－) : "));jp3.add(new JLabel("  최대값(＋) : "));
  listr=getVC();
  jl=new JList(listr);
  jl.addListSelectionListener(this);
  jl.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
  JPanel jp1 = new JPanel();
  jp1.setLayout(new BorderLayout());
  jp1.add(new Label("주식명"),"North");
  jp1.add(jl,"Center");
  jp5= new JPanel();
  jp5.setLayout(new GridLayout(1,3));
  jp5.add(jp1);jp5.add(jp3);jp5.add(jp2);
  add(jp4,"South");add(jp5,"Center");
  pack();
  setVisible(true);
 }
 public String[] getVC(){
  String list = "select *from investment order by account";
  String listr[] = null;
  boolean b=true;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(list);
   rs.last();
   listr = new String[rs.getRow()];
   int i =0;
   rs.first();
   while(b){
    listr[i++]=rs.getString(1);
    b=rs.next();    
   }
  }catch(SQLException ee){}
  return listr;
 }
 public void valueChanged(ListSelectionEvent lse){
  String str = listr[jl.getSelectedIndex()];
  accounttf.setEditable(false);valuetf.setEditable(false);numbertf.setEditable(false);mintf.setEditable(false);maxtf.setEditable(false);
  check.setEnabled(false);del.setEnabled(true);change.setEnabled(true);
  String list = "select *from investment where account='"+str+"'";
  try{
   String url = "jdbc:mysql://localhost:3306/java";
   String id = "root";
   String pw = "dytc1234";
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(list);
   rs.next();
   accounttf.setText(rs.getString(1));
   valuetf.setText(""+rs.getInt(2));
   numbertf.setText(""+rs.getInt(3));
   mintf.setText(""+rs.getInt(4));
   maxtf.setText(""+rs.getInt(5));
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
 }
 public void actionPerformed(ActionEvent ae){
  String str=ae.getActionCommand();
  if(str.equals("수정")){
   accounttf.setEditable(true);
   valuetf.setEditable(true);
   numbertf.setEditable(true);
   mintf.setEditable(true);
   maxtf.setEditable(true);
   check.setEnabled(true);
   change.setEnabled(false);
   del.setEnabled(false);
  }
  else if(str.equals("확인")){
   if(check()){
   check.setEnabled(false);
   change.setEnabled(true);
   del.setEnabled(true);
   accounttf.setEditable(false);
   valuetf.setEditable(false);
   numbertf.setEditable(false);
   mintf.setEditable(false);
   maxtf.setEditable(false);
   Project.Message(this,"성공적으로 저장되었습니다.","저장완료",1);
   } 
  }
  else if(str.equals("삭제")){
   check.setEnabled(false);
   change.setEnabled(true);
   if(Project.Message2(this,"정말 삭제하시겠습니까?","삭제확인")){
    del();
    Project.Message(this,"삭제 되었습니다","삭제완료",1);
   }
   else{Project.Message(this,"취소 되었습니다","취소완료",1);}
  }
 }
 public boolean check(){
  String str = listr[jl.getSelectedIndex()];
  String update = "update investment set account='"+accounttf.getText()+"',value="+valuetf.getText()+",number="+numbertf.getText()+",min="+mintf.getText()+",max="+maxtf.getText()+" where account ='"+str+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  boolean b = false;
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.close();
   conn.close();
   listr[jl.getSelectedIndex()]=accounttf.getText();
   b=true;
  }catch(SQLException ee){if(ee.getSQLState().equals("23000")){Project.Message(this,"중복된 주식이 있습니다.","Error",0);}
   else if(ee.getSQLState().equals("42000")){Project.Message(this,"빈공간없이 입력해주십시오.","Error",0);}
   else if(ee.getSQLState().equals("42S22")){Project.Message(this,"주식명외엔 숫자만 입력해주세요.","Error",0);}
   else{System.out.println(ee.getSQLState());}
  }
  return b;

 }
 public void del(){
  String str = listr[jl.getSelectedIndex()];
  listr[jl.getSelectedIndex()]=null;
  String remove = "delete from investment where account ='"+str+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(remove);
   stmt.close();
   conn.close();
  }catch(Exception ee){System.out.println(ee.getMessage());}
 }
}
class Ye_List extends JInternalFrame implements ActionListener,ListSelectionListener{
 private JList jl;
 private JTextField accounttf,ratetf;
 private JButton check,change,del;
 private String listr[]=null;
 private JPanel jp5;
 public Ye_List(){
  super("예금리스트");
  check = new JButton("확인");change = new JButton("수정");del = new JButton("삭제");
  check.setEnabled(false);del.setEnabled(false);change.setEnabled(false);
  check.addActionListener(this);change.addActionListener(this);del.addActionListener(this);
  JPanel jp4 = new JPanel();jp4.add(check);jp4.add(change);jp4.add(del);
  accounttf = new JTextField(10);ratetf= new JTextField(10);
  accounttf.setEditable(false);ratetf.setEditable(false);
  JPanel jp2 = new JPanel();
  jp2.setLayout(new GridLayout(5,1));
  jp2.add(accounttf);jp2.add(ratetf);
  JPanel jp3 = new JPanel();
  jp3.setLayout(new GridLayout(5,1));
  jp3.add(new JLabel("예금명       : "));jp3.add(new JLabel("연이율 (%) : "));
  listr=getVC();
  jl=new JList(listr);
  jl.addListSelectionListener(this);
  jl.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
  JPanel jp1 = new JPanel();
  jp1.setLayout(new BorderLayout());
  jp1.add(new Label("예금명"),"North");
  jp1.add(jl,"Center");
  jp5= new JPanel();
  jp5.setLayout(new GridLayout(1,3));
  jp5.add(jp1);jp5.add(jp3);jp5.add(jp2);
  add(jp4,"South");add(jp5,"Center");
  pack();
  setVisible(true);
 }
 public String[] getVC(){
  String list = "select *from deposit order by account";
  String listr[] = null;
  boolean b=true;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(list);
   rs.last();
   listr = new String[rs.getRow()];
   int i =0;
   rs.first();
   while(b){
    listr[i++]=rs.getString(1);
    b=rs.next();    
   }
  }catch(SQLException ee){}
  return listr;
 }
 public void valueChanged(ListSelectionEvent lse){
  String str = listr[jl.getSelectedIndex()];
  String list = "select *from deposit where account='"+str+"'";
  accounttf.setEditable(false);ratetf.setEditable(false);
  check.setEnabled(false);del.setEnabled(true);change.setEnabled(true);
  try{
   String url = "jdbc:mysql://localhost:3306/java";
   String id = "root";
   String pw = "dytc1234";
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(list);
   rs.next();
   accounttf.setText(rs.getString(1));
   ratetf.setText(""+rs.getInt(2));
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
 }
 public void actionPerformed(ActionEvent ae){
  String str=ae.getActionCommand();
  if(str.equals("수정")){
   accounttf.setEditable(true);
   ratetf.setEditable(true);
   check.setEnabled(true);
   change.setEnabled(false);
   del.setEnabled(false);
  }
  else if(str.equals("확인")){
   if(check()){
    check.setEnabled(false);
    change.setEnabled(true);
    del.setEnabled(true);
    accounttf.setEditable(false);
    ratetf.setEditable(false);
    Project.Message(this,"성공적으로 저장되었습니다.","저장완료",1);
   }    
  }
  else if(str.equals("삭제")){
   check.setEnabled(false);
   change.setEnabled(true);
   if(Project.Message2(this,"정말 삭제하시겠습니까?","삭제확인")){
    del();
    Project.Message(this,"삭제 되었습니다","삭제완료",1);
   }
   else{Project.Message(this,"취소 되었습니다","취소완료",1);}
  }
 }
 public boolean check(){
  String str = listr[jl.getSelectedIndex()];
  String update = "update deposit set account='"+accounttf.getText()+"',rate="+ratetf.getText()+" where account ='"+str+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  boolean b=false;
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.close();
   conn.close();
   listr[jl.getSelectedIndex()]=accounttf.getText();
   b=true;   
  }catch(SQLException ee){if(ee.getSQLState().equals("23000")){Project.Message(this,"중복된 예금이 있습니다.","Error",0);}
   else if(ee.getSQLState().equals("42000")){Project.Message(this,"빈공간없이 입력해주십시오.","Error",0);}
   else if(ee.getSQLState().equals("42S22")){Project.Message(this,"연이율엔 숫자만 입력해주세요.","Error",0);}
   else{System.out.println(ee.getSQLState());}
  }
  return b;

 }
 public void del(){
  String str = listr[jl.getSelectedIndex()];
  listr[jl.getSelectedIndex()]=null;
  String remove = "delete from deposit where account ='"+str+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(remove);
   stmt.close();
   conn.close();
  }catch(Exception ee){System.out.println(ee.getMessage());}
 }
}
class LoginTitle extends JFrame implements ActionListener{   //로그인 타이틀화면입니다.
 private UserInfo usif;
 private Container contentPane;
 public LoginTitle(UserInfo usi){
  usif=usi;
  contentPane = getContentPane();
  setTitle("사용자 모드");
  Label l = new Label(usif.getName()+"님의 현재자산은 "+usif.getMoney()+"원 입니다.");
  JButton moneyb = new JButton("입출금");moneyb.addActionListener(this);
         JButton depositb = new JButton("예금가입");depositb.addActionListener(this);
  JButton investmentb = new JButton("주식투자");investmentb.addActionListener(this);
  JButton deinb = new JButton("투자내역");deinb.addActionListener(this);
  JButton logoutb = new JButton("로그아웃");logoutb.addActionListener(this);
  JPanel jp = new JPanel();
  jp.add(moneyb);jp.add(depositb);jp.add(investmentb);jp.add(deinb);jp.add(logoutb);
  contentPane.setLayout(new GridLayout(2,1));
  contentPane.add(l);
  contentPane.add(jp);
  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("입출금")){
   setVisible(false);
   new InoutMoney(usif);
  }
  else if(str.equals("예금가입")){
   setVisible(false);
   new NewDeposit(usif);
  }
  else if(str.equals("주식투자")){
   setVisible(false);
   new NewInvestment(usif);
  }
  else if(str.equals("투자내역")){
   setVisible(false);
   new MyMoney(usif,true);
  }
  else if(str.equals("로그아웃")){
   setVisible(false);
   new Title();
  }
 }  
}
class MyMoney extends JFrame implements ActionListener,ItemListener{
 private Container contentPane;
 private UserInfo usif;
 private Vector invevc,depovc;
 private JRadioButton jr1,jr2;
 private JRadioButton[] depojrb,invejrb;
 private JTextField jtf;
 private JLabel jl1,jl2;
 private JPanel p2;
 private ButtonGroup bg = new ButtonGroup();
 public MyMoney(UserInfo us,boolean b){
  setTitle("나의투자내역");
  getInvestment(us.getID());
  getDeposit(us.getID());
  p2=new JPanel();
  usif=us;
  contentPane = getContentPane();
  if(b){
   jr1=new JRadioButton("주식확인&판매",true);jr1.addItemListener(this);
   jr2=new JRadioButton("예금확인&판매",false);jr2.addItemListener(this);
   jl1 = new JLabel(" 주식판매수 : ");
   jl2 = new JLabel(" 주 ");
   p2.add(sellInvestment(us.getID()));
  }
  else{
   jr1=new JRadioButton("주식확인&판매",false);jr1.addItemListener(this);
   jr2=new JRadioButton("예금확인&판매",true);jr2.addItemListener(this);
   jl1 = new JLabel(" 출금금액 : ");
   jl2 = new JLabel(" 원 ");
   p2.add(sellDeposit(us.getID()));
  }
  bg.add(jr1);bg.add(jr2);
  jtf = new JTextField(10);

  JButton sell = new JButton("판매");sell.addActionListener(this);
  JButton close = new JButton("닫기");close.addActionListener(this);
  JPanel p1 = new JPanel();JPanel p3 = new JPanel();JPanel p4 = new JPanel();JPanel p5 = new JPanel();
  p1.add(jr1);p1.add(jr2);p3.add(jl1);p3.add(jtf);p3.add(jl2);p4.add(sell);p4.add(close);
  p5.setLayout(new GridLayout(1,2));
  p5.add(p3);p5.add(p4);
  contentPane.add(p1,"North");contentPane.add(p2,"Center");contentPane.add(p5,"South");
  pack();
  setVisible(true);
 }
 public void getInvestment(String a){
  invevc=new Vector();;
  String query = "select useinvestment.account,useinvestment.number,investment.value from useinvestment inner join investment on useinvestment.account = investment.account where id='"+a+"'";  
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   while(rs.next()){
    UserInve ui = new UserInve(rs.getString(1),rs.getInt(2),rs.getInt(3));
    invevc.add(ui);
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("주식");}
 }
 public JPanel sellInvestment(String a){
  boolean b=true;
  ButtonGroup bg2 = new ButtonGroup();
  invejrb = new JRadioButton[invevc.size()];
  JPanel invep= new JPanel(); 
  if(invevc.size()==0){
   invep.add(new Label("구매하신 주식이 없습니다."));
  }
  else{
   invep.setLayout(new GridLayout(invevc.size()+1,3));
   invep.add(new Label("주식명"));invep.add(new Label("보유주식수"));invep.add(new Label("현재주가"));
   for(int i=0;i<invevc.size();i++){
    UserInve ui = (UserInve)invevc.get(i);
    invejrb[i]=new JRadioButton(ui.getAccount(),b);
    bg2.add(invejrb[i]);
    invep.add(invejrb[i]);invep.add(new Label(""+ui.getNumber()+" 주"));invep.add(new Label(""+ui.getValue()+"원"));
    b=false;
   }
  }
  return invep;
 }
 public JPanel sellDeposit(String a){
  boolean b=true;
  ButtonGroup bg2 = new ButtonGroup();
  depojrb = new JRadioButton[depovc.size()];
  JPanel depop= new JPanel(); 
  if(depovc.size()==0){
   depop.add(new Label("가입하신 예금이 없습니다."));
  }
  else{
   depop.setLayout(new GridLayout(depovc.size()+1,3));
   depop.add(new Label("예금명"));depop.add(new Label("가입자금"));depop.add(new Label("연이율(%)"));
   for(int i=0;i<depovc.size();i++){
    UserDepo ud = (UserDepo)depovc.get(i);
    depojrb[i]=new JRadioButton(ud.getAccount(),b);
    bg2.add(depojrb[i]);
    depop.add(depojrb[i]);depop.add(new Label(""+ud.getMoney()+"원"));depop.add(new Label(""+ud.getRate()+"%"));
    b=false;
   }
  }
  return depop;

 }
 public void getDeposit(String a){
  depovc=new Vector();
  String query = "select usedeposit.account,usedeposit.money,deposit.rate from usedeposit inner join deposit on usedeposit.account = deposit.account where id='"+a+"'";  
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   while(rs.next()){
    UserDepo ud = new UserDepo(rs.getString(1),rs.getInt(2),rs.getInt(3));
    depovc.add(ud);
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("예금");}
 }
 public void itemStateChanged(ItemEvent ie){
  if(jr1.isSelected()){
   p2.removeAll();
   p2.add(sellInvestment(usif.getID()));
   pack();
   jl1.setText(" 주식판매수 : ");
   jl2.setText(" 주 ");
  }
  else if(jr2.isSelected()){
   p2.removeAll();
   p2.add(sellDeposit(usif.getID()));
   pack();
   jl1.setText(" 출금금액 : ");
   jl2.setText(" 원 ");
  }
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("판매")){
   sell();    
  }
  if(str.equals("닫기")){
   setVisible(false);
   new LoginTitle(usif);
  }
 }
 public void sell(){
  try{
   int str=Integer.parseInt(jtf.getText());
   if(jr1.isSelected()){
    invesell(str); 
    new MyMoney(usif,true);
    setVisible(false);  
   }
   else{
    deposell(str);
    new MyMoney(usif,false);
    setVisible(false);
   }
  }catch(Exception ee){Project.Message(this,"숫자만 입력해주세요.","입력오류",0);}
 }
 public void invesell(int str){
  UserInve uise;
  for(int i=0;i<invejrb.length;i++){
   if(invejrb[i].isSelected()){
    uise = (UserInve)invevc.get(i); 
    invesell2(uise,str);   
    break;
   }
  }  
 }
 public void invesell2(UserInve usiv,int str){
  int num = str;
  if(usiv.getNumber()>num){ //판매가능
   usif.inMoney(""+usiv.getMoney(num));
   inveDB(usif.getMoney(),false,usiv,num);
   Project.Message(this,""+num+"개의 주식을 판매하였습니다.","판매 완료",1);
  }
  else if(usiv.getNumber()==num){   //판매가능* 같아서 useinvestment에 잇는내용사라져야함
   usif.inMoney(""+usiv.getMoney(num));
   inveDB(usif.getMoney(),true,usiv,num);
   Project.Message(this,usiv.getAccount()+"의 주식을 모두판매 하였습니다.","모두 판매",1);
  }
  else{
   Project.Message(this,""+usiv.getNumber()+"주 까지 판매 가능합니다.","주식초과",0);
  }
    
 }
 public void inveDB(long money,boolean del,UserInve usiv,int num){
  String update = "update java set money="+usif.getMoney()+" where id='"+usif.getID()+"'";   //javaDB업뎃
  String update2;
  String update3=null;
  String query = "select number from investment where account='"+usiv.getAccount()+"'";
  if(del){update2 = "delete from useinvestment where account='"+usiv.getAccount()+"' and id='"+usif.getID()+"'";}   // useinvestmentDB업뎃
  else{update2= "update useinvestment set number="+usiv.getNumber()+" where id='"+usif.getID()+"' and account='"+usiv.getAccount()+"'";}
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   rs.next();
   int rsi=rs.getInt(1);
   num=num+rsi;
   update3 = "update investment set number="+num+" where account='"+usiv.getAccount()+"'";
   stmt.executeUpdate(update);
   stmt.executeUpdate(update2);
   stmt.executeUpdate(update3);
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.println("오류");}
 }
 public void deposell(int str){
  UserDepo udse;
  for(int i=0;i<depojrb.length;i++){
   if(depojrb[i].isSelected()){
    udse=(UserDepo)depovc.get(i);
    deposell2(udse,str);    
    break;
   }
  }
 }
 public void deposell2(UserDepo usdp,int str){
  if(usdp.getMoney()>str){ //판매가능
   usdp.delMoney(str);
   usif.inMoney(""+usdp.getMoney());
   depoDB(usif.getMoney(),false,usdp,str);
   Project.Message(this,""+str+"원의 금액을 찾으셨습니다.","인출 완료",1);
  }
  else if(usdp.getMoney()==str){   //판매가능* 같아서 usedeposit에 잇는내용사라져야함
   usdp.delMoney(str);
   usif.inMoney(""+usdp.getMoney());
   depoDB(usif.getMoney(),true,usdp,str);
   Project.Message(this,usdp.getAccount()+"을 모두 인출하셨습니다","예금 해지",1);
  }
  else{
   Project.Message(this,""+usdp.getMoney()+"원 까지 가능합니다.","예금액초과",0);
  }
 }
 public void depoDB(long mymoney,boolean b,UserDepo usdp,int sellmoney){
  String update = "update java set money="+usif.getMoney()+" where id='"+usif.getID()+"'";   //javaDB업뎃
  String update2;
  if(b){update2 = "delete from usedeposit where account='"+usdp.getAccount()+"' and id='"+usif.getID()+"'";} // useinvestmentDB업뎃
  else{update2= "update usedeposit set money="+usdp.getMoney()+" where id='"+usif.getID()+"' and account='"+usdp.getAccount()+"'";}
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.executeUpdate(update2);
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.println("오류");}
 }
}
class NewDeposit extends JFrame implements ActionListener{  //예금가입 모드 클래스..
 private UserInfo usif;
 private String[][] sdeposit=null;
 private JRadioButton[] jr=null;
 private Container contentPane;
 private JTextField moneytf;
 private ButtonGroup bg;
 public NewDeposit(UserInfo us){
  setTitle("예금가입");
  usif=us;
  contentPane = getContentPane();
  moneytf = new JTextField(10);  
  JPanel jp1 = new JPanel();
  sdeposit=showlist();
  jp1=choicep(sdeposit);
  JPanel jp2 = new JPanel();
  JPanel jp3 = new JPanel();
  JPanel jp4 = new JPanel();
  JButton jb1 = new JButton("예금가입");jb1.addActionListener(this);
  JButton jb2 = new JButton("취소");jb2.addActionListener(this);
  jp2.setLayout(new GridLayout(1,2));
  jp2.add(jb1);jp2.add(jb2);jp3.add(new Label("금액 : "));jp3.add(moneytf);jp3.add(new Label(" 원"));
  jp4.add(jp3);jp4.add(jp2);
  contentPane.add(jp1,"Center");
  contentPane.add(jp4,"South");
  pack();
  setVisible(true);
 }
 public String[][] showlist(){
  String deposits[][]=null;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  String query = "select *from deposit order by rate";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   rs.last();
   int i =0;
   deposits = new String[2][rs.getRow()];
   rs.first();
   while(true){
    deposits[0][i]=rs.getString(1);
    deposits[1][i++]=""+rs.getInt(2);
    if(!rs.next()){break;}
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
  return deposits;
 }
 public JPanel choicep(String[][] a){
  Boolean b = true;
  JPanel choicep = new JPanel();
  choicep.setLayout(new GridLayout(a[0].length+1,1));
  bg= new ButtonGroup();
  jr= new JRadioButton[a[0].length];
  if(a[0].length!=0){choicep.add(new Label("예금명 (연이율 %)"));}
  else{choicep.add(new Label("예금할 예금이 없습니다."));}
  for(int i=0;i<a[0].length;i++){
   jr[i] = new JRadioButton(a[0][i]+" (연이율: "+a[1][i]+"%)",b);
   bg.add(jr[i]);
   choicep.add(jr[i]);
   b=false;
  }
  return choicep;
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("예금가입")){
   useDeposit(choice());
  }
  else if(str.equals("취소")){
   setVisible(false);new LoginTitle(usif);
  }
 }
 public int choice(){
  int getI = 0;
  for(int i=0;i<jr.length;i++){
   if(jr[i].isSelected()){
    getI=i;
    break;
   }
  }
  return getI;
 }
 public void useDeposit(int i){
  String update;
  String check = "select *from usedeposit where id='"+usif.getID()+"' and account='"+sdeposit[0][i]+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
  if(moneytf.getText().equals("")){Project.Message(this,"값을 입력해주세요.","오류",0);}
  else if(usif.getMoney()>=Long.parseLong(moneytf.getText())){
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs=stmt.executeQuery(check);
   long money1=Long.parseLong(moneytf.getText());
   if(rs.next()){
    long money2 = rs.getInt(2);
    long money3 = money1+money2;
    usif.outMoney(moneytf.getText());
    update = "update usedeposit set money="+money3+" where id='"+usif.getID()+"' and account='"+sdeposit[0][i]+"'";
    stmt.executeUpdate(update);
   }
   else if(!rs.next()){
    update = "insert into usedeposit values('"+usif.getID()+"',"+moneytf.getText()+",'"+sdeposit[0][i]+"')";
    usif.outMoney(moneytf.getText());
    stmt.executeUpdate(update);
   }
   Project.Message(this,"성공적으로 예금하였습니다.","예금성공",1);
   stmt.close();
   conn.close();
  }catch(Exception ee){Project.Message(this,"입금금액 초과입니다.","오류",0);}
  }
  else{Project.Message(this,usif.getMoney()+"원까지 가능합니다.","오류",0);}
  }catch(Exception eee){Project.Message(this,"숫자만 입력해주십시오.","문자입력",0);}
  reSave();
 }
 public void reSave(){
  String update="update java set money="+usif.getMoney()+" where id='"+usif.getID()+"'";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
 }  
}
class NewInvestment extends JFrame implements ActionListener,ItemListener,KeyListener {  //주식투자 모드 클래스..
 private UserInfo usif;
 private Container contentPane;
 private JTextField numbertf;
 private JRadioButton jrb[];
 private ButtonGroup bg;
 private JLabel jl;
 private Vector vc;
 private Investment maininve;
 private int chei=0,sum=0;
 public NewInvestment(UserInfo us){
  setTitle("주식투자");
  usif=us;
  contentPane = getContentPane();
  numbertf = new JTextField(8);
  numbertf.addKeyListener(this);
  getDB();  
  JPanel jp1 = new JPanel();
  jp1=choicep();
  JPanel jp2 = new JPanel();
  JPanel jp3 = new JPanel();
  JPanel jp4 = new JPanel();
  jp4.setLayout(new GridLayout(3,1));
  JButton jb1 = new JButton("주식투자");jb1.addActionListener(this);
  JButton jb2 = new JButton("취소");jb2.addActionListener(this);
  jl = new JLabel("가격은 총 "+sum+"원 입니다.");
  jp2.add(jb1);jp2.add(jb2);jp3.add(new Label("구매할개수 : "));jp3.add(numbertf);jp3.add(new Label(" 주"));
  jp4.add(jp3);jp4.add(jl);jp4.add(jp2);
  contentPane.add(jp1,"Center");
  contentPane.add(jp4,"South");
  pack();
  setVisible(true);
 }
 public void getDB(){
  vc = new Vector();
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  String query = "select *from investment where number!=0 order by value ";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(query);
   while(rs.next()){
    Investment inve = new Investment(rs.getString(1),rs.getInt(2),rs.getInt(3),rs.getInt(4),rs.getInt(5));
    vc.add(inve);
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.println("오류잇나?");}
 }
 public JPanel choicep(){
  JPanel getjp1 = new JPanel();
  JPanel getjp2 = new JPanel();
  JPanel getjp3 = new JPanel();
  JPanel getjp = new JPanel();
  jrb=new JRadioButton[vc.size()];
  Boolean b = true;
  getjp1.setLayout(new GridLayout(jrb.length+1,1));
  getjp2.setLayout(new GridLayout(jrb.length+1,1));
  getjp3.setLayout(new GridLayout(jrb.length+1,1));
  bg= new ButtonGroup();
  if(jrb.length!=0){
   getjp1.add(new Label(" 주식명 "));getjp2.add(new Label(" 주식가격 "));getjp3.add(new Label(" 주식수 "));
   maininve=(Investment)vc.get(0);
  }
  else{getjp.add(new Label("투자할 주식이 없습니다."));}
  for(int i=0;i<jrb.length;i++){
   Investment inve = (Investment)vc.get(i);
   jrb[i]=new JRadioButton(inve.getAccount(),b);
   jrb[i].addItemListener(this);
   bg.add(jrb[i]);
   getjp1.add(jrb[i]);
   getjp2.add(new Label(""+inve.getValue()));
   getjp3.add(new Label(""+inve.getNumber()));
   b=false;   
  }
  getjp.add(getjp1);getjp.add(getjp2);getjp.add(getjp3);  
  return getjp;
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("주식투자")){
   if(!(numbertf.getText()).replace("0","").equals("")){
   if(usif.outMoney(sum)){
    if(delInvestment(numbertf.getText())){
     useInvestment(numbertf.getText());
     reSave();
     new NewInvestment(usif);
     Project.Message(this,"성공적으로 구매하였습니다.","구매성공",1);
     setVisible(false);
    }
   }
   else{Project.Message(this,"구매금액 초과입니다.","금액초과",0);}
   numbertf.setText("");
   sum=0;
   jl.setText("가격은 총 "+sum+"원 입니다.");
   }
   else{Project.Message(this,"정확한 값을입력해주세요","값불확실",0);}
  }
  else if(str.equals("취소")){
   setVisible(false);new LoginTitle(usif);
  }
 }
 public void keyPressed(KeyEvent e){}
 public void keyReleased(KeyEvent e){   //이벤트동작,..
  if(numbertf.getText().equals("")){
   sum=0;
   jl.setText("가격은 총 "+sum+"원 입니다.");
  }
  else if(jrb.length!=0){
   Investment inve=(Investment)vc.get(chei);
   try{
    int num=Integer.parseInt(numbertf.getText());
    sum=num*inve.getValue();
    jl.setText("가격은 총 "+sum+"원 입니다.");        
   }catch(Exception ee){Project.Message(this,"숫자만 입력하세요","입력오류",0);numbertf.setText("");}
  }
 }
 public void keyTyped(KeyEvent te){}
 public void itemStateChanged(ItemEvent ie){    //이벤트동작
  for(int i=0;i<jrb.length;i++){
   if(jrb[i].isSelected()){
    try{
    maininve=(Investment)vc.get(i);
    int num=Integer.parseInt(numbertf.getText());
    sum=num*maininve.getValue();
    }catch(Exception ee){sum=0;}
    jl.setText("가격은 총 "+sum+"원 입니다.");
    chei=i;
    break;
   }
  }
 }
 public void useInvestment(String a){   //구매하는 메소드.
  String update;
  String check = "select *from useinvestment where id='"+usif.getID()+"' and account='"+maininve.getAccount()+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  if(numbertf.getText().equals("")){Project.Message(this,"값을 입력해주세요.","오류",0);}
  else{
   try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs=stmt.executeQuery(check);
   int num1=Integer.parseInt(numbertf.getText());
   if(rs.next()){
    int num2 = rs.getInt(2);
    int num3 = num1+num2;
    update = "update useinvestment set number="+num3+" where id='"+usif.getID()+"' and account='"+maininve.getAccount()+"'";
    stmt.executeUpdate(update);
   }
   else if(!rs.next()){
    update="insert into useinvestment values('"+usif.getID()+"',"+a+",'"+maininve.getAccount()+"')";
    stmt.executeUpdate(update);
   }
   stmt.close();
   conn.close();
   }catch(SQLException ee){}
  }
 }
 public boolean delInvestment(String a){   //구매한주식만큼 총주식수에서 빠지게하는 메소드
  boolean b = false;
  int j = Integer.parseInt(a);
  String check = "select number from investment where account='"+maininve.getAccount()+"'";
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(check);
   rs.next();
   int i=rs.getInt(1);
   if(j<=i){
    i=i-j;
    String update = "update investment set number="+i+" where account='"+maininve.getAccount()+"'";
    stmt.executeUpdate(update);
    b=true;
   }
   else{
    Project.Message(this,"구매할수있는 수량이 초과하였습니다(최대 : "+rs.getInt(1)+"주)","입력오류",0);
    numbertf.setText("");
    sum=0;
    jl.setText("가격은 총 "+sum+"원 입니다.");
   }
  }catch(SQLException ee){System.out.println("에러없겟지..");}
  return b;
 }  
 public void reSave(){   //다시저장..
  String update="update java set money="+usif.getMoney()+" where id='"+usif.getID()+"'";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
 }
}
class InoutMoney extends JFrame implements ActionListener{  //입출금 모드 클래스..
 private Container contentPane;
 private UserInfo usif;
 private JRadioButton jrb1,jrb2;
 private JTextField jtf;
 public InoutMoney(UserInfo us){   //입출금모드의 메인창
  usif=us;
  setTitle("입출금모드");
  jtf = new JTextField(10);
  contentPane = getContentPane();  
  jrb1 = new JRadioButton("입금",true);
  jrb2 = new JRadioButton("출금",false);
  JButton jb = new JButton("확인");
  JButton jb2 = new JButton("닫기");
  jb.addActionListener(this);jb2.addActionListener(this);
  ButtonGroup bg = new ButtonGroup();
  bg.add(jrb1);bg.add(jrb2);
  JPanel jp1 = new JPanel();
  JPanel jp2 = new JPanel();
  jp1.add(jrb1);jp1.add(jrb2);
  jp2.add(new Label("금액 : "));
  jp2.add(jtf);jp2.add(new Label(" 원"));jp2.add(jb);jp2.add(jb2);
  contentPane.setLayout(new GridLayout(2,1));
  contentPane.add(jp1);contentPane.add(jp2);
  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){   //이벤트..
  String str = ae.getActionCommand();
  if(str.equals("확인")){
   money();   
  }
  else if(str.equals("닫기")){
   setVisible(false);
   new LoginTitle(usif);
  }
 }
 public void money(){
  try{
   if(100000000l<Long.parseLong(jtf.getText())){Project.Message(this,"한번에 1억까지 입출금가능합니다.","입출금오류",0);}
   else if(jrb1.isSelected()){  //입금 눌렀을시..(확인누르면동작합니다.)
    usif.inMoney(jtf.getText());
    reSave();
    Project.Message(this,jtf.getText()+"원이 입금되어서 총 "+usif.getMoney()+"원 이 되었습니다.","입금완료",1);
   }
   else if(jrb2.isSelected()){  //출금 눌렀을시..
    if(usif.outMoney(jtf.getText())){
    reSave();
    Project.Message(this,jtf.getText()+"원이 출금되어서 총 "+usif.getMoney()+"원 이 되었습니다.","출금완료",1);
    }
    else{Project.Message(this,usif.getMoney()+"원 까지 출금하실수 있습니다.","출금불가",0);}
   }
  }catch(Exception ee){Project.Message(this,"숫자만 입력해주세요.","입출금오류",0);}
 }
 public void reSave(){   //다시 DB에 저장하는 메소드
  String update="update java set money="+usif.getMoney()+" where id='"+usif.getID()+"'";
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   stmt.executeUpdate(update);
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
 }
}
 
class NewUser extends JFrame implements ActionListener{   //회원가입 클래스.
 private JTextField newidtf,newnametf,newbirthdaytf,newphonetf,newemailtf,newaddresstf;
 private JButton idcheckb,okb,cancelb,clearb;
 private JPasswordField newpwtf;
 private Boolean blidcheck;
 private JFrame checkjf;
 public NewUser(){
  blidcheck = false;
  setTitle("회원가입"); 
  Container contentPane = getContentPane();
  idcheckb = new JButton("중복확인");
  okb = new JButton("확인");
  cancelb = new JButton("취소");
  clearb = new JButton("다시작성");
  okb.addActionListener(this);
  cancelb.addActionListener(this);
  clearb.addActionListener(this);
  idcheckb.addActionListener(this);
  newidtf = new JTextField(10);
  newpwtf = new JPasswordField(10);
  newpwtf.setEchoChar('*');
  newnametf = new JTextField(10);
  newbirthdaytf = new JTextField(10);
  newphonetf = new JTextField(10);
  newaddresstf = new JTextField(10);
  newemailtf = new JTextField(10);
  JPanel jp1 = new JPanel();
  jp1.setLayout(new GridLayout(7,1));
  JPanel jp2 = new JPanel();
  jp2.setLayout(new GridLayout(7,1));
  JPanel jp3 = new JPanel();
  jp3.setLayout(new GridLayout(7,1));
  jp1.add(new JLabel("아이디"));jp1.add(new JLabel("비밀번호"));jp1.add(new JLabel("이름"));
  jp1.add(new JLabel("생년월일"));jp1.add(new JLabel("전화번호"));jp1.add(new JLabel("주소"));jp1.add(new JLabel("E-mail"));
  jp2.add(newidtf);jp2.add(newpwtf);jp2.add(newnametf);jp2.add(newbirthdaytf);
  jp2.add(newphonetf);jp2.add(newaddresstf);jp2.add(newemailtf);
  jp3.add(idcheckb);jp3.add(new JLabel());jp3.add(new JLabel());
  jp3.add(new JLabel("ex)19991225"));jp3.add(new JLabel("ex)0325552222"));jp3.add(new JLabel());jp3.add(new JLabel());
  JPanel jp4 = new JPanel();
  jp4.setLayout(new GridLayout(1,3));
  jp4.add(jp1);jp4.add(jp2);jp4.add(jp3);
  JPanel jp5 = new JPanel();
  jp5.add(okb);jp5.add(cancelb);jp5.add(clearb);
  contentPane.add(jp4,"Center");contentPane.add(jp5,"South");
  pack();
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){  //이벤트동작..
  String s = ae.getActionCommand();
  if(s.equals("중복확인")){
   checkTitle(idcheck());
  }
  else if(s.equals("확인")){
   if(blidcheck){
    usercheck();
    Project.Message(this,"회원가입이 완료되었습니다.","가입완료",1);
    setVisible(false);
    new Title();
   }
   else{
    Project.Message(this,"중복된 ID가 있거나 중복확인을 안하셨습니다.","가입불가능",0);
   }
   blidcheck=false;
  }
  else if(s.equals("취소")){
   setVisible(false);
   new Title();
  }
  else if(s.equals("다시작성")){
   blidcheck=false;
   newidtf.setEditable(true);
   newidtf.setText("");
   newpwtf.setText("");
   newnametf.setText("");
   newbirthdaytf.setText("");
   newphonetf.setText("");
   newaddresstf.setText("");
   newemailtf.setText("");
  }
  else if(s.equals("닫기")){
   checkjf.setVisible(false);
  }
 }
 public void checkTitle(Boolean b){   //중복확인후에 반환된 Boolean값을 인수로 가져와서 JFrame창을 띄우는 메소드
  blidcheck=b;
  checkjf = new JFrame("중복확인");
  checkjf.setSize(200,100);
  JPanel checkjp = new JPanel();
  JButton closejb = new JButton("닫기");
  closejb.addActionListener(this);
  Container checkPane = checkjf.getContentPane();
  JLabel l;
  String staaa = newidtf.getText();
  if(staaa.equals("")){
   l = new JLabel("아이디를 입력해 주세요.");
   blidcheck = false; 
  }
  else if(blidcheck){
   l = new JLabel("ID 사용이 가능 합니다.");
   newidtf.setEditable(false);   
  }
  else{
   l = new JLabel("중복된 ID가 있습니다.");
  }
  checkjp.add(l);
  checkjp.add(closejb);
  checkPane.add(checkjp,"Center");
  checkjf.setVisible(true);
 }
 public void usercheck(){   //회원가입되는곳. DB로 바로저장.
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){System.out.print("첫번째");}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pass = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pass);
   Statement stmt = conn.createStatement();
   String abc = "insert into java values('"+newidtf.getText()+"','"+newpwtf.getText()+"','"+newnametf.getText()+"','"+newbirthdaytf.getText()+"','"+newphonetf.getText()+"','"+newaddresstf.getText()+"','"+newemailtf.getText()+"',"+0+")";
   stmt.executeUpdate(abc);
  }catch(SQLException ee){}
 }
 public Boolean idcheck(){ //ID 중복확인 하는 메소드. 그리고 중복된값이 있으면 false, 없으면 true를 반환
  String s = null;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){System.out.println("여긴가?");}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pass = "dytc1234";
  try{
   Connection conn = DriverManager.getConnection(url,id,pass);
   String str = "select *from java where id='"+newidtf.getText()+"';";
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(str);
   while(rs.next()){
   s = rs.getString("id");
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.print("동작안되");}
  if(s==null){
   return true;
  }
  else{ return false;}
 }
}

class Search extends JFrame implements ActionListener,ItemListener{   //ID또는PW 검색클래스
 private JButton idb;
 private JRadioButton idsearch,pwsearch;
 private JTextField firsttf,secondtf;
 private JLabel al,bl;
 private ButtonGroup bg;
 public Search(){
  setTitle("ID/PW검색");
  Container contentPane = getContentPane();
  idsearch = new JRadioButton("ID 검색",true);
  pwsearch = new JRadioButton("PW 검색",false);
  bg = new ButtonGroup();
  idb = new JButton("ID  찾기");
  JButton closeb = new JButton("닫기");
  firsttf = new JTextField(10);
  secondtf = new JTextField(10);
  al = new JLabel("이         름 입력 : ");
  bl = new JLabel("생년월일 입력 : ");
  idb.addActionListener(this);
  closeb.addActionListener(this);
  idsearch.addItemListener(this);
  pwsearch.addItemListener(this);
  bg.add(idsearch);
  bg.add(pwsearch);
  JPanel jp = new JPanel();
  JPanel jp2 = new JPanel();
  JPanel jp3 = new JPanel();
  jp3.setLayout(new GridLayout(2,2));
  jp3.add(al);
  jp3.add(firsttf);
  jp3.add(bl);
  jp3.add(secondtf);
  jp2.add(idb);
  jp2.add(closeb);
  jp.add(idsearch);
  jp.add(pwsearch);
  contentPane.add(jp,"North");
  contentPane.add(jp2,"South");
  contentPane.add(jp3,"Center");
  setSize(200,150);
  setVisible(true);
 }
 public void actionPerformed(ActionEvent ae){
  String str = ae.getActionCommand();
  if(str.equals("닫기")){
   setVisible(false);
   new Title();
  }
  else if((firsttf.getText().equals(""))||(secondtf.getText().equals(""))){
   Project.Message(this,"공백이 있습니다.","검색 오류",0);
  }
  else if(str.equals("ID  찾기")){
   String strid[] = idSearch(firsttf.getText(),secondtf.getText());
   if(strid.length!=0){
    String a="";
    for(int i=0;i<strid.length;i++){
     if(i==0){a=a+strid[i];}
     else{a=a+","+strid[i];}
    }
    Project.Message(this,"당신의 ID는 총 "+strid.length+"개 입니다. ("+a+")","아이디 확인",1);
   }
   else{Project.Message(this,"일치하는 정보가 존재하지 않습니다.","찾지못함",1);
   }
   firsttf.setText("");
   secondtf.setText("");
  }
  else if(str.equals("PW찾기")){
   String strpw = pwSearch(firsttf.getText(),secondtf.getText());
   if(strpw!=null){
   Project.Message(this,"당신의 PW는 '"+strpw+"' 입니다.","패스워드 확인",1);
   }
   else{Project.Message(this,"일치하는 정보가 존재하지 않습니다.","찾지못함",1);
   }
   firsttf.setText("");
   secondtf.setText("");
  }
  else if(str.equals("닫기")){
   setVisible(false);
  }
 }
 public void itemStateChanged(ItemEvent ie){
  if(idsearch.isSelected()){   //id검색을 눌럿을시..
   firsttf.setText("");
   secondtf.setText("");
   idb.setText("ID  찾기");
   al.setText("이         름 입력 : ");
   bl.setText("생년월일 입력 : ");
      
  }
  else if(pwsearch.isSelected()){   //pw검색을 눌럿을시..
   firsttf.setText("");
   secondtf.setText("");
   idb.setText("PW찾기");
   al.setText("  I    D 입력 : ");
   bl.setText("  E-mail 입력 : ");
  }
 }
 public String[] idSearch(String a, String b){    //String 배열을 반환한다. ID가 1개이상일수도 있으므로..
  String restr[]=null;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  String search = "select *from java where name = '"+a+"' and birthday ='"+b+"'";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(search);
   rs.last();    //ResultSet객체의 끝으로이동
   int i=rs.getRow();   //끝으로 이동후 지금위치의 값을가져온다.
   restr = new String[i];   //String배열객체를 맞춰서 만든다.
   rs.first();   //다시 처음으로 이동
   for(int j=0;j<i;j++){ 
    restr[j] = rs.getString("id");
    rs.next();
   }
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){}
  return restr;
 }
 public String pwSearch(String a,String b){     //String값을 반환한다. PW가 여러개 일수는 없다.
  String restr=null;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  String search = "select *from java where id = '"+a+"' and email ='"+b+"'";
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   ResultSet rs = stmt.executeQuery(search);
   rs.next();
   restr = rs.getString("pass");
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){System.out.println("에러발생");}
  return restr;
 }
}

class Title extends JFrame implements ActionListener{   //Title클래스, JFrame 클래스를 상속받고 ActionListener인터페이스 구현
 private JTextField idtf;
 private JPasswordField pwtf;
 private JButton adminb,loginb,searchb,newuserb;
 public Title(){ //메인화면 창을 보여준다.
  setTitle("메인화면");
  Container contentPane = getContentPane();
  idtf = new JTextField(10);
  pwtf = new JPasswordField(10);
  pwtf.setEchoChar('*');
  adminb = new JButton("관리자모드");
  loginb = new JButton("로그인");
  searchb = new JButton("ID/PW찾기");
  newuserb = new JButton("회원가입");
  adminb.addActionListener(this);
  loginb.addActionListener(this);
  searchb.addActionListener(this);
  newuserb.addActionListener(this);
  JLabel idl = new JLabel("ID");
  JLabel pwl = new JLabel("PW");
  JPanel jp1 = new JPanel();
  JPanel jp2 = new JPanel();
  jp1.add(jpadd(idl,pwl));
  jp1.add(jpadd(idtf,pwtf));
  jp1.add(jpadd(adminb,loginb));
  jp2.add(searchb);
  jp2.add(newuserb);
  contentPane.add(jp1,"Center");
  contentPane.add(jp2,"South");
  pack();
  setVisible(true);
 }
 public boolean adminlogin(String a){  //관리자 로그인 확인 !!
  String adminpw="dytc1234";
  if(a.equals(adminpw)){
   return true;
  }
  else{return false;}
 }
 public void actionPerformed(ActionEvent ae){  //이벤트동작, 버튼어떤것이 눌러졌냐에따라 실행
  String s = ae.getActionCommand();
  if(s.equals("관리자모드")){
   idtf.setText("");
   pwtf.setText("");
   idtf.setEditable(false);
   adminb.setText("사용자모드");
   loginb.setText("관리자접속");
   searchb.setEnabled(false);
   newuserb.setEnabled(false);
   pack();
  }
  else if(s.equals("로그인")){
   UserInfo uif = login(idtf.getText(),pwtf.getText());
   if(null!=uif){
    setVisible(false);
    new LoginTitle(uif);
   }
  }
  else if(s.equals("ID/PW찾기")){
   setVisible(false);
   new Search();
  }
  else if(s.equals("회원가입")){
   setVisible(false);
   new NewUser();
  }
  else if(s.equals("사용자모드")){
   idtf.setEditable(true);
   adminb.setText("관리자모드");
   loginb.setText("로그인");
   searchb.setEnabled(true);
   newuserb.setEnabled(true);
   pack();
  }
  else if(s.equals("관리자접속")){
   if(adminlogin(pwtf.getText())){
           setVisible(false); 
    new Admin_frame();
   }
   else{}
  }
 }
 public JPanel jpadd(Component e,Component f){  //그냥 편리성에 jpadd메소드 만듬.
  JPanel p = new JPanel();
  p.setLayout(new GridLayout(2,1));
  p.add(e);
  p.add(f);
  return p;
 }
 public UserInfo login(String a,String b){   //로그인 성공시엔 UserInfo객체를 가져오고 실패시엔 null값을 가져온다.
  String s = null;
  try{
   Class.forName("org.gjt.mm.mysql.Driver");
  }catch(ClassNotFoundException ee){}
  String url = "jdbc:mysql://localhost:3306/java";
  String id = "root";
  String pw = "dytc1234";
  UserInfo usif=null;
  try{
   Connection conn = DriverManager.getConnection(url,id,pw);
   Statement stmt = conn.createStatement();
   String str = "select *from java where id='"+a+"'and pass='"+b+"'";
   ResultSet rs = stmt.executeQuery(str);
   rs.next();
   usif = new UserInfo(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getInt(8));
   rs.close();
   stmt.close();
   conn.close();
  }catch(SQLException ee){Project.Message(this,"ID또는PW가 틀렸습니다.","접속불가",0);}
  return usif;
 }
}

class UserInfo{   //유저 정보 클래스
 private String id,password,name,address,birthday,email,phone;  //아이디 비밀번호 이름 주소 생일 이메일 전화번호가 저장.
 private long money;
 public UserInfo(String id,String password,String name,String birthday,String phone,String address,String email,long money){
  this.id=id;
  this.password=password;
  this.name=name;
  this.birthday=birthday;
  this.phone=phone;
  this.address=address;
  this.email=email;
  this.money=money;
 }
 public String getID(){return id;}
 public String getPW(){return password;}
 public String getName(){return name;}
 public String getBirthday(){return birthday;}
 public String getPhone(){return phone;}
 public String getAddress(){return address;}
 public String getEmail(){return email;}
 public long getMoney(){return money;}
 public void setID(String id){this.id=id;}
 public void setPW(String password){this.password=password;}
 public void setName(String name){this.name=name;}
 public void setBirthday(String birthday){this.birthday = birthday;}
 public void setPhone(String phone){this.phone=phone;}
 public void setAddress(String address){this.address=address;}
 public void setEmail(String email){this.email=email;}
 public void inMoney(String money){this.money = this.money+Long.parseLong(money);}
 public boolean outMoney(String money){
  long outmoney =Long.parseLong(money);
  if(this.money>=outmoney){
   this.money=this.money-outmoney;
   return true;
  }
  else {return false;}
 }
 public boolean outMoney(int money){
  long outmoney =money;
  if(this.money>=outmoney){
   this.money=this.money-outmoney;
   return true;
  }
  else {return false;}
 }
}

class UserInve{
 private int number;   //구매한 주식개수
 private String account;    //구매한 주식명
 private int value;
 public UserInve(String account,int number,int value){   //다른주식의 주식살때(신규주식)
  this.account = account;
  this.number = number;
  this.value=value;
 }
 public UserInve(String account,String number){  
  this.account = account;
  this.number = Integer.parseInt(number);
 }
 public String getAccount(){return account;}
 public int getNumber(){return number;}
 public int getValue(){return value;}
 public int getMoney(int a){
  number=number-a;
  return value*a;
 }
}

class UserDepo{
 private float rate;  //이율
 private String account;   //예금한 예금명
 private int money;   //예금한돈
 private String id;
 public UserDepo(String id,String account,int money,int rate){
  this.id=id;
  this.account=account;
  this.money=money;
  this.rate=rate;
 }
 public UserDepo(String account,int money,int rate){  //다른예금에 예금할때(신규예금)
  this.account=account;
  this.money=money;
  this.rate=rate;
 }
 public UserDepo(String account,String money){ 
  this.account=account;
  this.money=Integer.parseInt(money);
 }
 public String getID(){return id;}
 public String getAccount(){return account;}
 public float getRate(){return rate;}
 public int getMoney(){return money;}
 public void addMoney(String addmoney){money=money+Integer.parseInt(addmoney);}  //같은예금에 더예금할때..
 public void delMoney(String delmoney){money=money-Integer.parseInt(delmoney);}  //0보다 작아지지않게 if문넣어야함.(예금에서 돈찾을때)]
 public void delMoney(int i){money=money-i;}
 public void dateDepo(){
  float year = (rate/100)/365;
  float plus = money*year;
  float total = plus+money;
  money=(int)total/1;
 }
}

class Investment{
 private int value,min,max,number;  //value(주가),min(상승폭최소값),max(최대값),number(주식개수)
 private String account;   //account(주식명)
 private boolean b=false;
 public Investment(String account,int value,int min,int max){
  this.account = account;
  this.value = value;
  this.min = min;
  this.max = max; 
 }
 public Investment(String account,int value,int number,int min,int max){
  this.account = account;
  this.value = value;
  this.number = number;
  this.min = min;
  this.max = max;  
 }
 public String getAccount(){return account;}
 public int getValue(){return value;}
 public int getMin(){return min;}
 public int getMax(){return max;}
 public int getNumber(){return number;}
 public void addNumber(String addnum){number=number+Integer.parseInt(addnum);}  //증자할경우
 public void delNumber(String delnum){number=number-Integer.parseInt(delnum);}  //감자할경우
 public void dateInve(){
  Random r = new Random();
  int date=r.nextInt(1+min+max)-min;
  value=value+date;
  if(value<=0){b=true;}
 }
 public boolean delInve(){
  return b;
 }
}

class Deposit{
 private float rate;    //예금이율
 private String account;   //예금명
 public Deposit(String account,String rate){
  this.rate = Float.parseFloat(rate);
  this.account = account;
 }
 public String getAccount(){return account;}
 public float getRate(){return rate;}
}

//제가 소스제출할때 DB명령어는 제출하지않았습니다.. foreign키와 primary키를 사용해서 한DB안의 table끼리 서로 연동(?) 이
되는것처럼 하였는데,, 그명령어를 여기서 표시하겠습니다;;
java table생성시 명령어 : create table java (id char(20) not null, pass char(15) not null, name char(10) not null,
birthday char(8) not null, phone char(12),address varchar(30),email varchar(25),money bigint(50), primary key(id));
deposit table생성시 명령어 : create table deposit(account char(30),rate int(3),primary key(account));
investment table생성시 명령어 : create table investment(account char(30),value int(10),number int(10),min int(5),max int(5), primary key(account));
useinvestment table생성시 명령어 : create table useinvestment(id char(20) not null,number int(10) not null,account char(30) not null,constraint foreign key(id) references java(id), constraint foreign key(account) references investment(account));
usedeposit table 생성시 명령어 : create table usedeposit(id char(20) not null,money bigint(30),account char(30) not null,
constraint foreign key(id) references java(id), constraint foreign key(account) references deposit(account));

회원가입을 눌렀을경우.. DB에서 회원정보를 읽어옵니다.
읽어온회원정보를 Vector에 넣은후에..
ID 중복확인을 할수있게하였고..
중복된아이디가 없을경우엔 다시작성을 누르지않은이상 아이디수정을 못하도록하였습니다.
그리고 가입이 완료되는경우 Vector에 그자료를 넣었습니다.


질문사항 : 원래 처음엔 가입완료되는순간 DB로 바로 넣고, 중복확인도 DB에서 빼와서 비교하였는데,
벡터를 사용하는 것이 좋은것일까요 아님 바로 DB를 사용해서 비교하는게 낳을까요,
DB를 많이사용하게되면. 계속 Connector와 Statement를 생성해줘야하고 ..
소스가 길어지는걸 보고 벡터를사용하면 소스가 확연히 줄어들것같아서 벡터를 사용하게되었는데말이죠ㅠㅠ

프로젝트의 메인화면입니다.
JFrame을 사용해서 만들었습니다.
저번주 부터 짜기 시작하였지만.. 너무 늦게시작한 감이있네요ㅠ

위에 보이는 이미지는 원도우 창 안에 윈도우 창이 존재하는 이미지 입니다. 보통 포토샵 프로그램에서 여러 이미지를 불러오게 되면 포토샵 프로그램 창 안에 여러가지 이미지들이 각각 따로 배치가 돼 있는 것을 볼 수 있습니다. 오늘은 바로 이와 같이 윈도우 창 안에 윈도우 창을 넣는 방법에 대해서 이야기 해 봅시다.

그럼 위에 이미지를 아주 단순하게 생각을 해 봅시다.

JFrame 안에 JFrame를 넣는다.
이 단순한 생각을 코딩한다면 JFrame.add(JFrame) 이런 방식을 사용한다는 의미 일 것입니다.
그러나 실제로 돌리면 안된다는 것을 알 수 있습니다. 물론 공부를 탄탄히 하셨다면 왜 인지도 알수 있겠지요.

그럼 어떻게 해야 할까요? 방법은 간단합니다 JInternalFrame 클래스를 이용하면 됩니다.
JInternalFrame 클래스에 대한 자세한 정보는 API를 참고하세요.

이용 방법은 간단합니다. add를 이용해서 넣어주면 됩니다.

그러나 여기서 주의해야 할 것이 한가지 있는데..

setSize, setLocation 등 일부 메소드가 먹히지 않는 경우가 발생할 수 있습니다.

그 이유는 바로 레이아웃 메니저에 대한 설정 문제 입니다. 이런 간단한 설명으로는 이해가 부족할 수 있으니 간단한 예제를 통해서 더 자세히 알아보도록 합시다.

import javax.swing.*;

public class Internaltest {

 public static void main(String[] args) {
  JFrame frm = new JFrame("외부 윈도우 창");
  
  JPanel jp = new JPanel();
  frm.setLayout(null);
  // 이 부분이 생각보다 중요할 수 있습니다. 레이아웃 메니저 때문에 원하는 데로 설정이 안될 수도 있습니다.
  // JPanel, JFrame는 기본적인 레이아웃이 다르게 설정 돼 있죠..

  JInternalFrame inter = new JInternalFrame("내부 윈도우 창",false,false,false,false);
    // JInternalFrame 클래스는 생성자가 많으니 API를 잘 참고해야 합니다.

  inter.setSize(200,300);
  inter.setLocation(100, 50);
  inter.setVisible(true);
  
  frm.add(inter);
  frm.setSize(500,500);
  
  frm.setVisible(true);
  
 }
}

간단한 예제이지만 실제로 해보지 않으면 도움이 되질 못합니다. 꼭 해보시길 바랍니다.