**Connectivity is not getting done in this program plz check it out wat is the problem with that Although i've made tables in MA-ACCESS**

Ads

 
 
 

Share on Google+Share on Google+

swati shriwastav
**Connectivity is not getting done in this program plz check it out wat is the problem with that Although i've made tables in MA-ACCESS**
1 Answer(s)      6 years and a month ago
Posted in : JDBC
<p>import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.JPopupMenu;
import com.sun.java.swing.plaf.motif.MotifLookAndFeel;</p>

<p>public class ProjectLibrary extends JFrame implements ActionListener
{
    JTextField id,phno,name,add,city,padd,eadd,class1,shift,progress,date;
    JTextField bookTF,authorTF,priceTF,bcodeTF;
    JTextField cdcodeTF,cdtitleTF,cdisbnTF,cdeditionTF,cdpubTF;
    Container c;
    JButton search,save,delete,exit,update;
    JButton searBook,saveNow,update1;
    JButton cdsearch,cdsave,cddelete,cdexit,cdupdate;
    JLabel cdlogo,cdcode,cdtitle,cdisbn,cdedit,cdpub;
    JOptionPane jp = new JOptionPane();
    JMenuBar menuBar,menuBar1; <br />
    JMenu menu1,menu2; 
    JMenuItem menuItemN,menuItemB,menuItemC,menuItemH,menuItemA,menuItemE;
    Cursor cur;</p>

<pre class="prettyprint">public ProjectLibrary()
{
    super("Library Record System");
    c = getContentPane(); c.setBackground(new Color(128,26,136));
    c.setLayout(null); 
    setBounds(0,0,850,590);
    setFont(new Font("verdana",3,14));
    cur = new Cursor(Cursor.CROSSHAIR_CURSOR);
    setCursor(cur);
    ImageIcon coll = new ImageIcon("collicon.gif");
    JLabel LogoColl = new JLabel(coll);
    menuBar = new JMenuBar();   
    menu1 = new JMenu("Library");   
    menu1.setBackground(Color.white);
    menu1.setMnemonic('L');
    menu2 = new JMenu("Help");  
    menu2.setMnemonic('H'); 
    menu2.setBackground(Color.white);
    //menu1.setMnemonic(KeyEvent.VK_D);

    menuItemN = new JMenuItem("New",new ImageIcon("NEW.GIF")); menuItemN.setBackground(Color.white);
    menuItemN.setMnemonic('N');
            menuItemB = new JMenuItem("Books",new ImageIcon("b.gif"));  
    menuItemB.setBackground(Color.white);
            menuItemB.setMnemonic('B');
    menuItemC = new JMenuItem("CD's",new ImageIcon("cd.PNG"));
    menuItemC.setBackground(Color.white);
    menuItemC.setMnemonic('C');
    menuItemE = new JMenuItem("Exit",new ImageIcon("Exit.PNG")); 
    menuItemE.setBackground(Color.white);
    menuItemE.setMnemonic('E');
    menuItemH = new JMenuItem("Help library",new ImageIcon("help.gif")); 
    menuItemH.setBackground(Color.white);
    menuItemH.setMnemonic('E');
    menuItemA = new JMenuItem("About LRS");
    setJMenuBar(menuBar);

    JLabel lDate = new JLabel("Issue Of Date :");  
    lDate.setForeground(Color.white);
    JLabel ph = new JLabel("Enter Phone Number :"); 
    ph.setForeground(Color.white);
    JLabel lname = new JLabel("Student's Name :"); 
    lname.setForeground(Color.white);
    JLabel address = new JLabel("Student's Address :"); 
    address.setForeground(Color.white);
    JLabel lid = new JLabel("Book Code"); 
    lid.setForeground(Color.white);
    JLabel lcity = new JLabel("City"); 
    lcity.setForeground(Color.white);
    JLabel pad = new JLabel("Permenent Address"); 
    pad.setForeground(Color.white);
    JLabel leadd = new JLabel("Email Address"); 
    leadd.setForeground(Color.white);
    JLabel lclass = new JLabel("Class"); 
    lclass.setForeground(Color.white);
    JLabel lshift = new JLabel("Shift"); 
    lshift.setForeground(Color.white);
    JLabel lprogress = new JLabel("Progress"); 
    lprogress.setForeground(Color.white);
    ImageIcon next = new ImageIcon("next.gif");
    JLabel next1 = new JLabel(next);
    ImageIcon previous = new ImageIcon("Back.gif");
    JLabel previous1 = new JLabel(previous);
    ImageIcon background = new ImageIcon("backg.jpg");
    JLabel img = new JLabel(background);
    ImageIcon college = new ImageIcon("GNIT.jpg");
    JLabel colLogo = new JLabel(college);
    ImageIcon LineStraight = new ImageIcon("lineh.gif");
    JLabel Line = new JLabel(LineStraight);
    date = new JTextField(); 
    date.setForeground(Color.black); 
    date.setBackground(Color.white);
    phno = new JTextField(); 
    phno.setForeground(Color.black); 
    phno.setBackground(Color.white);
    name = new JTextField(); 
    name.setForeground(Color.black); 
    name.setBackground(Color.white);
    add = new JTextField();  
    add.setForeground(Color.black); 
    add.setBackground(Color.white);
    eadd = new JTextField();
    eadd.setForeground(Color.black); 
    eadd.setBackground(Color.white);
    city = new JTextField();        
    city.setForeground(Color.black); 
    city.setBackground(Color.white);
    padd = new JTextField();         
    padd.setForeground(Color.black);  
    padd.setBackground(Color.white);
    id = new JTextField();      
    id.setForeground(Color.black); 
    id.setBackground(Color.white);
    class1 = new JTextField();      
    class1.setForeground(Color.black); 
    class1.setBackground(Color.white);
                   shift = new JTextField();         
    shift.setForeground(Color.black); 
    shift.setBackground(Color.white);
    progress = new JTextField();    
    progress.setForeground(Color.black);  
    progress.setBackground(Color.white);
    search = new JButton("Search",new ImageIcon("search.gif"));  
    search.setForeground(Color.white); 
    search.setBackground(Color.pink);
            save = new JButton("Save", new ImageIcon("Save.gif")); 
    save.setForeground(Color.white); 
    save.setBackground(Color.pink);
            delete = new JButton("Delete", new ImageIcon("remove.gif"));    
    delete.setForeground(Color.white); 
    delete.setBackground(Color.pink);
            exit = new JButton("Exit", new ImageIcon("EXIT.PNG"));  
    exit.setForeground(Color.white); 
    exit.setBackground(Color.pink);
            update = new JButton("Update", new ImageIcon("update.gif")); 
    update.setForeground(Color.white); 
    update.setBackground(Color.pink);
    search.setToolTipText("Search the record"); 
    save.setToolTipText("Save the record"); 
    delete.setToolTipText("Delete the record"); 
    exit.setToolTipText("Exit from the library");   
    update.setToolTipText("Update the record"); 
    lDate.setBounds(80,135,670,150);
    LogoColl.setBounds(380,20,670,150);
    lid.setBounds(80,240,150,20);
    ph.setBounds(400,245,150,20);
    lname.setBounds(80,285,150,20);
    address.setBounds(400,290,150,20);
    lcity.setBounds(400,330,150,20);
    pad.setBounds(400,375,150,20);
    leadd.setBounds(400,415,150,20);
    lclass.setBounds(80,330,150,20);
    lshift.setBounds(80,380,150,20);
    lprogress.setBounds(80,415,150,20);
    next1.setBounds(650,478,180,54);
    previous1.setBounds(10,478,190,54);
    img.setBounds(90,100,20,40);
    colLogo.setBounds(3,0,790,142);
    Line.setBounds(2,2,48,1000);
    date.setBounds(220,190,152,26);
    id.setBounds(220,235,152,26);
    phno.setBounds(550,245,152,26);
    name.setBounds(220,280,152,26);
    add.setBounds(550,290,152,26);
            city.setBounds(550,330,152,26);
    padd.setBounds(550,370,152,26);
    eadd.setBounds(550,410,152,26);
    class1.setBounds(220,325,152,26);
    shift.setBounds(220,370,152,26);
    progress.setBounds(220,415,152,26);
    search.setBounds(160,490,105,30);
    save.setBounds(270,490,90,30);
    delete.setBounds(363,490,95,30);
    update.setBounds(460,490,110,30);
    exit.setBounds(575,490,95,30);
    menu1.add(menuItemN);
    menu1.add(menuItemB);
    menu1.add(menuItemC);
    menu1.add(menuItemE);
    menuBar.add(menu1);
    menu2.add(menuItemH);
    menu2.add(menuItemA);
    menuBar.add(menu2);
    save.addActionListener(this);
    search.addActionListener(this);
            delete.addActionListener(this);
    update.addActionListener(this);
    exit.addActionListener(this);
    menuItemN.addActionListener(this);
    menuItemB.addActionListener(this);
    menuItemC.addActionListener(this);
    menuItemH.addActionListener(this);
    menuItemA.addActionListener(this);
    menuItemE.addActionListener(this);
    c.add(search);
    c.add(save );
    c.add(delete);
    c.add(exit);
    c.add(update);
    c.add(LogoColl);
    c.add(lDate);
    c.add(ph);
    c.add(lname);
    c.add(address);
    c.add(lid);
    c.add(lcity);
    c.add(pad);
    c.add(leadd);
    c.add(lclass);
    c.add(lshift);
    c.add(lprogress);
    c.add(next1);
    c.add(previous1);
    c.add(img);
    c.add(colLogo); 
    c.add(date);
    c.add(phno);
    c.add(name);
    c.add(add);
    c.add(city);
    c.add(padd);
    c.add(id);
    c.add(eadd);
    c.add(class1);
    c.add(progress);
    c.add(shift);
    c.add(Line);
</code></pre>

<p>next1.addMouseListener(new MouseAdapter()
        {
        public void mousePressed(MouseEvent me)
        {
            int a = Integer.parseInt(id.getText());
            a++;
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection c = DriverManager.getConnection("jdbc:odbc:Student");
                Statement st = c.createStatement();</p>

<pre class="prettyprint">            ResultSet rs = st.executeQuery("select * from Directory where Id="+a);
                         while(rs.next())
            {       
                date.setText(rs.getString("DateToday"));
                id.setText(rs.getString("Id"));
                name.setText(rs.getString("Name"));
                add.setText(rs.getString("Address"));
                class1.setText(rs.getString("Class"));
                progress.setText(rs.getString("Progress"));
                shift.setText(rs.getString("Shift"));
                city.setText(rs.getString("City"));
                padd.setText(rs.getString("Permenent_Address"));
                phno.setText(rs.getString("PhoneNo"));
                eadd.setText(rs.getString("address"));

          }
            c.close();
            st.close();
     }
    catch(ClassNotFoundException cnf)
    {
            System.out.println("Cnf Exception");
    }
    catch(SQLException sql)
    {
        System.out.println(sql);
    }

}
     });
previous1.addMouseListener(new MouseAdapter()
    {
    public void mousePressed(MouseEvent me)
    {
            int a = Integer.parseInt(id.getText());
            a--;
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection c = DriverManager.getConnection("jdbc:odbc:Student");
                Statement st = c.createStatement();
                ResultSet rs = st.executeQuery("select * from Directory where Id="+a);

                                while(rs.next())
                {       date.setText(rs.getString("DateToday"));
                    id.setText(rs.getString("Id"));
                    name.setText(rs.getString("Name"));
                    add.setText(rs.getString("Address"));
                    class1.setText(rs.getString("Class"));
                    progress.setText(rs.getString("Progress"));
                    shift.setText(rs.getString("Shift"));
                    city.setText(rs.getString("City"));
                    padd.setText(rs.getString("Permenent_Address"));
                    phno.setText(rs.getString("PhoneNo"));
                    eadd.setText(rs.getString("address"));

                  }
                  c.close();
                  st.close();
            }
            catch(ClassNotFoundException cnf)
            {
                System.out.println("Cnf Exception");
            }
            catch(SQLException sql)
            {
                System.out.println(sql);
            }


        }
});
    setDefaultCloseOperation(EXIT_ON_CLOSE);
    setVisible(true);
}

