Java成绩管理系统源码

蕾蕾

//需求分析：写一个成绩管理系统。其中的一个功能是实现成绩录入。要求能根据课程名称在系统里找到学生和课程信息；在结果区域中添加成绩。

//规则：要求对输入成绩的操作要有有效性检验。成绩只接受大于0且小于100的数字；同一记录不能反复提交；当点击“提交”，告知用户操作是否成功，并给出相应信息；课程名下拉列表中的课程列表根据数据库中的课程表，自动生成。

//代码如下：
import java.awt.*;
7 V* _8 Y: o1 g( Himport java.awt.event.*;
import java.sql.*;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;

import school.schoolPicture.JdbcUtil;

public class AddScore extends JPanel implements ActionListener {
String[] columnNames = new String[] { "姓名", "学期", "课程ID", "成绩" };

DefaultTableModel dtmScore = new DefaultTableModel(columnNames, 57);

JTable jtAddScore = new JTable(dtmScore);

JScrollPane jspScore = new JScrollPane(jtAddScore);

JComboBox jcbCourse = new JComboBox();

JComboBox jcbClassName = new JComboBox();

JComboBox jcbTerm = new JComboBox();
Connection con = JDBCUtil.getConnection();
0 `. d; `2 a4 X% t) J* i// Connection con2 = JdbcUtil.getConnection();
& H2 i! _: }3 k2 zPreparedStatement ps = null;
ResultSet rs = null;
ResultSetMetaData meta = null;
String sql = null;
int cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
}

public void actionPerformed(ActionEvent e) {
4 P4 d' e( \7 T# nString str = e.getActionCommand();
# Y4 s( P& S7 B% l# eif ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
+ Y$ t0 ]# V! A" ~. X& y: F! Z8 A! xsearchScore();
) v7 ^" P7 L8 @, s9 P' d} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
tryCommit();

} else if ("退出".equals(str)) {
this.setVisible(false);
8 N* ?8 u1 b2 l' r7 p  }}
}
/ u4 C. U# m1 G. |5 epublic void tryCommit() {
if (cols < 1)
return;
; w( H' G/ B- o# ysql = "insert into scorexx values(?,?,?,?)";
try {
* Z  }7 M; i  }$ Q) J- D# Hps = con.prepareStatement(sql);
. d) s, V) `* H0 J! Z9 t. DString[] value = new String[4];
. Y7 M9 \' y- Afor (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
& @) a* B' i" _" c  }) h// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
! U6 z0 \% x5 G9 vvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
3 ^6 L2 I+ z9 L6 z9 B# ^.toString();
} else {
% M3 e1 h1 o2 Z3 n8 r( T( z7 Jif (i == 4)
6 s( n1 |/ H. Z/ d7 u; Z( yJOptionPane
+ p* W) F5 @* @/ J) A.showMessageDialog(null, "无效成绩输入！成绩不能为空");
* _) S5 ^) Z: [/ n6 hreturn;
& \# M3 X. [; c" Z0 p}
. _0 ]8 w# y& n( l+ k// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
// if(
( I, o' c, ~9 L. ?# ^// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
' Z  L% [. S; H. s& F: B6 n// }
// }
% }6 X6 z( Y% S9 q, iSystem.out.print(value[i - 1]);
. [* s- q6 L6 u7 u0 A}
ps.setString(1, value[0]);
ps.setString(2, value[1]);
8 l/ V+ V) D+ s  \- gps.setString(3, value[2]);
6 K% b/ y% r7 Ips.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
3 i! y0 m$ Q: p# C: n2 g7 DSystem.out.println();
}
4 Y& @" ~4 c( e0 w0 eJOptionPane
2 Y9 _' E5 d7 r6 r% `.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
} catch (Exception ew) {
6 G& A/ x4 H6 T. v' gew.printStackTrace();

}

}

0 m' p, e0 m/ j4 w; K9 _; ]$ G

// 自动添加课程下拉列表中的课程
5 p. X. v5 o. S1 h6 Lpublic void addCourseToJCheckBoxCourse() {
String courseName = null;
sql = "select cname from coursexx";
* {8 C' P/ ]# \try {
ps = con.prepareStatement(sql);
3 H, ^2 o3 {* l, ~1 y/ [+ v. Brs = ps.executeQuery();
5 F! G# l) r: F: C8 T7 FResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
0 s( Z( D$ k% N# mwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
, O, ~( t, u0 k8 Z+ ~System.out.println(courseName);
: S! q6 C) R. K  p# |: ?jcbCourse.addItem(courseName);
5 E$ E, z0 y5 c+ k0 l; {rowCount++;
5 T' o5 ?6 l0 X; H+ ~0 e}
}
con.commit();
} catch (Exception ers) {
+ E1 j& m8 q/ Jers.printStackTrace();
try {
con.rollback();
; U3 X% x/ Z  N% P3 n3 ?+ G% Z. q} catch (Exception er) {
$ [: X1 O, Y  eer.printStackTrace();
}
- e* N- }( c9 p9 a}

}

! D/ u; R+ e2 n/ `( E

public void searchScore() {
// 每次查询之前清空之前的结果
5 y) y6 E+ j# f' r$ ffor (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
' w7 j' e: }. ?$ n3 kjtAddScore.setValueAt(null, k, i);
" v2 X# Q" w( e2 l  u}

}
// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
+ "choicesxx x join Coursexx k "
+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
ps.setString(1, cName);
: |' [  H% f% [$ t* G( J& P: W# urs = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
boolean flag = true;
8 ]  r- c; U8 l6 f# A6 JString result = null;
8 g5 B! {9 L  E0 sint k = 1;
( T) p* i: [. C# c( {: {while (rs.next()) {
4 e& ]  t; @3 ?' S$ E' j3 {for (int i = 1; i <= cols; i++) {
result = rs.getString(i);
6 l: s- u/ q  [/ {- T+ mjtAddScore.setValueAt(result, k - 1, i - 1);
}
rowCount = k++;
}

} catch (Exception exx) {
$ \/ j& Z+ P5 Wexx.printStackTrace();
}
}

2 C- K% i/ n7 e& w* V: R' H

//产生用户界面

public void CreateAddScoreGUI() {
this.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
jcbCourse.addItem(new String("请选择课程"));
addCourseToJCheckBoxCourse();
this.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
2 k7 l1 {- q; [1 Z3 \5 G// this.add(jlClassName);
// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
' h9 k4 V$ N/ e+ ]6 C// addTermToJCheckBoxTerm();
; y, C6 f3 {+ A" [" x/ x1 t2 P// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
/ A* R, B% M% E( [0 PJButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
jbExit.addActionListener(this);
3 O: Q3 \7 G. d7 lthis.add(jbSearch);
) G9 X; s* S2 A3 e9 Gthis.add(jbOK);
this.add(jbExit);

this.add(jspScore);

this.setVisible(true);
this.setSize(500, 600);

}

public static void main(String[] args) {
new AddScore();
}
}

5 E5 X( [1 a. M0 |9 s