stueditframe.java

辽宁交通专科学校０３级大三的一个课程设计学生成绩管理信息系统．赵磊

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
class StuEditFrame extends JFrame implements ActionListener
{ 
  JFrame f=new JFrame("学生基本信息维护 ");
  JLabel lbsid=new JLabel("请输入查询的学号"),
         lbname=new JLabel("姓名  "),
         lbsex=new JLabel("性别 "),
         lbbirth=new JLabel("生日 "),
         lbmajor=new JLabel("专业  "),
         lbphone=new JLabel("电话 "),
         lbjiguan=new JLabel("籍贯 ");
  JTextField tfsid=new JTextField(10),       
             tfname=new JTextField(10),
             tfsex=new JTextField(10),
             tfbirth=new JTextField(10),
             tfmajor=new JTextField(10),
             tfphone=new JTextField(10),
             tfjiguan=new JTextField(10);
   JPanel p1=new JPanel(),
          p2=new JPanel(),
          p3=new JPanel(),
          p4=new JPanel(),
          p5=new JPanel(),
          p6=new JPanel(),
          p7=new JPanel(),
          p8=new JPanel();
  JButton btnserch=new JButton("查询 "),
          btnedit=new JButton("修改 "),
          btnclear=new JButton("清空 "),
          btnadd=new JButton("添加 "),
          btndelete=new JButton("删除 "),
          btnexit=new JButton("退出 ");
  public StuEditFrame()
  { Container cp=f.getContentPane();
    cp.setLayout(new GridLayout(8,1));
    p1.add(lbsid);p1.add(tfsid);p1.add(btnserch);
    p2.add(lbname);p2.add(tfname);
    p3.add(lbsex);p3.add(tfsex);
    p4.add(lbbirth);p4.add(tfbirth);
    p5.add(lbmajor);p5.add(tfmajor);
    p6.add(lbphone);p6.add(tfphone);
    p7.add(lbjiguan);p7.add(tfjiguan);
    p8.add(btnedit);p8.add(btnclear);p8.add(btnadd);p8.add(btndelete);p8.add(btnexit);
    cp.add(p1);cp.add(p2);cp.add(p3);cp.add(p4);cp.add(p5);cp.add(p6);cp.add(p7);cp.add(p8);
    btnserch.addActionListener(this);
    btnedit.addActionListener(this);
    btnclear.addActionListener(this);
    btnadd.addActionListener(this);
    btndelete.addActionListener(this);
    btnexit.addActionListener(this);
   
    f.setSize(400,400);
    f.setVisible(true);
    }
    public void actionPerformed(ActionEvent e)
    {          
    	
    	if (e.getSource()==btnserch) 
         {  try
 	    {  
 	    	Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent");
                Statement s=con.createStatement();  
               String id=tfsid.getText();
               String strSQL = "select name,sex,birth,major,phone,jiguan from stuinfor where id= '"+id+"' ";
               ResultSet  rs = s.executeQuery(strSQL);
               if(rs.next())
                   {
             	    tfname.setText(rs.getString("name"));
             	    tfsex.setText(rs.getString("sex"));
             	    tfbirth.setText(rs.getString("birth"));
             	    tfmajor.setText(rs.getString("major"));
             	    tfphone.setText(rs.getString("phone"));
             	    tfjiguan.setText(rs.getString("jiguan"));
                    }
             	  else
             	   {  
             	    JOptionPane.showMessageDialog(null,"对不起，没有您要查找的学生资料！,或者您的输入不符合查询的条件，请重新输入");
             	    tfname.setText(null);
             	    tfsex.setText(null);
             	    tfbirth.setText(null);
             	    tfmajor.setText(null);
             	    tfphone.setText(null);
             	    tfjiguan.setText(null);
             	    tfsid.setText(null);
                    }
            }
              catch(Exception ee)
              { System.out.println("SQLException 错误信息 "+ee.getMessage() );  }        
                    
             }
             
            if (e.getSource()==btnedit) 
            {  try{  
                        
                        if((tfsid.getText().equals(""))||(tfname.getText().equals("")) ||(tfsex.getText().equals("")) ||(tfbirth.getText().equals("")) ||(tfmajor.getText()==null)||(tfphone.getText().equals(""))|| (tfjiguan.getText().equals("")))
            	         
            	          {JOptionPane.showMessageDialog(null,"抱歉！您还有相关的信息没有输入。请输入相应的信息再点击修改按钮！"); }
            	       else
            	         {String strSQL="update  stuinfor set name='"+tfname.getText()+"',sex='"+tfsex.getText()+"',birth='"+tfbirth.getText()+"',major='"+tfmajor.getText()+"',phone='"+tfphone.getText()+"',jiguan='"+tfjiguan.getText()+"'where id=?";
            	     
            	         Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent"); 
                         PreparedStatement ps=con.prepareStatement(strSQL);
                         ps.setString(1,tfsid.getText().trim());
                         ps.executeUpdate(); 
            	    	 
            	    	 JOptionPane.showMessageDialog(null,"恭喜你，修改成功！ ");
            	    	 tfname.setText(null); 
                    	 tfsex.setText(null); 
                   	 tfbirth.setText(null);
                   	 tfmajor.setText(null);
                    	 tfphone.setText(null); 
                 	 tfjiguan.setText(null);
                 	 tfsid.setText(null);	
            	         } 
                    }         
                   catch(Exception ee)
                   {System.out.println("修改信息出错:"+ee.getMessage()); } 
                  
            	} 
            if (e.getSource()==btnclear) 
            {
                     tfname.setText(null); 
                     tfsex.setText(null); 
                    tfbirth.setText(null);
                    tfmajor.setText(null);
                    tfphone.setText(null); 
                    tfjiguan.setText(null);
                    tfsid.setText(null);
                  } 
           if (e.getSource()==btnadd) 
            { 
            	     try{  
                        
                        if((tfsid.getText().equals(""))||(tfname.getText().equals("")) ||(tfsex.getText().equals("")) ||(tfbirth.getText().equals("")) ||(tfmajor.getText()==null)||(tfphone.getText().equals(""))|| (tfjiguan.getText().equals("")))
            	         
            	          {JOptionPane.showMessageDialog(null,"抱歉！您还有相关的信息没有输入。请输入相应的信息再点击添加按钮！"); }
            	       else
            	         {String strSQL="insert into  stuinfor(id,name,sex,birth,major,phone,jiguan) values('"+tfsid.getText()+"','"+tfname.getText()+"','"+tfsex.getText()+"','"+tfbirth.getText()+"','"+tfmajor.getText()+"','"+tfphone.getText()+"','"+tfjiguan.getText()+"')";
            	     
            	         Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent"); 
                         Statement s=con.createStatement(); 
            	    	 s.executeUpdate(strSQL);
            	    	 JOptionPane.showMessageDialog(null,"恭喜你，添加成功！ ");
            	    	 tfname.setText(null); 
                    	 tfsex.setText(null); 
                   	 tfbirth.setText(null);
                   	 tfmajor.setText(null);
                    	 tfphone.setText(null); 
                 	 tfjiguan.setText(null);
                 	 tfsid.setText(null);	
            	         } 
                    }         
                   catch(Exception ee)
                   {System.out.println("添加信息出错:"+ee.getMessage()); } 
                  

            }
       if (e.getSource()==btndelete)
        {   
           if(tfsid.getText().trim().equals("")||tfname.getText().trim().equals(""))
       	       { JOptionPane.showMessageDialog(this,"抱歉，学号和姓名不可以为空，无法删除");}
           else{
        	
                 try{ 
       	            Connection con=DriverManager.getConnection("jdbc:odbc:Xsstudent");
                    Statement s=con.createStatement();  
       	            String id = tfsid.getText();
                    String strSQL = "delete * from stuinfor where id= '"+id+"' ";
         	    s.executeUpdate(strSQL);
                  }
                catch(Exception exx)
                {JOptionPane.showMessageDialog(null,"抱歉，出错了");}
                
           	
            	    JOptionPane.showMessageDialog(null,"删除成功！");
             	    tfname.setText(null);
             	    tfsex.setText(null);
             	    tfbirth.setText(null);
             	    tfmajor.setText(null);
             	    tfphone.setText(null);
             	    tfjiguan.setText(null);
             	    tfsid.setText(null);
       	     }
       	}
      if (e.getSource()==btnexit) { f.setVisible(false);}
    	
     
     }
    
    public static void main(String args[])
    {         
    	String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
	      String conURL="jdbc:odbc:Xsstudent";
	      try{
	      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	      }
	      catch(Exception e)
	      {System.out.println("加载驱动失败");}
    	
    	new StuEditFrame();
    	
    	}
 
 }