Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
9 _! D+ \7 q$ \' m$ Vimport java.awt.*;
import java.awt.event.*;
% O' ~& E) L9 g. ?5 g% u$ `import java.sql.*;

import javax.swing.*;
2 H. u/ L5 [/ J1 r# @: dimport javax.swing.table.DefaultTableModel;

import school.schoolPicture.JdbcUtil;

public class AddScore extends JPanel implements ActionListener {
; A( \( T  E. G2 t' MString[] 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();
1 ~2 d( `6 S# ~# N' S# E* zConnection con = JDBCUtil.getConnection();
// Connection con2 = JdbcUtil.getConnection();
6 S1 a8 z# t! p* ]( k: PPreparedStatement ps = null;
ResultSet rs = null;
ResultSetMetaData meta = null;
String sql = null;
& U, p. m# K! Y4 l/ jint cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
/ |% M7 g( M1 ]: O9 C  e}

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

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

//当点击提交时，用tryCommit()方法对其进行处理
6 O9 |* z& t/ i) d  B6 ?tryCommit();

} else if ("退出".equals(str)) {
this.setVisible(false);
}
}
public void tryCommit() {
' m) |. W/ W' c7 [2 N. b2 eif (cols < 1)
return;
sql = "insert into scorexx values(?,?,?,?)";
try {
0 }/ M  b$ h( u0 d* \7 rps = con.prepareStatement(sql);
String[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
7 m' `- F, t' h2 H, u$ l; _for (int i = 1; i <= cols + 1; i++) {
// 如果成绩为空，取消提交操作，并给出提示。
, F' H$ k) f" V' K, t4 V3 q% Fif (jtAddScore.getValueAt(k, i - 1) != null) {
# I& C) I: O, ^- G; Q# n5 g* nvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
} else {
if (i == 4)
4 M) b% E( l% iJOptionPane
6 ]7 a! ^6 K' c! `.showMessageDialog(null, "无效成绩输入！成绩不能为空");
, a6 O  c5 N) `- c8 k7 q# D) Treturn;
2 ~' G* ~% y3 `7 p$ q. A}
* T9 D0 c0 D' z+ C7 i8 [// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
/ b" ~7 H/ ]: @- U; j- ~  O2 a0 q4 \// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
4 s9 L/ p6 v6 H( B: ]// if(
// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
6 ^, r* w, d6 v: t) O4 A// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
; v: U3 t, T7 \4 C6 B! V: y9 z! _// return;}
// }
' c$ S5 V0 I! ^4 R; R( X// }
System.out.print(value[i - 1]);
* B& @& O6 e- r3 p0 X9 {5 w}
( T! t) R9 L, d2 Q# V' ops.setString(1, value[0]);
ps.setString(2, value[1]);
4 u, @0 k. ^$ }2 L5 F1 _' Aps.setString(3, value[2]);
ps.setInt(4, Integer.parseInt(value[3]));
7 E% V# R( M3 D9 I+ x9 R& e9 ]( }ps.executeUpdate();
con.commit();
System.out.println();
% \2 Y3 P! n" ?8 c}
$ M8 J3 Y, [2 S+ K: k  I. S) ?JOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
2 T; h5 Z8 c; J; X3 ppublic void addCourseToJCheckBoxCourse() {
+ d- z  t6 h6 e* y2 W$ Z( WString courseName = null;
0 @% v. |% Q: usql = "select cname from coursexx";
& f4 i8 W" _5 _8 R2 F7 @/ K$ @try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
; p0 `' L" n6 m3 U. E" hResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
4 T/ z3 t8 K' e+ g1 jfor (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
System.out.println(courseName);
( G0 g- F" w9 p$ ?" ~0 l+ o' m$ l% pjcbCourse.addItem(courseName);
rowCount++;
}
7 s1 d: E9 K) Q1 z1 z}
" O! y# b" I2 [9 Jcon.commit();
} catch (Exception ers) {
- `1 r6 J7 U. I4 V0 N" ?  W9 W) a% |ers.printStackTrace();
try {
con.rollback();
} catch (Exception er) {
er.printStackTrace();
}
: S  S& b  U7 G2 R* M( ^& {1 F( |}

}

- R1 E3 l% \3 u3 |" B

public void searchScore() {
8 H9 q& Z7 C6 r& P// 每次查询之前清空之前的结果
7 ?1 m$ K: J& Sfor (int k = 0; k < 50; k++) {
) D5 U8 H% k7 v$ R- Y; l, Jfor (int i = 0; i < cols; i++) {
! d% S/ o5 t! D0 {! m2 RjtAddScore.setValueAt(null, k, i);
}

}
+ r, S! c6 _% H// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
+ "choicesxx x join Coursexx k "
+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
ps.setString(1, cName);
rs = ps.executeQuery();
meta = rs.getMetaData();
( O+ \; n7 w6 kcols = meta.getColumnCount();
boolean flag = true;
( B$ r3 `* S! x* [8 b4 PString result = null;
int k = 1;
2 q, _5 I9 r5 D" g8 l/ m; Q/ U3 _) kwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
, `. Z# w) K/ E( n9 v: Zresult = rs.getString(i);
jtAddScore.setValueAt(result, k - 1, i - 1);
9 `) ?/ y( i  a" U4 }7 I}
  e* r: f: n1 ~' C! B/ ^rowCount = k++;
}

} catch (Exception exx) {
exx.printStackTrace();
# o, |* l* Q5 c4 |}
}

4 o- L9 `8 K/ o2 J, [; N7 o+ J+ t

//产生用户界面

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

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
4 g8 F+ R1 _" h6 V1 b! ^( K* v0 l! gjcbCourse.addItem(new String("请选择课程"));
addCourseToJCheckBoxCourse();
this.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
% w4 ^# @. G( P+ K// addClassNameToJCheckBoxClassName();
& I+ O5 }, G' a1 n// this.add(jlClassName);
1 R0 N$ X/ x3 D* T6 T3 K// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
* [+ s9 ~: t3 _4 C) p" _; m// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
. t9 {) ?5 Z6 L! H3 q* W( Y// this.add(jlTerm);
$ D4 w' F# V, K6 S. W: }// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
+ `' l! ?0 e' E2 a' n! ]. ?jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
2 A+ S  c9 ]0 [9 i- h4 D4 s% PjbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
jbExit.addActionListener(this);
& `8 Z8 j) a6 e: g) e9 cthis.add(jbSearch);
$ y. ^. e4 O9 ithis.add(jbOK);
& y: T' M+ f. ^7 Z4 v- a% b  ?2 Rthis.add(jbExit);

this.add(jspScore);

this.setVisible(true);
+ W  }5 J* T0 ~; Ethis.setSize(500, 600);

}

public static void main(String[] args) {
9 P  k& i+ T3 I" e4 O& H; Unew AddScore();
}
}