mybatis中使用if标签判断时，如果判断的字段是boolean(数据库bit)时，传的值是0或者false时，mybatis会把它变成空，相当于没有传值

在mapper中的查询语句<select id="sectionSelect" parameterType="com.yinpeng.model.QueryFlight" resultMap="BaseResultMap">select<include refid="Base_Column_List"/>from flight where<trim prefix=""

qq2064676101

2406人浏览 · 2022-04-28 00:24:31

qq2064676101 · 2022-04-28 00:24:31 发布

在mapper中的查询语句

  <select id="sectionSelect" parameterType="com.yinpeng.model.QueryFlight" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"/>
        from flight where
        <trim prefix="" suffix="" suffixOverrides="and"  >
            <if test="
            startTime != null and
            endTime != null and
            startTime != '' and
            endTime != ''">
                start_time between #{startTime,jdbcType=DATE} and #{endTime,jdbcType=DATE}
                and
            </if>
            <if test="
            startLocation!=null and
            endLocation !=null and
            startLocation !='' and
            endLocation !=''">
                start_location = #{startLocation} and end_location=#{endLocation}
                and
            </if>
            <if test="
            startPrice != null and
            endPrice != null and
            startPrice !='' and
            endPrice != ''">
                ticket_price between #{startPrice} and #{endPrice}
                and
            </if>
            <if test="
            isTransfer != null and
            isTransfer != '' or isTransfer==0">
                is_transfer=#{isTransfer}
                and
            </if>
            <if test="
            isRound != null and
            isRound != '' ">
                is_round=#{isRound}
                and
            </if>
        </trim>

    </select>

如果前面的字段都不传值，只给isRound传一个0/false，报错出来的sql语句是这样的

### SQL: select id , start_time, end_time, start_location, start_location_crc32, end_location, end_location_crc32,remain_ticket, ticket_price, company, garde, is_transfer, is_round, model, other from flight where

where后面没有条件，原因是0/false会被判断成没有传值，php中我记得也会这样

解决方法在后面的条件中加入

or isRound == false或者or isTransfer==0就可以了，正确的如下

    <select id="sectionSelect" parameterType="com.yinpeng.model.QueryFlight" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"/>
        from flight where
        <trim prefix="" suffix="" suffixOverrides="and"  >
            <if test="
            startTime != null and
            endTime != null and
            startTime != '' and
            endTime != ''">
                start_time between #{startTime,jdbcType=DATE} and #{endTime,jdbcType=DATE}
                and
            </if>
            <if test="
            startLocation!=null and
            endLocation !=null and
            startLocation !='' and
            endLocation !=''">
                start_location = #{startLocation} and end_location=#{endLocation}
                and
            </if>
            <if test="
            startPrice != null and
            endPrice != null and
            startPrice !='' and
            endPrice != ''">
                ticket_price between #{startPrice} and #{endPrice}
                and
            </if>
            <if test="
            isTransfer != null and
            isTransfer != '' or isTransfer==0">
                is_transfer=#{isTransfer}
                and
            </if>
            <if test="
            isRound != null and
            isRound != '' or isRound == false">
                is_round=#{isRound}
                and
            </if>
        </trim>

    </select>

在查询就正常了

: ==>  Preparing: select id , start_time, end_time, start_location, start_location_crc32, end_location, end_location_crc32, remain_ticket, ticket_price, company, garde, is_transfer, is_round, model, other from flight where is_round=?

数据库表如下，附赠一百条数据

