problem

soni avbnb <[email protected]> Tue, 6 Mar 2007 18:14:13 +0000 (GMT)
Newsgroups gmane.comp.db.mysql.java
Message-ID <[email protected]>
hi.

I have got a problem.
how to write a code in jdbc with mysql ,for insertion,search for variable.
i.e ehen i write somthing like
String dep1=d.getText();
smnt.executequery("select e.name ,e.salary"+" "+"from Emp e"+ " " +"where e.dept=" dep1);

I get an error syntax error,similar is case of insertion .


please help..

 				
---------------------------------
 Here’s a new way to find what you're looking for - Yahoo! Answers