JAVA课程设计

课程设计（论文）任务书

指导、检查记录

目录

1题目要求 (4)

2系统设计 (4)

2.1功能模块设计1 (4)

2.1.1 功能说明: (4)

2.1.2 必要知识点： (5)

2.2功能模块设计2 (5)

2.2.1 系统逻辑结构设计 (5)

2.2.2 程序运行代码 (5)

3运行结果分析 (21)

4总结 (23)

参考文献 (24)

1题目要求

红河学院成绩查询

功能要求：

1. 根据学号查询学生成绩；

2. 可以按学年、学期查询。

2系统设计

描述为完成题目要求的系统设计，设计可以是按功能，或步骤分解，分解之后的内容要可检查，有相应的代码或文档说明这部分功能。

重点介绍自己负责部分的功能设计，设计可以包括功能模块图、必要的UML图，2.1 功能模块设计1

2.1.1功能说明:

1.创建主类MainFrame，下含4个类，对4个事件按钮添加监控，实现按钮事件为对应类的对象，出现相应功能窗口。

2.创建添加类Insert，题目虽只要求查询学生成绩，但我们不可能再代码中添加学生成绩，故需创建添加按钮，对按钮添加监控，实现按钮事件为获取文本域中的信息。

3.创建查询类QUERY，按照题目要求，分别创建学号，学年，学期三个查询按钮，此外，为了便于查询，又创建姓名和课程两个查询按钮以及一个显示全部信息的按钮。

4.创建修改类Modify，因存在添加类Insert，为了防止添加学生成绩信息时出现错误，故应当建立修改按钮，与添加数据类似，对按钮添加监控，实现按钮事件为获取文本域中的信息，不同的是以学号为主键进行查找并更新。

5.创建删除类DELETE，同理，当学生成绩信息过多时进行删除，且使得窗口界面整洁合理。与修改数据类似，对按钮添加监控，实现按钮事件为获取文本域中的学号信息，不同的是以学号为主键进行查找并将删除信息输出到文本框中。

2.1.2必要知识点：

1.创建图形界面需运用到GUI语句，可参考课本355页的知识。

2.创建图形界面以后需要创建相关按钮，每一个按钮对应一个相关功能类。

3.为每一个按钮添加监听。

4.大致完成以后，修改界面，使其整洁有序，并可以修改界面大小，按钮颜色。

5.添加与修改两个类需要连接到SQL2008数据库，在数据库中进行信息的添加与删

除。

2.2 功能模块设计2

2.2.1系统逻辑结构设计

学生成绩信息表

2.2.2程序运行代码

MainFrame类：

package dazuoye;

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

