关于json格式字符串解析并用mybatis存入数据库
园子里面找了很多关于json解析后存入数据库的方法，不是太乱，就是没有写完，我下面的主题代码多是受下面两位的启发，请按顺序查看
http://www.cnblogs.com/tian830937/p/6364622.html,我沿用了这个例子中的json数据格式，多层嵌套。
http://blog.csdn.net/baicp3/article/details/46711067，这个例子虽然是反例，但是引出了JsonArray。方便后续开发。
看完明白上面两个例子后，我们就可以开始了。（注意：没有看懂上面的例子请先看懂，当然，下面的代码复制过去都能用的，最主要是理解）
1.包，请到http://maven.aliyun.com获取，然后复制到pom.xml中
2.配置mybatis.xml，文件放在resource文件夹下，关于数据库的连接就不多讲，照代码中做就是
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:util="http://www.springframework.org/schema/util" xmlns:jpa="http://www.springframework.org/schema/data/jpa" xsi:schemaLocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.2.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-3.2.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.2.xsd http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.2.xsd http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.2.xsd"> <!-- 配置连接mysql --> <!-- 已测试 --> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"> <property name="driverClassName" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/（数据库名）?useUnicode=true&characterEncoding=utf8"/><!-- localhost:3307 --> <property name="username" value="root"/> <property name="password" value="123456"/> </bean> <!-- 配置MyBatis mapper接口扫描 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="mapperLocations" value="classpath:（mapper文件夹名）/*.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <!-- <property name="sqlSessionFactory" ref="sqlSessionFactory"/> --> <property name="basePackage" value="（项目dao层的位置，如：xxx.xxx.dao）"/> </bean> </beans>
3.设计实体类(实体类是按照要解析的json数据确定的)
student实体类
package com.bean;
import java.util.Map;
public class Student {
private int age;//年龄
private String gender;//性别，male/female
private String grades;//班级
private String name;//姓名
private Map<String, Double> score;//各科分数
private String scoreId;
private Double weight;//体重
public Student() {
// TODO Auto-generated constructor stub
}
public Student(int age, String gender, String grades, String name, String scoreId, Double weight) {
super();
this.age = age;
this.gender = gender;
this.grades = grades;
this.name = name;
this.weight = weight;
this.scoreId=scoreId;
}
public String getScoreId() {
return scoreId;
}
public void setScoreId(String scoreId) {
this.scoreId = scoreId;
}
public Double getWeight() {
return weight;
}
public void setWeight(Double weight) {
this.weight = weight;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getGender() {
return gender;
}
public void setGender(String gender) {
this.gender = gender;
}
public String getGrades() {
return grades;
}
public void setGrades(String grades) {
this.grades = grades;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Map<String, Double> getScore() {
return score;
}
public void setScore(Map<String, Double> score) {
this.score = score;
}
@Override
public String toString() {
return "Student [age=" + age + ", gender=" + gender + ", grades=" + grades + ", name=" + name + ", score="
+ score + ", weight=" + weight + "]";
}
}
Score实体类
package com.bean; public class Score { private String scoreId; private Double Networkprotocol;//网络协议 private Double javaEE; private Double Computerbasis;//计算机基础 private Double Linuxoperatingsystem;//Linux操作系统 private Double networksecurity;//网络安全 private Double SQLdatabase;//Sql数据库 private Double datastructure;//数据结构 public Score() { // TODO Auto-generated constructor stub } public Score(String scoreId, Double networkprotocol, Double javaEE, Double computerbasis, Double linuxoperatingsystem, Double networksecurity, Double sQLdatabase, Double datastructure) { super(); this.scoreId = scoreId; Networkprotocol = networkprotocol; this.javaEE = javaEE; Computerbasis = computerbasis; Linuxoperatingsystem = linuxoperatingsystem; this.networksecurity = networksecurity; SQLdatabase = sQLdatabase; this.datastructure = datastructure; } public String getScoreId() { return scoreId; } public void setScoreId(String scoreId) { this.scoreId = scoreId; } public Double getNetworkprotocol() { return Networkprotocol; } public void setNetworkprotocol(Double networkprotocol) { Networkprotocol = networkprotocol; } public Double getJavaEE() { return javaEE; } public void setJavaEE(Double javaEE) { this.javaEE = javaEE; } public Double getComputerbasis() { return Computerbasis; } public void setComputerbasis(Double computerbasis) { Computerbasis = computerbasis; } public Double getLinuxoperatingsystem() { return Linuxoperatingsystem; } public void setLinuxoperatingsystem(Double linuxoperatingsystem) { Linuxoperatingsystem = linuxoperatingsystem; } public Double getNetworksecurity() { return networksecurity; } public void setNetworksecurity(Double networksecurity) { this.networksecurity = networksecurity; } public Double getSQLdatabase() { return SQLdatabase; } public void setSQLdatabase(Double sQLdatabase) { SQLdatabase = sQLdatabase; } public Double getDatastructure() { return datastructure; } public void setDatastructure(Double datastructure) { this.datastructure = datastructure; } @Override public String toString() { return "Score [scoreId=" + scoreId + ", Networkprotocol=" + Networkprotocol + ", javaEE=" + javaEE + ", Computerbasis=" + Computerbasis + ", Linuxoperatingsystem=" + Linuxoperatingsystem + ", networksecurity=" + networksecurity + ", SQLdatabase=" + SQLdatabase + ", datastructure=" + datastructure + "]"; } }
4.配置dao，建立dao接口
package company.order.dao; import com.bean.Score; import com.bean.Student; public interface TestDao { int addStudent(Student student); int addScore(Score score); }
5.设计数据库表结构
student表结构
score表结构
6.配置mapper.xml，注意修改路径
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="company.order.dao.TestDao">
<!--测试将json解析的数据存入到数据库 -->
<insert id="addStudent" parameterType="com.bean.Student">
insert into student(
age,
gender,
grades,
name,
scoreId,
weight
)values(
#{age},
#{gender},
#{grades},
#{name},
#{scoreId},
#{weight}
)
</insert>
<insert id="addScore" parameterType="com.bean.Score">
insert into score(
scoreId,
Networkprotocol,
javaEE,
Computerbasis,
Linuxoperatingsystem,
networksecurity,
SQLdatabase,
datastructure
)values(
#{scoreId},
#{Networkprotocol},
#{javaEE},
#{Computerbasis},
#{Linuxoperatingsystem},
#{networksecurity},
#{SQLdatabase},
#{datastructure}
)
</insert>
</mapper>
7.上面的准备工作就做好了，然后就是核心业务（模拟的是service业务层）
（1）.将json格式字符串解析成想要的数据格式
（2）.将数据封装jsonarray
（3）.遍历jsonArray,将object数据封装为JSONObject
（4）.运用JSONObject.toBean方法，将其封装为实体类对象
（5）.写入数据库
import java.util.UUID; import org.junit.Before; import org.junit.Test; import org.springframework.context.support.ClassPathXmlApplicationContext; import company.order.dao.TestDao; import net.sf.json.JSONArray; import net.sf.json.JSONObject; public class Domain { ClassPathXmlApplicationContext ctx; @Before public void init(){ ctx=new ClassPathXmlApplicationContext("backstage-mybatis.xml"); } /** *这个测试的代码相当于service业务层的代码 */ @Test public void testJson(){ TestDao dao=ctx. getBean("testDao", TestDao.class); String jsonstr = "{\"name\":\"三班\",\"students\":[{\"age\":25,\"gender\":\"female\",\"grades\":\"三班\",\"name\":\"露西\",\"score\":{\"网络协议\":98,\"JavaEE\":92,\"计算机基础\":93},\"weight\":51.3},{\"age\":26,\"gender\":\"male\",\"grades\":\"三班\",\"name\":\"杰克\",\"score\":{\"网络安全\":75,\"Linux操作系统\":81,\"计算机基础\":92},\"weight\":66.5},{\"age\":25,\"gender\":\"female\",\"grades\":\"三班\",\"name\":\"莉莉\",\"score\":{\"网络安全\":95,\"Linux操作系统\":98,\"SQL数据库\":88,\"数据结构\":89},\"weight\":55}]}"; int strstrat=jsonstr.indexOf("["); int endstrat=jsonstr.lastIndexOf("]")+1; //将数据分成jsonArray String jsonStr=jsonstr.substring(strstrat, endstrat); //System.out.println(jsonStr); JSONArray jsonArray=new JSONArray(); jsonArray =JSONArray.fromObject(jsonStr); for (Object object : jsonArray) { JSONObject jsonObject=JSONObject.fromObject(object); Student studentData=(Student) JSONObject.toBean(jsonObject, Student.class); //System.out.println(studentData); String ScoreId= UUID.randomUUID().toString(); //System.out.println(ScoreId); studentData.setScoreId(ScoreId);//设计ScoreId方便以后关联查询 Student student=new Student(studentData.getAge(), studentData.getGender(), studentData.getGrades(), studentData.getName(), studentData.getScoreId(), studentData.getWeight()); //System.out.println(student); int a=dao.addStudent(student);//将学生信息写入到数据库 Map<String,Double> Scores= studentData.getScore(); //遍历Scores,将单个数据存入到数据库 /*map遍历总结 * http://www.cnblogs.com/blest-future/p/4628871.html * */ Score scoreData=new Score(); for (Map.Entry<String , Double> entry : Scores.entrySet()) { //Map.entry<Integer,String> 映射项（键-值对） 有几个方法：用上面的名字entry //entry.getKey() ;entry.getValue(); entry.setValue(); //map.entrySet() 返回此映射中包含的映射关系的 Set视图。 //System.out.println("key= " + entry.getKey() + " and value= "+ entry.getValue()); if(entry.getKey().equals("网络协议")){ scoreData.setNetworkprotocol(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("JavaEE")){ scoreData.setJavaEE(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("计算机基础")){ scoreData.setComputerbasis(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("网络安全")){ scoreData.setNetworksecurity(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("Linux操作系统")){ scoreData.setLinuxoperatingsystem(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("SQL数据库")){ scoreData.setSQLdatabase(Double.parseDouble(entry.getValue()+"")); } if(entry.getKey().equals("数据结构")){ scoreData.setDatastructure(Double.parseDouble(entry.getValue()+"")); } } Score score=new Score(ScoreId, scoreData.getNetworkprotocol(), scoreData.getJavaEE(), scoreData.getComputerbasis(), scoreData.getLinuxoperatingsystem(), scoreData.getNetworksecurity(), scoreData.getSQLdatabase(), scoreData.getDatastructure()); int b=dao.addScore(score); System.out.println("学生："+a+";成绩:"+b); } //JSONObject jsonObject = JSONObject.fromObject(jsonStr); //Grades grades = (Grades) JSONObject.toBean(jsonObject, Grades.class); //System.out.println(grades); //System.out.println(grades.getName()); //System.out.println(grades.getStudents()); } }
8.结果：
