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

2024-02-27 08:12:08 232

SELECT * FROM P_GATEWAY WHERE GATEWAY_ID=#{gatewayId} SELECT * FROM P_GATEWAY WHERE GATEWAY_NAME=#{gatewayName} DELETE FROM P_GATEWAY WHERE GATEWAY_ID=#{gatewayId} UPDATEP_GATEWAY SET GATEWAY_NAME=#{gatewayName}, GATEWAY_NUM=#{gatewayNum}, GATEWAY_NATURE=#{gatewayNature}, GATEWAY_SUPPLY=#{gatewaySupply}, REMARK=#{remark} WHERE GATEWAY_ID=#{gatewayId}

packagecom.soecode.hbdw.gateway.entity; importjava.io.Serializable; importjava.util.Date; publicclassGatewayimplementsSerializable{ /** * */ privatestaticfinallongserialVersionUID=1L; privateintgatewayId; privateStringgatewayName; privateStringgatewayNum; privateStringgatewayNature; privateStringgatewaySupply; privateStringremark; publicintgetGatewayId(){ returngatewayId; } publicvoidsetGatewayId(intgatewayId){ this.gatewayId=gatewayId; } publicStringgetGatewayName(){ returngatewayName; } publicvoidsetGatewayName(StringgatewayName){ this.gatewayName=gatewayName; } publicStringgetGatewayNum(){ returngatewayNum; } publicvoidsetGatewayNum(StringgatewayNum){ this.gatewayNum=gatewayNum; } publicStringgetGatewayNature(){ returngatewayNature; } publicvoidsetGatewayNature(StringgatewayNature){ this.gatewayNature=gatewayNature; } publicStringgetGatewaySupply(){ returngatewaySupply; } publicvoidsetGatewaySupply(StringgatewaySupply){ this.gatewaySupply=gatewaySupply; } publicStringgetRemark(){ returnremark; } publicvoidsetRemark(Stringremark){ this.remark=remark; } publicstaticlonggetSerialversionuid(){ returnserialVersionUID; } @Override publicStringtoString(){ return"Gateway[gatewayId="+gatewayId+",gatewayName=" +gatewayName+",gatewayNum="+gatewayNum +",gatewayNature="+gatewayNature+",gatewaySupply=" +gatewaySupply+",remark="+remark+"]"; } }

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

热门推荐

随机推荐