Java读取Excel文件转换成JSON并转成List——(七)

2023-03-14,,

Jar包

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmYAAAAiCAIAAAB6GIKOAAAH8klEQVR4nO2cTW8TRxjH/QF6663nii/ApbLUOzduKKilvUSGA+kB0UrhTYAo21QlWokUVEXAFqkFUUQiRNw6KEJBoUBPWBDkZB2/YJNdmzVYsreoaUp6WHt3Xnc3jhOzzv+nUWTPzDMzOzue/z4zs4mtAQCCePeu1y3YHqCft4bt1s9dvN5Y10oCAAAA+hpIJgAAABAKSCYAAAAQCkgmAAAAEApIJgAAABAKSCYAAAAQCkgmAAAAEApIJgAAABCKUJK58ycEBAQEBIQohV5KJgAAABAVIimZmWLl9tzTK1OPAsPtuaeZYqXDagAAAACCSErmxOyT+cWcbdtvOZrNpvvZtu35xdzE7JMOqwEAAAAIIimZF27eq9Vqq6ur/xGsrq42m836wtzKyoobU6vVLty812E1AACwbsyUMqSle90KsDlEUjLVa9OWZf1LsLKy0mg0and/sEY/sW3bjbcsS7023WE17ye6Go/FVb3XzQAASElrQ0rKFKdQCWkN6hotIimZIz9PVSqVfwjq9Xr1j5FX3+548+bNq/S0bdtOfKVSGfl5qsNqNkgyEWshUjj/VCITmwzJ3A6ktaEW5ATrxrLTsZlSRDN0WhNmJSZpsWFgHq950vmesfIshEbC6xV3Qrdh1c1MKUwLzZRCNF7SXwG0rVzFbH2AZHYEOya9O0DfHt+BSvW9U4KWXmPGKne7IymZp8cnDMP4u02j0TBnxionPjIMw7xzunpmR6PRcJIMwzg9PtFhNRsimXB1LZmIxRLJdaS20NW4v6KCPoXwRNJa+9duppQhd7r1poD2ZMHP5E4KE+/NNb6GfnnkHhRVMaf2cmkQXq8wchNgLsdMKYpCL6xSTxA+bTFTCpvC+JRez7YTIJnrRTC6iBtE3p6ggUr0PXVXSTv+dkdSMo+OXS+Xy4029Xq9cuRD56/zoV6vO0nlcvno2PUOq+kayUSAKylK1dV4LJHwtQTbgPbvl5q33S8tHRVMDmZKGdI0Nt7NKDcMyCNxaOmK+ZJDS4NwngtU6Q0gujy6tbTT7XMljEByeb2CKEdmC1zpvkE4ushuJkdvQI+2zdjFGLJwfl86kpJ5+NzVYrFYb2NZVuX7ncVi0fz6A8uyLMsqlUrLy8uvX78uFouHz13lCnBXReOq6omS49XFYjHC7fPWT+nIuKomAtdViTLEfqQ8VVfjsURSJKetFFmLneRkAv5pf+A+5dKzLy9I9PTQ+qWz8Vw+gRb55zFTipJKyRaIpcWQS5ekfyzSa16Rts7LbM+zbKR/o8myyHby+5bOdRCzObzMjpCOf1ox/QdqWhvS0oIbShQuOMkVSck8qIzncrlarVapVJaWlpaWlnK5XPn0x4XJk7lcrlQqfaP+MnL51osXL7LZ7EFlnLYmNUpX421pIaWIyOnpjmeXTLgaFbizqKtxH8GUpLpV+Uqmrib41V1HReUKDSIEsa3G/Hb9JZPUWX9Xj5fMgDzutL8WIB8yx9B7pOfN+W1EWWQXYZbh2Kl3jdb7AMeFdG2YdVozpSiapmhpKgGS2RGi5zr6gSzEQG3ZCB/b+mwvc/DkWDabrVary8vLe4+M7Tt+8cDZS58d/XHvkbEDZy+N35x24r+7PJHJZAZPjlHGjAp5Xx2Hkkhj9coVKzJBV+POZ8Jz1QkDuaBKU4niA7xMgZ8pUH4QRcyUwp6FCSmZxBepsyQpJzgPtyIm0xC/M6PSIzSi1eXNXrCUdJfQ1Qjh7hJ+Kp0znUqZ/G4nJLMjuIHN3bcQA9Xpe/6MHPeMSN2hSErmvuHRhYUFwzBKpVKpVPr9/l/J+4+T9x9Pzvw5OfMwoy9lMpkvT1wcuTwxPz+/b3iUMpZKpgNx5kaQ5KojL5ksnSzHeg2gIWtwNZGUXNL1hGRGH8HU7Kt+zPwu3CUTvi3In30JyEPvEHUqmQJV3uLlWBfm6AgN7+GHaVRak7mjjmSKNjKxmbkufLYbW0khBmp7ILLrGP5qG0nJ3HNIef78eblcLpfLhUJh/5nxgeHze4fPDwyf339mvFAofHH8gnLpVqFQePbs2Z5DCm0tXZhVqe3ANcHCrOePBkmmULncVVz/VLqthCjStklmFxaS2S+IX4Wn5/bALUk2Xlwov+MYJg9xnjbkwqxp8k/trrmw2i36fwCSc8jUd+7klZ+2OY6xpgndY3iZXcLXy6ROxnEZqEJEy7j96GXuPnhK13XDMPL5fDabXRDx8uVLwzB0Xd998BRr7zly1PEf76iPpzny4z/+kknaucau7Pmn0sVIJZO8jEQCXmb/wHkhxJYMvWFDWARIpvzNTZkHKS/ca5/PbM89qnO+lDuRCa9X1gndo1WD3H9sxzDqLdtc5V7qcSpgvHhIZjcQnGsTjJOAgcrtdQyJxiNrGknJ3JU4ls/nTdP87e5DRbvz1blf+VCtVi3LyufzuxLH/MryfwHkPQSaCNaPzwrquvIAEcI3YEWJkMzoE0nJHDis3JicMk3T8KVard6YnBo4zCzM6mqceockeooZrRaD3gPFBKA7RFIyJ2ceDB4f/fTzQ4Fh8Pjo5MwD1p44YRMl9Wkt58LFBACA3hBJyQQAAAC2HkgmAAAAEApIJgAAABCKHksmAgICAgJChELPJBMAAAAAmyuZmWLl9tzTK1OPAsPtuaeZYmVTGwMAAABshM2VzInZJ/OLOdu233I0m033s23b84u5idknm9oYAAAAYCP8DynlMw928li5AAAAAElFTkSuQmCC" alt="" />

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmYAAACVCAIAAAB916FDAAAgAElEQVR4nO2d3W8Tx7vH8wf0rne9rvgHkKo2Uu+54+qgoEKrSpHhIqkqTlopQFCIgG2qJrKESy6sgOGnFgQcEgExdVDEKQcK9KKnbgl18Dt2smuzBus4bk9DenIu1rs7L8/MbBzbsZ3no1Fkz87MPrPene8+z2x2ej7//PPPP/98A0G6nf/5a327TdgR4HFuDTvtOLdJf3u22wAEaRHV/22LS67rwePcGnbacW6T/qJkIjuFv9b+2W4TdgR4nFvDTjvObdJflExkp7C2/n/bbcKOAI9za9hpx7lN+ouSiewU1v9pi0uu68Hj3Bp22nFuk/6iZCI7hf9riyuu+8Hj3Bp22nFuk/6iZCIIgiCIJ1AyEQRBEMQTKJkIgiAI4gmUTARBEATxBEomgiAIgngCJRNBEARBPIGSiSAIgiCeQMlEEARBEE+gZCIIgiCIJ1AyEQRBEMQTasmMZQs3H/x+Ye6xMt188HssW2iB0QiCIAjSetSSOfPjr4vPU9Vq9S+O1dVV53O1Wl18npr58dcWGI0gCIIgrUctmeeu3yuVSuvr6/8QrK+vr66ulpcerK2tOTmlUunc9XvNtxlBEMTCiGiDoeh2W4HsGNSS6b88b5rmG4K1tbVKpVK6+405+X61WnXyTdP0X55vgdEtIe7v7fGFt2W3vf74xsZG2Lcd+xcYgyBtSzQ0qEUMeAu1IRpCdUW2iFoyxy/OFQqFvwnK5XLxh/GXp3e9fv36ZXS+Wq1a+YVCYfziXAuMbgmdJ5lxfy+sb3F/b48FuD3sq23ldrdDJDMaGqxBDrBOLjscGxGNzhKWJFwgpww3ZjtlYDPcXQhkgTPJbUfYnLQXzVQVVt2MiMbs0IhoctPpAiB2LUcxax9QMjcLeE7ymR5OOerYW78hc9aLztQ2Qy2ZY8EZXdf/tKlUKsZCoHDiHV3XjdtjxVO7KpWKtUnX9bHgTAuMbgmtlExwX5uRTFsUIX0jGg/7OF2M+3vFG3cEhCcSDdnjtxHRBp3h1h3U7eGauLQFJe1tWsTY2DAiWi2fK+KUAc0g9iEaTwCTmK2gSPO9EFrYSBjJNCKaptEWUhZLjHEtJhpn5ZhWTJTMTQKek7ITdWNDGCknjj1VjTwjmnvuNQi1ZB4LXMnn8xWbcrlcOPq29df6UC6XrU35fP5Y4EoLjG4JHSSZNWcw7AMlk2xHUMTDxp2Bff1Sl73zpaaO1LAPl6Rbg/YgK8NkGhFtMBSCg4+QSZK9eagiCXM2AK5nliXEQaOPoUTkGIHkygIefof5M22FhxNVXG7D/XXYeAlZviPmpdWSOTRxKZvNlm1M0yx8vTubzRpfvGWapmmauVxuZWXl1atX2Wx2aOIS14AT93MGZDenhxnNwzVvyRd2SxG15AWkLfvZwm60ElYmS8bcBolCfI/A5qD9kuJY+0zY3OuPuwVcqVOZSvYTDrzW8jermKy1jBHEIeoOrXXucunRlxkFqK+SkltRTE6G5UIGbyVHIMIZllVpsmLSrbsOtuAehDOabYscX/l5S+soEhFo9DLrBnQAwZiJ4BBHQ4OhKPCDEj9+RyimB8kc0IKpVKpUKhUKhWQymUwmU6lUfuzdzOxoKpXK5XJf+r8bP3/jxYsXiURiQAvStcM+djilc9xoIDHyWiJiZVMSoi4gbNkt3OuPe/EhLYkg5M9tjZJdX3hjYyPu99l53vfrfiZyecn07O6KBVE8W7nhaiGwjbQQ6CB9iDodYlpN7i1K7ouZKBM7ecONOsAYTs/ukSK+WcnklEgqmQILGwxzgNyINnVEPbqC5HQsE6c1IpoWCmmhKLUBJbM++BlnQabkLK25+tBNZGf5/mrJ7B8NJBKJYrG4srKy/2jg4MjU4TPTHx37dv/RwOEz08Hr81b+V+dnYrFY/2iAqsyP4myOMyqTG8DPqgKeWnYekbFUhKzg6IqVySiV/ZX0YxVuK7TfOiRTbarwYNsNgseNhb+7YY4B18FtekKqCRgRjX3AYYtepnhGRxKHAswgHKRNSqbCXZR4ma0JzMLqycRTFQpH+Kl0yWgkYvCznSiZm4c9J8WZ8lPOOvb82cVeTW3/C6kl8+Dw5NLSkq7ruVwul8vduf9z+P6T8P0nsws/zS48isWTsVjskxNT4+dnFhcXDw5PUpU9SaY3RaxHMvmKzFOllgqAKiKWTL543N8LhF4bJZlKUzf4gyLqxuZCs4QXDXWwSyQTuE7F05XsRkFJaYAKVlXBQz+epuA2Maek3t7E0CzRZX6CkT9yXkbQaEh0WCzJhCYyO8Wh2XY8hmPdDeowOuuc0pWaOy3QENSSue+I9uzZs3w+n8/nM5nMoVPBvuGz+4fP9g2fPXQqmMlkPh45p03fyGQyT58+3XdEo2uTj2GG/TVlo8OnwDxbXZLpqWVXuvyccNHE/b30rB3h8xHTpKwfS5cEJZOQHm+BWZWpXI83mFAweax6fGF6K9lH18GmBR7uYFdIJixu9NguuS+GS9KNEu4OER/lykjVYbNeJhR3FQdmYQsbjuTpYuc79zyVzBjL2wmFQJ8HvcwtInzcWnUzKNhK3gmRX7rNy9w7cDIej+u6nk6nE4nEEsTy8rKu6/F4fO/ASba+G84jn8cRPKSzJcn00rLrZYIP9jB2+3xQIcGDMLVQqc8n8zKJokRJO1Pw+I/KVKCflFISR4XYH2sP3RvGJwY72BWSyXkhtUvW9fH4/2WAZwGp/0WhBw/CYRSUEZkh2qncJNhllc1lAhY2lFr/xP6jncMMyeA0mmMv7Z8wviNK5hYBz0nhiaqQO24Go/Zj0e11wM+jlsw9vuPpdNowjGt3H2mh259NfM+nYrFommY6nd7jO94Co5EW0RWa2Hq8RJc6IALVpsj+SZXaiJKJNAG1ZPYNaVdn5wzD0KUUi8Wrs3N9Q5qyQaRT2CEv/2k0qJgI0rWoJXN24WH/yOSHB44oU//I5OzCwxYYjTSdWiwXXUwEQRAXXGIaQRAEQTyBkokgCIIgnkDJRBAEQRBPoGQiCIIgiCdQMhEEQRDEE2rJjGULNx/8fmHusTLdfPB7LFtogdEIgiAI0nrUkjnz46+Lz1PVavUvjtXVVedztVpdfJ6a+fHXFhiNIAiCIK1HLZnnrt8rlUrr6+v/EKyvr6+urpaXHqytrTk5pVLp3PV7zbcZQRDEojMWWUS6BrVk+i/Pm6b5hmBtba1SqZTufmNOvl+tVp180zT9l+dbYHSbQa7SVe///nfci3Y6zmCka5EtysK+VxfVFdkaaskcvzhXKBT+JiiXy8Ufxl+e3vX69euX0flqtWrlFwqF8YtzLTC6zWhzyZSuL+2+sV24d2a9NDe3ayTTfTM0+KJ0Vab7RnNu4AbWDQPXHqRWNAHX5JC/Xk/2jnfBqp3sNkkvGgj4SnvJkmeALdCaaAzukpzOuinwspqIHOGJ5G6glieRnD/Aiuv22unSn7vtUEvmWHBG1/U/bSqVirEQKJx4R9d14/ZY8dSuSqVibdJ1fSw40wKj24y6JbMFbz13F/eiFi2rEfZxy4JxBkrltBsgPBF3MQZwmSphJrEEJDv886uFMMOCW8bWAnCZFOFgAhWQSoP7tnLCXlkvGgm/foqm0XcV1B2ExBb+peusT+keWXsDSuYmgQ8YuDorcBGJmqJKMCuNt/8PpJbMY4Er+Xy+YlMulwtH37b+Wh/K5bK1KZ/PHwtcaYHRbUY7SyaBdHVpaHPNkVTU6yrs65dbtJFblsr5Qo4qzFgCLKwZEi6+WdNjvg6XSQIX8CoNbjVJLxoK1z3LeMbbdb9KesIIJFfWbQhaZboT/JntBzr8ypAHfP7YTbGBFrJ0R8xLqyVzaOJSNpst25imWfh6dzabNb54yzRN0zRzudzKysqrV6+y2ezQxCWuAT72J17VMlxza3xhtxRRS15A2rKfLQysE1m/5bxkghFPMtPvNkUtk9nwXpD1pYopaAGuSBosWHLTFw77OstFde5yucX9tIgBZzK6I1TM2mjADieK9atlmeICZOhStnI0c4MP96KxsMfEjpdyB0poNNUWHStkj6yzAKcbqG3/EbmdEJxIWiQCTVrUkHmZwA9K/PgdoZgeJHNAC6ZSqVKpVCgUkslkMplMpVL5sXczs6OpVCqXy33p/278/I0XL14kEokBLUjXDvvYMZPOcUdqYni1JINdxthTAWHLbmFm8WQRm7Kc/0CJmi8MNkgY0axeuHomKxf390pvHKSSGff7+OiutdeOWgiFmFZjrl3rqgYz7Y/8bA/ruDlaLHcHGyGZVD7txLo9Zc0V9KLBqFWaHKYV0k36O0yc1ohoWiikhaLUBpTMenFPJOdWZAO6pRGtCO6cXtxP2oVzmf2jgUQiUSwWV1ZW9h8NHByZOnxm+qNj3+4/Gjh8Zjp4fd7K/+r8TCwW6x8NUJX54ZbNIRWFnFjjP6sKeGrZeZbFUl2yguPbga3J26clk/QSnRYB5YEks7G9oM0HHb64v1fuCaq9TMDP7LDFqY2IRl2v3r1MatQQ3DHT6go7VEyzHjK9FZBVhQW1VYFZWD2ZeKpC4Qg/ldH/SMTAJaYbif0T0WcHd7MjO9msKIssrNIJk5lqyTw4PLm0tKTrei6Xy+Vyd+7/HL7/JHz/yezCT7MLj2LxZCwW++TE1Pj5mcXFxYPDk1RlT8LjTRHrkUy+IvP4pzXUQ4KxOcs5yeSbrF8yt9ALlQXicKy0GmkwKbmk69k5kglcp6CyQZki15PIh57w5CdMwT1LM70VkKsEofuwA91gmKeMaHgP38sIGg2JvBNLMqGJzE5xaNoJ+0SipzLJ6Qn5T0XUHxSfbE2dFWgMasncd0R79uxZPp/P5/OZTObQqWDf8Nn9w2f7hs8eOhXMZDIfj5zTpm9kMpmnT5/uO6LRtckxOeyvKRsdeKx92bJkemrZFpu430/NuvH93pTlfGCWnITkM60GvQVmt9IL94FZ4r9C5HFd7r9HKMnk6xKbifhu50gmPIFCj+3EI61sJuufueOCKDwln7lpyFymwd+1O3YSvpdrO9yLhgM+cszslHvIStZzy7EJhUD3Br3MrQKdSORvQp5UqiMbpZ+YhUIw3eJl7h04GY/HdV1Pp9OJRGIJYnl5Wdf1eDy+d+AkW9+N2Xl4vGVLkumlZdc/c4uKhvZNWM49/gM+lsM1WMvw/vjP5nsheDTH9stpfOHNSyaxh16fr/O8TM4L4ZxD8J8X6ftkvq4yTioo0wjJJAyiombEQOelFw2l1rzYf7RzmNFXNDnG/cOOtQPyMKFkbhXoRKLzRSED8F6QPdvsQK+0Xtuhlsw9vuPpdNowjGt3H2mh259NfM+nYrFommY6nd7jO94Co5Htp3M0sfV4iS51QASqTQH/uxXaiJKJNAG1ZPYNaVdn5wzD0KUUi8Wrs3N9Q5qyQaQL6KaX/zQaVEwE6VrUkjm78LB/ZPLDA0eUqX9kcnbhYQuMRraTWjgXXUwEQXYcuMQ0giAIgngCJRNBEARBPIGSiSAIgiCeQMlEEARBEE+gZCIIgiCIJ9SSGcsWbj74/cLcY2W6+eD3WLbQAqMRBEEQpPWoJXPmx18Xn6eq1epfHKurq87narW6+Dw18+OvLTAaQRAEQVqPWjLPXb9XKpXW19f/IVhfX19dXS0vPVhbW3NySqXSuev3mm8zgiCIRWcssoh0DWrJ9F+eN03zDcHa2lqlUind/cacfL9arTr5pmn6L8+3wOiWQK4X3TbgS3cQhEW2jgv7blRUV2RrqCVz/OJcoVD4m6BcLhd/GH95etfr169fRuer1aqVXygUxi/OtcDoltBMyXTfhy7QP9Hb1lEym4H7Zmhm+Wd4mSjwherwW9ZpF6iuMqqVnxXGy5b7BZYubPbbsVl149+6Tq+VJjheCtwlOZ11U+BlNREF/NnFvYGde9k/fPtCHXursL3ouvTnbjvUkjkWnNF1/U+bSqViLAQKJ97Rdd24PVY8tatSqVibdF0fC860wOiW0DzJDPuolVe4vcALVCJNgvBEgLWy6EU37HGBH/bB693VvzrLuG8WFyyLJDJeUkvQtda89ZbZixHRNI0OrFJ3EJLFoPiXrrM+pXtk7Q0omZsDPLsI3N+KWQgVPFPhZWyYlcbb/wdSS+axwJV8Pl+xKZfLhaNvW3+tD+Vy2dqUz+ePBa60wOiW0JrALC+PzPLRSCuxr19u0UZnKUctYjCLU0KZdGtbLUMXVBovzxN2rSV3+Nyxs7rMrPblfpWIHCOQXFm3IWiV6U7wZ9oK4OwisshjD5+pdoloiIuHUCvUdYFkDk1cymazZRvTNAtf785ms8YXb5mmaZpmLpdbWVl59epVNpsdmrjENcBHIcXrQYZray/6wm4popa8gLRlP1sYXNGSNluy+CXcJmFAr9/vwVnkvcy4v9dtmGuAXHJLsBKmLxz2iSO+iAznLpdb3E90kcsyuaw6y0jzAePBWo5vCXbNiGhaJCKKRDcQqhu2TrOZlFMvNoaRSH7e0lmAExrYkU3Bn13cvY0buhAsBBuKAj+octH1dkMtmQNaMJVKlUqlQqGQTCaTyWQqlcqPvZuZHU2lUrlc7kv/d+Pnb7x48SKRSAxoQbp22MeO3nSOqxnEQG/pDrtWsacCwpbdwswKySIcyYz7fXwcFWqTEsC4v1elW3F/Ly/XRMPAzCW5sDNglaWi7ffUUkdATKsx1259ksmPz/WUsaO1iqGEmRPka9mDFdw1R182VDq1RZgwHDDKklOVCjNI15iJ0xoRTQuFtFCU2oCSWR/QOt/QzZ5sIry2GYqDdJbvr5bM/tFAIpEoFosrKyv7jwYOjkwdPjP90bFv9x8NHD4zHbw+b+V/dX4mFov1jwaoynzckc1xRIDcAH5WFfDUshP2tFSXrBCmXTsqMMt5dFCbjAHu1zDvNAoVlW5E2CfYKlz3uU6MiEZdr1v3MqE75nrKEPnSZZWF0Vy5SruSSfe+WWMXHcsD1JOJp6rvFODneqKRiIFLTDcCwdkFzk5Am4gKoShwQlKlO2EyUy2ZB4cnl5aWdF3P5XK5XO7O/Z/D95+E7z+ZXfhpduFRLJ6MxWKfnJgaPz+zuLh4cHiSquxJMr0pYj2SyVdkZgot0QGdQVsySXGjPFrvkgk0LVQ22kChZMJWoWTWA3CdCkOF3EZBJhhjqqOMcotqkJFHfm0T6KnM5kkm85QIDe/hexlBoyGRd2JJJjSR2SkOzbYj/AF4xRTfYjqZzgMB4sKteQhtS6glc98R7dmzZ/l8Pp/PZzKZQ6eCfcNn9w+f7Rs+e+hUMJPJfDxyTpu+kclknj59uu+IRtcm1SHsrwkLHT51XbGtSaanlm1Fivv91Pwf329bMonaRCRV6LmqA7PgDt0YLBGNpcLIdDwZtgolc/PAEyj02O5hulE6htRbhvCT4HAp2AZYi/7EdY1ovomBWcHDutR37vEkmS2WCxQKgY4QeplbRDy3CMVLFM+9Mk/Mwk9qd4eXuXfgZDwe13U9nU4nEokliOXlZV3X4/H43oGTbH03ekg+jyN4SGdLkumlZdeJE/3r44Zbi5wg7Onp6en1+WReJl1W+PgPaaOzf2rakjMNmIIFrULJ3DycF0JM6cFzM2rJFDx/uuky1MweNJQIjAdqkYMa3DW3rWYMWrXWxf6jncOM09A0mtsH2j9hfEeUzC0iujRET5pJzx9uQmDQeRwN2EMbo5bMPb7j6XTaMIxrdx9podufTXzPp2KxaJpmOp3e4zveAqM7g2b8eyVqYifgJbrUARGoNoUTS9FGlEykCagls29Iuzo7ZxiGLqVYLF6dnesb0pQNdi9xfy/lSTdFMfG/R9odVEwE6VrUkjm78LB/ZPLDA0eUqX9kcnbhYQuMbl+IZ1gbLG21YC26mAiCINsGLjGNIAiCIJ5AyUQQBEEQT6BkIgiCIIgnej7/Tx0TJkyYMGFqw7TdEsnSs1x5gwkTJkyYMLVb6kjJfPJc/4/7v12Ye6xM/3H/tyfP9W0/ypgwYcKEqQtSR0rm1Xv/vfg8Va1W/+JYXV11Pler1cXnqav3/nvbjzImTJgwYeqC1I6S+bkYy+hz1++VSqX19fV/CNbX11dXV8tLD9bW1pycUql07vq9bT/KmDBh2jFp+drpwanH224GpqakdpRM0QZHMv2X503TfEOwtrZWqVRKd78xJ9+vVqtOvmma/svz236UG5RuHejp/1cDG4xO7O75YDS67f3qTPMwYRKmX6YGz1xLQZseXxi7tUx+HZz+ZbutxbSJ1JGSOX5xrlAo/E1QLpeLP4y/PL3r9evXL6Pz1WrVyi8UCuMX57b9KDcotbVkPhz/YPf4H43cupMl8/EF+63Q5Mj7y5SXTLduDWqMTt0ZG7xwz/76260z1FZxplsRtA02mEyg8dLqqTtjijYbdKhP3/nNzVm+dnqQlrHla6eJo0kVhgqA2LXuTdf6UvuAktnA37GGc3pLT7nKm3vTRDDAOtmmf7HyJT93R0rmWHBG1/U/bSqVirEQKJx4R9d14/ZY8dSuSqVibdJ1fSw4s/0/Z2NSoyWzUSk6sbunp6enBxbFrWzdoemXKedCfXzBHgKWr522xU+RSSRaIJdJObQFiRNULpOqCNoGZpJJbqewv7URDW6zQYmRzNSdsdNn6INGBVrvTQ+KRO63W2fYeCzjU6bujNX2ZXcZJbMhib3veaO+NCjJ/GVqkPqJnV+N/7k7UjKPBa7k8/mKTblcLhx92/prfSiXy9amfD5/LHBl+3/RxqT2lMw/Rt/r2T3+x78+BWVvK1sxvXFDfJT42YM4mElUJy9+qjV7QKELgJlMxboyVXZC1X+ZotyFpjma9Ghr3RlQ/gdjsETkGIFk/JjKm99unanV5SIB4G0KJm9p+drpek45+9f5ZYo++OT57/5kdupIyRyauJTNZss2pmkWvt6dzWaNL94yTdM0zVwut7Ky8urVq2w2OzRxiTvEtw7Ybyq3R2o3p8eVpVsHej4YvVFzgw7ceLN8o5+rJS8gbXmcLfxw/AOuJGM22QLfLJn/weh4f897Ew8l+dGJ3bW6sD3i1oAkl716trrmuc5o7ThX3lhye+DGrQM9PXLDOjs5N8j0SF27qsFMpy7nYvI345A6QpnAXbzg5l2UyduZujPGCyFR3TUD3HsDj7DbuD34spnOgEv4LkAiZf4N5T3XtlouCzHEo5e59ZS6M3b6zrVp+s5DfmnYmVOPgR+UKAxobUdK5oAWTKVSpVKpUCgkk8lkMplKpfJj72ZmR1OpVC6X+9L/3fj5Gy9evEgkEgNakD5Stw6wYUA650Z/jysk9nBsaeGnt5YrjNKoCwhbdgt/MBqlFQJOjmTKmiUVxdYSQT7TEcYeYWtwaqZk/jH6qb1rt7N/jL4nurfolpS6M2bHi5i7XeuqBjNFX5c5pwcs47EiaZsiU2A8IJlsdWcuqmlR2Qqtju5n0q8lpyoVzi45DczEaX+7dWZs+sLY9C/LqTtjztFAyWzIL+icNvZJJb80nExwtrIL5zL7RwOJRKJYLK6srOw/Gjg4MnX4zPRHx77dfzRw+Mx08Pq8lf/V+ZlYLNY/GqCO1A3OW2JzLPflTc33qj1+An5WFfDU8h+j77kS1UM98EI4ebUC/f+SGMzkO19F+YyXydgjqsVaVUvN9TIBF9w5mN2Zfrt1hn2+ZnNeJhfM5J1Oj5IJTYjy4gFmyoyX95cS1BYFZplJLN7VkExk2onwU+mS927d+Y0US+jIYNriL7jsMQBjZ049fnNvmtVFqjAXNelIyTw4PLm0tKTrei6Xy+Vyd+7/HL7/JHz/yezCT7MLj2LxZCwW++TE1Pj5mcXFxYPDk9SR8iSZ3hSxHsnkKzqZzldWjewkkUypyDVYMuHURMmMTux2vGrS9exeyQSGZjBUKIwfAsFMflZm2Ztk8jfsYDuyoV9ip6C6Fy+hIYnYkePUOnAPItHPiQjSL1Pwg7Vvav4lNJEJOjSYPCX3oao3y6RkSk+5ZTd2wj4jLb/17EjJ3HdEe/bsWT6fz+fzmUzm0Klg3/DZ/cNn+4bPHjoVzGQyH4+c06ZvZDKZp0+f7jui0UeKjDfeGh3/A4hzuu7U1iTTU8u2REUnRqlZOv7kEAdm5QFYT4FZ2OutMzDL/X9IPVsd8wi1fjj+Qfd7mZA7yD5BWhsOwMw3y4DGCEcNlWTSFUHbYINVxjt+pLBN0sts0ssBJM9VOjuljsBvt85ItW352unBwdMXpk5DEoheZlMS8SO6p43w0nAS88Ss80N0oZe5d+BkPB7XdT2dTicSiSWI5eVlXdfj8fjegZPsIXafJZE/TbN1yfTSsutl/utTu6A1rcgmD4//uF2jH9gB8xWSKW4NSk2UzJrn3dPT07P70/7u9zI5L4SYp+Hm9sBMXmPoO3EnqSWTqQjaJjK4QhvA2OmMbqLqRH4z9LI2ZUUMlGwoddp5Wod9gBbSOWvKk/tfVeY/WFAym5LcCAH7r5bspeEmeobejQ1Qc5lc3Y6UzD2+4+l02jCMa3cfaaHbn018z6disWiaZjqd3uM7vt0/5zYlUShVFWLdXGvNS+rnoTB5TXUHNpsXEe2ixIklmayB23GsUTI7PLWjZCrfMftv/65dnZ0zDEOXUiwWr87O/du/a807fG2W/hh9j3JDbddNlF9fay1KD8c/6Ob/HmlpqvvxmWY+d4MJUwemdpRMpdEXw//1ybGJDw8cUaZPjk1cDP/Xth/l1iXi/xcphRPl19das1Pt31vRxcSECVN7pY6UTEyYMGHChKn1CSUTEyZMmDBh8pRQMjFhwoQJEyZPqR0l8/P/1DFhwoQJE6Y2TNstkSzCfzJBEARBEIRELZmxbOHmg98vzD1WppsPfo9lCy0wGkEQBEFaj1oyZ378dfF5qlqt/sWxurrqfK5Wq4vPUzM//toCoxEEQRCk9agl89z1e6VSaX19/R+C9fX11c4rmzYAAA5QSURBVNXV8tKDtbU1J6dUKp27fq/5NiMIglgYEW0wFN1uK5Adg1oy/ZfnTdN8Q7C2tlapVEp3vzEn369Wq06+aZr+y/MtMHrzhH09vf74Nu087u/dxr0jSJcTDQ1qEQPeQm2IhlBdkS2ilszxi3OFQuFvgnK5XPxh/OXpXa9fv34Zna9Wq1Z+oVAYvzjXAqM3zyYkM+7vFRQN+2ov51Ft7/GFmRZRMtuZaMh+KzQ5wDq57HBsRDR2IBaUZFwgtqI4U1HRiGiiPYpado0U1RT219ok25N3WHUzItogLWNu3wT9owuA2LUcxax9QMlsCNDpR51f0EGmjr3VQijKVmzMSdZc1JI5FpzRdf1Pm0qlYiwECife0XXduD1WPLWrUqlYm3RdHwvOtMDozeNNMuP+XqEkEroX9rGi6HkPSPtBeCLRkH25GxFt0Blu3THAHiyISxusvuEUr20EKgoy1RUJOeX2qGyZaYDMAvpLNNYUyTQimqbRxlDGifpnlWO3MD6lexDtDSiZDQA+/ZSHlihA/arkGSH5udsHtWQeC1zJ5/MVm3K5XDj6tvXX+lAul61N+Xz+WOBKC4zePF4ErSaKcNG4v9eVSeqLnYOC2QXY1y81bjtfaroiiwOyfqr1FawoaU1ekRydQFsUdgL5cH/dbyFhlzcJdwgsO4lxkt67ZCRmBJIr6zbEedgd4s+0J/Dp51ky2YgFeUZ0xLy0WjKHJi5ls9myjWmaha93Z7NZ44u3TNM0TTOXy62srLx69SqbzQ5NXOIacOOVlqrYvhwZxQz7enr94dqGWgbr8Lnt9LDqFfbVihJfqXJhX0+v3+9ja0PAkhn2kbXYMnF/L9E8W51UWKLzZBbRBWT7cO5y6QFApITC6oJyYEUgU1WRGqjEYz+8kRyWHN9S2N9aael+NgPVkO0Gspm8faK2yPGVn7e0fg0iPo1eZiOATj8yWg4f4mhoMBQFflD+ZGtz1JI5oAVTqVSpVCoUCslkMplMplKp/Ni7mdnRVCqVy+W+9H83fv7GixcvEonEgBaka5Piwjln7kZCMCy9s8q5NcI+UlDc0KglQZSCUkJJVCdqyKQJlEzGdLYM0TzQvls57vfZW4RdQLYJYlqNuXY9SSY3K8ePzx4l00NFx2+SjTDq3dkjmKi/5C1E4yUTVn5y8FXsk5ysZeK0RkTTQiEtFKU2oGQ2BtnpJ5r3rtURT6F3iu+vlsz+0UAikSgWiysrK/uPBg6OTB0+M/3RsW/3Hw0cPjMdvD5v5X91fiYWi/WPBqjKpGfIeGCUCpEaBH0G3DqrMqNloq+McpPizDp39XiZ9Hehsc43ys/kw7xIqzEiGjNBuSnJZKtvwHfMniRTWZG6U5dpmTTky2Xz/SXKNkMyYfVk4qkKhSP8VLpkNBIx+NlOlMytoz794JPFOva8oFKlO2EyUy2ZB4cnl5aWdF3P5XK5XO7O/Z/D95+E7z+ZXfhpduFRLJ6MxWKfnJgaPz+zuLh4cHiSqiycQ2Q21CGZbpS3XsmEEUqmQO35JqX6bm8iXU+UzG0FuE6FoUJuo+AyB2NMXgYYZUW5B6zYnafpTWsP0IOpW5ZN5tERGt7D9zKCRkMiwyzJhCYyO8WhaUM8nH7wjYmdy0ZjuHn6dv9h1JK574j27NmzfD6fz+czmcyhU8G+4bP7h8/2DZ89dCqYyWQ+HjmnTd/IZDJPnz7dd0Sja1NPl4Z9IpFQSSYfmOWUZ8P+Ss8bOoHZuiTTjbISO3JK0FsJi3r9ceYDK9yEbSiZ2wo8gUKP7ZL7YmV1UUU400NF9jZf8nyMZN6IaUrWX5Hlm0fyXK7znXsSSbZjy70PhTgnv7YRvcyGA59+hqFyFKP0E7Pkl27zMvcOnIzH47qup9PpRCKxBLG8vKzrejwe3ztwkq3PBSLZYK3z+I9MMpl6oodX4/7eHp+P///IrUsm2RFSkwHz2ElN2qGsxYJ9PvQy2wLOC6ldsq6XJQ2TgtXh/7X0NrnopSKxU8kAA86Acv8+QgZEZRNUW5TMmsli/9HOYW4a+H/cJPIZ/4TxHVEymwRw+hFZ4qfJad9y0HnyjL/42hm1ZO7xHU+n04ZhXLv7SAvd/mziez4Vi0XTNNPp9B7f8RYYLaYt5actjUKaR90C0wFhqe1H+m+i5EaUTKQJqCWzb0i7OjtnGIYupVgsXp2d6xvSlA02k3ZUJ3z5zw4DFRNBuha1ZM4uPOwfmfzwwBFl6h+ZnF142AKjxbSZZNaCtW1kEYIgCFI3uMQ0giAIgngCJRNBEARBPIGSiSAIgiCeQMlEEARBEE+gZCIIgiCIJ9SSGcsWbj74/cLcY2W6+eD3WLbQAqMRBEEQpPWoJXPmx18Xn6eq1epfHKurq87narW6+Dw18+OvLTAaQRAEQVqPWjLPXb9XKpXW19f/IVhfX19dXS0vPVhbW3NySqXSuev3mm8zgiCIRWcssoh0DWrJ9F+eN03zDcHa2lqlUind/cacfL9arTr5pmn6L89TlZv15ht7LS7wtelNRdQj4ZviG70jBEEoxG9N4pedRnVFtoZaMscvzhUKhb8JyuVy8Yfxl6d3vX79+mV0vlqtWvmFQmH84hxVuQ0l0319usQweuEUkq1JJvNKeOoN9UwdlMyW4b4Zml3UC3zPNPvudLi6XZQYpMGXrsNvYpdXdF+hrljmQ/L6ePFav+Cr45uwxLTTE+5V8dIluqBVyQR9cxSz9gElsy6Y0486ldjVaGRv9qdO6EF39XLpz912qCVzLDij6/qfNpVKxVgIFE68o+u6cXuseGpXpVKxNum6PhacaYHR7IrPGxueJTPso5YegWtYC45sTq+UkmmvYsJIJr5Mb7shPBF3fQ3BMlX2cE2toCFeicsda4CKgkx1RWbRSUgExC0zDZBZgmW55O9B3yT86qCaRhtDGSdZDIp/6TrrU7oH0d6AkrlZoBNJuB6m9BRhFv8if2JPS9m1DWrJPBa4ks/nKzblcrlw9G3rr/WhXC5bm/L5/LHAlRYYvQXJZBqBZNFeQKyhklnzGfmVtVEy2wn7+uUWbXSWctQihiwOyI4t7mqUXEVJa/KK5JAF2qKwE8iH++t+CzXqhfHcIbDsZFb7cr9KRI4RSK6s2xC0ynQn+DPbDnwiQb+JYNU6ArsWG7GQLJ/enqglc2jiUjabLduYpln4enc2mzW+eMs0TdM0c7ncysrKq1evstns0MQlqjIhH9y6mRuCJTDDvp5ev98nDZ6SgVly1Ulu0UoJsJdZa1Egp4wg0kt/8pJp9ZnYCd0scUhgkaUWy+bX6qz1F8O3jcK5y+UW9xNd5HB1QTkPS0x7quh+ld7awxvJYcnxLYX9rZVu2Bor4OqgwjW75StMM0M3P2/JLV6KXmZd8Ld6bADWiGhaJCKO7G/Ujj3wg/InW5ujlswBLZhKpUqlUqFQSCaTyWQylUrlx97NzI6mUqlcLvel/7vx8zdevHiRSCQGtCBV2Rn3AdeLni90BSzsc5RBOJ8HS6YrKOKgK2EYUMKp50EyqX0QnbFLQPOhomaBsmTXfHwwmVNjZIsQ02rMtetJMrlZOX589iiZHio6fpNshPG0ovWgFjGE/SVvIRovmbDykyOyYp+ka8PEaY2IpoVCWihKbUDJrAtJuII4Uci12YHitVNWPIXeKb6/WjL7RwOJRKJYLK6srOw/Gjg4MnX4zPRHx77dfzRw+Mx08Pq8lf/V+ZlYLNY/GqAq0wJDyQKrHk5RcoPzuIzjzzlfQS8TbI31V+P+Xtg1I/ZMfyRaAM3c4AKzPlizhUrMb6E7xPmZbbbMWYdjRDRmgnJTkslW34DvmD1JprIiNSTJtEwa8uWy+f4SZZshmbB6MvFUhcIRfipdMhqJGLjEdINQz0RwMwfgeW6FK2QRlE6YzFRL5sHhyaWlJV3Xc7lcLpe7c//n8P0n4ftPZhd+ml14FIsnY7HYJyemxs/PLC4uHhyepCqzAzvxYA0gmY4c8pLJ4F0ygZrSh35o+J17k8ye3l7QP5ZKJm0W5aDzQV+UzIYBXKfCUCG3UXCZgzEmL5KprCj3gBW78zS9ae0BejB1y7LJPLlEw3v4XkbQaEhkmCWZ0ERmpzg0bYJUMu1Zfm+SyUdjPKhte6GWzH1HtGfPnuXz+Xw+n8lkDp0K9g2f3T98tm/47KFTwUwm8/HIOW36RiaTefr06b4jGlWZGPf9YSaLC8zWvtQvmfTcHyQoskdz2B1sJjALyRpkBDOXGefD0o4xkDYTTaJkNgh4AoUe2yX3xcrqoopwpoeKrJcpeT5GMm/ENCXrr8jyzSN5Ltf5zj2JJNux5d6HQpyTX9uIXmYjYE5RA/AJiR9KHJgl74TIL93mZe4dOBmPx3VdT6fTiURiCWJ5eVnX9Xg8vnfgJFWZGNihJ3PEj//U52X6VE//0M/r1MrVKZn0v3j6wSdmrRJUh+nYNOfO8pJJuL+9Ph96mQ2G80KIQQCeL+Qucq664PlBT5OLXioSO5UMMOAMKPfvI2RAVNjk1iWzZrLYf7RzmJsG/h83iXzGP2F8R5TMBsE5gqCn7uaDx5iL/Q86MV3+4mtn1JK5x3c8nU4bhnHt7iMtdPuzie/5VCwWTdNMp9N7fMepyt03sLesR9136HYMdQtMB4Slth/pv4mSG1EykSaglsy+Ie3q7JxhGLqUYrF4dXaub4gKzHbfG2xa1qPuO3Q7BlRMBOla1JI5u/Cwf2TywwNHlKl/ZHJ24SHVejf5SbUwavN71LIdIQiCIJsBl5hGEARBEE+gZCIIgiCIJ1AyEQRBEMQTKJkIgiAI4gmUTARBEATxBEomgiAIgngCJRNBEARBPIGSiSAIgiCeQMlEEARBEE+gZCIIgiCIJ1AyEQRBEMQTKJkIgiAI4on/B1+UpH0442zXAAAAAElFTkSuQmCC" alt="" />

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAmgAAAAUCAIAAAC28laNAAAGlUlEQVR4nO2cz28TRxTH/Qf01lvPFf9AL5Wl3rlxQ4la2ku0cIh7iNJKCQRBRNmmaiJLuHCwki5ILYgibCHi1kERAkEpPWFBIof1T7x4d806sWSbqqkr9+DM7vzc9Zo4ttP3kZWs38ybnex45rvvzTqBtivponnn0fMfV//wfN159DxdNN1bAwAAAIBRJ+BeHHvwbONlrtls/sXQaDTs42azufEyF3vw7GA6DQAAAACDwkM4L9+6X61WW63WvxitVqvRaNS2Hu3u7tqWarV6+db9A+kzAABAu902knJISQ26F8D/Dw/hDF9fsyzrH4zd3d16vV6997219HGz2bTtlmWFr68Rzmo4GAiGVW7DCSkgJbqtDAAAwCWlhOSkwS8hClIKaCywX3gI58LVVdM0/8ao1WqV3xbefHNkZ2fnTWqt2Wx27KZpLlxdJZxBOIHhJ6WE9sCXWdvqZTSSMqemXeQs1UZSJmtwT0E68vvmuPMVg+vl1pSoh0Jjj9AaZyTlEClmztUU9JSswAV52bq5dwDC6QvnA8NcV1+zAPkQMyEUoj/gbh/MYcRDOOejMV3X3yLq9bqxHjHPfqDrunF3vnLhSL1e7xTpuj4fjXV9XkY4AWAAYFFJSkGruJGUQ/ai62p0jtjIx5EctKxQKw3TGuXI7Rvmz19quF5uTQl6KDC+C9QlMpKyLJOpVuJeg9tTux5dQsWXztVHBSCcPeMMi+9Z0EZmdO2JUcWruwz3EOIhnKcjNzRNqyNqtZo5+37nZ+egVqt1ijRNOx250fV5QTiBYQPNYmL1Rm+4RmKZoGIzu2xvraHrsq3Rjry+YR6KMEfppynUHN1DvvHdYE7QaR/728lL4SJ1lEwydZ2GmMhp1GKbweOMm+9Z4LRgR5jcSUK3PfR4COf04rVisVhDWJZlfvdRsVg0vnrPsizLskqlUrlc3t7eLhaL04vXCGc1HAxIic5vJJMJqXPITdUiixoOBvbATVIiIQUCkNAF+oJ9x0uuwXtzW2QUiCErT4SB25rAkegbdiJvSePew9tGLHhwP3N/hNOJqwXXkOkf3Rb+p7H7mSF0v4OlGEdnXR4i8DHxOwuwmkqKM6CY62jpppdwTsrRXC5XrVZN08xms9lsNpfLafMfFuLncrlcqVT6OvzTwsrtV69eZTKZSTlKOGNamJACwbCKfrVdhVMNS0gakcwiLYUgFegP2HYbNwDkR4X4Jp29VqN31CrgcnNNJazo5YPcCsT13U3S2A1EyjhY4XSO6QvTZViIhzZU5tZIyrKiyEqKKADh7Anvz614FuA1uUN6aPc4J85FMplMpVIpl8vjs5ETc1dOXVz+9PQP47ORUxeXo7fWOvZvV2LpdHriXIRwxoPIdkIK4NGia8TJiTnJYgDYP4ykTD9H02XE2SYelUgqbnfPXUWcjCOnb1gEJVpqaC+xUdhDV2OPCDrPDTu62PHCYlayZiqZNNhdUBDOXiDH39csIFvp5Eg80jCjM0IewnliZmlra0vX9VKpVCqVfn34Z+Lh08TDp/H13+PrT9JqNp1Of3H2ysJKbGNj48TMEuHcm3Cq4aBdDw9DQTiBPsCZrdzUk3c+yllURMWCfCz56AW5MLk9dCq4T3dP0LrQb+HE/jp245G9AF12WXAz0BFO3gbnyAU3g4Qafj+zgGel0yCMLI/MwHgI5/EpeXNzU9M0TdMKhcLJC9GxmUvjM5fGZi6dvBAtFAqfz12Wl28XCoUXL14cn5IJZyZVi33lBAmnbbIrO+lcfHMUhBPoA/yNFXKFZ4NB3gT33K3hPN7jcgphM6IGXb2ExoNM1bo8SEzsuxJ7uZ7JaFlRuIE0RJz7ATP63c8C2o7fD+FvDmfEeWzyvKqquq7n8/lMJrPF4/Xr17quq6p6bPI84YzELiERISTxcBArnFiaNihJEHECfYSJSLCYkTAIjLzvrwm++UivKWxr7GO53L6JGnTx4hoPUDj3zi+OJZGFUnjuPi2yU7EKFUeCcO4DPCnrchYwDVGZlBDKsos/4EONh3Aelc7k83nDMH6590RW7n65+DP7qlQqlmXl8/mj0hnC2ZfYgTICh4KelWaUElUDQ/z9VaoQhBPoJx7COTYt34yvGoahu1KpVG7GV8emiVStr/8FBP84CDgUgG4CwOHHQzjj648n5pY++WzK8zUxtxRff0w03WUE2XlsCMJNAAAAYBTwEE4AAAAAAHBAOAEAAADAByCcAAAAAOADEE4AAAAA8MF/sJvgjgBgDRoAAAAASUVORK5CYII=" alt="" />

实体类

 package bean;

 public class Question {

     private String timu; //题干
private String leixing; //类型
private String axuanxiang; //A选项
private String bxuanxiang; //B选项
private String cxuanxiang; //C选项
private String dxuanxiang; //D选项
private String daan; //答案
private String jiexi; //解析
public String getTimu() {
return timu;
}
public void setTimu(String timu) {
this.timu = timu;
}
public String getLeixing() {
return leixing;
}
public void setLeixing(String leixing) {
this.leixing = leixing;
} public String getAxuanxiang() {
return axuanxiang;
}
public void setAxuanxiang(String axuanxiang) {
this.axuanxiang = axuanxiang;
}
public String getBxuanxiang() {
return bxuanxiang;
}
public void setBxuanxiang(String bxuanxiang) {
this.bxuanxiang = bxuanxiang;
}
public String getCxuanxiang() {
return cxuanxiang;
}
public void setCxuanxiang(String cxuanxiang) {
this.cxuanxiang = cxuanxiang;
}
public String getDxuanxiang() {
return dxuanxiang;
}
public void setDxuanxiang(String dxuanxiang) {
this.dxuanxiang = dxuanxiang;
}
public String getDaan() {
return daan;
}
public void setDaan(String daan) {
this.daan = daan;
}
public String getJiexi() {
return jiexi;
}
public void setJiexi(String jiexi) {
this.jiexi = jiexi;
}
@Override
public String toString() {
return "Question [timu=" + timu + ", leixing=" + leixing + ", axuanxiang=" + axuanxiang + ", bxuanxiang="
+ bxuanxiang + ", cxuanxiang=" + cxuanxiang + ", dxuanxiang=" + dxuanxiang + ", daan=" + daan
+ ", jiexi=" + jiexi + "]";
} }

Excel转成JSON

 package Action.Excel2;

 import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import net.sf.json.JSONArray;
import net.sf.json.JSONObject; import java.io.File; public class Excel2JSON { /**
* 将Excel数据转为JSON格式数组(题对象list)
*@param name Excel路径
*@return Json格式数组
*/
public static String excel2Json(String name) {
Sheet sheet;
Workbook book;
Cell cell1, cell2, cell3, cell4, cell5,cell6,cell7,cell8;
JSONArray array = new JSONArray();
try {
//为要读取的excel文件名 "F://a.xls"
book = Workbook.getWorkbook(new File("F://a.xls")); //获得第一个工作表对象(ecxel中sheet的编号从0开始,0,1,2,3,....)
sheet = book.getSheet(0); for (int i = 2; i < sheet.getRows(); i++) {
//获取每一行的单元格
cell1 = sheet.getCell(0, i);//(列,行)
cell2 = sheet.getCell(1, i);
cell3 = sheet.getCell(2, i);
cell4 = sheet.getCell(3, i);
cell5 = sheet.getCell(4, i);
cell6 = sheet.getCell(5, i);
cell7 = sheet.getCell(6, i);
cell8 = sheet.getCell(7, i);
if ("".equals(cell1.getContents())) {//如果读取的数据为空
break;
}
JSONObject object = new JSONObject();
object.put("timu",cell1.getContents());
object.put("leixing",cell2.getContents());
object.put("axuanxiang",cell3.getContents());
object.put("bxuanxiang",cell4.getContents());
object.put("cxuanxiang",cell5.getContents());
object.put("dxuanxiang",cell6.getContents());
object.put("daan",cell7.getContents());
object.put("jiexi",cell8.getContents());
array.add(object);
}
System.out.println(array.toString());
book.close();
} catch (Exception e) {
e.printStackTrace();
}
return array.toString();
}
}

JSON转成List

 package Action.Excel2;

 import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map; import org.junit.Test; import com.google.gson.Gson;
import com.google.gson.reflect.TypeToken;
import com.sun.org.apache.bcel.internal.generic.Type; import bean.Question; public class JSON2BeanList { // 测试JSON转list
/**
* 将字符串转为list集合对象
*@param json json数组字符串
*@return list集合
*/
@SuppressWarnings("unchecked")
public static List<Question> json2list(String json){
List<Question> list = new ArrayList<Question>();
Gson gson = new Gson();
list = (List<Question>) gson.fromJson(json, new TypeToken<List<Question>>(){}.getType());
return list;
} }

测试:

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAABBIAAAD8CAIAAABFOxBwAAAgAElEQVR4nO3dz08j9+H/cf8re+G2/4DP0d7Q/gco7Xdrpe0hEdseokRRo6ZRDl2Jhh6qSJV6WSldwy7gZcAlEAploSACAiPKj9A0alRlGzXapmk+yW7X34ONPZ6Z98x77JnXzJjnQz6AGQ/mZc+befnt8ZSeAAAAAECoUtZ3AAAAAEDeURsAAAAARKA2AAAAAIhAbQAAAAAQgdoAAAAAIAK1AQAAAEAEagMAAACACNQGAAAAABGoDQAAAAAieGtDHTGl99hk/ZcNDyIFAAAYUEBtaMJaPeXakPXfNwzqvbUh67sDAABQSNSGgVAb8o/aAAAAMDhqw0CoDflHbQAAABgctWEg1Ib8ozYAAAAMjtowEGqD0ueff35ychL3VonUhpGREc8XsW6V+E1sFvMsk+CaAQDAFURtGAi1QeaNN964devWD37wg3feeSfWDZW1YSSK/S8afDFqAwAASBC1YSCxasPY2NjY2FjiteHp06fHx8dbW1uPHz9+/vy556fffffdd999l8KfHuCbb745PDz86KOPEl/z3bt3x8bGvvjii9dff31ycjLWbROsDXHLQKyOEXKTwMUi70YftYHOAAAATOLVhsBdk7ivpw6TPNSGr7/++sMPP6xWq9PT04eHh99++23r+u++++7vf/97o9H48ssv08yg7dmzZ1tbW7Va7dNPP0185T/84Q9/+tOf9nfbwWtD5D6959s+phpMtSTwDvRXAOLe6qptywAAIFwCtSF8gYIaC+JfLCdvUvryyy///Oc/V6vVarW6sbHx73//+/Hjx+vr62tra59++umzZ88SzSbAs2fPlpaWarXawsLCZ599luCa33zzzU7+3//+9/tYQ1K1waYz9C3wVwTWBsvf2EdtGNZtGQAAJCJGbYh8pXPI9jMiO0MzN7Wh2Ww+e/bs4uJiaWmpWq3W6/XFxcXd3d2vvvoqoTDCPH36dHFxsVarOY7zl7/8JfH1/+53vxsbG5uenu7v5gPWBpv3//iXj/UmIs+W5d/Qwqc7Qu5zH3cm1i8CAABXR2K1YSj3M8I7QzMfb1JyOz4+bs05PHz48Ouvvx7srw/w5MmTv/71r//73/861zx9+nRhYaFWq9Xr9T4+5sjGG2+8MTY29t///rfZbD5+/Pj4+Lj1xfn5uc3NB6kNpud8H+U5ZLIicpfdNO0QWAMSuc9DuTkDAIBBUBsihHSGZp5qw/Pnz09PT2dnZ+fn51dXV6empj766CP3/n0iPvjgg1qt9uGHH7bW/H//93+PHj2q1WpLS0uHh4fJ/q6OSqXy4x//uNlsvvbaaz/60Y+mpqZmZmZu377985//3ObmCR7b0OzdCkxNwPIFfv/KI68J6R59rDbukgAA4CqjNgwkJ29Sev78+dHRUbVanZube/z48dOnT7e3t6vV6scff5zs3+s4Tq1Wq9VqW1tb//nPf1rHQM/Pz1u+8N+Hzz//fGxs7O233242m5999tlvfvObsbGxVouwlF5taA68y94MehNUrNowYBmgMwAAAEu2tSHWG6OvjjzUhufPn3/88cfVanVmZuYf//hH68qnT59ubm7Ozs7+61//SvDv/eqrr2qXWscz/OEPf0i8nLhVq1X3gQ2/+MUvxsbG3n333S+++MJyDWl8klLgfnzIPINp2wms4oHbV8jNw++zzcKxlgEAAFdTjNoQ+LXpmisiD29S+uyzzx48eDA9Pf3JJ5+4r//222//+Mc/Pnr0KNnzNnz11VedOYfWG5ZS/aSmt99+u1KpNJvNn/zkJ6+99toHH3zw8ssv37p16+WXX7ZcQ6q1oTnYk9+0ZlM9sP+9fWykbNcAACAEtWEgeagNf/vb3z744IPWgcIe33zzzfb2dmcKIkEbGxutj1v95z//mfjKW773ve9tbW299NJL9+7dazab9tMLHml8AGvI5mA5z2BaSWBtMN2lkGvibqSmn17ZTRsAAHhY1Qb3fk/cN0sMtzy8SSkTT58+PTs7S+mjk1refffdd9555/e///2A60n22AbTNZE/stlkEpxMsL/PIT3HVHgAAMAVFO90b/C4srWhQBI/JDp8T7rvne8+5gdC1h93bbHuGAAAuIKoDQOhNuTf4LUBAAAA1IaBUBvyj9oAAAAwOGrDQKgN+UdtAAAAGBy1YSDUhvyjNgAAAAwuoDYgllRrAxJBpAAAAAPy1gYAAAAA8KA2AAAAAIhAbQAAAAAQgdoAAAAAIAK1AQAAAEAEagMAAACACNQGAAAAABGoDQAAAAAiUBsAAAAARKA2AAAAAIiQZG1YXFxsQIvM9chcj8z1yFyPzPXIXI/M9RYXF5Pa1U+yNiwsLGSdzJVD5npkrkfmemSuR+Z6ZK5H5noLCwtJ7eonWRscx8k6mSuHzPXIXI/M9chcj8z1yFyPzPUcx0lqVz/J2jA/P591Mn1YefOtG9du37j26/ezvif9KFrm79+6feNaz+XFN/+U9Z2KqWiZNxqNRmP+VVfmr/4267sTV9Ey9z3PCzi8FC3zRuNPv3qh4MNL8TIPGNJv3CrUH1HAzH1P9bd+Vc/6HsVStMzfv9Uzhrd2Ggv2b3R+fj6pXf1Ba8Mnn3zS+frhw4dZJxPfn371wu0bL7z1YuGeBC1Fy9yz+bX+5RQs+aJl3qjffdH1v7w15BVsd6pomfc+z1v/44vWHIqWeVFzdite5q2netF2W92Kl/n8q9du33jh7kr729bTvlAPQdEyH4ba8PDhwwH39jsGqg2ffPLJo0ePOt8W7anQaLT3qF797fyrhduRaila5p7Nr/HbX7MLmzZv5kVU9Mx5nitQGzJAbRArfOCNgmZObbjUf21odQZ3bajValknE9fKm2+1ng3v33LX9+IoWuZBsw1FGwELlvn8q4V724BfwTL3V7UCPgpFy3wYakPxMi/mGO5WsMw9Uw3FVLDMh6I21Gq1JCrDkyd914ZOZ3DXhrm5uayTian1DqW7K+3nQQHHvqJlPgzHNhQr8953KBVVsTI31YZi/bMvWuZBxzYUbUgvXubFrw3FypzxPAsBB/AUrjbMzc0l1Br6qg3uzuCuDbOzs1knE0/97oud3Vb31wVStMwDW3vBBsFiZT4c/2aKlflw1IaiZT4Msw3Fy9y/R1W0ClGszIMOVCveC3DFynw4ZhtmZ2czqw2ezuCuDTMzM1knE0vvY1/A/+uNRqNomQ/D7lTBMi/g22P8Cpb5ULxJqWiZD0NtKF7mxZ9tKFjmQf8xC3foVMEyH4raMDMzk01t8HcGd2148OBB1snEEfBpfcUb/gqW+VDUhsJnXkBFz7xw/9cbxct8GGpD8TIvfm0oWuYBgRdueClk5gWvDQ8ePMigNgR2huLWhtZkn2uHtZAfTFmszNmdysQQfABr0TIfhg9gLVrmRc3ZrXiZUxv0WifhuXyet4b3Yg3pRcuc2tBXbTB1BndtuH//ftbJ2AvYefIViQIoVOaNITg3UKN4mTcajcKf7q1omQ/D6d6KlnnwBHKxhpfiZV782lDAzBv+EYbneZqGoTbcv39fXRtsTE9PZ53MlUPmemSuR+Z6ZK5H5npkrkfmetPT00nt6idZG6amprJO5sohcz0y1yNzPTLXI3M9Mtcjc72pqamkdvWTrA2+z7XlwoULFy5cuHDhwoVLlpekdvVLFxcX5+fnp6enJycnx8fHR0dHjUbj4OBgf39/b29vd3d3Z2dne3t7a2trc3NzY2NjfX19bW1tdXV1ZWVleXl5aWmpXq8vLi46jlOtVjPPhQsXLly4cOHChQsXLp1LNSFJzjZUq9UmAAAAgHxoNBpJrYraAAAAAAwnagMAAACACNQGAAAAABGoDQAAAAAiUBsAoFjOJsql8sRZ6xunUup+c/lTz1XhnEqpVIp3k9bvKJUqjvv7y+9iaP/uPu5tiKi1Xd77fu4wAFxh1AYAKJieZtDaj+7uKnf2q213itt70TH2oQNu0b4qxv5/91axbuT9cwN+aPe3xFkWANCkNgBAAblfpe956d9q9713fiF2bWjfvPcG3gkIs86L/X1NGFjUBvsa0lqe4gAAVqgNAFA87r10V4ewevneUy3i1gaLtwmF7v+H/b7o+5JobehvjgQArihqAwAUkHsPuXN8g1Ox2An27poH7aqfTZRN++4Dv0JvMdsQWRsiqspEJd4blegNAGCB2gAAxWHzDh/vTvRZ32vw704ncDhx6rMNlYmJslUV6FYQegMARJPXhsPJ0ZHxGrUBAOI7s9whvlyyUvHOGvgnC+K8SSnwqAij4FWmWBtiLNPsnbigNwBAJHFtqI2PjIxQGwCgH+394bJxb731o/KEY/pE1IC3MdnXhmRenR/sTUoxDq2IuJOX5cKJ/UlSAHA16WrD4eToyMjI6Pg4sw0A0I+o0yO0D4iuVCrlcuBOc+BkhW1tcCqlUsVxH3QdtQcfvN8+2GyDSdxTR7h/U9wjqQHgahLWhlrt8AlvUgKANFicOM3wDiffrnrP6eRc63d93GvKsw19rP5yrZ1Dw+O8jynwI2UBAL04tgEACi6wMpxNlHt3hC/3pa3f5RMyH5BAbeieZsL1e4xr7+kaIe/Ssqsfvl9jf9YJALi6qA0AUAyxTpgQsffvEu+NQb173OF3KfztVD1vdIrTQy4nPvr9KwK7CcUBAKJQGwCg4AZ7b/7gtcF705AZiXZfcL+lyFccnErE3Qk6S5v1X2E870TP25wAAD7UBgAouOLUhssPcur5na5jLlqHXUdPQfgXsPsrwt9i1X0nFHMOAOBHbQCAgitKbej+JsPv7B7qEFUcfAcxW/wVNodluN91RXcAgB7UBgAouHRqQ/uV/8ClbY5tMBw8UCpPnJl+p6ssGN9LZLiPUbXBPiP30dc0BwDoktcGO9QGAIjg2We3en9OfIF7/30f22Bzb2IeHh190/7PBgEA6KI2AECRifeJfbUhD0cQ0wsAQIDaAAAAACACtQEAAABAhCRrw8XFxfn5+enp6cnJyfHx8dHRUaPRODg42N/f39vb293d3dnZ2d7e3tra2tzc3NjYWF9fX1tbW11dXVlZWV5eXlpaqtfri4uLjuNUq9UGAAAAgKHDbEOxNZJrkLBE5npkrkfmemSuR+Z6ZK6XYObUhmJj89Mjcz0y1yNzPTLXI3M9MtejNqAt55tf69MV87OeROQ880C5CrAPZK5H5npFzNyjcA9BDjP3Zxg31Zw/CoXIfMBb5e0hoDZYsfp0c8P2ab98tnK++Zm+9i8fnnOuYs9h5m6BmccNMG9PfjLXI3O9nGfuMRwPQQ4z9//54YGEZJiHZ7Vf/jO3TC/8+mHNfPhrg/9r/7eWK8mhHG5+zaB/IZExBi5pf3OlfGbu1kf+kavKFpnrkble/jP3GIKHIG+Zl3zm5ub8V5Zi7s/k5BnekvPMPdc3zem5rzetJCeoDVZMm1msBzWfz4COvG1+HvbpBW6fkRttJnKeedOXW8j/G9MynvVkjsz1yFwv/5l7DMFDkLfMQ8KxSSk/T+YQ+cy86UsvMvmcPIdtUBushGx4pnEtfCU5lKvNz/SfwybzwO0z1nApk4fM4z51+1s+7saSnqwyjxsCmSfIMgoyT9yVetrnJPMWUzKBC/gXsyH9ewzymXmpVHrvvfc814c8Cm6//OUv8xNvIGFtOJwcHWkbrxWyNnge9VKp9Prrr7sXsFlJ6ve1X7na/NwsR6uQ0c29HebqUchD5nEDiftU9y+f7UOQYeaB/zD6uGHkMmTu1l/sZJ6Uq/O0z23mzd7/j4OsIcl7mYRcZe5/D9jo6Gj4U9R9c5vF8kBWG2rjnbZQGx8ZGZ08LFJtCFQqlV5//fWSdTu8Ok+FBHVC839hf5NYN1fKPPNSqfTee++F/4+JFLjakOSzfQhyWxvIPCUhsZO5gD+HYX0I8pO5mye9kDD9N8nJkzlE3jIvXZaH1j/W0dFR949MGZoeI5tNQE9VG2rjrqZwODkaMeGQn9pgevBaVcFUG0Ie9avwVEiKf0Pyf215k8AFMpd55iVDbXAv4M8zMsPwW2X7EOS2NgReT+YDsvzDyTw9/hwiR+aCPgT5ybyldCnWjwIXy/bJHCKHmftrQ8k1EWG6lTvkwGd1fmRybINr5iH3tcHN8/iVmG1ITeQ4FT4aBi4TuenqZZ55idogVPIJWczzNZn3x/IPJ/P0+HMITGYIHoK8Ze4OIXDwcX/tv63nR4FXZi4/mbd40uvUBlOqzd7/wiXf/mTeAm9mUhsOJ0ej3qNEbchA3jY/j/4SDhz4Url/fcnPmzdMyQQuExlj+K2yfRTyswtL5gKWfziZpydyWPZfWdCHID+ZJyjbp3GkvGVe8s02RD4bS74X70xf54S6NhxOjlocEZ272lDqrYOe50Ef/5lyKD+bXykm960CVyX/C2zloTaEP4cDhzybcTBk4WwflFztwoY/acl8cJZ/OJmn5+o87fOTeUcpVKyFI2+eibxlXop5bEP40950q2xJa8Ph5GjkwdD5rw3uK2M9tDl8+N3ytvm52Q9VRRnsWvJQG/xfBy4TuHD4rUquibhSqfTSSy+F/y6NXO3C9vGPhMxjsfzDyTw9V+dpn5/MO8Jzs7mtWzr3cSB5y9yTWGe2ITLMwKd9M+thJJCuNljOMxSlNlgOhbEWyFbeNr+OQTYhMjexfAKbhrnA68PHxJdeeikPDweZ65G5Xn7G86vzEOQn8w5TDpH5dBbwf5Erecu887SM9UlKnp+avs4JVW2wOaAhr7Wh1GvA9SR4x5KVt82vxfJfjv3NcyXnu1N9PO1N/8jzMwiSuV7OZ9XIPFWeKIb4IchP5h2mEELC8TwQ/q+zfWJ75CrzTjilAWqDzfaSLVFtqI2PeBTok5Q8D2c4m/XkU642v2boCBX4I5tHx/KRksnDGYvDr/H/dPCnfbb55yFzU3RknpKQ3Mg8VTYxDs1DkJPM3WKFGXi96ZoMn9tuucrcE0uJ2hDF/gNYizTbkOBjlsOH3y0/m5/lqJSrwas/+ck8JaYHKMMHjsz1yFxv6DP3yMNDkMPMB48l5/9k85N54O5+3NpgU9syR21AW342v6uDzPXIXI/M9chcj8z1yFyP2oA2Nj89Mtcjcz0y1yNzPTLXI3O9JGvDxcXF+fn56enpycnJ8fHx0dFRo9E4ODjY39/f29vb3d3d2dnZ3t7e2tra3Nzc2NhYX19fW1tbXV1dWVlZXl5eWlqq1+uLi4uO41Sr1QYAAACAocNsQ7E1aO1yjUaj9LOS+5L1PRp+ZK5H5npkrkfmemSul+C+IrWh2KgNep4hL+u7cyWQuR6Z65G5HpnrkblekWpD6fLTqazuTZyPfx58Gc8R9IP/Rj3fU8GplCqO95ryxFnwAu1vzibK7kUQyj3kZX1frgoy1yNzPTLXI3M9MtcT1obuuRuiz/vWR20oRQlczLRC/60i/vghrA3NplMpdYuBpzN4rrusENSGODpDXveqs4myt60hST2Zn02UL7d0Qk9PT+ZO5TJyRooUMbbokbkemeupaoP7LNG18aizvQXUBtN+f0iLiL7HQSdx8/zI5peGfxtyx3LVH9xPBdfeVAD/jINheXYLIrSGPNcVrV0qhrwUuTJ31WKnwtM1Pd3MzybKnZx7XpVAwnxjS2twIfAUMZ7rkbleJm9Sqo1HTTiE14bA65uhEw4hy4f8Fk95MP7lw1gbXPtQPW9GCppOcE1EMNsQh7+qlSsVXilJVTfznvkzXqFKkeHfTNAEJhLizdyplMplnuOpYjzXI3O9DGqDe+LBsjZ09u9NswHx7mjQGbybQTv0/mUC12ZfG3LbGZrxZxva7zXw/N+nNsTRk7njnDXZfU2deReW3NMSmLl74gGJ6838bKJccRhbUsZ4rkfmetracDg5Gv/YhsCGELjPbTPbELhC/9o8sw3hcxemxcLvc85rg9Vsw9lEuTzhhHQMNt5QAZsfQ17K2IXV82beflmCxFMUMJ4ztqSM8VyPzPWyeJPSwMc2NON0icDrI28YuP6+12Z/VzPUz7ENPR3isl34P4EJBgx5ev7MzybKFNxUBf+bYYInTa7MnUprlGZsSRnjuR6Z6xX12AbPt52vTUxrC/zW/1vc6w/4y+3WFrJAHvQ923Dm+bqzOP0hCkOenifzs4kyL3unjWMb9DqZd4dhxpaUMZ7rkbneUNUG/7ch15hW2LnSXRJMhcHyPph+mqv+YH4qmHf/u7XB9Uk0fBarNYY8Pd+sGmmnjtqgd5l59/Nueeto2hjP9chcT1Ub3G9MOpwcjXlIdNPcFjx79jYTDpa1wfQj08Kmb8N/lJ/m4H51KlpnYqE8cebZ+eq+w4l9gggMeXrdzDmgQaXn06s6T29eV0gTY4semeuRuZ5utqF9OPTISOSBDeGzDYHfhlzZDH2B3+a1/6Rqg02lyVDs2QanUipVKrw/eQAMeXoh9ZjcU2I4boq8U8TYokfmemSul8mblKKF1wbTrnbc/XL71/7DV2hZG0wKWhsuj7MLPX6ajTdUgpsfLJG5HpnrkbkemeuRuV5hagPSxuanR+Z6ZK5H5npkrkfmemSuR21AG5ufHpnrkbkemeuRuR6Z65G5XpK14eLi4vz8/PT09OTk5Pj4+OjoqNFoHBwc7O/v7+3t7e7u7uzsbG9vb21tbW5ubmxsrK+vr62tra6urqysLC8vLy0t1ev1xcVFx3Gq1WoDAAAAwNBhtqHYGrR2uUajUfpZyX3J+h4NPzLXI3M9Mtcjcz0y10twX5HaUGzUBj3PkJf13bkSyFyPzPXIXI/M9chcr0i1oWQ4i0LwvbH+eCKbJSOX8XzQ0+C/Uc/3VPB/gJLn9Ew9C7S/4bPY43APeVnfl6uCzPXIXI/M9chcj8z15LXhcHK0r/M2NKNqg/EzQHs/MtV/ZeAK/beK+OOHsDb0npsp8JSu3es4NXQ/OkNe9yo+czplPZlzEgGJnsy758tgpEgRY4semeuRuZ66NtTGBz3dm6kPmJYPu8eXtSGwXdj/0vBvQ+5YrvqD+6kQdiqGUsCMg2F5dgsitIY81xWtXSqGvBS5MnfVYqfC0zU93czdZ+Z2OFVkinxjS2twIfAUMZ7rkbmetjbUxkdGR/ubbTC98O/ZCzcJWT7kt3jKg/EvH8ba4NqH6nkzUtB0gmsigtmGOPxVrVyp8EpJqrqZ98yf8QpVigz/ZoImMJEQb+ZOpVQu8xxPFeO5HpnrKWvD4eToeK2vNyl19u9NswHx7qhrksF/ffgygWuzrw257QzN+LMN7fcaeP7vUxvi6Mnccc6a7L6mzrwLS+5pCczcPfGAxPVmfjZRrjiMLSljPNcjcz1dbTicHB2dPOzj2IbAhhC4z20z2xC4Qv/aPLMN4XMXpsXC73POa4PVbMPZRLk84YR0DDbeUAGbH0NeytiF1fNm3n5ZgsRTFDCeM7akjPFcj8z1ZLWhNj46efik/0OiS0HzDJY74qZWELmAqZzEXZv9Xc1QP8c29HSIy3bh/wQmGDDk6fkzP5soU3BTFfxvhgmeNLkydyqtUZqxJWWM53pkrieqDbXxy66QaG1o+iYNTExrC/zW/1vc6w/4y+3WFrJAHvQ923Dm+bqzOP0hCkOenifzs4kyL3unjWMb9DqZd4dhxpaUMZ7rkbmepjbUxke8wqtDf7XB/23INaYVdq50lwRTYbC8D6af5qo/mJ8K5t3/bm1wfRINn8VqjSFPzzerRtqpozboXWbe/bxb3jqaNsZzPTLXK8x5G0xtwbNnbzPhYFkbTD8yLWz6NvxH+WkO7lenonUmFsoTZ56dr+47nNgniMCQp9fNnAMaVHo+varz9OZ1hTQxtuiRuR6Z6xWsNpi+DbmyGfoCv81r/0nVBptKk6HYsw1OpVSqVHh/8gAY8vRC6jG5p8Rw3BR5p4ixRY/M9chcT14b7ITXBtOudtz9cvvX/sNXaFkbTApaGy6Psws9fpqNN1SCmx8skbkemeuRuR6Z65G5XmFqA9LG5qdH5npkrkfmemSuR+Z6ZK5HbUAbm58emeuRuR6Z65G5HpnrkblekrXh4uLi/Pz89PT05OTk+Pj46Oio0WgcHBzs7+/v7e3t7u7u7Oxsb29vbW1tbm5ubGysr6+vra2trq6urKwsLy8vLS3V6/XFxUXHcarVagMAAADA0GG2odgatHa5RqNR+lnJfcn6Hg0/Mtcjcz0y1yNzPTLXS3BfkdpQbNQGPc+Ql/XduRLIXI/M9chcj8z1yFyvSLWhZDiLQvC9sf54IpslI5fxfNDT4L9Rz/dU8H+Akuf0TD0LtL/hs9jjcA95Wd+Xq4LM9chcj8z1yFyPzPWEteFwcrRzjujRycOka4PxM0B7PzLVf2XgCv23ivjjh7A29J6bKfCUrt3rODV0PzpDXvcqPnM6ZT2ZcxIBiZ7Mu+fLYKRIEWOLHpnrkbmesDbUxi3O82asDab9/pAWEX2PL2tDYLuw/6Xh34bcsVz1B/dTIexUDKWAGQfD8uwWRGgNea4rWrtUDHkpcmXuqsVOhadrerqZu8/M7XCqyBT5xpbW4ELgKWI81yNzPV1tqI1HzjHY1obA65t2p3vzLx/yWzzlwfiXD2NtcO1D9bwZKWg6wTURwWxDHP6qVq5UeKUkVd3Me+bPeIUqRYZ/M0ETmEiIN3OnUiqXeY6nivFcj8z1ZLXhcHLUvjV4a0Nn/940GxDvjromGfzXhy8TuDb72pDbztCMP9vQfq+B5/8+tSGOnswd56zJ7mvqzLuw5J6WwMzdEw9IXG/mZxPlisPYkjLGcz0y15PVhtr4yOjoqN2RDb21IbAhBO5z28w2BK7QvzbPbEP43IVpsfD7nPPaYDXbcDZRLk84IR2DjTdUwObHkJcydmH1vJm3X5Yg8RQFjOeMLSljPNcjcz1VbTicHO22heijHCLfpGTfJQKvj7xh4Pr7Xpv9Xc1QP8c29HSIy3bh/wQmGDDk6fkzP1We8QAAABHTSURBVJsoU3BTFfxvhgmeNLkydyqtUZqxJWWM53pkrpfJB7BGH+ZgWRuavkkDE9PaAr/1/xb3+gP+cru1hSyQB33PNpx5vu4sTn+IwpCn58n8bKLMy95p49gGvU7m3WGYsSVljOd6ZK43VLXB/23INaYVdq50lwRTYbC8D6af5qo/mJ8K5t3/bm1wfRINn8VqjSFPzzerRtqpozboXWbe/bxb3jqaNsZzPTLXU9WG2vhI541JFkdHm2qDvy149uxtJhwsa4PpR6aFTd+G/yg/zcH96lS0zsRCeeLMs/PVfYcT+wQRGPL0uplzQINKz6dXdZ7evK6QJsYWPTLXI3M93WyD62xv0advCJltCPw25Mpm6Av8Nq/9J1UbbCpNhmLPNjiVUqlS4f3JA2DI0wupx+SeEsNxU+SdIsYWPTLXI3O9TN6kFC28Nph2tePul9u/9h++QsvaYFLQ2nB5nF3o8dNsvKES3Pxgicz1yFyPzPXIXI/M9QpTG5A2Nj89Mtcjcz0y1yNzPTLXI3M9agPa2Pz0yFyPzPXIXI/M9chcj8z1kqwNFxcX5+fnp6enJycnx8fHR0dHjUbj4OBgf39/b29vd3d3Z2dne3t7a2trc3NzY2NjfX19bW1tdXV1ZWVleXl5aWmpXq8vLi46jlOtVhsAAAAAhg6zDcXWoLXLNRqN0s9K7kvW92j4kbkemeuRuR6Z65G5XoL7itSGYqM26HmGvKzvzpVA5npkrkfmemSuR+Z6RaoNJcNZFILvjfXHE9ksGbmM54OeBv+Ner6ngv8DlDynZ+pZoP0Nn8Ueh3vIy/q+XBVkrkfmemSuR+Z6ZK6nrA3dMzdEne2tn9pg/AzQ3o9M9V8ZuEL/rSL++CGsDb3nZgo8pWv3Ok4N3Y/OkNe9is+cTllP5pxEQKIn8+75MhgpUsTYokfmemSup6sNtfHLunA4ORpVHELO22DqA6blw+7xZW0IbBf2vzT825A7lqv+4H4qhJ2KoRQw42BYnt2CCK0hz3VFa5eKIS9Frsxdtdip8HRNTzdz95m5HU4VmSLf2NIaXAg8RYznemSuJ6sNtfHoOQbb2hB4fdPudG/+5UN+i6c8GP/yYawNrn2onjcjBU0nuCYimG2Iw1/VypUKr5Skqpt5z/wZr1ClyPBvJmgCEwnxZu5USuUyz/FUMZ7rkbmeqjYcTo6OjNdsW4O3NnT2702zAfHuqGuSwX99+DKBa7OvDbntDM34sw3t9xp4/u9TG+LoydxxzprsvqbOvAtL7mkJzNw98YDE9WZ+NlGuOIwtKWM81yNzPVVtqI2PjE7WLg9uiCwQ7toQ2BAC97ltZhsCV+hfm2e2IXzuwrRY+H3OeW2wmm04myiXJ5yQjsHGGypg82PISxm7sHrezNsvS5B4igLGc8aWlDGe65G5nrA2dI6E7h7lYDvb0LR7+5BpR9zUCiIXMJWTuGuzv6sZ6ufYhp4Ocdku/J/ABAOGPD1/5mcTZQpuqoL/zTDBkyZX5k6lNUoztqSM8VyPzPWksw2XTSH6HUuWtaHpmzQwMa0t8Fv/b3GvP+Avt1tbyAJ50Pdsw5nn687i9IcoDHl6nszPJsq87J02jm3Q62TeHYYZW1LGeK5H5nqZHNuQVm3wfxtyjWmFnSvdJcFUGCzvg+mnueoP5qeCefe/Wxtcn0TDZ7FaY8jT882qkXbqqA16l5l3P++Wt46mjfFcj8z1pB/A6nqTUsTRDaba4G8Lnj17mwkHy9pg+pFpYdO34T/KT3NwvzoVrTOxUJ448+x8dd/hxD5BBIY8vW7mHNCg0vPpVZ2nN68rpImxRY/M9chcL5vTvcU6JLq99vjHDwReH7Iem5vb3JmQ9URWmgzFnm1wKqVSpcL7kwfAkKcXUo/JPSWG46bIO0WMLXpkrkfmesraEEN4bTDtasfdL7d/7T98hZa1waSgteHyOLvQ46fZeEMluPnBEpnrkbkemeuRuR6Z6xWmNiBtbH56ZK5H5npkrkfmemSuR+Z6eawN127f4MKFCxcuXLhw4cKFS94uydSGer2+uLi4sLCwsLDgOI7jOPPz8/Pz8w8fPqzVarVabW5ubm5ubnZ2dnZ2dmZmZmZm5sGDB/fv379///709PT09PTU1NTU1FTmcXDhwoULFy5cuHDhwsV/aSShlMhaGo1G6z4lUmUAAAAADC7BXXRqQ7HdvXv3EbTu3r1b+n+lziXru3MlkLkemeuRuR6Z65G5WLNYtaFkOItC8L2x/ngimyUjlylZfJBrrN+o56sNd26Wbt7xXnP9lXvBC7S/uffKdfciCOUe8rK+L1cFmeuRuR6Z65G5HpmLNWW1oX73Rc/7om7NJ1wbQj591f2Rqf4rwz/L1f2rw/74IawNjx7duVnqFgNPZ/Bcd1khqA1xdIa87lX3XrnubWtIUk/m9165frmlE3p6ejK/c/MyckaKFDG26JG5HpmLNbOYbVh5860b126/+tuYsw2m/f6QFhF9jy9rQ2C7sP+l4d+G3LFc9Qd3bXDtTQXwzzgYlme3IEJryHNd0dqlYshLkStzVy2+c5Ona3q6md975Xon555XJZAw39jSGlwIPEWM53pkLtbU14bWtEPIVINNbQi8vml3ujf/8iG/pRQ6vxG4zsjli1IbXPtQPW9GCppOcE1EMNsQh7+qXb95k1dKUtXNvGf+jFeoUmQ4bipoAhMJ8WZ+52bp+nWe46liPNcjc7GmvDa8f+v2jWtv/aoeupD/PnX2702zAfHuqGuSwX99+DKBa7OvDbntDM34sw3t9xp4/u9TG+LoyfzOnXuP2H1NnXkXltzTEpi5e+IBievN/N4r12/eYWxJGeO5HpmLNdW1Yf7Va7dvvHB3JXwpz30KbAiB+9w2sw2BK/SvzTPbED53YVos/D7nvDZYzTbce+X69VfuhHQMNt5QAbtTDHkpYxdWz5t5+2UJEk9RwHjO2JIyxnM9MhdrimvDb39949rtF9/8U8RiNm9Ssu8SgddH3jBw/X2vzf6uZqifYxt6OsRlu/B/AhMMGPL0/Jnfe+U6BTdVwTM8TPCkyZX5nZutUZqxJWWM53pkLtbU1gardyjFqg1N36SBiWltgd/6f4t7/QF/ud3aQhbIg75nG+55vu4sTn+IwpCn58n83ivXedk7bRzboNfJvDsMM7akjPFcj8zFmtLa8KdfvXD7xrVfvx/VGvqvDf5vQ64xrbBzpbskmAqD5X0w/TRX/cF8ujfz7n+3Nrg+iYbPYrXGkKfnm1Uj7dRRG/QuM+9+3i1vHU0b47kemYs1pbXB7sCG8NrgbwuePXubCQfL2mD6kWlh07fhP8pPc3C/OhWtM7Fw/ZV7np2v7juc2CeIwJCn182cAxpUej69qvP05nWFNDG26JG5HpmLNQtXG0zfhlzZDH2B3+a1/6Rqg02lyVDs2YY7N0ulmzd5f/IAGPL0QuoxuafEcNwUeaeIsUWPzPXIXKyZxeneokXWBtOudtz9cvvX/sNXaFkbTApaGy6Psws9fpqNN5Q5c6SFzPXIXI/M9chcj8xl0tjtTLc2IG1sfnpkrkfmemSuR+Z6ZK5H5jLNy3mGzmXw3U5qAwAAADBskq8N9Xp9cXFxYWFhYWHBcRzHcebn5+fn5x8+fFir1Wq12tzc3Nzc3Ozs7Ozs7MzMzMzMzIMHD+7fv3///v3p6enp6empqampqSnPPePChQsXLly4cOHChUsmF39tGHySoPQkIZmnw4ULFy5cuHDhwoULl2tBtSGB2YakasOTJ0+q1ergdwixNBqNrO/ClUPmemSuR+Z6ZK5H5npkrkRtQA82Pz0y1yNzPTLXI3M9Mtcjc70EM4+qDYeToyMto5OH1IbcYfPTI3M9Mtcjcz0y1yNzPTLXk9WG2vjIyHitUx9aX1IbcoTNT4/M9chcj8z1yFyPzPXIXE9VGw4nR7tVoTYeNeFAbdBj89Mjcz0y1yNzPTLXI3M9MteTzTa4ekN0a6A2ZIDNT4/M9chcj8z1yFyPzPXIXE94bEPn4IboQxuoDRlg89Mjcz0y1yNzPTLXI3M9MteTHtvQ6gsc25BPbH56ZK5H5npkrkfmemSuR+Z6HNuANjY/PTLXI3M9Mtcjcz0y1yNzPWoD2tj89Mhcj8z1yFyPzPXIXI/M9aSHRPMmpTxj89Mjcz0y1yNzPTLXI3M9MtfjdG9oY/PTI3M9Mtcjcz0y1yNzPTLXU36SUgzUBj02Pz0y1yNzPTLXI3M9Mtcjcz1qA9rY/PTIXI/M9chcj8z1yFyPzPWoDWhj89Mjcz0y1yNzPTLXI3M9MtdLsjZcXFycn5+fnp6enJwcHx8fHR01Go2Dg4P9/f29vb3d3d2dnZ3t7e2tra3Nzc2NjY319fW1tbXV1dWVlZXl5eWlpaV6vb64uOg4TrVabQAAAAAYOsw2FFuD1i5H5npkrkfmemSuR+Z6ZK6XYObUhmJj89Mjcz0y1yNzPTLXI3M9MtejNqCNzU+PzPXIXI/M9chcj8z1yFxPWBs6522IPm0DtSEDbH56ZK5H5npkrkfmemSuR+Z6stpQGx9xnSU64iTR1IYMsPnpkbkemeuRuR6Z65G5HpnrqWpDT1eojUfNOFAb9Nj89Mhcj8z1yFyPzPXIXI/M9agNaGPz0yNzPTLXI3M9Mtcjcz0y15O+SanVG1rHOIS/TYnaoMfmp0fmemSuR+Z6ZK5H5npkrpfBIdGjk7XIoxuoDXpsfnpkrkfmemSuR+Z6ZK5H5nqZfAArb1LKIzY/PTLXI3M9Mtcjcz0y1yNzvSxqg8VHKVEb9Nj89Mhcj8z1yFyPzPXIXI/M9ZTHNrRnGLpHOVAb8oTNT4/M9chcj8z1yFyPzPXIXE8421AbH+F0bznG5qdH5npkrkfmemSuR+Z6ZK6XybEN0agNemx+emSuR+Z6ZK5H5npkrkfmetQGtLH56ZG5HpnrkbkemeuRuR6Z61Eb0Mbmp0fmemSuR+Z6ZK5H5npkrpdkbbi4uDg/Pz89PT05OTk+Pj46Omo0GgcHB/v7+3t7e7u7uzs7O9vb21tbW5ubmxsbG+vr62tra6urqysrK8vLy0tLS/V6fXFx0XGcarXaAAAAADB0mG0otgatXY7M9chcj8z1yFyPzPXIXC/BzKkNxcbmp0fmemSuR+Z6ZK5H5npkrkdtQBubnx6Z65G5HpnrkbkemeuRuZ6qNnjPDH04Odo6iUPwid+oDXpsfnpkrkfmemSuR+Z6ZK5H5nqa2tA601u3IXROFG06YzS1QY/NT4/M9chcj8z1yFyPzPXIXC/12tCaVhgdH3fNNtTGO2eK9s5CUBsyw+anR+Z6ZK5H5npkrkfmemSul35tqNUOPfWgpyq4KgS1IVNsfnpkrkfmemSuR+Z6ZK5H5npZHNtAbcglNj89Mtcjcz0y1yNzPTLXI3M9agPa2Pz0yFyPzPXIXI/M9chcj8z1qA1oY/PTI3M9Mtcjcz0y1yNzPTLXy+QDWDkkOo/Y/PTIXI/M9chcj8z1yFyPzPWyOW8DH8CaQ2x+emSuR+Z6ZK5H5npkrkfmelmd7q11JgdO95YjbH56ZK5H5npkrkfmemSuR+Z6qtoQE7VBj81Pj8z1yFyPzPXIXI/M9chcj9qANjY/PTLXI3M9Mtcjcz0y1yNzPWoD2tj89Mhcj8z1yFyPzPXIXI/M9ZKsDRcXF+fn56enpycnJ8fHx0dHR41G4+DgYH9/f29vb3d3d2dnZ3t7e2tra3Nzc2NjY319fW1tbXV1dWVlZXl5eWlpqV6vLy4uOo5TrVYbAAAAAIYOsw3F1qC1y5G5HpnrkbkemeuRuR6Z6yWYObWh2Nj89Mhcj8z1yFyPzPXIXI/M9agNaGPz0yNzPTLXI3M9Mtcjcz0y11PVhsCzQRtOEU1tyASbnx6Z65G5HpnrkbkemeuRuZ6mNrRO7uZpCIFXUhsyw+anR+Z6ZK5H5npkrkfmemSul3ptOJwcHRkZGR0fd08sBF5JbcgWm58emeuRuR6Z65G5Hpnrkble+rWhVjt84n0/UuCV1IZssfnpkbkemeuRuR6Z65G5HpnrcWwD2tj89Mhcj8z1yFyPzPXIXI/M9RLM/P8D3QfcASJVwxkAAAAASUVORK5CYII=" alt="" />

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

Java读取Excel文件转换成JSON并转成List——(七)的相关教程结束。

《Java读取Excel文件转换成JSON并转成List——(七).doc》

下载本文的Word格式文档,以方便收藏与打印。