jmenudemo.java

一个通过odbc链接数据库（mysql）的奖学金评定系统！·

					 Object[][] data=new Object [10][6];
					 int i=0;
					 while(rs.next())
					 {  
						
						 data[i][0]=rs.getString("num");
						 data[i][1]=rs.getString("sid");
						 data[i][2]=rs.getString("sname");
						 data[i][3]=rs.getString("av");

						 i++;
                      
					 }
					 JInternalFrame iframe=new JInternalFrame(ac,true,true,true,true);
					
					 String[] columnNames = jsql.col2;
					 final  JTable jtb = new JTable(data, columnNames);		
					 jtb.setPreferredScrollableViewportSize(new Dimension(500,370));            
					 iframe.getContentPane().add(jtb);
					 JScrollPane scroPanel = new JScrollPane(); 
					 scroPanel.getViewport().setBackground(Color.white);
					 scroPanel.getViewport().add(jtb);
					 iframe.getContentPane().add(scroPanel, BorderLayout.NORTH);
					 desktop.add(iframe);
					 iframe.setVisible(true);
					 iframe.setSize(480,400);

					 rs.close();
					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }


			 }			


			 if (ac=="运行计算奖学金")
			 {
				 Jdbcsql jsql=new Jdbcsql();
				 Desktop dsk=new Desktop();
				 try
				 {
					 Class.forName(jsql.drv);
				 }
				 catch(ClassNotFoundException e)
				 {
					 System.out.println("Unable to load Driver Class");
					 return;
				 }
				 try
				 {
					 Connection con = DriverManager.getConnection(jsql.con,"root","luanluan");
					 Statement stmt=con.createStatement();
			       ResultSet rs1=stmt.executeQuery(jsql.sql5);
					   ResultSet rs2=stmt.executeQuery(jsql.sql7);
                             rs2.close();
					 rs1.close();
					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }
				 try
				 {
					 Class.forName(jsql.drv);
				 }
				 catch(ClassNotFoundException e)
				 {
					 System.out.println("Unable to load Driver Class");
					 return;
				 }
				 try
				 {
					 Connection con = DriverManager.getConnection(jsql.con,"root","luanluan");
					 Statement stmt=con.createStatement();
					
					 ResultSet rs2=stmt.executeQuery(jsql.sql7);
					 rs2.close();

					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }

			 }			


			 if (ac=="删除列表")
			 {
				 Jdbcsql jsql=new Jdbcsql();
				 Desktop dsk=new Desktop();
				 try
				 {
					 Class.forName(jsql.drv);
				 }
				 catch(ClassNotFoundException e)
				 {
					 System.out.println("Unable to load Driver Class");
					 return;
				 }
				 try
				 {
					 Connection con = DriverManager.getConnection(jsql.con,"root","luanluan");
					 Statement stmt=con.createStatement();
					 ResultSet rs1=stmt.executeQuery(jsql.sql6);
					
				
					 rs1.close();
					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }
				

			 }			


			 if (ac=="学习奖学金")
			 {
				 Jdbcsql jsql=new Jdbcsql();
				 Desktop dsk=new Desktop();
				 try
				 {
					 Class.forName(jsql.drv);
				 }
				 catch(ClassNotFoundException e)
				 {
					 System.out.println("Unable to load Driver Class");
					 return;
				 }
				 try
				 {
					 Connection con = DriverManager.getConnection(jsql.con,"root","luanluan");
					 Statement stmt=con.createStatement();
					 ResultSet rs=stmt.executeQuery(jsql.sql3);
					 Object[][] data=new Object [26][6];
					 int i=0;
					 while(rs.next())
					 {  
						
						 data[i][0]=rs.getString("sid1");
						 data[i][1]=rs.getString("sname");
						 data[i][2]=rs.getString("c");

						 i++;
                      
					 }
					 JInternalFrame iframe=new JInternalFrame(ac,true,true,true,true);
					
					 String[] columnNames = jsql.col1;
					 final  JTable jtb = new JTable(data, columnNames);		
					 jtb.setPreferredScrollableViewportSize(new Dimension(500,170));            
					 iframe.getContentPane().add(jtb);
					 JScrollPane scroPanel = new JScrollPane(); 
					 scroPanel.getViewport().setBackground(Color.white);
					 scroPanel.getViewport().add(jtb);
					 iframe.getContentPane().add(scroPanel, BorderLayout.NORTH);
					 desktop.add(iframe);
					 iframe.setVisible(true);
					 iframe.setSize(480,400);

					 rs.close();
					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }


			 }			

			 if (ac=="平均分数")
			 {
				 Jdbcsql jsql=new Jdbcsql();
				 Desktop dsk=new Desktop();
				 try
				 {
					 Class.forName(jsql.drv);
				 }
				 catch(ClassNotFoundException e)
				 {
					 System.out.println("Unable to load Driver Class");
					 return;
				 }
				 try
				 {
					 Connection con = DriverManager.getConnection(jsql.con,"root","luanluan");
					 Statement stmt=con.createStatement();
					 ResultSet rs=stmt.executeQuery(jsql.sql3);
					 Object[][] data=new Object [26][6];
					 int i=0;
					 while(rs.next())
					 {  
						
						 data[i][0]=rs.getString("sid1");
						 data[i][1]=rs.getString("sname");
						 data[i][2]=rs.getString("c");

						 i++;
                      
					 }
					 JInternalFrame iframe=new JInternalFrame(ac,true,true,true,true);
					
					 String[] columnNames = jsql.col1;
					 final  JTable jtb = new JTable(data, columnNames);		
					 jtb.setPreferredScrollableViewportSize(new Dimension(500,370));            
					 iframe.getContentPane().add(jtb);
					 JScrollPane scroPanel = new JScrollPane(); 
					 scroPanel.getViewport().setBackground(Color.white);
					 scroPanel.getViewport().add(jtb);
					 iframe.getContentPane().add(scroPanel, BorderLayout.NORTH);
					 desktop.add(iframe);
					 iframe.setVisible(true);
					 iframe.setSize(480,400);

					 rs.close();
					 stmt.close();
					 con.close();
				 }
				 catch(SQLException se)
				 {
					 System.out.println("SQL exception: "+se.getMessage());
					 se.printStackTrace(System.out);
				 }


			 }			


			 
			 
            
         }
      };

      //添加文件菜单和添加快捷键
      for (int i=0; i < fileItems.length; i++) {
         JMenuItem item = new JMenuItem(fileItems[i]);
         item.setAccelerator(KeyStroke.getKeyStroke(fileShortcuts[i],
              Toolkit.getDefaultToolkit(  ).getMenuShortcutKeyMask(  ), false));
         item.addActionListener(printListener);
         fileMenu.add(item);
      }
      //在退出的上面添加横条
      fileMenu.insertSeparator(3);
	   
   

     //添加编辑菜单和快捷键
      for (int i=0; i < editItems.length; i++) {
         JMenuItem item = new JMenuItem(editItems[i]);
         item.setAccelerator(KeyStroke.getKeyStroke(editShortcuts[i],
              Toolkit.getDefaultToolkit(  ).getMenuShortcutKeyMask(  ), false));
         item.addActionListener(printListener);
         editMenu.add(item);
	

      }

	   for (int i=0; i < editItems1.length; i++) 
	   {
		   JMenuItem item = new JMenuItem(editItems1[i]);
		   item.setAccelerator(KeyStroke.getKeyStroke(editShortcuts[i],
			   Toolkit.getDefaultToolkit(  ).getMenuShortcutKeyMask(  ), false));
		   item.addActionListener(printListener);
		   editMenu1.add(item);
	

	   }



      //插入在“撤销”下面一条横条
//      editMenu.insertSeparator(1);


      add(fileMenu);
      add(editMenu);
      add(editMenu1);


   }
   
}