《java学生成绩管理系统源码》由会员分享，可在线阅读，更多相关《java学生成绩管理系统源码（23页珍藏版）》请在金锄头文库上搜索。
1、文件 addmessage.java 代码： import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.table.*; classaddmessage extends JFrame implementsActionListener JTextField t1,t2,t3,t4,t5; JTable table; JButton but1; JLabel lab1,lab2,lab3,lab4,lab5;
2、JPanel p1; addmessage() super(“增加“); setBounds(350,100,470,400); setLayout(new GridLayout(1,1,10,10); p1=new JPanel(); lab1=new JLabel(“学号“);t1=new JTextField(10); lab2=new JLabel(“姓名“);t2=new JTextField(10); lab3=new JLabel(“课程名“);t3=new JTextField(10); lab4=new JLabel(“状态“); t4=new JTextField(10);
3、 lab5=new JLabel(“成绩“); t5=new JTextField(10); but1=new JButton(“添加“); but1.addActionListener(this); p1.add(lab1); p1.add(t1); p1.add(lab2); p1.add(t2); p1.add(lab3); p1.add(t3); p1.add(lab4); p1.add(t4); p1.add(lab5); p1.add(t5); p1.add(but1); add(p1); setVisible(true); public void actionPerformed(
4、ActionEvent e) int i=0 ; String sql1=null,sql2=null,update=null; String url=“jdbc:mysql:/localhost:3306/学生成绩系统“; Connection con; Statement stmt; try Class.forName(“org.gjt.mm.mysql.Driver“); catch(java.lang.ClassNotFoundException e1) System.err.println(“ClassNotFoundException:“+e1.getMessage(); if(e
5、.getSource()=but1)/添加- try con=DriverManager.getConnection(url,“root“,“123“); stmt=con.createStatement(); sql1=“INSERTINTO学生成绩表VALUES (“+t1.getText()+“,“+t2.getText()+“,“+ t3.getText()+“,“+t4.getText()+“,“+t5.getText()+“)“; String num1=t1.getText(); String num2=t1.getText(); String sele=“select * fr
6、om 学生成绩表where 学号=“+num1+“ and 课程名 =“+num2+“; ResultSet rs=stmt.executeQuery(sele); if(rs.next() JOptionPane.showMessageDialog(this, “已有该条记录，请核实！“); else stmt.executeUpdate(sql1); JOptionPane.showMessageDialog(this, “添加成功!“); t1.setText(“); t2.setText(“); t3.setText(“); t4.setText(“); t5.setText(“);
7、stmt.close(); con.close(); catch(SQLException ex) System.err.println(“SQLException:“+ex.getMessage(); 文件 deletemessage.java 代码 import java.awt.*; import java.awt.event.*; import java.sql.*; import java.util.*; import javax.swing.*; import javax.swing.table.*; classdeletemessage extends JFrame implem
8、entsActionListener JTextField t1,t2,t3; JTable table; JButton but1; JLabel lab1,lab2,lab3; JPanel p1; deletemessage() super(“删除“); setBounds(350,100,470,400); setLayout(new GridLayout(1,1,10,10); p1=new JPanel(); lab1=new JLabel(“学号“);t1=new JTextField(10); lab2=new JLabel(“姓名“);t2=new JTextField(10
9、); lab3=new JLabel(“课程名“);t3=new JTextField(10); but1=new JButton(“删除“); but1.addActionListener(this); p1.add(lab1); p1.add(t1); p1.add(lab2); p1.add(t2); p1.add(lab3); p1.add(t3); p1.add(but1); add(p1); setVisible(true); public void actionPerformed(ActionEvent e) String sql1=null,sql2=null; String
10、url=“jdbc:mysql:/localhost:3306/学生成绩系统“; Connection con; Statement stmt; try Class.forName(“org.gjt.mm.mysql.Driver“); catch(java.lang.ClassNotFoundException e1) System.err.println(“ClassNotFoundException:“+e1.getMessage(); if(e.getSource()=but1)/删除- try String num1=t1.getText(); String num2=t2.getT
11、ext(); String num3=t3.getText(); sql2=“delete from 学 生 成 绩 表where 学 号 =“+num1+“and 课 程 名 =“+num3+“; con=DriverManager.getConnection(url,“root“,“123“); stmt=con.createStatement(); sql1=“select * from 学生成绩表where 学号=“+num1+“ and 姓名=“+num2+“ and 课程名=“+num3+“; ResultSet rs=stmt.executeQuery(sql1); if(rs.
12、next() stmt.executeUpdate(sql2); JOptionPane.showMessageDialog(this, “删除成功!“); else JOptionPane.showMessageDialog(this, “没有此条记录!请重新输入“); t1.setText(“); stmt.close(); con.close(); catch(SQLException ex) System.err.println(“SQLException:“+ex.getMessage(); 文件 entry.java 代码 import java.awt.*; import jav
13、a.awt.event.*; import java.sql.*; import javax.swing.*; class entry extends JFrame implementsActionListener int flag=1; String user,pass; JPanel pa; JLabel lab1,lab2; JTextField tf1; JPasswordField tf2; JButton btu1,btu2; JPanel pa1,pa2,pa4; entry() super(“学生成绩管理系统“); setBounds(400,200,400,300); Gri
14、dBagLayout gbL=new GridBagLayout(); GridBagConstraints gbc=new GridBagConstraints(); setLayout(gbL); gbc.fill=GridBagConstraints.HORIZONTAL; gbc.anchor=GridBagConstraints.CENTER; lab1=new JLabel(“请输入帐号“); lab2=new JLabel(“请输入密码“); tf2=new JPasswordField(10); tf2.setEchoChar(*); tf1=new JTextField(10
15、); tf1.addActionListener(this); pa1=new JPanel(); pa1.add(lab1); pa1.add(tf1); gbc.gridx=1;gbc.gridy=1; gbc.insets=new Insets(2,5,0,5); gbL.setConstraints(pa1,gbc); add(pa1); tf2.addActionListener(this); pa2=new JPanel(); pa2.add(lab2); pa2.add(tf2); gbc.gridx=1;gbc.gridy=2; gbc.insets=new Insets(2,
16、5,2,5); gbL.setConstraints(pa2,gbc); add(pa2); btu1=new JButton(“确定“); btu1.addActionListener(this); btu2=new JButton(“退出“); btu2.addActionListener(this); pa4=new JPanel(); pa4.add(btu1); pa4.add(btu2); gbc.gridx=1;gbc.gridy=4; gbc.insets=new Insets(2,5,2,5); gbL.setConstraints(pa4,gbc); add(pa4); public void actionPerformed(ActionEvent e) logi
