dailyeventframe.java

这是一个完全的开发实例

package dailyevent;

import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import javax.swing.ImageIcon;
import com.borland.dx.sql.dataset.Database;
import com.borland.dx.sql.dataset.*;
import javax.swing.JTabbedPane;
import com.borland.dbswing.JdbNavToolBar;
import com.borland.dbswing.TableScrollPane;
import com.borland.dbswing.JdbTable;
import com.borland.dx.dataset.Column;
import com.borland.dbswing.JdbStatusLabel;
import javax.swing.JLabel;
import com.borland.dbswing.JdbTextArea;
import com.borland.dbswing.JdbTextField;
import javax.swing.JScrollPane;
import com.borland.dbswing.JdbComboBox;
import com.borland.dbswing.JdbLabel;
import com.borland.dx.dataset.*;

public class DailyEventFrame extends JFrame {
    JPanel contentPane;
    BorderLayout borderLayout1 = new BorderLayout();
    JMenuBar jMenuBar1 = new JMenuBar();
    JMenu jMenuFile = new JMenu();
    JMenuItem jMenuFileExit = new JMenuItem();
    JMenu jMenuHelp = new JMenu();
    JMenuItem jMenuHelpAbout = new JMenuItem();
    ImageIcon image1 = new ImageIcon(dailyevent.DailyEventFrame.class.
                                     getResource("openFile.png"));
    ImageIcon image2 = new ImageIcon(dailyevent.DailyEventFrame.class.
                                     getResource("closeFile.png"));
    ImageIcon image3 = new ImageIcon(dailyevent.DailyEventFrame.class.
                                     getResource("help.png"));
    Database database1 = new Database();
    QueryDataSet queryDataSet1 = new QueryDataSet();
    QueryDataSet queryDataSet2 = new QueryDataSet();
    JPanel jPanel1 = new JPanel();
    BorderLayout borderLayout2 = new BorderLayout();
    JTabbedPane jTabbedPane1 = new JTabbedPane();
    JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
    JPanel jPanel2 = new JPanel();
    JPanel jPanel3 = new JPanel();
    GridBagLayout gridBagLayout1 = new GridBagLayout();
    TableScrollPane tableScrollPane1 = new TableScrollPane();
    JdbTable jdbTable1 = new JdbTable();
    Column column1 = new Column();
    BorderLayout borderLayout3 = new BorderLayout();
    JdbStatusLabel jdbStatusLabel1 = new JdbStatusLabel();
    JPanel jPanel4 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JLabel jLabel5 = new JLabel();
    JdbTextField jdbTextField1 = new JdbTextField();
    JdbTextField jdbTextField2 = new JdbTextField();
    JdbTextField jdbTextField3 = new JdbTextField();
    JScrollPane jScrollPane1 = new JScrollPane();
    JdbTextArea jdbTextArea1 = new JdbTextArea();
    JLabel jLabel6 = new JLabel();
    JdbTextField jdbTextField4 = new JdbTextField();
    JdbComboBox jdbComboBox1 = new JdbComboBox();
    JLabel jLabel7 = new JLabel();
    QueryDataSet queryDataSet3 = new QueryDataSet();
    QueryDataSet queryDataSet4 = new QueryDataSet();
    JPanel jPanel5 = new JPanel();
    GridBagLayout gridBagLayout2 = new GridBagLayout();
    JLabel jLabel8 = new JLabel();
    JLabel jLabel9 = new JLabel();
    JdbLabel jdbLabel1 = new JdbLabel();
    JdbLabel jdbLabel2 = new JdbLabel();
    JLabel jLabel10 = new JLabel();
    JdbLabel jdbLabel3 = new JdbLabel();
    Column column3 = new Column();

    public DailyEventFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(borderLayout1);
        setSize(new Dimension(600, 400));
        setTitle("日程记事");
        jMenuFile.setText("File");
        jMenuFileExit.setText("Exit");
        jMenuFileExit.addActionListener(new
                                        DailyEventFrame_jMenuFileExit_ActionAdapter(this));
        jMenuHelp.setText("Help");
        jMenuHelpAbout.setText("About");
        jMenuHelpAbout.addActionListener(new
                                         DailyEventFrame_jMenuHelpAbout_ActionAdapter(this));
        /**
         * 建立数据库的连接
         */
        database1.setConnection(new ConnectionDescriptor(
                "jdbc:JSQLConnect://127.0.0.1:1433/database=dailyevent", "sa",
                "sa", false, "com.jnetdirect.jsql.JSQLDriver"));
        database1.setDatabaseName("");
        /**
         * DailyEvent表的数据集合
         */
        queryDataSet2.setSort(new com.borland.dx.dataset.SortDescriptor("",
                new String[] {"EventTime"}, new boolean[] {true, }, null, 0));
        queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1, "select * from dailyevent", null, true,
                Load.AS_NEEDED));
        jPanel1.setLayout(borderLayout2);
        /**
         * 导航工具栏挂靠在queryDataSet2数据集上
         */
        jdbNavToolBar1.setDataSet(queryDataSet2);
        jPanel2.setLayout(gridBagLayout1);
        jdbTable1.setCustomColumns(null);
        jdbTable1.setDataSet(queryDataSet2);
        jPanel3.setLayout(borderLayout3);
        /**
         * queryDataSet2数据集的状态栏
         */
        jdbStatusLabel1.setText("jdbStatusLabel1");
        jdbStatusLabel1.setDataSet(queryDataSet2);

        jLabel1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel1.setText("时间");
        jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel2.setText("地点");
        jLabel3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel3.setText("参与人员");
        jLabel4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel4.setText("事件类型");
        jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel5.setText("描述");
        jdbTextField1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jdbTextField1.setText("jdbTextField1");
        jdbTextField1.setColumnName("eventtime");
        jdbTextField1.setDataSet(queryDataSet2);
        jdbTextField2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jdbTextField2.setText("jdbTextField2");
        jdbTextField2.setColumnName("eventaddress");
        jdbTextField2.setDataSet(queryDataSet2);
        jdbTextField3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jdbTextField3.setText("jdbTextField3");
        jdbTextField3.setColumnName("personality");
        jdbTextField3.setDataSet(queryDataSet2);
        jdbTextArea1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jdbTextArea1.setText("jdbTextArea1");
        jdbTextArea1.setColumns(40);
        queryDataSet2.setColumns(new Column[] {column3});
        jdbTextArea1.setRows(3);
        jdbTextArea1.setColumnName("note");
        jdbTextArea1.setDataSet(queryDataSet2);
        jLabel6.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jLabel6.setText("序号");
        jdbTextField4.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        jdbTextField4.setEditable(false);
        jdbTextField4.setText("jdbTextField4");
        jdbTextField4.setColumnName("EventUID");
        jdbTextField4.setDataSet(queryDataSet2);
        jLabel7.setText("格式：YYYY-MM-DD HH:MI:SS");

        /**
         * 最近生日的数据集
         */

        queryDataSet3.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(
                database1,
                "select eventtime,personality from dailyevent where eventtypeuid = " +
                "3and DATEDIFF(dayofyear, eventtime, getdate()) > 0 order by DATEDIFF(day, " +