您拼接搜索数据库语句时黏在一起发生报错了

### 该问题是怎么引起的？
您好，您的代码中有点问题，就是生成的时候搜索原表拼接 数据库语句时 将 from前面的连接在一起报错了。

### 重现步骤

/**
	 * 获取表结构
	 * 
	 * @author johnDeng
	 * @dataTime 2019年3月5日下午3:51:10
	 * @param tableName
	 * @return
	 */
	@Override
	public List<TableColumns> getListByTable(String tableName) {
		StringBuffer sql=new StringBuffer();
		sql.append("SELECT TABLE_SCHEMA AS tableSchema,TABLE_NAME AS tableName,COLUMN_NAME AS columnName,");
		sql.append("ORDINAL_POSITION AS ordinalPosition,IS_NULLABLE AS notNullFlag,DATA_TYPE AS dataType,");
		sql.append("CHARACTER_MAXIMUM_LENGTH AS columnLength,COLUMN_KEY AS  cloumnKey,COLUMN_COMMENT AS cloumnComent");
		sql.append("FROM information_schema.columns WHERE table_schema = '");
		sql.append(DataBaseUtils.getDatabaseName(datasourceSettings.getUrl()));
		sql.append("' AND table_name = '");
		sql.append(tableName);
		sql.append("'");
		logger.info("jdbc getListByTable sql:"+sql.toString());
		return jdbcTemplate.query(sql.toString(), new BeanPropertyRowMapper<TableColumns>(TableColumns.class));
	}

其中的后面少了一个空格，导致与后面的from黏在一起发生报错。
		sql.append("CHARACTER_MAXIMUM_LENGTH AS columnLength,COLUMN_KEY AS  cloumnKey,COLUMN_COMMENT AS cloumnComent");

### 报错信息

org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [SELECT TABLE_SCHEMA AS tableSchema,TABLE_NAME AS tableName,COLUMN_NAME AS columnName,ORDINAL_POSITION AS ordinalPosition,IS_NULLABLE AS notNullFlag,DATA_TYPE AS dataType,CHARACTER_MAXIMUM_LENGTH AS columnLength,COLUMN_KEY AS  cloumnKey,COLUMN_COMMENT AS cloumnComentFROM information_schema.columns WHERE table_schema = 'simple_bak' AND table_name = 'sp_cluster']; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'information_schema.columns WHERE table_schema = 'simple_bak' AND table_name = 's' at line 1

一点小问题，不知道你那里有没有问题，我这边修改后成功运行，得到了想要的结果，十分感谢

JohnDeng/code-generator

内容风险标识

评论 (1)

JohnDeng/code-generator .gitee-modal { width: 500px !important; }

内容风险标识