card.java~26~

jbiulder连接数据库

package weng;

import javax.swing.*;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;


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

public class Card extends JInternalFrame {
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField jTextField4 = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField jTextField5 = new JTextField();
  JLabel jLabel7 = new JLabel();
  JTextField jTextField6 = new JTextField();
  JLabel jLabel8 = new JLabel();
  JTextField jTextField7 = new JTextField();
  JLabel jLabel9 = new JLabel();
  JTextField jTextField8 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton4 = new JButton();
  JButton jButton5 = new JButton();
  JButton jButton6 = new JButton();
  JButton jButton7 = new JButton();
  JButton jButton8 = new JButton();
  JButton jButton9 = new JButton();
   ResultSet rs;//数据库变量声明
   Connection con;
  Statement stmt;
  PreparedStatement pstmt;
     java.util.Date today=new java.util.Date();
   void display()
  {
    try {

      jTextField1.setText(rs.getString(1));
      jTextField2.setText(rs.getString(2));
      jTextField3.setText(rs.getString(3));
      jTextField4.setText(rs.getString(4));
      jTextField5.setText(rs.getString(5));
      jTextField6.setText(String.valueOf(rs.getDate(6)));
      jTextField7.setText(String.valueOf(rs.getDouble(7)));
      jTextField8.setText(String.valueOf(rs.getDouble(8)));

    }
    catch(SQLException e){}
  }
  void clear()
   {
     jTextField1.setText("");
     jTextField2.setText("");
     jTextField3.setText("");
     jTextField4.setText("");
     jTextField5.setText("");
     jTextField6.setText("");//(today.getYear()+1900)+"-"+(today.getMonth()+1)+"-"+today.getDate()
     jTextField7.setText("");
     jTextField8.setText("");
   }


