一、前言
有些时候存储到数据库的时候是如下
[[\"35\",\"TSQ02-10001\",\"13\",\"基础型主机\",\"三重四级杆质谱系统\",\"TSQ Quantis\",50500.0,46000.0,42000.0],[\"36\",\"OPTON-32101\",\"21\",\"化学喷射装置\",\"大气压化学喷射装置\",\"APCI Source Kit\",1150.0,1050.0,950.0],[\"37\",\"OPTON-30666\",\"22\",\"启动包\",\"启动包\",\"Pre-Installation Kit\",110.0,100.0,90.0],[\"38\",\"OPTON-30626\",\"6\",\"软件\",\"食品安全方向定量软件\",\"TRACE FINDER general quan\",700.0,620.0,550.0],[\"39\",\"5400.0225\",\"13\",\"基础型主机\",\"UHPLC主机\",\"Vanquish Binary Flex w/o Detector\",9200.0,8300.0,7500.0],[\"40\",\"PEAK NM32LA\",\"19\",\"氮气发生器\",\"进口氮气发生器\",\"PEAK NM32LA\",4200.0,3800.0,3400.0],[\"41\",\"SANTAK\",\"20\",\"不间断电源\",\"1小时不间断电源\",\"UPS 10KVA\",730.0,660.0,600.0]]
仅仅只有value，但是所有的数据格式都是固定的，现在有一个需求，根据上述数据，封装到对应的类对象中，当然看当前数据，肯定是一个list返回
上述数据是由此类组成
public class ShowModularListBind {
private String modularId;//模块编号
private String cargoNum;//产品货号
private String typeId;//模块类型编号
private String typeName;//配件类型
private String modularName;//配件名称
private String modularSerie;//配件型号
private Integer num;//数量
private Integer sequence;//套餐模块的排序
private Double threeMonth;//租期3月的月租金
private Double sixMonth;//租期6月的月租金
private Double nineMonth;//租期9月的月租金
public String getModularId() {
return modularId;
}
public void setModularId(String modularId) {
this.modularId = modularId;
}
public String getCargoNum() {
return cargoNum;
}
public void setCargoNum(String cargoNum) {
this.cargoNum = cargoNum;
}
public String getTypeId() {
return typeId;
}
public void setTypeId(String typeId) {
this.typeId = typeId;
}
public String getTypeName() {
return typeName;
}
public void setTypeName(String typeName) {
this.typeName = typeName;
}
public String getModularName() {
return modularName;
}
public void setModularName(String modularName) {
this.modularName = modularName;
}
public String getModularSerie() {
return modularSerie;
}
public void setModularSerie(String modularSerie) {
this.modularSerie = modularSerie;
}
public Integer getNum() {
return num;
}
public void setNum(Integer num) {
this.num = num;
}
public Double getThreeMonth() {
return threeMonth;
}
public void setThreeMonth(Double threeMonth) {
this.threeMonth = threeMonth;
}
public Double getSixMonth() {
return sixMonth;
}
public void setSixMonth(Double sixMonth) {
this.sixMonth = sixMonth;
}
public Double getNineMonth() {
return nineMonth;
}
public void setNineMonth(Double nineMonth) {
this.nineMonth = nineMonth;
}
public Integer getSequence() {
return sequence;
}
public void setSequence(Integer sequence) {
this.sequence = sequence;
}
}
对应的抽象方法如下，思路【将上述数据变成key：value结构，再利用Gson去转换成对象】
-------------------------------pom-------------------------------------------
<dependency> <groupId>com.google.code.gson</groupId> <artifactId>gson</artifactId> <version>2.3.1</version> </dependency>
------------------------------------方法--------------------------------------
import com.google.gson.Gson;
import org.springframework.util.StringUtils;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.LinkedList;
import java.util.List;
/**
* Created by ASUS on 2018/5/29.
*/
public class DBStringToBean<T> {
public <T> List<T> stringToBean(String dbStr, Class<T> clazz) {
List<T> result = new ArrayList<T>();//返回数据结构封装
/*--------------------------创建key数组-----------------------*/
List<String> keyList = new LinkedList<>();
Field[] fields = clazz.getDeclaredFields();//利用反射原理
for (Field f : fields) {
keyList.add(f.getName());
}
/*---------------------data部分-------------------------------*/
String[] valueContentArray = null;
List<String> dbStringLinkedList = new LinkedList<>();
dbStr = dbStr.subSequence(dbStr.indexOf("[[") + 2, dbStr.lastIndexOf("]]")) + "";//去掉非法数据结构
if (!StringUtils.isEmpty(dbStr)) {
String[] strContentArray = dbStr.split("\\]\\,\\[");//组数再次分成分成list
for (String strOne : strContentArray) {
dbStringLinkedList.add(strOne);
}
}
/*string和key组合*/
try {
StringBuffer buffer = null;
for (int i = 0; i < dbStringLinkedList.size(); i++) {
buffer = new StringBuffer();
buffer.append("{");
String stringGetIndexValList = dbStringLinkedList.get(i);
valueContentArray = stringGetIndexValList.split(",");//list中取值
for (int j = 0; j < valueContentArray.length; j++) {
if (j > 0) {
buffer.append(",");
}
String key = keyList.get(j);
buffer.append("\"" + key + "\":" + valueContentArray[j]);
}
buffer.append("}");
T bean = parseJsonWithGson(buffer.toString(), clazz);
result.add(bean);
}
} catch (Exception e) {
}
return result;
}
/**
* @param jsonData
* @param type
* @param <T>
* @return
* @description 将Json一条【数据】解析成相应的映射对象---使用此需要导入gson.jar
*/
public static <T> T parseJsonWithGson(String jsonData, Class<T> type) {
Gson gson = new Gson();
T obj = gson.fromJson(jsonData, type);
return obj;
}
public static void main(String[] args) {
String str = "[[\"35\",\"TSQ02-10001\",\"13\",\"基础型主机\",\"三重四级杆质谱系统\",\"TSQ Quantis\",50500.0,46000.0,42000.0],[\"36\",\"OPTON-32101\",\"21\",\"化学喷射装置\",\"大气压化学喷射装置\",\"APCI Source Kit\",1150.0,1050.0,950.0],[\"37\",\"OPTON-30666\",\"22\",\"启动包\",\"启动包\",\"Pre-Installation Kit\",110.0,100.0,90.0],[\"38\",\"OPTON-30626\",\"6\",\"软件\",\"食品安全方向定量软件\",\"TRACE FINDER general quan\",700.0,620.0,550.0],[\"39\",\"5400.0225\",\"13\",\"基础型主机\",\"UHPLC主机\",\"Vanquish Binary Flex w/o Detector\",9200.0,8300.0,7500.0],[\"40\",\"PEAK NM32LA\",\"19\",\"氮气发生器\",\"进口氮气发生器\",\"PEAK NM32LA\",4200.0,3800.0,3400.0],[\"41\",\"SANTAK\",\"20\",\"不间断电源\",\"1小时不间断电源\",\"UPS 10KVA\",730.0,660.0,600.0]]\n";
List<ShowModularListBind> result = new DBStringToBean<ShowModularListBind>().stringToBean(str, ShowModularListBind.class);
System.out.println(result);
}
}
--------------------------------返回结果------------------------------------------
感谢大家的收看
