学生信息管理系统方案.doc

同学信息管理系统方案
实验部分程序如下：
主程序：
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
class MyPanel extends JPanel{
Image img=Toolkit.getDefaultToolkit().getImage(D:/shiyan3/a.jpg);
public void paint(Graphics g){
g.drawImage(img,0,0,this);
}
}
public class MainForm extends JFrame implements ActionListener
{
JMenu mSystem=new JMenu(系统);
JMenuItem mExit=new JMenuItem(退出);
JMenu mOperate=new JMenu(数据操作);
JMenuItem mAdd=new JMenuItem(添加);
JMenuItem mDel=new JMenuItem(删除);
JMenuItem mModify=new JMenuItem(修改);
JMenu mQuery=new JMenu(查询);
JMenuItem mName=new JMenuItem(按查询);
JMenuItem mScore=new JMenuItem(按出生日期查询);
JMenu mHelp=new JMenu(帮助);
JMenuItem mAbout=new JMenuItem(软件信息);
JMenuBar mBar=new JMenuBar();
MainForm()
{
super(同学信息管理系统);
setSize(875,583);
mSystem.add(mExit);
mOperate.add(mAdd);
mOperate.add(mDel);
mOperate.add(mModify);
mQuery.add(mName);
mQuery.add(mScore);
mHelp.add(mAbout);
mBar.add(mSystem);
mBar.add(mOperate);
mBar.add(mQuery);
mBar.add(mHelp);
setJMenuBar(mBar);
mExit.addActionListener(this);
mAdd.addActionListener(this);
mDel.addActionListener(this);
mModify.addActionListener(this);
mName.addActionListener(this);
mScore.addActionListener(this);
mAbout.addActionListener(this);
setContentPane(new MyPanel());
setVisible(true);
}
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==mExit)
System.exit(0);
else if(ae.getSource()==mAbout)
JOptionPane.showMessageDialog(this,同学信息管理系统\n\n电院\n\n2021年12月,电子信息,JOptionPane.INFORMA TION_MESSAGE);
else if(ae.getSource()==mAdd)
new AddForm().setVisible(true);
else if(ae.getSource()==mDel)
new DeleteForm().setVisible(true);
else if(ae.getSource()==mModify)
new ModifyForm().setVisible(true);
else if(ae.getSource()==mName)
new NameQueryForm().setVisible(true);
else if(ae.getSource()==mScore)
new ScoreQueryForm().setVisible(true);
}
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);
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,Center);
getContentPane().add(pan4,South);
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(sun.jdbc.odbc.JdbcOdbcDriver);
System.out.println(连接数据库成功);}
catch(ClassNotFoundException e){
System.out.println(SQLException:+e.getMessage());
System.out.println(连接数据库不成功);
}
try{con=DriverManager.getConnection(jdbc:odbc:St);
sql=con.createStatement();
rs=sql.executeQuery(select * from 信息表where ='+txtName.getText()+');
if(rs.next()){
txtName.setText(rs.getString());
txtScore.setText(rs.getString(性别).toString());
txtDate.setText(rs.getDate(出生日期).toString());
btnModify.setEnabled(true);
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(Update 信息表set 出生日期='+txtDate.getText()+',性别=+txtScore.getText()+ where ='+txtName.getText()+');
sql.executeUpdate(Update 信息表set 出生日期='+txtDate.getText()+',性别=+txtScore.getText()+ where ='+txtName.getText()+');
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();
}}
添加部分程序：
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
public class AddForm 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 btnAdd=new JButton(添加);
JButton btnCancel=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;
AddForm()
{
super(添加数据);
setSize(400,300);
pan1.add(labName);
pan1.add(txtName);
pan2.add(labDate);
pan2.add(txtDate);
pan3.add(labScore);
pan3.add(txtScore);
pan4.add(btnAdd);
pan4.add(btnCancel);
pan.setLayout(new GridLayout(3,1));
pan.add(pan1);
pan.add(pan2);
pan.add(pan3);
getContentPane().add(pan,Center);