成绩管理系统课程设计完整版本

public static void main(String[] args) { new MainForm(); } }

import javax.swing.*; import java.awt.*; import java.awt.event.*;

import java.sql.*;

public class ModifyForm extends JFrame implements ActionListener {

JLabel labName=new JLabel(\姓名：\ JLabel labDate=new JLabel(\出生日期：\ JLabel labScore=new JLabel(\成绩：\ JTextField txtName=new JTextField(20); JTextField txtDate=new JTextField(18); JTextField txtScore=new JTextField(20); JButton btnModify=new JButton(\修改\ JButton btnCancel=new JButton(\取消\ JButton btnQuery=new JButton(\查询\ JPanel pan=new JPanel(); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); JPanel pan3=new JPanel(); JPanel pan4=new JPanel(); Connection con; Statement sql; ResultSet rs;

ModifyForm() {

super(\修改数据\ setSize(400,300); pan1.add(labName); pan1.add(txtName); pan2.add(labDate); pan2.add(txtDate); pan3.add(labScore); pan3.add(txtScore);

29

pan4.add(btnQuery); pan4.add(btnModify);

pan4.add(btnCancel);

pan.setLayout(new GridLayout(3,1)); pan.add(pan1); pan.add(pan2); pan.add(pan3);

getContentPane().add(pan,\ getContentPane().add(pan4,\ btnQuery.addActionListener(this); btnModify.addActionListener(this);

btnCancel.addActionListener(this); btnModify.setEnabled(false); txtDate.setEditable(false); txtScore.setEditable(false);

setVisible(true); txtName.requestFocus();

}

public void actionPerformed(ActionEvent ae){ if(ae.getSource()==btnCancel){ dispose();

} else if(ae.getSource()==btnQuery){

try{

Class.forName(\ catch(ClassNotFoundException e){ }

try{con=DriverManager.getConnection(\:odbc:sun\ sql=con.createStatement();

rs=sql.executeQuery(\* from 成绩表 where 姓名='\ if(rs.next()){

txtName.setText(rs.getString(\姓名\ txtScore.setText(new Integer(rs.getInt(\

成绩

\

txtDate.setText(rs.getDate(\出生日期\ btnModify.setEnabled(true);

30

txtDate.setEditable(true); txtScore.setEditable(true);

}else{ System.out.println(\不存在该记录! \ btnModify.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\

txtDate.setEditable(false); txtScore.setEditable(false); }

}catch(SQLException e){ }

}else if(ae.getSource()==btnModify){ try{

System.out.println(\ 成绩表='\成绩=\

='\

sql.executeUpdate(\ 成绩表='\成绩=\='\

System.out.println(\记录修改完毕！\ btnModify.setEnabled(false); txtName.setText(\ txtScore.setText(\ txtDate.setText(\

txtDate.setEditable(false); txtScore.setEditable(false); con.close(); }catch(SQLException e){ } }

}

public static void main(String[] args) { new ModifyForm(); } }

set 出生日期where

姓名

set 出生日期where 姓名

31

import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.sql.*;

public class NameQueryForm extends JFrame implements ActionListener {

JLabel labName=new JLabel(\姓名：\ JLabel labDate=new JLabel(\出生日期：\ JLabel labScore=new JLabel(\成绩：\ JTextField txtName=new JTextField(20); JTextField txtDate=new JTextField(18); JTextField txtScore=new JTextField(20); JButton btnCancel=new JButton(\取消\ JButton btnQuery=new JButton(\查询\ JPanel pan=new JPanel(); JPanel pan1=new JPanel(); JPanel pan2=new JPanel(); JPanel pan3=new JPanel(); JPanel pan4=new JPanel(); Connection con; Statement sql; ResultSet rs;

NameQueryForm() {

super(\按姓名查询\ setSize(400,300); pan1.add(labName); pan1.add(txtName); pan2.add(labDate); pan2.add(txtDate); pan3.add(labScore); pan3.add(txtScore); pan4.add(btnQuery); pan4.add(btnCancel);

pan.setLayout(new GridLayout(3,1)); pan.add(pan1); pan.add(pan2);

32