Oracle在Mybatis中SQL语句的配置方法
数据库中有下划线的字段在实体中应采用驼峰命名法,如P_NAME对应pName,实例如下:
1.XML文件中SQL语句配置(Geteway.xml文件)
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}
2.entity实体配置(Gateway.java文件)
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语句的配置,希望对大家有所帮助,如果大家有任何疑问欢迎给我留言,小编会及时回复大家的!
热门推荐
1 训练狗狗憋尿
2 狗狗追踪训练
3 狗狗训练要多少钱
5 深圳狗狗训练
6 训练狗狗唤回
7 狗狗叫怎么训练
8 狗狗训练班
10 狗狗社会化训练
11 狗狗叫回训练
12 广州狗狗训练学校
13 狗狗训练躺下
14 狗狗随行训练
15 训练狗狗巡回
16 狗狗要怎么训练
17 狗狗喂食训练
18 训练狗狗躺下