📄 remarkupdate.java~9~
字号:
package java_教务管理系统;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.JTableHeader;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.PreparedStatement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Connection;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import java.awt.Font;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class remarkupdate extends JPanel {
public remarkupdate() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setLayout(null);
jLabel1.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel1.setText("月");
jLabel1.setBounds(new Rectangle(454, 243, 24, 28));
jLabel2.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel2.setText("任课老师:");
jLabel2.setBounds(new Rectangle(231, 207, 104, 25));
txtresultstuno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
txtresultstuno.setBounds(new Rectangle(174, 161, 190, 28));
jLabel3.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel3.setText("考试次数:");
jLabel3.setBounds(new Rectangle(47, 276, 106, 44));
jLabel4.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel4.setText("学号:");
jLabel4.setBounds(new Rectangle(84, 156, 111, 41));
txtlessonteacher.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
txtlessonteacher.setBounds(new Rectangle(352, 203, 265, 28));
jLabel5.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel5.setText("考试时间:");
jLabel5.setBounds(new Rectangle(124, 247, 112, 31));
txtresult.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
txtresult.setBounds(new Rectangle(532, 285, 218, 27));
txaresultremarks.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
txaresultremarks.setBounds(new Rectangle(173, 328, 577, 98));
jLabel6.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel6.setText("备注:");
jLabel6.setBounds(new Rectangle(87, 321, 94, 43));
cboexaminationdatedate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
cboexaminationdatedate.setBounds(new Rectangle(486, 245, 61, 28));
txtexaminationnumber.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
txtexaminationnumber.setBounds(new Rectangle(174, 285, 188, 27));
cboexaminationdateyear.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
cboexaminationdateyear.setBounds(new Rectangle(246, 245, 99, 28));
jLabel7.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel7.setText("日");
jLabel7.setBounds(new Rectangle(551, 236, 38, 45));
cboexaminationdatemonth.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
cboexaminationdatemonth.setBounds(new Rectangle(374, 245, 74, 28));
tbremark.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
tbremark.setBounds(new Rectangle(3, 37, 853, 114));
tbremark.addMouseListener(new remarkupdate_tbremark_mouseAdapter(this));
jLabel8.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel8.setText("成绩:");
jLabel8.setBounds(new Rectangle(448, 276, 91, 36));
jLabel9.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel9.setText("年");
jLabel9.setBounds(new Rectangle(350, 243, 21, 30));
txtresultclassno.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
txtresultclassno.setBounds(new Rectangle(532, 161, 218, 28));
jLabel10.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
jLabel10.setText("课程名称:");
jLabel10.setBounds(new Rectangle(412, 162, 102, 25));
btnselect.setBounds(new Rectangle(74, 446, 154, 43));
btnselect.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
btnselect.setText("查询成绩");
btnselect.addActionListener(new remarkupdate_btnselect_actionAdapter(this));
btnupdate.setBounds(new Rectangle(307, 446, 154, 42));
btnupdate.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
btnupdate.setText("修改成绩");
btnupdate.addActionListener(new remarkupdate_btnupdate_actionAdapter(this));
btnexit.setBounds(new Rectangle(523, 446, 154, 42));
btnexit.setFont(new java.awt.Font("宋体", Font.PLAIN, 20));
btnexit.setText("退出修改");
jTableHeader1.setFont(new java.awt.Font("宋体", Font.PLAIN, 15));
jTableHeader1.setBounds(new Rectangle(0, 15, 854, 22));
this.add(tbremark);
this.add(jTableHeader1);
this.add(jLabel4);
this.add(txtresultstuno);
this.add(txtresultclassno);
this.add(jLabel2);
this.add(txtlessonteacher);
this.add(jLabel5);
this.add(cboexaminationdateyear);
this.add(jLabel9);
this.add(cboexaminationdatemonth);
this.add(jLabel1);
this.add(jLabel7);
this.add(cboexaminationdatedate);
this.add(jLabel10);
this.add(txtexaminationnumber);
this.add(jLabel3);
this.add(txtresult);
this.add(jLabel8);
this.add(txaresultremarks);
this.add(jLabel6);
this.add(btnupdate);
this.add(btnexit);
this.add(btnselect);
}
String year[] = {"", "2006", "2007", "2008", "2009"};
String month[] = {"", "01", "02", "03", "04", "05", "06", "07",
"08",
"09",
"10", "11", "12"};
String date[] = {"", "01", "02", "03", "04", "05", "06", "07",
"08",
"09",
"10", "11", "12", "13", "14", "15", "16", "17",
"18", "19", "20", "21", "22", "23", "24", "25",
"26", "27", "28", "29", "30", "31"};
String head[] = {"学号", "考试名称", "任课老师", "考试时间", "考试次数", "成绩", "备注"};
DefaultTableModel mod = new DefaultTableModel(head, 0);
JLabel jLabel1 = new JLabel();
JLabel jLabel2 = new JLabel();
JTextField txtresultstuno = new JTextField();
JLabel jLabel3 = new JLabel();
JLabel jLabel4 = new JLabel();
JTextField txtlessonteacher = new JTextField();
JLabel jLabel5 = new JLabel();
JTextField txtresult = new JTextField();
JTextArea txaresultremarks = new JTextArea();
JLabel jLabel6 = new JLabel();
JComboBox cboexaminationdatedate = new JComboBox(date);
JTextField txtexaminationnumber = new JTextField();
JComboBox cboexaminationdateyear = new JComboBox(year);
JLabel jLabel7 = new JLabel();
JComboBox cboexaminationdatemonth = new JComboBox(month);
JTable tbremark = new JTable(mod);
JLabel jLabel8 = new JLabel();
JLabel jLabel9 = new JLabel();
JTextField txtresultclassno = new JTextField();
JLabel jLabel10 = new JLabel();
JButton btnselect = new JButton();
JButton btnupdate = new JButton();
JButton btnexit = new JButton();
JTableHeader jTableHeader1 = tbremark.getTableHeader();
String timename =
this.cboexaminationdateyear.getSelectedItem().toString() + "-" +
this.cboexaminationdatemonth.getSelectedItem().toString() + "-" +
this.cboexaminationdatedate.getSelectedItem().toString() + " ";
public void btnselect_actionPerformed(ActionEvent e) {
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection nod = DriverManager.getConnection("jdbc:odbc:studer");
String daima = "select resultstuno,resultclassno,lessonteacher,examinationdate,examinationnumber,result,resultremarks from result where 1=1";
if (!this.txtresultstuno.getText().equals("")) {
daima += " and classno = '" + this.txtresultstuno.getText() +
"'";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -