bikeinfo.java

关于自行车店管理系统的源代码

		{
				if (JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog(this,"你确认要添加吗？","确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE))
				{																        	    
	        	    Connection con=null;
 				   	Statement sql=null;
 				   	Statement sql2=null;
 				   	Statement sql3=null;
 				   	Statement sql4=null;
				    ResultSet result;
				    ResultSet result2;
				    ResultSet result3;
				    ResultSet result4;
    				try
    				{
	    				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    				}
	  			 	catch(ClassNotFoundException ee)
	   				{
	   					System.out.println(""+ee);
    				}
	   				try
	   				{
	   					Object[] object=
				  		{
							studentnumber.getText(),
							name.getText(),
							new String(password.getText()),
							sex.getSelectedItem(),
							age.getText(),
							grade.getSelectedItem(),						
							new Boolean(party.isSelected()),
							telephone.getText(),						
							adress.getText(),																								
							photo.getIcon(),
							resume.getText(),
						};
						model.addRow(object);
						num++;
	   						   						   						   					
		   				con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
					   	sql=con.createStatement();
					   	sql2=con.createStatement();
					   	sql3=con.createStatement();
					   	sql4=con.createStatement();
					   	result2=sql2.executeQuery("SELECT * FROM student1");
					   	result4=sql4.executeQuery("SELECT * FROM student");
					   	String temps=studentnumber.getText();
		 			   	long templong=Long.parseLong(temps);
		 			  	boolean tempbool=false;
		 			  	while(result4.next())
		 			  	{
		 			  		if(result4.getLong("sn")==templong)
		 			  		{
		 			  			JOptionPane.showMessageDialog(this,"该代号已存在，请重新输入！","警告",JOptionPane.WARNING_MESSAGE);
		 			  			studentnumber.setText("");
	        		 		    name.setText("");
	        		   		    password.setText("");
	        	        	    telephone.setText("");
	        		    	    adress.setText("");
	        		    	    sex.setSelectedIndex(0);
	        	     		    party.setSelected(false);
	        		 		    age.setText("");
	        		    	    grade.setSelectedIndex(0);
	        		 		    resume.setText("");
	        		 		    photo.setIcon(new ImageIcon("2.gif"));
	        		   		    con.close();
		 			  			tempbool=true;
		 			  		}
		 			  	}
		 			  	//name.setText("===============3");
		 			  	if(tempbool==false)
		 			  	{
		 			  		//name.setText("===============2");
		 			  		while(result2.next())
					    	{
					   		idcount=result2.getInt("ID");
					   		idcount2=idcount+1;
					    	}
					    	
					    	//name.setText("===============1");
					  		String s1=studentnumber.getText();
							long t1=Long.parseLong(s1);
						
							String s2="'"+name.getText()+"'";
						
							String temps3=new String(password.getText());
							String s3="'"+temps3+"'";
						
							int t4=sex.getSelectedIndex();
						
							String s5=age.getText();
							int t5=Integer.parseInt(s5);
						
							int t6=grade.getSelectedIndex();
						
							//boolean bool7;
						
							String s8="'"+telephone.getText()+"'";
						
							String s9="'"+adress.getText()+"'";
						
							String s10="'"+filenamepath+"'";
												
							String s11="'"+resume.getText()+"'";
						
							String temp="INSERT INTO student VALUES("+idcount+","+t1+","+s2+","+s3+","+t4+","+t5+","+t6+","+new Boolean(party.isSelected())+","+s8+","+s9+","+s10+","+s11+")";
							sql.executeUpdate(temp);
							String temp2="UPDATE student1 SET ID="+idcount2+" WHERE ID="+idcount+"";
							sql3.executeUpdate(temp2);
	        		  		con.close();	        		    	        		    
	        		  		JOptionPane.showMessageDialog(this,"输入成功！","消息提示",JOptionPane.INFORMATION_MESSAGE);
	        			    studentnumber.setText("");
	        		 	    name.setText("");
	        		   	    password.setText("");
	        	            telephone.setText("");
	        		        adress.setText("");
	        		        sex.setSelectedIndex(0);
	        	     	    party.setSelected(false);
	        		 	    age.setText("");
	        		        grade.setSelectedIndex(0);
	        		 	    resume.setText("");
	        		 	    photo.setIcon(new ImageIcon("2.gif"));
	        		   	    con.close();		 			  		
		 			 	}		 			  							   	
	        	 	}
	        	    catch(SQLException e1)
					{
					}
	        	 }
		}
		
		if(e.getSource()==delete)
		{
			Connection con=null;
   		 	Statement sql=null;
   		 	Statement sql2=null;
		    ResultSet result2;
    		try
    		{
	  		  	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		}
	   		catch(ClassNotFoundException e2)
	  	 	{
	   			System.out.println(""+e);
    		}
	   		try
	  	 	{
	  	 		if (JOptionPane.YES_OPTION==JOptionPane.showConfirmDialog(this,"你确认要删除吗？","确认",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE))
	  	 		{
	  	 			con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
		 		  	sql=con.createStatement();
		 	 		sql2=con.createStatement();
		 		  	result2=sql2.executeQuery("SELECT * FROM student");
		 	 	 	String temps=studentnumber.getText();
		 		   	long templong=Long.parseLong(temps);
		 		  	boolean tempbool=false;
			 	  	while(result2.next())
			 	 	{
		 	  			if(result2.getLong("sn")==templong)
		 	  			{ 			
		 	 			 	sql.executeUpdate("DELETE FROM student WHERE sn="+templong+"");	 	  	
		 	 				tempbool=true;
		 	 	 			JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.INFORMATION_MESSAGE);
		 	 			 	studentnumber.setText("");
	        		 	    name.setText("");
	        			    password.setText("");
	       		 		    telephone.setText("");
	       		 	  	    adress.setText("");
	       			        sex.setSelectedIndex(0);
	       		 	 	    party.setSelected(false);
	            	 		age.setText("");
	        				grade.setSelectedIndex(0);
	        				resume.setText("");
	        				photo.setIcon(new ImageIcon("2.gif"));
		 	 		 		con.close();
		 	  			}
		 	  		}
		 	 		if(tempbool==false)
		 	  		{
		 	  			studentnumber.setText("");		 	  			
		 	  			name.setText("");
		 	  			password.setText("");
		 	  			telephone.setText("");
		 	  			adress.setText("");
		 	  			sex.setSelectedIndex(0);
		 	  			party.setSelected(false);
		 	  			age.setText("");
		 	  			grade.setSelectedIndex(0);
		 	  			resume.setText("");
		 	  			photo.setIcon(new ImageIcon("2.gif"));
		 	  			con.close();
		 	  			JOptionPane.showMessageDialog(this,"该代号不存在，请重新输入！","警告",JOptionPane.WARNING_MESSAGE);
		 	  		}
		 	  	}
    		}
			catch(SQLException ee2)
			{			
			}
		}
		
		if(e.getSource()==search)
		{
			Connection con=null;
   		 	Statement sql=null;
		    ResultSet result;
    		try
    		{
	   		 	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		}
	   		catch(ClassNotFoundException e3)
	  	 	{
	   			System.out.println(""+e);
    		}
	   		try
	   		{
		 	  	con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
		  	 	sql=con.createStatement();
		  	 	result=sql.executeQuery("SELECT * FROM student");
		  	 	String temps=studentnumber.getText();
		 	  	long templong=Long.parseLong(temps);
		 	 	boolean tempbool=false;
		  	 	while(result.next())
		  	 	{
		  	 		if(result.getLong("sn")==templong)
		  	 		{
		  	 			tempbool=true;
		  	 			String tempsn=String.valueOf(templong);
		  	 			studentnumber.setText(tempsn);		 	  			
		 	  			name.setText(result.getString("name"));
		 	  			password.setText(result.getString("password"));
		 	  			telephone.setText(result.getString("telephone"));
		 	  			adress.setText(result.getString("adress"));
		 	  			sex.setSelectedIndex(result.getInt("sex"));
		 	  			party.setSelected(result.getBoolean("party"));
		 	  			age.setText(result.getString("age"));
		 	  			grade.setSelectedIndex(result.getInt("grade"));
		 	  			resume.setText(result.getString("resume"));
		 	  			photo.setIcon(new ImageIcon(result.getString("photo")));
		  	 		}
		  	 		
		  	 	}
		  	 	if(tempbool==false)
		  	 	{
		  	 		JOptionPane.showMessageDialog(this,"该代号不存在，请重新输入！","警告",JOptionPane.WARNING_MESSAGE);
		  	 		studentnumber.setText("");		 	  			
		 	  		name.setText("");
		 	  		password.setText("");
		 	  		telephone.setText("");
		 	  		adress.setText("");
		 	  		sex.setSelectedIndex(0);
		 	  		party.setSelected(false);
		 	  		age.setText("");
		 	  		grade.setSelectedIndex(0);
		 	  		resume.setText("");	
		 	  		photo.setIcon(new ImageIcon("2.gif"));	  	 		
		  	 	}
		  	 	
    		}
			catch(SQLException ee3)
			{
			}	
		}
		
		if(e.getSource()==change)
		{
			Connection con=null;
   		 	Statement sql=null;
   		 	Statement sql2=null;
		    ResultSet result;
		    ResultSet resul2t;
    		try
    		{
	   		 	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		}
	   		catch(ClassNotFoundException e4)
	  	 	{
	   			System.out.println(""+e4);
    		}
	   		try
	   		{
		 	  	con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
		  	 	sql=con.createStatement();
		  	 	sql2=con.createStatement();
		  	 	result=sql.executeQuery("SELECT * FROM student");
		  	 	String temps=studentnumber.getText();
		 	  	long templong=Long.parseLong(temps);
		 	 	boolean tempbool=false;
		  	 	while(result.next())
		  	 	{		  	 		
		  	 		if(result.getLong("sn")==templong)
		  	 		{
		  	 			tempbool=true;
		  	 									
						String s2="'"+name.getText()+"'";
						sql2.executeUpdate("UPDATE student SET name="+s2+" WHERE sn="+templong+"");
					
						String temps3=new String(password.getText());
						String s3="'"+temps3+"'";
						sql2.executeUpdate("UPDATE student SET password="+s3+" WHERE sn="+templong+"");
						
						int t4=sex.getSelectedIndex();
						sql2.executeUpdate("UPDATE student SET sex="+t4+" WHERE sn="+templong+"");
					
						String s5=age.getText();
						int t5=Integer.parseInt(s5);
						sql2.executeUpdate("UPDATE student SET age="+t5+" WHERE sn="+templong+"");						
						
						int t6=grade.getSelectedIndex();
						sql2.executeUpdate("UPDATE student SET grade="+t6+" WHERE sn="+templong+"");
											
						sql2.executeUpdate("UPDATE student SET party="+new Boolean(party.isSelected())+" WHERE sn="+templong+"");
						
						String s8="'"+telephone.getText()+"'";
						sql2.executeUpdate("UPDATE student SET telephone="+s8+" WHERE sn="+templong+"");
						
						String s9="'"+adress.getText()+"'";
						sql2.executeUpdate("UPDATE student SET adress="+s9+" WHERE sn="+templong+"");
						
						String s10="'"+filenamepath+"'";
						sql2.executeUpdate("UPDATE student SET photo="+s10+" WHERE sn="+templong+"");
												
						String s11="'"+resume.getText()+"'";
						sql2.executeUpdate("UPDATE student SET resume="+s11+" WHERE sn="+templong+"");
						JOptionPane.showMessageDialog(this,"修改成功！","提示：",JOptionPane.INFORMATION_MESSAGE);	  
		  	 		}
		  	 	}
		  	 	if(tempbool==false)
		  	 	{
		  	 		JOptionPane.showMessageDialog(this,"该号不存在，请重新输入！","警告：",JOptionPane.WARNING_MESSAGE);
		  	 		studentnumber.setText("");		 	  			
		 		  	name.setText("");
		 	 	 	password.setText("");
		 	  		telephone.setText("");
		 	  		adress.setText("");
		 	  		sex.setSelectedIndex(0);
		 	  		party.setSelected(false);
		 	  		age.setText("");
		 	  		grade.setSelectedIndex(0);
		 	  		resume.setText("");	
		 	  		photo.setIcon(new ImageIcon("2.gif"));
		  	 	}
		  	 }
		  	 catch(SQLException ee4)
		   	{
			}	
		}
		if(e.getSource()==next)
		{
			Connection con=null;
   		 	Statement sql=null;
		    ResultSet result;
    		try
    		{
	   		 	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    		}
	   		catch(ClassNotFoundException e5)
	  	 	{
	   			System.out.println(""+e5);
    		}
	   		try
	   		{
		 	  	con=DriverManager.getConnection("jdbc:odbc:me2","zww","123");
		  	 	sql=con.createStatement();
		  	 	result=sql.executeQuery("SELECT * FROM student");
		  	 	String temps=studentnumber.getText();
		 	  	long templong=Long.parseLong(temps);
		 	 	boolean tempbool=false;
		 	 	boolean tempbool2=false;
		 	 	while(result.next())
		 	 	{
		 	 		if(tempbool2==true)
		 	 		{
		 	 			long templong2=result.getLong("sn");
		  	 			String tempsn=String.valueOf(templong2);
		  	 			studentnumber.setText(tempsn);		 	  			
		 	  			name.setText(result.getString("name"));
		 	  			password.setText(result.getString("password"));
		 	  			telephone.setText(result.getString("telephone"));
		 	  			adress.setText(result.getString("adress"));
		 	  			sex.setSelectedIndex(result.getInt("sex"));
		 	  			party.setSelected(result.getBoolean("party"));
		 	  			int tempage=result.getInt("age");
		 	  			String tempage1=String.valueOf(tempage);
		 	  			age.setText(tempage1);
		 	  			grade.setSelectedIndex(result.getInt("grade"));
		 	  			resume.setText(result.getString("resume"));
		 	  			photo.setIcon(new ImageIcon(result.getString("photo")));
		 	  			
		 	  			tempbool2=false;
		 	 		}
		 	 		if(result.getLong("sn")==templong)
		 	 		{
		 	 			tempbool=true;
		 	 			tempbool2=true;		  	 					  	 			
		 	 		}
		 	 	}
		 	 	if(tempbool==false)
		  	 	{
		  	 		JOptionPane.showMessageDialog(this,"该号不存在，请重新输入！","警告：",JOptionPane.WARNING_MESSAGE);
		  	 		studentnumber.setText("");		 	  			
		 		  	name.setText("");
		 	 	 	password.setText("");
		 	  		telephone.setText("");
		 	  		adress.setText("");
		 	  		sex.setSelectedIndex(0);
		 	  		party.setSelected(false);
		 	  		age.setText("");
		 	  		grade.setSelectedIndex(0);