kechjframe.java

java开发的数据库

/*
 * KeChJFrame.java
 *
 * Created on 2006年5月28日, 上午9:25
 */

package stucontrol;

import java.util.Vector;
import javax.swing.JList;
import javax.swing.JOptionPane;
import java.sql.*;
/**
 *
 * @author  jjk
 */
public class KeChJFrame extends javax.swing.JFrame {
    
    /** Creates new form KeChJFrame */
    public KeChJFrame() {
        initComponents();
        listJ=new Vector();
    
     
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jPanel1 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jTextField1 = new javax.swing.JTextField();
        jLabel2 = new javax.swing.JLabel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jList1 = new javax.swing.JList();
        jLabel3 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jButton2 = new javax.swing.JButton();
        jButton3 = new javax.swing.JButton();
        list1 = new java.awt.List();

        jPanel1.setPreferredSize(new java.awt.Dimension(100, 100));
        jLabel1.setText("\u5e74\u7ea7:");

        jLabel2.setText("\u6240\u6709\u8bfe\u7a0b:");

        jList1.setModel(new javax.swing.AbstractListModel() {
            String[] strings = { "\u8bed\u6587", "\u6570\u5b66", "\u82f1\u8bed" };
            public int getSize() { return strings.length; }
            public Object getElementAt(int i) { return strings[i]; }
        });
        jScrollPane1.setViewportView(jList1);

        jLabel3.setText("\u5df2\u9009\u8bfe\u7a0b:");

        jButton1.setText("\u9009\u62e9");
        jButton1.addItemListener(new java.awt.event.ItemListener() {
            public void itemStateChanged(java.awt.event.ItemEvent evt) {
                jButton1ItemStateChanged(evt);
            }
        });
        jButton1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton1ActionPerformed(evt);
            }
        });

        jButton2.setText("\u53d6\u6d88");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        jButton3.setText("\u786e\u5b9a");
        jButton3.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton3ActionPerformed(evt);
            }
        });

        org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING)
                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel1Layout.createSequentialGroup()
                        .add(44, 44, 44)
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
                            .add(jPanel1Layout.createSequentialGroup()
                                .add(jLabel2)
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .add(jLabel3))
                            .add(jPanel1Layout.createSequentialGroup()
                                .add(jLabel1)
                                .add(59, 59, 59)
                                .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 136, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))))
                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel1Layout.createSequentialGroup()
                        .add(81, 81, 81)
                        .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 41, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                        .add(28, 28, 28)
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jButton1)
                            .add(jButton2)
                            .add(jButton3))))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .add(list1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 31, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
                .add(228, 228, 228))
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
            .add(jPanel1Layout.createSequentialGroup()
                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.TRAILING, false)
                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel1Layout.createSequentialGroup()
                        .add(90, 90, 90)
                        .add(list1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                    .add(org.jdesktop.layout.GroupLayout.LEADING, jPanel1Layout.createSequentialGroup()
                        .add(19, 19, 19)
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                            .add(jLabel1)
                            .add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
                        .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
                            .add(jPanel1Layout.createSequentialGroup()
                                .add(57, 57, 57)
                                .add(jButton1)
                                .add(38, 38, 38)
                                .add(jButton2))
                            .add(jPanel1Layout.createSequentialGroup()
                                .add(25, 25, 25)
                                .add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
                                    .add(jLabel2)
                                    .add(jLabel3))
                                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
                                .add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)))))
                .addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .add(jButton3)
                .add(39, 39, 39))
        );
        getContentPane().add(jPanel1, java.awt.BorderLayout.CENTER);

        pack();
    }// </editor-fold>//GEN-END:initComponents

    private void jButton1ItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_jButton1ItemStateChanged
// TODO 将在此处添加您的处理代码：
    }//GEN-LAST:event_jButton1ItemStateChanged

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码：
        String aa= list1.getSelectedItem();
        
        System.out.println("del  aa="+aa);
        list1.remove(aa);
        listJ.remove(aa);
    }//GEN-LAST:event_jButton2ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码：
        Object aa=jList1.getSelectedValue();
        System.out.println("aa="+aa);
        for(int i=0;i<listJ.size();i++)
            System.out.println("=="+listJ.elementAt(i));
        if(!listJ.contains(aa)){
            listJ.add(aa);
         list1.add((String)aa);
   
        }
    }//GEN-LAST:event_jButton1ActionPerformed

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton3ActionPerformed
// TODO 将在此处添加您的处理代码：
        init();
        doAction();
        list1.removeAll();
        listJ=new Vector();
    }//GEN-LAST:event_jButton3ActionPerformed
    
    public void doAction(){
        if(!searchGreed()) return;
     String list1 = null,list2 = null,list3 = null;
     if(listJ.size()==0)
          JOptionPane.showMessageDialog( this, "请选择课程！！" );
     else if(listJ.size()==1){
     list1=(String)listJ.elementAt(0);
     list2=list3="";
     }
     else if(listJ.size()==2){
          list1=(String)listJ.elementAt(0);
     list2=(String)listJ.elementAt(1);
     list3="";
     }
     else{
     list1=(String)listJ.elementAt(0);
     list2=(String)listJ.elementAt(1);
      list3=(String)listJ.elementAt(2);
     }
         String query="insert into kech values('"+jTextField1.getText()+"','"+list1+"','"
                  +list2+"','"+list3+"')";
       System.out.println("query="+query);
      try { 
     statement = connection.createStatement(); 
     resultSet = statement.executeQuery(query); 

     } 
                catch ( SQLException sqlex ) { 
                }
     JOptionPane.showMessageDialog( this, "成功！" );
     }
      public void init(){
    String url = "jdbc:odbc:stu"; 
String username = ""; 
String password = ""; 
//加载驱动程序以连接数据库 

try { 
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
connection = DriverManager.getConnection( 
url, username, password ); 
} 

//捕获加载驱动程序异常 
catch ( ClassNotFoundException cnfex ) { 
System.err.println( 
"装载 JDBC/ODBC 驱动程序失败。" ); 
cnfex.printStackTrace(); 
System.exit( 1 ); // terminate program 
} 

//捕获连接数据库异常 
catch ( SQLException sqlex ) { 
System.err.println( "无法连接数据库" ); 
sqlex.printStackTrace(); 
System.exit( 1 ); // terminate program 
} 
    
    }     
   
   public boolean searchGreed(){
      String query="select * from kech where 年级='"+jTextField1.getText()+"'";
            try { 
     statement = connection.createStatement(); 
     resultSet = statement.executeQuery(query); 
       if(resultSet.next()){
        JOptionPane.showMessageDialog( this, "该年级已选过课！！" );
        return false;
       }
           
     } 
       catch ( SQLException sqlex ) { 
      }
      return true;
      }

    /**
     * @param args the command line arguments
     */
   /*
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
             KeChJFrame pp=   new KeChJFrame();
             pp.setVisible(true);
             pp.setSize(360,320);
             pp.validate();
            }
        });
    }
    */
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JButton jButton1;
    private javax.swing.JButton jButton2;
    private javax.swing.JButton jButton3;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JList jList1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField jTextField1;
    private java.awt.List list1;
    // 变量声明结束//GEN-END:variables
    private  Vector listJ;
    private Connection connection;
    private Statement statement; 
    private ResultSet resultSet; 

  
}