- 博客(71)
- 问答 (1)
- 收藏
- 关注
原创 aspose替换表格
throw new DxBusinessException("500", "配置项表格书签丢失");if ("图号".equals(trim)) {
2023-08-06 21:10:31
335
原创 Aspose复制内容到另一个文档
Document doc = new Document("doc1.doc");Document doc2 = new Document("doc2.doc");Bookmark bookmark = doc.getRange().getBookmarks().get("start");Bookmark endBk = doc.getRange().getBookmarks().get("end");Node currentNode = bookmark.getBookmarkStart().ge
2023-06-21 13:55:22
867
原创 aspsoe获取word指定位置文本
Document doc = new Document("xxx.doc");DocumentBuilder documentBuilder = new DocumentBuilder(doc);documentBuilder.moveToBookmark("content");Paragraph currentParagraph = documentBuilder.getCurrentParagraph();String text = currentParagraph.getText().tri
2023-06-01 10:07:14
886
原创 aspose添加字体
ArrayList<FontSourceBase> fontSources = new ArrayList<>();String fontPath = new ApplicationHome().getDir().getPath() + File.separator + "template" + File.separator + "font";FolderFontSource fontSource = new FolderFontSource(fontPath, true);
2023-05-09 14:44:52
2032
1
原创 aspose.words填充表格数据
value = DateUtil.format((Date) field.get(vo), "yyyy年MM月dd日");
2023-03-30 11:08:18
1341
原创 java获取对象属性
value = DateUtil.format((Date) field.get(vo), "yyyy年MM月dd日");//设置允许通过反射访问私有变量。
2023-03-29 10:28:30
583
原创 Java Aspose.words插入checkBox
Document document = new Document("xxx.docx");DocumentBuilder builder = new DocumentBuilder(document);builder.moveToMergeField("c1");builder.getFont().setName("Wingdings 2");builder.write("\u00A3");builder.write("\u0052");
2023-03-28 15:37:49
780
原创 java读写文件
URL resource = this.getClass().getResource("/ModelDataFiles/" + adcd.substring(0, 6));String basePath = resource.getPath().substring(1)+ "/";
2021-12-03 09:46:53
220
原创 java获取打包后文件路径
URL resource = this.getClass().getResource("/ModelDataFiles/"+adcd.substring(0, 6));String basePath = resource.getPath() + "/";
2021-11-29 14:30:04
964
原创 32位jdk8连接不上sqlServer
The server selected protocol version TLS10 is not accepted by client preferences [TLS12]删掉这几个加密算法
2021-11-29 14:05:34
605
原创 java调用c++ dll
public class DllTest { public interface CLibrary extends Library { CLibrary INSTANCE = Native.load("Dll1", CLibrary.class); int add(int a, int b); } public static void main(String[] arg.
2021-11-26 14:18:50
564
原创 idea Generate POJOs.groovy
import com.intellij.database.model.DasTableimport com.intellij.database.model.ObjectKindimport com.intellij.database.util.Caseimport com.intellij.database.util.DasUtilimport java.io.*import java.text.SimpleDateFormat/** Available context bindings:.
2021-11-05 15:50:34
189
原创 java定时器
//定时器到泄洪时间生成泄洪中预警LocalDateTime floodTime = startTime.toLocalDateTime();LocalDateTime now = LocalDateTime.now();Duration duration = Duration.between(now, floodTime);long delay = duration.toMillis();new Timer().schedule(new TimerTask() { @Override.
2021-11-04 16:33:56
93
原创 nginx配置一个端口对应多个服务
upstream test { server 127.0.0.1:48412; server 127.0.0.1:38251; } server { listen 18080; server_name 127.0.0.1; location / { proxy_pass http://test/; p...
2021-09-18 09:36:59
1382
原创 FileUtil
public class FileUtil { /** * 创建目录,如果目录不存在这创建目录 * * @param path 目录路径 */ public static void mkdirs(String path) { File file = new File(path); if (!file.exists()) { file.mkdirs(); } } .
2021-08-25 09:01:58
124
原创 redis
官网:https://redis.io/downloadlinux安装:$ wget https://download.redis.io/releases/redis-6.2.5.tar.gz$ tar xzf redis-6.2.5.tar.gz$ cd redis-6.2.5$ make配置环境变量:vim /etc/profileexport REDIS_HOME=/root/redis-6.2.5/export PATH=$PATH:$REDIS_HOME/src..
2021-08-23 16:56:07
141
原创 Linux安装rar
cd /usr/localwget http://www.rarlab.com/rar/rarlinux-x64-5.3.0.tar.gztar zxvf rarlinux-x64-5.3.0.tar.gzmake && make installrar x demo.rar
2021-08-16 10:50:05
108
原创 查询分页接口全部数据
private void request() { int pageNum = 1; int pageSize = 100; Object o = resourceFile("3307", null, null, null, null, pageNum, pageSize); Map<String, String> map = JSONObject.parseObject(JSON.toJSONString...
2021-07-28 10:27:04
2691
原创 HttpClientUtil
import com.fasterxml.jackson.databind.ObjectMapper;import java.io.*;import java.net.HttpURLConnection;import java.net.MalformedURLException;import java.net.URL;import java.util.Map;public class HttpClientUtil { public static String doPost(Str.
2021-07-09 10:46:48
89
原创 对象list根据某个属性排序
List<StationRainVo> stationRainList = jsonArray.toJavaList(StationRainVo.class);Collections.sort(stationRainList, new Comparator<StationRainVo>() { @Override public int compare(StationRainVo o1, StationRainVo o2) { Float f1 = .
2021-06-23 14:43:21
82
原创 mysql版本问题导致group by报错
SELECT ANY_VALUE ( a.PREV_CODE ) AS PREV_CODE, ANY_VALUE ( a.AD_CODE ) AS AD_CODE, ANY_VALUE ( a.ADMIN_ADNM ) AS ADMIN_ADNM, ANY_VALUE ( a.NATURAL_ADNM ) AS NATURAL_ADNM, ANY_VALUE ( a.PCHARGE_CODE ) AS PCHARGE_CODE, ANY_VALUE ( a.C...
2021-05-21 16:35:47
131
原创 mysql存储过程case使用,in条件查询
CREATE DEFINER=`admin`@`%` PROCEDURE `pro_inspection`(IN inspectionCode varchar(50),IN hystCode varchar(50),IN status varchar(25),IN start datetime,IN end datetime)BEGINSELECT a.INSPECTION_CODE, d.HYST_CODE, d.HYST_NAME, CONCAT(e....
2021-05-10 16:33:30
592
原创 mybatis分页
public class WarningMsgParam { private Integer pageNumber; private Integer pageSize; public Integer getPageNumber() { if(pageNumber==null){ return 1; } return pageNumber; } public Integer getPag.
2021-04-27 09:30:50
108
原创 linux部署java
nohup java -jar demo-0.0.1-SNAPSHOT.jar > log.file 2>&1 & 上面的2 和 1 的意思如下: 0 标准输入(一般是键盘) 1 标准输出(一般是显示屏,是用户终端控制台) 2 标准错误(错误信息输出) 将运行的jar 错误日志信息输出到log.file文件中,然后(>&1)就是继续输出到标准输出(前面加的&,是为了让系统识别是标准...
2021-04-16 16:39:12
92
原创 查询视图sql
select VIEW_DEFINITION from information_schema.views where TABLE_SCHEMA='database' and TABLE_NAME='view'
2021-04-12 09:28:06
92
原创 jpa执行存储过程,内存分页
LinkedHashMap<String, Object> hasMap = new LinkedHashMap<>();hasMap.put("adcd", adcd);hasMap.put("name", name);hasMap.put("mobile", mobile);List<Map<String, Object>> list = vwWarningHystNewService.execProc("pro_adcd_warn_rece.
2021-03-24 11:01:51
231
原创 stream排序分页
List<AnalysisVo> collect = analysisVos.stream().sorted(Comparator.comparing(AnalysisVo::getAdminDivCode)).skip(pageSize * (pageNumber - 1)).limit(pageSize).collect(Collectors.toList());
2020-12-16 08:41:06
347
原创 mysql创建存储过程
CREATE DEFINER=`admin`@`%` PROCEDURE `pro_monitor_item_count`(IN projectCode varchar(25))BEGIN #Routine body goes here...select `a`.`NAME` AS `NAME`,`a`.`CODE` AS `CODE`,if(isnull(`c`.`count`),0,`c`.`count`) AS `COUNT` from (`jh_monitor_inst_manage`...
2020-12-09 10:47:07
200
原创 文件上传限制文件大小
配置文件不生效情况下,启动类加入以下代码/** * 文件上传配置 */@Beanpublic MultipartConfigElement multipartConfigElement() { MultipartConfigFactory factory = new MultipartConfigFactory(); // 单个文件最大大小(KB,MB) factory.setMaxFileSize("102400KB"); // 上传数据总大小 fac.
2020-10-15 16:15:45
197
原创 springboot配置mvc访问服务器静态资源
spring: mvc: static-path-pattern: /resources/** resources: static-locations: file:${file.uploadFileDir}#文件保存目录file: uploadFileDir: D://files/upload
2020-09-16 16:44:24
239
原创 excel导入
@PostMapping("/import")public ResponseMessage importPerson(@RequestParam("file") MultipartFile excel) { ResponseMessage responseMessage = new ResponseMessage(0); try { personInfoService.importPerson(excel); } catch (Exception e) { .
2020-09-09 08:41:31
135
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人