📄 lookstu.java
字号:
/*
* LookStu.java
*
* Created on 2007年8月29日, 下午6:56
*/
package org.Adam;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.util.Vector;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JRadioButton;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Administrator
*/
public class LookStu extends javax.swing.JFrame {
UpdateStu updatestu=new UpdateStu();
/** Creates new form LookStu */
public LookStu() {
initComponents();
this.setLocationRelativeTo(this);
this.setResizable(false);
}
/** 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();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jPanel2 = new javax.swing.JPanel();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("\u6d4f\u89c8\u5b66\u5458\u4fe1\u606f");
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("\u6d4f\u89c8\u5b66\u5458\u4fe1\u606f"));
jButton1.setText("\u6d4f\u89c8\u6240\u6709\u5b66\u5458\u4fe1\u606f");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
jButton2.setText("\u4fee\u6539\u76f8\u5e94\u5b66\u5458\u4fe1\u606f");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
org.jdesktop.layout.GroupLayout jPanel2Layout = new org.jdesktop.layout.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(0, 822, Short.MAX_VALUE)
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(0, 0, Short.MAX_VALUE)
);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{},
{},
{},
{}
},
new String [] {
}
));
jScrollPane1.setViewportView(jTable1);
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(169, 169, 169)
.add(jButton1)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED, 213, Short.MAX_VALUE)
.add(jButton2)
.add(182, 182, 182))
.add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 822, Short.MAX_VALUE)
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jButton1)
.add(jButton2))
.add(22, 22, 22)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 415, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(15, 15, 15)
.add(jPanel2, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 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(layout.createSequentialGroup()
.addContainerGap()
.add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 508, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addContainerGap(org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}// </editor-fold>//GEN-END:initComponents
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
// TODO 将在此处添加您的处理代码:
updatestu.setDefaultCloseOperation(JFrame.DO_NOTHING_ON_CLOSE);
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(3))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),3).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(4))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),0).toString());
// ((JRadioButton)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(5))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),2).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(11))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),5).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(10))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),4).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(12))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),1).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(14))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),6).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(16))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),7).toString());
((JTextField)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(18))).setText(jTable1.getValueAt(jTable1.getSelectedRow(),8).toString());
// ((JRadioButton)(((java.awt.Container)(updatestu.getContentPane().getComponent(1))).getComponent(5))).setSelected(jTable1.getValueAt(jTable1.getSelectedRow(),2).toString());
updatestu.setVisible(true);
updatestu.setResizable(false);
updatestu.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
updatestu.dispose();
}
});
}//GEN-LAST:event_jButton2ActionPerformed
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
// TODO 将在此处添加您的处理代码:
Vector<Vector> data=new Vector();
Vector<String> head=new Vector();
String sql="select 学号,姓名,性别,年级,班级,籍贯,邮政编码,出生年月,联系电话,备注 from 学生档案 order by 学号 ";
DefaultTableModel tableModel=(DefaultTableModel)this.jTable1.getModel();
DB dB=new DB();
/* headGrade=dB.doClassQuery(sql1);
this.jComboBoxGrade.addItem(headGrade);*/
// String Grade=this.jComboBoxGrade.getSelectedItem().toString();
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_jButton1ActionPerformed
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new LookStu().setVisible(true);
}
});
}
// 变量声明 - 不进行修改//GEN-BEGIN:variables
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
// 变量声明结束//GEN-END:variables
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -