connection.java

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

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

import javax.swing.*;


public class connection extends JFrame {
	private JTable table;
	
	
	public connection()
	{
			try{ 
			Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" ); 
			String url = "jdbc:odbc:myaccess"; 
			Connection connection = DriverManager.getConnection( url ); 
			Statement statement = connection.createStatement(); 
/*			String sql = "SELECT * FROM User"; 
			ResultSet rs = statement.executeQuery( sql );
				
						boolean moreRecords = rs.next();      // 定位到第一条记录
     					if ( ! moreRecords ) {                // 如果没有记录，则显示一条消息
     					JOptionPane.showMessageDialog( this,"结果集中无记录" );
      					setTitle( "无记录显示" );
         				return;
      					}
						
						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 ) );
//							System.out.println( columnHeads.firstElement() );
						}
						while( rs.next() ){
							rows.addElement( getNextRow( rs, rsmd ) );
							System.out.println( rows.firstElement() );
						}
						table = new JTable( rows, columnHeads );
*/			
			String sql = "Select Storage_quantity from Book_info where Book_id = '2' ";
			ResultSet rs = statement.executeQuery( sql );
//			ResultSetMetaData rsmd = rs.getMetaData();
			rs.next();
			int a = rs.getInt( "Storage_quantity" );
			System.out.println( a );
			
			rs.close();
			connection.close();
		}
		catch( Exception ex ){ 
			System.out.println( ex ); 
		}
	}
	
	
	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[] )
	{
		connection application = new connection();
		String b = "60";
		int c = Integer.parseInt( b );
		
		System.out.println( c );
	}
	
}