public void actionPerformed(ActionEvent ae)
{   
    String str1=(String)ae.getActionCommand();
    Object source = ae.getSource();
    if(source==menuItemA)
    {
        JFrame aboutus = new JFrame("About us");
        aboutus.setSize(700,500);
        aboutus.getContentPane().setLayout(null);
        ImageIcon design = new ImageIcon("about.jpg");
        JLabel cover = new JLabel(design);
        aboutus.getContentPane().add(cover);
        cover.setBounds(5,0,685,500);
        aboutus.setVisible(true);
    }
    if(source==menuItemN)   
    {
        id.setEditable(true);
        phno.setEditable(true);
        name.setEditable(true);
        add.setEditable(true);
        city.setEditable(true);
        padd.setEditable(true);
        eadd.setEditable(true);
        class1.setEditable(true);
        shift.setEditable(true);
        progress.setEditable(true);
        date.setEditable(true);

        id.setText(null);
        phno.setText(null);
        name.setText(null);
        add.setText(null);
        city.setText(null);
        padd.setText(null);
        eadd.setText(null);
        class1.setText(null);
        shift.setText(null);
        progress.setText(null);
        date.setText(null);

    }
    if(source==menuItemB)
    {
            JFrame book=new JFrame("Book's available in library");
            book.setSize(660,560);
            book.getContentPane().setLayout(null);
            book.getContentPane().setBackground(new Color(14,58,119));
            book.getContentPane().setForeground(Color.white);
            book.setResizable(false);
            JLabel BookName = new JLabel("Book Name:");
            book.getContentPane().add(BookName);
            JLabel AuthorName = new JLabel("Author Name:");
            book.getContentPane().add(AuthorName);
            JLabel Pri = new JLabel("Price:");
            book.getContentPane().add(Pri);
            JLabel Bcode = new JLabel("Book Code:");
            book.getContentPane().add(Bcode);
            bookTF = new JTextField(10);
            book.getContentPane().add(bookTF);
            authorTF = new JTextField(10);
            book.getContentPane().add(authorTF);
            priceTF = new JTextField(5);     
            book.getContentPane().add(priceTF);
            bcodeTF = new JTextField(5);
            book.getContentPane().add(bcodeTF);

            ImageIcon logobook = new ImageIcon("logoBook.jpg");
            JLabel logoBook = new JLabel(logobook);  
            book.getContentPane().add(logoBook);

            searBook = new JButton("Search", new ImageIcon("SEARCH.PNG"));
            book.getContentPane().add(searBook);

            saveNow = new JButton("Save", new ImageIcon("SAVE.PNG"));
            book.getContentPane().add(saveNow);

            update1 = new JButton("Update", new ImageIcon("UPDATE.PNG"));
            book.getContentPane().add(update1);


            logoBook.setBounds(0,0,650,171);
            Bcode.setBounds(33,200,112,30);
            BookName.setBounds(33,250,112,30);
            AuthorName.setBounds(30,310,112,30);
            Pri.setBounds(31,370,112,30);

            bcodeTF.setBounds(123,200,100,20);
            bookTF.setBounds(123,255,262,20);
            authorTF.setBounds(123,315,262,20);
            priceTF.setBounds(123,375,100,20);
            saveNow.setBounds(280,500,111,30);
            update1.setBounds(400,500,111,30);
            searBook.setBounds(160,500,111,30);
            saveNow.addActionListener(this);
            update1.addActionListener(this);
            searBook.addActionListener(this);

            book.setVisible(true);  
        }
        if(source==menuItemE)
        {
            System.exit(0);
            jp = new JOptionPane();
        }           
        if(source==saveNow)
        {
            try
            {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection c = DriverManager.getConnection("jdbc:odbc:Student");
                Statement st = c.createStatement();

                PreparedStatement ps = c.prepareStatement("Insert into Book values(?,?,?,?)");
                ps.setString(1,bcodeTF.getText());
                ps.setString(2,bookTF.getText());
                ps.setString(3,authorTF.getText());
                ps.setString(4,priceTF.getText());

                        ps.executeUpdate();
                        jp.showMessageDialog(this,"Record Inserted Successfully","SUCCESS",jp.INFORMATION_MESSAGE);

            c.close();
            st.close();
            }
            catch(ClassNotFoundException cnf)
            {System.out.println("Cnf Exception");}
            catch(SQLException sql)
            {jp.showMessageDialog(this,"Record Already Exists","EXCEPTION",jp.ERROR_MESSAGE);}
        }
            if(source==update1)
        {
                    try
                       {        
                  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection c = DriverManager.getConnection("jdbc:odbc:Student");
                    Statement st = c.createStatement();

            PreparedStatement ps=c.prepareStatement ("Update Book set BookName=? , AuthorName=? , Price=? where BookCode="+bcodeTF.getText() ); 

                ps.setString(1,bookTF.getText());       
                ps.setString(2,authorTF.getText());
                ps.setInt(3,Integer.parseInt(priceTF.getText()));
                ps.executeUpdate();
            jp.showMessageDialog(this,"Record Updated Successfully","SUCCESS",jp.INFORMATION_MESSAGE);
            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {System.out.println("Cnf Exception");}
        catch(SQLException sql)
        {jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);}
    }    
            if(source==menuItemC)
        {   
            JFrame cd=new JFrame("CD's available in library");
            cd.setSize(510,540);    
            cd.getContentPane().setLayout(null);
            cd.getContentPane().setBackground(new Color(0,55,0));
            cd.getContentPane().setLayout(null);
            cd.setResizable(false);

            ImageIcon backg = new ImageIcon("CDLABEL.PNG");
            JLabel cdlogo = new JLabel(backg);
            cd.getContentPane().add(cdlogo);  

            cdcode = new JLabel("CD Code:"); 
            cdcode.setForeground(Color.white);
            cdtitle = new JLabel("Title:"); 
            cdtitle.setForeground(Color.white);
            cdisbn = new JLabel("ISBN NO:"); 
            cdisbn .setForeground(Color.white);     
            cdedit = new JLabel("Edition:");    
            cdedit .setForeground(Color.white);
            cdpub = new JLabel("Publication:");
            cdpub .setForeground(Color.white);
            cdcodeTF = new JTextField();
            cdtitleTF = new JTextField();
            cdisbnTF = new JTextField();
            cdeditionTF = new JTextField();
            cdpubTF = new JTextField();

            cdsearch = new JButton("Search" , new ImageIcon("SEARCH.PNG"));
            cdsave = new JButton("Save", new ImageIcon("SAVE.PNG"));
            cddelete = new JButton("Delete", new ImageIcon("DELETE.PNG"));
            cdupdate = new JButton("Update", new ImageIcon("UPDATE.PNG"));
            cdexit = new JButton("Exit", new ImageIcon("EXIT.PNG"));
            cd.getContentPane().add(cdcode);
            cd.getContentPane().add(cdtitle);
            cd.getContentPane().add(cdisbn);
            cd.getContentPane().add(cdedit);
            cd.getContentPane().add(cdpub);
            cd.getContentPane().add(cdcodeTF);
            cd.getContentPane().add(cdtitleTF);
            cd.getContentPane().add(cdisbnTF);
            cd.getContentPane().add(cdeditionTF);
            cd.getContentPane().add(cdpubTF);
            cd.getContentPane().add(cdsearch);
            cd.getContentPane().add(cdsave);
            cd.getContentPane().add(cddelete);
            cd.getContentPane().add(cdupdate);
            cd.getContentPane().add(cdexit);
            cdlogo.setBounds(1,0,500,100);
            cdcode.setBounds(50,120,210,25);
            cdtitle.setBounds(50,160,210,25);
            cdisbn.setBounds(50,200,210,25);
            cdedit.setBounds(50,240,210,25);
            cdpub.setBounds(50,280,210,25);
            cdcodeTF.setBounds(150,120,210,25);
            cdtitleTF.setBounds(150,160,210,25);
            cdisbnTF.setBounds(150,200,210,25);
            cdeditionTF.setBounds(150,240,210,25);
            cdpubTF.setBounds(150,280,210,25);
            cdsearch.setBounds(0,420,98,25);
            cdsave.setBounds(100,420,98,25);
            cddelete.setBounds(200,420,98,25);
            cdupdate.setBounds(300,420,98,25);
            cdexit.setBounds(400,420,98,25);
            cdsearch.addActionListener(this);   
            cdsave.addActionListener(this);
            cddelete.addActionListener(this);
            cdexit.addActionListener(this);
            cdupdate.addActionListener(this);
            cd.setVisible(true);
        }

        if(source==cdsearch)
        {
            try
            {

                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    Connection c = DriverManager.getConnection("jdbc:odbc:Student");
                                    Statement st = c.createStatement();
                ResultSet rs = st.executeQuery("select * from CD  where CdCode="+cdcodeTF.getText());
                   while(rs.next())
                    {   
                        cdtitleTF.setText(rs.getString("Title"));
                        cdisbnTF.setText(rs.getString("IsbnNO"));
                            cdeditionTF.setText(rs.getString("Edition"));
                        cdpubTF.setText(rs.getString("Publication"));

                    }
                        c.close();
                        st.close();
              }
              catch(ClassNotFoundException cnf)
              {
                jp.showMessageDialog(this,cnf,"EXCEPTION",jp.ERROR_MESSAGE);
                System.out.println("Cnf Exception");
               }
            catch(SQLException sql)
            {
                    jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);
              }

        }

        if(source==cdsave)
        {
            try
            {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
            PreparedStatement ps  = c.prepareStatement("Insert into CD values(?,?,?,?,?)");

                ps.setString(1,cdcodeTF.getText());
                ps.setString(2,cdtitleTF.getText());
                ps.setString(3,cdisbnTF.getText());
                ps.setString(4,cdeditionTF.getText());
                ps.setString(5,cdpubTF.getText());
                ps.executeUpdate();
    jp.showMessageDialog(this,"Record Inserted Successfully","SUCCESS",jp.INFORMATION_MESSAGE);

            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,"Record Already Exists","EXCEPTION",jp.ERROR_MESSAGE);
        }

    }               

    if(source==cddelete)
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
            PreparedStatement ps=c.prepareStatement("Delete from CD where CdCode="+cdcodeTF.getText());
            ps.executeUpdate();
            jp.showMessageDialog(this,"Record Deleted Successfully","SUCCESS",jp.INFORMATION_MESSAGE);
            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);

        }

    }
    if(source==cdupdate)
    {
        try
              {

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
        PreparedStatement ps=c.prepareStatement ("Update CD set Title=?, IsbnNO=?, Edition=?, Publication=?  where CdCode="+cdcodeTF.getText());

                ps.setString(1,cdtitleTF.getText());        
                ps.setString(2,cdisbnTF.getText());
                ps.setString(3,cdeditionTF.getText());
                ps.setString(4,cdpubTF.getText());
                ps.executeUpdate();
            jp.showMessageDialog(this,"Record Updated Successfully","SUCCESS",jp.INFORMATION_MESSAGE);
            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);
        }

    }
    if(source==cdexit)
    {
        System.exit(0);
    }
    if(source==menuItemH)
    {
            JFrame help=new JFrame("Help ?");
            help.setSize(800,730);  
            help.getContentPane().setBackground(new Color(14,58,119));
            help.getContentPane().setLayout(null);
            help.setResizable(false);
            ImageIcon hl = new ImageIcon("helpLib.png");
            JLabel logoCD = new JLabel(hl);
            help.getContentPane().add(logoCD);  
            logoCD.setBounds(0,0,800,540);
            help.setVisible(true);
    }
    if(source==searBook)
    {           
                            try
        {

        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
               Statement st = c.createStatement();
               ResultSet rs = st.executeQuery("select * from Book where BookCode="+bcodeTF.getText());
               while(rs.next())
                {   
                bookTF.setText(rs.getString("BookName"));   
                    authorTF.setText(rs.getString("AuthorName"));
                priceTF.setText(rs.getString("Price"));
                    /*add.setText(rs.getString("Address"));
                class1.setText(rs.getString("Class"));
                progress.setText(rs.getString("Progress"));
                phno.setText(rs.getString("PhoneNo"));
                shift.setText(rs.getString("Shift"));
                city.setText(rs.getString("City"));
                padd.setText(rs.getString("Permenent_Address"));
                eadd.setText(rs.getString("eaddress"));*/

                }
                c.close();
                st.close();
      }
      catch(ClassNotFoundException cnf)
      {
        jp.showMessageDialog(this,cnf,"EXCEPTION",jp.ERROR_MESSAGE);
        System.out.println("Cnf Exception");
    }
    catch(SQLException sql)
      {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);
      }

  }

    if(str1.equals("Search"))
    {
        try
        {
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection c = DriverManager.getConnection("jdbc:odbc:Student");
           Statement st = c.createStatement();
           ResultSet rs = st.executeQuery("select * from Directory where Id="+id.getText());

           while(rs.next())
           {           date.setText(rs.getString("DateToday")); 
                    id.setText(rs.getString("Id"));
                name.setText(rs.getString("Name"));
                    add.setText(rs.getString("Address"));
                class1.setText(rs.getString("Class"));
                progress.setText(rs.getString("Progress"));
                phno.setText(rs.getString("PhoneNo"));
                shift.setText(rs.getString("Shift"));
                city.setText(rs.getString("City"));
                padd.setText(rs.getString("Permenent_Address"));
                eadd.setText(rs.getString("eaddress"));

          }
                c.close();
                st.close();
      }
      catch(ClassNotFoundException cnf)
      {
            jp.showMessageDialog(this,cnf,"EXCEPTION",jp.ERROR_MESSAGE);
            System.out.println("Cnf Exception");
      }
      catch(SQLException sql)
      {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);
      }
  }

    if(str1.equals("Save"))
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
            PreparedStatement ps  = c.prepareStatement("Insert into Directory values(?,?,?,?,?,?,?,?,?,?,?)");

                ps.setString(1,date.getText());
                ps.setString(2,id.getText());
                ps.setString(3,name.getText());
                ps.setString(4,class1.getText());
                ps.setString(5,shift.getText());
                ps.setString(6,progress.getText());
                ps.setString(7,add.getText());
                ps.setString(8,city.getText());
                ps.setString(9,padd.getText());
                ps.setString(10,phno.getText());
                ps.setString(11,eadd.getText());
                                ps.executeUpdate();
    jp.showMessageDialog(this,"Record Inserted Successfully","SUCCESS",jp.INFORMATION_MESSAGE);

            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,"Record Already Exists","EXCEPTION",jp.ERROR_MESSAGE);
        }
    }
    if(str1.equals("Delete"))
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
            PreparedStatement ps=c.prepareStatement("Delete from Directory where Id="+id.getText());
            ps.executeUpdate();
            jp.showMessageDialog(this,"Record Deleted Successfully","SUCCESS",jp.INFORMATION_MESSAGE);
            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);

        }
    }
    if(str1.equals("Update"))
    {
          try
          {

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection c = DriverManager.getConnection("jdbc:odbc:Student");
            Statement st = c.createStatement();
    PreparedStatement ps=c.prepareStatement ("Update Directory set  Date=?,Name=?,Class=?,Shift=?,Progress=?,Address=?,City=?,Permenent_Address=?,PhoneNo=?,eaddress=?  where Id="+id.getText());
    //PreparedStatement ps=c.prepareStatement ("Update Directory set Name=?, Class=?, Shift=?, Progress=?, Address=?, City=?, Permenent_Address=?, PhoneNo=?, eaddress=?, DateToday=? where Id="+id.getText());

                ps.setString(1,name.getText());     
                ps.setString(2,class1.getText());
                ps.setString(3,shift.getText());
                ps.setString(4,progress.getText());
                ps.setString(5,add.getText());
                ps.setString(6,city.getText());
                ps.setString(7,padd.getText());
                ps.setString(8,phno.getText());
                ps.setString(9,eadd.getText());
                ps.setString(10,date.getText());
                ps.executeUpdate();
            jp.showMessageDialog(this,"Record Updated Successfully","SUCCESS",jp.INFORMATION_MESSAGE);
            c.close();
            st.close();
         }
        catch(ClassNotFoundException cnf)
        {
            System.out.println("Cnf Exception");
        }
        catch(SQLException sql)
        {
            jp.showMessageDialog(this,sql,"EXCEPTION",jp.ERROR_MESSAGE);
        }
    }
    if(str1.equals("Exit"))
    {
        System.exit(0);
    }
  }

