數(shù)據(jù)庫中有下劃線的字段在實體中應采用駝峰命名法，如P_NAME對應pName,實例如下：
1.XML文件中SQL語句配置（Geteway.xml文件）
?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文件）
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語句的配置 ，希望對大家有所幫助，如果大家有任何疑問歡迎給我留言，小編會及時回復大家的！
標簽：遼源 中衛(wèi) 紹興 海東 自貢 昭通 寧波 百色
巨人網(wǎng)絡(luò)通訊聲明：本文標題《Oracle在Mybatis中SQL語句的配置方法》，本文關(guān)鍵詞 Oracle,在,Mybatis,中,SQL,語句,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題，煩請?zhí)峁┫嚓P(guān)信息告之我們，我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無關(guān)。
