first.java

自己写的小程序

import javax.swing.*;
//import java.awt.*;
import java.awt.event.*;
//import javax.sql.*;
import java.sql.*;
import java.util.*;
public class First {
	JFrame window;
	JPanel jp;
	JButton jb;
	JLabel jl;
	JLabel jmax;
	JTextArea jt;
	String name="";
	int num[];
	int number=10;
	public First(){
		 window=new JFrame();
		 jp=new JPanel();
		 jb=new JButton("你觉得谁最笨？按一下得到答应");
		 jl=new JLabel("");
		 num=new int[11];
         jt=new JTextArea();
         jmax=new JLabel();
}
         
	public void first(){
		jp.add(jb);
		jp.add(jl);
		jp.add(jt);
		jp.add(jmax);
		jb.addActionListener(new press());
		window.getContentPane().add(jp);
		window.setSize(200, 400);
		window.setVisible(true);
		//System.out.println("dsdfsd");
		
	}
	class press implements ActionListener {
		public void actionPerformed(ActionEvent e) 
		{	
			try{
			
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				}
				catch(java.lang.ClassNotFoundException cx) 
					{
           				 System.err.print("ClassNotFoundException: ");
       	    			 System.err.println(cx.getMessage());
      				}
					
				
				
			try {
				
				int id;
				int n=0;
				Random rd=new Random();
				Statement stmt;
			
        		String url="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=first.mdb";	      
            	Connection con=DriverManager.getConnection(url,"","");
            	stmt = con.createStatement();
            	String sql;
            	while(n<1000){
            		
            	id=rd.nextInt(1100);
            	//System.out.println(id);
            	sql="select * from employer where id='"+id+"'";
            	
            	
            	ResultSet rs=stmt.executeQuery(sql);
            	while(rs.next())
            	{
            		name=rs.getString(2);
            	}
            		num[id/100]+=1;
            		n+=1;
            		jl.setText(name+"笨到顶点！已经笨了"+num[id/100]+"次了");	
				
				}	
					int max=0;
					String maxname="徐鲜艳";
					jl.setText("谢谢光临,请看答案");
					for(int i=0;i<11;i++){
						sql="select * from employer where id='"+i+"'";
						 ResultSet rs=stmt.executeQuery(sql);
						
						while(rs.next())
            				{
            				name=rs.getString(2);
            				
            				}
            				if(num[max]<num[i]){
            					max=i;
            					maxname=name;
            				}
							
						jt.append(name+"笨了"+num[i]+"次\n");
						
					}
					jmax.setText(maxname+"你不行了,最笨了,笨了"+num[max]+"次");
					
				
            stmt.close();
            con.close();
			}catch(SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }         
			
				
				
		
			
			
		}
	}
	public static void main(String args[]){
		First f=new First();
		f.first();
	}
	

}