📄 scoreinfo.java
字号:
package xiangmu;
import java.awt.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.BorderFactory;
import javax.swing.border.TitledBorder;
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.event.WindowEvent;
import java.awt.event.WindowAdapter;
/**
* <p>Title: 第四学习小组-教学管理系统</p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class ScoreInfo extends JFrame {
public static String userType="";
String cols[]={" 学 号"," 课程名"," 老 师"," 考试日期"," 考试编次"," 考试成绩"," 备 注"};
DefaultTableModel bg=new DefaultTableModel(cols,0);
String classno[]={"T58","T64","T65"};
JButton btnAdd = new JButton();
JButton btnEdit = new JButton();
JButton btnDel = new JButton();
JButton btnExit = new JButton();
JPanel jPanel1 = new JPanel();
JLabel jLabel2 = new JLabel();
JTextField txtStudentNo = new JTextField();
JLabel jLabel3 = new JLabel();
JTextField txtCourse = new JTextField();
JLabel jLabel4 = new JLabel();
JTextField txtTeacher = new JTextField();
JLabel jLabel5 = new JLabel();
JTextField txtExamDate = new JTextField();
JLabel jLabel6 = new JLabel();
JLabel jLabel7 = new JLabel();
JTextField txtScore = new JTextField();
JLabel jLabel8 = new JLabel();
JTextArea txaRemark = new JTextArea();
TitledBorder titledBorder1 = new TitledBorder("");
JTable jTable1 = new JTable(bg);
JScrollPane jScrollPane1 = new JScrollPane();
JButton btnjiansuo = new JButton();
JButton btnshuaxin = new JButton();
String examno[] = {"", "1", "2", "3","4"};
JComboBox cmbExamNo = new JComboBox(examno);
public ScoreInfo() {
try {
jbInit();
} catch (Exception exception) {
exception.printStackTrace();
}
}
private void jbInit() throws Exception {
this.setResizable(false);
this.addWindowListener(new ScoreInfo_this_windowAdapter(this));
getContentPane().setLayout(null);
btnExit.setBounds(new Rectangle(562, 13, 90, 29));
btnExit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnExit.setText("退 出");
btnExit.addActionListener(new ScoreInfo_btnExit_actionAdapter(this));
btnDel.setBounds(new Rectangle(461, 13, 90, 29));
btnDel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnDel.setText("删 除");
btnDel.addActionListener(new ScoreInfo_btnDel_actionAdapter(this));
btnEdit.setBounds(new Rectangle(358, 13, 90, 29));
btnEdit.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnEdit.setText("修 改");
btnEdit.addActionListener(new ScoreInfo_btnEdit_actionAdapter(this));
btnAdd.setBounds(new Rectangle(256, 12, 90, 29));
btnAdd.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnAdd.setText("添 加");
btnAdd.addActionListener(new ScoreInfo_btnAdd_actionAdapter(this));
jPanel1.setBorder(BorderFactory.createEtchedBorder());
jPanel1.setBounds(new Rectangle(10, 211, 670, 222));
jPanel1.setLayout(null);
jLabel2.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel2.setText("学 号：");
jLabel2.setBounds(new Rectangle(28, 21, 95, 21));
txtStudentNo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtStudentNo.setBounds(new Rectangle(127, 9, 130, 28));
jLabel3.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel3.setText("课 程 名：");
jLabel3.setBounds(new Rectangle(426, 21, 98, 15));
txtCourse.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtCourse.setBounds(new Rectangle(534, 221, 130, 28));
jLabel4.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel4.setText("老 师：");
jLabel4.setBounds(new Rectangle(28, 60, 94, 28));
txtTeacher.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtTeacher.setBounds(new Rectangle(127, 55, 130, 28));
jLabel5.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel5.setText("考试日期：");
jLabel5.setBounds(new Rectangle(426, 66, 81, 15));
txtExamDate.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtExamDate.setBounds(new Rectangle(534, 265, 130, 28));
jLabel6.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel6.setText("考试编次：");
jLabel6.setBounds(new Rectangle(28, 105, 82, 15));
jLabel7.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel7.setText("成 绩：");
jLabel7.setBounds(new Rectangle(428, 106, 93, 13));
txtScore.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
txtScore.setBounds(new Rectangle(524, 98, 130, 28));
jLabel8.setFont(new java.awt.Font("楷体_GB2312", Font.BOLD, 15));
jLabel8.setText("备 注：");
jLabel8.setBounds(new Rectangle(28, 143, 91, 15));
txaRemark.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
txaRemark.setBorder(BorderFactory.createEtchedBorder());
txaRemark.setBounds(new Rectangle(127, 142, 527, 65));
jScrollPane1.setBorder(BorderFactory.createEtchedBorder());
jScrollPane1.setBounds(new Rectangle(10, 52, 670, 149));
btnjiansuo.setBounds(new Rectangle(47, 11, 90, 29));
btnjiansuo.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnjiansuo.setText("检 索");
btnjiansuo.addActionListener(new ScoreInfo_btnjiansuo_actionAdapter(this));
btnshuaxin.setBounds(new Rectangle(151, 12, 90, 29));
btnshuaxin.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
btnshuaxin.setText("刷 新");
btnshuaxin.addActionListener(new ScoreInfo_btnshuaxin_actionAdapter(this));
cmbExamNo.setBounds(new Rectangle(127, 96, 130, 28));
jTable1.addMouseListener(new ScoreInfo_jTable1_mouseAdapter(this));
this.getContentPane().add(jScrollPane1);
this.getContentPane().add(btnExit);
this.getContentPane().add(btnDel);
this.getContentPane().add(btnEdit);
this.getContentPane().add(btnAdd);
this.getContentPane().add(btnshuaxin);
this.getContentPane().add(btnjiansuo);
this.getContentPane().add(txtCourse);
this.getContentPane().add(txtExamDate);
this.getContentPane().add(jPanel1);
jScrollPane1.getViewport().add(jTable1);
jPanel1.add(txaRemark);
jPanel1.add(txtScore);
jPanel1.add(jLabel7);
jPanel1.add(jLabel3);
jPanel1.add(jLabel5);
jPanel1.add(cmbExamNo);
jPanel1.add(txtTeacher);
jPanel1.add(txtStudentNo);
jPanel1.add(jLabel2);
jPanel1.add(jLabel4);
jPanel1.add(jLabel6);
jPanel1.add(jLabel8);
jScrollPane1.setVerticalScrollBarPolicy(JScrollPane.
VERTICAL_SCROLLBAR_ALWAYS);
setTitle("教学管理系统-成绩信息");
}
public void btnExit_actionPerformed(ActionEvent e) {
if (JOptionPane.showConfirmDialog(this, "是否确定退出成绩信息", "温馨提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
Dimension screenSize = Toolkit.getDefaultToolkit().
getScreenSize();
this.dispose();
}
}
public void btnjiansuo_actionPerformed(ActionEvent e) {
try {
String sql="select StudentNo,Course,Teacher,ExamDate,ExamNo,Score,Remark from Score where 1=1 ";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:xiangmu");
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs= ps.executeQuery();
bg.setRowCount(0);
while(rs.next()){
Object val[]={rs.getString(1),rs.getString(2),
rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),
rs.getString(7)};
bg.addRow(val);
}
jTable1.updateUI();
rs.close();
ps.close();
conn.close();
}
catch (Exception ex) {
JOptionPane.showMessageDialog(this, "检索失败！");
}
}
public void jTable1_mouseClicked(MouseEvent e) {
int row = this.jTable1.getSelectedRow();
if (row > -1) {
this.txtStudentNo.setText(this.jTable1.getValueAt(row, 0).toString());
this.txtCourse.setText(this.jTable1.getValueAt(row, 1).
toString());
this.txtTeacher.setText(this.jTable1.getValueAt(row, 2).
toString());
this.txtExamDate.setText(this.jTable1.getValueAt(row, 3).
toString());
this.cmbExamNo.setSelectedItem(this.jTable1.getValueAt(row, 4).
toString());
this.txtScore.setText(this.jTable1.getValueAt(row, 5).
toString());
this.txaRemark.setText(this.jTable1.getValueAt(row, 6).
toString());
}
}
public void btnDel_actionPerformed(ActionEvent e) {
try {
int row = this.jTable1.getSelectedRow();
if (JOptionPane.showConfirmDialog(this, "你确定删除吗?", "删除提示",
JOptionPane.OK_CANCEL_OPTION) ==
JOptionPane.OK_OPTION) {
if (row < 0) {
JOptionPane.showMessageDialog(this, "请选择数据");
return;
}
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection nod = DriverManager.getConnection(
"jdbc:odbc:xiangmu");
PreparedStatement sql = nod.prepareStatement(
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -