stringbuffer拼出SQL语句，避免加号带来的引号冲突

/** * 根据表名称创建一张表 * @param tableName */public int createTable(String tableName){StringBuffer sb = new StringBuffer("");sb.append("CREATE TABLE `" + tableName + "` (");sb.append("`id`  int(11) NOT NULL AUTO_INCREMENT ,");sb.append("`alertId`  int(11) NULL DEFAULT NULL ,");sb.append("`alertTime`  int(11) NULL DEFAULT NULL ,");sb.append("`alertLevel`  int(11) NULL DEFAULT NULL ,");sb.append("`deviceMark`  int(11) NULL DEFAULT NULL ,");sb.append("`carNo`  int(11) NULL DEFAULT NULL ,");sb.append("`updateTime`  varchar(255) DEFAULT NULL ,");sb.append("PRIMARY KEY (`id`)");sb.append(") CHARACTER SET=utf8 COLLATE=utf8_general_ci;");try {jdbcTemplate.update(sb.toString());return 1;} catch (Exception e) {e.printStackTrace();}return 0;}