public class MainFrame extends JFrame {

JButton insert, query, delete, modify;

JPanel panel, panel1, panel2;

public MainFrame() {

// TODO Auto-generated method stub

ImageIcon img = new ImageIcon("1.gif");

JLabel text1, text2, picture = new JLabel(img);

JFrame frame = new JFrame("学生成绩查询管理系统");

insert = new JButton("添加数据");

insert.setBackground(Color.orange);

insert.addActionListener(new insertActionPerformed());

query = new JButton("查询数据");

query.addActionListener(new queryActionPerformed());

query.setBackground(Color.orange);

modify = new JButton("修改数据");

modify.setBackground(Color.orange);

modify.addActionListener(new modifyActionPerformed());

delete = new JButton("删除数据");

delete.setBackground(Color.orange);

delete.addActionListener(new deleteActionPerformed());

frame.setSize(360, 200);

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

Container contentPane = frame.getContentPane();

contentPane.setLayout(new BorderLayout());

text1 = new JLabel("红河学院学生成绩管理系统", JLabel.CENTER);

text1.setFont(new Font("宋体", Font.BOLD, 26));

text1.setForeground(Color.blue);

text2 = new JLabel(" " + " ");

text2.setFont(new Font("TimesRoman", Font.ROMAN_BASELINE, 14));

panel1 = new JPanel();

panel1.add(insert);

panel1.add(query);

panel2 = new JPanel();

panel2.add(modify);

panel2.add(delete);

panel1.setOpaque(false);

panel2.setOpaque(false);

panel = new JPanel();

panel.add(text2, BorderLayout.NORTH);

panel.add(panel1, BorderLayout.NORTH);

panel.add(panel2, BorderLayout.SOUTH);

panel.setOpaque(false);

contentPane.add(text1, BorderLayout.NORTH);

contentPane.add(panel, BorderLayout.CENTER);

frame.getLayeredPane().add(picture, new Integer(Integer.MIN_VALUE));

Toolkit kit = Toolkit.getDefaultToolkit();

Dimension screenSize = kit.getScreenSize();

int screenWidth = screenSize.width / 2;

int screenHeight = screenSize.height / 2;

int height = this.getHeight();

int width = this.getWidth();

picture.setBounds(0, 0, 360, 360);

((JPanel) contentPane).setOpaque(false);

frame.setLocation(screenWidth - width / 2, screenHeight - height / 2);

frame.setVisible(true);

}

public class insertActionPerformed implements ActionListener { public void actionPerformed(ActionEvent e) {

new Insert().setVisible(true);

}

}

public class modifyActionPerformed implements ActionListener { public void actionPerformed(ActionEvent e) {

new Modify().setVisible(true);

}

}

public class queryActionPerformed implements ActionListener { public void actionPerformed(ActionEvent e) {

new Query().setVisible(true);

}

}

public class deleteActionPerformed implements ActionListener { public void actionPerformed(ActionEvent e) {

new Delete().setVisible(true);

}

}

public static void main(String[] args) {

new MainFrame();

}

}

Insert类：

package dazuoye;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class Insert extends JFrame {

JTextField input1, input2, input3, input4, input5, input6,input7;

JLabel label1, label2, label3, label4, label5;

JButton button;

static Statement st;

static {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:student");

st = con.createStatement();

} catch (Exception e) {

}

}

ResultSet rs;

public Insert() {

input1 = new JTextField(15);

input2 = new JTextField(15);

input3 = new JTextField(15);

input4 = new JTextField(15);

input5 = new JTextField(15);

input6 = new JTextField(15);

input7 = new JTextField(15);

JPanel panel = new JPanel();

panel.setLayout(new GridLayout(7,2));

panel.add(new JLabel("学号"), BorderLayout.CENTER);

panel.add(input1);

panel.add(new JLabel("姓名"), BorderLayout.CENTER);

panel.add(input2);

panel.add(new JLabel("学年"), BorderLayout.CENTER);

panel.add(input3);

panel.add(new JLabel("学期"), BorderLayout.CENTER);

panel.add(input4);

panel.add(new JLabel("语文"), BorderLayout.CENTER);

panel.add(input5);

panel.add(new JLabel("英语"), BorderLayout.CENTER);

panel.add(input6);

panel.add(new JLabel("数学"), BorderLayout.CENTER);

panel.add(input7);

button = new JButton("添加");

button.addActionListener(new mysql());

Container container = getContentPane();

container.add(panel, BorderLayout.CENTER);

container.add(button, BorderLayout.SOUTH);

setTitle("添加数据窗口");

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

setSize(300,300);

Toolkit kit = Toolkit.getDefaultToolkit();

Dimension screenSize = kit.getScreenSize();

int screenWidth = screenSize.width / 2;

int screenHeight = screenSize.height / 2;

int height = this.getHeight();

int width = this.getWidth();

setLocation(screenWidth - width / 2, screenHeight - height / 2);

setVisible(true);

}

class mysql implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String sno = input1.getText().trim();

String name = input2.getText().trim();

String year = input3.getText().trim();

String semester = input4.getText().trim();

String chinese = input5.getText().trim();

String english = input6.getText().trim();

String maths = input7.getText().trim();

