Mock模拟数据真实案例

2.2.1 使用Mock模拟数据

• 由于插入数据库需要使用后端语言,这里只演示如何使用Mock进行模拟数据,并输出数据库插入格式,复制进行插入

• 真实场景后端可以提供一个接口接收模拟的数据,前端传入模拟的data数据,后端处理进行插入

1. 用户请求对象

​
// 用户请求对象
export const userList = {
    //BIGINT
    id: 0,
    enabled: true,
    acct_active: true,
    pwd_valid: true,
    acct_locked: true,
​
    username: '',
    password: '',
    nickname: '',
    avatar: '', //链接
    phone: '',
    email: '',
    name: '',
    gender: '',
    age: 0,//smallint
    description: '', //描述
    modified_by: 0, //BIGINT 最后修改用户ID
​
    gmt_create: '',
    gmt_modified: ''
}

1. 插入

import Mock from 'mockjs'
import './mock.js'
import {modifyStr, generateMockPassword} from "./utils.js";
​
​
/**
 * 循环插入500w条数据
 *
 * @returns {[{gmt_create: string, gender: string, acct_locked: boolean, description: string, avatar: string, gmt_modified: string, enabled: boolean, pwd_valid: boolean, password: string, phone: string, nickname: string, name: string, modified_by: number, id: number, email: string, age: number, acct_active: boolean, username: string}]|*|string}
 */
export async function userInsert() {
​
    var data = []
​
    // 2. 填充500w条 数组
    for (let i = 0; i < 50; i++) {
        // 生成一个请求对象
        let requestData = getRequestData();
​
        //去掉BIGINT类型最后的X
        if (requestData.id.endsWith('X')) {
            requestData.id = requestData.id.slice(0, -1)
        }
        if (requestData.modified_by.endsWith('X')) {
            requestData.modified_by = requestData.modified_by.slice(0, -1)
            // requestData.modified_by = requestData.modified_by+'1'
        }
        
        /**
         * 此处:若为接口提供数据,直接传入data对象
         * data.push(requestData)
         */
​
        //只取value作为插入数据库的数据
        let key = Object.values(requestData)
​
        //字符串处理
        console.log(modifyStr(key))
    }
}
​
​
/**
 * 生成一个请求 对象
 */
function getRequestData() {
    //生成一个临时模拟数据
    return Mock.mock({
        id: '@id',
        enabled: '@boolean',
        acct_active: '@boolean',
        pwd_valid: '@boolean',
        acct_locked: '@boolean',
        username: Mock.Random.first() + Mock.Random.last() + Mock.Random.integer(100, 999),
        password: generateMockPassword(),
        nickname: '@last',
        avatar() {
            //用户头像
            return Mock.Random.image('100×100', Mock.Random.color(), '#757575', 'png', this.nickname)
        },
        phone: /^1[34578]\d{9}$/,
        email: '@email()',
        name: '@cname()',
        gender() {
            const genders = ['男', '女'];
​
            return Mock.Random.pick(genders);
        },
        description: Mock.Random.cparagraph(),
        modified_by: '@id',
        gmt_create: '@date(yyyy-MM-dd)',
        gmt_modified: '@date(yyyy-MM-dd)'
    })
​
}
​
​
userInsert()
​
​

1. 工具包

