userframe.java

学生成绩管理系统

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

public class UserFrame extends JFrame{

   
      public UserFrame(Connection connect){
               
    	  setTitle("Database Users Manage Frame");
    	  Container c=getContentPane();
  		  c.setLayout(new GridLayout(7,2));
   		
   		jl_dno=new JLabel("user name");
   		jl_dname=new JLabel("user password");
   		jtf_dno=new JTextField("",10);
   		jtf_dname=new JTextField("",10);
   		
   		
   		
   		jb_find=new JButton("find");
   		jb_delete=new JButton("delete");
   		jb_update=new JButton("alter");
   		jb_ok=new JButton("alter_ok");
   		
   		c.add(jl_dno);c.add(jtf_dno);
   		c.add(jl_dname);c.add(jtf_dname);
   		
   		
   		c.add(jb_find);
   		c.add(jb_delete);
   		c.add(jb_update);
   		c.add(jb_ok);
   		
   		
   		con=connect;
   		
   		////////添加响应
   		
   		jb_find.addActionListener(new FindListener());
   		jb_delete.addActionListener(new DeleteListener());
   		jb_update.addActionListener(new UpdateListener() );
   		jb_ok.addActionListener(new OKListener());
   		
   		
   		
   
   }
      ////////////响应事件
      class FindListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			try{
			
			String s=jtf_dno.getText();
			String sql="select * from users where guest =?";
			PreparedStatement pre=con.prepareStatement(sql);
			pre.setString(1, s);
			rs=pre.executeQuery();
			if(!rs.next()){
				JOptionPane.showMessageDialog(null, "Can not find");
				return;
				}
			jtf_dname.setText(rs.getString(2));
			pre.close();
		   }catch(SQLException e1){
			   JOptionPane.showMessageDialog(null, e1.getMessage());
		   }
		}
    	  
      }
      class DeleteListener implements ActionListener{

  		public void actionPerformed(ActionEvent e) {
  			try{
  				
  				
  				String s=jtf_dno.getText();
  				String sql="delete from users where guest=?";
  				PreparedStatement pre=con.prepareStatement(sql);
  				pre.setString(1, s);
  				if(pre.executeUpdate()!=0)
  				JOptionPane.showMessageDialog(null, "delete successfully!");
  				else
  					JOptionPane.showMessageDialog(null, "delete error!");
  				jtf_dno.setText("");
  				jtf_dname.setText("");
  				
  			}catch(SQLException e1){
 			   JOptionPane.showMessageDialog(null, e1.getMessage());
 		   }
  			
  		}
      	  
        }
      class UpdateListener implements ActionListener{

    		public void actionPerformed(ActionEvent e) {
    			
    			s1=jtf_dno.getText();
    			if(s1.equals("")){
    				JOptionPane.showMessageDialog(null, "Can not Update!");
    				return;
    			}
    				
    			try{
      				String s=jtf_dno.getText();
      				
      				String sql="delete from dept where guest=?";
      				PreparedStatement pre=con.prepareStatement(sql);
      				pre.setString(1, s);
      				pre.executeUpdate();
      				
      				
      			}catch(SQLException e1){
     			   JOptionPane.showMessageDialog(null, e1.getMessage());
     		   }
    			
    		}
        	  
          }
      class OKListener implements ActionListener{

      		public void actionPerformed(ActionEvent e) {
      			
      			
      			try{
      				if(jtf_dno.getText().equals("")){
        				JOptionPane.showMessageDialog(null, "Can not Update!");
        				return;
        			}
      				
      				
      				
      				
      				
      				String sql="insert into dept values(?,?)";
      				PreparedStatement pre=con.prepareStatement(sql);
      				pre.setString(1, jtf_dno.getText());
      				pre.setString(2, jtf_dname.getText());
      				pre.executeUpdate();
      				JOptionPane.showMessageDialog(null, "update successfully!");
      				
      				
      			}catch(SQLException e1){
     			   JOptionPane.showMessageDialog(null, e1.getMessage());
     		   }
      			
      			
      		}
          	  
            }
    JTextField jtf_dno,jtf_dname;
  	JLabel jl_dno,jl_dname;
  	JButton jb_find,jb_delete,jb_update,jb_ok;
  	
  	
  	Connection con;
  	
  	ResultSet rs;
  	String s1;
   
   
	
}