Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
# l9 g' U, G- _8 B7 g; Z; Timport java.awt.*;
import java.awt.event.*;
# P- ]+ A# H2 timport java.sql.*;

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

import school.schoolPicture.JdbcUtil;

public class AddScore extends JPanel implements ActionListener {
& G' a$ |) r+ i7 c5 z& D! F! ZString[] 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();
; p+ t1 d8 R: G* p& L0 C% ]2 B& IConnection con = JDBCUtil.getConnection();
// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
) ~- n1 L) j% @4 \0 zResultSetMetaData meta = null;
String sql = null;
6 G! U' U: d; e, }8 sint cols = 0;
7 i' R5 Y2 P& a; }  {- Uint rowCount = 0;

public AddScore() {
  `4 h3 U' U5 {/ l9 ^5 M4 [: dCreateAddScoreGUI();
( z0 E) ?6 i4 C" p, J- v* a}

public void actionPerformed(ActionEvent e) {
String str = e.getActionCommand();
4 \  V7 f: Q+ o. v; `if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
$ @8 O! G: j1 M/ t2 h% n* dsearchScore();
3 G0 N  h1 S; F. Q$ J" i  T' e} else if ("提交".equals(str)) {

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

} else if ("退出".equals(str)) {
this.setVisible(false);
}
}
public void tryCommit() {
$ W0 L2 T8 [7 J3 y( x# ]if (cols < 1)
return;
! H1 V6 f. r/ w& bsql = "insert into scorexx values(?,?,?,?)";
try {
ps = con.prepareStatement(sql);
String[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
value[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
} else {
if (i == 4)
JOptionPane
7 }5 x2 x! J9 M- S.showMessageDialog(null, "无效成绩输入！成绩不能为空");
return;
}
- [, x% h7 L4 K% Y3 a// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
" K+ R+ v9 v+ [  c+ n// if(
2 r  u3 `1 ]2 r# J// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
// }
) B* p/ k( M- ^4 }  G# {: S// }
System.out.print(value[i - 1]);
}
! E7 @: a- |& Z- w) Vps.setString(1, value[0]);
0 m; P+ K/ Q2 M2 g1 Xps.setString(2, value[1]);
ps.setString(3, value[2]);
' |% Q! Y0 a4 B0 A% b  w2 a6 j6 Gps.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
, c" K' V2 ], `System.out.println();
9 l! {0 k* f0 a1 p}
/ a$ ?+ y5 i/ T* x" g5 G% hJOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
7 J; b. Z  x% w1 {' E} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
: H6 Z& p6 v1 ^1 mString courseName = null;
sql = "select cname from coursexx";
! v1 O2 O# T$ [4 [3 s/ U5 f6 Etry {
  Y5 I1 M+ H& a9 X& s% Ips = con.prepareStatement(sql);
! R! k& B$ K& L$ D; Z$ ^5 T/ ers = ps.executeQuery();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
6 _8 Q$ {. t4 V4 S3 s9 `for (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
System.out.println(courseName);
: X5 G9 r; G7 d" e0 S( W/ HjcbCourse.addItem(courseName);
1 p" i# D" a0 ^# arowCount++;
" {, [7 ~/ `* v8 L% c}
% n# H9 m) W, q9 C- R' r  C}
& m' e3 C2 O0 l0 C$ j- ?  d. Dcon.commit();
} catch (Exception ers) {
ers.printStackTrace();
try {
con.rollback();
( h, ?" ~6 y' m7 d! R- w) G3 V+ h- X' [$ {} catch (Exception er) {
( Q8 `3 p4 w( `er.printStackTrace();
3 t4 i4 X& N  Y& t}
}

}

7 ~0 G! g8 n! x- }- y: N

public void searchScore() {
// 每次查询之前清空之前的结果
for (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
jtAddScore.setValueAt(null, k, i);
: S5 ?. i% p9 b, p- X8 U}

}
2 d6 ?, z; W6 n. n2 T+ d// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
, R8 A$ e1 T3 z* \sql = "select x.sname,k.term,k.cno from "
" Q; w4 h% c  i" O! ^6 R* K+ "choicesxx x join Coursexx k "
, ]8 M' a0 f, b1 @- `, J  {% A+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
ps.setString(1, cName);
- k& |. k# I! a9 C9 Prs = ps.executeQuery();
, e& K6 e4 x# d) f* D1 V3 ometa = rs.getMetaData();
cols = meta.getColumnCount();
1 B5 \# l; a, \8 }* Q$ z4 \) Mboolean flag = true;
String result = null;
+ Y  |) Y5 y& `1 b" o! Qint k = 1;
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
) K: J8 K" M7 \8 d2 cresult = rs.getString(i);
! K4 [/ Q9 ^# ?; a& PjtAddScore.setValueAt(result, k - 1, i - 1);
}
8 X3 \! H! A( A$ W7 }6 p$ GrowCount = k++;
}

} catch (Exception exx) {
. F  V* N. t! l) y# q/ R4 j( [& xexx.printStackTrace();
" u) H, C9 G8 X: O}
}

//产生用户界面

public void CreateAddScoreGUI() {
$ Y. h! v: _6 D# Nthis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
jcbCourse.addItem(new String("请选择课程"));
! d7 D. T- w! d) F1 y4 Y- w2 y" raddCourseToJCheckBoxCourse();
! X- P- J5 O# V9 xthis.add(jlCourse);
# ~% `! F& X$ Z; x- rthis.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
1 G; C# d- K2 }( k1 ]$ ]! i// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
// this.add(jlClassName);
1 M# u% w8 f5 B! p4 G. @// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
. B; Z! m/ f% U8 ~// jcbTerm.addActionListener(this);
! m$ [  p7 p! Z2 ?4 N// jcbTerm.addItem(new String("请选择学期"));
$ J1 S$ R5 [/ U0 i! M# Y& ?// addTermToJCheckBoxTerm();
// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
* n" ^% `+ t7 djbSearch.addActionListener(this);
; {* G% Z' S, A$ @, |6 B+ K3 sJButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
) j6 [0 p- R- f! H. c) tjbExit.addActionListener(this);
this.add(jbSearch);
* _3 G0 L7 n. r5 |7 H) kthis.add(jbOK);
this.add(jbExit);

this.add(jspScore);

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

}

public static void main(String[] args) {
new AddScore();
}
6 z5 ]/ G2 M9 H- t4 W}