开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Java编程 > 查看源码
MainFrame.java~139~
资源名称：Java.rar　[点击查看]
上传用户：liming9091
上传日期：2014-10-27
资源大小：3376k
文件大小：32k
源码类别：

Java编程

开发平台：

Java

MainFrame.java~139~：源码内容
  1. package stumanage;
  3. import javax.swing.*;
  4. import javax.swing.plaf.*;
  5. import com.borland.dbswing.*;
  6. import java.awt.*;
  7. import com.borland.jbcl.layout.*;
  8. import com.borland.dx.sql.dataset.*;
  9. import com.borland.dx.dataset.*;
  10. import java.awt.event.*;
  12. /**
  13.  * <p>Title: </p>
  14.  * <p>Description: </p>
  15.  * <p>Copyright: Copyright (c) 2003</p>
  16.  * <p>Company: </p>
  17.  * @author not attributable
  18.  * @version 1.0
  19.  */
  21. public class MainFrame
  22.     extends JFrame {
  23.   PaneLayout paneLayout1 = new PaneLayout();
  24.   JTabbedPane jTabbedPane1 = new JTabbedPane();
  25.   JPanel jPanel1 = new JPanel();
  26.   JPanel jPanel2 = new JPanel();
  27.   JPanel jPanel3 = new JPanel();
  28.   JPanel jPanel4 = new JPanel();
  29.   JPanel jPanel5 = new JPanel();
  30.   BorderLayout borderLayout1 = new BorderLayout();
  31.   JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  32.   BorderLayout borderLayout2 = new BorderLayout();
  33.   Database database1 = new Database();
  34.   JPanel jPanel6 = new JPanel();
  35.   BorderLayout borderLayout3 = new BorderLayout();
  36.   JPanel jPanel7 = new JPanel();
  37.   JPanel jPanel8 = new JPanel();
  38.   FlowLayout flowLayout1 = new FlowLayout();
  39.   JLabel jLabel1 = new JLabel();
  40.   JLabel jLabel2 = new JLabel();
  41.   JLabel jLabel3 = new JLabel();
  42.   JLabel jLabel4 = new JLabel();
  43.   JLabel jLabel5 = new JLabel();
  44.   JLabel jLabel6 = new JLabel();
  45.   JLabel jLabel7 = new JLabel();
  46.   JButton jButton1 = new JButton();
  47.   JButton jButton2 = new JButton();
  48.   TableScrollPane tableScrollPane1 = new TableScrollPane();
  49.   JdbTable jdbTable1 = new JdbTable();
  50.   QueryDataSet queryDataSet2 = new QueryDataSet();
  51.   Column column8 = new Column();
  52.   Column column9 = new Column();
  53.   Column column10 = new Column();
  54.   Column column11 = new Column();
  55.   Column column12 = new Column();
  56.   Column column13 = new Column();
  57.   Column column14 = new Column();
  58.   Font font1;
  59.   BorderLayout borderLayout4 = new BorderLayout();
  60.   JPanel jPanel9 = new JPanel();
  61.   JLabel jLabel8 = new JLabel();
  62.   JLabel jLabel9 = new JLabel();
  63.   JLabel jLabel10 = new JLabel();
  64.   JLabel jLabel11 = new JLabel();
  65.   JdbNavToolBar jdbNavToolBar2 = new JdbNavToolBar();
  66.   JPanel jPanel10 = new JPanel();
  67.   JPanel jPanel11 = new JPanel();
  68.   JPanel jPanel12 = new JPanel();
  69.   BorderLayout borderLayout5 = new BorderLayout();
  70.   JLabel jLabel12 = new JLabel();
  71.   TableScrollPane tableScrollPane2 = new TableScrollPane();
  72.   JdbTable jdbTable2 = new JdbTable();
  73.   JLabel jLabel13 = new JLabel();
  74.   TableScrollPane tableScrollPane3 = new TableScrollPane();
  75.   BorderLayout borderLayout6 = new BorderLayout();
  76.   JButton jButton3 = new JButton();
  77.   JButton jButton4 = new JButton();
  78.   XYLayout xYLayout1 = new XYLayout();
  79.   QueryDataSet queryDataSet1 = new QueryDataSet();
  80.   Column column1 = new Column();
  81.   Column column2 = new Column();
  82.   Column column3 = new Column();
  83.   Column column4 = new Column();
  84.   Column column5 = new Column();
  85.   Column column6 = new Column();
  86.   Column column7 = new Column();
  87.   JdbTable jdbTable3 = new JdbTable();
  88.   JLabel jLabel14 = new JLabel();
  89.   JLabel jLabel15 = new JLabel();
  90.   JPanel jPanel13 = new JPanel();
  91.   JLabel jLabel16 = new JLabel();
  92.   JLabel jLabel17 = new JLabel();
  93.   BorderLayout borderLayout7 = new BorderLayout();
  94.   JPanel jPanel14 = new JPanel();
  95.   JPanel jPanel15 = new JPanel();
  96.   TableScrollPane tableScrollPane4 = new TableScrollPane();
  97.   BorderLayout borderLayout8 = new BorderLayout();
  98.   BorderLayout borderLayout9 = new BorderLayout();
  99.   JPanel jPanel16 = new JPanel();
  100.   JPanel jPanel17 = new JPanel();
  101.   JPanel jPanel18 = new JPanel();
  102.   JdbTable jdbTable4 = new JdbTable();
  103.   GridBagLayout gridBagLayout1 = new GridBagLayout();
  104.   JLabel jLabel18 = new JLabel();
  105.   JLabel jLabel19 = new JLabel();
  106.   JdbTextField jdbTextField1 = new JdbTextField();
  107.   JdbTextField jdbTextField2 = new JdbTextField();
  108.   JdbTextArea jdbTextArea1 = new JdbTextArea();
  109.   BorderLayout borderLayout10 = new BorderLayout();
  110.   JButton jButton5 = new JButton();
  111.   JButton jButton6 = new JButton();
  112.   BorderLayout borderLayout11 = new BorderLayout();
  113.   JLabel jLabel20 = new JLabel();
  114.   JdbTextField jdbTextField3 = new JdbTextField();
  115.   JdbTextField jdbTextField4 = new JdbTextField();
  116.   JdbTextField jdbTextField5 = new JdbTextField();
  117.   JdbTextField jdbTextField7 = new JdbTextField();
  118.   JdbTextField jdbTextField8 = new JdbTextField();
  119.   JPanel jPanel19 = new JPanel();
  120.   GridBagLayout gridBagLayout2 = new GridBagLayout();
  121.   ButtonGroup buttonGroup1 = new ButtonGroup();
  122.   JdbRadioButton jdbRadioButton2 = new JdbRadioButton();
  123.   JdbRadioButton jdbRadioButton1 = new JdbRadioButton();
  124.   JdbNavField jdbNavField1 = new JdbNavField();
  125.   JdbTextField jdbTextField9 = new JdbTextField();
  126.   JdbTextField jdbTextField10 = new JdbTextField();
  127.   QueryDataSet queryDataSet4 = new QueryDataSet();
  128.   QueryDataSet qSet_course = new QueryDataSet();
  129.   Column column15 = new Column();
  130.   Column column16 = new Column();
  131.   Column column18 = new Column();
  132.   Column column19 = new Column();
  133.   JdbTextField jdbTextField11 = new JdbTextField();
  134.   JdbNavField jdbNavField2 = new JdbNavField();   JdbNavField jdbNavField3 = new JdbNavField();   JdbTextField jdbTextField12 = new JdbTextField();   JdbTextField jdbTextField13 = new JdbTextField();   JdbTextField jdbTextField14 = new JdbTextField();
  136.   public MainFrame() {
  137.     try {
  138.       jbInit();
  139.     }
  140.     catch (Exception e) {
  141.       e.printStackTrace();
  142.     }
  143.   }
  145.   public static void main(String[] args) {
  146.     try {
  147.       UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
  148.     }
  149.     catch (Exception e) {
  150.     }
  151.     //System.out.println(new javax.swing.UIManager());
  152.     Font f = new java.awt.Font("SansSerif", 0, 12);
  153. UIManager.put("Label.font",f);
  154. UIManager.put("Label.foreground",Color.black);
  155. UIManager.put("Button.font",f);
  156. UIManager.put("Menu.font",f);
  157. UIManager.put("MenuItem.font",f);
  158. UIManager.put("List.font",f);
  159. UIManager.put("CheckBox.font",f);
  160. UIManager.put("RadioButton.font",f);
  161. UIManager.put("ComboBox.font",f);
  162.     UIManager.put("TextArea.font",f);
  163.     UIManager.put("dbTextArea.font",f);
  164.     UIManager.put("font",f);
  166.     MainFrame mainFrame = new MainFrame();
  167.     mainFrame.setFont(new java.awt.Font("SansSerif", 0, 12));
  168.     mainFrame.pack();
  169.     mainFrame.setSize(600,450);
  170.     mainFrame.show();
  171.   }
  173.   private void jbInit() throws Exception {
  174.     font1 = new java.awt.Font("SansSerif", 0, 12);
  175.     this.getContentPane().setLayout(paneLayout1);
  176.     jPanel1.setLayout(borderLayout1);
  177.     jdbNavToolBar1.setDebugGraphicsOptions(0);
  178.     jdbNavToolBar1.setAlignment(FlowLayout.CENTER);
  179.     jPanel5.setLayout(borderLayout2);
  180.     database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;databaseName=student", "sa", "sa", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
  181.     database1.setDatabaseName("");
  182.     jPanel6.setFont(new java.awt.Font("SansSerif", 0, 12));
  183.     jPanel6.setMinimumSize(new Dimension(50, 100));
  184.     jPanel6.setPreferredSize(new Dimension(50, 110));
  185.     jPanel6.setLayout(borderLayout3);
  186.     jPanel7.setFont(new java.awt.Font("SansSerif", 0, 12));
  187.     jPanel7.setMinimumSize(new Dimension(100, 30));
  188.     jPanel7.setPreferredSize(new Dimension(100, 40));
  189.     jPanel7.setLayout(flowLayout1);
  190.     jPanel8.setFont(new java.awt.Font("SansSerif", 0, 12));
  191.     jPanel8.setMinimumSize(new Dimension(10, 10));
  192.     jPanel8.setLayout(gridBagLayout2);
  193.     jLabel1.setText("学号：");
  194.     flowLayout1.setAlignment(FlowLayout.LEFT);
  195.     jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
  196.     jLabel2.setText("姓名：");
  197.     jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
  198.     jLabel3.setText("性别：");
  199.     jLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
  200.     jLabel4.setText("班级：");
  201.     jLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
  202.     jLabel5.setText("生日：");
  203.     jLabel6.setHorizontalAlignment(SwingConstants.RIGHT);
  204.     jLabel6.setText("电话：");
  205.     jLabel7.setHorizontalAlignment(SwingConstants.RIGHT);
  206.     jLabel7.setText("地址：");
  207.     jButton1.setText("修改");
  208.     jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
  209.     jButton2.setText("取消");
  210.    jdbTable1.setFont(new java.awt.Font("SansSerif", 0, 12));
  211.     jdbTable1.setDataSet(queryDataSet2);
  212.     jTabbedPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
  213.     jTabbedPane1.setMinimumSize(new Dimension(500, 194));
  214.     jTabbedPane1.setPreferredSize(new Dimension(500, 607));
  215.     queryDataSet2.setProvider(null);
  216.     queryDataSet2.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_info.student_id,student_info.student_name,student_info.student_class,student_info.stud" +
  217.       "ent_sex,student_info.student_birthday,student_info.student_tel,student_info.student_address " +
  218.       "FROM student.dbo.student_info", null, true, Load.ALL));
  219.     column8.setCaption("生日");
  220.     column8.setColumnName("student_birthday");
  221.     column8.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
  222.     column8.setDisplayMask("MM-dd-yyyy");
  223.     column8.setEditMask("MM-dd-yyyy");
  224.     column8.setSchemaName("dbo");
  225.     column8.setTableName("student_info");
  226.     column8.setWidth(10);
  227.     column8.setServerColumnName("student_birthday");
  228.     column8.setSqlType(93);
  229.     column9.setCaption("学号");
  230.     column9.setColumnName("student_id");
  231.     column9.setDataType(com.borland.dx.dataset.Variant.INT);
  232.     column9.setEditMask("######");
  233.     column9.setFont(new java.awt.Font("SansSerif", 0, 12));
  234.     column9.setRowId(true);
  235.     column9.setSchemaName("dbo");
  236.     column9.setTableName("student_info");
  237.     column9.setWidth(10);
  238.     column9.setServerColumnName("student_id");
  239.     column9.setSqlType(4);
  240.     column10.setCaption("姓名");
  241.     column10.setColumnName("student_name");
  242.     column10.setDataType(com.borland.dx.dataset.Variant.STRING);
  243.     column10.setPrecision(50);
  244.     column10.setSchemaName("dbo");
  245.     column10.setTableName("student_info");
  246.     column10.setWidth(10);
  247.     column10.setServerColumnName("student_name");
  248.     column10.setSqlType(12);
  249.     column11.setCaption("班级");
  250.     column11.setColumnName("student_class");
  251.     column11.setDataType(com.borland.dx.dataset.Variant.INT);
  252.     column11.setSchemaName("dbo");
  253.     column11.setTableName("student_info");
  254.     column11.setWidth(10);
  255.     column11.setServerColumnName("student_class");
  256.     column11.setSqlType(4);
  257.     column12.setCaption("性别");
  258.     column12.setColumnName("student_sex");
  259.     column12.setDataType(com.borland.dx.dataset.Variant.STRING);
  260.     column12.setPrecision(50);
  261.     column12.setSchemaName("dbo");
  262.     column12.setTableName("student_info");
  263.     column12.setWidth(10);
  264.     column12.setServerColumnName("student_sex");
  265.     column12.setSqlType(12);
  266.     column13.setCaption("联系电话");
  267.     column13.setColumnName("student_tel");
  268.     column13.setDataType(com.borland.dx.dataset.Variant.STRING);
  269.     column13.setPrecision(50);
  270.     column13.setSchemaName("dbo");
  271.     column13.setTableName("student_info");
  272.     column13.setWidth(10);
  273.     column13.setServerColumnName("student_tel");
  274.     column13.setSqlType(12);
  275.     column14.setCaption("联系地址");
  276.     column14.setColumnName("student_address");
  277.     column14.setDataType(com.borland.dx.dataset.Variant.STRING);
  278.     column14.setPrecision(150);
  279.     column14.setSchemaName("dbo");
  280.     column14.setTableName("student_info");
  281.     column14.setWidth(14);
  282.     column14.setServerColumnName("student_address");
  283.     column14.setSqlType(12);
  284.     queryDataSet2.setColumns(new Column[] {column9, column10, column11, column12, column8, column13, column14});
  285.     queryDataSet2.addNavigationListener(new MainFrame_queryDataSet2_navigationAdapter(this));
  286.     jPanel1.setFont(new java.awt.Font("SansSerif", 0, 12));
  287.     jPanel1.setPreferredSize(new Dimension(472, 580));
  288.     jPanel5.setFont(new java.awt.Font("SansSerif", 0, 12));
  289.     tableScrollPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
  290.     tableScrollPane1.getViewport().setFont(new java.awt.Font("SansSerif", 0, 12));
  291.     this.setFont(new java.awt.Font("SansSerif", 0, 12));
  292.     jPanel2.setFont(new java.awt.Font("SansSerif", 0, 12));
  293.     jPanel2.setLayout(borderLayout4);
  294.     jLabel8.setText("学号：");
  295.     jLabel9.setRequestFocusEnabled(true);
  296.     jLabel9.setText("姓名: ");
  297.     jLabel10.setText("班级: ");
  298.     jLabel11.setText("性别: ");
  299.     jdbNavToolBar2.setEnabled(false);
  300.     jdbNavToolBar2.setAlignment(FlowLayout.CENTER);
  301.     jPanel10.setMinimumSize(new Dimension(300, 10));
  302.     jPanel10.setPreferredSize(new Dimension(300, 10));
  303.     jPanel10.setLayout(borderLayout5);
  304.     jLabel12.setText("学校设置可选课程信息");
  305.     jPanel11.setMinimumSize(new Dimension(200, 10));
  306.     jPanel11.setPreferredSize(new Dimension(200, 10));
  307.     jPanel11.setLayout(borderLayout6);
  308.     jLabel13.setText("个人已选课程信息");
  309.     jButton3.setText("选课");
  310.     jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
  311.     jButton4.setText("退课");
  312.     jButton4.addActionListener(new MainFrame_jButton4_actionAdapter(this));
  313.     jPanel12.setLayout(xYLayout1);
  314.     queryDataSet1.setReadOnly(false);
  315.     queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_coursecode.course_code,student_coursecode.course_name,student_coursecode.course_period" +
  316.       ",student_coursecode.course_credit,student_coursecode.course_teacher,student_coursecode.course_address" +
  317.       " FROM student.dbo.student_coursecode", null, true, Load.ALL));
  318.     column1.setCaption("课程代号");
  319.     column1.setColumnName("course_code");
  320.     column1.setDataType(com.borland.dx.dataset.Variant.INT);
  321.     column1.setRowId(true);
  322.     column1.setSchemaName("dbo");
  323.     column1.setTableName("student_coursecode");
  324.     column1.setWidth(10);
  325.     column1.setServerColumnName("course_code");
  326.     column1.setSqlType(4);
  327.     column2.setCaption("课程名称");
  328.     column2.setColumnName("course_name");
  329.     column2.setDataType(com.borland.dx.dataset.Variant.STRING);
  330.     column2.setPrecision(50);
  331.     column2.setSchemaName("dbo");
  332.     column2.setTableName("student_coursecode");
  333.     column2.setWidth(10);
  334.     column2.setServerColumnName("course_name");
  335.     column2.setSqlType(12);
  336.     column3.setCaption("课程学时");
  337.     column3.setColumnName("course_period");
  338.     column3.setDataType(com.borland.dx.dataset.Variant.INT);
  339.     column3.setSchemaName("dbo");
  340.     column3.setTableName("student_coursecode");
  341.     column3.setWidth(10);
  342.     column3.setServerColumnName("course_period");
  343.     column3.setSqlType(4);
  344.     column4.setCaption("课程学分");
  345.     column4.setColumnName("course_credit");
  346.     column4.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
  347.     column4.setSchemaName("dbo");
  348.     column4.setTableName("student_coursecode");
  349.     column4.setWidth(10);
  350.     column4.setServerColumnName("course_credit");
  351.     column4.setSqlType(6);
  352.     column5.setCaption("任课老师");
  353.     column5.setColumnName("course_teacher");
  354.     column5.setDataType(com.borland.dx.dataset.Variant.STRING);
  355.     column5.setPrecision(50);
  356.     column5.setSchemaName("dbo");
  357.     column5.setTableName("student_coursecode");
  358.     column5.setWidth(10);
  359.     column5.setServerColumnName("course_teacher");
  360.     column5.setSqlType(12);
  361.     column6.setCaption("上课地点");
  362.     column6.setColumnName("course_address");
  363.     column6.setDataType(com.borland.dx.dataset.Variant.STRING);
  364.     column6.setPrecision(50);
  365.     column6.setSchemaName("dbo");
  366.     column6.setTableName("student_coursecode");
  367.     column6.setWidth(10);
  368.     column6.setServerColumnName("course_address");
  369.     column6.setSqlType(12);
  370.     queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
  371.     jdbTable2.setDataSet(queryDataSet1);
  372.     jdbTable2.setEditable(false);
  373.     column7.setCaption("学生姓名");
  374.     column7.setColumnName("course_name");
  375.     column7.setDataType(com.borland.dx.dataset.Variant.STRING);
  376.     column7.setPrecision(50);
  377.     column7.setSchemaName("dbo");
  378.     column7.setTableName("student_course");
  379.     column7.setWidth(10);
  380.     column7.setServerColumnName("course_name");
  381.     column7.setSqlType(12);
  382.     jLabel14.setText("学号：");
  383.     jLabel15.setText("性别: ");
  384.     jLabel16.setRequestFocusEnabled(true);
  385.     jLabel16.setText("姓名: ");
  386.     jLabel17.setText("班级: ");
  387.     jPanel3.setLayout(borderLayout7);
  388.     jPanel15.setMinimumSize(new Dimension(200, 100));
  389.     jPanel15.setPreferredSize(new Dimension(200, 250));
  390.     jPanel15.setLayout(borderLayout8);
  391.     jPanel14.setLayout(borderLayout9);
  392.     jPanel14.setMinimumSize(new Dimension(300, 50));
  393.     jPanel14.setPreferredSize(new Dimension(300, 50));
  394.     jPanel14.setVerifyInputWhenFocusTarget(true);
  395.     jPanel13.setPreferredSize(new Dimension(404, 40));
  396.     jPanel16.setPreferredSize(new Dimension(280, 10));
  397.     jPanel16.setLayout(gridBagLayout1);
  398.     jLabel18.setText("获奖时间:");
  399.     jLabel19.setText("获奖名称:");
  400.     jdbTextField1.setText("jdbTextField1");
  401.     jdbTextField2.setText("jdbTextField2");
  402.     jdbTextArea1.setText("jdbTextArea1");
  403.     jPanel17.setLayout(borderLayout10);
  404.     jButton5.setText("增加");
  405.     jButton6.setText("取消");
  406.     jPanel18.setLayout(borderLayout11);
  407.     borderLayout11.setVgap(10);
  408.     jLabel20.setText("获奖内容具体描述:");
  409.     jdbTextField3.setEnabled(true);
  410.     jdbTextField3.setAlignmentX((float) 0.5);
  411.     jdbTextField3.setDoubleBuffered(false);
  412.     jdbTextField3.setMinimumSize(new Dimension(10, 22));
  413.     jdbTextField3.setPreferredSize(new Dimension(15, 22));
  414.     jdbTextField3.setMargin(new Insets(1, 3, 1, 3));
  415.     jdbTextField3.setText("");
  416.     jdbTextField3.setHorizontalAlignment(SwingConstants.LEFT);
  417.     jdbTextField3.setColumnName("student_name");
  418.     jdbTextField3.setDataSet(queryDataSet2);
  419.     jdbTextField3.setEnablePopupMenu(true);
  420.     jdbTextField3.setPostOnFocusLost(true);
  421.     jdbTextField4.setDebugGraphicsOptions(0);
  422.     jdbTextField4.setText("jdbTextField4");
  423.     jdbTextField4.setColumnName("student_class");
  424.     jdbTextField4.setDataSet(queryDataSet2);
  425.     jdbTextField5.setText("jdbTextField5");
  426.     jdbTextField5.setColumnName("student_tel");
  427.     jdbTextField5.setDataSet(queryDataSet2);
  428.     jdbTextField7.setDisabledTextColor(Color.gray);
  429.     jdbTextField7.setText("jdbTextField7");
  430.     jdbTextField7.setColumnName("student_birthday");
  431.     jdbTextField7.setDataSet(queryDataSet2);
  432.     jdbTextField8.setText("jdbTextField8");
  433.     jdbTextField8.setColumnName("student_address");
  434.     jdbTextField8.setDataSet(queryDataSet2);
  435.     jdbRadioButton2.setSelected(false);
  436.     jdbRadioButton2.setText("女");
  437.     jdbRadioButton2.setButtonGroup(buttonGroup1);
  438.     jdbRadioButton2.setColumnName("student_sex");
  439.     jdbRadioButton2.setDataSet(queryDataSet2);
  440.     jdbRadioButton2.setSelectedDataValue("女");
  441.     jdbRadioButton1.setActionCommand("男");
  442.     jdbRadioButton1.setContentAreaFilled(true);
  443.     jdbRadioButton1.setSelected(true);
  444.     jdbRadioButton1.setText("男");
  445.     jdbRadioButton1.setButtonGroup(buttonGroup1);
  446.     jdbRadioButton1.setColumnName("student_sex");
  447.     jdbRadioButton1.setDataSet(queryDataSet2);
  448.     jdbRadioButton1.setSelectedDataValue("男");
  449.     jdbNavField1.setMinimumSize(new Dimension(100, 22));
  450.     jdbNavField1.setPreferredSize(new Dimension(100, 22));
  451.     jdbNavField1.setText("jdbNavField1");
  452.     jdbNavField1.setColumnName("student_id");
  453.     jdbNavField1.setDataSet(queryDataSet2);
  454.     jdbTextField9.setEnabled(true);
  455.     jdbTextField9.setPreferredSize(new Dimension(70, 22));
  456.     jdbTextField9.setEditable(false);
  457.     jdbTextField9.setText("jdbTextField9");
  458.     jdbTextField9.setColumns(0);
  459.     jdbTextField9.setColumnName("student_class");
  460.     jdbTextField9.setDataSet(queryDataSet2);
  461.     jdbTextField10.setEnabled(true);
  462.     jdbTextField10.setPreferredSize(new Dimension(50, 22));
  463.     jdbTextField10.setEditable(false);
  464.     jdbTextField10.setText("jdbTextField10");
  465.     jdbTextField10.setColumnName("student_sex");
  466.     jdbTextField10.setDataSet(queryDataSet2);
  467.     queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_count.count_id FROM student.dbo.student_count", null, true, Load.ALL));
  468.     qSet_course.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_course.count_id,student_course.course_id,student_course.course_name,student_course.cou" +
  469.       "rse_no FROM student.dbo.student_course", null, true, Load.ALL));
  470.     column15.setColumnName("count_id");
  471.     column15.setDataType(com.borland.dx.dataset.Variant.INT);
  472.     column15.setRowId(true);
  473.     column15.setSchemaName("dbo");
  474.     column15.setTableName("student_course");
  475.     column15.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  476.     column15.setServerColumnName("count_id");
  477.     column15.setSqlType(4);
  478.     column16.setColumnName("course_id");
  479.     column16.setDataType(com.borland.dx.dataset.Variant.INT);
  480.     column16.setSchemaName("dbo");
  481.     column16.setTableName("student_course");
  482.     column16.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  483.     column16.setServerColumnName("course_id");
  484.     column16.setSqlType(4);
  485.     column18.setCaption("学生姓名");
  486.     column18.setColumnName("course_name");
  487.     column18.setDataType(com.borland.dx.dataset.Variant.STRING);
  488.     column18.setPrecision(50);
  489.     column18.setSchemaName("dbo");
  490.     column18.setTableName("student_course");
  491.     column18.setWidth(10);
  492.     column18.setServerColumnName("course_name");
  493.     column18.setSqlType(12);
  494.     column19.setCaption("所选课程编号");
  495.     column19.setColumnName("course_no");
  496.     column19.setDataType(com.borland.dx.dataset.Variant.INT);
  497.     column19.setSchemaName("dbo");
  498.     column19.setTableName("student_course");
  499.     column19.setServerColumnName("course_no");
  500.     column19.setSqlType(4);
  501.     qSet_course.setColumns(new Column[] {column15, column16, column18, column19});
  502.     qSet_course.addRowFilterListener(new MainFrame_qSet_course_rowFilterAdapter(this));
  503.     jdbTable3.setDataSet(qSet_course);
  504.     jdbTextField11.setMinimumSize(new Dimension(70, 22));
  505.     jdbTextField11.setPreferredSize(new Dimension(70, 22));
  506.     jdbTextField11.setEditable(false);
  507.     jdbTextField11.setText("jdbTextField11");
  508.     jdbTextField11.setColumnName("student_name");
  509.     jdbTextField11.setDataSet(queryDataSet2);
  510.     jdbNavField2.setDataSet(queryDataSet2);
  511.     jdbNavField2.setColumnName("student_id");
  512.     jdbNavField2.setPreferredSize(new Dimension(70, 22));
  513.     jdbNavField2.setMinimumSize(new Dimension(70, 22));
  514.     jdbNavField3.setMinimumSize(new Dimension(70, 22));     jdbNavField3.setPreferredSize(new Dimension(70, 22));     jdbNavField3.setColumnName("student_id");     jdbNavField3.setDataSet(queryDataSet2);     jdbTextField12.setDataSet(queryDataSet2);     jdbTextField12.setColumnName("student_name");     jdbTextField12.setText("jdbTextField11");     jdbTextField12.setEditable(false);     jdbTextField12.setPreferredSize(new Dimension(70, 22));     jdbTextField12.setMinimumSize(new Dimension(70, 22));     jdbTextField13.setDataSet(queryDataSet2);     jdbTextField13.setColumnName("student_class");     jdbTextField13.setColumns(0);     jdbTextField13.setText("jdbTextField9");     jdbTextField13.setEditable(false);     jdbTextField13.setPreferredSize(new Dimension(70, 22));     jdbTextField13.setEnabled(true);     jdbTextField14.setDataSet(queryDataSet2);     jdbTextField14.setColumnName("student_sex");     jdbTextField14.setText("jdbTextField10");     jdbTextField14.setEditable(false);     jdbTextField14.setPreferredSize(new Dimension(50, 22));     jdbTextField14.setEnabled(true);     this.getContentPane().add(jTabbedPane1,
  515.                               new PaneConstraints("jTabbedPane1", "jTabbedPane1",
  516.                                                   PaneConstraints.ROOT, 1.0f));
  517.     jTabbedPane1.add(jPanel1, "个人信息管理");
  518.     jPanel1.add(jPanel5, BorderLayout.CENTER);
  519.     jPanel5.add(jdbNavToolBar1, BorderLayout.SOUTH);
  520.     jPanel5.add(jPanel6, BorderLayout.NORTH);
  521.     jPanel6.add(jPanel7, BorderLayout.NORTH);
  522.     jPanel7.add(jLabel1, null);
  523.     jPanel6.add(jPanel8, BorderLayout.CENTER);
  524.     jPanel8.add(jLabel2,    new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
  525.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 28, 19));
  526.     jPanel8.add(jdbTextField3,      new GridBagConstraints(1, 0, 2, 1, 1.0, 0.0
  527.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 75, 13));
  528.     jPanel8.add(jLabel4,     new GridBagConstraints(3, 0, 1, 1, 0.0, 0.0
  529.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 31, 19));
  530.     jPanel8.add(jdbTextField4,   new GridBagConstraints(4, 0, 1, 1, 1.0, 0.0
  531.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  532.     jPanel8.add(jLabel6,   new GridBagConstraints(5, 0, 1, 1, 0.0, 0.0
  533.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
  534.     jPanel8.add(jdbTextField5,   new GridBagConstraints(6, 0, 1, 1, 1.0, 0.0
  535.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  536.     jPanel8.add(jButton1,   new GridBagConstraints(7, 0, 1, 1, 0.0, 0.0
  537.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
  538.     jPanel8.add(jLabel3,    new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
  539.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 30, 19));
  540.     jPanel8.add(jPanel19,     new GridBagConstraints(2, 1, 1, 1, 1.0, 1.0
  541.             ,GridBagConstraints.CENTER, GridBagConstraints.VERTICAL, new Insets(0, 0, 0, 0), -3, 25));
  542.     jPanel8.add(jLabel5,            new GridBagConstraints(3, 1, 1, 1, 0.0, 0.0
  543.             ,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(0, 0, 0, 1), 30, 19));
  544.     jPanel8.add(jdbTextField7,   new GridBagConstraints(4, 1, 1, 1, 1.0, 0.0
  545.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 7, 13));
  546.     jPanel8.add(jLabel7,   new GridBagConstraints(5, 1, 1, 1, 0.0, 0.0
  547.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
  548.     jPanel8.add(jdbTextField8,   new GridBagConstraints(6, 1, 1, 1, 1.0, 0.0
  549.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  550.     jPanel8.add(jButton2,   new GridBagConstraints(7, 1, 1, 1, 0.0, 0.0
  551.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
  552.     jPanel5.add(tableScrollPane1, BorderLayout.CENTER);
  553.     tableScrollPane1.getViewport().add(jdbTable1, null);
  554.     jTabbedPane1.add(jPanel2, "选课信息管理");
  555.     jTabbedPane1.add(jPanel3, "奖励信息管理");
  556.     jPanel3.add(jPanel13, BorderLayout.NORTH);
  557.     jPanel13.add(jLabel14, null);
  558.     jPanel13.add(jLabel16, null);
  559.     jPanel13.add(jLabel17, null);
  560.     jPanel13.add(jLabel15, null);
  561.     jPanel3.add(jPanel15,  BorderLayout.SOUTH);
  562.     jPanel15.add(tableScrollPane4, BorderLayout.CENTER);
  563.     tableScrollPane4.getViewport().add(jdbTable4, null);
  564.     jPanel3.add(jPanel14, BorderLayout.CENTER);
  565.     jPanel14.add(jPanel16, BorderLayout.WEST);
  566.     jPanel16.add(jLabel18,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
  567.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 17, 14));
  568.     jPanel16.add(jLabel19,  new GridBagConstraints(0, 1, 1, 2, 0.0, 0.0
  569.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 13, 10));
  570.     jPanel16.add(jdbTextField1,  new GridBagConstraints(1, 0, 1, 1, 0.0, 0.0
  571.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 28, 2));
  572.     jPanel16.add(jdbTextField2,     new GridBagConstraints(1, 2, 2, 2, 0.0, 0.0
  573.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 27, 0));
  574.     jPanel14.add(jPanel17, BorderLayout.CENTER);
  575.     jPanel17.add(jdbTextArea1, BorderLayout.CENTER);
  576.     jPanel17.add(jLabel20, BorderLayout.NORTH);
  577.     jPanel14.add(jPanel18,  BorderLayout.EAST);
  578.     jPanel18.add(jButton5,  BorderLayout.NORTH);
  579.     jPanel18.add(jButton6, BorderLayout.CENTER);
  580.     jTabbedPane1.add(jPanel4, "职务信息管理");
  581.     jPanel2.add(jPanel9, BorderLayout.NORTH);
  582.     jPanel9.add(jLabel8, null);
  583.     jPanel9.add(jdbNavField2, null);
  584.     jPanel9.add(jLabel9, null);
  585.     jPanel9.add(jdbTextField11, null);
  586.     jPanel9.add(jLabel10, null);
  587.     jPanel9.add(jdbTextField9, null);
  588.     jPanel9.add(jLabel11, null);
  589.     jPanel9.add(jdbTextField10, null);
  590.     jPanel2.add(jdbNavToolBar2, BorderLayout.SOUTH);
  591.     jPanel2.add(jPanel10, BorderLayout.WEST);
  592.     jPanel10.add(jLabel12, BorderLayout.NORTH);
  593.     jPanel10.add(tableScrollPane2, BorderLayout.CENTER);
  594.     tableScrollPane2.getViewport().add(jdbTable2, null);
  595.     jPanel2.add(jPanel11, BorderLayout.EAST);
  596.     jPanel11.add(jLabel13, BorderLayout.NORTH);
  597.     jPanel11.add(tableScrollPane3, BorderLayout.CENTER);
  598.     tableScrollPane3.getViewport().add(jdbTable3, null);
  599.     jPanel2.add(jPanel12, BorderLayout.CENTER);
  600.     jPanel12.add(jButton3, new XYConstraints(4, 89, -1, 31));
  601.     jPanel12.add(jButton4, new XYConstraints(2, 153, 59, 33));
  602.     jPanel19.add(jdbRadioButton1, null);
  603.     jPanel19.add(jdbRadioButton2, null);
  604.     buttonGroup1.add(jdbRadioButton2);
  605.     buttonGroup1.add(jdbRadioButton1);
  606.     jPanel7.add(jdbNavField1, null);     jPanel13.add(jdbNavField3, null);     jPanel13.add(jdbTextField12, null);     jPanel13.add(jdbTextField13, null);     jPanel13.add(jdbTextField14, null);
  607.   }
  609.   void jButton1_actionPerformed(ActionEvent e) {
  610.     queryDataSet2.saveChanges();
  611.   }
  613.   void jButton3_actionPerformed(ActionEvent e) {
  614.     if ( queryDataSet2.isEmpty() ) return;
  615.     if ( queryDataSet1.isEmpty() ) return;
  617.     if (!queryDataSet4.isOpen()) queryDataSet4.open();
  618.     queryDataSet4.last();
  619.       int i = queryDataSet4.getInt("count_id");
  620.     queryDataSet4.setInt("count_id", ++i);
  621.     queryDataSet4.post();
  622.     queryDataSet4.saveChanges( queryDataSet4 );
  624.     if (! qSet_course.isOpen() ) qSet_course.open();
  625.     try {
  626.       qSet_course.insertRow(false);
  627.       qSet_course.setInt("count_id", i);
  628.       qSet_course.setInt("course_id", queryDataSet2.getInt("student_id"));
  629.       qSet_course.setString("course_name",
  630.                             queryDataSet2.getString("student_name"));
  631.       qSet_course.setInt("course_no", queryDataSet1.getInt("course_code"));
  632.       qSet_course.post();
  633.       qSet_course.saveChanges(qSet_course);
  634.     }catch (Exception ex ){
  635.         qSet_course.refresh();
  636.     }
  637.   }
  639.   void jButton4_actionPerformed(ActionEvent e) {
  640.     if (! qSet_course.isOpen() ) qSet_course.open();
  641.     if ( qSet_course.isEmpty() ) return;
  643.     qSet_course.deleteRow();
  644.     qSet_course.saveChanges( qSet_course );
  645.   }
  647.   void qSet_course_filterRow(ReadRow row, RowFilterResponse response) {
  648.     if ( row.getInt("course_id" )== queryDataSet2.getInt("student_id") )
  649.     {
  650.       response.add();
  651.     }else{
  652.       response.ignore();
  653.     }
  654.   }
  656.   void queryDataSet2_masterNavigating(MasterNavigateEvent e) {
  658.   }
  660.   void jPanel2_focusGained(FocusEvent e) {
  661.     qSet_course.refilter();
  662.   }
  664.   void queryDataSet2_navigated(NavigationEvent e) {
  665.     qSet_course.refilter();
  666.   }
  668. }
  670. class MainFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  671.   MainFrame adaptee;
  673.   MainFrame_jButton1_actionAdapter(MainFrame adaptee) {
  674.     this.adaptee = adaptee;
  675.   }
  676.   public void actionPerformed(ActionEvent e) {
  677.     adaptee.jButton1_actionPerformed(e);
  678.   }
  679. }
  681. class MainFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  682.   MainFrame adaptee;
  684.   MainFrame_jButton3_actionAdapter(MainFrame adaptee) {
  685.     this.adaptee = adaptee;
  686.   }
  687.   public void actionPerformed(ActionEvent e) {
  688.     adaptee.jButton3_actionPerformed(e);
  689.   }
  690. }
  692. class MainFrame_jButton4_actionAdapter implements java.awt.event.ActionListener {
  693.   MainFrame adaptee;
  695.   MainFrame_jButton4_actionAdapter(MainFrame adaptee) {
  696.     this.adaptee = adaptee;
  697.   }
  698.   public void actionPerformed(ActionEvent e) {
  699.     adaptee.jButton4_actionPerformed(e);
  700.   }
  701. }
  703. class MainFrame_qSet_course_rowFilterAdapter implements com.borland.dx.dataset.RowFilterListener {
  704.   MainFrame adaptee;
  706.   MainFrame_qSet_course_rowFilterAdapter(MainFrame adaptee) {
  707.     this.adaptee = adaptee;
  708.   }
  709.   public void filterRow(ReadRow row, RowFilterResponse response) {
  710.     adaptee.qSet_course_filterRow(row, response);
  711.   }
  712. }
  715. class MainFrame_queryDataSet2_navigationAdapter implements com.borland.dx.dataset.NavigationListener {
  716.   MainFrame adaptee;
  718.   MainFrame_queryDataSet2_navigationAdapter(MainFrame adaptee) {
  719.     this.adaptee = adaptee;
  720.   }
  721.   public void navigated(NavigationEvent e) {
  722.     adaptee.queryDataSet2_navigated(e);
  723.   }
  724. }