panelretrieval.java

学员信息管理系统

package com.javasme.panel;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;

import javax.swing.BorderFactory;
import javax.swing.BoxLayout;
import javax.swing.ComboBoxModel;
import javax.swing.DefaultComboBoxModel;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JLabel;
import javax.swing.JList;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextArea;
import javax.swing.JTextField;
import javax.swing.ListModel;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import com.javasme.data.SQLOperate;
import com.javasme.longs.LookAndFeel;
import com.javasme.longs.ObjectClasses;
import com.javasme.util.FormChecked;

public class PanelRetrieval extends javax.swing.JPanel {

    private static final long serialVersionUID = 1L;

    private JPanel            panelResult;

    private JScrollPane       scrollPaneResult = new JScrollPane();

    private JComboBox         comboBoxTable;

    private JList             listInformation;

    private JComboBox         comboBoxJudge;

    private JLabel            labelWord;

    private JLabel            labelInformation;

    private JTextArea         textAreaHelp;

    private JTextField        textFieldCondition;

    private JComboBox         comboBoxWord;

    private JScrollPane       scrollPaneInformation;

    private JTable            tableRetrieval   = ObjectClasses.tableRetrieval;

    private JButton           buttonSubmit;

    private JPanel            panelDown;

    private JLabel            labelHelp;

    private JLabel            labelCondition;

    private JLabel            labelJudge;

    private JLabel            labelTable;

    private JPanel            panelCondition;

    private String            tableName;

    private String[]          wordStudents     = new String[] {
            "Student_ID", "Student_Name", "Student_Sex", "Student_Age",
            "Student_Phone", "Student_Handset", "Student_Address",
            "Student_Native", "Student_Edu", "Student_Marry", "Student_Work",
            "Student_Stage", "Student_Class", "Student_StartClassTime",
            "Student_Like", "Student_Remarks", "Student_InsertTime",
            "Student_UpdateTime", "Student_UpdateName" };

    private String[]          wordTeachers     = new String[] {
            "Teacher_ID", "Teacher_Name", "Teacher_Sex", "Teacher_Age",
            "Teacher_Phone", "Teacher_Handset", "Teacher_Address",
            "Teacher_Native", "Teacher_Edu", "Teacher_Marry", "Teacher_Work",
            "Teacher_Language", "Teacher_Post", "Teacher_StartTeachTime",
            "Teacher_Like", "Teacher_Remarks", "Teacher_InsertTime",
            "Teacher_UpdateTime", "Teacher_UpdateName" };

    private String[]          wordCourses      = new String[] {
            "Courses_ID", "Courses_Name", "Courses_Family", "Courses_Term",
            "Courses_Describe", "Courses_Aim", "Courses_InsertTime",
            "Courses_UpdateTime", "Courses_UpdateName" };

    private String[]          wordClasses      = new String[] {
            "Class_ID", "Class_Name", "Class_Family", "Class_StartTime",
            "Class_Time", "Class_Teacher", "Class_Describe", "Class_Remarks",
            "Class_InsertTime", "Class_UpdateTime", "Class_UpdateName" };

    private String[]          studentsItem     = new String[] {
            "学生编号", "学生姓名", "学生性别", "学生年龄", "电话号码", "手机号码", "家庭地址", "学生祖籍",
            "学生学历", "婚姻状况", "工作经验", "学习阶段", "所在班级", "入学时间", "兴趣爱好", "学生电评",
            "添加时间", "更新时间", "更新用户"            };

    private String[]          teachersItem     = new String[] {
            "教师编号", "教师姓名", "教师性别", "教师年龄", "电话号码", "手机号码", "家庭地址", "教师祖籍",
            "教师学历", "婚姻状况", "工作经验", "教授语言", "教师职务", "入教时间", "兴趣爱好", "教师点评",
            "添加时间", "更新时间", "更新用户"            };

    private String[]          coursesItem      = new String[] {
            "课程编号", "课程名称", "课程类别", "所属学期", "课程描述", "课程目的", "添加时间", "更新时间",
            "更新用户"                            };

    private String[]          classesItem      = new String[] {
            "班级编号", "班级名称", "班级类别", "开设时间", "上课时间", "负责教师", "班级描述", "班级点评",
            "添加时间", "更新时间", "更新用户"            };

    private String            word;

    private String            judge;

    private String            condition;

    private String            sqlStr;

    public PanelRetrieval() {
        super();
        initGUI();
        /**
         * 风格设置
         */
        LookAndFeel.UpdateLookAndFeel(this);
    }

