sql查询的简单问题
ljjjx 2002-09-16 09:58:24 我在执行以下语句时出错,不知道原因,请搞人指点:
String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";
String sourceURL = "jdbc:odbc:yuliao";
Class.forName (driverName);
databaseConnection = DriverManager.getConnection(sourceURL);
Statement myStatement = databaseConnection.createStatement();
String characters="上海"
ResultSet myResults = myStatement.executeQuery("SELECT frequency FROM yuliao WHERE keyword=characters");
出错提示:
SQL Exception:java.sql.SQLException:[Microsoft][ODBC SQL Server Driver][SQL Server]列名'characters'无效
另外,我使用的是sql2000