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

数据库  /  管理员 发布于 6年前   187

数据库中有下划线的字段在实体中应采用驼峰命名法，如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语句的配置 ，希望对大家有所帮助，如果大家有任何疑问欢迎给我留言，小编会及时回复大家的！