dvdmanage.java~181~

管理dvd碟片的软件

package dvd;

import javax.swing.*;
import java.awt.*;
import com.borland.jbcl.layout.*;
import java.awt.event.*;
import java.sql.*;

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

public class DVDManage extends JFrame {
  private Connection connection;
  private   String url = "jdbc:odbc:sql";

  XYLayout xYLayout1 = new XYLayout();
  JButton jButton1 = new JButton();
  JLabel jLabel1 = new JLabel();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JLabel jLabel8 = new JLabel();
  JTextField jtx1 = new JTextField();
  JTextField jtx2 = new JTextField();
  JTextField jtx3 = new JTextField();
  JTextField jtx4 = new JTextField();
  JTextField jtx5 = new JTextField();
  JTextField jtx6 = new JTextField();
  JTextField jtx7 = new JTextField();
  JLabel jLabel9 = new JLabel();
  JTextField jtx8 = new JTextField();
  JLabel jLabel10 = new JLabel();
  JTextField jtx9 = new JTextField();
  JLabel jLabel11 = new JLabel();
  JTextField jtx10 = new JTextField();




  private  String  dvdid=  jtx1.getText().trim();
  private  String  directorid= jtx2.getText().trim();
  private  String  level= jtx3.getText().trim();
  private  String  mdate= jtx4.getText().trim();
  private  String  DVDcn =jtx5.getText().trim();
  private  String  DVDen = jtx6.getText().trim();
  private  String  pprice= jtx7.getText().trim();
  private  String  sprice= jtx8.getText().trim();
  private  String  type= jtx9.getText().trim();
  private  String  number= jtx10.getText().trim();
  JLabel jLabel12 = new JLabel();
  JLabel jLabel13 = new JLabel();
  JLabel jLabel14 = new JLabel();
  JLabel jLabel15 = new JLabel();
  JLabel jLabel17 = new JLabel();
  JLabel jLabel18 = new JLabel();
  JLabel jLabel19 = new JLabel();
  JPanel jPanel1 = new JPanel();
  XYLayout xYLayout2 = new XYLayout();
  JLabel jLabel16 = new JLabel();
  JLabel jLabel20 = new JLabel();
  JLabel jLabel21 = new JLabel();
  JLabel jLabel22 = new JLabel();
  JLabel jLabel23 = new JLabel();
  JLabel jLabel24 = new JLabel();
  JLabel jLabel25 = new JLabel();



  public DVDManage() {
    try {
       Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );

       connection = DriverManager.getConnection(
          url );
    }
    catch ( ClassNotFoundException cnfex ) {
       System.err.println(
          "Failed to load JDBC/ODBC driver." );
       cnfex.printStackTrace();
       System.exit( 1 );  // terminate program
    }
    catch ( SQLException sqlex ) {
       System.err.println( "Unable to connect" );
       sqlex.printStackTrace();
    }

