Netbeans + Access Help

[Era.123]

Machnzla..... mata podiiii help ekak ona.. mage assgiment ekekaata java Netbeans walin application 1k karanwa..... eke database eka connect wennne access walin....
mata e database eke data add & delete aulka na... but machanzlaa UPDATE & SEARCH buttons wla hari coding ekak na.... danna pinwathek innawanm podii help 1k denna.....loku udawwak...@!

 

[chrishanelloyd]

access valata enne sql codings mada bn..

 

[Era.123]

access valata enne sql codings mada bn..

naaaa ban wenas

 

[tlhewage]

bump.. SQL ,Hibranate witarai ban danne

 

[mr90486]

Found some videos. May be useful for your purpose. I don't do java so I am not sure about this but though it would be useful.

https://www.youtube.com/watch?v=sqXtWlzwKM4
http://tune.pk/video/3111519/java-netbeans-and-ms-access-tut6-sql-update-statementavi

 

[Error365!]

Machan mama access walin java connect karala nam naha. But mama hithanne mysql quary wada karai. Poddak quary eka change karanda try karapan.

UPDATE:
Update column_name from db_name where column_name = 'column_value'

DELETE:
Delete from db_name where column_name = 'column_value'

Machan mewa mysql quary access walata wada karaida danne naha. Hoyanda vidihak naha mama reply kare phone eken ban. Try ekak dapan
. Harigiye naththam google search ekak dapan

 

[Era.123]

Found some videos. May be useful for your purpose. I don't do java so I am not sure about this but though it would be useful.

https://www.youtube.com/watch?v=sqXtWlzwKM4
http://tune.pk/video/3111519/java-netbeans-and-ms-access-tut6-sql-update-statementavi

thnkz budddy..... try 1k dennam meka balala...!!

Machan mama access walin java connect karala nam naha. But mama hithanne mysql quary wada karai. Poddak quary eka change karanda try karapan.


UPDATE:
Update column_name from db_name where column_name = 'column_value'

DELETE:
Delete from db_name where column_name = 'column_value'

Machan mewa mysql quary access walata wada karaida danne naha. Hoyanda vidihak naha mama reply kare phone eken ban. Try ekak dapan
. Harigiye naththam google search ekak dapan

google search kara ban.... hariyana ekak set unema naa..... sql coode eka run wenne na ban.... apahu try 1k dila balannam thsnkz machooo

 

[Dhananja4medialab]

Code

Connection conn =null;
ResultSet rs=null;
PreparedStatement pst =null;

Update Code-----------------------------

 try {
            String value1 =name1TextField1.getText();
            String value2 =name2jTextField2.getText();
            String value3 =name3TextField3.getText();
            
        String sql="update item set name1='"+value2+"',name2='"+value3+"',name3='"+value4+"'";
        pst=conn.prepareStatement(sql);
        pst.execute();
        JOptionPane.showMessageDialog(null, "Updated");
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, e);
        }


Search code -------------------------

        try {
            String sql="select * from item where name1=?";
            pst=conn.prepareStatement(sql);
            pst.setString(1,SearchTextField1.getText());
            rs=pst.executeQuery();
            if(rs.next()){
         String add1 =rs.getString("name1");
         name1TextField1.setText(add1);
        
            }
             
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, "e");
        }

machz mama statement 3 kahadal thieynne...ita amtharawa name1,name2,name3 tiyanne column name machz