manager1.java

中小型书店管理系统,主要是为了方便书店的管理而编写的管理系统.

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.util.*;

import javax.swing.*;


public class Manager1 extends JFrame {
	private Container container;
	private JTable table;
	
	public Manager1()
	{
		super( "管理员" );
		
		JMenu fileMenu = new JMenu( "菜单---ALT+F" );
		fileMenu.setMnemonic( 'F' );
		
		JMenuItem storItem = new JMenuItem( "库存管理---------S" );
		storItem.setMnemonic( 'S' );
		
		storItem.addActionListener(
			new ActionListener() {
				public void actionPerformed( ActionEvent event )
				{
					Storage2.main( null );
				}
			}
		);
		
		fileMenu.add( storItem );
		
		 
		JMenuItem infoItem = new JMenuItem( "书籍信息管理---I" );
		infoItem.setMnemonic( 'I' );
		
		infoItem.addActionListener(
			new ActionListener() {
				public void actionPerformed( ActionEvent event )
				{
					Information.main( null );
				}
			}
		);
		
		fileMenu.add( infoItem );
		
		JMenuItem exitItem = new JMenuItem( "退出---------------X" );
		exitItem.setMnemonic( 'X' );
		
		exitItem.addActionListener(
			new ActionListener() {
				public void actionPerformed( ActionEvent event )
				{
					System.exit( 0 );
				}
			}
		);
		
		fileMenu.add( exitItem );
		
		JMenuBar bar = new JMenuBar();
		setJMenuBar( bar );
		bar.add( fileMenu );
//-------------------------------------------
		container = getContentPane();
		container.setLayout( new FlowLayout() );
		
		JLabel label = new JLabel( "库存报警(库存数量<3)" );
		container.add( label );
		
		try{ 
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
			String url = "jdbc:odbc:myaccess"; 
			Connection connection = DriverManager.getConnection( url ); 
			Statement statement = connection.createStatement(); 
			String sql = "SELECT Book_id, Book_name, Book_type, Storage_quantity from Book_info where Storage_quantity < 3"; 
			ResultSet rs = statement.executeQuery( sql );
			boolean moreRecords = rs.next();      // 定位到第一条记录
     						
     		if ( !moreRecords ){
     			JOptionPane.showMessageDialog( null,"无库存报警" );
      		}
      		else{
				Vector columnHeads = new Vector();
				Vector rows = new Vector();
			
				ResultSetMetaData rsmd = rs.getMetaData();
				for( int i = 1; i <= rsmd.getColumnCount(); i++ ){
					columnHeads.addElement( rsmd.getColumnName( i ) );
				}
				do{
					rows.addElement( getNextRow( rs, rsmd ) );
				}while( rs.next() );
				table = new JTable( rows, columnHeads );
			}	
			container.add( table, BorderLayout.CENTER );
			container.add( new JScrollPane( table ) );
			container.validate();
			rs.close(); 
			connection.close();
		}
		catch( Exception ex ){ 
			System.out.println( ex ); 
		}
		
		setSize( 500,500 );
		setVisible( true );
		
	}
	
	private Vector getNextRow( ResultSet rs,ResultSetMetaData rsmd ) throws SQLException{
      Vector currentRow = new Vector();
      for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
         currentRow.addElement( rs.getString( i ) );
      return currentRow;      //返回一条记录
    }
	
	public static void main( String args[] )
	{
		
		Manager1 application = new Manager1();
		
		application.setDefaultCloseOperation( JFrame.EXIT_ON_CLOSE );
	}
}