Java成绩管理系统源码

蕾蕾

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

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

//代码如下：
- M" g; C* }; l0 h6 Bimport java.awt.*;
import java.awt.event.*;
1 I* j% e( x; c# g- [1 Fimport java.sql.*;

import javax.swing.*;
/ d( |  J5 B" J( M6 ^/ u. @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();
5 `0 @6 L: |2 [" `Connection con = JDBCUtil.getConnection();
* R3 B5 Z! X( n9 Z- y- N: Z8 n. Y// Connection con2 = JdbcUtil.getConnection();
PreparedStatement ps = null;
ResultSet rs = null;
ResultSetMetaData meta = null;
String sql = null;
& {. v2 f2 x9 Fint cols = 0;
int rowCount = 0;

public AddScore() {
CreateAddScoreGUI();
8 {+ v1 Q$ V2 N. t* Q7 p. C}

public void actionPerformed(ActionEvent e) {
5 q0 T# X" w, u* }# s. _; C* xString str = e.getActionCommand();
: L# R( W% P8 s! J! Jif ("查询".equals(str)) {

//当点击查询时，用searchScore()方法对其进行处理
; }. J. B& G; @3 h# \searchScore();
} else if ("提交".equals(str)) {

//当点击提交时，用tryCommit()方法对其进行处理
tryCommit();

} else if ("退出".equals(str)) {
this.setVisible(false);
$ h8 v. K+ w! ?* K+ f* j# ]0 Z}
}
public void tryCommit() {
6 B3 A0 z, G2 `3 e9 A! w' cif (cols < 1)
1 L7 W5 t1 H: Y. i; G' Y7 Qreturn;
8 j* O: G# l0 n8 Ksql = "insert into scorexx values(?,?,?,?)";
( j8 Z+ T! \6 t" g# itry {
ps = con.prepareStatement(sql);
String[] value = new String[4];
for (int k = 0; k < rowCount; k++) {
for (int i = 1; i <= cols + 1; i++) {
// 如果成绩为空，取消提交操作，并给出提示。
if (jtAddScore.getValueAt(k, i - 1) != null) {
, ^2 c% h# S  D+ O7 qvalue[i - 1] = jtAddScore.getValueAt(k, i - 1)
.toString();
} else {
& P- E8 C0 i: E% J5 Yif (i == 4)
JOptionPane
) N. m! P7 U2 Q& n. G0 h/ s.showMessageDialog(null, "无效成绩输入！成绩不能为空");
. }4 }5 R0 {$ H& w  |return;
6 X! d: ^' D! O1 @! E9 v6 P}
// 如果成绩字段里面不是数字，则取消本次操作??
// String str = "^[0-9]{1}[0-9]?[0-9]?$";
: ]  i1 n  j, Z) K7 j) ^// if (i == 4) {
// if(jtAddScore.getValueAt(k, i - 1) instanceof Integer){
2 e. Q: y% W  h) _8 @// if(
6 g, s7 N* m8 p9 P$ Y+ V// Integer.parseInt(value[3])<0||Integer.parseInt(value[3])>100)
8 b9 k4 f1 A; R2 d% Q// {JOptionPane.showMessageDialog(null, "成绩只能大于0且小于100");
" k7 o' M0 a  K5 A0 N6 F, @( w) D+ G7 K// return;}
// }
// }
System.out.print(value[i - 1]);
}
ps.setString(1, value[0]);
( s2 R0 N% A7 pps.setString(2, value[1]);
ps.setString(3, value[2]);
; n& l0 s* a; D& \- g$ e; sps.setInt(4, Integer.parseInt(value[3]));
ps.executeUpdate();
con.commit();
System.out.println();
}
$ }8 T9 q; M7 J4 S: R# d/ [" \( u( TJOptionPane
.showMessageDialog(null, "提交成功：更新 " + rowCount + " 条记录！");
} catch (Exception ew) {
ew.printStackTrace();

}

}

// 自动添加课程下拉列表中的课程
, ~) ]7 l* A9 }public void addCourseToJCheckBoxCourse() {
String courseName = null;
2 T/ g0 R" F7 a/ lsql = "select cname from coursexx";
0 @3 F/ X# V+ q" K+ Otry {
ps = con.prepareStatement(sql);
- G$ T' T, T1 b- ~5 Q( ^: y, ers = ps.executeQuery();
& L6 C! Z* u$ G# ], eResultSetMetaData meta = rs.getMetaData();
int cols = meta.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= cols; i++) {
3 [& b2 J5 T. KcourseName = rs.getString(i);
0 j2 s3 @7 z  Q4 |! r7 {System.out.println(courseName);
4 H' [+ A4 b4 ]  rjcbCourse.addItem(courseName);
" h. q0 n! ]. I# h3 krowCount++;
6 ^* c3 v% v! k0 q2 f: N' s% M7 O}
}
% W/ P3 M0 e8 H# v  [9 ccon.commit();
} catch (Exception ers) {
ers.printStackTrace();
4 M" L% ~' z4 b$ O* _try {
1 p! b2 }5 D8 `3 _8 {# ccon.rollback();
} catch (Exception er) {
. e& r. s; Y/ Ser.printStackTrace();
+ b* n  a8 z; P- ~}
}

}

5 s. S% u" y  q* J$ [. S

public void searchScore() {
// 每次查询之前清空之前的结果
, r1 ^6 [8 k7 a0 V# _! R" k& Ofor (int k = 0; k < 50; k++) {
for (int i = 0; i < cols; i++) {
# X& o$ W  o3 V, v$ H9 z5 `' j6 r; T9 N& {jtAddScore.setValueAt(null, k, i);
( O/ r8 ^0 U' H, s0 I& I' n1 v; z}

}
// Method1:JDBC Method2:hibernate
String cName = jcbCourse.getSelectedItem().toString().trim();
sql = "select x.sname,k.term,k.cno from "
+ "choicesxx x join Coursexx k "
/ F8 T) {0 [6 u4 ?% h  \+ ^; k9 x+ "on x.cno=k.cno and k.cname=?";
try {
ps = con.prepareStatement(sql);
ps.setString(1, cName);
- u4 h* s+ g) n4 ors = ps.executeQuery();
meta = rs.getMetaData();
cols = meta.getColumnCount();
: b0 {) n) p( oboolean flag = true;
3 {  a, x2 j+ b' EString result = null;
2 @7 T% B$ g, g% j) _' @int k = 1;
* a% s. B4 \9 Vwhile (rs.next()) {
for (int i = 1; i <= cols; i++) {
result = rs.getString(i);
* x, J5 b# f3 _jtAddScore.setValueAt(result, k - 1, i - 1);
9 w7 c9 v$ a4 I9 K4 E( _& C' |}
rowCount = k++;
/ D! l" h% `, {2 c- g}

} catch (Exception exx) {
exx.printStackTrace();
0 X8 f' T6 b8 ^! a}
}

//产生用户界面

public void CreateAddScoreGUI() {
& X4 \) X3 X8 Vthis.setLayout(new FlowLayout());

JLabel jlCourse = new JLabel("课程：");
; b" M( q' Q, c; f  OjcbCourse.addActionListener(this);
9 h9 K3 q& i) p6 F. m/ ujcbCourse.addItem(new String("请选择课程"));
" T  n& ~* r' g/ daddCourseToJCheckBoxCourse();
this.add(jlCourse);
- k! `- P( A* I6 ethis.add(jcbCourse);

// JLabel jlClassName = new JLabel("班级：");
1 X7 G0 Y3 z# S6 m& P& F$ b// jcbClassName.addActionListener(this);
// jcbClassName.addItem(new String("请选择班级"));
2 V: }2 @. n2 n. |) a// addClassNameToJCheckBoxClassName();
* m! l8 ]/ }# i8 W# ]4 g9 x// this.add(jlClassName);
8 I# b4 F0 e. z7 ]// this.add(jcbClassName);

// JLabel jlTerm = new JLabel("学期：");
. \) X% ?6 ?) ~5 D3 r- [- z; y// jcbTerm.addActionListener(this);
// jcbTerm.addItem(new String("请选择学期"));
  J, D3 D0 x( R1 g// addTermToJCheckBoxTerm();
% s9 b/ @. A; G( T1 t// this.add(jlTerm);
// this.add(jcbTerm);

JButton jbSearch = new JButton("查询");
jbSearch.addActionListener(this);
JButton jbOK = new JButton("提交");
1 f6 j7 l% n" r/ AjbOK.addActionListener(this);
: @* Y) z' Z! g. |4 E& CJButton jbExit = new JButton("退出");
; d. D& G, O5 Q: Q0 |( U: o8 VjbExit.addActionListener(this);
this.add(jbSearch);
this.add(jbOK);
7 G0 E% [1 l2 g4 \* athis.add(jbExit);

this.add(jspScore);

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

}

public static void main(String[] args) {
6 g. B4 F: U2 Onew AddScore();
}
& F8 C. M( R6 q8 `0 s. v}