public static void main(String arg[])
{
     ProjectLibrary p4 = new ProjectLibrary();
     p4.setResizable(false);

 }
</code></pre>

<p>}</p>
Ads
View Answers

April 6, 2011 at 12:46 PM


Follow these steps:

1)Go to the start->Control Panel->Administrative Tools-> data sources.

2)Click Add button and select the driver Microsoft Access Driver(*.mdb).

3)After selecting the driver, click finish button.

4)Then give Data Source Name and click ok button.

5)Your DSN will get created.

6) Restart your command prompt and then compile the given code.

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.event.*;
class  Retrieve{
public static void main(String[] args){
    JFrame f=new JFrame();
    JLabel label1=new JLabel("Name: ");
    JLabel label2=new JLabel("Address: ");
    JTextField text1=new JTextField(20);
    JTextField text2=new JTextField(20);
    try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection("jdbc:odbc:student");
           Statement st=con.createStatement();
           ResultSet rs=st.executeQuery("select * from data where id=1");
           String name="",address="";
           if(rs.next()){
               name=rs.getString("name");
               address=rs.getString("address");
           }
           text1.setText(name);
           text2.setText(address);
        }
        catch(Exception e){
        }
        JPanel p=new JPanel(new GridLayout(2,2));
        p.add(label1);
        p.add(text1);
        p.add(label2);
        p.add(text2);
        f.add(p);
        f.setVisible(true);
        f.pack();
    }
}

