栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

课程设计-学生成绩管理系统

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

课程设计-学生成绩管理系统

我负责的是程序入口,菜单组建,形成GUI界面,数据库连接,代码规约扫描;

代码如下:

//Main.java程序入口

 

public class Main {
    public static void main(String[] args) {
        new Dengru();
    }
}

//Menu.java 菜单组建及形成GUI界面和数据库连接

import javax.swing.*;
import javax.swing.table.AbstractTableModel;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.io.File;
import java.io.FileWriter;
import java.io.Writer;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;





public class Menu extends AbstractTableModel implements ActionListener{
    public static String []title={"学号","姓名","数学","物理","英语","平均分","总分"};
    public  static Object [][]inf={{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""},
            {"","","","","","",""},{"","","","","","",""}};
    public static final String DATA_DRIVER ="com.mysql.cj.jdbc.Driver";
    public static final String DATA_URL ="jdbc:mysql://localhost:3306/student?characterEncoding=utf-8&serverTimezone=UTC&useSSL=false&&allowPublicKeyRetrieval=true";
    public static final String USERNAME ="root";
    public static final String PASSWORD ="123";
    public static final String SQL="select id,name,math,wuli,english,everage,sum from stu";

    JFrame f=new JFrame("学生成绩管理系统");
    JButton display=new JButton("显示");
    JButton search=new JButton("查找");
    JButton modify=new JButton("修改");
    JButton adda=new JButton("添加");
    JButton delete=new JButton("删除");
    JButton sort=new JButton("排序");
    JButton save=new JButton("保存文件");
    JButton quit=new JButton("退出");
    JTable tab;
    DefaultTableModel tabmo;
    Connection con;
    Statement sta;
    ResultSet rs=null;

    

