Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
import java.awt.*;
import java.awt.event.*;
8 }5 A  c4 w  x  C7 H: [3 m$ q5 T8 zimport java.sql.*;

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

import school.schoolPicture.JdbcUtil;

public class AddScore extends JPanel implements ActionListener {
5 w2 L" W5 h. y+ N, O* T! O1 x& C; tString[] 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();
; Y* y, y) i# P5 \% F// Connection con2 = JdbcUtil.getConnection();
( z" _6 u1 E' mPreparedStatement ps = null;
ResultSet rs = null;
" w' v; u& E# @) y$ ZResultSetMetaData meta = null;
String sql = null;
# M* |  C, q% w1 r2 ~int cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
}

public void actionPerformed(ActionEvent e) {
% o6 r* z% `, u: h7 zString str = e.getActionCommand();
0 e6 R  X3 p* z7 X/ o+ hif ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
/ R' D7 ?2 h: `searchScore();
& k5 \% O) ?6 N  }1 K6 H} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
0 ^9 m' ]9 x1 RtryCommit();

} else if ("退出".equals(str)) {
# B) f5 T$ a7 W5 \6 g5 bthis.setVisible(false);
  ]* R% ]; j# P. n}
% s; X& c. C$ L6 @, l}
public void tryCommit() {
' h7 n. a$ ^/ Dif (cols < 1)
$ _9 C3 B" [1 }( A* ~. r8 }3 Y# Zreturn;
& N) r! q4 p' F) Esql = "insert into scorexx values(?,?,?,?)";
try {
. U* i/ c1 g' ?% a1 x  Q- wps = con.prepareStatement(sql);
- C% Q0 F1 _" O, ]6 a/ B* aString[] value = new String[4];
5 l/ j  b; |4 y. W. ofor (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
1 ^3 I* i/ A2 M3 g+ A// 如果成绩为空，取消提交操作，并给出提示。
0 _' [" i% e6 o% zif (jtAddScore.getValueAt(k, i - 1) != null) {
value[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
5 W; }: o2 m* U* \) A# ^- S" k8 @} else {
if (i == 4)
  Z7 u5 ^, k9 X  i$ K1 G, aJOptionPane
.showMessageDialog(null, "无效成绩输入！成绩不能为空");
- u" k% ]5 {% t7 Q' P( h8 Oreturn;
* T) N" F9 a" S) m2 S& c}
// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
( X3 s$ Y; F; `, t# G) i1 t  R! w// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
" n/ J* o/ S2 g  B$ r4 r" K// return;}
// }
2 f( a+ A/ I; n8 G) b// }
System.out.print(value[i - 1]);
}
$ l6 F. ?2 ]$ N1 H- z8 Lps.setString(1, value[0]);
' u2 e8 P  J' t5 [9 C/ y) @7 bps.setString(2, value[1]);
1 w9 n" ~* _! x$ g6 z* P* f0 lps.setString(3, value[2]);
: _! |$ J3 s4 S0 C0 D" ips.setInt(4, Integer.parseInt(value[3]));
& s9 p" x* I4 [. T/ }" `. N+ i' v+ Q$ ups.executeUpdate();
9 Z1 z: q9 N) ~- |con.commit();
7 @6 k2 a' @1 J* ]0 tSystem.out.println();
2 _6 ~1 E, L" H- [/ F, f5 D& T( x}
" R: Q6 \; ]$ ^7 O3 uJOptionPane
* y# H3 ]/ J0 o) i.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
, U# D) w9 @" l5 v& v# V3 `' ~5 o} catch (Exception ew) {
1 I# t& x4 x. K9 F* ~ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
String courseName = null;
sql = "select cname from coursexx";
# O) Y& I2 P  _" H% f- Jtry {
- F# M3 R$ t1 ^, |+ r8 Jps = con.prepareStatement(sql);
rs = ps.executeQuery();
1 d& m- k3 L/ M; G8 m$ ]ResultSetMetaData meta = rs.getMetaData();
( \. E' G: p& `$ @5 lint cols = meta.getColumnCount();
0 t+ c$ C! D: [+ `0 C" `while (rs.next()) {
for (int i = 1; i <= cols; i++) {
& |1 s4 P9 f( f! V% p# e* i) J; ScourseName = rs.getString(i);
' J, |/ H& d4 QSystem.out.println(courseName);
jcbCourse.addItem(courseName);
rowCount++;
}
( U4 M) O1 |2 N+ r5 i+ f}
3 V( n5 L: q: Qcon.commit();
} catch (Exception ers) {
ers.printStackTrace();
2 B" b8 j3 U- P. C1 k) u2 ]try {
, C) M4 l6 B! g- {. y7 \con.rollback();
- S% U  p  Z+ I} catch (Exception er) {
er.printStackTrace();
) H# v  W, s4 a}
}

}

. W1 T3 K. [( ~$ J7 z

public void searchScore() {
0 R6 [3 V$ Y2 B# B$ g0 O% K// 每次查询之前清空之前的结果
' }2 Y( R/ O6 H( z) e* t- Rfor (int k = 0; k < 50; k++) {
6 J. L9 j8 V+ `0 nfor (int i = 0; i < cols; i++) {
jtAddScore.setValueAt(null, k, i);
: G. a- ?1 x3 C0 m  P) }9 ^! B7 h}

}
, x1 J3 _* s0 z// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
7 x0 t7 Z! _: e0 ~+ v/ k+ C# Y  ~+ "choicesxx x join Coursexx k "
4 i# G( D" Y% \- \& K+ "on x.cno=k.cno and k.cname=?";
try {
( g( }7 O8 Z& Q9 h+ J% D& O! Pps = con.prepareStatement(sql);
: f0 h1 q; s7 x, ?/ v/ d: z2 Xps.setString(1, cName);
# |, s/ L6 Z4 Q! U- q1 l6 Jrs = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
1 s# S7 l9 H% x' H$ W- @# j) Wboolean flag = true;
String result = null;
1 X1 D  C1 k3 C0 G2 O+ cint k = 1;
while (rs.next()) {
. R% L' }6 ?$ e( F& J& l7 Ofor (int i = 1; i <= cols; i++) {
result = rs.getString(i);
8 _# q) `# |& x* u7 p- qjtAddScore.setValueAt(result, k - 1, i - 1);
}
rowCount = k++;
}

} catch (Exception exx) {
exx.printStackTrace();
, m( B* d* U; m2 v}
}

//产生用户界面

public void CreateAddScoreGUI() {
4 A% n( x' j3 Y; D6 U# @/ Qthis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
" b1 Z; m5 v$ a5 J0 _) D9 a; ~jcbCourse.addActionListener(this);
8 ?$ M' w2 g4 sjcbCourse.addItem(new String("请选择课程"));
addCourseToJCheckBoxCourse();
this.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
- H! f4 H/ r$ _0 \& G// jcbClassName.addActionListener(this);
8 R& ]3 [$ e/ S1 M// jcbClassName.addItem(new String("请选择班级"));
- s5 A9 v0 i$ X; L: F2 p: W0 l// addClassNameToJCheckBoxClassName();
* g( y5 }; D. z6 l// this.add(jlClassName);
// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
. Z7 v( e% S4 x  ~// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
// this.add(jlTerm);
1 U; l+ Q; K1 [  ^3 @6 ~7 l4 D" e7 L// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
7 G: b* h" t- o" c8 d0 YJButton jbExit = new JButton("退出");
# ]5 U2 J5 A& N& q" K  Q; d6 T# cjbExit.addActionListener(this);
/ Z2 J  h8 t: p* @this.add(jbSearch);
this.add(jbOK);
/ V; }0 ~0 ~$ Ithis.add(jbExit);

this.add(jspScore);

this.setVisible(true);
7 T# m+ a3 N3 X# i- U2 e! Mthis.setSize(500, 600);

}

public static void main(String[] args) {
/ G/ T8 f3 k2 `$ r. |5 Y  N0 B, Inew AddScore();
}
}

# u: n" v9 g; D: t3 W0 ?* T