Oracle在Mybatis中SQL语句的配置方法

时间:2022-05-20 00:41:27

数据库中有下划线的字段在实体中应采用驼峰命名法,如P_NAME对应pName,实例如下:

1.XML文件中SQL语句配置(Geteway.xml文件)

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.soecode.hbdw.gateway.dao.GatewayDao">
 <cache></cache>
 <!-- 目的:为dao接口方法提供sql语句配置 -->
 <select id="queryById" resultType="Gateway" parameterType="int">
 <!-- 具体的sql -->
 SELECT
   *
 FROM
  P_GATEWAY
 WHERE
  GATEWAY_ID = #{gatewayId}
 </select>
 <select id="queryByName" resultType="Gateway" parameterType="java.lang.String">
 <!-- 具体的sql -->
 SELECT
  *
 FROM
  P_GATEWAY
 WHERE
  GATEWAY_NAME=#{gatewayName}
 </select>
 <delete id="delGateway" parameterType="java.lang.Integer">
   DELETE
   FROM
   P_GATEWAY
   WHERE
   GATEWAY_ID = #{gatewayId}
 </delete>
 <update id="updateGateway" >
 <!-- ignore 主键冲突,报错 -->
   UPDATE P_GATEWAY
   SET
   GATEWAY_NAME= #{gatewayName},
   GATEWAY_NUM= #{gatewayNum},
   GATEWAY_NATURE= #{gatewayNature},
   GATEWAY_SUPPLY= #{gatewaySupply},
   REMARK= #{remark}
   WHERE
   GATEWAY_ID = #{gatewayId}
 </update>
</mapper>

2.entity实体配置(Gateway.java文件)

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
package com.soecode.hbdw.gateway.entity;
import java.io.Serializable;
import java.util.Date;
public class Gateway implements Serializable{
 /**
 *
 */
 private static final long serialVersionUID = 1L;
 private int gatewayId;
 private String gatewayName;
 private String gatewayNum;
 private String gatewayNature;
 private String gatewaySupply;
 private String remark;
 public int getGatewayId() {
 return gatewayId;
 }
 public void setGatewayId(int gatewayId) {
 this.gatewayId = gatewayId;
 }
 public String getGatewayName() {
 return gatewayName;
 }
 public void setGatewayName(String gatewayName) {
 this.gatewayName = gatewayName;
 }
 public String getGatewayNum() {
 return gatewayNum;
 }
 public void setGatewayNum(String gatewayNum) {
 this.gatewayNum = gatewayNum;
 }
 public String getGatewayNature() {
 return gatewayNature;
 }
 public void setGatewayNature(String gatewayNature) {
 this.gatewayNature = gatewayNature;
 }
 public String getGatewaySupply() {
 return gatewaySupply;
 }
 public void setGatewaySupply(String gatewaySupply) {
 this.gatewaySupply = gatewaySupply;
 }
 public String getRemark() {
 return remark;
 }
 public void setRemark(String remark) {
 this.remark = remark;
 }
 public static long getSerialversionuid() {
 return serialVersionUID;
 }
 @Override
 public String toString() {
 return "Gateway [gatewayId=" + gatewayId + ", gatewayName="
  + gatewayName + ", gatewayNum=" + gatewayNum
  + ", gatewayNature=" + gatewayNature + ", gatewaySupply="
  + gatewaySupply + ", remark=" + remark + "]";
 }
}

以上所述是小编给大家介绍的Oracle在Mybatis中SQL语句的配置 ,希望对大家有所帮助,如果大家有任何疑问欢迎给我留言,小编会及时回复大家的!

原文链接:http://blog.csdn.net/jnx1142410525/article/details/63252802