关于把数据写进mysql的问题
前辈们，我想把下面的json数据用java写进mysql，该怎么做啊？第一次做这个，完全没有思路啊！{"Citys":[{"areacode":"8977260037","areaname":"华北","citychpy":"BaoTou","citycode":"472","cityname":"包头","first
cap":"B","privincode":"","privinname":"","state":0,"wdcode":"","wpwcode":""},{"areacode":"2674441062","areanam
e":"华东","citychpy":"BangBu","citycode":"552","cityname":"蚌埠","firstcap":"B","privincode":"","privinname":"","s
tate":0,"wdcode":"","wpwcode":""},{"areacode":"8977260037","areaname":"华北","citychpy":"BeiJing","citycode":"11
0","cityname":"北京","firstcap":"B","privincode":"","privinname":"","state":0,"wdcode":"","wpwcode":""},{"areaco
de":"","areaname":"","citychpy":"BaoJi","citycode":"917","cityname":"宝鸡","firstcap":"B","privincode":"","privi
nname":"","state":0,"wdcode":"","wpwcode":""},{"areacode":"1127309790","areaname":"西南","citychpy":"ChongQing",
"citycode":"023","cityname":"重庆","firstcap":"C","privincode":"","privinname":"","state":0,"wdcode":"","wpwcode
":""},{"areacode":"1477181664","areaname":"华中","citychpy":"ChangSha","citycode":"731","cityname":"长沙","firstca
p":"C","privincode":"","privinname":"","state":0,"wdcode":"","wpwcode":""},{"areacode":"5654710939","areaname"
:"东北","citychpy":"ChangChun","citycode":"431","cityname":"长春","firstcap":"C","privincode":"","privinname":"","
state":0,"wdcode":"","wpwcode":""},{"areacode":"8082438251","areaname":"西
北","citychpy":"HanZhong","citycode":"916","cityname":"汉中","firstcap":"H","privincode":"","privinname":"","stat
e":0,"wdcode":"","wpwcode":""},{"areacode":"1477181664","areanam
e":"华中","citychpy":"ZhouKou","citycode":"394","cityname":"周口","firstcap":"Z","privincode":"","privinname":"","
state":0,"wdcode":"","wpwcode":""},{"areacode":"","areaname":"","citychpy":"ZhanJiang","citycode":"759","cityn
ame":"湛江","firstcap":"Z","privincode":"","privinname":"","state":0,"wdcode":"","wpwcode":""}],"retCode":"0000"
,"retMsg":"成功"}
mysql
json
--------------------编程问答--------------------
如果我把这些内容全部转换成了xml文件的那种标签形式，有没有办法直接用xpath得到指定节点的数据的？
--------------------编程问答--------------------
具体说下需求吧。
--------------------编程问答--------------------
就是要把从指定的网址得到的这些JSON数据按照几个大区写进mysql，几个大区像这样分：华北，华南，东北．．． 然后 最后是些一个页面 然后让用户已登录这个页面就 把这些数据写入到mysql！能帮一下忙吗？大虾。。。
急用。。。
--------------------编程问答--------------------
就是要把从指定的网址得到的这些JSON数据按照几个大区写进mysql，几个大区像这样分：华北，华南，东北．．． 然后最好是写一个页面 然后让用户一登录这个页面就把这些数据写入到mysql里面！能帮一下忙吗？大虾。。。急用。。。 --------------------编程问答-------------------- 我的方法先：把json格式的数据转换下。写个共通的类。然后一条条的插入。做例子的。今天上班了。估计没时间。你上网找找肯定有。见谅，昨天放假。后来出去玩了。在给看帖子 --------------------编程问答-------------------- 没事。。谢谢你的回答。我是已经把json格式的数据转成了标签形式的数据啊。。但是还是不符合xml格式。。我是想，要是能转成xml形式的数据，直接用xpath就好办的多了 --------------------编程问答-------------------- 用第三方jar包（比如：gson） 将json格式数据转成list类型 然后在存入数据库
--------------------编程问答-------------------- 有这么好的包啊？有没有下载地址啊？没有我就去看看能不能百度的到 --------------------编程问答-------------------- 直接百度gson就行 --------------------编程问答-------------------- 楼主的问题解决了吗？同求~~不会啊啊啊~~~ --------------------编程问答-------------------- 1.定义一个JAVABEAN ,属性名就是json串中的key名，然后使用下面的方法转化为类
采用 public static <T> T toBean(Object object, Class<T> beanClass)
{
JSONObject jsonObject = JSONObject.fromObject(object);
return (T) JSONObject.toBean(jsonObject, beanClass);
}
补充：Java , Java相关
