Hi, I am new to java. I am trying to retrieving the data from access. I have a form(search data) in which i enter specialty and availday and i have a database in Ms-Access having four columns(Id,DoctName,Specialty,Availday). The thing I want is when i enter specialty and availday and click search button then it show result(data) having the specialty and availday that i want.
I have tried it to do but getting a syntax error.String b=sp.getText();
String c=ad.getText();
st.executeQuery("select * from doctorinfo where speciality='"+b+"' AND Availability Day='"+c+"' ");
and please also help me in writing query(how to quote the syntax)
Thanks in advance.
解决方案
st.executeQuery("select * from doctorinfo where Specialty = '" + b + "' AND [Availability Day]= '" + c + "'");
If your column name (Availbility day) have spaces in between them.Try like this.I hope this will help you.
Column name's should not contain space in between. Here in your case, the exception is thrown due to space between Availability Day column. To prevent this, you can alter the table and put underscore(Availability_Day) in place of space or you can try this:
st.executeQuery("select * from doctorinfo where speciality='"+b+"' AND [Availability Day]='"+c+"' ");
--Amit
Try like below...
st.executeQuery("select * from doctorinfo where Specialty = '" + b + "' AND Availday = '" + c + "'");
Make sure the column names (Specialty and Availday) and table name (doctorinfo) are correct.