if (sno.equals("") | name.equals("") | year.equals("") |

semester.equals("")| chinese.equals("")| english.equals("")| maths.equals("")) {

JOptionPane.showMessageDialog(Insert.this, "请重新输入", "提示对话框", 1);

} else {

String sql = "insert into

ScoreInfo(ID,name,year,semester,Chinese,English,Maths) values('" + sno + "','"

+ name + "','" + year + "'," +semester+ "',"+ chinese + "," + english + "," + maths + ");";

st.executeUpdate(sql);

JOptionPane.showMessageDialog(Insert.this, "数据添加成功", "提示对话框", 1);

input1.setText("");

input2.setText("");

input3.setText("");

input4.setText("");

input5.setText("");

input6.setText("");

input7.setText("");

}

} catch (Exception ee) {

}

}

}

}

QUERY类：

package dazuoye;

import java.awt.*;

import javax.swing.event.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class Query extends JFrame {

JTextArea show;

JButton button1, button2, button3, button4, button5,button6;;

JTextField field1, field2, field3,field4;

JComboBox comoBox;

static Statement st;

static {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:student");

st = con.createStatement();

} catch (Exception e) {

}

}

public Query() {

show = new JTextArea(6, 15);

button1 = new JButton("显示所有信息");

button1.addActionListener(new Mysql1());

Container container = getContentPane();

container.setLayout(new BorderLayout());

JPanel panel = new JPanel();

JPanel mainpanel = new JPanel();

button2 = new JButton("按学号查询");

button2.addActionListener(new Mysql2());

panel.add(button2);

field1 = new JTextField(7);

panel.add(field1);

panel.setVisible(true);

mainpanel.add(panel);

button3 = new JButton("按姓名查询");

button3.addActionListener(new Mysql3());

panel.add(button3);

field2 = new JTextField(6);

panel.add(field2);

panel.setVisible(true);

mainpanel.add(panel);

button4 = new JButton("按学年查询");

button4.addActionListener(new Mysql4());

panel.add(button4);

field3 = new JTextField(6);

panel.add(field3);

panel.setVisible(true);

mainpanel.add(panel);

button5 = new JButton("按学期查询");

button5.addActionListener(new Mysql4());

panel.add(button5);

field4 = new JTextField(6);

panel.add(field4);

panel.setVisible(true);

mainpanel.add(panel);

String items[] = { "请选择", "语文", "英语", "数学" };

comoBox = new JComboBox(items);

button6 = new JButton("按课程名称查询");

button6.addActionListener(new Mysql5());

panel.add(button6);

panel.add(comoBox);

panel.setVisible(true);

mainpanel.add(panel);

panel = new JPanel();

panel.add(button1);

container.add(mainpanel, BorderLayout.NORTH);

container.add(panel, BorderLayout.SOUTH);

container.add(new JScrollPane(show), BorderLayout.CENTER);

setTitle("查询数据");

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

setSize(1000, 400);

Toolkit kit = Toolkit.getDefaultToolkit();

Dimension screenSize = kit.getScreenSize();

int screenWidth = screenSize.width / 2;

int screenHeight = screenSize.height / 2;

int height = this.getHeight();

int width = this.getWidth();

setLocation(screenWidth - width / 2, screenHeight - height / 2);

setVisible(true);

}

class Mysql1 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String sql = "select * from ScoreInfo";

ResultSet rs = st.executeQuery(sql);

show.setText("");

show.append(

"序号学号姓名

学年学期语文英语

数学"

+ "\n");

while (rs.next()) {

show.append(rs.getInt(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getString(4) + " ");

show.append(rs.getInt(5) + " ");

show.append(rs.getInt(6) + " ");

show.append(rs.getInt(7) + " ");

show.append(rs.getInt(8) + "\n");

}

} catch (Exception ee) {

}

}

}

class Mysql2 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String ss = field1.getText().trim();

String sql = "select * from ScoreInfo where ID='" + ss + "'";

ResultSet rs = st.executeQuery(sql);

show.setText("");

show.append(

"序号学号姓名

学年学期语文英语

数学"

+ "\n");

