wu xiao wrote:
> PreparedStatement ps = db.prepareStatement("select * from operator where
> ID=?");
> The sqlexception is：....column 'id' is not exist..... What's the reason
> please? All of the tables are created in Windows XP.
If you've created the table with a capitalized column name, you will
need to quote it in your SQL:
"select * from operator where \"ID\"=?"
Unquoted identifiers (column names, table names, etc) are forced to
lowercase by the server.
-O