DROP TABLE IF EXISTS `flight`;
CREATE TABLE `flight` (
  `id` int(11) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `start_location` varchar(255) NOT NULL,
  `start_location_crc32` int(11) NOT NULL,
  `end_location` varchar(255) NOT NULL,
  `end_location_crc32` int(11) NOT NULL,
  `remain_ticket` int(11) NOT NULL,
  `ticket_price` int(11) NOT NULL,
  `company` varchar(255) NOT NULL,
  `garde` int(11) NOT NULL,
  `is_transfer` bit(1) NOT NULL,
  `is_round` bit(1) NOT NULL,
  `model` varchar(255) NOT NULL,
  `other` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `start_time` (`start_time`,`end_time`) USING BTREE,
  KEY `start_location_crc32` (`start_location_crc32`,`end_location_crc32`) USING BTREE,
  KEY `is_transfer` (`is_transfer`,`is_round`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flight
-- ----------------------------

INSERT INTO `flight` VALUES ('10', '2022-04-15 16:21:04', '2022-04-17 12:21:04', '米兰Milano', '1119618895', '拉各斯Lagos', '-1435022174', '500', '1978', '厦门航空有限责任公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('11', '2022-04-16 16:21:04', '2022-04-17 05:21:04', '马德里Madrid', '-2055494046', '慕尼黑Munich', '1077993426', '500', '8727', '瑞丽航空有限公司', '1', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('12', '2022-04-16 16:21:04', '2022-04-17 01:21:04', '米兰Milano', '1119618895', '达拉斯Dallas', '-2145657581', '500', '5182', '瑞丽航空有限公司', '1', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('13', '2022-04-16 16:21:04', '2022-04-16 21:21:04', '伊斯坦布尔Istanbul', '1416568148', '里约热内卢Rio DE Janeiro', '1957188465', '500', '9586', '大连航空有限责任公司', '2', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('14', '2022-04-16 16:21:04', '2022-04-18 05:21:04', '班加罗尔Bangalore', '-265017777', '丹佛Denver', '280733528', '500', '7553', '山东航空公司', '3', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('15', '2022-04-16 16:21:04', '2022-04-18 05:21:04', '法兰克福Frankfurt', '232609924', '多哈Doha', '-1232695598', '500', '2774', '天津航空有限责任公司', '3', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('16', '2022-04-16 16:21:04', '2022-04-17 14:21:04', '西雅图Seattle', '-1743738096', '汉堡Hamburg', '2118161988', '500', '1515', '中国新华航空公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('17', '2022-04-16 16:21:04', '2022-04-18 03:21:04', '波特兰Portland', '-859519099', '布鲁塞尔Brussels', '-103412165', '500', '3886', '翡翠国际货运航空有限责任公司', '1', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('18', '2022-04-16 16:21:04', '2022-04-18 04:21:04', '卡尔加里Calgary', '1998051632', '鹿特丹Rotterdam', '-1102226041', '500', '3390', '瑞丽航空有限公司', '1', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('19', '2022-04-16 16:21:04', '2022-04-16 17:21:04', '赫尔辛基Helsinki', '-1314805713', '布加勒斯特Bucharest', '394867010', '500', '8487', '中国航空货运公司', '4', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('20', '2022-04-16 16:21:04', '2022-04-17 15:21:04', '马尼拉Manila', '820979421', '卢森堡Luxembourg', '-2087175909', '500', '9460', '厦门航空有限责任公司', '1', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('21', '2022-04-17 16:21:04', '2022-04-19 15:21:04', '巴塞罗那Barcelona', '-1907607115', '卡尔加里Calgary', '1998051632', '500', '3098', '西部航空有限公司', '3', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('22', '2022-04-17 16:21:04', '2022-04-17 17:21:04', '约翰内斯堡Johannesburg', '-806093023', '深圳Shenzhen', '-405578601', '500', '9687', '新疆航空公司', '4', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('23', '2022-04-17 16:21:04', '2022-04-19 06:21:04', '底特律Detroit', '1796381492', '都柏林Dublin', '-293611835', '500', '806', '中国东方航空公司', '4', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('24', '2022-04-17 16:21:04', '2022-04-17 16:21:04', '特拉维夫Tel Aviv-Yafo', '297426416', '多伦多Toronto', '1830492483', '500', '8295', '中苏民用航空股份公司', '1', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('25', '2022-04-17 16:21:04', '2022-04-18 07:21:04', '马尼拉Manila', '820979421', '迪拜Dubai', '-1411946297', '500', '2876', '武汉航空公司', '4', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('26', '2022-04-17 16:21:04', '2022-04-18 19:21:04', '墨西哥城Mexico City', '-2055775658', '休斯顿Houston', '495411853', '500', '2856', '上海国际货运航空有限公司', '1', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('27', '2022-04-17 16:21:04', '2022-04-18 12:21:04', '约翰内斯堡Johannesburg', '-806093023', '台北 Taipei', '-1198290639', '500', '5881', '中国南方航空（集团）湖南公司', '2', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('28', '2022-04-17 16:21:04', '2022-04-19 09:21:04', '旧金山San Francisco', '2107901337', '伯明翰Birmingham', '-998672219', '500', '3387', '中原航空公司', '4', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('29', '2022-04-17 16:21:04', '2022-04-19 13:21:04', '马德里Madrid', '-2055494046', '曼彻斯特Manchester', '-193766243', '500', '9658', '上海国际货运航空有限公司', '2', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('30', '2022-04-17 16:21:04', '2022-04-18 10:21:04', '布加勒斯特Bucharest', '394867010', '孟买Mumbai', '1817416822', '500', '8801', '西藏航空有限公司', '2', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('31', '2022-04-18 16:21:04', '2022-04-19 02:21:04', '纽约New York', '-1521020648', '巴塞罗那Barcelona', '-1907607115', '500', '3463', '长龙国际货运航空有限公司', '3', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('32', '2022-04-18 16:21:04', '2022-04-18 20:21:04', '马尼拉Manila', '820979421', '雅典Athens', '-88342680', '500', '7532', '鲲鹏航空有限公司', '4', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('33', '2022-04-18 16:21:04', '2022-04-18 18:21:04', '马德里Madrid', '-2055494046', '卡尔加里Calgary', '1998051632', '500', '8165', '武汉航空公司', '4', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('34', '2022-04-18 16:21:04', '2022-04-19 10:21:04', '圣保罗Sao Paulo', '-1766945013', '伊斯兰堡Islamabad', '1145410172', '500', '2958', '北京航空有限责任公司', '3', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('35', '2022-04-18 16:21:04', '2022-04-18 18:21:04', '基多Quito', '-145591424', '斯德哥尔摩Stockholm布拉格Prague', '502720450', '500', '9735', '长安航空公司', '3', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('36', '2022-04-18 16:21:04', '2022-04-19 10:21:04', '巴塞罗那Barcelona', '-1907607115', '雅典Athens', '-88342680', '500', '7949', '长安航空公司', '2', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('37', '2022-04-18 16:21:04', '2022-04-20 05:21:04', '雅典Athens', '-88342680', '东京Tokyo', '865210934', '500', '3974', '天鹅航空公司', '3', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('38', '2022-04-18 16:21:04', '2022-04-19 14:21:04', '巴拿马城Panama city', '-1783591258', '温哥华Vancouver', '-1622492277', '500', '4261', '天津货运航空有限公司', '4', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('39', '2022-04-18 16:21:04', '2022-04-20 00:21:04', '温哥华Vancouver', '-1622492277', '胡志明市Ho Chi Minh City', '-2043472138', '500', '2447', '桂林航空有限公司', '4', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('40', '2022-04-18 16:21:04', '2022-04-19 23:21:04', '内罗毕Nairobi', '-754279369', '底特律Detroit', '1796381492', '500', '2218', '广西航空有限公司', '3', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('41', '2022-04-19 16:21:04', '2022-04-21 01:21:04', '马德里Madrid', '-2055494046', '上海Shanghai', '-776530728', '500', '8851', '大连航空有限责任公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('42', '2022-04-19 16:21:04', '2022-04-20 21:21:04', '北京Beijing', '-1708522313', '约翰内斯堡Johannesburg', '-806093023', '500', '5283', '西藏航空有限公司', '2', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('43', '2022-04-19 16:21:04', '2022-04-20 21:21:04', '达拉斯Dallas', '-2145657581', '基辅Kiev', '114329594', '500', '6884', '中国航空货运公司', '2', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('44', '2022-04-19 16:21:04', '2022-04-20 11:21:04', '洛杉矶Los Angeles', '-613318089', '贝鲁特Beirut', '172566688', '500', '262', '中国西南航空公司', '4', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('45', '2022-04-19 16:21:04', '2022-04-20 23:21:04', '特拉维夫Tel Aviv-Yafo', '297426416', '波特兰Portland', '-859519099', '500', '3162', '上海航空公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('46', '2022-04-19 16:21:04', '2022-04-21 02:21:04', '日内瓦Geneva', '818881734', '阿拉木图Alma-Ata Almaty', '-975899516', '500', '8074', '龙江航空有限公司', '4', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('47', '2022-04-19 16:21:04', '2022-04-21 13:21:04', '爱丁堡Edinburgh', '-1837011221', '东京Tokyo', '865210934', '500', '4537', '杭州圆通货运航空有限公司', '3', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('48', '2022-04-19 16:21:04', '2022-04-20 02:21:04', '基多Quito', '-145591424', '丹佛Denver', '280733528', '500', '7072', '杭州圆通货运航空有限公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('49', '2022-04-19 16:21:04', '2022-04-21 05:21:04', '布达佩斯Budapest', '1870014727', '新加坡Singapore', '1402904499', '500', '7652', '中国南方航空海南公司', '2', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('50', '2022-04-19 16:21:04', '2022-04-21 14:21:04', '开普敦Cape Town', '-315171335', '卡尔加里Calgary', '1998051632', '500', '4004', '中国邮政航空公司', '4', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('51', '2022-04-20 16:21:04', '2022-04-21 20:21:04', '丹佛Denver', '280733528', '都柏林Dublin', '-293611835', '500', '2611', '浙江航空公司', '1', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('52', '2022-04-20 16:21:04', '2022-04-21 00:21:04', '里约热内卢Rio DE Janeiro', '1957188465', '波特兰Portland', '-859519099', '500', '874', '天鹅航空公司', '1', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('53', '2022-04-20 16:21:04', '2022-04-21 13:21:04', '惠灵顿Wellington', '448277417', '伊斯坦布尔Istanbul', '1416568148', '500', '4887', '鹰联航空有限公司', '1', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('54', '2022-04-20 16:21:04', '2022-04-21 15:21:04', '波士顿Boston', '-399309379', '丹佛Denver', '280733528', '500', '486', '长城航空有限公司', '3', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('55', '2022-04-20 16:21:04', '2022-04-21 07:21:04', '约翰内斯堡Johannesburg', '-806093023', '马尼拉Manila', '820979421', '500', '4639', '鲲鹏航空有限公司', '2', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('56', '2022-04-20 16:21:04', '2022-04-20 16:21:04', '莫斯科Moscow', '1943308839', '米兰Milano', '1119618895', '500', '9650', '成都航空有限公司', '1', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('57', '2022-04-20 16:21:04', '2022-04-22 05:21:04', '香港Hong Kong', '1041516103', '多伦多Toronto', '1830492483', '500', '9277', '奥凯航空有限公司', '1', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('58', '2022-04-20 16:21:04', '2022-04-20 19:21:04', '费城Philadelphia', '1128207498', '开罗Cairo', '-1077447375', '500', '1507', '新华航空股份有限公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('59', '2022-04-20 16:21:04', '2022-04-22 00:21:04', '伊斯坦布尔Istanbul', '1416568148', '墨尔本Melbourne', '197560661', '500', '4726', '幸福航空有限责任公司', '2', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('60', '2022-04-20 16:21:04', '2022-04-21 23:21:04', '布里斯班Brisbane', '-1969439273', '北京Beijing', '-1708522313', '500', '6691', '重庆航空有限责任公司', '4', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('61', '2022-04-21 16:21:04', '2022-04-21 22:21:04', '上海Shanghai', '-776530728', '贝鲁特Beirut', '172566688', '500', '6356', '友和道通航空有限公司', '4', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('62', '2022-04-21 16:21:04', '2022-04-22 23:21:04', '加尔各答Calcutta', '-213282427', '惠灵顿Wellington', '448277417', '500', '5642', '天津航空有限责任公司', '1', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('63', '2022-04-21 16:21:04', '2022-04-21 20:21:04', '卡萨布兰卡Casablanca', '1638717838', '布达佩斯Budapest', '1870014727', '500', '502', '广西航空有限公司', '3', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('64', '2022-04-21 16:21:04', '2022-04-21 18:21:04', '赫尔辛基Helsinki', '-1314805713', '旧金山San Francisco', '2107901337', '500', '2510', '东北航空有限公司', '1', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('65', '2022-04-21 16:21:04', '2022-04-22 23:21:04', '法兰克福Frankfurt', '232609924', '迪拜Dubai', '-1411946297', '500', '1446', '长龙国际货运航空有限公司', '1', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('66', '2022-04-21 16:21:04', '2022-04-23 06:21:04', '圣保罗Sao Paulo', '-1766945013', '墨西哥城Mexico City', '-2055775658', '500', '6872', '桂林航空有限公司', '2', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('67', '2022-04-21 16:21:04', '2022-04-22 06:21:04', '曼谷Bangkok', '-56481516', '墨尔本Melbourne', '197560661', '500', '306', '奥凯航空有限公司', '1', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('68', '2022-04-21 16:21:04', '2022-04-21 20:21:04', '雅典Athens', '-88342680', '都柏林Dublin', '-293611835', '500', '4780', '中国东方航空江苏有限公司', '1', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('69', '2022-04-21 16:21:04', '2022-04-23 07:21:04', '班加罗尔Bangalore', '-265017777', '苏黎世Zurich', '-2035731058', '500', '6175', '上海国际货运航空有限公司', '1', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('70', '2022-04-21 16:21:04', '2022-04-22 21:21:04', '蒙得维的亚Montevideo', '1550048490', '伊斯坦布尔Istanbul', '1416568148', '500', '3086', '北京航空有限责任公司', '4', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('71', '2022-04-22 16:21:04', '2022-04-24 09:21:04', '深圳Shenzhen', '-405578601', '新德里New Delhi', '-334940537', '500', '9877', '中国南方航空（集团）湖南公司', '4', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('72', '2022-04-22 16:21:04', '2022-04-23 02:21:04', '蒙特利尔Montreal', '775592369', '基辅Kiev', '114329594', '500', '8036', '山东航空公司', '3', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('73', '2022-04-22 16:21:04', '2022-04-22 17:21:04', '柏林Berlin', '-467030166', '巴塞罗那Barcelona', '-1907607115', '500', '6971', '厦门航空有限责任公司', '3', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('74', '2022-04-22 16:21:04', '2022-04-24 08:21:04', '多哈Doha', '-1232695598', '首尔Seoul', '-1123297002', '500', '7395', '瑞丽航空有限公司', '2', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('75', '2022-04-22 16:21:04', '2022-04-23 15:21:04', '赫尔辛基Helsinki', '-1314805713', '首尔Seoul', '-1123297002', '500', '3475', '上海吉祥航空有限公司', '1', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('76', '2022-04-22 16:21:04', '2022-04-23 03:21:04', '洛杉矶Los Angeles', '-613318089', '东京Tokyo', '865210934', '500', '8206', '中国新华航空公司', '3', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('77', '2022-04-22 16:21:04', '2022-04-24 06:21:04', '罗马Rome', '-869730262', '巴塞罗那Barcelona', '-1907607115', '500', '8635', '河北航空有限公司', '1', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('78', '2022-04-22 16:21:04', '2022-04-23 16:21:04', '休斯顿Houston', '495411853', '圣地亚哥San Diego', '913752368', '500', '8317', '东海航空有限公司', '2', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('79', '2022-04-22 16:21:04', '2022-04-23 03:21:04', '特拉维夫Tel Aviv-Yafo', '297426416', '马尼拉Manila', '820979421', '500', '1919', '中国国际航空内蒙古有限公司', '2', '', '', '青黛', null);
INSERT INTO `flight` VALUES ('80', '2022-04-22 16:21:04', '2022-04-23 05:21:04', '马尼拉Manila', '820979421', '里加Riga', '1464569285', '500', '7696', '顺丰航空有限公司', '3', '', '', '羽涅', null);
INSERT INTO `flight` VALUES ('81', '2022-04-23 16:21:04', '2022-04-25 03:21:04', '布达佩斯Budapest', '1870014727', '伦敦 London', '2141000536', '500', '1065', '中原航空公司', '4', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('82', '2022-04-23 16:21:04', '2022-04-24 11:21:04', '上海Shanghai', '-776530728', '米兰Milano', '1119618895', '500', '1374', '金鹿航空有限公司', '4', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('83', '2022-04-23 16:21:04', '2022-04-25 02:21:04', '卡拉奇Karachi', '1060433088', '雅加达Jakarta', '1920246351', '500', '7642', '中国南方航空（集团）湖南公司', '1', '', '', '剪秋', null);
INSERT INTO `flight` VALUES ('84', '2022-04-23 16:21:04', '2022-04-24 14:21:04', '维也纳Vienna', '250957207', '亚特兰大Atlanta', '1184807805', '500', '6119', '鲲鹏航空有限公司', '2', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('85', '2022-04-23 16:21:04', '2022-04-25 07:21:04', '圣何塞 SAN JOSE', '-1921761717', '布里斯班Brisbane', '-1969439273', '500', '1068', '云南翔鹏航空有限责任公司', '1', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('86', '2022-04-23 16:21:04', '2022-04-23 16:21:04', '台北 Taipei', '-1198290639', '布达佩斯Budapest', '1870014727', '500', '8785', '福建航空公司', '3', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('87', '2022-04-23 16:21:04', '2022-04-25 05:21:04', '悉尼Sydney', '-1072670505', '亚特兰大Atlanta', '1184807805', '500', '7462', '中国人民航空公司', '3', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('88', '2022-04-23 16:21:04', '2022-04-24 04:21:04', '内罗毕Nairobi', '-754279369', '广州Guangzhou', '-1030080191', '500', '1160', '天津货运航空有限公司', '2', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('89', '2022-04-23 16:21:04', '2022-04-23 19:21:04', '温哥华Vancouver', '-1622492277', '马尼拉Manila', '820979421', '500', '7526', '新华航空股份有限公司', '3', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('90', '2022-04-23 16:21:04', '2022-04-24 20:21:04', '达拉斯Dallas', '-2145657581', '阿拉木图Alma-Ata Almaty', '-975899516', '500', '3933', '昆明航空有限公司', '3', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('91', '2022-04-24 16:21:04', '2022-04-24 16:21:04', '首尔Seoul', '-1123297002', '约翰内斯堡Johannesburg', '-806093023', '500', '8783', '天津货运航空有限公司', '3', '', '', '辛夷', null);
INSERT INTO `flight` VALUES ('92', '2022-04-24 16:21:04', '2022-04-25 17:21:04', '伊斯兰堡Islamabad', '1145410172', '布宜诺斯艾利斯 Buenos Aires', '7488034', '500', '4500', '中国邮政航空公司', '1', '', '', '荆芥', null);
INSERT INTO `flight` VALUES ('93', '2022-04-24 16:21:04', '2022-04-25 01:21:04', '罗马Rome', '-869730262', '慕尼黑Munich', '1077993426', '500', '2241', '鹰联航空有限公司', '2', '', '', '沉香', null);
INSERT INTO `flight` VALUES ('94', '2022-04-24 16:21:04', '2022-04-25 13:21:04', '马尼拉Manila', '820979421', '布加勒斯特Bucharest', '394867010', '500', '354', '中州航空有限责任公司', '4', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('95', '2022-04-24 16:21:04', '2022-04-25 07:21:04', '利雅得Riyadh', '-1060250242', '安特卫普Antwerp', '-654128128', '500', '6310', '北京首都航空有限公司', '1', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('96', '2022-04-24 16:21:04', '2022-04-26 13:21:04', '吉隆坡Kuala Lumpur', '677092577', '法兰克福Frankfurt', '232609924', '500', '9069', '上海吉祥航空有限公司', '4', '', '', '半夏', null);
INSERT INTO `flight` VALUES ('97', '2022-04-24 16:21:04', '2022-04-26 09:21:04', '孟买Mumbai', '1817416822', '北京Beijing', '-1708522313', '500', '1350', '中国南方航空汕头航空有限公司', '2', '', '', '枳实', null);
INSERT INTO `flight` VALUES ('98', '2022-04-24 16:21:04', '2022-04-25 21:21:04', '布加勒斯特Bucharest', '394867010', '法兰克福Frankfurt', '232609924', '500', '6301', '长城航空公司', '1', '', '', '君迁子', null);
INSERT INTO `flight` VALUES ('99', '2022-04-24 16:21:04', '2022-04-25 04:21:04', '里斯本Lisbon', '69253876', '多伦多Toronto', '1830492483', '500', '1777', '北京航空有限责任公司', '3', '', '', '长卿', null);
INSERT INTO `flight` VALUES ('100', '2022-04-24 16:21:04', '2022-04-25 05:21:04', '孟买Mumbai', '1817416822', '法兰克福Frankfurt', '232609924', '500', '751', '中航货运航空有限公司', '3', '', '', '沉香', null);