mangament.java

班级管理查询系统

package huazheng;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JTextField;
public class Mangament {
    final  JButton b=new JButton("确定");
    JLabel j1,j2,j3,j4,j5;
    JTextField f1,f2,f3,f4,f5;
    static String  s1,s2,s3,s4,s5;
    JFrame frame=new JFrame("添加");
    public void Welcome(){
    	 
    	frame.setSize(200,200);
    	frame.setLocation(300,300);
    	frame.setLayout(null);
    	frame.setResizable(false);
    	frame.setAlwaysOnTop(true);
    	//frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    	j1=new JLabel("学号");
    	j2=new JLabel("姓名");
    	j3=new JLabel("性别");
    	j4=new JLabel("住址");
    	j5=new JLabel("专业");
    	
    	f1=new JTextField(10);
    	f2=new JTextField(10);
    	f3=new JTextField(10);
    	f4=new JTextField(10);
    	f5=new JTextField(10);
    	frame.add(j1);
    	frame.add(f1);
    	
    	frame.add(j2);
    	frame.add(f2);
    	
    	frame.add(j3);
    	frame.add(f3);
    	
    	frame.add(j4);
    	frame.add(f4);
    	
    	frame.add(j5);
    	frame.add(f5);
    	
    	j1.setBounds(10,0,120,40);
    	f1.setBounds(40,10,120,20);
    	
    	j2.setBounds(10,20,120,40);
    	f2.setBounds(40,30,120,20);
    	
    	j3.setBounds(10,40,120,40);
    	f3.setBounds(40,50,120,20);
    	
    	j4.setBounds(10,60,120,40);
    	f4.setBounds(40,70,120,20);
    	
    	j5.setBounds(10,80,120,40);
    	f5.setBounds(40,90,120,20);
    	frame.add(b);
    	b.setBounds(10,130,120,30);
    	
    	frame.setVisible(true);
    	
    	
    	b.addActionListener(new ActionListener(){
    		public void actionPerformed(ActionEvent e){
    			if(e.getSource()==b){
    			s1=f1.getText().trim();
    	    	s2=f2.getText().trim();
    	    	s3=f3.getText().trim();
    	    	s4=f4.getText().trim();
    	    	s5=f5.getText().trim();
    	    	System.out.println(s1);
              insert();
              }
    		}
    	});
    	
    } 	
    public void insert(){
    	System.out.println(s1);
    	
	  	  Connection con=null;
	  	  Statement sql=null;
	  		try{
	  			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	  			System.out.println(" 成功加载JDBC-ODBC桥驱动器");
	  		}catch(ClassNotFoundException e){
	  		}
	  		try{
	  			con=DriverManager.getConnection("jdbc:odbc:hua","huazheng","huazheng");
	  			sql=con.createStatement();
	  		    sql.executeUpdate("INSERT INTO huazheng3 VALUES("+"'"+s1+"'"+","+"'"+s2+"'"+","+"'"+s3+"'"+","+"'"+s4+"'"+","+"'"+s5+"'"+")");
	  			
	  		}
	  		catch(SQLException e){
	  			System.out.println("dfefdfsd");
	  		}
	  		frame.setVisible(false);
    }
	public static void main(String[] args) {
		System.out.println("dddfdsafdfsdfsfdff");
	    
	}

}