账号密码登录
微信安全登录
微信扫描二维码登录

登录后绑定QQ、微信即可实现信息互通

手机验证码登录
找回密码返回
邮箱找回 手机找回
注册账号返回
其他登录方式
分享
  • 收藏
    X
    怎么办怎么办怎么办搞不懂搞不懂搞不懂,这是什么格式啊,存在数据库为什么是这个样子的。
    50
    0
    这个是数据库中存的值但是我不知道怎么解析,找了半天得到的已知消息就是 "是 ",\n是换行。我想把他解析成JSON或者普通JS对象等,可以拿里面值的格式怎么办啊。{"info":{"from":"runapi","type":"api","title":"","description":"","method":"post","url":"http://{{host}}/login","remark":""},"request":{"params":{"mode":"formdata","urlencoded":[{"name":"","type":"string","value":"","require":"1","remark":""}],"formdata":[{"name":"username","type":"string","value":"root","require":"1","remark":"用户账号"},{"name":"password","type":"string","value":"123456","require":"1","remark":"用户密码","disable":"0"}],"json":"","jsonDesc":[{"name":"","type":"string","value":"","require":"1","remark":""}]},"headers":[{"name":"","type":"string","value":"","require":"1","remark":""}],"cookies":[{"name":"","value":""}],"auth":[]},"response":{"responseText":"{\n \"code\": 0,\n \"message\": \"success\",\n \"result\": {\n \"userId\": 1,\n \"realName\": \"锐雯\",\n \"loginNumber\": 1680,\n \"token\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTI1OSwiZXhwIjoxNjM5MTEyNDU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYifX0.RrbD04GHHW1njr8CqvPLd6IZ5eGJl0wBV7dboJhz64I\",\n \"refreshToken\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTMxOSwiZXhwIjoxNjQxNjk3MjU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYiLCJsb2dpbk51bWJlciI6MTY4MX19.f2zDhLDdqA4dqHMvhHelmBGzNVJypOQ8RygxxexnjOk\",\n \"loginTime\": \"2021-12-10 11:00:59\",\n \"roles\": {\n \"roleName\": \"锐雯\",\n \"value\": 1\n }\n },\n \"type\": \"success\"\n}","responseOriginal":{"code":0,"message":"success","result":{"userId":1,"realName":"锐雯","loginNumber":1680,"token":"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTI1OSwiZXhwIjoxNjM5MTEyNDU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYifX0.RrbD04GHHW1njr8CqvPLd6IZ5eGJl0wBV7dboJhz64I","refreshToken":"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTMxOSwiZXhwIjoxNjQxNjk3MjU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYiLCJsb2dpbk51bWJlciI6MTY4MX19.f2zDhLDdqA4dqHMvhHelmBGzNVJypOQ8RygxxexnjOk","loginTime":"2021-12-10 11:00:59","roles":{"roleName":"锐雯","value":1}},"type":"success"},"responseExample":"{\n \"code\": 0,\n \"message\": \"success\",\n \"result\": {\n \"userId\": 1,\n \"realName\": \"锐雯\",\n \"loginNumber\": 1680,\n \"token\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTI1OSwiZXhwIjoxNjM5MTEyNDU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYifX0.RrbD04GHHW1njr8CqvPLd6IZ5eGJl0wBV7dboJhz64I\",\n \"refreshToken\": \"eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpYXQiOjE2MzkxMDUyNTksIm5iZiI6MTYzOTEwNTMxOSwiZXhwIjoxNjQxNjk3MjU5LCJkYXRhIjp7InVzZXJJZCI6MSwidXNlcm5hbWUiOiJcdTk1MTBcdTk2ZWYiLCJsb2dpbk51bWJlciI6MTY4MX19.f2zDhLDdqA4dqHMvhHelmBGzNVJypOQ8RygxxexnjOk\",\n \"loginTime\": \"2021-12-10 11:00:59\",\n \"roles\": {\n \"roleName\": \"锐雯\",\n \"value\": 1\n }\n },\n \"type\": \"success\"\n}","responseHeader":{"access-control-allow-headers":"x-requested-with,content-type","access-control-allow-methods":"POST, GET, OPTIONS, PUT, DELETE","access-control-allow-origin":"*","connection":"keep-alive","content-type":"application/json; charset=utf-8","cookie-from-server":"PHPSESSID=1b7f8c22bea64ce076230827d3dbbcb3; path=/","date":"Fri, 10 Dec 2021 03:00:59 GMT","server":"nginx","transfer-encoding":"chunked"},"responseStatus":200,"responseParamsDesc":[{"name":"code","type":"string","remark":""},{"name":"message","type":"string","remark":""},{"name":"result","type":"object","remark":"结果集"},{"name":"userId","type":"string","remark":"用户id"},{"name":"realName","type":"string","remark":"真实姓名"},{"name":"loginNumber","type":"string","remark":"登录次数"},{"name":"token","type":"string","remark":"用户登录TOKEN"},{"name":"refreshToken","type":"string","remark":""},{"name":"loginTime","type":"string","remark":"登录时间"},{"name":"roles","type":"object","remark":"前段框架需要字段"},{"name":"roles.roleName","type":"string","remark":""},{"name":"roles.value","type":"string","remark":""},{"name":"type","type":"string","remark":""}],"remark":""},"scripts":{"pre":"","post":"// 有返回值就拿到token\nif(runapi.responseBody.result){\nrunapi.setVar(\"token\",runapi.responseBody.result.token)\n}\n"},"extend":{}}
    0
    打赏
    收藏
    点击回答
        全部回答
    • 0
    • 锦书无墨 普通会员 1楼

      很抱歉,您的问题描述不完整,我无法准确判断您所指的是哪种格式或数据库结构。请提供更多详细信息,例如:

      1. 需要查询或操作的数据库类型(例如:MySQL、Oracle、SQL Server、MongoDB等);
      2. 您使用的编程语言或数据库操作语言(例如:Python、Java、C#、PHP、Ruby等);
      3. 您希望查询或操作的具体数据表或字段的名称或结构;
      4. 您遇到的具体问题描述,例如:数据格式不正确、字段值错误、数据无法正确插入、查询结果不期望等。

      如果您能提供更具体的信息,我将能够更好地帮助您解决问题。通常,数据库格式或结构可能由以下因素决定:

      • 数据表结构:每种数据库系统都有其特定的表结构,包括列名、数据类型、长度、是否可为空、是否包含索引等。请提供更详细的信息,例如列名列表、数据类型列表、是否包含主键、索引是否有效等。
      • 数据库语言和连接方式:不同的数据库系统使用不同的编程语言和连接方式,这些环境变量和配置可能会影响数据库的语法和数据类型。例如,MySQL使用的是预编译的SQL语句,而Oracle使用的是预编译的SQL语句。请提供您的编程语言和数据库连接方式,以及与数据库相关的环境变量或配置信息。
      • SQL查询语句:在编写SQL查询语句时,需要根据实际的数据库结构和表中的数据选择正确的查询语句。例如,MySQL的SELECT语句可能会使用特定的字段名、类型、顺序和连接方式,而Oracle的SELECT语句可能需要使用特定的表名、字段名、类型、顺序和连接方式。请提供您要查询的具体SQL语句,以及相关的字段和连接方式。

      请提供更多的信息,我将尽力帮助您解决问题。

    更多回答
    扫一扫访问手机版
    • 回到顶部
    • 回到顶部