Here student is our dsn.


Ads









Related Tutorials/Questions & Answers:
Tutorials   
Java Spring Hibernate Struts Training java.lang.classnotfoundexception com.mysql.jdbc.driver how to retrieve text and images from mysql database and show on html page using jsp servlet How to install Neo4j on Ubuntu 15.10? please help me in these prog MYSQL - mysql copy table to another table example by creating new table solution for mapping hibernate and pojos from net beans through database Connect GWT application with Oracle inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store inventory System of Medical Store This code have created jTable that connected with a database.every cell of last column have a button.But this button doesn't work properly.Where is the error java program Java Database Program jdbc Database connection class in a live project ..?? What is JDBC architecture? Unable to Create DSN for excel to ms access importing data and edit that data Database Scrolling Buttons how to use foreign key in java How to delete content of a log file from linux terminal? JSP-Oracle connectivity Student Management System Java code for Saving Marathi (Indian local language ) in Mysql and retrieving the same crud operations with foreign key constraint. I really need help with this assignment question Please help me out Please Backup Failed Mysqldump Got Errno 28 On Write Upgrade MySQL 5.1 to 5.5 in cpanel mysqldump all databases com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jpa.sequence' doesn't exist persistence xml class element persistence.xml for MySQL MySQL JDBC Driver pom dependency code Blob column jdk6 and oracle 8i connexion oracle 8i et jdk6 java [ cannot retrive date from sql ] why?? Order Entry System How to threow timeout exception when DB is not responding How to threow timeout exception when DB is not responding This is the employee form to add data to mysql database but I got error of NullPointerException, Is this write code please give me feedback as soon as possible make a method which takes user name & pwd as parameter & validate them against the database. If the corresponding user exist return true otherwise false. prabhakar validating credentials and displaying error message in login .jsp if not valid JDBC jdbc jdbc code register servlet vibhu

Ads

 
Advertisement null

Ads