    public Menu() throws Exception{
        Class.forName(DATA_DRIVER);
        con=DriverManager.getConnection(DATA_URL, USERNAME, PASSWORD);
        sta=con.createStatement();
        tabmo=new DefaultTableModel(inf,title);
        tab=new JTable(tabmo);
        JScrollPane js=new JScrollPane(tab);
        JPanel jp=new JPanel();
        jp.add(display);
        jp.add(search);
        jp.add(modify);
        jp.add(adda);
        jp.add(delete);
        jp.add(sort);
        jp.add(save);
        jp.add(quit);
        f.add(jp,BorderLayout.NORTH);
        f.add(js,BorderLayout.CENTER);
        f.setSize(700,500);
        f.setLocation(250,70);
        f.setVisible(true);
        display.addActionListener(this);
        search.addActionListener(this);
        modify.addActionListener(this);
        adda.addActionListener(this);
        delete.addActionListener(this);
        sort.addActionListener(this);
        save.addActionListener(this);
        quit.addActionListener(this);
    }

    
    public int getColumnCount(){
        return title.length;
    }

    
    public int getRowCount(){
        return inf.length;
    }

    
    public Object getValueAt(int row,int col){
        return inf[row][col];
    }

    
    public String getColumnName(int col){
        return title[col];
    }

    
    public ClassgetColumnClass(int col){
        return this.getValueAt(0,col).getClass();
    }

    
    public boolean isCellEditable(int row,int col){
        return false;
    }

    
    public void setValueAt(Object newv,int row,int col){
        this.inf[row][col]=newv;
    }

    
    public void actionPerformed(ActionEvent e){
        if(e.getSource()==display){
            try{
                this.show(SQL,0,"");
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==search){
            try{
                f.dispose();
                new Search();
                if("".equals(tabmo.getValueAt(0,0))){
                    JOptionPane.showMessageDialog(null,"数据库中不存在你查找学生的信息,请重新输入!","提示!",JOptionPane.INFORMATION_MESSAGE);
                    f.dispose();
                    new Search();
                }
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==modify){
            try{
                f.dispose();
                new Modify();
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==adda){
            try{
                f.dispose();
                new Adda();
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==delete){
            try{
                f.dispose();
                new Delete();
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==sort){
            try{
                JOptionPane.showMessageDialog(null,"排序是将读取到数据库的内容进行排序,不修改数据库的内容!","提示!",JOptionPane.INFORMATION_MESSAGE);
                this.sort();
            }catch(Exception ex){
                System.out.println("异常");
            }
        }
        if(e.getSource()==save){
            try{
                this.save();
                JOptionPane.showMessageDialog(null,"保存文件成功,可以在D盘根目录查看文件!","提示!",JOptionPane.INFORMATION_MESSAGE);
            }catch(Exception ex){System.out.println("异常");}
        }
        if(e.getSource()==quit){
            try{
                sta.close();
                con.close();
                System.exit(1);
            }catch(Exception ex){System.out.println("异常");}
        }
    }

    
    public void show(String s,int p,String t)throws Exception{
        if (p != 0) {
            sta.executeUpdate(t);
        }
        
        rs=sta.executeQuery(s);
        int id0;
        String name0;
        float math0;
        float wuli0;
        float english0;
        float everage0;
        float sum0;
        int i=0;
        
        while(rs.next()){
            id0=rs.getInt("id");
            name0=rs.getString("name");
            math0=rs.getFloat("math");
            wuli0=rs.getFloat("wuli");
            english0=rs.getFloat("english");
            everage0=toTwo(rs.getFloat("everage"));
            sum0=rs.getFloat("sum");
            tabmo.setValueAt(id0,i,0);
            tabmo.setValueAt(name0,i,1);
            tabmo.setValueAt(math0,i,2);
            tabmo.setValueAt(wuli0,i,3);
            tabmo.setValueAt(english0,i,4);
            tabmo.setValueAt(everage0,i,5);
            tabmo.setValueAt(sum0,i,6);
            i+=1;
            if (i>=tabmo.getRowCount()) {
                tabmo.addRow(new Object[]{});
            }
        }
    }

    
    public void sort()throws Exception{
        int []id=new int[1000];
        String []name=new String[1000];
        float []math=new float[1000];
        float []wuli=new float[1000];
        float []english=new float[1000];
        float []everage=new float[1000];
        float []sum=new float[1000];
        int idtemp;
        String nametemp;
        float mathtemp;
        float wulitemp;
        float englishtemp;
        float everagetemp;
        float sumtemp;
        int num=0;
        rs=sta.executeQuery(SQL);
        
        while(rs.next()){
            id[num]=rs.getInt("id");
            name[num]=rs.getString("name");
            math[num]=rs.getFloat("math");
            wuli[num]=rs.getFloat("wuli");
            english[num]=rs.getFloat("english");
            everage[num]=toTwo(rs.getFloat("everage"));
            sum[num]=rs.getFloat("sum");
            num+=1;
        }
        
        for(int j=1;j=tabmo.getRowCount()) {
                tabmo.addRow(new Object[]{});
            }
        }
    }

    
    public void save()throws Exception{
        String []id1=new String[1000];
        String []name1=new String[1000];
        String []math1=new String[1000];
        String []wuli1=new String[1000];
        String []english1=new String[1000];
        String []everage1=new String[1000];
        String []sum1=new String[1000];
        int i=0;
        Writer out= new FileWriter("d:"+File.separator+"Student.txt");
        
        rs=sta.executeQuery(SQL);
        while(rs.next()){
            id1[i]=rs.getString("id");
            name1[i]=rs.getString("name");
            math1[i]=rs.getString("math");
            wuli1[i]=rs.getString("wuli");
            english1[i]=rs.getString("english");
            everage1[i]=String.valueOf(toTwo(rs.getFloat("everage")));
            sum1[i]=rs.getString("sum");
            i+=1;
        }
        for(int j=0;j 

Menu类通过继承AbstractTableModel类创建表格及其单元,重写构造方法Menu实现对数据库的连接,并添加相关组件;通过实现ActionListener接口实现对各个事件源的监听,进而产生不同的行为,写入sort方法对学生成绩进行排序,写入save方法保存学生成绩。

想要使用MySQL,还要导入MySQL-connector-jar包,在这里我们将它导入项目下的外部库中;避免出现classnotfoundException

;

 

这是数据库和idea连接界面,我们可以看到在student数据库中的stu表,

 通过nacivat我们给student数据库的stu表加入了如下学生信息:

也就是结果集;

 idea通过mysql-connector获取传入的结果集,在这里我们通过Menu菜单的保存文件按钮将传入的结果集保存下来:

如果更改学生信息之后继续保存文件,新保存的文件会刷新之前保存的文件,D盘不会有重复的student.txt文件。

PS:我们也可以通过navicat将所有信息保存为excel文件;

 在组员提交完代码,我将代码进行规约扫描,将出现的警告都尽力改正了,代码的命名符合规范;

使用的是阿里巴巴规约扫描工具:

结果如下:

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/972308.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号