xinxicaozuo.java

java写的xuesheng信息管理系统！欢迎下载使用

																	
																		
																		
																		b3.addActionListener(   //添加的事件处理
																				new ActionListener()
																				{

																					public void actionPerformed(ActionEvent e) 
																					{
																						
																						String t1="'"+text2.getText().trim()+"'";
																						String t2="'"+text3.getText().trim()+"'";
																						String t3="'"+text4.getText().trim()+"'";
																						String t4="'"+text5.getText().trim()+"'";
																						String t5="'"+text6.getText().trim()+"'";
																						String t6="'"+text7.getText().trim()+"'";
																						String t7="'"+text8.getText().trim()+"'";
																						String t8="'"+text9.getText().trim()+"'";
																						String t9="'"+text10.getText().trim()+"'";
																						String t10="'"+123456+"'";
																						//String t1="'"+text8.getText().trim()+"'";
																						
																						
																						
																						
																						
																						final String url="jdbc:odbc:stuinf";
																						
																						
																						String sqltianjia="INSERT INTO  Student values(" + t1 + "," + t10 + "," +t2 + "," + t3 + "," + t4 + "," + t5 + "," + t6 + "," + t7 + "," + t8 + "," + t9 + ")";
																						
																										
																						
																						
																						try
																						{
																							Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
																						}
																						catch(java.lang.ClassNotFoundException e1)
																						{	
																						}
																						try
																						{
																							
																							Connection con=DriverManager.getConnection(url,"","");
																							Statement stmt=con.createStatement();
																							System.out.println(sqltianjia);
																								stmt.executeUpdate(sqltianjia);
																								
																								System.out.print("成功！");
																								jlabel.setText("成功！") ;
																							
																							stmt.close();
																							con.close();
																						
																						}
																						catch(SQLException ex)
																						{
																							System.out.print(ex.getMessage());
																						}
																						
																						
																					}
																					
																				}
																				);
																		b4.addActionListener(   //删除的事件处理
																				new ActionListener()
																				{

																					public void actionPerformed(ActionEvent e) 
																					{
																						
																						final String url="jdbc:odbc:stuinf";
																						String sqlshanchu="Delete  from Student where sno='"+mm+"'";
																						try
																						{
																							Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
																						}
																						catch(java.lang.ClassNotFoundException e1)
																						{	
																						}
																						try
																						{
																							
																							Connection con=DriverManager.getConnection(url,"","");
																							Statement stmt=con.createStatement();

																								int rs=stmt.executeUpdate(sqlshanchu);
																								
																								System.out.print("删除成功！");
																								jlabel.setText("删除成功！") ;
																							
																							stmt.close();
																							con.close();
																						
																						}
																						catch(SQLException ex)
																						{
																							System.out.print(ex.getMessage());
																						}
																						
																						
																					}
																					
																				}
																				);
																		
																		
																		b5.addActionListener(          //修改的事件处理
																				new ActionListener()
																				{

																					public void actionPerformed(ActionEvent e1) 
																					{
																						
																						final String url="jdbc:odbc:stuinf";
																						String sqlshanchu="Delete  from Student where sno='"+mm+"'";
																						try
																						{
																							Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
																						}
																						catch(java.lang.ClassNotFoundException e)
																						{	
																						}
																						try
																						{
																							
																							Connection con=DriverManager.getConnection(url,"","");
																							Statement stmt=con.createStatement();

																								int rs=stmt.executeUpdate(sqlshanchu);
																																				
																							
																							stmt.close();
																							con.close();
																						
																						}
																						catch(SQLException ex)
																						{
																							System.out.print(ex.getMessage());
																						}
																						
																						
																					String t1="'"+text2.getText().trim()+"'";
																					String t2="'"+text3.getText().trim()+"'";
																					String t3="'"+text4.getText().trim()+"'";
																					String t4="'"+text5.getText().trim()+"'";
																					String t5="'"+text6.getText().trim()+"'";
																					String t6="'"+text7.getText().trim()+"'";
																					String t7="'"+text8.getText().trim()+"'";
																					String t8="'"+text9.getText().trim()+"'";
																					String t9="'"+text10.getText().trim()+"'";
																					String t10="'"+123456+"'";
																				
																					
																					String sqltianjia="INSERT INTO  Student values(" + t1 + "," + t10 + "," +t2 + "," + t3 + "," + t4 + "," + t5 + "," + t6 + "," + t7 + "," + t8 + "," + t9 + ")";
																					
																									
																					
																					try
																					{
																						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
																					}
																					catch(java.lang.ClassNotFoundException e)
																					{	
																					}
																					try
																					{
																						
																						Connection con=DriverManager.getConnection(url,"","");
																						Statement stmt=con.createStatement();
																						System.out.println(sqltianjia);
																							stmt.executeUpdate(sqltianjia);
																							
																							System.out.print("成功！");
																							jlabel.setText("成功！") ;
																						
																						stmt.close();
																						con.close();
																					
																					}
																					catch(SQLException ex)
																					{
																						System.out.print(ex.getMessage());
																					}
																					
																					
																				}
																				
																			}
																
																		
																		
																		);
																		
																				
																			
																		
																							
																		
																		
																		
																	}
																	
																}
														);
														
														
													}
								        			
								        		}
								        );
										
									
								}
								
							}
					);
					 
			      
				}
        		
        	}
        )  ;

	}
	
	}