showwin.java

改经的学生学籍管理系统

import java.util.*;
import java.awt.event.*;
import java.awt.*;
import javax.swing.*;
import java.io.*;
import java.sql.*;
class student1 extends JPanel
{
 String number,name;
 float computer,shuxue,english;

    student1(String number,String name,float computer,float shuxue,float english)
 {this.number=number;this.name=name;this.computer=computer;this.shuxue=shuxue;this.english=english;
 }	
}
class ShowWin extends JFrame implements ActionListener
{
	private Connection connect;
	private Consql consql;
	private Statement stmt;
	private ResultSet rs;
 Hashtable hashtable=new Hashtable();
 JTextField t1=new JTextField();
 JTextField t2=new JTextField();
 JTextField t3=new JTextField();
 JTextField t4=new JTextField();
 JTextField t5=new JTextField();
 JTextField t6=new JTextField();
 JButton b_add=new JButton("添加成绩");
 JButton b_reset=new JButton("重置");
 JButton b_show=new JButton("确定");
 JButton b_average=new JButton("计算平均分");
 JButton b_fanhui=new JButton("返回");
 JTextField t7=new JTextField();
 ShowWin()
 {
 	Container con=getContentPane();
 	consql=new Consql();
 	JPanel tianjia=new JPanel();
 	       tianjia.setLayout(new GridLayout(8,2));
 	       tianjia.add(new Label("成绩添加区："));
 	       tianjia.add(new Label());
 	       tianjia.add(new Label("学号："));
 	       tianjia.add(t1);
 	       tianjia.add(new Label("姓名："));
 	       tianjia.add(t2);
 	       tianjia.add(new Label("计算机："));
 	       tianjia.add(t3);
 	       tianjia.add(new Label("数学："));
 	       tianjia.add(t4);
 	       tianjia.add(new Label("英语："));
 	       tianjia.add(t5);
 	       tianjia.add(b_add);
 	       tianjia.add(b_reset);
    JPanel chaxun=new JPanel();
           chaxun.setLayout(new GridLayout(5,2));
           chaxun.add(new Label("查询成绩："));
           chaxun.add(new Label());
           chaxun.add(new Label("请输入学号："));
           chaxun.add(t6);
           chaxun.add(b_show);
           chaxun.add(b_average);
           chaxun.add(t7);
           JSplitPane split;
      split=new JSplitPane(JSplitPane.VERTICAL_SPLIT,tianjia,chaxun);
      con.add(split,BorderLayout.CENTER);
      this.addWindowListener(new WindowAdapter()
   {public void windowClosing(WindowEvent e)
   {dispose();
   } });
    JPanel fanhui=new JPanel();
    fanhui.add(new Label("成绩添加和查询区"));
     fanhui.add(b_fanhui);
     
      con.add(fanhui, BorderLayout.NORTH);
      
      b_add.addActionListener(this);b_show.addActionListener(this);
      b_fanhui.addActionListener(this);
     b_reset.addActionListener(this);
      setSize(600,500);
      setVisible(true);
      try
      {
      
      connect=consql.connect();
      stmt=connect.createStatement();
      rs=stmt.executeQuery("select * from results");
      rs.next();
      t1.setText(rs.getString("number"));
      t2.setText(rs.getString("name"));
      t3.setText(rs.getString("computer"));
      t4.setText(rs.getString("shuxue"));
      t5.setText(rs.getString("english"));
      rs.close();
      }
      catch(SQLException e)
  	  {
  		  System.out.println("SQLException4:"+e.getMessage());
  	  } 
		
 }
 
public void actionPerformed(ActionEvent e) 
 { 
  if(e.getSource()==b_fanhui)
  {
  	try
      {
 	  stmt.close();
      consql.closeconnect();
      }
      catch(SQLException ce)
  	  {
  		  System.out.println("SQLException4:"+ce.getMessage());
  	  } 
  	 this.hide();
  }
  else if(e.getSource()==b_show)	
  { 
  
   }
   else if(e.getSource()==b_add)
   {
   		try
   		{
   		String inststr="insert into results values('"+t1.getText()+"','"+
   		t2.getText()+"','"+t3.getText()+"','"+t4.getText()+"','"+
   		t5.getText()+"','0')";
   		stmt.executeUpdate(inststr);
   		}
   		catch(SQLException ce)
  	  	{
  			 System.out.println("SQLException5:"+ce.getMessage());
  	  	}
  	  	JOptionPane.showMessageDialog(this,"添加成功！","信息提示",JOptionPane.INFORMATION_MESSAGE);
   }
   else if(e.getSource()==b_reset)
   {
   	t1.setText("");
   	t2.setText("");
   	t3.setText("");
   	t4.setText("");
   	t5.setText("");
   	
   }
}
}