mysql5.7 json jdbc,MySQL 5.7 对JSON的支持

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

开启事务

mysql> select * from json_test;

+-----+-------------------------------------------------------------------+-----------+

| uid | data                                                              | user_name |

+-----+-------------------------------------------------------------------+-----------+

|   1 | {"name": "name1", "amount": 400, "mobile": "15044447279"}         | "name1"   |

|   2 | {"name": "name1", "amount": 300, "mobile": "15044447279"}         | "name1"   |

|   3 | {"name": "name2", "amount": 300, "mobile": "15044447278"}         | "name2"   |

|   4 | {"name": "name3", "amount": 300, "mobile": "15044447277"}         | "name3"   |

|   5 | {"amount": 300, "mobile": "15044447277"}                          | NULL      |

|   6 | {"amount": "300", "name”:”name2”,”mobile": "15044447278"}         | NULL      |

+-----+-------------------------------------------------------------------+-----------+

查看原表。

mysql> insert into json_test (uid,data)  values (NULL, '{"name":"name1","mobile":"15044447279","amount":300}');

Query OK, 1 row affected (0.00 sec)

插入新数据

mysql> select * from json_test;                                                                                                                                                                             +-----+-------------------------------------------------------------------+-----------+

| uid | data                                                              | user_name |

+-----+-------------------------------------------------------------------+-----------+

|   1 | {"name": "name1", "amount": 400, "mobile": "15044447279"}         | "name1"   |

|   2 | {"name": "name1", "amount": 300, "mobile": "15044447279"}         | "name1"   |

|   3 | {"name": "name2", "amount": 300, "mobile": "15044447278"}         | "name2"   |

|   4 | {"name": "name3", "amount": 300, "mobile": "15044447277"}         | "name3"   |

|   5 | {"amount": 300, "mobile": "15044447277"}                          | NULL      |

|   6 | {"amount": "300", "name”:”name2”,”mobile": "15044447278"}         | NULL      |

|   7 | {"name": "name1", "amount": 300, "mobile": "15044447279"}         | "name1"   |

+-----+-------------------------------------------------------------------+-----------+

7 rows in set (0.00 sec)

确认新数据

mysql> rollback;

回滚数据

mysql> select * from json_test;

+-----+-------------------------------------------------------------------+-----------+

| uid | data                                                              | user_name |

+-----+-------------------------------------------------------------------+-----------+

|   1 | {"name": "name1", "amount": 400, "mobile": "15044447279"}         | "name1"   |

|   2 | {"name": "name1", "amount": 300, "mobile": "15044447279"}         | "name1"   |

|   3 | {"name": "name2", "amount": 300, "mobile": "15044447278"}         | "name2"   |

|   4 | {"name": "name3", "amount": 300, "mobile": "15044447277"}         | "name3"   |

|   5 | {"amount": 300, "mobile": "15044447277"}                          | NULL      |

|   6 | {"amount": "300", "name”:”name2”,”mobile": "15044447278"}         | NULL      |

+-----+-------------------------------------------------------------------+-----------+

6 rows in set (0.00 sec)