/**     * 获取物理表中已存在的列信息     * @param tbName 表名     * @return results 查询结果     */    fun getExistColumnInfo(tbName:String) :List
     
       {        var sql = "select database() AS db_name"        var dbNameRecord = Db.findFirst(sql)        var existColSql = """             select COLUMN_NAME as name             from INFORMATION_SCHEMA.COLUMNS             where TABLE_SCHEMA=? and TABLE_NAME=?            """        var results = Db.find(existColSql, dbNameRecord.getStr("dbName"), tbName)        return results    }
     

　　获取主键信息：

/**     * 获取物理表已存在的主键字段名     * @param tbName 表名     * @return results 查询结果     */    fun getExistPrimaryKeyFields(tbName: String) : List
     
      ? {        var sql = "select database() AS db_name"        var dbNameRecord = Db.findFirst(sql)        var existPKFiledsSql = """                SELECT                    k.column_name,                    t.table_name,                    table_schema                FROM                    information_schema.table_constraints t                JOIN information_schema.key_column_usage k USING (                    constraint_name,                    table_schema,                    table_name                )                WHERE                    t.constraint_type = 'PRIMARY KEY'                AND t.table_schema = ?                AND t.table_name = ?            """        var results = Db.find(existPKFiledsSql, dbNameRecord.getStr("dbName"), tbName)        return results    }