Oracle在Mybatis中SQL语句的配置

数据库中有下划线的字段在实体中应采用驼峰命名法，如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 + "]";
	}
}