Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
$ J( {' S- L- H- R+ W$ cimport java.awt.*;
" H7 j& n$ H% J+ \; R+ E9 Qimport 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 {
5 _+ I, p( o7 n7 OString[] 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();
// Connection con2 = JdbcUtil.getConnection();
& @4 F6 t/ N, L! [PreparedStatement ps = null;
, p5 ^$ r* \, v0 O! }; `ResultSet rs = null;
ResultSetMetaData meta = null;
2 ~, `8 X# y, S6 CString sql = null;
int cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
& }& G8 r( Z$ V/ J" }3 K}

public void actionPerformed(ActionEvent e) {
String str = e.getActionCommand();
6 T0 V9 V9 J$ \if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
searchScore();
} else if ("提交".equals(str)) {

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

} else if ("退出".equals(str)) {
* L6 a6 X+ Q0 C5 G/ ^" bthis.setVisible(false);
}
}
public void tryCommit() {
if (cols < 1)
return;
/ M3 D) N! L0 L% {+ q$ osql = "insert into scorexx values(?,?,?,?)";
4 c. n1 ~1 v  N* H4 ]try {
+ u* v0 e* {) W! ^7 @; kps = con.prepareStatement(sql);
7 U% K3 v. w. B. M' iString[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
: _# e3 _2 @; K" T  ]; afor (int i = 1; i <= cols + 1; i++) {
& N/ N- J7 ?, [9 W: z+ n' X! U// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
: j" k5 r8 B5 Y+ evalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
6 l5 r0 x0 H. }* O0 W.toString();
} else {
; R- T/ j3 U8 p5 S% eif (i == 4)
. ?, C$ d1 d/ I: T: H1 r: X" J0 bJOptionPane
.showMessageDialog(null, "无效成绩输入！成绩不能为空");
return;
; l, q* p9 ~/ z) H" r  y* |5 z0 V}
* m  }( }1 E$ G4 z8 Q3 I5 S+ |$ J// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
  u' i( k# C- S1 c% G// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
1 i! C$ j/ A. {+ O3 _! R0 S& J// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
1 u, l' e! x9 V" |2 m// return;}
// }
// }
  Z! C# @7 O! z, c0 DSystem.out.print(value[i - 1]);
! M: m4 D. w1 ~5 p}
5 d4 o. B  \2 J4 d1 x+ O% _ps.setString(1, value[0]);
ps.setString(2, value[1]);
ps.setString(3, value[2]);
ps.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
2 `0 i2 I* I( DSystem.out.println();
}
JOptionPane
* p# J  c9 _# j" u4 p( Q1 G.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
8 G5 b1 Q1 d& ?8 Y# H( h} catch (Exception ew) {
; L* N% o1 R/ k3 dew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
String courseName = null;
sql = "select cname from coursexx";
/ _5 x) J6 O' ~, x1 Wtry {
* W5 k2 G. i* v7 ^ps = con.prepareStatement(sql);
9 o- _  m% w" L# Hrs = ps.executeQuery();
, Z; q# {, b) f1 C( o3 {/ |ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
% d& p; w1 I& `# j; v' |$ uwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
9 i( D; v0 X9 @  T* G4 D% s: P9 xSystem.out.println(courseName);
  |# j% y, d0 m/ vjcbCourse.addItem(courseName);
rowCount++;
}
}
con.commit();
} catch (Exception ers) {
ers.printStackTrace();
try {
5 f4 y: p* m/ p( X  w, X1 ?: X. Rcon.rollback();
# g7 G2 V- d* Y( X7 ^8 K9 v} catch (Exception er) {
er.printStackTrace();
}
}

}

public void searchScore() {
3 g$ W. m4 h+ N1 Y! @// 每次查询之前清空之前的结果
for (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
jtAddScore.setValueAt(null, k, i);
}

}
// Method1:JDBC Method2:hibernate
1 ^2 J* S: C9 m: DString cName = jcbCourse.getSelectedItem().toString().trim();
1 a: p; O* f6 K& [3 b9 n8 b. ]sql = "select x.sname,k.term,k.cno from "
$ I, n: g) W- Z: {6 J1 |+ "choicesxx x join Coursexx k "
% ?! z5 f, z) I2 o( H+ "on x.cno=k.cno and k.cname=?";
# Y6 E3 q8 x, V( Ktry {
ps = con.prepareStatement(sql);
! _0 o2 k  y9 |$ Xps.setString(1, cName);
* U) l2 R  V: v2 ?$ M* C8 |rs = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
$ \3 h* ^1 A8 u1 q/ yboolean flag = true;
String result = null;
1 N* `# x1 z1 D- f, Mint k = 1;
6 P9 l* o' B8 [while (rs.next()) {
/ z0 v8 F6 W. n- J$ c# X. Kfor (int i = 1; i <= cols; i++) {
5 N; [. B" P' ?# _* U( Fresult = rs.getString(i);
jtAddScore.setValueAt(result, k - 1, i - 1);
}
rowCount = k++;
}

} catch (Exception exx) {
exx.printStackTrace();
}
; U' w9 N1 o9 ]  p& P}

% y& I# V5 G0 }9 n- }

//产生用户界面

public void CreateAddScoreGUI() {
9 P2 w3 }4 O8 h+ j8 s# athis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
4 H, H+ ^  t) T$ ?. A) WjcbCourse.addItem(new String("请选择课程"));
2 A- P4 h6 t, eaddCourseToJCheckBoxCourse();
3 U* _. J% U& K( D4 rthis.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
2 x. u( K' x7 K0 q- j4 }# r" }; p// addClassNameToJCheckBoxClassName();
// this.add(jlClassName);
$ G1 N% r; f, M) E: m// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
* W1 f1 G3 E1 v& |+ l' |// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
/ E( q" H. b( b! ]2 @& G& q// this.add(jlTerm);
5 Z0 ?; V7 K, U! h: O* s2 l: r& P// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
8 D5 n9 V$ J3 F9 }" C# KJButton jbExit = new JButton("退出");
! e  l% L) N) `- P- l  h' CjbExit.addActionListener(this);
this.add(jbSearch);
this.add(jbOK);
+ b, Q# I1 ^. ?# `' Y* b( A* rthis.add(jbExit);

this.add(jspScore);

this.setVisible(true);
$ F2 r3 ]* z# w( n0 p+ Xthis.setSize(500, 600);

}

public static void main(String[] args) {
( i& Y3 z5 z# ynew AddScore();
) A2 y2 c! v+ `( H8 n# b, R}
}