mysql problems in netbeans

appu sharma

Ranch Hand

Posts: 104

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello everyone,
I try to run following code in netbeans as a IDE and mysql as database.
I have added my sql connector in CLASSPATH and tool\libraries in netbeans and still getting the error
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
here is the code

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

public class DisplayQueryResults extends JPanel {
   private Connection connection;
   private Statement statement;
   private ResultSet resultSet;
   private ResultSetMetaData rsMetaData;

private JTable table;
   private JTextArea inputQuery;
   private JButton submitQuery;

public DisplayQueryResults()
   {

String url = "jdbc:mysql://localhost:3306/abc";
      String username = "root";
      String password = "root";

try {
            Class.forName ("com.mysql.jdbc.Driver").newInstance();
         connection = DriverManager.getConnection(
            url, username, password );
          System.out.println ("Database connection established");
      }
      catch ( ClassNotFoundException cnfex ) {
         System.err.println(
            "Failed to load JDBC/ODBC driver." );
         cnfex.printStackTrace();
         System.exit( 1 );  // terminate program
      }
      catch ( Exception sqlex ) {
         System.err.println( "Unable to connect" );
         sqlex.printStackTrace();
         System.exit( 1 );  // terminate program
      }

inputQuery =
         new JTextArea( "SELECT * FROM Authors", 4, 30 );
      submitQuery = new JButton( "Submit query" );
      submitQuery.addActionListener(
         new ActionListener() {
            public void actionPerformed( ActionEvent e )
            {
               getTable();
            }
         }
      );

JPanel topPanel = new JPanel();
      topPanel.setLayout( new BorderLayout() );
      topPanel.add( new JScrollPane( inputQuery),
                    BorderLayout.CENTER );
      topPanel.add( submitQuery, BorderLayout.SOUTH );

table = new JTable( 4, 4 );

setLayout( new BorderLayout() );
      add( topPanel, BorderLayout.NORTH );
      add( table, BorderLayout.CENTER );

getTable();

setSize( 500, 500 );
      show();
   }

private void getTable()
   {
      try {
         String query = inputQuery.getText();

statement = connection.createStatement();
         resultSet = statement.executeQuery( query );
         displayResultSet( resultSet );
      }
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
      }
   }

private void displayResultSet( ResultSet rs )
      throws SQLException
   {
      // position to first record
      boolean moreRecords = rs.next();

// If there are no records, display a message
      if ( ! moreRecords ) {
         JOptionPane.showMessageDialog( this,
            "ResultSet contained no records" );
         return;
      }

Vector columnHeads = new Vector();
      Vector rows = new Vector();

try {
         // get column heads
         ResultSetMetaData rsmd = rs.getMetaData();

for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
            columnHeads.addElement( rsmd.getColumnName( i ) );

// get row data
         do {
            rows.addElement( getNextRow( rs, rsmd ) );
         } while ( rs.next() );

// display table with ResultSet contents
         table = new JTable( rows, columnHeads );
         JScrollPane scroller = new JScrollPane( table );
         remove( 1 );
         add( scroller, BorderLayout.CENTER );
         validate();
      }
      catch ( SQLException sqlex ) {
         sqlex.printStackTrace();
      }
   }

private Vector getNextRow( ResultSet rs,
                              ResultSetMetaData rsmd )
       throws SQLException
   {
      Vector currentRow = new Vector();

for ( int i = 1; i <= rsmd.getColumnCount(); ++i )
         switch( rsmd.getColumnType( i ) ) {
            case Types.VARCHAR:
            case Types.LONGVARCHAR:
                  currentRow.addElement( rs.getString( i ) );
               break;
            case Types.INTEGER:
                  currentRow.addElement(
                     new Long( rs.getLong( i ) ) );
               break;
            default:
               System.out.println( "Type was: " +
                  rsmd.getColumnTypeName( i ) );
         }

return currentRow;
   }

public void shutDown()
   {
      try {
         connection.close();
      }
      catch ( SQLException sqlex ) {
         System.err.println( "Unable to disconnect" );
         sqlex.printStackTrace();
      }
   }

public static void main( String args[] )
   {
JFrame f=new JFrame("Vedisoft: JDBC Example 3");
final DisplayQueryResults td = new DisplayQueryResults();
	f.setContentPane(td);
	f.setSize(500,500);
	f.setVisible(true);
	f.addWindowListener(
         new WindowAdapter() {
            public void windowClosing( WindowEvent e )
            {
               td.shutDown();
               System.exit( 0 );
            }
         }
      );
   }
}

It doesn't matter if you win by an inch or a mile; winning's winning.

appu sharma

Ranch Hand

Posts: 104

I like...

posted 14 years ago