Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
, I- |/ ]3 n1 ~- {8 Oimport java.awt.*;
4 u# k9 h6 S7 }3 B, wimport 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();
; w; ^) H  w4 a# d/ g1 ]0 g7 jConnection con = JDBCUtil.getConnection();
1 m: R# h  e& [% y# f// Connection con2 = JdbcUtil.getConnection();
; D' @- F! Q/ W' |) r" ]' l& FPreparedStatement ps = null;
" o' d: Q% G2 w  v' l# N4 o) kResultSet rs = null;
' V2 H* \5 B- H" bResultSetMetaData meta = null;
String sql = null;
int cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
- ^. @; j( p1 g% v) i+ O}

public void actionPerformed(ActionEvent e) {
) Y2 V  @/ ?% wString str = e.getActionCommand();
if ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
0 ^1 f- X5 U& o7 t5 T6 HsearchScore();
} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
; K4 M; v; t  e) b# S7 ItryCommit();

} else if ("退出".equals(str)) {
) }2 o( R5 T: Z9 A: U) xthis.setVisible(false);
}
}
public void tryCommit() {
if (cols < 1)
return;
sql = "insert into scorexx values(?,?,?,?)";
try {
2 z# i0 A  X# L/ A5 u' C9 fps = con.prepareStatement(sql);
String[] value = new String[4];
7 b+ U( Y$ L# `8 w( l3 gfor (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
& g% A  q1 e! A. O, b// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
6 |+ ?, }5 R) R0 m+ `9 F6 Y4 Evalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
* [" d! B: [2 l9 W) `0 [' `( Q& |} else {
1 \+ M% V1 ?0 Hif (i == 4)
JOptionPane
  l4 a# ~' U( Y) s* y5 W.showMessageDialog(null, "无效成绩输入！成绩不能为空");
return;
! K- u( N1 ?& a' J) K# x}
// 如果成绩字段里面不是数字，则取消本次操作??
) }( h* C% ?9 A# {0 q! k// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
// if(
7 L# Y4 S+ Z0 [' `// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
* i" H% d: ^8 [. R1 V// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
// }
// }
- \, }3 J$ a; b/ @& Z- dSystem.out.print(value[i - 1]);
}
6 K1 A% F& f6 Hps.setString(1, value[0]);
ps.setString(2, value[1]);
ps.setString(3, value[2]);
ps.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
System.out.println();
}
$ c2 m; f( l5 q  V% l* TJOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
} catch (Exception ew) {
. u  M( E  \0 F8 Eew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
public void addCourseToJCheckBoxCourse() {
  r$ l. _" j0 v  a5 F) V# GString courseName = null;
sql = "select cname from coursexx";
try {
+ n% y. @% z! w8 X0 kps = con.prepareStatement(sql);
rs = ps.executeQuery();
; O; F( e0 r2 aResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
! r% ]9 ~0 P! Z, k* @1 Ofor (int i = 1; i <= cols; i++) {
courseName = rs.getString(i);
System.out.println(courseName);
+ e" Q5 G& S, i& W7 ~2 L: Y7 QjcbCourse.addItem(courseName);
rowCount++;
6 N& ^* e, c- U$ k}
2 W4 W9 K3 S, q; V- b) u}
con.commit();
} catch (Exception ers) {
$ ~& M- y$ D# x9 Gers.printStackTrace();
) Z7 F2 p  |/ n7 K$ U9 A% Xtry {
con.rollback();
5 `. j5 w5 [8 M. ^' k- x& _} catch (Exception er) {
er.printStackTrace();
7 Q8 d. I, {/ C* k9 |' b}
}

}

public void searchScore() {
// 每次查询之前清空之前的结果
/ W6 d' R/ y2 \) D" _3 ]for (int k = 0; k < 50; k++) {
' Z, n7 n5 U4 I0 f) ]3 vfor (int i = 0; i < cols; i++) {
jtAddScore.setValueAt(null, k, i);
$ s* J: C$ O: U" O' g* Y}

}
9 r0 Y9 E$ N) S8 p# F$ O// 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=?";
: c4 o5 Z5 G2 f# C3 i6 ltry {
) ^9 s2 F: G! q0 C' Cps = con.prepareStatement(sql);
; q7 J  n7 h$ ]1 \+ S0 Ups.setString(1, cName);
rs = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
2 `4 T% w/ p1 I8 {! w( A/ Jboolean flag = true;
% r/ J- V% e! [9 R, fString result = null;
int k = 1;
' c1 K/ m! c6 X' S0 cwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
! o5 T: y  Y) }# C5 t' a7 bresult = rs.getString(i);
jtAddScore.setValueAt(result, k - 1, i - 1);
" f' T& p& e3 \3 Q; t( g}
% Z/ ]5 x) z! k7 Z( ?0 @" BrowCount = k++;
0 f! o/ J' ^( B3 z+ p}

} catch (Exception exx) {
2 x, W0 e! o0 }* q, ?  Qexx.printStackTrace();
}
}

//产生用户界面

public void CreateAddScoreGUI() {
9 {( i, e- ?' O8 \, k* E9 e% hthis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
* _/ Y1 f6 g- u+ B' {& AjcbCourse.addActionListener(this);
jcbCourse.addItem(new String("请选择课程"));
addCourseToJCheckBoxCourse();
this.add(jlCourse);
2 h* r( d3 C2 Y) rthis.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
; ?% v2 c$ o. p8 @// jcbClassName.addActionListener(this);
. c0 W" g, k- p2 Q8 Y// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
) A2 A" k6 V; s4 ?( t/ Q3 U5 z// this.add(jlClassName);
// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
. C+ K& F- D' w// this.add(jlTerm);
) L* P4 m. h2 N6 |3 l+ Q' ~* U; {* G// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
3 ~7 s; E* L$ {6 djbSearch.addActionListener(this);
; @- u6 L; h5 t" I/ K0 jJButton jbOK = new JButton("提交");
jbOK.addActionListener(this);
, X3 G- C7 t2 RJButton jbExit = new JButton("退出");
jbExit.addActionListener(this);
8 @8 N) Y# L/ I, gthis.add(jbSearch);
this.add(jbOK);
this.add(jbExit);

this.add(jspScore);

this.setVisible(true);
4 d  ^5 g. }! n0 i4 bthis.setSize(500, 600);

}

public static void main(String[] args) {
new AddScore();
0 }' |) {# L; }8 h- s% e- \}
( K" k- X+ P6 n  y/ N8 y+ `}