PreparedStatement中的java单引号
我使用PreparedStatement执行mysql数据库的查询。我写了如下内容:
String createQuery = "create table FEATURE(ID varchar(15) not null, ?, ?, ?)";
preparedStatement = connect.prepareStatement(createQuery);
//replacing question marks in prepared statement
int i =1;
for(Map.Entry<String,Boolean> entry: featureBool.entrySet()){
String col_final = "`"+entry.getKey()+"`"+" varchar(5)";
preparedStatement.setString(i, col_final);
}
我面临的问题是,当执行此查询时,单引号被追加到替换的字符串的开头和结尾。有人能帮我一下吗,因为我卡住了
例如,如果col_final=“Feature-1 varchar(5)”则在preparedStatement中,它将变成“Feature-1 varchar(5)”
共 (0) 个答案