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

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

Java编程

开发平台：

Java

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