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

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

Java编程

开发平台：

Java

MainFrame.java~147~：源码内容
  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();
  135.   JdbNavField jdbNavField3 = new JdbNavField();
  136.   JdbTextField jdbTextField12 = new JdbTextField();
  137.   JdbTextField jdbTextField13 = new JdbTextField();
  138.   JdbTextField jdbTextField14 = new JdbTextField();
  139.   QueryDataSet qSet_jiangli = new QueryDataSet();
  140.   Column column20 = new Column();
  141.   Column column21 = new Column();
  142.   Column column22 = new Column();
  143.   Column column23 = new Column();
  144.   Column column24 = new Column();
  145.   Column column25 = new Column();
  146.   JdbNavToolBar jdbNavToolBar3 = new JdbNavToolBar();
  148.   public MainFrame() {
  149.     try {
  150.       jbInit();
  151.     }
  152.     catch (Exception e) {
  153.       e.printStackTrace();
  154.     }
  155.   }
  157.   public static void main(String[] args) {
  158.     try {
  159.       UIManager.setLookAndFeel(UIManager.getSystemLookAndFeelClassName());
  160.     }
  161.     catch (Exception e) {
  162.     }
  163.     //System.out.println(new javax.swing.UIManager());
  164.     Font f = new java.awt.Font("SansSerif", 0, 12);
  165. UIManager.put("Label.font",f);
  166. UIManager.put("Label.foreground",Color.black);
  167. UIManager.put("Button.font",f);
  168. UIManager.put("Menu.font",f);
  169. UIManager.put("MenuItem.font",f);
  170. UIManager.put("List.font",f);
  171. UIManager.put("CheckBox.font",f);
  172. UIManager.put("RadioButton.font",f);
  173. UIManager.put("ComboBox.font",f);
  174.     UIManager.put("TextArea.font",f);
  175.     UIManager.put("dbTextArea.font",f);
  176.     UIManager.put("font",f);
  178.     MainFrame mainFrame = new MainFrame();
  179.     mainFrame.setFont(new java.awt.Font("SansSerif", 0, 12));
  180.     mainFrame.pack();
  181.     mainFrame.setSize(600,450);
  182.     mainFrame.show();
  183.   }
  185.   private void jbInit() throws Exception {
  186.     font1 = new java.awt.Font("SansSerif", 0, 12);
  187.     this.getContentPane().setLayout(paneLayout1);
  188.     jPanel1.setLayout(borderLayout1);
  189.     jdbNavToolBar1.setDebugGraphicsOptions(0);
  190.     jdbNavToolBar1.setAlignment(FlowLayout.CENTER);
  191.     jPanel5.setLayout(borderLayout2);
  192.     database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:microsoft:sqlserver://localhost:1433;databaseName=student", "sa", "sa", false, "com.microsoft.jdbc.sqlserver.SQLServerDriver"));
  193.     database1.setDatabaseName("");
  194.     jPanel6.setFont(new java.awt.Font("SansSerif", 0, 12));
  195.     jPanel6.setMinimumSize(new Dimension(50, 100));
  196.     jPanel6.setPreferredSize(new Dimension(50, 110));
  197.     jPanel6.setLayout(borderLayout3);
  198.     jPanel7.setFont(new java.awt.Font("SansSerif", 0, 12));
  199.     jPanel7.setMinimumSize(new Dimension(100, 30));
  200.     jPanel7.setPreferredSize(new Dimension(100, 40));
  201.     jPanel7.setLayout(flowLayout1);
  202.     jPanel8.setFont(new java.awt.Font("SansSerif", 0, 12));
  203.     jPanel8.setMinimumSize(new Dimension(10, 10));
  204.     jPanel8.setLayout(gridBagLayout2);
  205.     jLabel1.setText("学号：");
  206.     flowLayout1.setAlignment(FlowLayout.LEFT);
  207.     jLabel2.setHorizontalAlignment(SwingConstants.RIGHT);
  208.     jLabel2.setText("姓名：");
  209.     jLabel3.setHorizontalAlignment(SwingConstants.RIGHT);
  210.     jLabel3.setText("性别：");
  211.     jLabel4.setHorizontalAlignment(SwingConstants.RIGHT);
  212.     jLabel4.setText("班级：");
  213.     jLabel5.setHorizontalAlignment(SwingConstants.RIGHT);
  214.     jLabel5.setText("生日：");
  215.     jLabel6.setHorizontalAlignment(SwingConstants.RIGHT);
  216.     jLabel6.setText("电话：");
  217.     jLabel7.setHorizontalAlignment(SwingConstants.RIGHT);
  218.     jLabel7.setText("地址：");
  219.     jButton1.setText("修改");
  220.     jButton1.addActionListener(new MainFrame_jButton1_actionAdapter(this));
  221.     jButton2.setText("取消");
  222.    jdbTable1.setFont(new java.awt.Font("SansSerif", 0, 12));
  223.     jdbTable1.setDataSet(queryDataSet2);
  224.     jTabbedPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
  225.     jTabbedPane1.setMinimumSize(new Dimension(500, 194));
  226.     jTabbedPane1.setPreferredSize(new Dimension(500, 607));
  227.     queryDataSet2.setProvider(null);
  228.     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" +
  229.       "ent_sex,student_info.student_birthday,student_info.student_tel,student_info.student_address " +
  230.       "FROM student.dbo.student_info", null, true, Load.ALL));
  231.     column8.setCaption("生日");
  232.     column8.setColumnName("student_birthday");
  233.     column8.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
  234.     column8.setDisplayMask("yyyy-MM-dd");
  235.     column8.setEditMask("yyyy-MM-dd");
  236.     column8.setSchemaName("dbo");
  237.     column8.setTableName("student_info");
  238.     column8.setWidth(10);
  239.     column8.setServerColumnName("student_birthday");
  240.     column8.setSqlType(93);
  241.     column9.setCaption("学号");
  242.     column9.setColumnName("student_id");
  243.     column9.setDataType(com.borland.dx.dataset.Variant.INT);
  244.     column9.setEditMask("######");
  245.     column9.setFont(new java.awt.Font("SansSerif", 0, 12));
  246.     column9.setRowId(true);
  247.     column9.setSchemaName("dbo");
  248.     column9.setTableName("student_info");
  249.     column9.setWidth(10);
  250.     column9.setServerColumnName("student_id");
  251.     column9.setSqlType(4);
  252.     column10.setCaption("姓名");
  253.     column10.setColumnName("student_name");
  254.     column10.setDataType(com.borland.dx.dataset.Variant.STRING);
  255.     column10.setPrecision(50);
  256.     column10.setSchemaName("dbo");
  257.     column10.setTableName("student_info");
  258.     column10.setWidth(10);
  259.     column10.setServerColumnName("student_name");
  260.     column10.setSqlType(12);
  261.     column11.setCaption("班级");
  262.     column11.setColumnName("student_class");
  263.     column11.setDataType(com.borland.dx.dataset.Variant.INT);
  264.     column11.setSchemaName("dbo");
  265.     column11.setTableName("student_info");
  266.     column11.setWidth(10);
  267.     column11.setServerColumnName("student_class");
  268.     column11.setSqlType(4);
  269.     column12.setCaption("性别");
  270.     column12.setColumnName("student_sex");
  271.     column12.setDataType(com.borland.dx.dataset.Variant.STRING);
  272.     column12.setPrecision(50);
  273.     column12.setSchemaName("dbo");
  274.     column12.setTableName("student_info");
  275.     column12.setWidth(10);
  276.     column12.setServerColumnName("student_sex");
  277.     column12.setSqlType(12);
  278.     column13.setCaption("联系电话");
  279.     column13.setColumnName("student_tel");
  280.     column13.setDataType(com.borland.dx.dataset.Variant.STRING);
  281.     column13.setPrecision(50);
  282.     column13.setSchemaName("dbo");
  283.     column13.setTableName("student_info");
  284.     column13.setWidth(10);
  285.     column13.setServerColumnName("student_tel");
  286.     column13.setSqlType(12);
  287.     column14.setCaption("联系地址");
  288.     column14.setColumnName("student_address");
  289.     column14.setDataType(com.borland.dx.dataset.Variant.STRING);
  290.     column14.setPrecision(150);
  291.     column14.setSchemaName("dbo");
  292.     column14.setTableName("student_info");
  293.     column14.setWidth(14);
  294.     column14.setServerColumnName("student_address");
  295.     column14.setSqlType(12);
  296.     queryDataSet2.setColumns(new Column[] {column9, column10, column11, column12, column8, column13, column14});
  297.     queryDataSet2.addNavigationListener(new MainFrame_queryDataSet2_navigationAdapter(this));
  298.     jPanel1.setFont(new java.awt.Font("SansSerif", 0, 12));
  299.     jPanel1.setPreferredSize(new Dimension(472, 580));
  300.     jPanel5.setFont(new java.awt.Font("SansSerif", 0, 12));
  301.     tableScrollPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
  302.     tableScrollPane1.getViewport().setFont(new java.awt.Font("SansSerif", 0, 12));
  303.     this.setFont(new java.awt.Font("SansSerif", 0, 12));
  304.     jPanel2.setFont(new java.awt.Font("SansSerif", 0, 12));
  305.     jPanel2.setLayout(borderLayout4);
  306.     jLabel8.setText("学号：");
  307.     jLabel9.setRequestFocusEnabled(true);
  308.     jLabel9.setText("姓名: ");
  309.     jLabel10.setText("班级: ");
  310.     jLabel11.setText("性别: ");
  311.     jdbNavToolBar2.setEnabled(false);
  312.     jdbNavToolBar2.setAlignment(FlowLayout.CENTER);
  313.     jPanel10.setMinimumSize(new Dimension(300, 10));
  314.     jPanel10.setPreferredSize(new Dimension(300, 10));
  315.     jPanel10.setLayout(borderLayout5);
  316.     jLabel12.setText("学校设置可选课程信息");
  317.     jPanel11.setMinimumSize(new Dimension(200, 10));
  318.     jPanel11.setPreferredSize(new Dimension(200, 10));
  319.     jPanel11.setLayout(borderLayout6);
  320.     jLabel13.setText("个人已选课程信息");
  321.     jButton3.setText("选课");
  322.     jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
  323.     jButton4.setText("退课");
  324.     jButton4.addActionListener(new MainFrame_jButton4_actionAdapter(this));
  325.     jPanel12.setLayout(xYLayout1);
  326.     queryDataSet1.setReadOnly(false);
  327.     queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_coursecode.course_code,student_coursecode.course_name,student_coursecode.course_period" +
  328.       ",student_coursecode.course_credit,student_coursecode.course_teacher,student_coursecode.course_address" +
  329.       " FROM student.dbo.student_coursecode", null, true, Load.ALL));
  330.     column1.setCaption("课程代号");
  331.     column1.setColumnName("course_code");
  332.     column1.setDataType(com.borland.dx.dataset.Variant.INT);
  333.     column1.setRowId(true);
  334.     column1.setSchemaName("dbo");
  335.     column1.setTableName("student_coursecode");
  336.     column1.setWidth(10);
  337.     column1.setServerColumnName("course_code");
  338.     column1.setSqlType(4);
  339.     column2.setCaption("课程名称");
  340.     column2.setColumnName("course_name");
  341.     column2.setDataType(com.borland.dx.dataset.Variant.STRING);
  342.     column2.setPrecision(50);
  343.     column2.setSchemaName("dbo");
  344.     column2.setTableName("student_coursecode");
  345.     column2.setWidth(10);
  346.     column2.setServerColumnName("course_name");
  347.     column2.setSqlType(12);
  348.     column3.setCaption("课程学时");
  349.     column3.setColumnName("course_period");
  350.     column3.setDataType(com.borland.dx.dataset.Variant.INT);
  351.     column3.setSchemaName("dbo");
  352.     column3.setTableName("student_coursecode");
  353.     column3.setWidth(10);
  354.     column3.setServerColumnName("course_period");
  355.     column3.setSqlType(4);
  356.     column4.setCaption("课程学分");
  357.     column4.setColumnName("course_credit");
  358.     column4.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
  359.     column4.setSchemaName("dbo");
  360.     column4.setTableName("student_coursecode");
  361.     column4.setWidth(10);
  362.     column4.setServerColumnName("course_credit");
  363.     column4.setSqlType(6);
  364.     column5.setCaption("任课老师");
  365.     column5.setColumnName("course_teacher");
  366.     column5.setDataType(com.borland.dx.dataset.Variant.STRING);
  367.     column5.setPrecision(50);
  368.     column5.setSchemaName("dbo");
  369.     column5.setTableName("student_coursecode");
  370.     column5.setWidth(10);
  371.     column5.setServerColumnName("course_teacher");
  372.     column5.setSqlType(12);
  373.     column6.setCaption("上课地点");
  374.     column6.setColumnName("course_address");
  375.     column6.setDataType(com.borland.dx.dataset.Variant.STRING);
  376.     column6.setPrecision(50);
  377.     column6.setSchemaName("dbo");
  378.     column6.setTableName("student_coursecode");
  379.     column6.setWidth(10);
  380.     column6.setServerColumnName("course_address");
  381.     column6.setSqlType(12);
  382.     queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
  383.     jdbTable2.setDataSet(queryDataSet1);
  384.     jdbTable2.setEditable(false);
  385.     column7.setCaption("学生姓名");
  386.     column7.setColumnName("course_name");
  387.     column7.setDataType(com.borland.dx.dataset.Variant.STRING);
  388.     column7.setPrecision(50);
  389.     column7.setSchemaName("dbo");
  390.     column7.setTableName("student_course");
  391.     column7.setWidth(10);
  392.     column7.setServerColumnName("course_name");
  393.     column7.setSqlType(12);
  394.     jLabel14.setText("学号：");
  395.     jLabel15.setText("性别: ");
  396.     jLabel16.setRequestFocusEnabled(true);
  397.     jLabel16.setText("姓名: ");
  398.     jLabel17.setText("班级: ");
  399.     jPanel3.setLayout(borderLayout7);
  400.     jPanel15.setMinimumSize(new Dimension(200, 100));
  401.     jPanel15.setPreferredSize(new Dimension(200, 250));
  402.     jPanel15.setLayout(borderLayout8);
  403.     jPanel14.setLayout(borderLayout9);
  404.     jPanel14.setMinimumSize(new Dimension(300, 50));
  405.     jPanel14.setPreferredSize(new Dimension(300, 50));
  406.     jPanel14.setVerifyInputWhenFocusTarget(true);
  407.     jPanel13.setPreferredSize(new Dimension(404, 40));
  408.     jPanel16.setPreferredSize(new Dimension(280, 10));
  409.     jPanel16.setLayout(gridBagLayout1);
  410.     jLabel18.setText("获奖时间:");
  411.     jLabel19.setText("获奖名称:");
  412.     jdbTextField1.setText("jdbTextField1");
  413.     jdbTextField1.setColumnName("gcheck_time");
  414.     jdbTextField1.setDataSet(qSet_jiangli);
  415.     jdbTextField2.setText("jdbTextField2");
  416.     jdbTextField2.setColumnName("gcheck_title");
  417.     jdbTextField2.setDataSet(qSet_jiangli);
  418.     jdbTextArea1.setText("jdbTextArea1");
  419.     jdbTextArea1.setColumnName("gcheck_disc");
  420.     jdbTextArea1.setDataSet(qSet_jiangli);
  421.     jPanel17.setLayout(borderLayout10);
  422.     jButton5.setText("增加");
  423.     jButton6.setText("取消");
  424.     jPanel18.setLayout(borderLayout11);
  425.     borderLayout11.setVgap(10);
  426.     jLabel20.setText("获奖内容具体描述:");
  427.     jdbTextField3.setEnabled(true);
  428.     jdbTextField3.setAlignmentX((float) 0.5);
  429.     jdbTextField3.setDoubleBuffered(false);
  430.     jdbTextField3.setMinimumSize(new Dimension(10, 22));
  431.     jdbTextField3.setPreferredSize(new Dimension(15, 22));
  432.     jdbTextField3.setMargin(new Insets(1, 3, 1, 3));
  433.     jdbTextField3.setText("");
  434.     jdbTextField3.setHorizontalAlignment(SwingConstants.LEFT);
  435.     jdbTextField3.setColumnName("student_name");
  436.     jdbTextField3.setDataSet(queryDataSet2);
  437.     jdbTextField3.setEnablePopupMenu(true);
  438.     jdbTextField3.setPostOnFocusLost(true);
  439.     jdbTextField4.setDebugGraphicsOptions(0);
  440.     jdbTextField4.setText("jdbTextField4");
  441.     jdbTextField4.setColumnName("student_class");
  442.     jdbTextField4.setDataSet(queryDataSet2);
  443.     jdbTextField5.setText("jdbTextField5");
  444.     jdbTextField5.setColumnName("student_tel");
  445.     jdbTextField5.setDataSet(queryDataSet2);
  446.     jdbTextField7.setDisabledTextColor(Color.gray);
  447.     jdbTextField7.setText("jdbTextField7");
  448.     jdbTextField7.setColumnName("student_birthday");
  449.     jdbTextField7.setDataSet(queryDataSet2);
  450.     jdbTextField8.setText("jdbTextField8");
  451.     jdbTextField8.setColumnName("student_address");
  452.     jdbTextField8.setDataSet(queryDataSet2);
  453.     jdbRadioButton2.setSelected(false);
  454.     jdbRadioButton2.setText("女");
  455.     jdbRadioButton2.setButtonGroup(buttonGroup1);
  456.     jdbRadioButton2.setColumnName("student_sex");
  457.     jdbRadioButton2.setDataSet(queryDataSet2);
  458.     jdbRadioButton2.setSelectedDataValue("女");
  459.     jdbRadioButton1.setActionCommand("男");
  460.     jdbRadioButton1.setContentAreaFilled(true);
  461.     jdbRadioButton1.setSelected(true);
  462.     jdbRadioButton1.setText("男");
  463.     jdbRadioButton1.setButtonGroup(buttonGroup1);
  464.     jdbRadioButton1.setColumnName("student_sex");
  465.     jdbRadioButton1.setDataSet(queryDataSet2);
  466.     jdbRadioButton1.setSelectedDataValue("男");
  467.     jdbNavField1.setMinimumSize(new Dimension(100, 22));
  468.     jdbNavField1.setPreferredSize(new Dimension(100, 22));
  469.     jdbNavField1.setText("jdbNavField1");
  470.     jdbNavField1.setColumnName("student_id");
  471.     jdbNavField1.setDataSet(queryDataSet2);
  472.     jdbTextField9.setEnabled(true);
  473.     jdbTextField9.setPreferredSize(new Dimension(70, 22));
  474.     jdbTextField9.setEditable(false);
  475.     jdbTextField9.setText("jdbTextField9");
  476.     jdbTextField9.setColumns(0);
  477.     jdbTextField9.setColumnName("student_class");
  478.     jdbTextField9.setDataSet(queryDataSet2);
  479.     jdbTextField10.setEnabled(true);
  480.     jdbTextField10.setPreferredSize(new Dimension(50, 22));
  481.     jdbTextField10.setEditable(false);
  482.     jdbTextField10.setText("jdbTextField10");
  483.     jdbTextField10.setColumnName("student_sex");
  484.     jdbTextField10.setDataSet(queryDataSet2);
  485.     queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_count.count_id FROM student.dbo.student_count", null, true, Load.ALL));
  486.     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" +
  487.       "rse_no FROM student.dbo.student_course", null, true, Load.ALL));
  488.     column15.setColumnName("count_id");
  489.     column15.setDataType(com.borland.dx.dataset.Variant.INT);
  490.     column15.setRowId(true);
  491.     column15.setSchemaName("dbo");
  492.     column15.setTableName("student_course");
  493.     column15.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  494.     column15.setServerColumnName("count_id");
  495.     column15.setSqlType(4);
  496.     column16.setColumnName("course_id");
  497.     column16.setDataType(com.borland.dx.dataset.Variant.INT);
  498.     column16.setSchemaName("dbo");
  499.     column16.setTableName("student_course");
  500.     column16.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  501.     column16.setServerColumnName("course_id");
  502.     column16.setSqlType(4);
  503.     column18.setCaption("学生姓名");
  504.     column18.setColumnName("course_name");
  505.     column18.setDataType(com.borland.dx.dataset.Variant.STRING);
  506.     column18.setPrecision(50);
  507.     column18.setSchemaName("dbo");
  508.     column18.setTableName("student_course");
  509.     column18.setWidth(10);
  510.     column18.setServerColumnName("course_name");
  511.     column18.setSqlType(12);
  512.     column19.setCaption("所选课程编号");
  513.     column19.setColumnName("course_no");
  514.     column19.setDataType(com.borland.dx.dataset.Variant.INT);
  515.     column19.setSchemaName("dbo");
  516.     column19.setTableName("student_course");
  517.     column19.setServerColumnName("course_no");
  518.     column19.setSqlType(4);
  519.     qSet_course.setColumns(new Column[] {column15, column16, column18, column19});
  520.     qSet_course.addRowFilterListener(new MainFrame_qSet_course_rowFilterAdapter(this));
  521.     jdbTable3.setDataSet(qSet_course);
  522.     jdbTextField11.setMinimumSize(new Dimension(70, 22));
  523.     jdbTextField11.setPreferredSize(new Dimension(70, 22));
  524.     jdbTextField11.setEditable(false);
  525.     jdbTextField11.setText("jdbTextField11");
  526.     jdbTextField11.setColumnName("student_name");
  527.     jdbTextField11.setDataSet(queryDataSet2);
  528.     jdbNavField2.setDataSet(queryDataSet2);
  529.     jdbNavField2.setColumnName("student_id");
  530.     jdbNavField2.setPreferredSize(new Dimension(70, 22));
  531.     jdbNavField2.setMinimumSize(new Dimension(70, 22));
  532.     jdbNavField3.setMinimumSize(new Dimension(70, 22));
  533.     jdbNavField3.setPreferredSize(new Dimension(70, 22));
  534.     jdbNavField3.setColumnName("student_id");
  535.     jdbNavField3.setDataSet(queryDataSet2);
  536.     jdbTextField12.setDataSet(queryDataSet2);
  537.     jdbTextField12.setColumnName("student_name");
  538.     jdbTextField12.setText("jdbTextField11");
  539.     jdbTextField12.setEditable(false);
  540.     jdbTextField12.setPreferredSize(new Dimension(70, 22));
  541.     jdbTextField12.setMinimumSize(new Dimension(70, 22));
  542.     jdbTextField13.setDataSet(queryDataSet2);
  543.     jdbTextField13.setColumnName("student_class");
  544.     jdbTextField13.setColumns(0);
  545.     jdbTextField13.setText("jdbTextField9");
  546.     jdbTextField13.setEditable(false);
  547.     jdbTextField13.setPreferredSize(new Dimension(70, 22));
  548.     jdbTextField13.setEnabled(true);
  549.     jdbTextField14.setDataSet(queryDataSet2);
  550.     jdbTextField14.setColumnName("student_sex");
  551.     jdbTextField14.setText("jdbTextField10");
  552.     jdbTextField14.setEditable(false);
  553.     jdbTextField14.setPreferredSize(new Dimension(50, 22));
  554.     jdbTextField14.setEnabled(true);
  555.     qSet_jiangli.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_gcheck.gcheck_id,student_gcheck.gcheck_no,student_gcheck.gcheck_name,student_gcheck.gc" +
  556.       "heck_time,student_gcheck.gcheck_title,student_gcheck.gcheck_disc " +
  557.       "FROM student.dbo.student_gcheck", null, true, Load.ALL));
  558.     column20.setCaption("获奖时间");
  559.     column20.setColumnName("gcheck_time");
  560.     column20.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
  561.     column20.setEditMask("yyyy-MM-dd");
  562.     column20.setDisplayMask( "yyyy-MM-dd");
  563.     column20.setSchemaName("dbo");
  564.     column20.setTableName("student_gcheck");
  565.     column20.setServerColumnName("gcheck_time");
  566.     column20.setSqlType(93);
  567.     jdbTable4.setDataSet(qSet_jiangli);
  568.     column21.setColumnName("gcheck_id");
  569.     column21.setDataType(com.borland.dx.dataset.Variant.INT);
  570.     column21.setRowId(true);
  571.     column21.setSchemaName("dbo");
  572.     column21.setTableName("student_gcheck");
  573.     column21.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  574.     column21.setServerColumnName("gcheck_id");
  575.     column21.setSqlType(4);
  576.     column22.setColumnName("gcheck_no");
  577.     column22.setDataType(com.borland.dx.dataset.Variant.INT);
  578.     column22.setSchemaName("dbo");
  579.     column22.setTableName("student_gcheck");
  580.     column22.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  581.     column22.setServerColumnName("gcheck_no");
  582.     column22.setSqlType(4);
  583.     column23.setColumnName("gcheck_name");
  584.     column23.setDataType(com.borland.dx.dataset.Variant.STRING);
  585.     column23.setPrecision(10);
  586.     column23.setSchemaName("dbo");
  587.     column23.setTableName("student_gcheck");
  588.     column23.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
  589.     column23.setServerColumnName("gcheck_name");
  590.     column23.setSqlType(1);
  591.     column24.setCaption("获奖名称");
  592.     column24.setColumnName("gcheck_title");
  593.     column24.setDataType(com.borland.dx.dataset.Variant.STRING);
  594.     column24.setPrecision(50);
  595.     column24.setSchemaName("dbo");
  596.     column24.setTableName("student_gcheck");
  597.     column24.setWidth(20);
  598.     column24.setServerColumnName("gcheck_title");
  599.     column24.setSqlType(12);
  600.     column25.setCaption("具体说明");
  601.     column25.setColumnName("gcheck_disc");
  602.     column25.setDataType(com.borland.dx.dataset.Variant.STRING);
  603.     column25.setPrecision(50);
  604.     column25.setSchemaName("dbo");
  605.     column25.setTableName("student_gcheck");
  606.     column25.setWidth(25);
  607.     column25.setServerColumnName("gcheck_disc");
  608.     column25.setSqlType(12);
  609.     qSet_jiangli.setColumns(new Column[] {column21, column22, column23, column20, column24, column25});
  610.     jdbNavToolBar3.setAlignment(FlowLayout.CENTER);
  611.     this.getContentPane().add(jTabbedPane1,
  612.                               new PaneConstraints("jTabbedPane1", "jTabbedPane1",
  613.                                                   PaneConstraints.ROOT, 1.0f));
  614.     jTabbedPane1.add(jPanel1, "个人信息管理");
  615.     jPanel1.add(jPanel5, BorderLayout.CENTER);
  616.     jPanel5.add(jdbNavToolBar1, BorderLayout.SOUTH);
  617.     jPanel5.add(jPanel6, BorderLayout.NORTH);
  618.     jPanel6.add(jPanel7, BorderLayout.NORTH);
  619.     jPanel7.add(jLabel1, null);
  620.     jPanel6.add(jPanel8, BorderLayout.CENTER);
  621.     jPanel8.add(jLabel2,    new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
  622.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 28, 19));
  623.     jPanel8.add(jdbTextField3,      new GridBagConstraints(1, 0, 2, 1, 1.0, 0.0
  624.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 75, 13));
  625.     jPanel8.add(jLabel4,     new GridBagConstraints(3, 0, 1, 1, 0.0, 0.0
  626.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 31, 19));
  627.     jPanel8.add(jdbTextField4,   new GridBagConstraints(4, 0, 1, 1, 1.0, 0.0
  628.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  629.     jPanel8.add(jLabel6,   new GridBagConstraints(5, 0, 1, 1, 0.0, 0.0
  630.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
  631.     jPanel8.add(jdbTextField5,   new GridBagConstraints(6, 0, 1, 1, 1.0, 0.0
  632.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  633.     jPanel8.add(jButton1,   new GridBagConstraints(7, 0, 1, 1, 0.0, 0.0
  634.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
  635.     jPanel8.add(jLabel3,    new GridBagConstraints(0, 1, 1, 1, 0.0, 0.0
  636.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 30, 19));
  637.     jPanel8.add(jPanel19,     new GridBagConstraints(2, 1, 1, 1, 1.0, 1.0
  638.             ,GridBagConstraints.CENTER, GridBagConstraints.VERTICAL, new Insets(0, 0, 0, 0), -3, 25));
  639.     jPanel8.add(jLabel5,            new GridBagConstraints(3, 1, 1, 1, 0.0, 0.0
  640.             ,GridBagConstraints.EAST, GridBagConstraints.NONE, new Insets(0, 0, 0, 1), 30, 19));
  641.     jPanel8.add(jdbTextField7,   new GridBagConstraints(4, 1, 1, 1, 1.0, 0.0
  642.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 7, 13));
  643.     jPanel8.add(jLabel7,   new GridBagConstraints(5, 1, 1, 1, 0.0, 0.0
  644.             ,GridBagConstraints.WEST, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 40, 19));
  645.     jPanel8.add(jdbTextField8,   new GridBagConstraints(6, 1, 1, 1, 1.0, 0.0
  646.             ,GridBagConstraints.WEST, GridBagConstraints.HORIZONTAL, new Insets(0, 0, 0, 0), 57, 13));
  647.     jPanel8.add(jButton2,   new GridBagConstraints(7, 1, 1, 1, 0.0, 0.0
  648.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 3), 16, 10));
  649.     jPanel5.add(tableScrollPane1, BorderLayout.CENTER);
  650.     tableScrollPane1.getViewport().add(jdbTable1, null);
  651.     jTabbedPane1.add(jPanel2, "选课信息管理");
  652.     jTabbedPane1.add(jPanel3, "奖励信息管理");
  653.     jPanel3.add(jPanel13, BorderLayout.NORTH);
  654.     jPanel13.add(jLabel14, null);
  655.     jPanel13.add(jdbNavField3, null);
  656.     jPanel13.add(jLabel16, null);
  657.     jPanel13.add(jdbTextField12, null);
  658.     jPanel13.add(jLabel17, null);
  659.     jPanel13.add(jdbTextField13, null);
  660.     jPanel13.add(jLabel15, null);
  661.     jPanel3.add(jPanel15,  BorderLayout.SOUTH);
  662.     jPanel15.add(tableScrollPane4, BorderLayout.CENTER);
  663.     jPanel15.add(jdbNavToolBar3,  BorderLayout.SOUTH);
  664.     tableScrollPane4.getViewport().add(jdbTable4, null);
  665.     jPanel3.add(jPanel14, BorderLayout.CENTER);
  666.     jPanel14.add(jPanel16, BorderLayout.WEST);
  667.     jPanel16.add(jLabel18,  new GridBagConstraints(0, 0, 1, 1, 0.0, 0.0
  668.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 17, 14));
  669.     jPanel16.add(jLabel19,  new GridBagConstraints(0, 1, 1, 2, 0.0, 0.0
  670.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 13, 10));
  671.     jPanel16.add(jdbTextField1,   new GridBagConstraints(1, 0, 2, 1, 0.0, 0.0
  672.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 89, 2));
  673.     jPanel16.add(jdbTextField2,        new GridBagConstraints(1, 2, 3, 2, 0.0, 0.0
  674.             ,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 0, 0, 0), 91, 0));
  675.     jPanel14.add(jPanel17, BorderLayout.CENTER);
  676.     jPanel17.add(jdbTextArea1, BorderLayout.CENTER);
  677.     jPanel17.add(jLabel20, BorderLayout.NORTH);
  678.     jPanel14.add(jPanel18,  BorderLayout.EAST);
  679.     jPanel18.add(jButton5,  BorderLayout.NORTH);
  680.     jPanel18.add(jButton6, BorderLayout.CENTER);
  681.     jTabbedPane1.add(jPanel4, "职务信息管理");
  682.     jPanel2.add(jPanel9, BorderLayout.NORTH);
  683.     jPanel9.add(jLabel8, null);
  684.     jPanel9.add(jdbNavField2, null);
  685.     jPanel9.add(jLabel9, null);
  686.     jPanel9.add(jdbTextField11, null);
  687.     jPanel9.add(jLabel10, null);
  688.     jPanel9.add(jdbTextField9, null);
  689.     jPanel9.add(jLabel11, null);
  690.     jPanel9.add(jdbTextField10, null);
  691.     jPanel2.add(jdbNavToolBar2, BorderLayout.SOUTH);
  692.     jPanel2.add(jPanel10, BorderLayout.WEST);
  693.     jPanel10.add(jLabel12, BorderLayout.NORTH);
  694.     jPanel10.add(tableScrollPane2, BorderLayout.CENTER);
  695.     tableScrollPane2.getViewport().add(jdbTable2, null);
  696.     jPanel2.add(jPanel11, BorderLayout.EAST);
  697.     jPanel11.add(jLabel13, BorderLayout.NORTH);
  698.     jPanel11.add(tableScrollPane3, BorderLayout.CENTER);
  699.     tableScrollPane3.getViewport().add(jdbTable3, null);
  700.     jPanel2.add(jPanel12, BorderLayout.CENTER);
  701.     jPanel12.add(jButton3, new XYConstraints(4, 89, -1, 31));
  702.     jPanel12.add(jButton4, new XYConstraints(2, 153, 59, 33));
  703.     jPanel19.add(jdbRadioButton1, null);
  704.     jPanel19.add(jdbRadioButton2, null);
  705.     buttonGroup1.add(jdbRadioButton2);
  706.     buttonGroup1.add(jdbRadioButton1);
  707.     jPanel7.add(jdbNavField1, null);
  708.     jPanel13.add(jdbTextField14, null);
  709.   }
  711.   void jButton1_actionPerformed(ActionEvent e) {
  712.     queryDataSet2.saveChanges();
  713.   }
  715.   void jButton3_actionPerformed(ActionEvent e) {
  716.     if ( queryDataSet2.isEmpty() ) return;
  717.     if ( queryDataSet1.isEmpty() ) return;
  719.     if (!queryDataSet4.isOpen()) queryDataSet4.open();
  720.     queryDataSet4.last();
  721.       int i = queryDataSet4.getInt("count_id");
  722.     queryDataSet4.setInt("count_id", ++i);
  723.     queryDataSet4.post();
  724.     queryDataSet4.saveChanges( queryDataSet4 );
  726.     if (! qSet_course.isOpen() ) qSet_course.open();
  727.     try {
  728.       qSet_course.insertRow(false);
  729.       qSet_course.setInt("count_id", i);
  730.       qSet_course.setInt("course_id", queryDataSet2.getInt("student_id"));
  731.       qSet_course.setString("course_name",
  732.                             queryDataSet2.getString("student_name"));
  733.       qSet_course.setInt("course_no", queryDataSet1.getInt("course_code"));
  734.       qSet_course.post();
  735.       qSet_course.saveChanges(qSet_course);
  736.     }catch (Exception ex ){
  737.         qSet_course.refresh();
  738.     }
  739.   }
  741.   void jButton4_actionPerformed(ActionEvent e) {
  742.     if (! qSet_course.isOpen() ) qSet_course.open();
  743.     if ( qSet_course.isEmpty() ) return;
  745.     qSet_course.deleteRow();
  746.     qSet_course.saveChanges( qSet_course );
  747.   }
  749.   void qSet_course_filterRow(ReadRow row, RowFilterResponse response) {
  750.     if ( row.getInt("course_id" )== queryDataSet2.getInt("student_id") )
  751.     {
  752.       response.add();
  753.     }else{
  754.       response.ignore();
  755.     }
  756.   }
  758.   void queryDataSet2_masterNavigating(MasterNavigateEvent e) {
  760.   }
  762.   void jPanel2_focusGained(FocusEvent e) {
  763.     qSet_course.refilter();
  764.   }
  766.   void queryDataSet2_navigated(NavigationEvent e) {
  767.     qSet_course.refilter();
  768.   }
  770. }
  772. class MainFrame_jButton1_actionAdapter implements java.awt.event.ActionListener {
  773.   MainFrame adaptee;
  775.   MainFrame_jButton1_actionAdapter(MainFrame adaptee) {
  776.     this.adaptee = adaptee;
  777.   }
  778.   public void actionPerformed(ActionEvent e) {
  779.     adaptee.jButton1_actionPerformed(e);
  780.   }
  781. }
  783. class MainFrame_jButton3_actionAdapter implements java.awt.event.ActionListener {
  784.   MainFrame adaptee;
  786.   MainFrame_jButton3_actionAdapter(MainFrame adaptee) {
  787.     this.adaptee = adaptee;
  788.   }
  789.   public void actionPerformed(ActionEvent e) {
  790.     adaptee.jButton3_actionPerformed(e);
  791.   }
  792. }
  794. class MainFrame_jButton4_actionAdapter implements java.awt.event.ActionListener {
  795.   MainFrame adaptee;
  797.   MainFrame_jButton4_actionAdapter(MainFrame adaptee) {
  798.     this.adaptee = adaptee;
  799.   }
  800.   public void actionPerformed(ActionEvent e) {
  801.     adaptee.jButton4_actionPerformed(e);
  802.   }
  803. }
  805. class MainFrame_qSet_course_rowFilterAdapter implements com.borland.dx.dataset.RowFilterListener {
  806.   MainFrame adaptee;
  808.   MainFrame_qSet_course_rowFilterAdapter(MainFrame adaptee) {
  809.     this.adaptee = adaptee;
  810.   }
  811.   public void filterRow(ReadRow row, RowFilterResponse response) {
  812.     adaptee.qSet_course_filterRow(row, response);
  813.   }
  814. }
  817. class MainFrame_queryDataSet2_navigationAdapter implements com.borland.dx.dataset.NavigationListener {
  818.   MainFrame adaptee;
  820.   MainFrame_queryDataSet2_navigationAdapter(MainFrame adaptee) {
  821.     this.adaptee = adaptee;
  822.   }
  823.   public void navigated(NavigationEvent e) {
  824.     adaptee.queryDataSet2_navigated(e);
  825.   }
  826. }