mybatis与Oracle中字段,Oracle在Mybatis中SQL语句的配置方法

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

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

sql;">

gt;

SELECT

*

FROM

P_GATEWAY

WHERE

GATEWAY_ID = #{gatewayId}

SELECT

*

FROM

P_GATEWAY

WHERE

GATEWAY_NAME=#{gatewayName}

UPDATE P_GATEWAY

SET

GATEWAY_NAME= #{gatewayName},GATEWAY_NUM= #{gatewayNum},GATEWAY_NATURE= #{gatewayNature},GATEWAY_SUPPLY= #{gatewaySupply},REMARK= #{remark}

WHERE

GATEWAY_ID = #{gatewayId}

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

sql;">

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语句的配置 ，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的！

总结

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。