Java成绩管理系统源码

蕾蕾

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

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

6 m/ a* b6 A" @' \  y$ W//代码如下：
import java.awt.*;
( I0 `+ c( w3 V; Aimport 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 {
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();
// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
ResultSetMetaData meta = null;
String sql = null;
int cols = 0;
3 T8 y" Z& c5 k+ ~- k2 m/ }int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
1 k7 ^' Y% R8 i: U}

public void actionPerformed(ActionEvent e) {
2 _" ?( R/ l) f* N) sString str = e.getActionCommand();
if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
. b- j9 H& z5 y$ \1 }2 M: n& tsearchScore();
} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
3 C2 K" Y6 w- o! Z) V& MtryCommit();

} else if ("退出".equals(str)) {
0 F2 ~2 N3 G6 X" ^' L6 {! ^3 }this.setVisible(false);
}
  `' C+ h/ n7 b6 [}
4 a3 p: u) I( _" W0 Spublic void tryCommit() {
if (cols < 1)
8 p" K3 r1 S: Z+ U7 Z) R, dreturn;
/ u/ ?8 O( ]. k7 r8 b" Vsql = "insert into scorexx values(?,?,?,?)";
try {
  [* a$ G: {& X% B" g* eps = con.prepareStatement(sql);
0 C& p6 j" \- HString[] value = new String[4];
9 l% f2 S( K# h+ ~7 Z( y2 Zfor (int k = 0; k < rowCount; k++) {
5 k, N! g/ e# W4 {; N! Yfor (int i = 1; i <= cols + 1; i++) {
/ T; Q- p: y3 L( _// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
+ s3 ], @- H5 k6 J# {7 }value[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
6 l* v0 p9 ]7 w, a} else {
if (i == 4)
JOptionPane
.showMessageDialog(null, "无效成绩输入！成绩不能为空");
  |+ O! o' V2 t: yreturn;
; }3 ]+ b3 n2 ^; A/ R* M; t}
4 w9 f8 s' f4 Z/ A9 g// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
8 ~8 d  r6 [3 c: ], P$ l* {// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
  }0 Q6 H! I9 [" _% V" F. \, X" E// }
// }
System.out.print(value[i - 1]);
}
: ]1 X; P/ }) m( k/ Aps.setString(1, value[0]);
% e$ \* L" g9 c, S  l  Aps.setString(2, value[1]);
ps.setString(3, value[2]);
$ h$ T; A. M3 `  e0 Hps.setInt(4, Integer.parseInt(value[3]));
/ y2 m7 q3 a4 `' R# c) bps.executeUpdate();
' X2 Y6 M- g, P6 O7 h  Q  k1 Qcon.commit();
System.out.println();
}
7 s2 H$ E2 O) v, O6 U3 _JOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
# U: G* Z4 A% e! W. `# p} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
& f) l& R' d1 S( a% ~String courseName = null;
# O0 P1 K% Q& V  qsql = "select cname from coursexx";
. t% f0 B% O% l6 J" [try {
2 H: U; ]& j7 o4 C3 o1 C7 v0 L; ups = con.prepareStatement(sql);
, [1 [  Q1 c& C4 t6 Z- ^6 trs = ps.executeQuery();
ResultSetMetaData meta = rs.getMetaData();
1 ]- d% O) j' o. g- Q. w6 L2 tint cols = meta.getColumnCount();
. ]9 b. n; `# c3 Z" Kwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
/ q3 o* R) ]6 s% C- q9 V$ ucourseName = rs.getString(i);
2 o) @$ h* T3 K. P3 n6 c# uSystem.out.println(courseName);
& X1 F( O% o- n9 K* J: ?- IjcbCourse.addItem(courseName);
rowCount++;
! H% a+ r" b" K/ r9 z; }}
}
( Y: W9 A+ X1 t% @* lcon.commit();
2 X2 v  q$ f% w, z1 m; Q1 R} catch (Exception ers) {
* W& r! S# [0 S3 a0 l+ p5 G. @5 rers.printStackTrace();
try {
8 J4 g  u, ~' p$ s- m0 B! |8 econ.rollback();
} catch (Exception er) {
+ D& ~" m7 z. z% k* m( |. Z! @5 ker.printStackTrace();
0 W$ O+ l- v. E0 S) P" h! u}
}

}

0 u% q5 l" p4 r1 `0 @

public void searchScore() {
+ P  W: z0 i6 J& A6 w+ E// 每次查询之前清空之前的结果
9 g# ~. e) ~1 ~4 ^7 X1 N1 Gfor (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
% Z) G% f. [" e( S; i- ~jtAddScore.setValueAt(null, k, i);
}

}
- R% ^& c9 C  N0 I// Method1:JDBC Method2:hibernate
1 x/ B' {2 v% o6 KString cName = jcbCourse.getSelectedItem().toString().trim();
. D6 G7 D/ F$ b2 O; F1 L- I! ?sql = "select x.sname,k.term,k.cno from "
+ "choicesxx x join Coursexx k "
* F* p$ C/ J2 Y  {8 s# H4 `+ "on x.cno=k.cno and k.cname=?";
try {
6 B$ w& ^+ y, E9 e* d+ z) K- G& Zps = con.prepareStatement(sql);
& n4 `& u* U! F, O6 X% }ps.setString(1, cName);
rs = ps.executeQuery();
6 R2 j+ ^0 p4 X8 w! O7 ometa = rs.getMetaData();
cols = meta.getColumnCount();
boolean flag = true;
String result = null;
int k = 1;
' g, G0 t$ _. b" J9 Dwhile (rs.next()) {
2 z# \% x2 M, o: K/ ]9 C3 j( c1 Hfor (int i = 1; i <= cols; i++) {
* C) y4 h; X3 F) t: x) x+ {result = rs.getString(i);
jtAddScore.setValueAt(result, k - 1, i - 1);
, D3 D' I: C: C  n* v' q3 V}
rowCount = k++;
5 J! ?% W3 K/ F+ ?}

} catch (Exception exx) {
exx.printStackTrace();
}
& ^9 u3 Y& H0 W, U# j}

//产生用户界面

public void CreateAddScoreGUI() {
0 _# x7 {4 f) w$ _6 Qthis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
9 u, G: |1 m: M; k" LjcbCourse.addActionListener(this);
jcbCourse.addItem(new String("请选择课程"));
; W- K3 n+ T# g) q0 XaddCourseToJCheckBoxCourse();
this.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
. B+ y, m" Q" X1 X3 Q) L// jcbClassName.addActionListener(this);
- }3 s, m6 w1 ?+ Z9 o+ W// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
// this.add(jlClassName);
1 G/ x3 ]. @- c6 X) D// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
// jcbTerm.addActionListener(this);
# E, B. ^% x3 G& P// jcbTerm.addItem(new String("请选择学期"));
) n2 d* O3 _7 w6 D$ J8 S6 i/ D) x// addTermToJCheckBoxTerm();
1 ~1 k0 O, Z. i6 u9 |// this.add(jlTerm);
4 i( F! d. D' r" J// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
* V8 f# u' j7 a8 FjbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
jbExit.addActionListener(this);
: m0 M( e* p" D# `. s% B- Ethis.add(jbSearch);
1 q5 t1 ?: T+ j( D: L5 s) l0 Qthis.add(jbOK);
this.add(jbExit);

this.add(jspScore);

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

}

public static void main(String[] args) {
  z$ N1 c& u% Y2 Y. {new AddScore();
1 G) Y* |- y, m9 e& q( `# o}
% u5 S  t! z* h6 G8 g/ Q# b5 w( g}