  try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  private void jbInit() throws Exception {
    jButton1.setFont(new java.awt.Font("Dialog", 0, 18));
    jButton1.setForeground(Color.magenta);
    jButton1.setText("增加新的DVD");
    jButton1.addActionListener(new DVDManage_jButton1_actionAdapter(this));
    this.getContentPane().setLayout(xYLayout1);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 25));
    jLabel1.setForeground(Color.magenta);
    jLabel1.setText("DVD管理");
    jButton2.setFont(new java.awt.Font("Dialog", 0, 18));
    jButton2.setForeground(Color.magenta);
    jButton2.setToolTipText("输入影片ID号对于修改的属性给于修改");
    jButton2.setText("更新DVD信息");
    jButton2.addActionListener(new DVDManage_jButton2_actionAdapter(this));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 18));
    jButton3.setForeground(Color.magenta);
    jButton3.setToolTipText("输入影片ID号进行删除");
    jButton3.setSelected(false);
    jButton3.setText("删除DVD");
    jButton3.addActionListener(new DVDManage_jButton3_actionAdapter(this));

    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setForeground(Color.blue);
    jLabel2.setMaximumSize(new Dimension(34, 16));
    jLabel2.setText("dvdID");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel3.setForeground(Color.blue);
    jLabel3.setText("导演ID");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel4.setForeground(Color.blue);
    jLabel4.setText("推荐等级");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel5.setForeground(Color.blue);
    jLabel5.setText("制作年份");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel6.setForeground(Color.blue);
    jLabel6.setText("影片中文名");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel7.setForeground(Color.blue);
    jLabel7.setToolTipText("");
    jLabel7.setText("影片英文名");
    jLabel8.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel8.setForeground(Color.blue);
    jLabel8.setText("进价");
    jtx2.setToolTipText("");
    jtx2.setText(" ");
    jtx3.setToolTipText("输入的值应在1到5之间");
    jtx3.setText(" ");
    jtx4.setText(" ");
    jtx5.setText(" ");
    xYLayout1.setWidth(494);
    xYLayout1.setHeight(478);
    jtx6.setText(" ");
    jLabel9.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel9.setForeground(Color.blue);
    jLabel9.setText("售价");
    jLabel10.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel10.setForeground(Color.blue);
    jLabel10.setText("影片类型");
    jtx9.setText(" ");
    jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel11.setForeground(Color.blue);
    jLabel11.setText("存货数量");
    jtx10.setText(" ");
    jtx1.setForeground(Color.orange);
    jtx1.setDisabledTextColor(Color.black);
    jtx1.setText("");
    jtx1.addActionListener(new DVDManage_jtx1_actionAdapter(this));
    jtx7.setToolTipText("进价应低于售价");
    jtx7.setText("");
    jtx8.setToolTipText("售价应高于进价");
    jtx8.setText("");
    jLabel12.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel12.setForeground(Color.red);
    jLabel12.setText("*");
    jLabel13.setText("*");
    jLabel13.setForeground(Color.red);
    jLabel13.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel14.setText("*");
    jLabel14.setForeground(Color.red);
    jLabel14.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel15.setText("*");
    jLabel15.setForeground(Color.red);
    jLabel15.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel17.setText("*");
    jLabel17.setForeground(Color.red);
    jLabel17.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel18.setText("*");
    jLabel18.setForeground(Color.red);
    jLabel18.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel19.setText("*");
    jLabel19.setForeground(Color.red);
    jLabel19.setFont(new java.awt.Font("Dialog", 0, 20));
    jLabel16.setForeground(Color.blue);
    jPanel1.setLayout(xYLayout2);
    jPanel1.setBackground(Color.white);
    jLabel16.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel16.setForeground(SystemColor.desktop);
    jLabel16.setText("操作说明:");
    jLabel20.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel20.setForeground(SystemColor.desktop);
    jLabel20.setText("1.增加新的DVD时，*为必添项。");
    jLabel21.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel21.setForeground(SystemColor.desktop);
    jLabel21.setText("2.更新DVD信息时,dvdId为必录入 ");
    jLabel22.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel22.setForeground(SystemColor.desktop);
    jLabel22.setText("信息，可同时修改多项信息。");
    jLabel23.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel23.setForeground(SystemColor.desktop);
    jLabel23.setText("3.删除DVD时，为防止dvdID输入错 ");
    jLabel24.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel24.setForeground(SystemColor.desktop);
    jLabel24.setText("误，导致信息错误的删除，请同时 ");
    jLabel25.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel25.setForeground(SystemColor.desktop);
    jLabel25.setText("输入dvdID和影片 中文名。");
    this.getContentPane().setBackground(Color.lightGray);
    this.getContentPane().add(jButton1,  new XYConstraints(23, 80, 144, 38));
    this.getContentPane().add(jButton3,   new XYConstraints(22, 182, 145, 36));
    this.getContentPane().add(jButton2,  new XYConstraints(23, 131, 144, 36));
    this.getContentPane().add(jLabel3,      new XYConstraints(249, 103, 67, 24));
    this.getContentPane().add(jLabel4,      new XYConstraints(249, 143, 61, 23));
    this.getContentPane().add(jLabel5,     new XYConstraints(249, 183, 64, 24));
    this.getContentPane().add(jLabel6,        new XYConstraints(249, 223, 77, 25));
    this.getContentPane().add(jLabel7,       new XYConstraints(249, 263, 78, 23));
    this.getContentPane().add(jLabel8,    new XYConstraints(249, 303, 44, 24));
    this.getContentPane().add(jLabel9,      new XYConstraints(249, 343, 49, 27));
    this.getContentPane().add(jLabel10,      new XYConstraints(249, 383, 73, 24));
    this.getContentPane().add(jtx2,    new XYConstraints(324, 103, 126, 29));
    this.getContentPane().add(jtx3,      new XYConstraints(324, 143, 126, 29));
    this.getContentPane().add(jtx5,     new XYConstraints(324, 223, 126, 29));
    this.getContentPane().add(jtx10,     new XYConstraints(324, 423, 126, 29));
    this.getContentPane().add(jtx4,    new XYConstraints(324, 183, 126, 29));
    this.getContentPane().add(jtx8,    new XYConstraints(324, 343, 126, 29));
    this.getContentPane().add(jtx9,    new XYConstraints(324, 383, 126, 29));
    this.getContentPane().add(jLabel11,    new XYConstraints(249, 424, 68, 21));
    this.getContentPane().add(jtx1,   new XYConstraints(324, 63, 126, 29));
    this.getContentPane().add(jtx7,   new XYConstraints(324, 299, 126, 29));
    this.getContentPane().add(jLabel2,   new XYConstraints(249, 63, 47, 25));
    this.getContentPane().add(jtx6,     new XYConstraints(324, 263, 126, 29));
    this.getContentPane().add(jLabel12,         new XYConstraints(453, 63, 29, -1));
    this.getContentPane().add(jLabel13,         new XYConstraints(453, 343, 29, -1));
    this.getContentPane().add(jLabel14,     new XYConstraints(453, 143, 29, -1));
    this.getContentPane().add(jLabel15,     new XYConstraints(453, 223, 29, -1));
    this.getContentPane().add(jLabel17,       new XYConstraints(453, 383, 29, -1));
    this.getContentPane().add(jLabel18,      new XYConstraints(453, 303, 29, -1));
    this.getContentPane().add(jLabel19,       new XYConstraints(453, 424, 29, -1));
    this.getContentPane().add(jPanel1,                                 new XYConstraints(3, 264, 238, 186));
    jPanel1.add(jLabel16,    new XYConstraints(5, 1, 78, 29));
    jPanel1.add(jLabel20,             new XYConstraints(5, 27, 219, 31));
    jPanel1.add(jLabel21,         new XYConstraints(5, 57, 236, 29));
    jPanel1.add(jLabel22,       new XYConstraints(5, 77, 215, 29));
    jPanel1.add(jLabel24,        new XYConstraints(5, 127, 239, 39));
    jPanel1.add(jLabel23,     new XYConstraints(5, 107, 240, 36));
    jPanel1.add(jLabel25,     new XYConstraints(5, 147, 234, 34));
    this.getContentPane().add(jLabel1, new XYConstraints(174, 15, 108, 43));
  }

  void jtx1_actionPerformed(ActionEvent e) {

  }

  void jButton1_actionPerformed(ActionEvent e) {

    try {

         Statement statement = connection.createStatement();
         String  dvdid=  jtx1.getText().trim();
         String  directorid= jtx2.getText().trim();
         String  level= jtx3.getText().trim();
         String  mdate= jtx4.getText().trim();
         String  DVDcn =jtx5.getText().trim();
         String  DVDen = jtx6.getText().trim();
         String  pprice= jtx7.getText().trim();
         String  sprice= jtx8.getText().trim();
         String  type= jtx9.getText().trim();
         String  number= jtx10.getText().trim();

      if(!(dvdid.equals("")||level.equals("")||type.equals("")||DVDcn.equals("")||pprice.equals("")||sprice.equals("")||number.equals("")))
          {
            String s1= "insert into DVD (" +
          "DVD_no,r_level," +
          "DVD_cn,p_price,s_price," +
          "type,remains";