java - Select query using Prepared Statement -

java - Select query using Prepared Statement -

i not know wrong in code. next conditions in code given below:

i come in client id in jtextfield after entering client id in database search relative info of client id (customer_id,customer_name,customer_contact). after collecting relative info of particular client id, display on jtextfield.

these code given below:

import java.awt.container; import java.awt.event.actionevent; import java.awt.event.actionlistener; import java.sql.*; import javax.swing.*; public abstract class customer_details extends jframe implements actionlistener { jtextfield textfieldid; jtextfield textfieldid1; jtextfield textfieldid2; jtextfield textfieldid3; jlabel l1; jlabel l2; jlabel l3; jlabel l4; jlabel l5; jbutton b1,b2; container c = getcontentpane(); customer_details() { super("shree datta digambar"); setbounds(140,250,777,555); c.setlayout(null); textfieldid = new jtextfield(); textfieldid1 = new jtextfield(); textfieldid2 = new jtextfield(); textfieldid3 = new jtextfield(); this.setextendedstate(jframe.maximized_both); l1 = new jlabel("update client details:-"); l2 = new jlabel("customer id"); l3 = new jlabel("customer id"); l4 = new jlabel("name"); l5 = new jlabel("contact"); l1.setbounds(10,10,340,20); l2.setbounds(10,20,140,70); l3.setbounds(10,100,140,70); l4.setbounds(100,100,140,70); l5.setbounds(270,100,140,70); textfieldid.setbounds(10,70,70,20); textfieldid1.setbounds(10,160,70,20); textfieldid2.setbounds(100,160,150,20); textfieldid3.setbounds(270,160,90,20); b1 = new jbutton("ok"); b1.setbounds(100,70,50,20); b2 = new jbutton("update"); b2.setbounds(380,160,90,20); c.add(b1); c.add(b2); c.add(l1); c.add(l2); c.add(l3); c.add(l4); c.add(l5); c.add(textfieldid); c.add(textfieldid1); c.add(textfieldid2); c.add(textfieldid3); setvisible(true); setdefaultcloseoperation(exit_on_close); b1.addactionlistener(this); b2.addactionlistener(this); } public static void main(string[] args) { customer_details eeap=new customer_details() {}; } public void actionperformed(actionevent e) { system.out.println("you clicked button"); if(e.getsource()==b1) { seek { connection con; con = drivermanager.getconnection("jdbc:odbc:dalvi"); java.sql.statement st = con.createstatement(); preparedstatement ps = con.preparestatement("select customer_id,customer_name,customer_contact customer_details customer_id = ?"); ps.setstring(1,textfieldid.gettext()); resultset rs1=ps.executequery(); while(rs1.next()) { textfieldid1.settext(rs1.getstring(1)); textfieldid2.settext(rs1.getstring(2)); textfieldid3.settext(rs1.getstring(3)); } textfieldid.settext(""); } grab (sqlexception s) { system.out.println("sql code not execute."); joptionpane.showmessagedialog(null,"please come in detail correctly"); } } }

}

take @ query (formatting added improve readability, inconsequential issue):

select customer_id,customer_name,customer_contact customer_details customer_id = ' ?'

by surrounding ? single quotes ('), you've turned in sql character literal. way, jdbc not recognize special character, , cannot bind it. if remove them, jdbc able bind (and take care of datatypes too):

select customer_id,customer_name,customer_contact customer_details customer_id = ?

java sql jdbc