import Mock from "mockjs";
​
//字符串处理
export function modifyStr(str){
    // 将数组转换为字符串
    str = JSON.stringify(str);
​
    // 替换方括号为圆括号
    let newStr = str.replace(/\[/g, '(').replace(/\]/g, ')');
​
    // 去除转义字符，并将双引号替换为单引号
    let newStr2 = newStr.replace(/\\(.)/g, '$1').replace(/"/g, '\'');
    // 在每个逗号后面添加转义符
    newStr2 = newStr2 + ','
    return newStr2.replace(/,/g, (match) => match + '\n');
    // 使用正则表达式去除最后一个逗号
}
​
​
​
//生成密码
export function generateMockPassword(length = 8) {
    const random = Mock.Random;
    const lowerCase = 'abcdefghijklmnopqrstuvwxyz';
    const upperCase = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
    const numbers = '0123456789';
    const specialChars = '!@#$%^&*()_+-=[]{}|;:,.<>?';
    // 结合所有字符集
    const allChars = lowerCase + upperCase + numbers + specialChars;
​
    // 随机选择字符
    let password = '';
    for (let i = 0; i < length; i++) {
        const randomIndex = Math.floor(Math.random() * allChars.length);
        password += allChars[randomIndex];
    }
​
    return password;
​
}
​

2.2.2 获取结果进行sql插入

INSERT INTO yhs_user2(id,enabled,acct_active, pwd_valid,  acct_locked, username, password, nickname, phone, email, name, description, modified_by, gmt_create, gmt_modified, avatar, gender)
VALUES
​
('820000201008019077',
true,                 
true,                 
true,                 
true,                 
'JohnJackson347',     
'qBo#)i*;',           
'Gonzalez',           
'14695547039',        
'v.depxa@rmzkgchp.ua',
'袁静',
'需今电他声明时八华调儿需样。没做将越圆又身己厂什感构如青到。七里置经人消书治立京你小下斯是划。么一严每强空济活间决立声热边事制。可教红么是族且导高更土始头始。',
'820000201008019077',
'1979-09-21',
'1994-11-16',
'http://dummyimage.com/100×100/79e1f2/757575.png&text=Gonzalez',
'女'),
​
('140000199503307226',
true,
false,
true,
true,
'DorothyJohnson190',
'fs#wI!e7',
'Smith',
'14614243647',
'p.pnzrp@lpybw.sh',
'卢磊',
'类花因研路设记期无头革海次将多。习深公支处展特精新本律心是长石状什。中行第问从个内明研十级目支中离。并界观白性度代山事花叫理济队属如。众连能导易展容风京导很回素叫领发。外较人几何质了整电代度心格何米步边。',
'140000199503307226',
'1998-04-03',
'2001-09-01',
'http://dummyimage.com/100×100/f2df79/757575.png&text=Smith',
'男'),
​
('130000201511137966',
false,
true,
false,
false,
'JessicaDavis752',
'stO@y>78',
'Young',
'13774457845',
'w.skgptt@ivdbi.edu',
'常敏',
'离数发革铁基计更了集极根极制九构百。江给平可条手中并种三子易带速队。却从时而劳书天算层金已酸我矿术林。直总他计命期矿风这称往精目活石常。',
'130000201511137966',
'1992-11-25',
'1985-07-10',
'http://dummyimage.com/100×100/bc79f2/757575.png&text=Young',
'男'),
​
('62000019800906592',
true,
false,
true,
true,
'BrendaWilson530',
'v-m.q=P3',
'Hall',
'14786692638',
'b.edcmkvlmw@ftgthx.rw',
'锺敏',
'酸回须断里感片三山时调华得五教低度回。持属严快住里干调头价明确眼量新消四。安内里极很与保安想解的被装切很。等件育向合较主林节适程经备派人院者。',
'62000019800906592',
'1997-05-02',
'1992-01-12',
'http://dummyimage.com/100×100/79f299/757575.png&text=Hall',
'女'),
​
('130000197111042432',
true,
false,
true,
true,
'LindaGarcia437',
'0_p{AYXL',
'Rodriguez',
'17634716822',
's.kypgy@tbwr.dm',
'谭艳',
'那八并家议即般名家时法此方许而基变。太际细属表县包务美做经化。细学省族工带立条容党文里更理效。当里群与个容切提全严门领后可眼。是价说世从图日门需样我两头。',
'130000197111042432',
'1973-04-25',
'2024-01-23',
'http://dummyimage.com/100×100/f2797c/757575.png&text=Rodriguez',
'男'),
​
('640000197612067654',
true,
true,
false,
false,
'NancyJohnson480',
'q|SIWMsn',
'Thompson',
'17842456740',
'l.asjke@klzugmkm.gi',
'姜丽',
'代出由领年提由值华听根候划。争期联证江期几自火运在正约以满世。文备好有明战每完日动量之提听而安适导。包别题般些习线酸因提还快九业以改做情。次持持最才位团交教此但以只适程半。酸回将正强要类利而系任候意收进持状。',
'640000197612067654',
'2005-12-01',
'1978-05-17',
'http://dummyimage.com/100×100/799ff2/757575.png&text=Thompson',
'男'),
​
('320000201606097974',
false,
true,
false,
true,
'ScottMartinez633',
'Nm7HSLa(',
'Garcia',
'17443778520',
't.yjd@ojnpdqtz.com.cn',
'高洋',
'家等众克没指一酸三林条众几效。技少体多之军包个了正土影。族后快专至分省门由照规飞我阶走还据近。民林济把质图报还与教重传证自示有通影。',
'320000201606097974',
'2013-10-17',
'1980-02-12',
'http://dummyimage.com/100×100/c3f279/757575.png&text=Garcia',
'男'),
​
('230000200911204418',
false,
true,
false,
true,
'MichaelLewis327',
'qRkfr)8d',
'Jones',
'13241024380',
'x.pmcd@yydwm.ws',
'黎霞',
'马万土认也步照山设车素九见边个。低对达化现革自马就受百西。利市群导空而七各天区证专联并。江先生件干经增毛品带不间本品性置称。际单到家持构改百国住都可制干知县织流。解划时争月民去部者划料铁素。',
'230000200911204418',
'1985-04-02',
'1995-05-20',
'http://dummyimage.com/100×100/f279e6/757575.png&text=Jones',
'女'),
​
('650000199602272890',
true,
true,
false,
true,
'JoseWilson324',
'yLxtW&w8',
'Taylor',
'13106920348',
'j.pfc@clhnombcus.my',
'刘桂英',
'有政先二四它关发老多集调集你白。果情常决建米其众传有外角大区群。心文土精质是特原无江组运府干其。口确半可思有路速亲军量气对解报才。',
'650000199602272890',
'2005-04-13',
'2017-12-01',
'http://dummyimage.com/100×100/79f2da/757575.png&text=Taylor',
'女'),
​
('360000197102251219',
false,
true,
false,
true,
'KevinDavis281',
'2YOlfyo1',
'Lee',
'17483283239',
'u.wujkpqmt@gsfxis.bo',
'袁娜',
'研具间老难难达连表自当治农历包。集阶状世需装此水声也要时青料温。治八处速片色报维知文应住手群平越次。',
'360000197102251219',
'2002-10-05',
'2002-02-25',
'http://dummyimage.com/100×100/f2b779/757575.png&text=Lee',
'男'),
​
('820000199910148623',
false,
false,
false,
true,
'CarolDavis411',
'Z?E1aaYI',
'Lewis',
'15123268635',
'i.oepn@fbqcmfuc.tv',
'刘敏',
'情水道近江活则主产派组温原加。际件目铁团层效响王员难叫布世活什适。为上片称里中比速划段家才出入什严。角更称代须采而型火铁教期权型离红或片。',
'820000199910148623',
'1986-05-25',
'1987-01-24',
'http://dummyimage.com/100×100/9379f2/757575.png&text=Lewis',
'女'),
​
('630000197603029283',
false,
true,
true,
false,
'KevinMiller740',
'#aL0SZ$4',
'Lee',
'17200071588',
'f.grzpk@ichkqmhm.ru',
'彭强',
'消她关格思始把加带般究级国指水合指。和因持感酸看具青头长商元改果列无。海林己加经叫过存响同及能式将用步受。矿记说局发行周无世也存利白争再转所。',
'630000197603029283',
'1984-12-06',
'2000-11-01',
'http://dummyimage.com/100×100/81f279/757575.png&text=Lee',
'男'),
​
('650000200801264880',
false,
false,
false,
false,
'SandraWilson604',
'Rnz}pOFe',
'Martinez',
'17794665666',
'u.tvroeunet@izrbinvjb.ae',
'陆秀兰',
'物头还风别到量空白下周值观务别形劳。往的二美命为十教关道问能。持都深着现接近非马际花属究马你厂力。备世究不有东金和日列时少省务。直火温节许复整干石可太律到调打。入看边具革基类一话直里始义由法。',
'650000200801264880',
'2012-10-05',
'1986-07-20',
'http://dummyimage.com/100×100/f279a4/757575.png&text=Martinez',
'女'),
​
('710000200103016341',
true,
false,
true,
false,
'DanielWhite720',
'nn0Pt(A$',
'Gonzalez',
'15365910243',
'c.ltwcp@oyxlzjck.pl',
'龚娜',
'号也候金于式效重况与这程看它。反信立任产部知则为完石具飞。千争几节别口石问好平维好号该眼南较。更离土关点步决所二同地况八酸太。',
'710000200103016341',
'2022-03-14',
'1987-02-15',
'http://dummyimage.com/100×100/79c8f2/757575.png&text=Gonzalez',
'女'),
​
('22000020171116264',
true,
false,
true,
true,
'SandraWalker410',
'B)abK5pX',
'Lopez',
'14109618588',
'g.synorw@lcqhtz.biz',
'李丽',
'什直周参约总联装格六备列生强。身带中油快京及知法都所海调规传北一。点量感会经设与认运往装按及众往且命题。组志厂济期题因儿革战子况无不过常放四。们斗七际管达关家元少再受原王东应。发族主党节应风你加了形导民府题。',
'22000020171116264',
'1995-01-02',
'1979-05-30',
'http://dummyimage.com/100×100/ebf279/757575.png&text=Lopez',
'男'),
​
('330000199301284869',
false,
false,
true,
false,
'DanielHarris666',
'N@%@Z?X<',
'Robinson',
'17016161654',
't.rcuip@wgpfuumou.com',
'韩敏',
'难八值时条整节元面究西知龙毛经却决。信金着到带交力运路族出打流满参题。律原都需计比况对非运别性线质据求口工。根规生称手声方质话电共社属。需史果些书四象快近思段调元话带。法表月打响商近团离程军区型干办难。',
'330000199301284869',
'2017-01-07',
'1975-10-14',
'http://dummyimage.com/100×100/d579f2/757575.png&text=Robinson',
'男'),
​
('610000202207151439',
true,
true,
false,
true,
'ChristopherWilson339',
'(K%}dOF@',
'Thomas',
'13160788527',
'r.tfuuwjwub@crch.lc',
'袁杰',
'相力群量十存期月酸山且门问把建。只人强心步将铁得被一那许何个立。实几支明选千部却温矿持或由京元干每。外造立样身市还温活说他识例。',
'610000202207151439',
'2003-11-25',
'2014-07-27',
'http://dummyimage.com/100×100/79f2b2/757575.png&text=Thomas',
'女'),
​
('610000200801201719',
false,
true,
false,
true,
'HelenThompson734',
'CI*i)PI8',
'Young',
'17337732738',
'm.pfsaifang@vkhlu.hn',
'于秀兰',
'会上马改同约片变标龙带展参想不家合。布号角北达政严得叫做放设出几儿年记。院目调军公压感江号十世出极化农性。四果在土世儿引对类着面白即。作酸林两住起联究始运都军后保先。',
'610000200801201719',
'1986-08-20',
'2013-03-20',
'http://dummyimage.com/100×100/f28e79/757575.png&text=Young',
'女'),
​
('230000197704257483',
false,
false,
false,
false,
'BrendaTaylor684',
'DSNl_;ub',
'Jackson',
'14230993227',
't.gkq@eivjonn.ma',
'范静',
'段温商解声导温农农元所米因无断先照。要南听员至风还约七思例参海有光又。海经增离家阶把目学真实片性品。么议约主实县程经行理解属县眼做十真。还今这连数人存情来只进务片主本内回国。容问当近金常向员影单情海件什至门实北。',
'230000197704257483',
'2014-04-28',
'1976-12-18',
'http://dummyimage.com/100×100/7986f2/757575.png&text=Jackson',
'男'),
​
('340000201802244744',
false,
true,
false,
true,
'MaryRobinson542',
'DjaPn&|>',
'Brown',
'14855119202',
'y.djvemqmdxf@dojsku.kg',
'董平',
'酸已引斗行象面展么算派料切装者办。连感革头元是油东书离了变正话军。片下么一广断其变风七研热文术约南压。示先住前铁军深什王小政水领节史干。相只明料构白音合路效等飞想与设。',
'340000201802244744',
'2013-11-12',
'1981-02-05',
'http://dummyimage.com/100×100/aaf279/757575.png&text=Brown',
'男'),
​
('530000199808252695',
false,
true,
false,
false,
'JenniferThompson865',
'k5?b1{b1',
'Hall',
'15646131360',
'p.jjlcpj@qyo.museum',
'吴霞',
'适非见查据打万近计并但世联难记入。厂始织经角着先八量研节写规外阶把。细相也龙数月队民组物团步定。开总自育自证半想置于必油。查之其年构参究石始效花员收院路资。正按利开始亲与土三及准门。',
'530000199808252695',
'1979-03-25',
'2023-12-18',
'http://dummyimage.com/100×100/f279cd/757575.png&text=Hall',
'女'),
​
('370000198702101130',
true,
false,
true,
false,
'AngelaHall880',
'5h{a!h,
0',
'Walker',
'13783463255',
'a.wctr@dnfpqu.an',
'邓敏',
'达学自界调写须压议属器向按。历极列研运火化法名准年线积。族片回太值八族中接群选场响叫然新设。',
'370000198702101130',
'2006-06-17',
'2003-11-17',
'http://dummyimage.com/100×100/79f0f2/757575.png&text=Walker',
'男'),
​
('110000201908274578',
false,
true,
false,
false,
'ThomasLopez192',
'@Dn)?1Ll',
'Hall',
'14797021288',
'k.cja@tyod.cu',
'贺静',
'市相事着使存物离消通她增格议。听要温示而联象才感少住支查算教理打来。等明四确水器研还级专同斗定专东机。该其及基没打导求地养收革华众术例准干。小它队通安走六月型局率术。',
'110000201908274578',
'1973-06-24',
'1994-03-26',
'http://dummyimage.com/100×100/f2d079/757575.png&text=Hall',
'女'),
​
('440000197302080186',
false,
false,
false,
false,
'StevenMoore698',
'zKB?(SUq',
'Johnson',
'15728208190',
'b.cawgdyfrg@venktp.eg',
'吕平',
'专状民角指建状口无规联算门容门存头极。思元题己根低受京作手表现道志。四解心结象重保半边处声局角而目问规。构众最建连节必员发南存区每。二月象现问任也准规方步从西业并所想。联总使按院美进果其总矿低金装展。',
'440000197302080186',
'2022-05-02',
'2023-06-12',
'http://dummyimage.com/100×100/ad79f2/757575.png&text=Johnson',
'女'),
​
('510000201112096125',
true,
true,
true,
false,
'TimothyWilliams607',
';sG.v(re',
'Walker',
'14043225349',
'q.hujtqume@qsomwthf.info',
'曾军',
'它制场集与今此心化题按农三西动至。效确价主名为已或成知九交。千工严五路议很会三所这程见议少。走验维马这头入价至度报计。被在己系比理写行通计验结。',
'510000201112096125',
'1977-02-26',
'1979-04-11',
'http://dummyimage.com/100×100/79f289/757575.png&text=Walker',
'女'),
​
('110000201510030418',
false,
true,
true,
false,
'DanielDavis764',
';cI8MyDj',
'Anderson',
'14261225543',
't.iddjbutni@moiwglqk.ws',
'杨秀兰',
'报和革往响活北科压百律山可。议入快安个基空得却门不数。教国感题明构正子心存我五。',
'110000201510030418',
'1971-03-09',
'1983-10-06',
'http://dummyimage.com/100×100/f2798b/757575.png&text=Anderson',
'男'),
​
('500000197301308667',
true,
false,
true,
false,
'SandraGarcia717',
'vuNh9c)D',
'White',
'18567807844',
'p.yhqgkf@owlgei.re',
'潘娟',
'意相定较争住结影日每我建点质收果计江。系社离极元作术委越提速人光法。严期门的得科观每几分确住层进状求快。号这你向六已面速应消眼积名观较老。',
'500000197301308667',
'2012-09-19',
'1977-12-23',
'http://dummyimage.com/100×100/79aff2/757575.png&text=White',
'男'),
​
('640000200508302874',
true,
false,
true,
true,
'ThomasJones268',
'*7<(-M%h',
'Lopez',
'17424567148',
'h.qsiouvjji@vwhptybnw.tm',
'马桂英',
'七斯地各可划史该调离内达至。海化展直素省王半酸情复京社义只合。商厂求千史方现被话民满象到。深色很问织调做须铁建水到铁。况团片理包己三度住响意查联。',
'640000200508302874',
'2001-10-19',
'1991-09-20',
'http://dummyimage.com/100×100/d2f279/757575.png&text=Lopez',
'女'),
​
('460000200804188603',
true,
true,
true,
true,
'CynthiaYoung633',
'Fmk?fp$n',
'Williams',
'15652863496',
'm.goxcs@qok.mx',
'胡明',
'性算非气习又引队离常具县关不拉。变争机法自格精十体议具老带路最。建安华身断之实增里准规斗者许式积知命。报安般规持提引没着圆把领带文住有格。',
'460000200804188603',
'2024-04-01',
'1980-07-24',
'http://dummyimage.com/100×100/ee79f2/757575.png&text=Williams',
'男'),
​
('460000199709141270',
true,
false,
true,
false,
'MatthewWalker906',
'GC%-gd<S',
'Johnson',
'17062552121',
'e.lbyk@drdm.sz',
'郑平',
'系族采信参各按因江新通到。社正领计进八格部存光与采也。采许化道热来米住安复们热收器养才己。场为同基很同管己位看总克重家中。',
'460000199709141270',
'2003-06-09',
'1973-11-21',
'http://dummyimage.com/100×100/79f2cb/757575.png&text=Johnson',
'女'),
​
('520000198903243280',
false,
false,
true,
false,
'KarenJones289',
'(m=A2*!#',
'Gonzalez',
'13186045616',
'k.xnphnms@breloien.be',
'孙霞',
'斗情存场置上直能日经品查。它七管术较产证众花什厂布己会适千斯写。积头点下采适直力区认现队流火别如。',
'520000198903243280',
'1973-07-28',
'1999-07-31',
'http://dummyimage.com/100×100/f2a779/757575.png&text=Gonzalez',
'男'),
​
('360000201512098578',
true,
false,
false,
true,
'CarolWilliams190',
'@)3?N>lN',
'Lopez',
'18037384118',
'w.isyvxrdbok@lpbndlhdo.bb',
'郑磊',
'王教受点当派走周完验与京权算直同着。本口性按处属动素基包且边利对。厂角图条安统基公价条加公中件办。格十器书名机比如马话转西量面严如次。',
'360000201512098578',
'1993-04-04',
'2016-07-09',
'http://dummyimage.com/100×100/8479f2/757575.png&text=Lopez',
'男'),
​
('150000201707022689',
false,
false,
true,
true,
'SharonMartinez730',
'zL{c:cI-',
'Davis',
'18349385375',
'c.noivkwt@drdtdydeew.mt',
'周强',
'长海叫布必她际次满心理变感。做府矿党争市院张各县劳子状。物水资信儿各照格他间在关。务联资断器难动根本对党况。且计整国节确加界活样组江听响飞期后打。建争快强些整民统天图温党易响除拉道。',
'150000201707022689',
'2021-11-25',
'1980-10-21',
'http://dummyimage.com/100×100/91f279/757575.png&text=Davis',
'男'),
​
('210000202205245867',
false,
false,
true,
false,
'MichaelYoung739',
'J^?217|B',
'Jackson',
'18466277923',
'l.lgndsxk@ezbmgxs.dk',
'彭杰',
'应品身清县代三识那已都设。深子计统造心类代科张已化料证近。务算社约里电成建该积酸认度。场样求前也向音东议研技节话高进。',
'210000202205245867',
'2002-03-12',
'2014-10-11',
'http://dummyimage.com/100×100/f279b4/757575.png&text=Jackson',
'男'),
​
('710000201810298223',
true,
true,
false,
false,
'JenniferMartin889',
'8#6zlpb_',
'Perez',
'13019407628',
's.cpnt@rux.pn',
'史霞',
'交证论号你往道把们命更分真明。容党为所万此土机如来万空界界。系打是济相真布东具市形地线起。约九严等数便日用低积时素话速织转。',
'710000201810298223',
'2008-07-22',
'2010-12-12',
'http://dummyimage.com/100×100/79d7f2/757575.png&text=Perez',
'女'),
​
('150000198006096146',
false,
false,
false,
true,
'BrendaJohnson466',
'D.BH+&K0',
'Taylor',
'14162957896',
'o.qvko@blstsi.dm',
'汪秀英',
'前定油制清基带力老为和管算。正众我已南影容干性商连参。也叫真活社证后造红时部问与性离拉。上联北社标容器装要置们风要组才议外。门群将该置北最没太走线把教目选习头。',
'150000198006096146',
'2023-08-04',
'1970-12-23',
'http://dummyimage.com/100×100/f2e979/757575.png&text=Taylor',
'男'),
​
('150000200010265264',
false,
true,
true,
true,
'JoseLopez494',
'h8{>9unB',
'White',
'17515903745',
'e.zpr@xtkek.ht',
'程敏',
'北组都响铁际里越义过往志米。里石战南候件音原好所火该律任构快。就点学说外养眼学实决山规一外习圆。力知派达出重支色走也眼式认例比何没完。',
'150000200010265264',
'2017-03-05',
'1994-06-30',
'http://dummyimage.com/100×100/c679f2/757575.png&text=White',
'男'),
​
('820000197111052829',
true,
false,
true,
true,
'JohnWilliams505',
'guQfVI((',
'Lee',
'17850420553',
'g.ijgglexml@bfedhk.org.cn',
'冯艳',
'团面类内从一约体程面专往带精办持。导价行各便极军至儿法可党流就区平在或。专候备己又使第复必算五意容近养原。先斗示住按王电离领六断往按三。区思间难也多造样土中相置分我民产。改面设出它不基说解所信样象平革社。',
'820000197111052829',
'1979-10-16',
'1971-07-20',
'http://dummyimage.com/100×100/79f2a2/757575.png&text=Lee',
'男'),
​
('500000197503218002',
false,
true,
false,
true,
'ThomasClark956',
'Cl:)N!{2',
'Martinez',
'15708644024',
'n.oeqedqgnwk@srq.dk',
'袁平',
'即近志持以济便外列毛并世当。为边日管加法写分性机次点形验。确行布起王各想者极其志候铁上着。真局发队叫张拉易加而存连。前油广义连压想公导意领平交元分。形识号权放划走的证结点指。',
'500000197503218002',
'1971-06-17',
'1971-02-13',
'http://dummyimage.com/100×100/f27f79/757575.png&text=Martinez',
'女'),
​
('500000200802093136',
false,
false,
false,
false,
'RobertGonzalez821',
'fFM*DDFN',
'Miller',
'15571879705',
'u.fhthw@yxjkvxth.cv',
'程艳',
'文算她改水已你力至什军办断快在条。平别每众元支队内基者属特酸。元儿如军术两处片科处队其响公年门教五。无群行然科于具分门对最集东结布之。',
'500000200802093136',
'1978-07-25',
'2022-05-11',
'http://dummyimage.com/100×100/7996f2/757575.png&text=Miller',
'女'),
​
('510000201608182334',
false,
true,
true,
false,
'AnnaJohnson932',
'u-6NzxOa',
'Lopez',
'15867871359',
'n.phehix@sbnhzn.pm',
'曹桂英',
'空北打对看满取置角一候山。身增他给专名基分育支存除命少机有斗。解满做问装斯当价表新指路目今且住认。节说没角上其研果着战你片济效按极物红。劳状历连来体府性解管点区。今派地引才计一识响住单作步与物技。转科意研低去毛资文现之劳装明装 
前。',
'510000201608182334',
'2018-09-10',
'2008-01-04',
'http://dummyimage.com/100×100/b9f279/757575.png&text=Lopez',
'男'),
​
('21000020020825951',
false,
false,
true,
true,
'BrianHernandez553',
'xd_S8*VD',
'Miller',
'13972017466',
'e.ngkd@dkmjq.pk',
'余丽',
'办常被军业严作带眼规的思龙用。当六白王技步起石无动习可员时些此。消社军马油万南马不地经与包质铁观。半使说单联满保低即条话清加行分专头起。',
'21000020020825951',
'1971-12-16',
'2009-11-15',
'http://dummyimage.com/100×100/f279dc/757575.png&text=Miller',
'女'),
​
('460000201103246203',
true,
false,
true,
true,
'DonaldMartin316',
'=<WzhNBR',
'Allen',
'18898732840',
'y.okgmng@optk.at',
'孔秀英',
'长族事府满论周七九常接适再。县思拉同通增整次能专矿国打任机。严矿无劳但离关提专要改儿六必见。叫再情造器老和三很区相之眼过把亲。状白那属构切质回确整几次什。段受史目去电采老根很引不量院形天做。',
'460000201103246203',
'1990-01-06',
'2011-10-20',
'http://dummyimage.com/100×100/79f2e4/757575.png&text=Allen',
'女'),
​
('110000198811012278',
false,
true,
false,
false,
'RobertJackson186',
'G=bL>@A.',
'Jackson',
'17830747645',
'k.lxekt@csdrtho.ua',
'胡丽',
'保建元铁代业度位组上边则用。识性建史往西变资温安题际机儿。比得听值定其放使书革验指青平什全很。置于研线等活时正手往写引老现价体。规明及代热感都经响斗织养龙公存和。比特联机党质基可走放由当则本立世。',
'110000198811012278',
'1987-07-02',
'2016-08-21',
'http://dummyimage.com/100×100/f2c079/757575.png&text=Jackson',
'女'),
​
('210000201401165341',
true,
false,
false,
false,
'DeborahMoore361',
'86?u?!(l',
'Garcia',
'14749193347',
'b.occgi@tlpey.cg',
'罗平',
'西件标流按系使重并期标传体亲们并史相。作世身南究深办体身铁那即口复。产所那于团他党平合世新近和从需或人先。般为光研前形分技院新采队调。价两意级好备出作日速代此。按太复科制广究使命文存记米已。',
'210000201401165341',
'1978-03-31',
'2015-03-25',
'http://dummyimage.com/100×100/9d79f2/757575.png&text=Garcia',
'女'),
​
('120000198509109118',
false,
true,
false,
true,
'JohnAnderson629',
'UyP59TPl',
'Lopez',
'15426909703',
'l.xpztiwe@cgd.中国',
'龚秀英',
'写今相当权给适其社况信华志称意学火。美可指家增产存马四样那部史象果在完制。后们治存更体者记资车什口飞厂小团运。克领断部重下强石听形动统别。自并它价被按了取单研消什开给儿系。飞具习分精方术个手石火级报九都支西反。',
'120000198509109118',
'1993-07-01',
'2004-01-30',
'http://dummyimage.com/100×100/79f27a/757575.png&text=Lopez',
'男'),
​
('530000201401200893',
true,
true,
false,
false,
'CynthiaMartin574',
'Nv<0;z9D',
'Martinez',
'17751605047',
'v.yoqwmuei@ovdbr.tv',
'廖杰',
'民决能知青价派资标火维象劳提五看厂。多求其型备收西风话使备深治感支。时更土器它命生期必体同满代流维长。片山进回级并作果土列果半知周类。',
'530000201401200893',
'1974-10-02',
'1988-04-09',
'http://dummyimage.com/100×100/f2799b/757575.png&text=Martinez',
'男'),
​
('640000202211257389',
true,
false,
false,
true,
'AngelaSmith474',
'rjtU-S+}',
'Jones',
'17811446188',
'q.hifubw@qhulqbslcn.cn',
'沈芳',
'世备土人化并前政们习美众白问。划置向他办年历该型志那量深查。包工价目点整群第了日要物决龙收总。建单引系加金区再取以经则数解。月多指统本因积实九情面个提。',
'640000202211257389',
'1997-08-20',
'1971-06-04',
'http://dummyimage.com/100×100/79bef2/757575.png&text=Jones',
'女'),
​
('440000201408220801',
true,
false,
true,
true,
'JoseClark508',
':2SB0SN.',
'Davis',
'14105723787',
'u.oit@qxngazmpp.iq',
'丁明',
'北点应以斗交与着文志养商进件。且思反无本容规包什影低什。响表色边照民验名按年行明列产。中地备根整场政引并重打属。料元没消题走流打给以说报设加油两少米。',
'440000201408220801',
'2023-06-28',
'2002-05-11',
'http://dummyimage.com/100×100/e2f279/757575.png&text=Davis',
'女'),
​
('450000201606055693',
true,
false,
false,
true,
'LisaMiller227',
'3|QEC<!p',
'Perez',
'17627812386',
'p.jfih@lbjrs.ge',
'夏霞',
'报思地世具即志打备与没除被复。界完争就百县他意千后它空性型。拉合种生认油九器便些表持水。好线六重府非权许传接商强往条节海。',
'450000201606055693',
'1996-09-23',
'1984-08-06',
'http://dummyimage.com/100×100/df79f2/757575.png&text=Perez',
'男')

• 结果: