Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- how to use prepared statement
- try
- {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- System.out.println("n Driver loaded");
- Connection con=DriverManager.getConnection("jdbc:odbc:wanisamajDB");
- Statement stmt=con.createStatement();
- System.out.println("statement is created");
- // System.out.println(Integer.parseInt(cbregn.getSelectedItem().toString()));
- String qry= " UPDATE Registration1 set RegistrationNo = '"+cbregn.getSelectedItem()+"',SeniorPerson = '"+cbnm.getSelectedItem()+"', NativePlace = '"+tfplace.getText()+"',Kul = '"+tfkul.getText()+"', Gotra = '"+tfgotra.getText()+"' ,KulSwami = '"+tfswami.getText()+"', ResidensialAddress = '"+taraddr.getText()+"' , PinCode = '"+tfpcd.getText()+"', STDcode = '"+tfstdcode.getText()+"',TelephoneNo = '"+tftele.getText()+"', MobileNo = '"+tfmno.getText()+"', Email = '"+tfemail.getText()+"',Website ='"+tfweb.getText()+"',Education ='"+tfedu.getText()+"',Branch ='"+tfbrch.getText()+"',BloodGroup ='"+cbbldgrp.getSelectedItem()+"' where SeniorPerson='" +cbnm.getSelectedItem().toString()+"'" ;
- // String qry= " UPDATE Registration1 set SeniorPerson = '"+cbnm.getSelectedItem().toString()+"',NativePlace = '"+tfplace.getText()+"', Kul = '"+tfkul.getText()+"',Gotra = '"+tfgotra.getText()+"' , KulSwami = '"+tfswami.getText()+"', ResidensialAddress = '"+taraddr.getText()+"' , PinCode = '"+Integer.parseInt(tfpcd.getText())+"', STDcode = '"+Integer.parseInt(tfstdcode.getText())+"',TelephoneNo = '"+Integer.parseInt(tftele.getText())+"',MobileNo = '"+Integer.parseInt(tfmno.getText())+"',Email = '"+tfemail.getText()+"',Website ='"+tfweb.getText()+"',Education ='"+tfedu.getText()+"',Branch ='"+tfbrch.getText()+"',BloodGroup ='"+cbbldgrp.getSelectedItem().toString()+"' where RegistrationNo='" +Integer.parseInt(cbregn.getSelectedItem().toString())+"'" ;
- stmt.executeUpdate(qry);
- JOptionPane.showMessageDialog(null,"RECORD IS UPDATED SUCCESSFULLY ");
- System.out.println("QURY");
- // cbregn.setEditable(false);
- cbnm.setEditable(false);
- tfplace.setEditable(false);
- tfkul.setEditable(false);
- tfgotra.setEditable(false);
- tfswami.setEditable(false);
- taraddr.setEditable(false);
- tfpcd.setEditable(false);
- tfstdcode.setEditable(false);
- tftele.setEditable(false);
- tfmno.setEditable(false);
- tfemail.setEditable(false);
- tfweb.setEditable(false);
- tfedu.setEditable(false);
- tfbrch.setEditable(false);
- cbbldgrp.setEditable(false);
- con.close();
- stmt.close();
- }
- // catch(SQLException eM)
- // {
- // JOptionPane.showMessageDialog(null,"RECORD IS NOT FOUND ");
- // }
- catch(Exception et)
- {
- et.printStackTrace();
- // System.out.println("error:"+et.getMessage());
- }
- String qry= " UPDATE Registration1 set RegistrationNo = '"+cbregn.getSelectedItem()+"',SeniorPerson = '"+cbnm.getSelectedItem()+"', NativePlace = '"+tfplace.getText()+"',Kul = '"+tfkul.getText()+"', Gotra = '"+tfgotra.getText()+"' ,KulSwami = '"+tfswami.getText()+"', ResidensialAddress = '"+taraddr.getText()+"' , PinCode = '"+tfpcd.getText()+"', STDcode = '"+tfstdcode.getText()+"',TelephoneNo = '"+tftele.getText()+"', MobileNo = '"+tfmno.getText()+"', Email = '"+tfemail.getText()+"',Website ='"+tfweb.getText()+"',Education ='"+tfedu.getText()+"',Branch ='"+tfbrch.getText()+"',BloodGroup ='"+cbbldgrp.getSelectedItem()+"' where SeniorPerson='" +cbnm.getSelectedItem().toString()+"'" ;
- stmt.executeUpdate(qry);
- String qry= " UPDATE Registration1 set RegistrationNo = ?,SeniorPerson = ?, NativePlace = ?,Kul = ?, Gotra = ?,KulSwami = ?, ResidensialAddress = ?, PinCode = ?, STDcode = ?,TelephoneNo = ?, MobileNo = ?, Email = ?,Website =?,Education =?,Branch =?,BloodGroup =? where SeniorPerson=?" ;
- PreparedStatement updateQry = con.prepareStatement(qry);
- updateQry.setString(1,cbregn.getSelectedItem());
- updateQry.setString(2,cbnm.getSelectedItem());
- updateQry.setString(3,tfplace.getText());
- updateQry.setString(4,tfkul.getText());
- updateQry.setString(5,tfgotra.getText());
- updateQry.setString(6,tfswami.getText());
- updateQry.setString(7,taraddr.getText());
- updateQry.setString(8,tfpcd.getText());
- updateQry.setString(9,tfstdcode.getText());
- updateQry.setString(10,tftele.getText());
- updateQry.setString(11,tfmno.getText());
- updateQry.setString(12,tfemail.getText());
- updateQry.setString(13,tfweb.getText());
- updateQry.setString(14,tfedu.getText());
- updateQry.setString(15,tfbrch.getText());
- updateQry.setString(16,cbbldgrp.getSelectedItem());
- updateQry.setString(17,cbnm.getSelectedItem().toString());
- updateQry.executeUpdate():
- public class UpdatesRecords{
- public static void main(String[] args) {
- System.out.println("Updates Records Example through Prepared Statement!");
- Connection con = null;
- try{
- Class.forName("com.mysql.jdbc.Driver");
- con = DriverManager.getConnection(
- "jdbc:mysql://localhost:3306/jdbctutorial","root","root");
- try{
- String sql = "UPDATE movies SET title = ? WHERE year_made = ?";
- PreparedStatement prest = con.prepareStatement(sql);
- prest.setString(1,"Sanam We wafafa");
- prest.setInt(2,2005);
- prest.executeUpdate();
- System.out.println("Updating Successfully!");
- con.close();
- }
- catch (SQLException s){
- System.out.println("SQL statement is not executed!");
- }
- }
- catch (Exception e){
- e.printStackTrace();
- }
- }
- }
Add Comment
Please, Sign In to add comment