MySql执行Sql语句时出现“MySqlException: Parameter ‘@maxNo‘ must be defined.”的错误

最新推荐文章于 2024-10-31 09:26:41 发布
原创 最新推荐文章于 2024-10-31 09:26:41 发布 · 1.2k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#mysql

博客内容涉及在连接MySQL数据库时遇到的问题及解决方案。当尝试连接到数据库时，SQL执行失败，错误信息未显示。通过在连接字符串中添加'AllowUserVariables=True;'配置，成功解决了连接问题，确保了与数据库的正常通信。

        具体执行的SQL和报错的信息如下图所示：

 

     解决办法：连接字符串中增加Allow User Variables=True;的配置即可，如下所示：

Server=192.168.2.1;Port=3306;Database=test_db;Uid=test_user;Pwd=123456;Allow User Variables=True;

Linux内存管理（42）：CMA 分配器——分配原理
私房菜
01-08 1575
上一篇博文是延续《memblock初始化》一文，对 dts 中 reserved-memory 节点进行详细剖析，阐述 CMA 分配器中核心数组 cma_areas 的创建过程。本文将重点剖析 CMA 分配器的分配、释放流程，对应接口是 cma_alloc() 函数、cma_release() 函数。将 cma 分配过程通过 5 张图阐述总结，核心逻辑都在图1，此时 CMA 的内存正在被非 cma 驱动使用，其中绿色表示普通页面，紫色表示干净的文件页，此时内存还是 MIGRATE_CMA 类型；图2，
利用mysql存储过程实现唯一单号生成规则
qq_38075474的博客
07-26 680
SET @orderNo = ''; CALL `new_generate_orderNo`('D0001', 6, @orderNo); SELECT @orderNo; 首先我们新建一张单号生成规则表，表结构如下： CREATE TABLE `bas_seq` ( `bas_seq_id` varchar(50) NOT NULL DEFAULT 'id', `del_...
mysql的连接备注
梁中林 的专栏
06-10 1739
MySQLHelper.connectionString = string.Format(“Database={0};Data Source=127.0.0.1;User Id=root;Password=frontlinkpassword;pooling=true;CharSet=utf8;port={1};allow zero datetime=true;allowuservariables=...
MYSQL报Fatal error encountered during command execution.错误的解决方法
11-03 2193
在连接字符串里加上 Allow User Variables=True 因为sql语句里边带了自定义参数了，如@rownum这种参数。 Allow User Variables=True允许用户自定义参数。
浅谈mysql【8.0】链接字符串
weixin_43542114的博客
10-31 1484
禁用 SSL 加密，适用于不关心安全的场景。: 允许客户端从服务器获取公钥，适用于 MySQL 8.0 及以上版本的认证插件。: 允许在 SQL 查询中使用用户变量，适用于需要使用用户变量的场景。如果只使用基本的连接字符串，而不配置和这些参数，会有几个显著的区别。安全性: 如果不配置sslmode，将可能在不安全的环境中传输数据，但可能不影响连接的可用性；但如果要求使用 SSL 且未配置，连接会失败。公钥处理: 不配置。
mysql 执行 sql 语句提示Parameter '@XXX' must be defined
weixin_30814223的博客
01-28 2370
执行 sql 语句 MySqlException: Parameter '@maxNo' must be defined. 执行 sql 中含有自定义变量 @maxNo，抛出异常 解决方法： 连接字符串 加入 : Allow User Variables=True; 转载于:http...
mysql-Parameter “” must be defined
Three_ST的博客
04-08 1055
mysql-Parameter “” must be defined a.检查数据库列表名是否有误 b.检查数据库字符串 连接字符串 加入 : Allow User Variables=True; 参考链接 1. stackoverflow 2. bbsmax
MySQL 报错：Parameter ‘@XXX‘ must be defined.
General_Y的博客
05-28 4104
报错信息： Parameter ‘@Name’ must be defined. 解决方案： 连接语句中添加：allowuservariables=True; 即可 配置解析： AllowUserVariables：是否允许 SQL 中出现用户变量，默认 false
var re=Ajax.WebRequest("Biz/SYGL/User_WebService/mycopy",{id:id,uid:uid,maxno:maxno},"","POST");
最新发布
11-29
整体上，这段代码旨在向 `mycopy` 服务端点发送一个包含用户数据的POST请求，用于执行复制或数据处理操作（如基于 `id`, `uid`, `maxno` 的业务逻辑）。 #### 2. **潜在问题分析** 代码可能存在多个问题，源于语法...
MySQL触发器自动生成自定义编码：字母+年月日+流水号
boluobao222的博客
05-28 1649
类型：字母+年月日+流水号 触发器设置： 具体代码（和上面的有点区别，以下面的为准）： -- 例：tp220127001 tp-年份后两位-月-日-三位数的流水号 BEGIN -- PART1:声明各个变量 DECLARE currentdate varCHAR (8) ; -- 当前日期 DECLARE maxNo INT DEFAULT 0 ; DECLARE oldNo VARCHAR (11) DEFAULT '' ; -- 此处的字符长度必须和要生成的目标编码的长度一致
package com.bs.lithoframe.service.reticle.service.impl; import com.alibaba.fastjson.JSONObject; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.bs.lithoframe.common.util.StringPermutations; import com.bs.lithoframe.service.kpimaintaintable.entity.TMainOvlApply; import com.bs.lithoframe.service.kpimaintaintable.mapper.TMainOvlApplyMapper; import com.bs.lithoframe.service.reticle.commom.MarkSizeUtils; import com.bs.lithoframe.service.reticle.dto.IBOCdsemDboSizeSummaryDTO; import com.bs.lithoframe.service.reticle.dto.MarkAutoGenerateDTO; import com.bs.lithoframe.service.reticle.dto.MarkAutoGenerateLayerDTO; import com.bs.lithoframe.service.reticle.entity.*; import com.bs.lithoframe.service.reticle.mapper.*; import com.bs.lithoframe.service.reticle.service.ILfmsIboCdsemDboSizeSummaryService; import com.bs.lithoframe.service.reticle.vo.*; import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.util.CollectionUtils; import org.springframework.util.StringUtils; import javax.annotation.Resource; import java.math.BigDecimal; import java.util.*; import java.util.stream.Collectors; /** * <p> * 服务实现类 * </p> * * @author L3150243 PX * @since 2025-07-07 */ @Service public class LfmsIboCdsemDboSizeSummaryServiceImpl extends ServiceImpl<LfmsIboCdsemDboSizeSummaryMapper, LfmsIboCdsemDboSizeSummary> implements ILfmsIboCdsemDboSizeSummaryService { @Resource private LfmsIboCdsemDboSizeSummaryMapper iboCdsemDboSizeSummaryMapper; @Resource private LfmsIboCdsemDboCdsemSizeMapper iboCdsemDboCdsemSizeMapper; @Resource private LfmsIboCdsemDboOvlMapper iboCdsemDboOvlMapper; @Resource private TMainOvlApplyMapper ovlApplyMapper; @Resource private MarkSizeUtils markSizeUtils; @Resource private LfmsDesignRecordMapper designRecordMapper; @Resource private LfmsReticleMapper reticleMapper; @Resource private LfmsIboCdsemDboCellValueMapper iboCellValueMapper; /** * IOB取两部分数据 * IBO mark: 同OVL sheet生成规则，取KPI系统数据。 * CDSEM mark生成时“OVL tree列”“mark size summary列” 信息为reference Prod mark本系统的数据 */ @Override public List<IboMarkAutoResultVO> markAutoGenerate(MarkAutoGenerateDTO markAutoGenerateDTO) { List<IboMarkAutoResultVO> resultList = new ArrayList<>(); // 1. 统一获取参数 Map<String, String> currentMarkSizeParam = markSizeUtils.getMarkSizeParam(markAutoGenerateDTO.getCurrentProject(), markAutoGenerateDTO.getCurrentProjectId(), markAutoGenerateDTO.getCurrentPart(), markAutoGenerateDTO.getTypeName(), markAutoGenerateDTO.getMainVersion()); List<String> currentLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getCurrentLayer).collect(Collectors.toList()); //查询当前layer的OVL tree信息 LambdaQueryWrapper<LfmsIboCdsemDboOvl> ovlTreeSummaryQueryWrapper = new LambdaQueryWrapper<>(); ovlTreeSummaryQueryWrapper.eq(LfmsIboCdsemDboOvl::getReticleKey, currentMarkSizeParam.get("rKey")) .eq(LfmsIboCdsemDboOvl::getSubVersion, markAutoGenerateDTO.getSubVersion()) .in(LfmsIboCdsemDboOvl::getLayerName, currentLayerNameList) .eq(LfmsIboCdsemDboOvl::getOvlType, "OVL"); List<LfmsIboCdsemDboOvl> ovlTreeList = iboCdsemDboOvlMapper.selectList(ovlTreeSummaryQueryWrapper); //将markTree由‘326A_633A’转换成‘326_633’，用于后续匹配数据 ovlTreeList.forEach(ovlSizeSummary -> ovlSizeSummary.setMarkTree(ovlSizeSummary.getMarkTree().replaceAll("[a-zA-Z]", ""))); //IBO mark: 同OVL sheet生成规则（取KPI） List<LfmsIboCdsemDboOvl> ibo = ovlTreeList.stream().filter(item -> Objects.equals(item.getOiType(), "IBO")) .collect(Collectors.toList()); //1.IBO List<IboMarkAutoResultVO> iboMarkAutoResultVOList = iboSizeSummary(markAutoGenerateDTO, currentMarkSizeParam, ibo); //CDSEM mark： 获取lfms系统mark size summary和ovl tree 信息 List<LfmsIboCdsemDboOvl> cdsem = ovlTreeList.stream().filter(item -> Objects.equals(item.getOiType(), "CDSEM")) .collect(Collectors.toList()); //2.cdsem List<LfmsIboCdsemDboOvl> iboCdsemDboOvlList = cdsemSizeSummary(markAutoGenerateDTO, cdsem); Map<String,List<LfmsIboCdsemDboOvl>> lfmsIboCdsemDboOvlMap = iboCdsemDboOvlList.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); List<LfmsIboCdsemDboOvl> lfmsIboCdsemDboOvlList = this.coverLayerAutoGenerate(markAutoGenerateDTO); //3.cover Map<String,List<LfmsIboCdsemDboOvl>> coverCdsemDboOvlMap = lfmsIboCdsemDboOvlList.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); IboMarkAutoResultVO vo = new IboMarkAutoResultVO(); for (String currentLayer : currentLayerNameList) { vo.setLayerName(currentLayer); if(!CollectionUtils.isEmpty(iboMarkAutoResultVOList)){ for (IboMarkAutoResultVO iboMarkAutoResultVO : iboMarkAutoResultVOList) { if(iboMarkAutoResultVO.getLayerName().equals(currentLayer)){ vo.setIboTreeSummaryList(iboMarkAutoResultVO.getIboTreeSummaryList()); } } } if(lfmsIboCdsemDboOvlMap.containsKey(currentLayer)){ vo.setCdsemDboOvlList(lfmsIboCdsemDboOvlMap.get(currentLayer)); } if(coverCdsemDboOvlMap.containsKey(currentLayer)){ vo.setCoverLayerList(coverCdsemDboOvlMap.get(currentLayer)); } resultList.add(vo) ; } return resultList; } /** * IOB取两部分数据 * IBO mark: 同OVL sheet生成规则，取KPI系统数据。 * CDSEM mark生成时“OVL tree列”“mark size summary列” 信息为reference Prod mark本系统的数据 */ public List<IboMarkAutoResultVO> markAutoGenerate_old(MarkAutoGenerateDTO markAutoGenerateDTO) { List<IboMarkAutoResultVO> resultList = new ArrayList<>(); Map<String, String> currentMarkSizeParam = markSizeUtils.getMarkSizeParam(markAutoGenerateDTO.getCurrentProject(), markAutoGenerateDTO.getCurrentProjectId(), markAutoGenerateDTO.getCurrentPart(), markAutoGenerateDTO.getTypeName(), markAutoGenerateDTO.getMainVersion()); List<String> currentLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getCurrentLayer).collect(Collectors.toList()); //查询当前layer的OVL tree信息 LambdaQueryWrapper<LfmsIboCdsemDboOvl> ovlTreeSummaryQueryWrapper = new LambdaQueryWrapper<>(); ovlTreeSummaryQueryWrapper.eq(LfmsIboCdsemDboOvl::getReticleKey, currentMarkSizeParam.get("rKey")) .eq(LfmsIboCdsemDboOvl::getSubVersion, markAutoGenerateDTO.getSubVersion()) .in(LfmsIboCdsemDboOvl::getLayerName, currentLayerNameList) .eq(LfmsIboCdsemDboOvl::getOvlType, "OVL"); List<LfmsIboCdsemDboOvl> ovlTreeList = iboCdsemDboOvlMapper.selectList(ovlTreeSummaryQueryWrapper); //将markTree由‘326A_633A’转换成‘326_633’，用于后续匹配数据 ovlTreeList.forEach(ovlSizeSummary -> ovlSizeSummary.setMarkTree(ovlSizeSummary.getMarkTree().replaceAll("[a-zA-Z]", ""))); //IBO mark: 同OVL sheet生成规则（取KPI） List<LfmsIboCdsemDboOvl> ibo = ovlTreeList.stream().filter(item -> Objects.equals(item.getOiType(), "IBO")) .collect(Collectors.toList()); //1.IBO List<IboMarkAutoResultVO> iboMarkAutoResultVOList = iboSizeSummary(markAutoGenerateDTO, currentMarkSizeParam, ibo); //CDSEM mark： 获取lfms系统mark size summary和ovl tree 信息 List<LfmsIboCdsemDboOvl> cdsem = ovlTreeList.stream().filter(item -> Objects.equals(item.getOiType(), "CDSEM")) .collect(Collectors.toList()); //2.cdsem List<LfmsIboCdsemDboOvl> iboCdsemDboOvlList = cdsemSizeSummary(markAutoGenerateDTO, cdsem); Map<String,List<LfmsIboCdsemDboOvl>> lfmsIboCdsemDboOvlMap = iboCdsemDboOvlList.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); List<LfmsIboCdsemDboOvl> lfmsIboCdsemDboOvlList = this.coverLayerAutoGenerate(markAutoGenerateDTO); //3.cover Map<String,List<LfmsIboCdsemDboOvl>> coverCdsemDboOvlMap = lfmsIboCdsemDboOvlList.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); IboMarkAutoResultVO vo = new IboMarkAutoResultVO(); for (String currentLayer : currentLayerNameList) { vo.setLayerName(currentLayer); if(!CollectionUtils.isEmpty(iboMarkAutoResultVOList)){ for (IboMarkAutoResultVO iboMarkAutoResultVO : iboMarkAutoResultVOList) { if(iboMarkAutoResultVO.getLayerName().equals(currentLayer)){ vo.setIboTreeSummaryList(iboMarkAutoResultVO.getIboTreeSummaryList()); } } } if(lfmsIboCdsemDboOvlMap.containsKey(currentLayer)){ vo.setCdsemDboOvlList(lfmsIboCdsemDboOvlMap.get(currentLayer)); } if(coverCdsemDboOvlMap.containsKey(currentLayer)){ vo.setCoverLayerList(coverCdsemDboOvlMap.get(currentLayer)); } resultList.add(vo) ; } return resultList; } /** * 查询出所选的referenceLayer的sizeSummary，过滤出coverLayer，将coverLayer信息新增给对应的currentLayer * coverLayer定义：LFMS_OVL_OVL_TREE_SUMMARY表OVL_TYPE=‘COVER’，OI_TYPE = ‘Special’ * * @return highlight信息 */ private List<LfmsIboCdsemDboOvl> coverLayerAutoGenerate(MarkAutoGenerateDTO markAutoGenerateDTO) { List<String> referenceLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream().map(MarkAutoGenerateLayerDTO::getReferenceLayer) .collect(Collectors.toList()); //生成cover layer String projectId = markSizeUtils.getProjectId(markAutoGenerateDTO.getProjectId()); Map<String, String> currentMarkSizeParam = markSizeUtils.getMarkSizeParam(markAutoGenerateDTO.getCurrentProject(), markAutoGenerateDTO.getCurrentProjectId(), markAutoGenerateDTO.getCurrentPart(), markAutoGenerateDTO.getTypeName(), markAutoGenerateDTO.getMainVersion()); //查询LfmsDesignRecord获取最新mainVersion和subVersion，然后拉取LFMS系统的ovlTree信息（coverLayer） LambdaQueryWrapper<LfmsDesignRecord> designRecordQueryWrapper = new LambdaQueryWrapper<>(); designRecordQueryWrapper.eq(LfmsDesignRecord::getProjAbbr, markAutoGenerateDTO.getProject()) .eq(LfmsDesignRecord::getPart, markAutoGenerateDTO.getPart()) .eq(LfmsDesignRecord::getProjId, projectId) .eq(LfmsDesignRecord::getProjType, markAutoGenerateDTO.getTypeName()) .eq(LfmsDesignRecord::getDesignTable, "RETICLE") .orderByDesc(LfmsDesignRecord::getMainVersion); List<LfmsDesignRecord> designRecords = designRecordMapper.selectList(designRecordQueryWrapper); String mainVersion = designRecords.get(0).getMainVersion(); String subversion = designRecords.stream().filter(designRecord -> Objects.equals(mainVersion, designRecord.getMainVersion())) .map(LfmsDesignRecord::getSubVersion).max(String::compareTo).get(); String rKey = String.join("@", markAutoGenerateDTO.getProject(), markAutoGenerateDTO.getPart(), mainVersion, projectId, markAutoGenerateDTO.getTypeName()); LambdaQueryWrapper<LfmsIboCdsemDboOvl> ovlTreeQueryWrapper = new LambdaQueryWrapper<>(); ovlTreeQueryWrapper.eq(LfmsIboCdsemDboOvl::getReticleKey, rKey).eq(LfmsIboCdsemDboOvl::getSubVersion, subversion) .eq(LfmsIboCdsemDboOvl::getOvlType, "COVER").eq(LfmsIboCdsemDboOvl::getOiType, "Special") .in(LfmsIboCdsemDboOvl::getLayerName, referenceLayerNameList); List<LfmsIboCdsemDboOvl> ovlTreeList = iboCdsemDboOvlMapper.selectList(ovlTreeQueryWrapper); if (CollectionUtils.isEmpty(ovlTreeList)) { return new ArrayList<>(); } //匹配到ovlTree信息，然后新增到数据库，其中四个字段使用当前系统的数据：reticleKey、markCountKey、layerName、subVersion List<LfmsIboCdsemDboOvl> coverLayerList = new ArrayList<>(); for (MarkAutoGenerateLayerDTO referenceLayer : markAutoGenerateDTO.getReferenceLayers()) { ovlTreeList.stream().filter(ovlTree -> Objects.equals(ovlTree.getLayerName(), referenceLayer.getReferenceLayer())) .forEach(ovlTree -> { LfmsIboCdsemDboOvl addOvlTree = new LfmsIboCdsemDboOvl(); BeanUtils.copyProperties(ovlTree, addOvlTree); addOvlTree.setLayerName(referenceLayer.getCurrentLayer()); addOvlTree.setReticleKey(currentMarkSizeParam.get("rKey")); addOvlTree.setMarkCountKey(String.join("@", markAutoGenerateDTO.getCurrentProjectId(), markAutoGenerateDTO.getMarkCountVersion())); addOvlTree.setSubVersion(markAutoGenerateDTO.getSubVersion()); addOvlTree.setNo(new BigDecimal(1)); coverLayerList.add(addOvlTree); }); } return coverLayerList; } /** * 判断页面上的If tape out or not = Y的数据中哪些是Dummy Block，GDS NO 去Reticel table 里查找If Dummy block 是Y，自动创建#_normal * <p> * 如何判断If tape out or not = Y? * 查询LFMS_IBO_CDSEM_DBO_CELL_VALUE表里面的if_tape_out值 "IF_TAPE_OUT": "N" if len(df_dummy_value) == 0 else df_dummy_value["IF_TAPE_OUT"].iat[0], * <p> * 如何判断Dummy Block？ * 1、查询LFMS_DESIGN_RECORD，找到对应的小版本号或者最新的小版本号subversion * 2、然后根据subversion匹配LFMS_RETICLE里相应的的数据，找到DUMMY_LAYER==Y的数据，即为Dummy block * * @param markAutoGenerateDTO */ @Override public void dummyBlockAutoGenerate(MarkAutoGenerateDTO markAutoGenerateDTO) { Map<String, String> markSizeParam = markSizeUtils.getMarkSizeParam(markAutoGenerateDTO.getCurrentProject(), markAutoGenerateDTO.getCurrentProjectId(), markAutoGenerateDTO.getCurrentPart(), markAutoGenerateDTO.getTypeName(), markAutoGenerateDTO.getMainVersion()); //取subversion，根据subversion查询出LfmsReticle的DUMMY_LAYER信息 String subversion = markAutoGenerateDTO.getSubVersion(); LambdaQueryWrapper<LfmsDesignRecord> designRecordQueryWrapper = new LambdaQueryWrapper<>(); designRecordQueryWrapper.eq(LfmsDesignRecord::getProjAbbr, markAutoGenerateDTO.getCurrentProject()).eq(LfmsDesignRecord::getPart, markAutoGenerateDTO.getCurrentPart()) .eq(LfmsDesignRecord::getProjId, markSizeParam.get("projectId")).eq(LfmsDesignRecord::getProjType, markAutoGenerateDTO.getTypeName()) .eq(LfmsDesignRecord::getMainVersion, markAutoGenerateDTO.getMainVersion()).eq(LfmsDesignRecord::getDesignTable, "RETICLE") .select(LfmsDesignRecord::getSubVersion) .orderByDesc(LfmsDesignRecord::getSubVersion); List<LfmsDesignRecord> designRecords = designRecordMapper.selectList(designRecordQueryWrapper); //如果没有对应的 subversion, 取最新的小版本号 boolean existSubversion = designRecords.stream().anyMatch(designRecord -> Objects.equals(designRecord.getSubVersion(), markAutoGenerateDTO.getSubVersion())); if (!existSubversion) { String reg = "^[1-9][0-9]{7}(_[0-9]{1,2})?$"; subversion = designRecords.stream().filter(designRecord -> designRecord.getSubVersion().matches(reg)) .map(LfmsDesignRecord::getSubVersion).findFirst().get(); } LambdaQueryWrapper<LfmsReticle> reticleQueryWrapper = new LambdaQueryWrapper<>(); reticleQueryWrapper.eq(LfmsReticle::getSubVersion, subversion).eq(LfmsReticle::getDummyLayer, "Y") .like(LfmsReticle::getIdx, markSizeParam.get("rKey")); List<LfmsReticle> lfmsReticles = reticleMapper.selectList(reticleQueryWrapper); if (CollectionUtils.isEmpty(lfmsReticles)) { return; } // 找到dummy layer LambdaQueryWrapper<LfmsIboCdsemDboCellValue> cellValueQueryWrapper = new LambdaQueryWrapper<>(); cellValueQueryWrapper.eq(LfmsIboCdsemDboCellValue::getReticleKey, markSizeParam.get("rKey")) .eq(LfmsIboCdsemDboCellValue::getSubVersion, subversion) .eq(LfmsIboCdsemDboCellValue::getIfTapeOut, "Y") .select(LfmsIboCdsemDboCellValue::getLayerName); List<LfmsIboCdsemDboCellValue> ovlCellValues = iboCellValueMapper.selectList(cellValueQueryWrapper); if (CollectionUtils.isEmpty(ovlCellValues)) { return; } //LfmsAsmlAlCellValue里的layerName值，示例M2_ARRAY_Dummy List<String> cellValueLayers = ovlCellValues.stream().map(LfmsIboCdsemDboCellValue::getLayerName).collect(Collectors.toList()); List<String> dummyLayerNames = lfmsReticles.stream().filter(reticle -> cellValueLayers.contains(reticle.getLayerName() + "_Dummy")) .map(reticle -> reticle.getLayerName() + "_Dummy").collect(Collectors.toList()); if (CollectionUtils.isEmpty(dummyLayerNames)) { return; } //先删除dummySummary信息,再新增 LambdaQueryWrapper<LfmsIboCdsemDboOvl> dummySummaryQueryWrapper = new LambdaQueryWrapper<>(); dummySummaryQueryWrapper.eq(LfmsIboCdsemDboOvl::getReticleKey, markSizeParam.get("rKey")) .eq(LfmsIboCdsemDboOvl::getSubVersion, subversion) .eq(LfmsIboCdsemDboOvl::getOvlType, "NORMAL") .in(LfmsIboCdsemDboOvl::getLayerName, dummyLayerNames); iboCdsemDboOvlMapper.delete(dummySummaryQueryWrapper); //新增dummySummary String finalSubversion = subversion; List<LfmsIboCdsemDboOvl> addDummySummaries = dummyLayerNames.stream().map(layer -> { LfmsIboCdsemDboOvl dummySummary = new LfmsIboCdsemDboOvl(); dummySummary.setReticleKey(markSizeParam.get("rKey")); dummySummary.setMarkCountKey(markSizeParam.get("mKey")); dummySummary.setLayerName(layer); dummySummary.setNo(new BigDecimal(1)); dummySummary.setOvlType("NORMAL"); dummySummary.setRefreshed("GREEN"); dummySummary.setSubVersion(finalSubversion); dummySummary.setCol("");//todo dummySummary.setRefreshed("green"); return dummySummary; }).collect(Collectors.toList()); addDummySummaries.forEach(dummySummary -> iboCdsemDboOvlMapper.insert(dummySummary)); } /** * 从KPI系统拉取数据，生成IBO 类型的size summary信息 * * @param markAutoGenerateDTO * @param markSizeParam * @return highlight提醒信息 */ private List<IboMarkAutoResultVO> iboSizeSummary(MarkAutoGenerateDTO markAutoGenerateDTO, Map<String, String> markSizeParam, List<LfmsIboCdsemDboOvl> ovlTreeSummaries) { List<String> currentLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getCurrentLayer).collect(Collectors.toList()); List<IboMarkAutoResultVO> resultList = new ArrayList<>(); //ovl和ibo需要判断有没有ovl tree，只对有ovl tree的数据进行auto mark size if (CollectionUtils.isEmpty(ovlTreeSummaries)) { log.warn("本地 tree 为空,不做处理"); return resultList; } //从KPI系统拉取alignment数据 LambdaQueryWrapper<TMainOvlApply> ovlQueryWrapper = new LambdaQueryWrapper<>(); String projectIdSql = String.format("PROJECT_ID = " + "(SELECT ID FROM T_MAIN_TAIN_KPI_APPLY WHERE ARCHIVE = 0 AND PROJECT = '%s' AND lOOP_F = '%s' ORDER BY CREATE_TIME FETCH FIRST 1 ROW ONLY)", markAutoGenerateDTO.getProject(), markAutoGenerateDTO.getPart()); List<String> referenceLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getReferenceLayer).collect(Collectors.toList()); ovlQueryWrapper.eq(TMainOvlApply::getArchive, 0).in(TMainOvlApply::getLayerName, referenceLayerNameList) .notLike(TMainOvlApply::getCellName, "CDSEM") .eq(TMainOvlApply::getMarkType,"ibo-cdsem-dbo") .ne(TMainOvlApply::getIfNeedRedesign, "Y") .isNotNull(TMainOvlApply::getQnerutOutMs) .isNotNull(TMainOvlApply::getQnerutInMs) .apply(projectIdSql); List<TMainOvlApply> mainOvlApplies = ovlApplyMapper.selectList(ovlQueryWrapper); if(CollectionUtils.isEmpty(mainOvlApplies)){ log.warn("本地 kpi ovl 为空,不做处理"); return resultList; } //查现有的IBO Size Summary，为了获取NO LambdaQueryWrapper<LfmsIboCdsemDboSizeSummary> iboSizeSummaryQueryWrapper = new LambdaQueryWrapper<>(); iboSizeSummaryQueryWrapper.eq(LfmsIboCdsemDboSizeSummary::getReticleKey, markSizeParam.get("rKey")) .eq(LfmsIboCdsemDboSizeSummary::getSubVersion, markAutoGenerateDTO.getSubVersion()) .in(LfmsIboCdsemDboSizeSummary::getLayerName, currentLayerNameList) .select(LfmsIboCdsemDboSizeSummary::getLayerName, LfmsIboCdsemDboSizeSummary::getNo); List<LfmsIboCdsemDboSizeSummary> iboSizeSummaries = iboCdsemDboSizeSummaryMapper.selectList(iboSizeSummaryQueryWrapper); //根据layer name分组，获取组内最新的maskVersion Map<String, List<TMainOvlApply>> mainOvlMap = mainOvlApplies.stream().filter(f-> !(strToJson(f.getQnerutOutMs()).getInteger("X")>=4) && !(strToJson(f.getQnerutOutMs()).getInteger("Y")>=4) && !(strToJson(f.getQnerutInMs()).getDouble("X")>=3) && !(strToJson(f.getQnerutInMs()).getDouble("Y")>=3) && !(strToJson(f.getTisMs()).getDouble("X")>=4) && !(strToJson(f.getTisMs()).getDouble("Y")>=4) ).collect(Collectors.groupingBy( TMainOvlApply::getLayerName, Collectors.collectingAndThen(Collectors.toList(), list -> { String newMaskVersion = list.stream().map(TMainOvlApply::getMaskVersion) .max(String::compareTo).get(); return list.stream().filter(item -> Objects.equals(item.getMaskVersion(), newMaskVersion)) .collect(Collectors.toList()); } ) )); return assembleSizeSummary(markAutoGenerateDTO.referenceLayers, mainOvlMap, ovlTreeSummaries, iboSizeSummaries); } public static JSONObject strToJson(String jsonStr) { JSONObject jsonObject = JSONObject.parseObject(jsonStr); return jsonObject; } /** * 从本系统拉取数据，生成CDSEM 类型的size summary信息 * * @param markAutoGenerateDTO auto接口入参 * @param currentRKey 当前sheet 的reticleKey * @return highlight提醒信息 */ private List<LfmsIboCdsemDboOvl> cdsemSizeSummary(MarkAutoGenerateDTO markAutoGenerateDTO,List<LfmsIboCdsemDboOvl> ovlTreeSummaries) { List<LfmsIboCdsemDboOvl> result = new ArrayList<>(); if (CollectionUtils.isEmpty(ovlTreeSummaries)) { return result; } //查当前layer的CDSEM Size Summary,为了获取NO List<String> currentLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getCurrentLayer) .collect(Collectors.toList()); List<String> referenceLayerNameList = markAutoGenerateDTO.getReferenceLayers().stream() .map(MarkAutoGenerateLayerDTO::getReferenceLayer) .collect(Collectors.toList()); //根据current layer拉取本系统的CDSEM ovl tree信息 和 size summary信息 String projectId = markSizeUtils.getProjectId(markAutoGenerateDTO.getProjectId()); LambdaQueryWrapper<LfmsDesignRecord> designRecordQueryWrapper = new LambdaQueryWrapper<>(); designRecordQueryWrapper.select(LfmsDesignRecord::getMainVersion, LfmsDesignRecord::getSubVersion) .eq(LfmsDesignRecord::getProjAbbr, markAutoGenerateDTO.getProject()) .eq(LfmsDesignRecord::getProjId, projectId) .eq(LfmsDesignRecord::getPart, markAutoGenerateDTO.getPart()) .eq(LfmsDesignRecord::getProjType, markAutoGenerateDTO.getTypeName()); //获取最新的mainVersion和subVersion List<LfmsDesignRecord> lfmsDesignRecords = designRecordMapper.selectList(designRecordQueryWrapper); String mainVersion = lfmsDesignRecords.stream().map(LfmsDesignRecord::getMainVersion) .filter(Objects::nonNull).max(String::compareTo).orElse(null); if (!StringUtils.hasText(mainVersion)) { log.error("没有获取到refer layer最新mainVersion"); return result; } String subVersion = lfmsDesignRecords.stream().filter(item -> Objects.equals(mainVersion, item.getMainVersion())) .map(LfmsDesignRecord::getSubVersion) .filter(Objects::nonNull).max(String::compareTo).orElse(null); if (!StringUtils.hasText(subVersion)) { log.error("没有获取到refer layer最新subVersion"); return result; } String rKey = String.join("@", markAutoGenerateDTO.getProject(), markAutoGenerateDTO.getPart(), mainVersion, projectId, markAutoGenerateDTO.getTypeName()); // 拉取本系统 的ovl tree信息 LambdaQueryWrapper<LfmsIboCdsemDboOvl> ovlQueryWrapper = new LambdaQueryWrapper<>(); ovlQueryWrapper.eq(LfmsIboCdsemDboOvl::getReticleKey, rKey) .eq(LfmsIboCdsemDboOvl::getSubVersion, subVersion) .eq(LfmsIboCdsemDboOvl::getOvlType, "OVL").eq(LfmsIboCdsemDboOvl::getOiType, "CDSEM") .in(LfmsIboCdsemDboOvl::getLayerName, referenceLayerNameList) .select(LfmsIboCdsemDboOvl::getLayerName, LfmsIboCdsemDboOvl::getMarkTree); List<LfmsIboCdsemDboOvl> ovlTreeList = iboCdsemDboOvlMapper.selectList(ovlQueryWrapper); if (CollectionUtils.isEmpty(ovlTreeList)) { return result; } //current Map<String, List<LfmsIboCdsemDboOvl>> currentOvlTreeSummarieMap = ovlTreeSummaries.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); //reference Map<String, List<LfmsIboCdsemDboOvl>> ovlTreeSummarieMap = ovlTreeList.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); for (String s : currentLayerNameList) { List<LfmsIboCdsemDboOvl> currentLfmsIboCdsemDboOvlList = currentOvlTreeSummarieMap.get(s); if(CollectionUtils.isEmpty(currentLfmsIboCdsemDboOvlList)){ continue; } List<LfmsIboCdsemDboOvl> referenceLfmsIboCdsemDboOvlList = ovlTreeSummarieMap.get(s); if(CollectionUtils.isEmpty(referenceLfmsIboCdsemDboOvlList)){ continue; } for (LfmsIboCdsemDboOvl lfmsIboCdsemDboOvl : currentLfmsIboCdsemDboOvlList) { for (LfmsIboCdsemDboOvl iboCdsemDboOvl : referenceLfmsIboCdsemDboOvlList) { if(lfmsIboCdsemDboOvl.getMarkTree().equals(iboCdsemDboOvl.getMarkTree().replaceAll("[a-zA-Z]", ""))){ lfmsIboCdsemDboOvl.setMarkTree(iboCdsemDboOvl.getMarkTree()); result.add(lfmsIboCdsemDboOvl); } } } } return result; } private List<IboMarkAutoResultVO> assembleSizeSummary(List<MarkAutoGenerateLayerDTO> referenceLayers, Map<String, List<TMainOvlApply>> mainOvlMap, List<LfmsIboCdsemDboOvl> ovlTreeSummaries, List<LfmsIboCdsemDboSizeSummary> iboSizeSummaries) { List<IboMarkAutoResultVO> result = new ArrayList<>(); Map<String, List<LfmsIboCdsemDboOvl>> currentOvlTreeSummarieMap = ovlTreeSummaries.stream().collect(Collectors.groupingBy(LfmsIboCdsemDboOvl::getLayerName)); //优先级排序：BSL mark> backup mark > LM KPI数值 List<LfmsIboCdsemDboSizeSummary> ovlSizeSummaryList = new ArrayList<>(); IboMarkAutoResultVO iboMarkAutoResultVO; for (int i = 0; i < referenceLayers.size(); i++) { MarkAutoGenerateLayerDTO referenceLayer = referenceLayers.get(i); iboMarkAutoResultVO = new IboMarkAutoResultVO(); iboMarkAutoResultVO.setLayerName(referenceLayer.getCurrentLayer()); List<LfmsIboCdsemDboOvl> ovlTreeSummarieList = currentOvlTreeSummarieMap.get(referenceLayer.getReferenceLayer()); if (CollectionUtils.isEmpty(ovlTreeSummarieList)) { continue; } List<TMainOvlApply> tMainOvlApplyList = mainOvlMap.get(referenceLayer.getReferenceLayer()); for (LfmsIboCdsemDboOvl lfmsIboCdsemDboOvl : ovlTreeSummarieList) { if (StringUtils.isEmpty(lfmsIboCdsemDboOvl.getMarkTree())) { continue; } List<String> markTreeList = StringPermutations.generatePermutations(lfmsIboCdsemDboOvl.getMarkTree()); //首先markTree 完全匹配 //这个地方要修改为匹配 List<TMainOvlApply> matchOvlApplyList = tMainOvlApplyList.stream().filter(f -> markTreeList.contains(f.getOvlTree().replaceAll("[a-zA-Z]", ""))).collect(Collectors.toList()); if (!CollectionUtils.isEmpty(matchOvlApplyList)) { //完全匹配一条 if (matchOvlApplyList.size() == 1) { TMainOvlApply minOvlApply = matchOvlApplyList.get(0); fillSizeSummary(lfmsIboCdsemDboOvl, minOvlApply, iboMarkAutoResultVO,result); } else { //走规则 //规则1.[BSL mark] List<TMainOvlApply> bslMarkOvlApplyList = tMainOvlApplyList.stream().filter(f -> !Objects.isNull(f.getIfBaselineMark()) && f.getIfBaselineMark().equals("Y")).collect(Collectors.toList()); if (!CollectionUtils.isEmpty(bslMarkOvlApplyList) && bslMarkOvlApplyList.size() == 1) { TMainOvlApply minOvlApply = bslMarkOvlApplyList.get(0); fillSizeSummary(lfmsIboCdsemDboOvl, minOvlApply, iboMarkAutoResultVO,result); continue; } //规则2.[Backup mark] bslMarkOvlApplyList = tMainOvlApplyList.stream().filter(f -> !Objects.isNull(f.getIfBackUp()) && f.getIfBackUp().equals("Y")).collect(Collectors.toList()); if (!CollectionUtils.isEmpty(bslMarkOvlApplyList) && bslMarkOvlApplyList.size() == 1) { TMainOvlApply minOvlApply = bslMarkOvlApplyList.get(0); fillSizeSummary(lfmsIboCdsemDboOvl, minOvlApply, iboMarkAutoResultVO,result); continue; } //规则3.[LM KPI] 通过对比“ROPI”值, max(X,Y) 越小越好（对于在KPI系统中没有填数值或为NA的，当成KPI最差。） X:5,Y:8 取8 最后min Optional<TMainOvlApply> optMarkTypeOvlApply = tMainOvlApplyList.stream().min((p1, p2) -> Double.compare(sumStrSymbol(p1.getQnerutOutMs(), "-") + sumStrSymbol(p1.getQnerutInMs(), "-"), sumStrSymbol(p2.getQnerutOutMs(), "-") + sumStrSymbol(p2.getQnerutInMs(), "-"))); TMainOvlApply minOvlApply = optMarkTypeOvlApply.get(); if (!Objects.isNull(minOvlApply)) { fillSizeSummary(lfmsIboCdsemDboOvl, minOvlApply, iboMarkAutoResultVO,result); } } } } } return result; } public static double sumStrSymbol(String str, String symbol) { String[] strings = str.split(symbol); return Double.parseDouble(strings[0]) + Double.parseDouble(strings[1]); } @Autowired private LfmsOvlTreeMarkSizeSummaryMapper lfmsOvlTreeMarkSizeSummaryMapper; private void fillSizeSummary(LfmsIboCdsemDboOvl lfmsIboCdsemDboOvl, TMainOvlApply tMainOvlApply, IboMarkAutoResultVO ovlMarkAutoResultVO,List<IboMarkAutoResultVO> result) { //1.set treeSummaryList if(CollectionUtils.isEmpty(ovlMarkAutoResultVO.getIboTreeSummaryList())){ ovlMarkAutoResultVO.setIboTreeSummaryList(new ArrayList<>()); } TreeSummaryVO treeSummaryVO = new TreeSummaryVO(); treeSummaryVO.setMarkTree(tMainOvlApply.getOvlTree()); LambdaQueryWrapper<LfmsOvlTreeMarkSizeSummary> ovlTreeMarkSizeSummaryWrapper = new LambdaQueryWrapper<>(); ovlTreeMarkSizeSummaryWrapper.eq(LfmsOvlTreeMarkSizeSummary::getMasterId,tMainOvlApply.getId()); ovlTreeMarkSizeSummaryWrapper.eq(LfmsOvlTreeMarkSizeSummary::getArchive,0); List<LfmsOvlTreeMarkSizeSummary> lfmsOvlTreeMarkSizeSummaryList = lfmsOvlTreeMarkSizeSummaryMapper.selectList(ovlTreeMarkSizeSummaryWrapper); List<SizeSummaryVO> sizeSummaryList = new ArrayList<>(); if(!CollectionUtils.isEmpty(lfmsOvlTreeMarkSizeSummaryList)){ for (LfmsOvlTreeMarkSizeSummary lfmsOvlTreeMarkSizeSummary : lfmsOvlTreeMarkSizeSummaryList) { SizeSummaryVO target = new SizeSummaryVO(); // 复制同名属性（忽略不匹配属性） BeanUtils.copyProperties(lfmsOvlTreeMarkSizeSummary, target); sizeSummaryList.add(target); } } //2.set sizeSummaryList treeSummaryVO.setSizeSummaryList(sizeSummaryList); ovlMarkAutoResultVO.getIboTreeSummaryList().add(treeSummaryVO); result.add(ovlMarkAutoResultVO); } /** * 组合sizeSummary * * @param ovlApply * @param sizeSummary */ private void assemble(TMainOvlApply ovlApply, LfmsIboCdsemDboSizeSummary sizeSummary) { sizeSummary.setCd(ovlApply.getMarkSizeCd()); sizeSummary.setPitch(ovlApply.getMarkSizePitch()); sizeSummary.setSegType(ovlApply.getMarkSizeSegType()); sizeSummary.setTone(ovlApply.getMarkSizeTone()); sizeSummary.setSizeType(ovlApply.getMarkSizeSizeType()); sizeSummary.setMarkType(ovlApply.getMarkSizeMarkType()); sizeSummary.setStdMarkType(ovlApply.getMarkSizeStdMarkType()); sizeSummary.setOvlSizeType("size"); sizeSummary.setAdditionRemark("'layer':" + ovlApply.getLayerName() + ",'mark':" + ovlApply.getCurrentMarkSize()); } private String assembleSizeSummary2(List<MarkAutoGenerateLayerDTO> referenceLayers, Map<String, List<Map<String, Object>>> ovlTreeSizeMap, List<LfmsIboCdsemDboOvl> ovlTreeSummaries, List<LfmsIboCdsemDboCdsemSize> existCdsemSizeSummaries) { if (CollectionUtils.isEmpty(ovlTreeSummaries)) { } List<LfmsIboCdsemDboCdsemSize> sourceSizeSummaryList = new ArrayList<>(); //优先级排序：BSL mark> backup mark > LM KPI数值 List<LfmsIboCdsemDboCdsemSize> addSizeList = new ArrayList<>(); for (int i = 0; i < referenceLayers.size(); i++) { MarkAutoGenerateLayerDTO referenceLayer = referenceLayers.get(i); Set<String> markTreeSet = ovlTreeSummaries.stream().filter(ovlTree -> Objects.equals(ovlTree.getLayerName(), referenceLayer.getCurrentLayer())) .map(LfmsIboCdsemDboOvl::getMarkTree).collect(Collectors.toSet()); //当前layer 的markTree 匹配对应KPI系统的ovlTree，匹配到的数据就做mark size summary新增操作，然后ovl tree数据做修改size type（eg：A、B、C）操作， Map<String, Object> markTreeMap = ovlTreeSizeMap.get(referenceLayer.getReferenceLayer()).stream() .filter(ovlTreeSize -> markTreeSet.contains(((String) ovlTreeSize.get("markTreeMap")).replaceAll("[a-zA-Z]", ""))) .findAny().orElse(null); if (CollectionUtils.isEmpty(markTreeMap)) { continue; } //获取sizeSummary最大NO，后续新增操作，NO依次递增 BigDecimal maxNo = existCdsemSizeSummaries.stream() .filter(ovlSizeSummary -> Objects.equals(ovlSizeSummary.getLayerName(), referenceLayer.getCurrentLayer())) .map(LfmsIboCdsemDboCdsemSize::getNo).max(BigDecimal::compareTo) .orElse(new BigDecimal(0)); LfmsIboCdsemDboCdsemSize sizeSummary = new LfmsIboCdsemDboCdsemSize(); int j = 1; if (null != markTreeMap.get("sizeSummary")) { LfmsIboCdsemDboCdsemSize sourceSizeSummary = (LfmsIboCdsemDboCdsemSize) markTreeMap.get("sizeSummary"); BeanUtils.copyProperties(sourceSizeSummary, sizeSummary); sizeSummary.setLayerName(referenceLayer.getCurrentLayer()); sizeSummary.setReticleKey(ovlTreeSummaries.get(0).getReticleKey()); sizeSummary.setMarkCountKey(ovlTreeSummaries.get(0).getMarkCountKey()); sizeSummary.setSubVersion(ovlTreeSummaries.get(0).getSubVersion()); sizeSummary.setNo(maxNo.add(new BigDecimal(j))); sizeSummary.setAdditionRemark("'layer':" + referenceLayer.getReferenceLayer() + ",'project':" + sourceSizeSummary.getReticleKey()); sourceSizeSummaryList.add(sizeSummary); j++; } //修改ovlTreeSummary里的markTree String markTree = (String) markTreeMap.get("markTreeMap"); ovlTreeSummaries.stream().filter(ovlTree -> Objects.equals(ovlTree.getLayerName(), referenceLayer.getCurrentLayer())) .filter(ovlTree -> Objects.equals(ovlTree.getMarkTree(), markTree.replaceAll("[a-zA-Z]", ""))) .findFirst() .ifPresent(ovlTree -> ovlTree.setMarkTree(markTree)); } addSizeList.forEach(markSize -> iboCdsemDboCdsemSizeMapper.insert(markSize)); iboCdsemDboOvlMapper.updateBatch(ovlTreeSummaries); return ""; } /** * 根据T_MAIN_OVL_APPLY表ifBaselineMark字段判断 * * @param mainOvlList * @return */ private TMainOvlApply ovlBSLMark(List<TMainOvlApply> mainOvlList) { List<TMainOvlApply> baseLineList = mainOvlList.stream().filter(kpiOvl -> Objects.equals("Y", kpiOvl.getIfBaselineMark())).collect(Collectors.toList()); if (CollectionUtils.isEmpty(baseLineList)) { return ovlBackUpMark(mainOvlList); } else if (baseLineList.size() == 1) { return baseLineList.get(0); } else { return ovlBackUpMark(baseLineList); } } /** * 根据T_MAIN_OVL_APPLY表ifBackUp字段判断 * * @param mainOvlList * @return */ private TMainOvlApply ovlBackUpMark(List<TMainOvlApply> mainOvlList) { List<TMainOvlApply> backUpList = mainOvlList.stream().filter(kpiOvl -> Objects.equals("Y", kpiOvl.getIfBackUp())).collect(Collectors.toList()); if (CollectionUtils.isEmpty(backUpList)) { //todo 从系统对比“ROPI”值 qnerutOutMs/qnerutInMs return mainOvlList.get(0); } else if (backUpList.size() == 1) { return backUpList.get(0); } else { //todo 从系统对比“ROPI”值 return backUpList.get(0); } } } markAutoGenerate将这个关联方法进行优化
11-20
4. 将三个数据准备部分（ibo, cdsem, cover）的结果提前转换为按层名分组的Map，这样在组装结果时可以直接通过层名获取 具体步骤： - 将iboMarkAutoResultVOList转换为按层名分组的Map（层名->IboMarkAutoResultVO...
Mysql 报错Parameter ‘@xxx‘ must be defined
大黄鸭在发光的专栏
01-17 1489
Mysql 报错Parameter '@xxx' must be defined
MySql.Data.MySqlClient.MySqlException: Parameter ‘@maxid’ must be defined
weixin_30758821的博客
10-18 916
本文涉及到的mysql知识点： mysql中的if条件语句用法：IF(expr1,expr2,expr3) mysql使用变量（mysql中变量不用事前申明） mysql事务 testcase 为了测试mysql事务，写了个testcase， using Microsoft.VisualStudio.TestTools.UnitTesting; using MySql....
关于MYSQL报Fatal error encountered during command execution. （Parameter ‘@var‘ must be defined.）错误的解决方法
qq_37823627的博客
02-28 2040
关于MYSQL报Fatal error encountered during command execution. （Parameter '@var' must be defined.）错误的解决方法
mysql查询加伪列_MySql数据库 sql查询增加序号的伪列
weixin_33125137的博客
01-20 496
在查询数据库的时候，我们有时候需要对查询出来的数据加上序列，1,2,3，……n例如：我们根据表的某个字段排序后，要对这些数据加上序列，这个时候序号常常不是我们建表时设置好的自增的主键id，怎么办呢？？？？可能我们会用变量来解决，如下set @rownum=0;SELECT @rownum:=@rownum+1 AS rownum, table_name.*FROM table_name如果在数据...
ado的mysql参数化_ADO.NET基础参数化SQL查询
weixin_42298415的博客
03-03 348
参数化查询(Parameterized Query )是指在设计与数据库链接并访问数据时，在需要填入数值或数据的地方，使用参数 (Parameter) 来给值，这个方法目前已被视为最有效可预防SQL注入攻击 (SQL Injection) 的攻击手法的防御方式。下面将重点总结下Parameter构建的几种常用方法。说起参数化查询当然最主要的就是如何构造所谓的参数：比如，我们登陆时需要密码和用户名，...
C# Mysql 查询 Rownum的解决方法
火翼小熊
06-05 8277
C# 一段程序如下，执行出错，错误信息是 “Parameter '@rowNum' must be defined” 但是直接在 mySql workbatch 中运行是正确的！！ 原因和在？  搜索一下，看到老外的网站说 连接串要加上 ：  “Allow User Variables=True”, 再试验一次，发现可以了！！                string mySqlConn
MYSQL批量导入几何对象数据
dev低调者-专注优质编程、分享不一样的历程
12-27 438
MYSQL连接字符串 Allow User Variables=true。连接串里面加上这段代码,允许 SQL 中出现用户变量 关键代码 var path="c:\\a.csv"; var cmd = conn.CreateCommand(); cmd.CommandText = "LOAD DATA INFILE '"+path+ "' INTO TABLE route_line FIELDS...
Mysql--配置
wanxiweilai的博客
01-23 554
配置增加查询参数必须在连接数据库是声明否则会提示错误：allowuservariables=True;Allow Zero Datetime=True 变量的使用 例如： Select ID From Product Where name=@name; 更改变量值： set @name:=123; 查询变量值: select @name; 不同终端的变量相互独立。 在Mysql中设置查询条件，当查询条件为空时，则忽略当前查询条件。 代码如下: select ID from wel..
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值