如何将list转换为json格式（javalist转成json）

Jar包

javalist转成json

实体类

 1 package bean; 2  3 public class Question { 4  5 private String timu; //题干 6 private String leixing; //类型 7 private String axuanxiang; //A选项 8 private String bxuanxiang; //B选项 9 private String cxuanxiang; //C选项10 private String dxuanxiang; //D选项11 private String daan; //答案12 private String jiexi; //解析13 public String getTimu() {14 return timu;15 }16 public void setTimu(String timu) {17 this.timu = timu;18 }19 public String getLeixing() {20 return leixing;21 }22 public void setLeixing(String leixing) {23 this.leixing = leixing;24 }25 26 public String getAxuanxiang() {27 return axuanxiang;28 }29 public void setAxuanxiang(String axuanxiang) {30 this.axuanxiang = axuanxiang;31 }32 public String getBxuanxiang() {33 return bxuanxiang;34 }35 public void setBxuanxiang(String bxuanxiang) {36 this.bxuanxiang = bxuanxiang;37 }38 public String getCxuanxiang() {39 return cxuanxiang;40 }41 public void setCxuanxiang(String cxuanxiang) {42 this.cxuanxiang = cxuanxiang;43 }44 public String getDxuanxiang() {45 return dxuanxiang;46 }47 public void setDxuanxiang(String dxuanxiang) {48 this.dxuanxiang = dxuanxiang;49 }50 public String getDaan() {51 return daan;52 }53 public void setDaan(String daan) {54 this.daan = daan;55 }56 public String getJiexi() {57 return jiexi;58 }59 public void setJiexi(String jiexi) {60 this.jiexi = jiexi;61 }62 @Override63 public String toString() {64 return "Question [timu=" + timu + ", leixing=" + leixing + ", axuanxiang=" + axuanxiang + ", bxuanxiang="65 + bxuanxiang + ", cxuanxiang=" + cxuanxiang + ", dxuanxiang=" + dxuanxiang + ", daan=" + daan66 + ", jiexi=" + jiexi + "]";67 }68 69 70 71 }

Excel转成JSON

 1 package Action.Excel2; 2  3 import jxl.Cell; 4 import jxl.Sheet; 5 import jxl.Workbook; 6 import net.sf.json.JSONArray; 7 import net.sf.json.JSONObject; 8  9 import java.io.File;10 11 public class Excel2JSON {12 13 /**14 * 将Excel数据转为JSON格式数组(题对象list)15 *@param name Excel路径16 *@return Json格式数组17 */18 public static String excel2Json(String name) {19 Sheet sheet;20 Workbook book;21 Cell cell1, cell2, cell3, cell4, cell5,cell6,cell7,cell8;22 JSONArray array = new JSONArray();23 try {24 //为要读取的excel文件名 "F://a.xls"25 book = Workbook.getWorkbook(new File("F://a.xls"));26 27 //获得第一个工作表对象(ecxel中sheet的编号从0开始,0,1,2,3,....)28 sheet = book.getSheet(0);29 30 for (int i = 2; i < sheet.getRows(); i++) {31 //获取每一行的单元格32 cell1 = sheet.getCell(0, i);//（列，行）33 cell2 = sheet.getCell(1, i);34 cell3 = sheet.getCell(2, i);35 cell4 = sheet.getCell(3, i);36 cell5 = sheet.getCell(4, i);37 cell6 = sheet.getCell(5, i);38 cell7 = sheet.getCell(6, i);39 cell8 = sheet.getCell(7, i);40 if ("".equals(cell1.getContents())) {//如果读取的数据为空41 break;42 }43 JSONObject object = new JSONObject();44 object.put("timu",cell1.getContents());45 object.put("leixing",cell2.getContents());46 object.put("axuanxiang",cell3.getContents());47 object.put("bxuanxiang",cell4.getContents());48 object.put("cxuanxiang",cell5.getContents());49 object.put("dxuanxiang",cell6.getContents());50 object.put("daan",cell7.getContents());51 object.put("jiexi",cell8.getContents());52 array.add(object);53 }54 System.out.println(array.toString());55 book.close();56 } catch (Exception e) {57 e.printStackTrace();58 }59 return array.toString();60 }61 }

JSON转成List

 1 package Action.Excel2; 2  3 import java.util.ArrayList; 4 import java.util.HashMap; 5 import java.util.List; 6 import java.util.Map; 7  8 import org.junit.Test; 9 10 import com.google.gson.Gson;11 import com.google.gson.reflect.TypeToken;12 import com.sun.org.apache.bcel.internal.generic.Type;13 14 import bean.Question;15 16 public class JSON2BeanList {17 18 19 20 // 测试JSON转list21 /**22 * 将字符串转为list集合对象23 *@param json json数组字符串24 *@return list集合25 */26 @SuppressWarnings("unchecked")27 public static List<Question> json2list(String json){28 List<Question> list = new ArrayList<Question>();29 Gson gson = new Gson();30 list = (List<Question>) gson.fromJson(json, new TypeToken<List<Question>>(){}.getType());31 return list;32 }33 34 }

测试:

Java代码

package Action.Excel2;import java.util.List;import org.junit.Test;import org.junit.validator.PublicClassValidator;import com.sun.org.apache.xml.internal.resolver.helpers.PublicId;import bean.Question;public class test1 { @Test public void test1(){ String excel2Json = Excel2JSON.excel2Json("F://a.xls"); List<Question> json2list = (List<Question>)JSON2BeanList.json2list(excel2Json); System.out.println(json2list); System.out.println(json2list.size()); for(Question q:json2list){ System.out.println(q); System.out.println(q.getAxuanxiang()); } }}

[{"timu":"你喜欢吃什么","leixing":"单选","axuanxiang":"1","bxuanxiang":"2","cxuanxiang":"3","dxuanxiang":"4","daan":"1","jiexi":"1"},{"timu":"你喜欢吃什么","leixing":"单选","axuanxiang":"1","bxuanxiang":"2","cxuanxiang":"3","dxuanxiang":"4","daan":"1","jiexi":"1"},{"timu":"你喜欢吃什么","leixing":"单选","axuanxiang":"1","bxuanxiang":"2","cxuanxiang":"3","dxuanxiang":"4","daan":"1","jiexi":"1"},{"timu":"你喜欢吃什么","leixing":"单选","axuanxiang":"1","bxuanxiang":"2","cxuanxiang":"3","dxuanxiang":"4","daan":"1","jiexi":"1"},{"timu":"你喜欢吃什么","leixing":"单选","axuanxiang":"1","bxuanxiang":"2","cxuanxiang":"3","dxuanxiang":"4","daan":"1","jiexi":"1"}]

[Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1], Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1], Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1], Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1], Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]]

5

Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]

1

Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]

1

Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]

1

Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]

1

Question [timu=你喜欢吃什么, leixing=单选, axuanxiang=1, bxuanxiang=2, cxuanxiang=3, dxuanxiang=4, daan=1, jiexi=1]

1

上面就是小居数码小编今天给大家介绍的关于（javalist转成json）的全部内容，希望可以帮助到你，想了解更多关于数码知识的问题，欢迎关注我们，并收藏，转发，分享。

94%的朋友还想知道的：

• pdf文件怎样转成word文件打开（pdf文件怎么在cad打开）
• 怎么将xps格式转换为PDF教程（XPS文件怎么打开方法）
• 怎样将html格式转成pdf啊（pdf如何转html）
• 把文件转为pdf格式方法分享（电脑文件怎么转成pdf的形式）

（551）个朋友认为回复得到帮助。