數據庫中有下劃線的字段在實體中應采用駝峰命名法，如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