  public Card() {

    try {
      jbInit();


      String url="jdbc:oracle:thin:@172.16.1.116:1521:neusoft";
      Class.forName("oracle.jdbc.OracleDriver");
      con=DriverManager.getConnection(url,"scott","tiger");
     stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
      rs=stmt.executeQuery("select * from CARD") ;
        rs.next(); // last() previous() first()
    // String str = rs.getString(2);


    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {
    jLabel1.setText("个人信息明细");
    jLabel1.setBounds(new Rectangle(154, 0, 143, 26));
    this.setTitle("card");
    this.getContentPane().setLayout(null);
    jLabel2.setText("卡号");
    jLabel2.setBounds(new Rectangle(20, 38, 76, 19));
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(69, 35, 96, 23));
    jLabel3.setText("姓名");
    jLabel3.setBounds(new Rectangle(226, 31, 87, 19));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(319, 30, 100, 24));
    jLabel4.setText("身份证");
    jLabel4.setBounds(new Rectangle(26, 65, 73, 23));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(135, 65, 242, 18));
    jLabel5.setText("地址");
    jLabel5.setBounds(new Rectangle(24, 91, 67, 24));
    jTextField4.setText("");
    jTextField4.setBounds(new Rectangle(120, 94, 253, 21));
    jLabel6.setText("电话");
    jLabel6.setBounds(new Rectangle(25, 134, 54, 19));
    jTextField5.setText("");
    jTextField5.setBounds(new Rectangle(93, 128, 119, 26));
    jLabel7.setText("开户日期");
    jLabel7.setBounds(new Rectangle(226, 133, 62, 25));
    jTextField6.setText("");
    jTextField6.setBounds(new Rectangle(304, 132, 109, 25));
    jLabel8.setText("开户金额");
    jLabel8.setBounds(new Rectangle(20, 179, 59, 22));
    jTextField7.setText("");
    jTextField7.setBounds(new Rectangle(95, 173, 110, 27));
    jLabel9.setText("现有金额 ");
    jLabel9.setBounds(new Rectangle(223, 175, 60, 30));
    jTextField8.setBounds(new Rectangle(304, 175, 102, 32));
    jButton1.setBounds(new Rectangle(32, 237, 59, 20));
    jButton1.setText("|<");
    jButton1.addActionListener(new Card_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(117, 239, 74, 19));
    jButton2.setText("<");
    jButton2.addActionListener(new Card_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(207, 240, 80, 17));
    jButton3.setText(">");
    jButton3.addActionListener(new Card_jButton3_actionAdapter(this));
    jButton4.setBounds(new Rectangle(318, 243, 83, 23));
    jButton4.setText(">|");
    jButton4.addActionListener(new Card_jButton4_actionAdapter(this));
    jButton5.setBounds(new Rectangle(7, 273, 78, 18));
    jButton5.setText("add");
    jButton5.addActionListener(new Card_jButton5_actionAdapter(this));
    jButton6.setBounds(new Rectangle(99, 274, 76, 17));
    jButton6.setText("concel");
    jButton6.addActionListener(new Card_jButton6_actionAdapter(this));
    jButton7.setBounds(new Rectangle(188, 273, 81, 19));
    jButton7.setText("delete");
    jButton7.addActionListener(new Card_jButton7_actionAdapter(this));
    jButton8.setBounds(new Rectangle(286, 277, 69, 21));
    jButton8.setText("update");
    jButton8.addActionListener(new Card_jButton8_actionAdapter(this));
    jButton9.setBounds(new Rectangle(370, 278, 60, 19));
    jButton9.setText("exit");
    jButton9.addActionListener(new Card_jButton9_actionAdapter(this));
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jButton4, null);
    this.getContentPane().add(jButton5, null);
    this.getContentPane().add(jButton6, null);
    this.getContentPane().add(jButton7, null);
    this.getContentPane().add(jButton8, null);
    this.getContentPane().add(jButton9, null);
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jTextField3, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jTextField4, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel6, null);
    this.getContentPane().add(jTextField5, null);
    this.getContentPane().add(jLabel7, null);
    this.getContentPane().add(jTextField6, null);
    this.getContentPane().add(jTextField7, null);
    this.getContentPane().add(jLabel8, null);
    this.getContentPane().add(jLabel9, null);
    this.getContentPane().add(jTextField8, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jTextField1, null);
  }

  void jButton1_actionPerformed(ActionEvent e) {
    try{
         rs.first();
         display();
       }
       catch(Exception ee){}

  }

  void jButton2_actionPerformed(ActionEvent e) {
    try{
         rs.previous();
         if(rs.isBeforeFirst())
           {
             JOptionPane.showMessageDialog(this,"这已经是第一条记录了");
             rs.first();
           }

       }
       catch(Exception ee){}
       display();

  }

  void jButton3_actionPerformed(ActionEvent e) {
    try{
         rs.next();
         if(rs.isAfterLast())
           {
             JOptionPane.showMessageDialog(this, "这已经是最后一条记录了");
             rs.last();
           }

         display();
       }
       catch(Exception ee){}

  }

  void jButton4_actionPerformed(ActionEvent e) {
    try{
         rs.last();
         display();
       }
       catch(Exception ee){}

  }

  void jButton5_actionPerformed(ActionEvent e) {
    try {
       pstmt=con.prepareStatement("insert into CARD values(?,?,?,?,?,?,?,?)");
       pstmt.setString(1,jTextField1.getText());
       pstmt.setString(2,jTextField2.getText());
       pstmt.setString(3,jTextField3.getText());
       pstmt.setString(4,jTextField4.getText());
       pstmt.setString(5,jTextField5.getText());
       pstmt.setDate(6,to_date(jTextField6.getText(),'yyyymmdd'));//setString(6,jTextField6.getText());
       pstmt.setString(7,jTextField7.getText());
       pstmt.setString(8,jTextField8.getText());
       pstmt.executeUpdate();

       rs=stmt.executeQuery("select * from CARD");
       rs.next();
       display();
     }
     catch(Exception ee){}

  }

  void jButton6_actionPerformed(ActionEvent e) {
clear();
  }

  void jButton7_actionPerformed(ActionEvent e) {
    try{
             PreparedStatement p=con.prepareStatement("delete from CARD where NO=?");
             p.setString(1,jTextField1.getText());
             p.executeUpdate();
             rs=stmt.executeQuery("select * from CARD");
             rs.next();
             display();

           }
           catch(Exception ee){}

  }

  void jButton9_actionPerformed(ActionEvent e) {
    int result=JOptionPane.showConfirmDialog(this,"确实要退出系统吗","退出",JOptionPane.YES_NO_OPTION);
       if(result==JOptionPane.YES_OPTION)
       {
         this.dispose();
       }

  }

  void jButton8_actionPerformed(ActionEvent e) {
    try{
          rs.refreshRow();
          display();
        }
        catch(Exception ee){}


  }

}

class Card_jButton1_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton1_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class Card_jButton2_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton2_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class Card_jButton3_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton3_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

class Card_jButton4_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton4_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

class Card_jButton5_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton5_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton5_actionPerformed(e);
  }
}

class Card_jButton6_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton6_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

class Card_jButton7_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton7_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton7_actionPerformed(e);
  }
}

class Card_jButton9_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton9_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton9_actionPerformed(e);
  }
}

class Card_jButton8_actionAdapter implements java.awt.event.ActionListener {
  Card adaptee;

  Card_jButton8_actionAdapter(Card adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton8_actionPerformed(e);
  }
}