Mybatis自己写mapper.xml

最新推荐文章于 2023-12-06 20:23:06 发布

原创最新推荐文章于 2023-12-06 20:23:06 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis

MyBaties 专栏收录该内容

5 篇文章

订阅专栏

本文档介绍了如何在Mybatis中自定义mapper.xml文件，包括编写步骤和mapper类的设置。同时，强调了调用mapper方法必须在Service层进行，以确保Mapper的正确注入和方法调用。

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;
		}

	}