Mybatis自己写mapper.xml

红太狼 2022-05-25 23:14 267阅读 0赞

1、mapper.xml 里面自己写文件

<select id="countByPduName" resultType="java.lang.Integer" parameterType="java.lang.String" >
        select 
        count(id)
        from t_envnew
        where name = #{name,jdbcType=VARCHAR}
      </select>

2、mapper类

int countByPduName(String name);

3、调用方法，里面含有自己写的数据库这种格式的拼接方法

注意要调用Mapper方法，必须要在Service里调用，只有在Service里面才能注入Mapper方法成功

[{"jobName":"PduOne-ModuleOne-build","version":"main_dev1.0.0"},{"jobName":"PduOne-ModuleOne-dev","version":"main_dev1.0.0"},{"jobName":"PduOne-ModuleOne-test","version":"main_dev1.0.0"}]

@Override
    	public boolean addEnvNew(String pduName, String jobName, String branch) {
    		int i = 0;
    		try {
    			StringBuilder sBuilder = new StringBuilder();
    			JSONObject jsonThree = new JSONObject();
    			int envNews = envNewMapper.countByPduName(pduName);
    			if (envNews == 0) {
    				Map map = new HashMap();
    				map.put("jobName", jobName);// map里面装有yes
    				map.put("version", branch);
    				String str = JSON.toJSONString(map);
    				sBuilder.append(str);
    				String stringnew = "[" + sBuilder + "]";
    				EnvNew envNew = new EnvNew();
    				envNew.setName(pduName);
    				envNew.setService(stringnew);
    				envNewMapper.insert(envNew);
    				return true;
    			} else {
    				List<EnvNew> envNewList = envNewMapper.selectByPduName(pduName);
    				if (envNewList.size() > 0) {
    					i = envNewMapper.selectIDByPduName(pduName);
    					for (EnvNew envNew : envNewList) {
    						String server = envNew.getService();
    						String servernew = server.replace("[", "").replace("]", "").trim();
    						sBuilder.append(servernew);
    						System.out.println(server);
    					}
    				}
    
    				Map map = new HashMap();
    				map.put("jobName", jobName);// map里面装有yes
    				map.put("version", branch);
    				String str = JSON.toJSONString(map);
    				sBuilder.append(",");
    				sBuilder.append(str);
    				String stringnew = "[" + sBuilder + "]";
    				EnvNew envNew = new EnvNew();
    				if (envNewList.size() > 0) {
    					envNew.setId(i);
    				}
    				envNew.setName(pduName);
    				envNew.setService(stringnew);
    				envNewMapper.updateByPrimaryKey(envNew);
    				System.out.println(jsonThree.toString());
    				return true;
    			}
    		} catch (Exception e) {
    			// TODO: handle exception
    			Date date = new Date();
    			String msg = String.format(pduName + "/" + jobName + "/" + date + ":" + e.getCause());
    			logger.error("向envnew数据表增加数据报错:" + msg);
    			return false;
    		}
    
    	}