while (rs.next()) {

show.append(rs.getInt(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getString(4) + " ");

show.append(rs.getInt(5) + " ");

show.append(rs.getInt(6) + " ");

show.append(rs.getInt(7) + " ");

show.append(rs.getInt(8) + "\n");

}

} catch (Exception ee) {

}

}

}

class Mysql3 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String ss = field2.getText().trim();

String sql = "select * from ScoreInfo where name='" + ss + "'";

ResultSet rs = st.executeQuery(sql);

show.setText("");

show.append(

"序号学号姓名

学年学期语文英语

数学"

+ "\n");

while (rs.next()) {

show.append(rs.getInt(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getString(4) + " ");

show.append(rs.getInt(5) + " ");

show.append(rs.getInt(6) + " ");

show.append(rs.getInt(7) + " ");

show.append(rs.getInt(8) + "\n");

}

} catch (Exception ee) {

}

}

}

class Mysql4 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String ss = field3.getText().trim();

String sql = "select * from ScoreInfo where class='" + ss + "'";

ResultSet rs = st.executeQuery(sql);

show.setText("");

show.append(

"序号学号姓名

学年学期语文英语

数学"

+ "\n");

while (rs.next()) {

show.append(rs.getInt(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getString(4) + " ");

show.append(rs.getInt(5) + " ");

show.append(rs.getInt(6) + " ");

show.append(rs.getInt(7) + " ");

show.append(rs.getInt(8) + "\n");

}

} catch (Exception ee) {

}

}

}

class Mysql5 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String ss = field3.getText().trim();

String sql = "select * from ScoreInfo where class='" + ss + "'";

ResultSet rs = st.executeQuery(sql);

show.setText("");

show.append(

"序号学号姓名

学年学期语文英语

数学"

+ "\n");

while (rs.next()) {

show.append(rs.getInt(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getString(4) + " ");

show.append(rs.getInt(5) + " ");

show.append(rs.getInt(6) + " ");

show.append(rs.getInt(7) + " ");

show.append(rs.getInt(8) + "\n");

}

} catch (Exception ee) {

}

}

}

class Mysql6 implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String sql = "";

String ss = comoBox.getSelectedItem().toString();

if (ss.equals("语文")) {

sql = "select ID,name,year,semester,Chinese from ScoreInfo ";

show.setText("");

show.append(

"序号学号姓名

学年学期语文"

+ "\n");

} else if (ss.equals("英语")) {

sql = "select ID,name,year,semester,English from ScoreInfo ";

show.setText("");

show.append(

"序号学号姓名

学年学期英语 "

+ "\n");

} else if (ss.equals("数学")) {

sql = "select ID,name,year,semester,Maths from ScoreInfo ";

show.setText("");

show.append(

"序号学号姓名

学年学期数学"

+ "\n");

}

ResultSet rs = st.executeQuery(sql);

int i = 0;

while (rs.next()) {

i++;

show.append("" + i + " " + rs.getString(1) + " ");

show.append(rs.getString(2) + " ");

show.append(rs.getString(3) + " ");

show.append(rs.getInt(4) + "\n");

}

} catch (Exception ee) {

}

}

}

}

Modify类：

package dazuoye;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class Modify extends JFrame {

JTextField input1, input2, input3, input4, input5, input6,input7;

JLabel label1, label2, label3, label4, label5;

JButton button;

static Statement st;

static {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:student");

st = con.createStatement();

} catch (Exception e) {

}

}

ResultSet rs;

