欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

程序员文章站 2024-01-17 14:15:52
数据库中有下划线的字段在实体中应采用驼峰命名法,如p_name对应pname,实例如下: 1.xml文件中sql语句配置(geteway.xml文件) <...

数据库中有下划线的字段在实体中应采用驼峰命名法,如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语句的配置 ,希望对大家有所帮助