📄 selectsubject.java
字号:
/*
* SelectSubject.java
*
* Created on 2007年9月3日, 下午11:10
*/
package org.Adam;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Administrator
*/
public class SelectSubject extends javax.swing.JFrame {
ResultSet rs=null;
public String a=new String();
/** Creates new form SelectSubject */
public SelectSubject() {
initComponents();
this.setLocationRelativeTo(this);
this.setResizable(false);
this.jComboBox1.addItem("");
GetGrade();
}
private void GetGrade(){
String sql="select distinct 年级 from 班级信息 ";
DB dB=new DB();
rs=dB.SelectpassDb(sql);
try {
while(rs.next()){
a=rs.getString("年级");
this.jComboBox1.addItem(a);
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
/** 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();
jLabel2 = new javax.swing.JLabel();
jComboBoxClass = new javax.swing.JComboBox();
jLabel3 = new javax.swing.JLabel();
jComboBoxXueqi = new javax.swing.JComboBox();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jButtonSelect = new javax.swing.JButton();
jButtonCancle = new javax.swing.JButton();
jComboBox1 = new javax.swing.JComboBox();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("\u8bfe\u7a0b\u67e5\u8be2");
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("\u73ed\u7ea7\u8bfe\u7a0b\u67e5\u8be2"));
jLabel1.setText("\u5e74\u7ea7\uff1a");
jLabel2.setText("\u73ed\u7ea7\uff1a");
jComboBoxClass.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "\u7535\u4fe1", "\u5e94\u7535", "\u7269\u65591\u73ed", "\u7269\u65592\u73ed", "\u7269\u65593\u73ed" }));
jLabel3.setText("\u5b66\u671f\uff1a");
jComboBoxXueqi.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "\u7b2c\u4e00\u5b66\u671f", "\u7b2c\u4e8c\u5b66\u671f", "\u7b2c\u4e09\u5b66\u671f", "\u7b2c\u56db\u5b66\u671f", "\u7b2c\u4e94\u5b66\u671f", "\u7b2c\u516d\u5b66\u671f", "\u7b2c\u4e03\u5b66\u671f", "\u7b2c\u516b\u5b66\u671f" }));
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{},
{},
{},
{}
},
new String [] {
}
));
jScrollPane1.setViewportView(jTable1);
jButtonSelect.setText("\u67e5\u8be2");
jButtonSelect.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButtonSelectActionPerformed(evt);
}
});
jButtonCancle.setText("\u53d6\u6d88");
jButtonCancle.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButtonCancleActionPerformed(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(25, 25, 25)
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jLabel1)
.add(jLabel3))
.add(15, 15, 15)
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING, false)
.add(jComboBoxXueqi, 0, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(jComboBox1, 0, 113, Short.MAX_VALUE))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 21, Short.MAX_VALUE)
.add(jLabel2)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(jComboBoxClass, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 118, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(39, 39, 39))
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 407, Short.MAX_VALUE)
.add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel1Layout.createSequentialGroup()
.add(48, 48, 48)
.add(jButtonSelect, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 75, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 153, Short.MAX_VALUE)
.add(jButtonCancle, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 76, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(55, 55, 55))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jPanel1Layout.createSequentialGroup()
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jLabel1)
.add(jLabel2)
.add(jComboBox1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(jComboBoxClass, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.add(20, 20, 20)
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jLabel3)
.add(jComboBoxXueqi, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 285, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(18, 18, 18)
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jButtonCancle)
.add(jButtonSelect))
.addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.addContainerGap()
.add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, layout.createSequentialGroup()
.addContainerGap(19, Short.MAX_VALUE)
.add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void jButtonCancleActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonCancleActionPerformed
// TODO 将在此处添加您的处理代码：
this.dispose();
}//GEN-LAST:event_jButtonCancleActionPerformed
private void jButtonSelectActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButtonSelectActionPerformed
// TODO 将在此处添加您的处理代码：
Vector<Vector> data=new Vector();
Vector<String> head=new Vector();
String Grade=this.jComboBox1.getSelectedItem().toString();
//String Subject=this.jTextFieldSubject.getText();
String Class=this.jComboBoxClass.getSelectedItem().toString();
String Xueqi=this.jComboBoxXueqi.getSelectedItem().toString();
String sql="select distinct a.年级,a.班级,a.专业 , b.科目 from 班级信息 a,课程明细 b, 学期 c,班级课程 d ";
if( Grade.equals("") && Class.equals("") && Xueqi.equals("")){
sql=sql+"where a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( !Grade.equals("") && Class.equals("") && Xueqi.equals("")){
sql=sql+" where a.年级='"+Grade+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( Grade.equals("") && !Class.equals("") && Xueqi.equals("")){
sql=sql+" where a.班级='"+Class+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( Grade.equals("") && Class.equals("") && !Xueqi.equals("")){
sql=sql+" where c.学期='"+Xueqi+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( !Grade.equals("") && !Class.equals("") && Xueqi.equals("")){
sql=sql+" where a.年级='"+Grade+"' and a.班级='"+Class+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( !Grade.equals("") && Class.equals("") && !Xueqi.equals("")){
sql=sql+" where a.年级='"+Grade+"' and c.学期='"+Xueqi+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( Grade.equals("") && !Class.equals("") && !Xueqi.equals("")){
sql=sql+" where a.班级='"+Class+"' and c.学期='"+Xueqi+"' and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
if( !Grade.equals("") && !Class.equals("") && !Xueqi.equals("")){
sql=sql+" where a.年级='"+Grade+"' and c.学期='"+Xueqi+"' and a.班级='"+Class+"'and a.s_id=d.s_id and d.subject_ID=b.subject_ID and d.xueqi_ID=c.xueqi_ID ";
}
DefaultTableModel tableModel=(DefaultTableModel)this.jTable1.getModel();
DB dB=new DB();
head=dB.doClassTableHead(sql);
data=dB.doClassQuery(sql);
tableModel.setDataVector(data,head);
this.jTable1.setModel(tableModel);
((DefaultTableModel)jTable1.getModel()).fireTableStructureChanged();
// dB.closeAccessConnection();
}//GEN-LAST:event_jButtonSelectActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new SelectSubject().setVisible(true);
}
});
}
// 变量声明 - 不进行修改//GEN-BEGIN:variables
private javax.swing.JButton jButtonCancle;
private javax.swing.JButton jButtonSelect;
private javax.swing.JComboBox jComboBox1;
private javax.swing.JComboBox jComboBoxClass;
private javax.swing.JComboBox jComboBoxXueqi;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// 变量声明结束//GEN-END:variables
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -