DBConnect for myProject.sql

package new0;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import java.sql.Statement;

import java.sql.ResultSet;

import javax.swing.JOptionPane;

import javax.swing.table.DefaultTableModel;

public class DBConnect extends javax.swing.JFrame
{
    public DBConnect()
    {
        initComponents();
    }
    // <editor-fold defaultstate="collapsed" desc="Generated Code">
    private void initComponents() {

        jScrollPane2 = new javax.swing.JScrollPane();
        p1 = new javax.swing.JTable();
        jButton2 = new javax.swing.JButton();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        p1.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {

            },
            new String [] {
                "memoryID", "memoryName"
            }
        ));
        jScrollPane2.setViewportView(p1);

        jButton2.setText("FETCH DATA");
        jButton2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButton2ActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jButton2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 557, Short.MAX_VALUE))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 275, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addGap(34, 34, 34)
                .addComponent(jButton2)
                .addContainerGap(132, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
        // TODO add your handling code here:
         //DefaultTableModel model = (DefaultTableModel)p1.getModel();
        String host = "jdbc:derby://localhost:1527/diary";
        String username = "nbuser";
        String password = "nbuser";
        try
        {
            //Class.forName("java.sql.Driver");
            Connection con=DriverManager.getConnection(host, username, password);

            Statement stmt = con.createStatement( );

            String SQL = "SELECT * FROM memoryAll";

            ResultSet rs = stmt.executeQuery( SQL );

            int id_col;
            String f;
            /*
            rs.next();

            int id_col;
            String f;

            id_col = rs.getInt("memoryID");
            f = rs.getString("memoryName");
            System.out.println("id : "+id_col+" "+"name : "+f+"\n");
            */

            /*
            rs.next();

            id_col = rs.getInt("memoryID");
             f = rs.getString("memoryName");
            System.out.println("id : "+id_col+" "+"name : "+f);
            System.out.println("Connection successful");
            */
            DefaultTableModel model = (DefaultTableModel) p1.getModel();
            while(rs.next())
            {
            id_col = rs.getInt("memoryID");
            f = rs.getString("memoryName");
            //System.out.println("id : "+id_col+" "+"name : "+f);
            model.addRow(new Object[]{id_col,f});
            }
            rs.close();
            stmt.close();
            con.close();
            /*
            Statement st = conn.createStatement();
            String query = "SELECT * FROM NBUSER.MEMORYALL;";
            ResultSet rs = st.executeQuery(query);
            System.out.println(rs);

            while(rs.next())
            {
                String d1=rs.getString("memoryID");
                String d2=rs.getString("memoryName");
                //model.addRow(new Object[]{d1,d2});
            }

            rs.close();
            st.close();
            conn.close();
*/
        }
        catch(SQLException k)
        {
            JOptionPane.showMessageDialog(this,"Error in connectivity");
        }
    }

    public static void main(String args[])
    {
        java.awt.EventQueue.invokeLater
        (
                new Runnable()
                {
                    public void run()
                    {
                        new DBConnect().setVisible(true);
                    }
                }
        );
    }

    // Variables declaration - do not modify
    private javax.swing.JButton jButton2;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JTable p1;
    // End of variables declaration
}