public Modify() {

input1 = new JTextField(15);

input2 = new JTextField(15);

input3 = new JTextField(15);

input4 = new JTextField(15);

input5 = new JTextField(15);

input6 = new JTextField(15);

input7 = new JTextField(15);

JPanel panel = new JPanel();

panel.setLayout(new GridLayout(7, 3));

panel.add(new JLabel("学号"));

panel.add(input1);

panel.add(new JLabel("姓名"));

panel.add(input2);

panel.add(new JLabel("学年"));

panel.add(input3);

panel.add(new JLabel("学期"));

panel.add(input4);

panel.add(new JLabel("语文"));

panel.add(input5);

panel.add(new JLabel("英语"));

panel.add(input6);

panel.add(new JLabel("数学"));

panel.add(input7);

button = new JButton("修改");

button.addActionListener(new mysql());

Container container = getContentPane();

container.add(panel, BorderLayout.CENTER);

container.add(button, BorderLayout.SOUTH);

setTitle("修改数据窗口");

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

setSize(400, 300);

Toolkit kit = Toolkit.getDefaultToolkit();

Dimension screenSize = kit.getScreenSize();

int screenWidth = screenSize.width / 2;

int screenHeight = screenSize.height / 2;

int height = this.getHeight();

int width = this.getWidth();

setLocation(screenWidth - width / 2, screenHeight - height / 2);

setVisible(true);

}

class mysql implements ActionListener {

public void actionPerformed(ActionEvent e) {

try {

String sno = input1.getText().trim();

String name = input2.getText().trim();

String year = input3.getText().trim();

String semester = input4.getText().trim();

String chinese = input5.getText().trim();

String english = input6.getText().trim();

String maths = input7.getText().trim();

if (sno.equals("") | name.equals("") | year.equals("") |

semester.equals("")| chinese.equals("")| english.equals("")| maths.equals("")) {

JOptionPane.showMessageDialog(Modify.this, "修改有错误！", "提示对话框", 1);

} else {

try {

String sql = "update ScoreInfo set name='" + name + "',year='" + year + "',semester='" + semester + "',Chinese=" + chinese

+ ",English="+ english+ ",Maths="+ maths+ " where ID='" + sno + "'";

st.executeUpdate(sql);

JOptionPane.showMessageDialog(Modify.this, "数据修改成功", "提示对话框", 1);

input1.setText("");

input2.setText("");

input3.setText("");

input4.setText("");

input5.setText("");

input6.setText("");

input7.setText("");

} catch (Exception ee) {

JOptionPane.showMessageDialog(Modify.this, "请确认需要修改的学号是否存在", "提示对话框", 1);

System.out.println(ee);

}

}

} catch (Exception eee) {

System.out.println(eee);

}

}

}

}

DELETE类：

package dazuoye;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import java.sql.*;

public class Delete extends JFrame {

JButton search;

JTextField input;

JTextArea show;

Connection con;

Statement st;

public Delete() {

JPanel p = new JPanel();

search = new JButton("删除");

input = new JTextField(10);

show = new JTextArea(6, 43);

p.add(new JLabel("输入要删除的学号"));

p.add(input);

p.add(search);

setTitle("删除数据窗口");

search.addActionListener(new Mysql());

show.setEditable(false);

add(p, BorderLayout.NORTH);

add(show, BorderLayout.CENTER);

setSize(400, 150);

Toolkit kit = Toolkit.getDefaultToolkit();

Dimension screenSize = kit.getScreenSize();

int screenWidth = screenSize.width / 2;

int screenHeight = screenSize.height / 2;

int height = this.getHeight();

int width = this.getWidth();

setLocation(screenWidth - width / 2, screenHeight - height / 2);

setVisible(true);

validate();

addWindowListener(new WindowAdapter() {

public void windowClosing(WindowEvent e) {

dispose();

}

});

}

class Mysql implements ActionListener {

public void actionPerformed(ActionEvent ee) {

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

} catch (ClassNotFoundException eee) {

System.out.println("" + eee);

}

try {

String ss = input.getText().trim();

con = DriverManager.getConnection("jdbc:odbc:student");

st = con.createStatement();

String sql = "select * from ScoreInfo where ID='" + ss + "'";

show.setText(sql);

ResultSet rs = st.executeQuery(sql);

while (rs.next()) {

String sno = rs.getString("ID");

String name = rs.getString("name");

String year = rs.getString("year");

String semester = rs.getString("semester");

int chinese = rs.getInt("Chinese");

int english = rs.getInt("English");

int math = rs.getInt("Maths");