Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
' X% M6 e1 p; W% Q# d1 @2 |5 Himport java.awt.*;
import java.awt.event.*;
: k' y( N; X  eimport 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();
" p, q% q# M9 P3 O  y// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
, P2 v9 }4 N2 V1 l* iResultSet rs = null;
ResultSetMetaData meta = null;
) C$ }* K1 {/ mString sql = null;
" t/ o! c* G6 Z! f4 r. vint cols = 0;
int rowCount = 0;

public AddScore() {
, N* r& `% j" w  uCreateAddScoreGUI();
}

public void actionPerformed(ActionEvent e) {
String str = e.getActionCommand();
7 i! p2 U' f3 x- B; j( U+ Fif ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
, @9 ?. I9 I5 _5 |% JsearchScore();
: ~6 t5 @9 B2 a$ n' @  j2 Z} else if ("提交".equals(str)) {

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

} else if ("退出".equals(str)) {
: b: M# n9 |# xthis.setVisible(false);
}
  G% Y7 S* h' F4 \9 a}
public void tryCommit() {
3 ^, l% \8 \* W1 Mif (cols < 1)
1 n/ G* n4 _- r# P" Preturn;
( T- S! M1 d7 h" @% C! X& K- U0 usql = "insert into scorexx values(?,?,?,?)";
7 @8 A& a6 a( Otry {
ps = con.prepareStatement(sql);
4 X( o, s5 g! f* m" [  QString[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
( c- z. F! e  e" F" b  ^8 J+ ]for (int i = 1; i <= cols + 1; i++) {
// 如果成绩为空，取消提交操作，并给出提示。
, T0 o9 J: E! K# W& j3 I+ Hif (jtAddScore.getValueAt(k, i - 1) != null) {
value[i - 1] = jtAddScore.getValueAt(k, i - 1)
- R+ G8 q" a' U: ~) z; z& |.toString();
# M( C5 w- S% R% K9 |9 H} else {
if (i == 4)
5 B* j  ?' v* B3 ~' m$ OJOptionPane
! f! G) @5 g- [6 n6 T  Q. B.showMessageDialog(null, "无效成绩输入！成绩不能为空");
" t, b  m: ^  D' R4 Lreturn;
/ I! q8 {' B; _! B9 P/ j}
2 v7 t# B  `* I+ U1 V1 M, B; w0 K// 如果成绩字段里面不是数字，则取消本次操作??
- ]# O, X2 I- b+ h. R: ?// String str = "^[0-9]{1}[0-9]?[0-9]?$";
1 t0 \! S, U3 d  B$ r7 I// if (i == 4) {
/ w) u& `4 j3 }% ~7 L5 J5 U// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
+ |) h6 g1 h/ H// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
// }
/ ^0 J* p9 N5 r0 O, r) g6 m* O9 E: {$ L// }
System.out.print(value[i - 1]);
}
5 n: [8 H* k* E, }! l. Ups.setString(1, value[0]);
ps.setString(2, value[1]);
ps.setString(3, value[2]);
/ i  w. y, m& I1 p: Y0 Mps.setInt(4, Integer.parseInt(value[3]));
( y3 q3 v" \, h+ E# hps.executeUpdate();
con.commit();
# ]+ G+ I8 l. P3 _, z" R" eSystem.out.println();
}
JOptionPane
' o! B% ]5 f/ p.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
7 T" J1 x) s# I* v8 H} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
String courseName = null;
sql = "select cname from coursexx";
/ Z) c9 C7 H# O/ \try {
0 R8 q7 e4 F3 Yps = con.prepareStatement(sql);
rs = ps.executeQuery();
% M4 p& L! D. g" Z. C: i% E, iResultSetMetaData meta = rs.getMetaData();
+ V# b! G: @3 k) _; A/ o. ?; Hint cols = meta.getColumnCount();
while (rs.next()) {
' G+ N0 m( u- A( H  Yfor (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
6 h2 S2 D: T& c) H) Z, BSystem.out.println(courseName);
1 g0 L) }. D# |: c* `9 DjcbCourse.addItem(courseName);
rowCount++;
}
}
# N+ ?3 \5 ]8 k* e/ icon.commit();
1 \  {6 K" D$ D} catch (Exception ers) {
% l4 P7 @( Q* k. ?2 L8 Q( Xers.printStackTrace();
9 ?# |) ^, J4 S5 n1 J1 R. ?! C7 @try {
con.rollback();
} catch (Exception er) {
er.printStackTrace();
}
, I. y  d6 _; z2 y4 e3 @& Y( j}

}

public void searchScore() {
9 |7 _# e0 N+ X- t+ u+ j7 D$ H  ~// 每次查询之前清空之前的结果
for (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
3 h' d) f* W- w& K/ r+ njtAddScore.setValueAt(null, k, i);
( k5 j" j8 n' P}

}
// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
+ "choicesxx x join Coursexx k "
/ ?# i" k. O/ f9 R+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
3 p4 T. @; k4 ?" lps.setString(1, cName);
' j. ?$ C& G( @: ars = ps.executeQuery();
meta = rs.getMetaData();
. H) Q" _  L, ?cols = meta.getColumnCount();
  {) K* y- J0 s8 L. ]! Vboolean flag = true;
String result = null;
( W* Q; H- a/ `# n1 r0 S4 Tint k = 1;
while (rs.next()) {
2 a; Y' @* T6 M' a5 B$ G% [7 pfor (int i = 1; i <= cols; i++) {
0 t2 p, x. X' h% N$ \2 presult = rs.getString(i);
jtAddScore.setValueAt(result, k - 1, i - 1);
}
' U- ]: b- q9 ^! b" MrowCount = k++;
. m4 U9 c: Y6 P. T' C" S' h}

} catch (Exception exx) {
, E7 a1 ?  q' U, e4 r; c; [6 vexx.printStackTrace();
: Y7 w9 v' z( K+ G' b/ O2 I, x}
}

//产生用户界面

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

JLabel jlCourse = new JLabel("课程：");
5 v' L6 Y0 o3 @7 U8 _jcbCourse.addActionListener(this);
; q$ _3 B9 S* P8 ~( Z0 QjcbCourse.addItem(new String("请选择课程"));
6 r# @; [( t! }& t) L5 D9 ]* g; baddCourseToJCheckBoxCourse();
% C5 r5 a7 ^5 ~; m& Q0 ~& i# v4 L" Bthis.add(jlCourse);
7 E6 c( k% L+ Uthis.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
( Y2 W) W! I$ D- }. Q4 {// addClassNameToJCheckBoxClassName();
6 M0 E1 @  T4 B- X7 v// this.add(jlClassName);
// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
// jcbTerm.addActionListener(this);
, h  c4 F; t, @; y// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
8 y. o) P7 v8 q1 @; z! a' PJButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
( C4 x3 a( o$ Q% R. Z. [; PjbExit.addActionListener(this);
this.add(jbSearch);
this.add(jbOK);
' c$ r9 B) r$ _this.add(jbExit);

this.add(jspScore);

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

}

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

9 P3 u5 i# s. X! C8 I' {9 i