?? 獲獎管理.java~1~
字號:
package 學生信息管理系統(tǒng);import java.awt.*;import javax.swing.*;import com.borland.dx.sql.dataset.*;import com.borland.dbswing.*;import java.awt.event.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2001</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class 獲獎管理 extends JDialog { JPanel jPanel1 = new JPanel(); JLabel jLabel1 = new JLabel(); JLabel jLabel2 = new JLabel(); JLabel jLabel3 = new JLabel(); FlowLayout flowLayout1 = new FlowLayout(); JTextField jTextField1 = new JTextField(); JTextField jTextField2 = new JTextField(); JTextField jTextField3 = new JTextField(); JPanel jPanel2 = new JPanel(); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JButton jButton3 = new JButton(); Database database1 = new Database(); QueryDataSet queryDataSet1 = new QueryDataSet(); JPanel jPanel3 = new JPanel(); TableScrollPane tableScrollPane1 = new TableScrollPane(); JdbTable jdbTable1 = new JdbTable(); FlowLayout flowLayout2 = new FlowLayout(); JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar(); private int counter=0; String operator,password,right,mode; public 獲獎管理(Frame frame, String title, boolean modal) { super(frame, title, modal); try { jbInit(); pack(); } catch(Exception ex) { ex.printStackTrace(); } } public 獲獎管理(String op,String pw,String rt,String md) { this(null, "", false); operator=op;password=pw;right=rt;mode=md; } private void jbInit() throws Exception { this.getContentPane().setLayout(null); jPanel1.setFont(new java.awt.Font("Dialog", 0, 15)); jPanel1.setBounds(new Rectangle(23, 7, 261, 158)); jPanel1.setLayout(flowLayout1); jLabel1.setFont(new java.awt.Font("Dialog", 0, 15)); jLabel1.setPreferredSize(new Dimension(80, 30)); jLabel1.setText("學 號："); jLabel2.setFont(new java.awt.Font("Dialog", 0, 15)); jLabel2.setPreferredSize(new Dimension(80, 30)); jLabel2.setText("獲 獎："); jLabel3.setFont(new java.awt.Font("Dialog", 0, 15)); jLabel3.setPreferredSize(new Dimension(80, 30)); jLabel3.setText("獲獎日期："); jTextField1.setFont(new java.awt.Font("Dialog", 0, 15)); jTextField1.setPreferredSize(new Dimension(120, 30)); jTextField1.setText(""); jTextField2.setFont(new java.awt.Font("Dialog", 0, 15)); jTextField2.setPreferredSize(new Dimension(120, 30)); jTextField2.setText(""); jTextField3.setFont(new java.awt.Font("Dialog", 0, 15)); jTextField3.setPreferredSize(new Dimension(120, 30)); jTextField3.setText(""); jButton1.setFont(new java.awt.Font("Dialog", 0, 15)); jButton1.setPreferredSize(new Dimension(120, 30)); jButton1.setText("查找"); jButton1.addActionListener(new 獲獎管理_jButton1_actionAdapter(this)); jButton2.setFont(new java.awt.Font("Dialog", 0, 15)); jButton2.setPreferredSize(new Dimension(120, 30)); jButton2.setText("增加"); jButton2.addActionListener(new 獲獎管理_jButton2_actionAdapter(this)); jButton3.setFont(new java.awt.Font("Dialog", 0, 15)); jButton3.setPreferredSize(new Dimension(120, 30)); jButton3.setText("返回"); jButton3.addActionListener(new 獲獎管理_jButton3_actionAdapter(this)); database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:odbc:學生信息管理", "sample", "", false, "sun.jdbc.odbc.JdbcOdbcDriver")); jPanel3.setLayout(flowLayout2); jdbTable1.setFont(new java.awt.Font("Dialog", 0, 15)); tableScrollPane1.setFont(new java.awt.Font("Dialog", 0, 15)); tableScrollPane1.setPreferredSize(new Dimension(450, 200)); jPanel3.setBounds(new Rectangle(39, 191, 460, 205)); jPanel2.setBounds(new Rectangle(303, 7, 197, 100)); jdbNavToolBar1.setBounds(new Rectangle(71, 164, 452, 28)); jPanel1.add(jLabel1, null); jPanel1.add(jTextField1, null); jPanel1.add(jLabel2, null); jPanel1.add(jTextField2, null); jPanel1.add(jLabel3, null); jPanel1.add(jTextField3, null); jPanel1.add(jButton1, null); this.getContentPane().add(jPanel2, null); this.getContentPane().add(jPanel3, null); jPanel3.add(tableScrollPane1, null); this.getContentPane().add(jPanel1, null); this.getContentPane().add(jdbNavToolBar1, null); jPanel2.add(jButton2, null); jPanel2.add(jButton3, null); }//查找記錄 void jButton1_actionPerformed(ActionEvent e) { String sql = ""; sql= "select * from 獲獎";String str1=jTextField1.getText(),str2=jTextField2.getText(),str3=jTextField3.getText(); //判斷查詢條件 if(str1.length()!=0||str2.length()!=0||str3.length()!=0) {sql+=" where ";} if(str1.length()!=0) {sql+="學號="+"'"+str1+"'"; if(str2.length()!=0||str3.length()!=0) sql+=" AND "; } if(str2.length()!=0){sql+="獲獎=" +"'"+str2+"'"; if(str3.length()!=0)sql+=" AND "; } if(str3.length()!=0){sql+="獲獎日期="+"'"+str3+"'";}try{if(counter==0){ queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL)); counter++;} else {queryDataSet1.close(); queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL)); } jdbTable1.setDataSet(queryDataSet1); tableScrollPane1.getViewport().add(jdbTable1, null); }catch(Exception ex){System.out.print("error"); } } //增加記錄 void jButton2_actionPerformed(ActionEvent e) { String sql = ""; sql= "INSERT INTO 獲獎(學號,獲獎,獲獎日期) VALUES ";String str1=jTextField1.getText(),str2=jTextField2.getText(),str3=jTextField3.getText(); //判斷查詢條件 sql+="("+"'"+str1+"'"+","; sql+="'"+str2+"'"+","; sql+="'"+str3+"'"; sql+=")"; if(str1.length()==0)JOptionPane.showMessageDialog(this,"學號不能為空！","警告",JOptionPane.INFORMATION_MESSAGE); while(str1.length()!=0){ if(counter==0){queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL)); counter++;} else {queryDataSet1.close(); queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, sql, null, true, Load.ALL)); } try{queryDataSet1.executeQuery();}catch(Exception ex){ JOptionPane.showMessageDialog(this,"已增加數(shù)據(jù)記錄！","增加記錄",JOptionPane.INFORMATION_MESSAGE); } } jTextField1.setText(""); jTextField2.setText(""); jTextField3.setText(""); } void cancel() { dispose(); } void jButton3_actionPerformed(ActionEvent e) { if (e.getSource() == jButton3) { cancel(); } }}class 獲獎管理_jButton1_actionAdapter implements java.awt.event.ActionListener { 獲獎管理 adaptee; 獲獎管理_jButton1_actionAdapter(獲獎管理 adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton1_actionPerformed(e); }}class 獲獎管理_jButton2_actionAdapter implements java.awt.event.ActionListener { 獲獎管理 adaptee; 獲獎管理_jButton2_actionAdapter(獲獎管理 adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton2_actionPerformed(e); }}class 獲獎管理_jButton3_actionAdapter implements java.awt.event.ActionListener { 獲獎管理 adaptee; 獲獎管理_jButton3_actionAdapter(獲獎管理 adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton3_actionPerformed(e); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -