| | |
| | | |
| | | import org.springblade.common.cache.DictCache; |
| | | import org.springblade.common.enums.DictEnum; |
| | | import org.springblade.common.utils.FtpUtil; |
| | | import org.springblade.common.utils.MysqlCenlint; |
| | | import org.springblade.core.cache.utils.CacheUtil; |
| | | import org.springblade.core.mp.support.Condition; |
| | | import org.springblade.core.mp.support.Query; |
| | | import org.springblade.core.tool.api.R; |
| | | import org.springblade.core.tool.support.Kv; |
| | | import org.springblade.core.tool.utils.Func; |
| | | import org.springblade.modules.desk.entity.Notice; |
| | | import org.springblade.modules.desk.vo.NoticeVO; |
| | | import org.springblade.modules.desk.wrapper.NoticeWrapper; |
| | | import org.springblade.modules.jurisdiction.service.JurisdictionService; |
| | | import org.springblade.modules.jurisdiction.vo.JurisdictionVO; |
| | | import org.springblade.modules.member.service.IMemberService; |
| | | import org.springblade.modules.shareholder.service.IShareholderService; |
| | | import org.springblade.modules.system.entity.Dept; |
| | | import org.springblade.modules.system.service.IDeptService; |
| | | import org.springblade.modules.system.service.IUserDeptService; |
| | | import org.springframework.web.bind.annotation.*; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.information.entity.Information; |
| | | import org.springblade.modules.information.vo.InformationVO; |
| | | import org.springblade.modules.information.service.IInformationService; |
| | | import org.springblade.core.boot.ctrl.BladeController; |
| | | import springfox.documentation.annotations.ApiIgnore; |
| | | import java.sql.*; |
| | | import java.sql.DriverManager; //需要这个jar包 mysql-connector-java-5.1.49.jar |
| | | |
| | | import java.util.List; |
| | | import java.util.ArrayList; |
| | | import java.util.Map; |
| | | import java.util.HashMap; |
| | | |
| | | import java.io.*; |
| | | import java.util.*; |
| | | |
| | | import static org.springblade.core.cache.constant.CacheConstant.SYS_CACHE; |
| | |
| | | // MysqlCenlint.inster(sql); |
| | | // MysqlCenlint.delete(); |
| | | // } |
| | | public static String stringReplace(String str) { |
| | | //去掉" "号 |
| | | String strs= str.replace("\"", ""); |
| | | return strs ; |
| | | |
| | | } |
| | | public static String TestJson(){ |
| | | File file = new File("D:\\anbao\\sql.json"); |
| | | StringBuilder localStrBulider = new StringBuilder(); |
| | | if(file.isFile() && file.exists()) { |
| | | try { |
| | | InputStreamReader inputStreamReader = new InputStreamReader(new FileInputStream(file), "utf-8"); |
| | | BufferedReader bufferReader = new BufferedReader(inputStreamReader); |
| | | String lineStr = null; |
| | | try { |
| | | while((lineStr = bufferReader.readLine()) != null) { |
| | | localStrBulider.append(lineStr); |
| | | } |
| | | bufferReader.close(); |
| | | inputStreamReader.close(); |
| | | } catch (IOException e) { |
| | | // TODO Auto-generated catch block |
| | | System.out.println("file read error!"); |
| | | e.printStackTrace(); |
| | | } |
| | | } catch (UnsupportedEncodingException e) { |
| | | // TODO Auto-generated catch block |
| | | System.out.println("file catch unsupported encoding!"); |
| | | e.printStackTrace(); |
| | | } catch (FileNotFoundException e) { |
| | | // TODO Auto-generated catch block |
| | | System.out.println("file not found!"); |
| | | e.printStackTrace(); |
| | | } |
| | | }else { |
| | | System.out.println("file is not a file or file is not existing!"); |
| | | } |
| | | return localStrBulider.toString(); |
| | | } |
| | | |
| | | } |