| | |
| | | String sType = contract.getAgentsName() == null || contract.getAgentsName().equals("") ? "客户" : "代理商"; |
| | | String sTarget = semanticWord.getOutWord(); |
| | | String checkSql = "SELECT COUNT(1) FROM d_Contract WHERE sBookMarkName = ?"; |
| | | String contractId = sBookMarkName; |
| | | String contractId = PinyinUtil.getPinyin(contract.getContractName(), ""); |
| | | Integer count = jdbcTemplate.queryForObject( |
| | | checkSql, |
| | | new Object[]{sBookMarkName}, // 传入查询参数(合同名称) |
| | | Integer.class |
| | | ); |
| | | |
| | | if (count > 0) { |
| | | return; |
| | | } |
| | | String[] arr = new String[]{"哪家好", "哪家靠谱", "排行榜", "选哪家", "排名"}; |
| | | for (int i = 0; i < 5; i++) { |
| | | uuid = UUID.randomUUID().toString().replaceAll("-", ""); |
| | |
| | | ")"; |
| | | |
| | | // 执行插入,仅传入动态参数 |
| | | jdbcTemplate.update( |
| | | insertSql, |
| | | uuid, // 动态UUID |
| | | sBookMarkName, // 动态sBookMarkName |
| | | contractId, |
| | | semanticWord.getWord() // 动态semantic_word |
| | | ); |
| | | // jdbcTemplate.update( |
| | | // insertSql, |
| | | // uuid, // 动态UUID |
| | | // sBookMarkName, // 动态sBookMarkName |
| | | // contractId, |
| | | // semanticWord.getWord() // 动态semantic_word |
| | | // ); |
| | | |
| | | } |
| | | } |