quotation marks problem of access db,SOS!

[Tom Keaton]

I use java to connect access db,the code appear like this:

String strurl="jdbc :-o	 dbc :mrgreen: river={Microsoft Access Driver (*.mdb)};DBQ=F:/tsefweb/jsp/db/students.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from students where '1'='1'");  

It is no problem,but

String strurl="jdbc :-o	 dbc :mrgreen: river={Microsoft Access Driver (*.mdb)};DBQ=F:/tsefweb/jsp/db/students.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(strurl) ;
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from students where \"1\"=\"1\"");

is wrong,though the sql sentence can correctly execute by copying to access
[ March 25, 2004: Message edited by: tvbas ]

[eammon bannon]

Not sure I understand your question - what exactly are you worried about?

[Tom Keaton]

String strurl="jdbc :-o	 dbc :mrgreen: river={Microsoft Access Driver (*.mdb)};DBQ=F:/tsefweb/jsp/db/students.mdb";Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");conn=DriverManager.getConnection(strurl) ;Statement stmt=conn.createStatement();ResultSet rs=stmt.executeQuery("select * from students where \"1\"=\"1\"");
  

it wrong,why?

[eammon bannon]

it wrong,why?

C'mon tvbas - you're not giving us much to work with here. By "wrong" do you mean:
- your code doesn't compile?
- you get a SQLException when you run it?
- you get some other kind of Exception?
- you get unexpected results?
- you get no results?
- you are worried it might be incorrect SQL?
- you are worried it could be better designed?
[ March 25, 2004: Message edited by: eammon bannon ]

[Bear Bibeault]

"tvbas",
We're pleased to have you here with us in the JSP forum, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.
In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.
Thanks!
bear
Forum Bartender

[Tom Keaton]

this is my code.
java.sql.SQLException

[Tom Keaton]

nobody can help me?

[Bear Bibeault]

"Tom K', thanks for changing your display name, but please read my response and the naming policy as your newly chosen name is still not valid.
bear
JDBC Forum Bartender

[Bear Bibeault]

nobody can help me?

Did you read eammon's reply? We can't help you unless you help yourself by answering requests for more information about your problem.

[Tom Keaton]

Originally posted by tvbas:
this is my code.
java.sql.SQLException

I have putted my code,please click "this",it is hyperlink of my code.