?? mainframe.java
字號:
column13.setTableName("student_info");
column13.setWidth(10);
column13.setServerColumnName("student_tel");
column13.setSqlType(12);
column14.setCaption("聯系地址");
column14.setColumnName("student_address");
column14.setDataType(com.borland.dx.dataset.Variant.STRING);
column14.setPrecision(150);
column14.setSchemaName("dbo");
column14.setTableName("student_info");
column14.setWidth(14);
column14.setServerColumnName("student_address");
column14.setSqlType(12);
queryDataSet2.setColumns(new Column[] {column9, column10, column11, column12, column8, column13, column14});
queryDataSet2.addNavigationListener(new MainFrame_queryDataSet2_navigationAdapter(this));
jPanel1.setFont(new java.awt.Font("SansSerif", 0, 12));
jPanel1.setPreferredSize(new Dimension(472, 580));
jPanel5.setFont(new java.awt.Font("SansSerif", 0, 12));
tableScrollPane1.setFont(new java.awt.Font("SansSerif", 0, 12));
tableScrollPane1.getViewport().setFont(new java.awt.Font("SansSerif", 0, 12));
this.setFont(new java.awt.Font("SansSerif", 0, 12));
jPanel2.setFont(new java.awt.Font("SansSerif", 0, 12));
jPanel2.setLayout(borderLayout4);
jLabel8.setText("學號：");
jLabel9.setRequestFocusEnabled(true);
jLabel9.setText("姓名: ");
jLabel10.setText("班級: ");
jLabel11.setText("性別: ");
jdbNavToolBar2.setEnabled(false);
jdbNavToolBar2.setAlignment(FlowLayout.CENTER);
jPanel10.setMinimumSize(new Dimension(300, 10));
jPanel10.setPreferredSize(new Dimension(300, 10));
jPanel10.setLayout(borderLayout5);
jLabel12.setText("學校設置可選課程信息");
jPanel11.setMinimumSize(new Dimension(200, 10));
jPanel11.setPreferredSize(new Dimension(200, 10));
jPanel11.setLayout(borderLayout6);
jLabel13.setText("個人已選課程信息");
jButton3.setText("選課");
jButton3.addActionListener(new MainFrame_jButton3_actionAdapter(this));
jButton4.setText("退課");
jButton4.addActionListener(new MainFrame_jButton4_actionAdapter(this));
jPanel12.setLayout(xYLayout1);
queryDataSet1.setReadOnly(false);
queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_coursecode.course_code,student_coursecode.course_name,student_coursecode.course_period" +
",student_coursecode.course_credit,student_coursecode.course_teacher,student_coursecode.course_address" +
" FROM student.dbo.student_coursecode", null, true, Load.ALL));
column1.setCaption("課程代號");
column1.setColumnName("course_code");
column1.setDataType(com.borland.dx.dataset.Variant.INT);
column1.setRowId(true);
column1.setSchemaName("dbo");
column1.setTableName("student_coursecode");
column1.setWidth(10);
column1.setServerColumnName("course_code");
column1.setSqlType(4);
column2.setCaption("課程名稱");
column2.setColumnName("course_name");
column2.setDataType(com.borland.dx.dataset.Variant.STRING);
column2.setPrecision(50);
column2.setSchemaName("dbo");
column2.setTableName("student_coursecode");
column2.setWidth(10);
column2.setServerColumnName("course_name");
column2.setSqlType(12);
column3.setCaption("課程學時");
column3.setColumnName("course_period");
column3.setDataType(com.borland.dx.dataset.Variant.INT);
column3.setSchemaName("dbo");
column3.setTableName("student_coursecode");
column3.setWidth(10);
column3.setServerColumnName("course_period");
column3.setSqlType(4);
column4.setCaption("課程學分");
column4.setColumnName("course_credit");
column4.setDataType(com.borland.dx.dataset.Variant.DOUBLE);
column4.setSchemaName("dbo");
column4.setTableName("student_coursecode");
column4.setWidth(10);
column4.setServerColumnName("course_credit");
column4.setSqlType(6);
column5.setCaption("任課老師");
column5.setColumnName("course_teacher");
column5.setDataType(com.borland.dx.dataset.Variant.STRING);
column5.setPrecision(50);
column5.setSchemaName("dbo");
column5.setTableName("student_coursecode");
column5.setWidth(10);
column5.setServerColumnName("course_teacher");
column5.setSqlType(12);
column6.setCaption("上課地點");
column6.setColumnName("course_address");
column6.setDataType(com.borland.dx.dataset.Variant.STRING);
column6.setPrecision(50);
column6.setSchemaName("dbo");
column6.setTableName("student_coursecode");
column6.setWidth(10);
column6.setServerColumnName("course_address");
column6.setSqlType(12);
queryDataSet1.setColumns(new Column[] {column1, column2, column3, column4, column5, column6});
jdbTable2.setDataSet(queryDataSet1);
jdbTable2.setEditable(false);
column7.setCaption("學生姓名");
column7.setColumnName("course_name");
column7.setDataType(com.borland.dx.dataset.Variant.STRING);
column7.setPrecision(50);
column7.setSchemaName("dbo");
column7.setTableName("student_course");
column7.setWidth(10);
column7.setServerColumnName("course_name");
column7.setSqlType(12);
jLabel14.setText("學號：");
jLabel15.setText("性別: ");
jLabel16.setRequestFocusEnabled(true);
jLabel16.setText("姓名: ");
jLabel17.setText("班級: ");
jPanel3.setLayout(borderLayout7);
jPanel15.setMinimumSize(new Dimension(200, 100));
jPanel15.setPreferredSize(new Dimension(200, 250));
jPanel15.setLayout(borderLayout8);
jPanel14.setLayout(borderLayout9);
jPanel14.setMinimumSize(new Dimension(300, 50));
jPanel14.setPreferredSize(new Dimension(300, 50));
jPanel14.setVerifyInputWhenFocusTarget(true);
jPanel13.setPreferredSize(new Dimension(404, 40));
jPanel16.setPreferredSize(new Dimension(280, 10));
jPanel16.setLayout(gridBagLayout1);
jLabel18.setText("獲獎時間:");
jLabel19.setText("獲獎名稱:");
jdbTextField1.setText("jdbTextField1");
jdbTextField1.setColumnName("gcheck_time");
jdbTextField1.setDataSet(qSet_jiangli);
jdbTextField2.setText("jdbTextField2");
jdbTextField2.setColumnName("gcheck_title");
jdbTextField2.setDataSet(qSet_jiangli);
jdbTextArea1.setText("jdbTextArea1");
jdbTextArea1.setColumnName("gcheck_disc");
jdbTextArea1.setDataSet(qSet_jiangli);
jPanel17.setLayout(borderLayout10);
jButton5.setText("增加");
jButton6.setText("取消");
jPanel18.setLayout(borderLayout11);
borderLayout11.setVgap(10);
jLabel20.setText("獲獎內容具體描述:");
jdbTextField3.setEnabled(true);
jdbTextField3.setAlignmentX((float) 0.5);
jdbTextField3.setDoubleBuffered(false);
jdbTextField3.setMinimumSize(new Dimension(10, 22));
jdbTextField3.setPreferredSize(new Dimension(15, 22));
jdbTextField3.setMargin(new Insets(1, 3, 1, 3));
jdbTextField3.setText("");
jdbTextField3.setHorizontalAlignment(SwingConstants.LEFT);
jdbTextField3.setColumnName("student_name");
jdbTextField3.setDataSet(queryDataSet2);
jdbTextField3.setEnablePopupMenu(true);
jdbTextField3.setPostOnFocusLost(true);
jdbTextField4.setDebugGraphicsOptions(0);
jdbTextField4.setText("jdbTextField4");
jdbTextField4.setColumnName("student_class");
jdbTextField4.setDataSet(queryDataSet2);
jdbTextField5.setText("jdbTextField5");
jdbTextField5.setColumnName("student_tel");
jdbTextField5.setDataSet(queryDataSet2);
jdbTextField7.setDisabledTextColor(Color.gray);
jdbTextField7.setText("jdbTextField7");
jdbTextField7.setColumnName("student_birthday");
jdbTextField7.setDataSet(queryDataSet2);
jdbTextField8.setText("jdbTextField8");
jdbTextField8.setColumnName("student_address");
jdbTextField8.setDataSet(queryDataSet2);
jdbRadioButton2.setSelected(false);
jdbRadioButton2.setText("女");
jdbRadioButton2.setButtonGroup(buttonGroup1);
jdbRadioButton2.setColumnName("student_sex");
jdbRadioButton2.setDataSet(queryDataSet2);
jdbRadioButton2.setSelectedDataValue("女");
jdbRadioButton1.setActionCommand("男");
jdbRadioButton1.setContentAreaFilled(true);
jdbRadioButton1.setSelected(true);
jdbRadioButton1.setText("男");
jdbRadioButton1.setButtonGroup(buttonGroup1);
jdbRadioButton1.setColumnName("student_sex");
jdbRadioButton1.setDataSet(queryDataSet2);
jdbRadioButton1.setSelectedDataValue("男");
jdbNavField1.setMinimumSize(new Dimension(100, 22));
jdbNavField1.setPreferredSize(new Dimension(100, 22));
jdbNavField1.setText("jdbNavField1");
jdbNavField1.setColumnName("student_id");
jdbNavField1.setDataSet(queryDataSet2);
jdbTextField9.setEnabled(true);
jdbTextField9.setPreferredSize(new Dimension(70, 22));
jdbTextField9.setEditable(false);
jdbTextField9.setText("jdbTextField9");
jdbTextField9.setColumns(0);
jdbTextField9.setColumnName("student_class");
jdbTextField9.setDataSet(queryDataSet2);
jdbTextField10.setEnabled(true);
jdbTextField10.setPreferredSize(new Dimension(50, 22));
jdbTextField10.setEditable(false);
jdbTextField10.setText("jdbTextField10");
jdbTextField10.setColumnName("student_sex");
jdbTextField10.setDataSet(queryDataSet2);
queryDataSet4.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "SELECT student_count.count_id FROM student.dbo.student_count", null, true, Load.ALL));
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" +
"rse_no FROM student.dbo.student_course", null, true, Load.ALL));
column15.setColumnName("count_id");
column15.setDataType(com.borland.dx.dataset.Variant.INT);
column15.setRowId(true);
column15.setSchemaName("dbo");
column15.setTableName("student_course");
column15.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
column15.setServerColumnName("count_id");
column15.setSqlType(4);
column16.setColumnName("course_id");
column16.setDataType(com.borland.dx.dataset.Variant.INT);
column16.setSchemaName("dbo");
column16.setTableName("student_course");
column16.setVisible(com.borland.jb.util.TriStateProperty.FALSE);
column16.setServerColumnName("course_id");
column16.setSqlType(4);
column18.setCaption("學生姓名");
column18.setColumnName("course_name");
column18.setDataType(com.borland.dx.dataset.Variant.STRING);
column18.setPrecision(50);
column18.setSchemaName("dbo");
column18.setTableName("student_course");
column18.setWidth(10);
column18.setServerColumnName("course_name");
column18.setSqlType(12);
column19.setCaption("所選課程編號");
column19.setColumnName("course_no");
column19.setDataType(com.borland.dx.dataset.Variant.INT);
column19.setSchemaName("dbo");
column19.setTableName("student_course");
column19.setServerColumnName("course_no");
column19.setSqlType(4);
qSet_course.setColumns(new Column[] {column15, column16, column18, column19});
qSet_course.addRowFilterListener(new MainFrame_qSet_course_rowFilterAdapter(this));
jdbTable3.setDataSet(qSet_course);
jdbTextField11.setMinimumSize(new Dimension(70, 22));
jdbTextField11.setPreferredSize(new Dimension(70, 22));
jdbTextField11.setEditable(false);
jdbTextField11.setText("jdbTextField11");
jdbTextField11.setColumnName("student_name");
jdbTextField11.setDataSet(queryDataSet2);
jdbNavField2.setDataSet(queryDataSet2);
jdbNavField2.setColumnName("student_id");
jdbNavField2.setPreferredSize(new Dimension(70, 22));
jdbNavField2.setMinimumSize(new Dimension(70, 22));
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);
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" +
"heck_time,student_gcheck.gcheck_title,student_gcheck.gcheck_disc " +
"FROM student.dbo.student_gcheck", null, true, Load.ALL));
column20.setCaption("獲獎時間");
column20.setColumnName("gcheck_time");
column20.setDataType(com.borland.dx.dataset.Variant.TIMESTAMP);
column20.setEditMask("yyyy-MM-dd");
column20.setDisplayMask( "yyyy-MM-dd");
column20.setSchemaName("dbo");
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -