cardusepanel.java~1~

来自「银行信用评估系统」· JAVA~1~ 代码 · 共 529 行 · 第 1/2 页

    jTextField22.setText("jTextField2");
    jTextField22.setBounds(new Rectangle(102, 27, 57, 22));
    jLabel119.setToolTipText("");
    jLabel119.setText("0");
    jLabel119.setBounds(new Rectangle(366, 8, 34, 16));
    jTextField21.setText("jTextField1");
    jTextField21.setBounds(new Rectangle(26, 26, 57, 22));
    jTextField24.setText("jTextField4");
    jTextField24.setBounds(new Rectangle(266, 28, 65, 22));
    jLabel1110.setFont(new java.awt.Font("Dialog", 0, 12));
    jLabel1110.setText("500元以下");
    jLabel1110.setBounds(new Rectangle(269, 8, 58, 16));
    //jButton1.setToolTipText("");
    jButton1.setBounds(new Rectangle(78, 479, 74, 30));
    jButton1.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton1.setText("更新");
    jButton1.addActionListener(new CardUsePanel_jButton1_actionAdapter(this));
    jButton2.setBounds(new Rectangle(185, 478, 74, 31));
    jButton2.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton2.setText("取消");
    jButton2.addActionListener(new CardUsePanel_jButton2_actionAdapter(this));
    jButton3.setBounds(new Rectangle(290, 480, 72, 30));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton3.setToolTipText("");
    jButton3.setText("返回");
    jButton3.addActionListener(new CardUsePanel_jButton3_actionAdapter(this));
    jPanel1.add(jTextField1, null);
    jPanel1.add(jTextField2, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jTextField3, null);
    jPanel1.add(jTextField5, null);
    jPanel1.add(jTextField4, null);
    jPanel1.add(jLabel2, null);
    jPanel1.add(jLabel3, null);
    jPanel1.add(jLabel5, null);
    jPanel1.add(jLabel6, null);
    this.add(jLabel8, null);
    this.add(jPanel2, null);
    jPanel2.add(jLabel12, null);
    jPanel2.add(jLabel9, null);
    jPanel2.add(jTextField6, null);
    jPanel2.add(jTextField7, null);
    jPanel2.add(jTextField9, null);
    jPanel2.add(jTextField10, null);
    jPanel2.add(jLabel7, null);
    jPanel2.add(jTextField8, null);
    jPanel2.add(jLabel11, null);
    jPanel2.add(jLabel10, null);
    this.add(jLabel14, null);
    this.add(jPanel3, null);
    this.add(jLabel1, null);
    this.add(jPanel1, null);
    jPanel3.add(jLabel17, null);
    jPanel3.add(jLabel18, null);
    jPanel3.add(jTextField14, null);
    jPanel3.add(jTextField13, null);
    jPanel3.add(jLabel13, null);
    jPanel3.add(jTextField12, null);
    jPanel3.add(jLabel15, null);
    jPanel3.add(jTextField11, null);
    jPanel3.add(jTextField15, null);
    jPanel3.add(jLabel16, null);
    jPanel4.add(jLabel111, null);
    jPanel4.add(jTextField20, null);
    jPanel4.add(jLabel114, null);
    jPanel4.add(jLabel113, null);
    jPanel4.add(jTextField16, null);
    jPanel4.add(jTextField19, null);
    jPanel4.add(jTextField17, null);
    jPanel4.add(jTextField18, null);
    jPanel4.add(jLabel19, null);
    jPanel4.add(jLabel112, null);
    this.add(jButton1, null);
    this.add(jButton2, null);
    this.add(jButton3, null);
    jPanel5.add(jTextField23, null);
    jPanel5.add(jTextField25, null);
    jPanel5.add(jLabel119, null);
    jPanel5.add(jTextField24, null);
    jPanel5.add(jLabel1110, null);
    jPanel5.add(jTextField21, null);
    jPanel5.add(jTextField22, null);
    jPanel5.add(jLabel117, null);
    jPanel5.add(jLabel115, null);
    jPanel5.add(jLabel118, null);
    this.add(jLabel116, null);
    this.add(jPanel5, null);
    this.add(jLabel110, null);
    this.add(jPanel4, null);
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
  }
  public void connect() {
      try{
        String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CCES";
        String username = "sa";
        String password = "";
        con = DriverManager.getConnection(url, username, password);
      }
    catch(Exception e)
      {System.out.print("系统错误，请重新运行。");}
    }
    void loaddata()
    {
         try{
           query = "select * from UseInstance ";
           pstmt = con.prepareStatement(query);
           rs = pstmt.executeQuery();
           if (rs.next()) {
            jTextField1.setText(Integer.toString(rs.getInt(1)));
            jTextField2.setText(Integer.toString(rs.getInt(2)));
            jTextField3.setText(Integer.toString(rs.getInt(3)));
            jTextField4.setText(Integer.toString(rs.getInt(4)));
            jTextField5.setText(Integer.toString(rs.getInt(5)));
            jTextField6.setText(Integer.toString(rs.getInt(6)));
            jTextField7.setText(Integer.toString(rs.getInt(7)));
            jTextField8.setText(Integer.toString(rs.getInt(8)));
            jTextField9.setText(Integer.toString(rs.getInt(9)));
            jTextField10.setText(Integer.toString(rs.getInt(10)));
            jTextField11.setText(Integer.toString(rs.getInt(11)));
            jTextField12.setText(Integer.toString(rs.getInt(12)));
            jTextField13.setText(Integer.toString(rs.getInt(13)));
            jTextField14.setText(Integer.toString(rs.getInt(14)));
            jTextField15.setText(Integer.toString(rs.getInt(15)));
            jTextField16.setText(Integer.toString(rs.getInt(16)));
            jTextField17.setText(Integer.toString(rs.getInt(17)));
            jTextField18.setText(Integer.toString(rs.getInt(18)));
            jTextField19.setText(Integer.toString(rs.getInt(19)));
            jTextField20.setText(Integer.toString(rs.getInt(20)));
            jTextField21.setText(Integer.toString(rs.getInt(21)));
            jTextField22.setText(Integer.toString(rs.getInt(22)));
            jTextField23.setText(Integer.toString(rs.getInt(23)));
            jTextField24.setText(Integer.toString(rs.getInt(24)));
            jTextField25.setText(Integer.toString(rs.getInt(25)));
           }
         }
           catch(Exception ep)
              {   System.out.print("系统错误，请重新运行1。");
              }
    }
  void update()
  {
      Yjcky3=jTextField1.getText();
      Yjcky3_15=jTextField2.getText();
      Yjcky15_5=jTextField3.getText();
      Yjcky5_1=jTextField4.getText();
      Yjcky1=jTextField5.getText();
      Yjljtz5=jTextField6.getText();
      Yjljtz2_5=jTextField7.getText();
      Yjljtz1_2=jTextField8.getText();
      Yjljtz1_1=jTextField9.getText();
      Yjljtz1=jTextField10.getText();
      Yhktzcs10=jTextField11.getText();
      Yhktzcs6_9=jTextField12.getText();
      Yhktzcs3_5=jTextField13.getText();
      Yhktzcs2=jTextField14.getText();
      Yhktzcs0=jTextField15.getText();
      Yjxfcs10=jTextField16.getText();
      Yjxfcs6_9=jTextField17.getText();
      Yjxfcs3_5= jTextField18.getText();
      Yjxfcs2=jTextField19.getText();
      Yjxfcs0=jTextField20.getText();
      Yjxf1=jTextField21.getText();
      Yjxf5_1= jTextField22.getText();
      Yjxf5_5=jTextField23.getText();
      Yjxf5=jTextField24.getText();
      Yjxf0=jTextField25.getText();
      try{
           query2="UPDATE  UseInstance SET Yjcky3=?, Yjcky3_15=?, Yjcky15_5=?, Yjcky5_1=?,   ";
           query2=query2+" Yjcky1=?, Yjljtz5=?,Yjljtz2_5=?,Yjljtz1_2=?, Yjljtz1_1=?, Yjljtz1=?,";
           query2=query2+" Yhktzcs10=?, Yhktzcs6_9=?, Yhktzcs3_5=?,Yhktzcs2=?, Yhktzcs0=?,";
           query2=query2+" Yjxfcs10=?, Yjxfcs6_9=?, Yjxfcs3_5=?, Yjxfcs2=?, Yjxfcs0=?, ";
           query2=query2+"Yjxf1=?, Yjxf5_1=?, Yjxf5_5=?, Yjxf5=?, Yjxf0=?";
           pstmt2 = con.prepareStatement(query2);
           pstmt2.setString(1,Yjcky3);
           pstmt2.setString(2, Yjcky3_15);
           pstmt2.setString(3,Yjcky15_5);
           pstmt2.setString(4,Yjcky5_1);
           pstmt2.setString(5, Yjcky1);
           pstmt2.setString(6,Yjljtz5);
           pstmt2.setString(7,Yjljtz2_5);
           pstmt2.setString(8,Yjljtz1_2);
           pstmt2.setString(9,Yjljtz1_1);
           pstmt2.setString(10,Yjljtz1);
           pstmt2.setString(11,Yhktzcs10);
           pstmt2.setString(12,Yhktzcs6_9);
           pstmt2.setString(13,Yhktzcs3_5);
           pstmt2.setString(14,Yhktzcs2);
           pstmt2.setString(15,Yhktzcs0);
           pstmt2.setString(16,Yjxfcs10);
           pstmt2.setString(17,Yjxfcs6_9);
           pstmt2.setString(18, Yjxfcs3_5);
           pstmt2.setString(19,Yjxfcs2);
           pstmt2.setString(20,Yjxfcs0);
           pstmt2.setString(21,Yjxf1);
           pstmt2.setString(22, Yjxf5_1);
           pstmt2.setString(23,Yjxf5_5);
           pstmt2.setString(24,Yjxf5);
           pstmt2.setString(25,Yjxf0);
           pstmt2.executeUpdate();
          JOptionPane.showMessageDialog(this,"修改成功！","update",JOptionPane.INFORMATION_MESSAGE);
         }
         catch(SQLException ep)
         {System.out.print(ep.getMessage());
         }
  }
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  TitledBorder titledBorder9;

  void jButton1_actionPerformed(ActionEvent e) {
   int respond;
    respond = JOptionPane.showConfirmDialog(this,"确实要修改吗？","sure",JOptionPane.YES_NO_CANCEL_OPTION);
    if(respond==JOptionPane.YES_OPTION) update();
    else loaddata();
  }

  void jButton2_actionPerformed(ActionEvent e) {

    loaddata();
  }

  void jButton3_actionPerformed(ActionEvent e) {
   eventFrame.jSplitPane1.remove(eventFrame.jSplitPane1.getRightComponent());
   eventFrame.jSplitPane1.add(new helloPanel(),JSplitPane.RIGHT);
 }

}

class CardUsePanel_jButton1_actionAdapter implements java.awt.event.ActionListener {
  CardUsePanel adaptee;

  CardUsePanel_jButton1_actionAdapter(CardUsePanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class CardUsePanel_jButton2_actionAdapter implements java.awt.event.ActionListener {
  CardUsePanel adaptee;

  CardUsePanel_jButton2_actionAdapter(CardUsePanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class CardUsePanel_jButton3_actionAdapter implements java.awt.event.ActionListener {
  CardUsePanel adaptee;

  CardUsePanel_jButton3_actionAdapter(CardUsePanel adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}