    private void initGUI() {
        try {
            setPreferredSize(new Dimension(700, 500));
            BoxLayout thisLayout = new BoxLayout(this, javax.swing.BoxLayout.Y_AXIS);
            this.setLayout(thisLayout);
            this.setBorder(BorderFactory.createTitledBorder("信息检索"));
            this.setBackground(new java.awt.Color(236, 233, 216));
            {
                panelResult = new JPanel();
                this.add(panelResult);
                BorderLayout panelResultLayout = new BorderLayout();
                panelResult.setLayout(panelResultLayout);
                panelResult.setBorder(BorderFactory.createTitledBorder(null, "检索结果", TitledBorder.LEADING, TitledBorder.TOP));
                panelResult.setPreferredSize(new java.awt.Dimension(684, 264));
                panelResult.setBackground(new java.awt.Color(236, 233, 216));
                {
                    panelResult.add(scrollPaneResult, BorderLayout.CENTER);
                    scrollPaneResult.setBackground(new java.awt.Color(236, 233, 216));
                    {
                        TableModel tableRetrievalModel = new DefaultTableModel();
                        tableRetrieval.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
                        scrollPaneResult.setViewportView(tableRetrieval);
                        tableRetrieval.setModel(tableRetrievalModel);
                        tableRetrieval.setFont(new java.awt.Font("宋体", 0, 12));
                    }
                }
            }
            {
                panelCondition = new JPanel();
                this.add(panelCondition);
                panelCondition.setLayout(null);
                panelCondition.setPreferredSize(new java.awt.Dimension(686, 182));
                panelCondition.setBorder(BorderFactory.createTitledBorder("检索条件"));
                panelCondition.setBackground(new java.awt.Color(236, 233, 216));
                {
                    labelTable = new JLabel();
                    panelCondition.add(labelTable);
                    labelTable.setText("选择查询表");
                    labelTable.setBounds(28, 14, 63, 21);
                    labelTable.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxTableModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "学生表", "教师表", "课程表", "班级表" });
                    comboBoxTable = new JComboBox();
                    panelCondition.add(comboBoxTable);
                    comboBoxTable.setModel(comboBoxTableModel);
                    comboBoxTable.setBounds(14, 42, 84, 21);
                    comboBoxTable.setFont(new java.awt.Font("宋体", 0, 12));
                    comboBoxTable.addItemListener(new ItemListener() {
                        public void itemStateChanged(ItemEvent evt) {
                            comboBoxTableItemStateChanged(evt);
                        }
                    });
                }
                {
                    ComboBoxModel comboBoxWordModel = new DefaultComboBoxModel(new String[] { "请选择..." });
                    comboBoxWord = new JComboBox();
                    panelCondition.add(comboBoxWord);
                    comboBoxWord.setModel(comboBoxWordModel);
                    comboBoxWord.setBounds(196, 42, 77, 21);
                    comboBoxWord.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    ComboBoxModel comboBoxJudgeModel = new DefaultComboBoxModel(new String[] {
                            "请选择...", "等于", "包含" });
                    comboBoxJudge = new JComboBox();
                    panelCondition.add(comboBoxJudge);
                    comboBoxJudge.setModel(comboBoxJudgeModel);
                    comboBoxJudge.setBounds(280, 42, 77, 21);
                    comboBoxJudge.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textFieldCondition = new JTextField();
                    panelCondition.add(textFieldCondition);
                    textFieldCondition.setBounds(364, 42, 77, 21);
                    textFieldCondition.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    textAreaHelp = new JTextArea();
                    panelCondition.add(textAreaHelp);
                    textAreaHelp.setBounds(448, 42, 210, 133);
                    textAreaHelp.setText(" ① 选择要查询的表\n ② 选择要显示的信息，可以多选\n ③ 选择索引字段\n ④ 选择判断符号，小于、大于...\n ⑤ 填写判断的条件\n ⑥ 点击《开始查询》按钮进行查询");
                    textAreaHelp.setEditable(false);
                    textAreaHelp.setBackground(new java.awt.Color(255, 128, 192));
                    textAreaHelp.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {
                    labelInformation = new JLabel();
                    panelCondition.add(labelInformation);
                    labelInformation.setText("显示信息");
                    labelInformation.setBounds(119, 14, 49, 21);
                    labelInformation.setFont(new java.awt.Font("宋体", 0, 12));
                }
                {