Java成绩管理系统源码

蕾蕾

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

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

( x6 s" |- h  M//代码如下：
import java.awt.*;
import 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();
# K. P, `! G& a// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
. y/ N: U4 \/ ]5 q- g! E- CResultSet rs = null;
ResultSetMetaData meta = null;
* j- Z" T) O; P8 b6 k3 s7 _String sql = null;
int cols = 0;
& e7 z/ K" O+ _4 @  I( lint rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
}

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

//当点击查询时，用searchScore()方法对其进行处理
searchScore();
' _* c, Q- }. {/ \) g: S; M' l} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
; s  [$ h" u3 c. l' D# l( dtryCommit();

} else if ("退出".equals(str)) {
9 o$ W# k2 k: K4 M/ S7 G3 e  s1 T0 jthis.setVisible(false);
}
- l+ l1 v# K, x5 k+ O+ i  q}
3 `4 o  {' d( O& J4 s! }public void tryCommit() {
if (cols < 1)
return;
+ |! @: k. [6 u9 _% ~' D' W: w. h' p$ Tsql = "insert into scorexx values(?,?,?,?)";
try {
- V6 A: U( Z3 `0 H: @6 Ops = con.prepareStatement(sql);
5 I" M4 a# V( e) T( E5 H% L3 z# `5 DString[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
; F$ G0 R1 q% R( i' Q9 \! D7 n6 l// 如果成绩为空，取消提交操作，并给出提示。
( ?. e8 P2 m+ a5 u* r% @if (jtAddScore.getValueAt(k, i - 1) != null) {
* T7 _/ l4 E' ]4 A! h8 Qvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
} else {
if (i == 4)
JOptionPane
$ m; O+ n! d7 J4 w6 f.showMessageDialog(null, "无效成绩输入！成绩不能为空");
return;
}
// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
// if (i == 4) {
% t6 P! r  o. i; }# v* q// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
// if(
1 j! M7 |6 T3 `# C9 ^- w// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
// return;}
// }
  [& M/ a$ m2 C; O- u, K# F* N/ F/ z2 h% j// }
  o3 a4 ]' M; a4 v! Y7 ~. nSystem.out.print(value[i - 1]);
}
ps.setString(1, value[0]);
ps.setString(2, value[1]);
ps.setString(3, value[2]);
) D3 v8 H1 [# M& D2 xps.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
: S* {  p4 t& ^* W3 H' ]System.out.println();
}
JOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
& w6 B6 _5 u2 H- g  u+ A} catch (Exception ew) {
  I+ c$ B; G2 P: `ew.printStackTrace();

}

}

5 \5 m* S+ t+ D' Q( H, J5 U3 L

// 自动添加课程下拉列表中的课程
9 P4 r, E% x4 a8 `: e# y: npublic void addCourseToJCheckBoxCourse() {
String courseName = null;
7 }/ e0 @9 Q' g7 ?5 ~sql = "select cname from coursexx";
try {
ps = con.prepareStatement(sql);
rs = ps.executeQuery();
ResultSetMetaData meta = rs.getMetaData();
1 |+ F9 Y) Y. Cint cols = meta.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
/ T" U+ e; G) B: @% Y. o5 U! vcourseName = rs.getString(i);
4 d' j+ E5 A) Q& HSystem.out.println(courseName);
) Q" _3 z& L  y' zjcbCourse.addItem(courseName);
rowCount++;
4 R2 \5 J0 A7 t2 i# g" o3 l}
  P; T6 Z- f8 w, M. P}
con.commit();
7 C; J8 E. S( ~( m} catch (Exception ers) {
ers.printStackTrace();
try {
( d% |) y/ V6 L# c8 ]con.rollback();
} catch (Exception er) {
* Z' O$ d' u5 K2 ler.printStackTrace();
4 p) o6 ]9 E) N- \2 Z}
) k5 b- j' B, A. g. f5 G4 p}

}

public void searchScore() {
// 每次查询之前清空之前的结果
/ }* L6 z) T9 b( m- C' ~2 n  v+ ofor (int k = 0; k < 50; k++) {
( r( _* N3 {8 @& `3 }/ _4 q' I2 V6 H) C+ |for (int i = 0; i < cols; i++) {
6 R/ }' O" I8 ]0 M; u& ZjtAddScore.setValueAt(null, k, i);
) h; o: J; C" p) o! y}

}
// Method1:JDBC Method2:hibernate
2 p6 D1 O1 l" O0 LString 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=?";
8 ?6 f/ i( X, r6 J+ V/ l1 d, ctry {
ps = con.prepareStatement(sql);
# S+ f& J  g5 f5 k, \ps.setString(1, cName);
rs = ps.executeQuery();
2 h3 W& I: }& i5 g0 p" ?2 \0 T3 Y$ ymeta = rs.getMetaData();
cols = meta.getColumnCount();
boolean flag = true;
) p+ g# s( H2 j; VString result = null;
int k = 1;
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
result = rs.getString(i);
# i, r1 ]- q1 X# l/ kjtAddScore.setValueAt(result, k - 1, i - 1);
+ l5 _( W2 U" [% t9 L7 K}
rowCount = k++;
}

} catch (Exception exx) {
  H( R) t" A% \9 v+ \exx.printStackTrace();
+ a, U6 Y  ~# V2 M1 X2 i}
2 _, G3 X6 |% W, A1 ?}

//产生用户界面

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

JLabel jlCourse = new JLabel("课程：");
jcbCourse.addActionListener(this);
jcbCourse.addItem(new String("请选择课程"));
# l( t& u- O  QaddCourseToJCheckBoxCourse();
  ]5 s; B6 z$ W5 x2 n* s+ y, ithis.add(jlCourse);
this.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
// addClassNameToJCheckBoxClassName();
; a; z+ [# k5 f) \! r) T5 d// this.add(jlClassName);
, v2 `0 |* V; [0 z// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
, L% R* R- [8 K// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
// addTermToJCheckBoxTerm();
( X+ ]- {- Y8 {8 ?// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
7 q' v7 S7 r( B# X# TJButton jbOK = new JButton("提交");
! Y/ }1 H. J1 R: L, L3 J- ujbOK.addActionListener(this);
JButton jbExit = new JButton("退出");
9 M& t2 _" N( `jbExit.addActionListener(this);
this.add(jbSearch);
this.add(jbOK);
this.add(jbExit);

this.add(jspScore);

this.setVisible(true);
# h% b. i$ c8 Q: h3 hthis.setSize(500, 600);

}

public static void main(String[] args) {
' q/ X; s# V* \) o' Jnew AddScore();
/ |5 l7 Y6 M% `: _3 U$ n7 V}
8 j* ]7 Y3 z  k5 Y! y1 r( d}