📄 classuniversquerydialog.java
字号:
package com.hb.stumanagesys.universquery;
import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import javax.swing.BorderFactory;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTabbedPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.border.BevelBorder;
import javax.swing.border.LineBorder;
import javax.swing.border.SoftBevelBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;
import com.hb.jdbcconnct.JdbcConnct;
/**
* This code was edited or generated using CloudGarden's Jigloo
* SWT/Swing GUI Builder, which is free for non-commercial
* use. If Jigloo is being used commercially (ie, by a corporation,
* company or business for any purpose whatever) then you
* should purchase a license for each developer using Jigloo.
* Please visit www.cloudgarden.com for details.
* Use of Jigloo implies acceptance of these licensing terms.
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE.
*/
public class ClassUniversQueryDialog extends javax.swing.JDialog {
private JPanel classQueryPanel;//定义班级查询面板
private JTable classinfoTable1;//定义班级信息表格
private JScrollPane classBaseinfoScrollPane1;//定义班级表滚动面板
private JButton quitButton; //定义退出按钮
private JCheckBox misCheckBox;//定义模糊查询复选框
private JTable classTable;//定义班级表格
private JComboBox classComboBox;//定义班级查询条件下拉框
private JLabel anLabel1; //定义按label
private JTextField stuNumberTextField;//定义学生数目显示文本框
private JLabel stuNumberLabel; //定义学生数目Label
private JTextField yearTermTextField; //定义班级届别文本框
private JLabel yearTermLabel; //定义班级届别Label
private JTextField teacherNameTextField; //定义老师文本框
private JLabel teacherNameLabel; //定义老师名Label
private JTextField classNameTextField;//定义班级名文本框
private JLabel classNameLabel;//定义班级名Label
private JLabel classIdLabel; //定义班级号Label
private JTextField classIdTextField; //定义班级号文本框
private JButton QueryButton; //定义查看详情按钮
private JPanel classUnierinfo;//定义班级面板
private JTabbedPane classBaseInfo;//定义班级基本信息JTabbePane
private JButton exsitButton; //定义退出按钮
private JScrollPane classScrollPane;//定义带滚动条的面板
private JButton querButton; //定义查询按钮
private JTextField classidTextField;//定义查询条件输入文本框
DefaultTableModel classinfoTable1Model;//定义DefaultTableModel
DefaultTableModel classTableModel;//定义DefaultTableModel
/**
* Auto-generated main method to display this JDialog
*
*/
public static void main(String[] args) {
JFrame frame = new JFrame();
ClassUniversQueryDialog inst = new ClassUniversQueryDialog(frame);
inst.setVisible(true);
inst.setLocationRelativeTo(null);
inst.setResizable(false);
}
/**
* 构造方法
* @param frame
*/
public ClassUniversQueryDialog(JFrame frame) {
super(frame);
initGUI();//界面实现方法
}
private void initGUI() {
try {
{
this.setTitle("\u73ed\u7ea7\u7efc\u5408\u67e5\u8be2");
getContentPane().setLayout(null);
getContentPane().setBackground(new java.awt.Color(185,185,255));
}
{
classBaseInfo = new JTabbedPane();
getContentPane().add(classBaseInfo);
classBaseInfo.setBounds(21, 0, 546, 434);
{
classQueryPanel = new JPanel();
classBaseInfo.addTab("班级信息", null, classQueryPanel, null);
classQueryPanel.setLayout(null);
classQueryPanel.setPreferredSize(new java.awt.Dimension(588, 427));
{
classidTextField = new JTextField();
classidTextField.setEditable(false);
classQueryPanel.add(classidTextField);
classidTextField.setBounds(196, 28, 98, 28);
}
{
querButton = new JButton();
classQueryPanel.add(querButton);
querButton.setText("\u67e5\u8be2");
querButton.setBounds(413, 28, 63, 28);
querButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
querButtonActionPerformed(evt);
}
});
}
{
exsitButton = new JButton();
classQueryPanel.add(exsitButton);
exsitButton.setText("\u9000\u51fa");
exsitButton.setBounds(399, 371, 77, 28);
exsitButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
exsitButtonActionPerformed(evt);
}
});
}
{
QueryButton = new JButton();
classQueryPanel.add(QueryButton);
QueryButton.setText("\u67e5\u770b\u8be6\u60c5");
QueryButton.setBounds(287, 371, 91, 28);
QueryButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
QueryButtonActionPerformed(evt);
}
});
}
{
classBaseinfoScrollPane1 = new JScrollPane();
classQueryPanel.add(classBaseinfoScrollPane1);
classBaseinfoScrollPane1.setBounds(21, 77, 504, 287);
{
classinfoTable1Model = new DefaultTableModel(
new String[][] { },
new String[] { "班级号", "班级名","届别","导师号","导师名","学生人数" });
classinfoTable1 = new JTable();
classBaseinfoScrollPane1
.setViewportView(classinfoTable1);
classinfoTable1.setModel(classinfoTable1Model);
}
}
{
anLabel1 = new JLabel();
classQueryPanel.add(anLabel1);
anLabel1.setText("\u6309\uff1a");
anLabel1.setBounds(21, 28, 63, 28);
}
{
ComboBoxModel classComboBoxModel = new DefaultComboBoxModel(
new String[] { "全部","班级号", "班级名","导师名","届别" });
classComboBox = new JComboBox();
classQueryPanel.add(classComboBox);
classComboBox.setModel(classComboBoxModel);
classComboBox.setBounds(84, 28, 98, 28);
classComboBox.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
classComboBoxActionPerformed(evt);
}
});
}
{
misCheckBox = new JCheckBox();
classQueryPanel.add(misCheckBox);
misCheckBox.setText("\u6a21\u7cca\u67e5\u8be2");
misCheckBox.setBounds(308, 28, 77, 28);
misCheckBox.setBackground(new java.awt.Color(212,208,200));
misCheckBox.setEnabled(false);
}
}
{
classUnierinfo = new JPanel();
classBaseInfo.addTab("班级详情", null, classUnierinfo, null);
classUnierinfo.setLayout(null);
classUnierinfo.setPreferredSize(new java.awt.Dimension(497, 322));
classUnierinfo.setBorder(BorderFactory.createEmptyBorder(0, 0, 0, 0));
{
classScrollPane = new JScrollPane();
classUnierinfo.add(classScrollPane);
classScrollPane.setBounds(21, 98, 504, 266);
{
classTableModel = new DefaultTableModel(
new String[][] { },
new String[] { "学号", "姓名", "性别", "年龄", "出生日期",
"政治面貌", "联系方式", "籍贯", "入学时间", "状态" });
classTable = new JTable();
classScrollPane.setViewportView(classTable);
classTable.setModel(classTableModel);
}
}
{
quitButton = new JButton();
classUnierinfo.add(quitButton);
quitButton.setText("\u9000\u51fa");
quitButton.setBounds(378, 371, 91, 28);
quitButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent evt) {
quitButtonActionPerformed(evt);
}
});
}
{
classIdTextField = new JTextField();
classUnierinfo.add(classIdTextField);
classIdTextField.setEditable(false);
classIdTextField.setBounds(84, 21, 91, 28);
classIdTextField.setBorder(BorderFactory
.createCompoundBorder(null, null));
}
{
classIdLabel = new JLabel();
classUnierinfo.add(classIdLabel);
classIdLabel.setText("\u73ed\u7ea7\u53f7\uff1a");
classIdLabel.setBounds(21, 21, 63, 28);
}
{
classNameLabel = new JLabel();
classUnierinfo.add(classNameLabel);
classNameLabel.setText("\u73ed\u7ea7\u540d\uff1a");
classNameLabel.setBounds(217, 21, 63, 28);
}
{
classNameTextField = new JTextField();
classUnierinfo.add(classNameTextField);
classNameTextField.setBounds(280, 21, 119, 28);
classNameTextField.setBorder(BorderFactory
.createCompoundBorder(null, null));
classNameTextField.setEditable(false);
}
{
teacherNameLabel = new JLabel();
classUnierinfo.add(teacherNameLabel);
teacherNameLabel.setText("\u5bfc\u5e08\u540d\uff1a");
teacherNameLabel.setBounds(21, 56, 63, 28);
}
{
teacherNameTextField = new JTextField();
classUnierinfo.add(teacherNameTextField);
teacherNameTextField.setBounds(84, 56, 91, 28);
teacherNameTextField.setBorder(BorderFactory
.createCompoundBorder(null, null));
teacherNameTextField.setEditable(false);
}
{
yearTermLabel = new JLabel();
classUnierinfo.add(yearTermLabel);
yearTermLabel.setText("\u5c4a\u522b\uff1a");
yearTermLabel.setBounds(217, 56, 49, 28);
}
{
yearTermTextField = new JTextField();
classUnierinfo.add(yearTermTextField);
yearTermTextField.setBounds(280, 56, 119, 28);
yearTermTextField.setBorder(BorderFactory
.createCompoundBorder(null, null));
yearTermTextField.setEditable(false);
}
{
stuNumberLabel = new JLabel();
classUnierinfo.add(stuNumberLabel);
stuNumberLabel.setText("\u5b66\u751f\u4eba\u6570\uff1a");
stuNumberLabel.setBounds(413, 21, 77, 28);
}
{
stuNumberTextField = new JTextField();
classUnierinfo.add(stuNumberTextField);
stuNumberTextField.setBounds(476, 21, 63, 28);
stuNumberTextField.setBorder(BorderFactory
.createCompoundBorder(null, null));
stuNumberTextField.setEditable(false);
}
}
}
this.setSize(600, 475);
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 查询班级信息，并在表格中显示的方法
* @param sql1
*/
public void initialClassTable(String sql1)
{
//定义向量，用来存储从数据库中查询出来的信息
Vector vecData = new Vector();
try
{
//定义并获取连接
Connection conn = JdbcConnct.fetchConnection();
//定义并创建statement
Statement stmt = conn.createStatement();
//查询的SQL语句
String sql = "select classid,classname,flagyear,teacherid,teachername," +
"stunum from class_teacher";
//
String sql2 = sql + sql1;
//定义并获取查询的结果集
ResultSet rs = stmt.executeQuery(sql2);
//对结果集进行操作
while(rs.next()){
//把查询出来的数据插入到向量中
vecData.addElement((String)rs.getString("classid"));
vecData.addElement((String)rs.getString("classname"));
vecData.addElement((String)rs.getString("flagyear"));
vecData.addElement((String)rs.getString("teacherid"));
vecData.addElement((String)rs.getString("teachername"));
vecData.addElement((String)rs.getString("stunum"));
}
int row = vecData.size()/6;
//把查询出来的数据显示到表格中
if(row!=0){
String [] title=new String[]{ "班级号", "班级名","届别","导师号","导师名","学生人数" };
String[][] aa = new String [row][6] ;
for(int i=0;i<row;i++)
{
for(int k=0;k<6;k++)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -