Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
import java.awt.*;
import java.awt.event.*;
0 t# X; i7 z7 |( ^8 ~/ mimport 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();
/ e$ ^+ E1 K2 v$ y// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
$ {0 E/ T) }7 l; G/ T8 i6 Y' @ResultSetMetaData meta = null;
- b$ j/ W; {  L* C, uString sql = null;
int cols = 0;
. ]+ Y/ _1 U: q8 X1 R2 |6 vint rowCount = 0;

public AddScore() {
- t0 Z- q5 Q: U4 r! k& [0 OCreateAddScoreGUI();
}

public void actionPerformed(ActionEvent e) {
String str = e.getActionCommand();
if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
  V) }; g1 ?' _. O2 j$ OsearchScore();
} else if ("提交".equals(str)) {

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

} else if ("退出".equals(str)) {
this.setVisible(false);
: \) o; @$ m$ c, B, V}
: }- Z) B0 \: P5 p! ?}
  c$ {! l' q: b! Kpublic void tryCommit() {
if (cols < 1)
return;
sql = "insert into scorexx values(?,?,?,?)";
7 S% s" K8 {( K: Etry {
! \& r4 K& }- w  K8 Rps = con.prepareStatement(sql);
  }! P- U6 Z2 b1 r6 OString[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
, C3 P& b7 y* N1 L/ O! f* ?2 C, }// 如果成绩为空，取消提交操作，并给出提示。
% y9 `; Z8 T- z! G+ H4 u: aif (jtAddScore.getValueAt(k, i - 1) != null) {
. D" L+ h" z9 I5 N* jvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
5 T: X! n1 l  l: [  }- K5 Y.toString();
' B# }3 `, [% X! s6 ~} else {
- c6 |4 W4 `& c# A) vif (i == 4)
3 m/ @5 s* Q0 v, |; f/ MJOptionPane
, r( Q7 _: W( x.showMessageDialog(null, "无效成绩输入！成绩不能为空");
" y, n' r: R, H+ D+ u4 B+ Zreturn;
& W  J( U8 X8 u0 S}
// 如果成绩字段里面不是数字，则取消本次操作??
! W/ K/ |) q+ J// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
3 M( E3 f) t$ Y. i4 u& {// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
; S: v& [5 ^7 |7 H3 K0 Z// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
$ R7 l4 s" g/ Q8 Z// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
// }
// }
7 e1 K9 Y% v0 @' Q" }System.out.print(value[i - 1]);
}
- p, _( x; n8 c; dps.setString(1, value[0]);
ps.setString(2, value[1]);
0 @' D, r1 `7 q1 `- S7 R0 t  ips.setString(3, value[2]);
ps.setInt(4, Integer.parseInt(value[3]));
4 @0 K7 Y7 E) H0 G& ~) D+ Qps.executeUpdate();
* N6 _2 L7 f' c9 tcon.commit();
System.out.println();
}
JOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
+ O6 f+ m6 w& {public void addCourseToJCheckBoxCourse() {
: {) `- X/ a- l$ U& QString courseName = null;
5 p9 f& i. Q6 H# Ssql = "select cname from coursexx";
try {
1 I0 `6 {4 u2 B% d4 xps = con.prepareStatement(sql);
) Z" e( M; w- h1 v$ Q* o0 @/ ]rs = ps.executeQuery();
' R- y( f& D1 |+ TResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
3 [/ k( A( }) f, G1 F* @while (rs.next()) {
for (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
System.out.println(courseName);
jcbCourse.addItem(courseName);
rowCount++;
. D0 J' b8 B- X1 c. C}
}
& T1 K: m7 Y+ O. ?8 M! g; Ucon.commit();
0 _) y3 G! d: Q6 L0 t* q) H3 u} catch (Exception ers) {
ers.printStackTrace();
6 e2 F" U% `' G9 C: c! i% o$ i( ltry {
con.rollback();
+ g% N1 j: {+ P" y& I; S} catch (Exception er) {
er.printStackTrace();
}
}

}

public void searchScore() {
// 每次查询之前清空之前的结果
for (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
1 e) F2 S. l+ xjtAddScore.setValueAt(null, k, i);
}

}
// Method1:JDBC Method2:hibernate
# C5 Q- u" g% U  n. t5 A+ A" AString cName = jcbCourse.getSelectedItem().toString().trim();
3 s' V; ?% \8 r6 J+ H+ C  w0 Rsql = "select x.sname,k.term,k.cno from "
: I  k- z0 w8 }% v! K, F- A0 R& _+ "choicesxx x join Coursexx k "
! H4 z; Q) e- H3 r- ^, l+ |% l9 n+ "on x.cno=k.cno and k.cname=?";
try {
  Z: s5 Z, k0 B% T( M& Aps = con.prepareStatement(sql);
: ?" @" u6 [& E4 K- Yps.setString(1, cName);
& V0 H! H' o) l' A3 C1 krs = ps.executeQuery();
; l  m2 W, k/ k. {3 I- imeta = rs.getMetaData();
cols = meta.getColumnCount();
boolean flag = true;
String result = null;
. B. ], C$ A+ O) Z9 sint k = 1;
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
result = rs.getString(i);
- p! m: |+ j4 |( ^% q7 e9 z4 DjtAddScore.setValueAt(result, k - 1, i - 1);
* K* |" H( S  J  C6 {1 Z7 x' ~}
rowCount = k++;
}

} catch (Exception exx) {
exx.printStackTrace();
}
9 o/ l5 z) z. U. {}

//产生用户界面

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

JLabel jlCourse = new JLabel("课程：");
" a# U9 I* l1 w9 g; xjcbCourse.addActionListener(this);
& \8 g" V3 T/ U8 |( g; @/ [jcbCourse.addItem(new String("请选择课程"));
addCourseToJCheckBoxCourse();
5 D" a1 k7 r% h" q' F3 uthis.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
6 w& _0 y0 [, s$ K# @// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
9 ^5 h( J8 y0 l7 g' ~// addClassNameToJCheckBoxClassName();
% Z2 y6 x  R  e0 }* N# v9 r  t// this.add(jlClassName);
  |) B: H( ^- R3 V9 C// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
# B, r% l$ U. [// jcbTerm.addActionListener(this);
* @+ X* k: o6 e$ D0 ?" B7 j: ]// jcbTerm.addItem(new String("请选择学期"));
6 H/ T3 o# h+ \// addTermToJCheckBoxTerm();
// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
1 q& B" J7 I3 K5 R4 Q* s; i0 ajbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
jbExit.addActionListener(this);
5 Z4 ]/ n4 x  x, N! N5 }/ pthis.add(jbSearch);
  v- D7 h. C. a3 V; E$ \1 B! C8 fthis.add(jbOK);
this.add(jbExit);

this.add(jspScore);

this.setVisible(true);
, l% r% }) G. W; x! f, I* A- r$ |  othis.setSize(500, 600);

}

public static void main(String[] args) {
3 b! k; ]. Y) Inew AddScore();
}
7 J* U/ j, ]/ l0 `( r4 }" a6 j. A}

. W. h% I9 n3 U4 Z4 `8 L4 G