dvdmanage.java

管理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.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx2.setForeground(Color.orange);
     jtx2.setToolTipText("");
     jtx2.setText(" ");
     jtx3.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx3.setForeground(Color.orange);
     jtx3.setToolTipText("输入的值应在1到5之间");
     jtx3.setText(" ");
     jtx4.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx4.setForeground(Color.orange);
     jtx4.setText(" ");
     jtx5.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx5.setForeground(Color.orange);
     jtx5.setText(" ");
     xYLayout1.setWidth(494);
     xYLayout1.setHeight(478);
     jtx6.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx6.setForeground(Color.orange);
     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.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx9.setForeground(Color.orange);
     jtx9.setText(" ");
     jLabel11.setFont(new java.awt.Font("Dialog", 0, 15));
     jLabel11.setForeground(Color.blue);
     jLabel11.setText("存货数量");
     jtx10.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx10.setForeground(Color.orange);
     jtx10.setText(" ");
     jtx1.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx1.setForeground(Color.orange);
    jtx1.setToolTipText("输入的形式为****-***-**");
     jtx1.setDisabledTextColor(Color.black);
     jtx1.setText("");
     jtx1.addActionListener(new DVDManage_jtx1_actionAdapter(this));
     jtx7.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx7.setForeground(Color.orange);
     jtx7.setToolTipText("进价应低于售价");
     jtx7.setText("");
     jtx8.setFont(new java.awt.Font("Dialog", 0, 15));
     jtx8.setForeground(Color.orange);
     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(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));
    this.getContentPane().add(jLabel2, new XYConstraints(248, 63, 47, 25));
   }

   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();