jiajian.java

利用java编写的奖学金评定系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.*;
import java.sql.ResultSet;
import java.io.*; 

//添加加减分窗体
//////////////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////////
class jiajian extends JFrame implements ActionListener{

	JLabel lb1 = new JLabel("奖 惩 信 息");
	JLabel lb2 = new JLabel("学    号：");
	JLabel lb3 = new JLabel("姓    名：");
	JLabel lb4 = new JLabel("加    分：");
	JLabel lb5 = new JLabel("减    分：");
	
	Connection con;
    Statement stmt;
    ResultSet rs;
	
	JTextField id = new JTextField();
	JTextField name = new JTextField();
	JTextField jia = new JTextField();
	JTextField jian = new JTextField();
	JButton btright = new JButton("<<");
    JButton btleft = new JButton(">>");
    JButton btamend = new JButton("修改");
    JButton btsave = new JButton("添加");
	public jiajian(){

		setTitle("奖惩分");
    
        id.setEditable(false);
        name.setEditable(false);
        
		getContentPane().setLayout(null);
		Font f = new Font("新宋体",0,14);
		btleft.setFont(f);

		lb1.setFont(new java.awt.Font("新宋体", 1, 18));
        lb1.setForeground(new Color(0, 51, 255));
        getContentPane().add(lb1);
        lb1.setBounds(110, 20, 160, 30);

        lb2.setFont(f);
        getContentPane().add(lb2);
        lb2.setBounds(40, 85, 70, 20);
        lb3.setFont(f);
        getContentPane().add(lb3);
        lb3.setBounds(40, 125, 70, 20);
        lb4.setFont(f);
        getContentPane().add(lb4);
        lb4.setBounds(40,165,70,20);
        lb5.setFont(f);
        getContentPane().add(lb5);
        lb5.setBounds(40,205,70,20);       
        
        getContentPane().add(id);
        id.setBounds(155,85,120,23);
        getContentPane().add(name);
        name.setBounds(155,125,120,23);
        getContentPane().add(jia);
        jia.setBounds(155,165,120,23);
         getContentPane().add(jian);
        jian.setBounds(155,205,120,23);

        btright.setFont(f);
		getContentPane().add(btright);
        btright.setBounds(330, 250, 50, 20);
        btright.addActionListener(this);

        btleft.setFont(f);
        getContentPane().add(btleft);
        btleft.setBounds(330, 230, 50, 20);
        btleft.addActionListener(this);

        btamend.setFont(f);
        getContentPane().add(btamend);
        btamend.setBounds(230, 240, 70, 25);
        btamend.addActionListener(this);

        btsave.setFont(f);
        getContentPane().add(btsave);
        btsave.setBounds(100, 240, 70, 25);
        btsave.addActionListener(this);
        
        
		Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-403)/2, (screenSize.height-329)/2, 403, 329);
        this.connection();
        setVisible(true);

	}
	
public void connection(){
    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        con=DriverManager.getConnection("jdbc:odbc:studentscore");
        stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE) ; 

        String sqlw="select * from studentscore";
        rs=stmt.executeQuery(sqlw);
        try{
           
           	  rs.next();
           	  String xh=(""+rs.getString("学号"));
           	  String xm=rs.getString("姓名");
           	  String jiafen=rs.getString("加分");
           	  String jianfen=rs.getString("减分");

           	  id.setText(xh);
           	  name.setText(xm);
           	  jia.setText(jiafen);
        	  jian.setText(jianfen);
      
          
        }
        catch(Exception esql){
        	   
        	   System.out.println(esql.getMessage());
        }
            } catch (Exception ex) {
    	System.out.println(ex.getMessage());
    }

    

    }
   public void actionPerformed(ActionEvent e){
       if(e.getSource()==btright)
        {

          	try{
          	  rs.previous();
           	  String xh=(""+rs.getString("学号"));
           	  String xm=rs.getString("姓名");
           	  String jiafen=rs.getString("加分");
           	  String jianfen=rs.getString("减分");
 

           	  id.setText(xh);
           	  name.setText(xm);
           	  jia.setText(jiafen);
        	  jian.setText(jianfen);

          	}
          	catch(Exception eup){
          	  System.out.println(eup.getMessage());
          	}
          }
          if(e.getSource()==btleft){
          try{
          rs.next();
           	  String xh=(""+rs.getString("学号"));
           	  String xm=rs.getString("姓名");
           	  String jiafen=rs.getString("加分");
           	  String jianfen=rs.getString("减分");

           	  id.setText(xh);
           	  name.setText(xm);
           	  jia.setText(jiafen);
        	  jian.setText(jianfen);

           	 
           	 }
           	 catch(Exception enext){
           	 	System.out.println(enext.getMessage());
           	 }
     }

	if(e.getSource()==btsave){
     if(jia.getText().equals("")||jian.getText().equals("")){
        		new JOptionPane().showMessageDialog(null,"以上信息必须填写!");
      }
     else{
     	     //btsave.setEnabled(true);
        
           	  
           	  String xh=id.getText();
           	  String xm=name.getText();
           	  String jiafen=jia.getText();
           	  String jianfen=jian.getText();

           	  
              		//id.setEditable(true);
              try{
              	    String Insert="insert into studentscore(加分,减分) values('"+jiafen+"','"+jianfen+"')";
                    stmt.executeUpdate(Insert);	
              		id.setEditable(true);
              		name.setEditable(true);
              		btsave.setEnabled(false);
              		
              		new JOptionPane().showMessageDialog(null,"添加数据成功！");
              		//ResultSet rs1;
              		String sql="select * from studentscore";
   		            rs=stmt.executeQuery(sql);
   	  		        rs.next();
   	  		        String xh1=(""+rs.getInt("学号"));
           	        String xm1=rs.getString("姓名");
           	        String jiafen1=rs.getString("加分");
           	        String jianfen1=rs.getString("减分");


           	        id.setText(xh1);
           	        name.setText(xm1);
           	        jia.setText(jiafen1);
        	        jian.setText(jianfen1);


                }
                                   catch(Exception esave){ System.out.println(esave.getMessage());
   	  				new JOptionPane().showMessageDialog(null,"添加数据不成功！");
              }
              }

         	}
          	
       if(e.getSource()==btamend){
          
      	 try{
   			  String supdate="update studentscore set 加分='"+ jia.getText() +"',减分='"+jian.getText()+"' where 学号='"+ id.getText()+"'";//学号='"+ id.getText()+"', 姓名='"+ name.getText()+"',
              new JOptionPane().showMessageDialog(null,"数据修改成功！");
   		      stmt.executeUpdate(supdate);
   		      //ResultSet rs1;
   	  		  String sqll="select * from studentscore";
   	          rs=stmt.executeQuery(sqll);
   	  		  rs.next();
   	  		        String xh1=(""+rs.getInt("学号"));
           	        String xm1=rs.getString("姓名");
           	        String jiafen1=rs.getString("加分");
           	        String jianfen1=rs.getString("减分");


           	        id.setText(xh1);
           	        name.setText(xm1);
           	        jia.setText(jiafen1);
        	        jian.setText(jianfen1);


        	}
      	 
      	 catch(Exception eupdapt){
      	 	System.out.println(eupdapt.getMessage());
      	 }
     }	
         	
  }
}