我负责的是程序入口,菜单组建,形成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 Class>getColumnClass(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文件;
在组员提交完代码,我将代码进行规约扫描,将出现的警告都尽力改正了,代码的命名符合规范;
使用的是阿里巴巴规约扫描工具:
结果如下:



