From 8d62f18a09418058e4c15b9c4da31d95761a460f Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 19 十月 2022 15:01:09 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/config/InitConfig.java | 35 ++++++++++++-----
data/menu-执行.xls | 0
src/main/java/com/lf/server/LfApplication.java | 1
src/main/java/com/lf/server/config/MybatisPlusConfig.java | 46 +++++++++++++++++++++++
4 files changed, 70 insertions(+), 12 deletions(-)
diff --git "a/data/menu-\346\211\247\350\241\214.xls" "b/data/menu-\346\211\247\350\241\214.xls"
index cfd7696..c9cb580 100644
--- "a/data/menu-\346\211\247\350\241\214.xls"
+++ "b/data/menu-\346\211\247\350\241\214.xls"
Binary files differ
diff --git a/src/main/java/com/lf/server/LfApplication.java b/src/main/java/com/lf/server/LfApplication.java
index fe54c16..6e0cf35 100644
--- a/src/main/java/com/lf/server/LfApplication.java
+++ b/src/main/java/com/lf/server/LfApplication.java
@@ -16,6 +16,5 @@
public class LfApplication {
public static void main(String[] args) {
SpringApplication.run(LfApplication.class, args);
- // com.lf.server.helper.RsaHelper.generate();
}
}
diff --git a/src/main/java/com/lf/server/config/InitConfig.java b/src/main/java/com/lf/server/config/InitConfig.java
index 4dcc09c..3c93526 100644
--- a/src/main/java/com/lf/server/config/InitConfig.java
+++ b/src/main/java/com/lf/server/config/InitConfig.java
@@ -2,6 +2,7 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
+import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.entity.bd.DlgAgnp;
import com.lf.server.helper.PathHelper;
import com.lf.server.mapper.bd.DlgAgnpMapper;
@@ -13,6 +14,7 @@
import org.springframework.boot.ApplicationRunner;
import org.springframework.stereotype.Component;
+import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -43,7 +45,9 @@
//GdalHelper.readShp("E:\\data\\13.cppe\\shps\\addr.shp");
//GdalHelper.readGdb("E:\\Test\\addr.gdb");
- testMybatisPlus();
+ // com.lf.server.helper.RsaHelper.generate();
+
+ //testMybatisPlus();
pathHelper.init();
@@ -59,26 +63,35 @@
DlgAgnp dlg = dlgAgnpMapper.selectById(1);
Map<String, Object> map = new HashMap<String, Object>(3);
- map.put("id", 1);
- map.put("id", 2);
+ map.put("gid", 2);
List<DlgAgnp> list1 = dlgAgnpMapper.selectByMap(map);
QueryWrapper<DlgAgnp> w1 = new QueryWrapper<>();
w1.eq("name", "娌诲鍘�");
List<DlgAgnp> list2 = dlgAgnpMapper.selectList(w1);
-
UpdateWrapper<DlgAgnp> w2 = new UpdateWrapper<DlgAgnp>();
// 璁剧疆鏇存柊鍐呭
w2.set("name", "newName").set("gb", "10013")
// 璁剧疆鏇存柊鏉′欢
- .eq("id", 0);
- dlgAgnpMapper.update(null, w2);
+ .eq("gid", 0);
+ // dlgAgnpMapper.update(null, w2)
- //List<Integer> ids = new ArrayList<Integer>();
- //ids.add(1);
- //ids.add(2);
- //dlgAgnpMapper.deleteBatchIds(ids);
- //dlgAgnpMapper.updateById(dlg);
+ List<Integer> ids = new ArrayList<Integer>();
+ ids.add(1);
+ ids.add(2);
+ // dlgAgnpMapper.deleteBatchIds(ids)
+ List<DlgAgnp> list3 = dlgAgnpMapper.selectBatchIds(ids);
+
+ // dlgAgnpMapper.updateById(dlg)
+ // List<DlgAgnp> all = dlgAgnpMapper.selectList(null)
+
+ // 椤垫暟 / 姣忛〉璁板綍鏁�
+ Page<DlgAgnp> page = new Page<>(1, 10);
+ // 鍒嗛〉 / 鍙傛暟浜岋細wrapper鏌ヨ鏉′欢
+ Page<DlgAgnp> userPage = dlgAgnpMapper.selectPage(page, null);
+ // 鎬婚〉鏁� / 鎬昏褰曟暟锛�325 / 3247
+ String str = userPage.getPages() + " / " + userPage.getTotal();
+ List<DlgAgnp> list4 = userPage.getRecords();
}
}
diff --git a/src/main/java/com/lf/server/config/MybatisPlusConfig.java b/src/main/java/com/lf/server/config/MybatisPlusConfig.java
new file mode 100644
index 0000000..4d977e3
--- /dev/null
+++ b/src/main/java/com/lf/server/config/MybatisPlusConfig.java
@@ -0,0 +1,46 @@
+package com.lf.server.config;
+
+import com.baomidou.mybatisplus.annotation.DbType;
+import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
+import com.baomidou.mybatisplus.core.MybatisConfiguration;
+import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
+import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
+import org.apache.ibatis.type.JdbcType;
+import org.mybatis.spring.annotation.MapperScan;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.transaction.annotation.EnableTransactionManagement;
+
+/**
+ * Mybatis-Plus鍒嗛〉閰嶇疆
+ * @author WWW
+ */
+@EnableTransactionManagement
+@Configuration
+@MapperScan("com.lf.server.mapper")
+public class MybatisPlusConfig {
+ /**
+ * 鏂扮殑鍒嗛〉鎻掍欢,涓�缂撳拰浜岀紦閬靛惊mybatis鐨勮鍒�,闇�瑕佽缃�
+ * MybatisConfiguration#useDeprecatedExecutor = false
+ * 閬垮厤缂撳瓨鍑虹幇闂(璇ュ睘鎬т細鍦ㄦ棫鎻掍欢绉婚櫎鍚庝竴鍚岀Щ闄�)
+ */
+ @Bean
+ public MybatisPlusInterceptor mybatisPlusInterceptor() {
+ MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
+ interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.POSTGRE_SQL));
+ return interceptor;
+ }
+
+ @Bean
+ public ConfigurationCustomizer configurationCustomizer() {
+ return new ConfigurationCustomizer() {
+ @Override
+ public void customize(MybatisConfiguration configuration) {
+ configuration.setCacheEnabled(true);
+ configuration.setMapUnderscoreToCamelCase(true);
+ configuration.setCallSettersOnNulls(true);
+ configuration.setJdbcTypeForNull(JdbcType.NULL);
+ }
+ };
+ }
+}
--
Gitblit v1.9.3