Java成绩管理系统源码

蕾蕾

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

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

: g# a, _& r' V$ F: ]9 O% w//代码如下：
' ~+ q  |, K& Qimport java.awt.*;
import java.awt.event.*;
$ o6 F  r; A( U0 ]7 bimport 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();
" }2 _. \& q0 _! o( ^7 q0 kConnection con = JDBCUtil.getConnection();
* u6 a3 }9 a( w/ n/ B// Connection con2 = JdbcUtil.getConnection();
9 G( U$ S" t$ c: h' ^& T6 @PreparedStatement ps = null;
ResultSet rs = null;
9 B" V& J$ F( v! c1 A1 JResultSetMetaData meta = null;
String sql = null;
int cols = 0;
int rowCount = 0;

public AddScore() {
" e7 ]0 A7 x# d8 d# ]CreateAddScoreGUI();
9 S8 y! J- _/ w" ~( G& p}

public void actionPerformed(ActionEvent e) {
0 k9 r# S. r- ?6 qString str = e.getActionCommand();
& O- i' o, o1 f" a( q) ?if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
; v6 w3 t4 b' @4 OsearchScore();
7 }- E) f# v0 o/ t5 F} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
6 \# @3 `$ j0 r) D1 c4 `) E! U" |tryCommit();

} else if ("退出".equals(str)) {
& R/ z2 t, p8 |& `! athis.setVisible(false);
}
2 R1 _) {6 Z- }4 N! E) h/ _}
0 B: p1 t+ z( x/ {$ l- ]public void tryCommit() {
  r& [# S& m5 \" ?! J/ zif (cols < 1)
3 ?4 |& C, x9 Z8 D" j& W8 S% wreturn;
/ x% G" W4 X: P7 Csql = "insert into scorexx values(?,?,?,?)";
try {
' p4 x5 h% L4 Dps = con.prepareStatement(sql);
String[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
: J3 |- W0 J; l. X7 k8 kfor (int i = 1; i <= cols + 1; i++) {
// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
* c8 L6 V$ P! {* W1 Uvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
; B, o& O9 v9 W/ Y6 l.toString();
} else {
if (i == 4)
JOptionPane
; g  n  c# b+ }" n& p; P/ p.showMessageDialog(null, "无效成绩输入！成绩不能为空");
return;
' ~3 `! d3 m$ `5 V}
: L) w( s. d9 I1 x4 o& o// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
" o' I' D# J; z( c: S// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
// if(
+ r) F9 l3 G  p3 T" }3 F// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
' r0 C7 M$ ]& y5 W* D' N4 j" W// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
! s3 _' @* w' \* q// }
8 A3 t8 g" y2 z) Q+ R// }
9 v9 k' h; L. X! C" \: B. RSystem.out.print(value[i - 1]);
}
ps.setString(1, value[0]);
. I0 O4 L! Z1 f9 u! i: u8 ~  S5 `2 O! yps.setString(2, value[1]);
9 O5 Z; Q0 R- b, D0 G6 rps.setString(3, value[2]);
" L4 B  N3 P% R% a- J& Ips.setInt(4, Integer.parseInt(value[3]));
# u( w8 I- R" J3 `ps.executeUpdate();
con.commit();
System.out.println();
+ j$ X9 M$ q9 X, Y2 p8 T- E}
JOptionPane
- }1 @0 [, h1 e, a# p.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
" m! f  G9 k, W7 e/ a} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
String courseName = null;
sql = "select cname from coursexx";
try {
: s2 [) [' I/ e. L: j0 j9 ops = con.prepareStatement(sql);
0 @* h2 P/ I( X' @3 \rs = ps.executeQuery();
ResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
: u5 \. @2 _+ z8 jwhile (rs.next()) {
' f* J/ t  |" ?- l: ufor (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
9 {0 d' P; Z0 }$ t- F& z/ YSystem.out.println(courseName);
jcbCourse.addItem(courseName);
rowCount++;
}
% o* r, Y6 Z8 B}
- [) e' X8 x: `9 Xcon.commit();
} catch (Exception ers) {
ers.printStackTrace();
# g! p- o) V1 ~  M8 btry {
con.rollback();
+ q. M* d9 t, p* g" |} catch (Exception er) {
er.printStackTrace();
. D; i4 {3 k  X: j  N8 g/ X0 w$ f+ ?}
}

}

public void searchScore() {
! c2 Y: ^: F, T( }' l// 每次查询之前清空之前的结果
for (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
jtAddScore.setValueAt(null, k, i);
* D2 n5 t5 v/ ^* S}

}
// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
  R. ?' `2 O* J9 M+ "choicesxx x join Coursexx k "
# Y" r# b7 P3 x& \+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
ps.setString(1, cName);
rs = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
boolean flag = true;
String result = null;
" a1 i/ o3 a  x! s2 h$ M  uint k = 1;
- F! z8 s) X8 G: B, j( \% Ewhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
5 N6 [; J4 o3 Nresult = rs.getString(i);
; k4 e) i2 r0 }1 o+ p% djtAddScore.setValueAt(result, k - 1, i - 1);
3 `! s8 M0 c( A3 n3 @}
: S( c( Y2 G4 n$ [; _6 L% p6 b: c$ rrowCount = k++;
& `  f2 |/ f  S! c}

} catch (Exception exx) {
exx.printStackTrace();
( c1 [) ^' q3 ?' ^9 f}
& ?+ \1 Q% d8 ~: D$ m% D- I}

//产生用户界面

public void CreateAddScoreGUI() {
7 p9 J- U: i# y6 n- \this.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
1 _" o% Q& v/ O$ j( {9 njcbCourse.addItem(new String("请选择课程"));
+ y( U( @* f( c8 AaddCourseToJCheckBoxCourse();
, @) A* E7 Y3 z  [this.add(jlCourse);
) H$ `" o' `& f, @8 N+ S6 nthis.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
8 W) `; t+ A+ B* ~" C// this.add(jlClassName);
// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
// jcbTerm.addActionListener(this);
$ Y1 d. [3 R9 D% O, N0 i( P* {// jcbTerm.addItem(new String("请选择学期"));
5 a& l, m. `* o// addTermToJCheckBoxTerm();
8 [2 R/ ]2 k0 P% l/ t// this.add(jlTerm);
3 M% o$ S+ Q+ J# D+ D// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
/ ]# f6 B# ?5 Y" J5 A  {jbOK.addActionListener(this);
4 U; B, ~6 A. jJButton jbExit = new JButton("退出");
% h! t; \, N0 x' c) o" a+ D2 F4 njbExit.addActionListener(this);
2 Q) j# X0 L* _% L" uthis.add(jbSearch);
2 {% z7 W! Z4 k: c+ u: o8 [this.add(jbOK);
this.add(jbExit);

this.add(jspScore);

this.setVisible(true);
! o! w0 i/ ]# B- t- ?' {4 @+ }this.setSize(500, 600);

}

public static void main(String[] args) {
new AddScore();
' R! a: p9 p' z, f" e}
}

: w. H& g) z: b! w4 P" q" y