Mybatis Mysql

最新推荐文章于 2025-03-19 13:59:25 发布
最新推荐文章于 2025-03-19 13:59:25 发布
阅读量969 收藏
点赞数
CC 4.0 BY-SA版权
分类专栏： Sql Mybatis
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_29246225/article/details/54946492

Bean

package com.weshop.service.bean;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.weshop.core.dao.QueryModel;
import com.weshop.web.util.BaseEnums.OrderStatus;


public class Order extends QueryModel implements Serializable {
    
	private static final long serialVersionUID = 1L;
    private String orderid;
    private String merchantid;
    private Date receivedate;
    private String memberid;
    private Date paymentdate;
    private Integer orderstatus;
    private Date deliverdate;

    private BigDecimal paymentfee;

    private String paymentname;

    private String posttype;

    private String invoicename;

    private String invoicecontent;

    private Boolean invoicetype;

    private Date createdate;

    private Date modifydate;

    private String createuser;

    private String modifieduser;

    private String customermessage;
     
    private String statusstr;
    
    private Integer reviewstatus;
	
    private String shopName;
    
    private String orderinfo;
    
    private long readability;
    
    private String OrderproductName;
    
    private String  userphone;
    
    private String  servicephone;
    
	public String getServicephone() {
		return servicephone;
	}

	public void setServicephone(String servicephone) {
		this.servicephone = servicephone;
	}

	public String getUserphone() {
		return userphone;
	}

	public void setUserphone(String userphone) {
		this.userphone = userphone;
	}

	public String getOrderproductName() {
		return OrderproductName;
	}

	public void setOrderproductName(String orderproductName) {
		OrderproductName = "%"+orderproductName+"%";
	}

	private List<ExpressInfo> erxpressInfo = new ArrayList<ExpressInfo>();
   

	public List<ExpressInfo> getErxpressInfo() {
		return erxpressInfo;
	}

	public void setErxpressInfo(List<ExpressInfo> erxpressInfo) {
		this.erxpressInfo = erxpressInfo;
	}

	public long getReadability() {
		return readability;
	}

	public void setReadability(long readability) {
		this.readability = readability;
	}

	public String getOrderinfo() {
		return orderinfo;
	}

	public void setOrderinfo(String orderinfo) {
		this.orderinfo = orderinfo;
	}

	public String getShopName() {
		return shopName;
	}

	public void setShopName(String shopName) {
		this.shopName = shopName;
	}


	public Integer getReviewstatus() {
		return reviewstatus;
	}

	public void setReviewstatus(Integer reviewstatus) {
		this.reviewstatus = reviewstatus;
	}

	public String getStatusstr() {
		return statusstr=OrderStatus.getName(orderstatus+"");
	}

	public void setStatusstr(String statusstr) {
		this.statusstr = statusstr;
	}

	private List<OrderProduct> orderProductlist = new ArrayList<OrderProduct>(); 
    

//	private List<OrderProduct> orderProducts= new ArrayList<OrderProduct>();
//    
//  public List<OrderProduct> getOrerProducts() {
//		return orderProducts;
//	}
//
//	public void setOrerProducts(List<OrderProduct> orderProducts) {
//		this.orderProducts = orderProducts;
//	}

	
    public List<OrderProduct> getOrderProductlist() {
		return orderProductlist;
	}

	public void setOrderProductlist(List<OrderProduct> orderProductlist) {
		this.orderProductlist = orderProductlist;
	}

	public String getOrderid() {
        return orderid;
    }

    public void setOrderid(String orderid) {
        this.orderid = orderid == null ? null : orderid.trim();
    }

    public String getMerchantid() {
        return merchantid;
    }

    public void setMerchantid(String merchantid) {
        this.merchantid = merchantid == null ? null : merchantid.trim();
    }

    public Date getReceivedate() {
        return receivedate;
    }

    public void setReceivedate(Date receivedate) {
        this.receivedate = receivedate;
    }

    public String getMemberid() {
        return memberid;
    }

    public void setMemberid(String memberid) {
        this.memberid = memberid == null ? null : memberid.trim();
    }

    public Date getPaymentdate() {
        return paymentdate;
    }

    public void setPaymentdate(Date paymentdate) {
        this.paymentdate = paymentdate;
    }

    public Integer getOrderstatus() {
        return orderstatus;
    }

    public void setOrderstatus(Integer orderstatus) {
        this.orderstatus = orderstatus;
    }

    public Date getDeliverdate() {
        return deliverdate;
    }

    public void setDeliverdate(Date deliverdate) {
        this.deliverdate = deliverdate;
    }

    public BigDecimal getPaymentfee() {
        return paymentfee;
    }

    public void setPaymentfee(BigDecimal paymentfee) {
        this.paymentfee = paymentfee;
    }

    public String getPaymentname() {
        return paymentname;
    }

    public void setPaymentname(String paymentname) {
        this.paymentname = paymentname == null ? null : paymentname.trim();
    }

    public String getPosttype() {
        return posttype;
    }

    public void setPosttype(String posttype) {
        this.posttype = posttype == null ? null : posttype.trim();
    }

    public String getInvoicename() {
        return invoicename;
    }

    public void setInvoicename(String invoicename) {
        this.invoicename = invoicename == null ? null : invoicename.trim();
    }

    public String getInvoicecontent() {
        return invoicecontent;
    }

    public void setInvoicecontent(String invoicecontent) {
        this.invoicecontent = invoicecontent == null ? null : invoicecontent.trim();
    }

    public Boolean getInvoicetype() {
        return invoicetype;
    }

    public void setInvoicetype(Boolean invoicetype) {
        this.invoicetype = invoicetype;
    }

    public Date getCreatedate() {
        return createdate;
    }

    public void setCreatedate(Date createdate) {
        this.createdate = createdate;
    }

    public Date getModifydate() {
        return modifydate;
    }

    public void setModifydate(Date modifydate) {
        this.modifydate = modifydate;
    }

    public String getCreateuser() {
        return createuser;
    }

    public void setCreateuser(String createuser) {
        this.createuser = createuser == null ? null : createuser.trim();
    }

    public String getModifieduser() {
        return modifieduser;
    }

    public void setModifieduser(String modifieduser) {
        this.modifieduser = modifieduser == null ? null : modifieduser.trim();
    }

    public String getCustomermessage() {
        return customermessage;
    }

    public void setCustomermessage(String customermessage) {
        this.customermessage = customermessage == null ? null : customermessage.trim();
    }
}
Mapper 

<?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="OrderMapper">
	<resultMap id="BaseResultMap" type="com.weshop.service.bean.Order">
		<id column="orderId" property="orderid" jdbcType="VARCHAR" />
		<result column="merchantId" property="merchantid" jdbcType="VARCHAR" />
		<result column="receiveDate" property="receivedate" jdbcType="TIMESTAMP" />
		<result column="memberId" property="memberid" jdbcType="VARCHAR" />
		<result column="paymentDate" property="paymentdate" jdbcType="TIMESTAMP" />
		<result column="orderStatus" property="orderstatus" jdbcType="INTEGER" />
		<result column="deliverDate" property="deliverdate" jdbcType="TIMESTAMP" />
		<result column="paymentFee" property="paymentfee" jdbcType="DECIMAL" />
		<result column="paymentName" property="paymentname" jdbcType="VARCHAR" />
		<result column="postType" property="posttype" jdbcType="VARCHAR" />
		<result column="invoiceName" property="invoicename" jdbcType="VARCHAR" />
		<result column="invoiceContent" property="invoicecontent" jdbcType="VARCHAR" />
		<result column="invoiceType" property="invoicetype" jdbcType="BIT" />
		<result column="createDate" property="createdate" jdbcType="TIMESTAMP" />
		<result column="modifyDate" property="modifydate" jdbcType="TIMESTAMP" />
		<result column="createUser" property="createuser" jdbcType="VARCHAR" />
		<result column="modifiedUser" property="modifieduser" jdbcType="VARCHAR" />

		<result column="weShopName" property="shopName" jdbcType="VARCHAR" />
		<result column="orderInfo" property="orderinfo" jdbcType="VARCHAR" />
		<result column="productName" property="OrderproductName" jdbcType="VARCHAR" />
		<result column="phone" property="userphone" jdbcType="VARCHAR" />
		<result column="servicePhone" property="servicephone" jdbcType="VARCHAR" />
	</resultMap>
	<resultMap id="ResultMapWithBLOBs" type="com.weshop.service.bean.Order"
		extends="BaseResultMap">
		<result column="customerMessage" property="customermessage"
			jdbcType="LONGVARCHAR" />
	</resultMap>
	<resultMap type="com.weshop.service.bean.Order" id="queryForListMap"
		extends="BaseResultMap">
		<result column="customerMessage" property="customermessage"
			jdbcType="LONGVARCHAR" />

		<association property="erxpressInfo"
			javaType="com.weshop.service.bean.ExpressInfo">
			<id column="expressInfoId" property="expressinfoid" jdbcType="VARCHAR" />
			<result column="orderId" property="orderid" jdbcType="VARCHAR" />
			<result column="expressSN" property="expresssn" jdbcType="VARCHAR" />
			<result column="expressFee" property="expressfee" jdbcType="DECIMAL" />
			<result column="expressCompanyId" property="expresscompanyid"
				jdbcType="VARCHAR" />
			<result column="name" property="name" jdbcType="VARCHAR" />
			<result column="phone" property="phone" jdbcType="VARCHAR" />
			<result column="address" property="address" jdbcType="VARCHAR" />
			<result column="createDate" property="createdate" jdbcType="TIMESTAMP" />
			<result column="modifyDate" property="modifydate" jdbcType="TIMESTAMP" />
			<result column="createUser" property="createuser" jdbcType="VARCHAR" />
			<result column="modifiedUser" property="modifieduser"
				jdbcType="VARCHAR" />
			<result column="expressTime" property="expresstime" jdbcType="INTEGER" />
		</association>
		
		<collection property="orderProductlist" javaType="java.util.List"
			ofType="com.weshop.service.bean.OrderProduct">
			<id column="orderProductId" property="orderProductid" jdbcType="VARCHAR" />

			<result column="productPrice" property="productprice"
				jdbcType="DECIMAL" />
			<result column="productAmount" property="productamount"
				jdbcType="INTEGER" />
			<result column="productId" property="productid" jdbcType="VARCHAR" />
			<result column="isEevaluate" property="iseevaluate" jdbcType="BIT" />
			<result column="skuOptionBunch" property="skuoptionbunch"
				jdbcType="VARCHAR" />
			<result column="productName" property="productname" jdbcType="VARCHAR" />
			<result column="productImageUrl" property="productimageurl"
				jdbcType="VARCHAR" />
			<result column="createDate" property="createdate" jdbcType="TIMESTAMP" />
			<result column="modifyDate" property="modifydate" jdbcType="TIMESTAMP" />
			<result column="createUser" property="createuser" jdbcType="VARCHAR" />
			<result column="modifiedUser" property="modifieduser"
				jdbcType="VARCHAR" />
		</collection>
	</resultMap>

	<resultMap type="com.weshop.service.bean.OrderCount" id="countResultMap">
		<result column="count" property="count" jdbcType="INTEGER" />
		<result column="orderStatus" property="orderstatus" jdbcType="INTEGER" />
	</resultMap>

	<sql id="Base_Column_List">
		orderId, merchantId, receiveDate, memberId, paymentDate,
		orderStatus,
		deliverDate,
		paymentFee, paymentName, postType,
		invoiceName, invoiceContent, invoiceType,
		createDate,
		modifyDate,
		createUser, modifiedUser,orderInfo
	</sql>
	<sql id="Blob_Column_List">
		customerMessage
	</sql>
       
	<select id="selectPageListSeeks" resultMap="queryForListMap"
		parameterType="com.weshop.service.bean.Order">
       select o.*,p.*,e.*,(select weShopName from ws_merchant where merchantId=o.merchantId) as weshopname,(select servicePhone from ws_merchant where merchantId=o.merchantId) as servicephone from ws_order o left join ws_order_product p on o.orderId=p.orderId  left join ws_express_info e on p.orderId=e.orderId where 1=1 		
		<if test="userphone != null">
			and e.phone = #{userphone}
		</if>
		<if test="orderstatus != null">
			and o.orderStatus = #{orderstatus}
		</if>
		<if test="paymentname != null">
			and o.paymentName= #{paymentname}
		</if>
		<if test="OrderproductName != null">
			and (p.productName like #{OrderproductName} or o.orderId like #{OrderproductName})
		</if>
		<if test="reviewstatus == 1">
			and p.isEevaluate =false
		</if>
		<if test="orderid != null">
			and o.orderId=#{orderid}
		</if> 
		<if test="merchantid != null">
			and o.merchantId = #{merchantid}
		</if>
		<if test="receivedate != null">
			and receiveDate = #{receivedate}
		</if>
		<if test="memberid != null">
			and memberId = #{memberid}
		</if>
		<if test="paymentdate != null">
			and paymentDate = #{paymentdate}
		</if>
		<if test="deliverdate != null">
			and deliverDate =#{deliverdate}
		</if>
		<if test="paymentfee != null">
			and paymentFee =#{paymentfee}
		</if>
		<if test="posttype != null">
			and postType=#{posttype}
		</if>
		<if test="invoicename != null">
			and invoiceName=#{invoicename}
		</if>
		<if test="invoicecontent != null">
			and invoiceContent=#{invoicecontent}
		</if>
		<if test="invoicetype != null">
			and invoiceType =#{invoicetype}
		</if>
		<if test="startDate != null">
			and o.createDate >=#{startDate}
		</if>
		<if test="endDate != null">
			and o.createDate <=#{endDate}
		</if>
		<if test="modifydate != null">
			and modifyDate=#{modifydate}
		</if>
		<if test="createuser != null">
			and createUser=#{createuser}
		</if>
		<if test="modifieduser != null">
			and modifiedUser=#{modifieduser}
		</if>
		<if test="orderinfo != null">
			and orderInfo=#{orderinfo}
		</if>
		<if test="customermessage != null">
			and customerMessage =#{customermessage}
		</if>
		
		 order by o.createDate desc limit #{offset},#{pageSize}
	</select>
	
	 <select id="selectPagCounteSeeks" resultType="java.lang.Integer"
		parameterType="com.weshop.service.bean.Order">
		select count(*),o.*,p.*,e.*,(select weShopName from ws_merchant where merchantId=o.merchantId) as weshopname,(select servicePhone from ws_merchant where merchantId=o.merchantId) as servicephone from ws_order o left join ws_order_product p on o.orderId=p.orderId  left join ws_express_info e on p.orderId=e.orderId where 1=1 		
		<if test="userphone != null">
			and e.phone = #{userphone}
		</if>
		<if test="orderstatus != null">
			and o.orderStatus = #{orderstatus}
		</if>
		<if test="paymentname != null">
			and o.paymentName= #{paymentname}
		</if>
		<if test="OrderproductName != null">
			and (p.productName like #{OrderproductName} or o.orderId like #{OrderproductName})
		</if>
		<if test="reviewstatus == 1">
			and p.isEevaluate =false
		</if>
		<if test="orderid != null">
			and o.orderId=#{orderid}
		</if> 
		<if test="merchantid != null">
			and o.merchantId = #{merchantid}
		</if>
		<if test="receivedate != null">
			and receiveDate = #{receivedate}
		</if>
		<if test="memberid != null">
			and memberId = #{memberid}
		</if>
		<if test="paymentdate != null">
			and paymentDate = #{paymentdate}
		</if>
		<if test="deliverdate != null">
			and deliverDate =#{deliverdate}
		</if>
		<if test="paymentfee != null">
			and paymentFee =#{paymentfee}
		</if>
		<if test="posttype != null">
			and postType=#{posttype}
		</if>
		<if test="invoicename != null">
			and invoiceName=#{invoicename}
		</if>
		<if test="invoicecontent != null">
			and invoiceContent=#{invoicecontent}
		</if>
		<if test="invoicetype != null">
			and invoiceType =#{invoicetype}
		</if>
		<if test="startDate != null">
			and o.createDate >=#{startDate}
		</if>
		<if test="endDate != null">
			and o.createDate <=#{endDate}
		</if>
		<if test="modifydate != null">
			and modifyDate=#{modifydate}
		</if>
		<if test="createuser != null">
			and createUser=#{createuser}
		</if>
		<if test="modifieduser != null">
			and modifiedUser=#{modifieduser}
		</if>
		<if test="orderinfo != null">
			and orderInfo=#{orderinfo}
		</if>
		<if test="customermessage != null">
			and customerMessage =#{customermessage}
		</if>
	</select>
	
	
	
	<select id="selectPageList" resultMap="queryForListMap"
		parameterType="com.weshop.service.bean.Order">
		select o.*,p.*,e.*,(select weShopName from ws_merchant where merchantId=o.merchantId) as weshopname,(select servicePhone from ws_merchant where merchantId=o.merchantId) as servicephone from ws_order o left join ws_order_product p on o.orderId=p.orderId left join ws_express_info e on p.orderId=e.orderId where 1=1
		
		<if test="reviewstatus ==1 ">
			and p.isEevaluate =false
		</if>
		<if test="orderid != null">
			and orderId=#{orderid}
		</if>
		<if test="merchantid != null">
			and merchantId = #{merchantid}
		</if>
		<if test="receivedate != null">
			and receiveDate = #{receivedate}
		</if>
		<if test="memberid != null">
			and memberId = #{memberid}
		</if>
		<if test="paymentdate != null">
			and paymentDate = #{paymentdate}
		</if>
		<if test="orderstatus != null">
			and orderStatus = #{orderstatus}
		</if>
		<if test="deliverdate != null">
			and deliverDate =#{deliverdate}
		</if>
		<if test="paymentfee != null">
			and paymentFee =#{paymentfee}
		</if>
		<if test="paymentname != null">
			and paymentName= #{paymentname}
		</if>
		<if test="posttype != null">
			and postType=#{posttype}
		</if>
		<if test="invoicename != null">
			and invoiceName=#{invoicename}
		</if>
		<if test="invoicecontent != null">
			and invoiceContent=#{invoicecontent}
		</if>
		<if test="invoicetype != null">
			and invoiceType =#{invoicetype}
		</if>
		<if test="startDate != null">
			and createDate >=#{startDate}
		</if>
		<if test="endDate != null">
			and createDate <=#{endDate}
		</if>
		<if test="modifydate != null">
			and modifyDate=#{modifydate}
		</if>
		<if test="createuser != null">
			and createUser=#{createuser}
		</if>
		<if test="modifieduser != null">
			and modifiedUser=#{modifieduser}
		</if>
		<if test="orderinfo != null">
			and orderInfo=#{orderinfo}
		</if>
		<if test="customermessage != null">
			and customerMessage =#{customermessage}
		</if>
		order by o.createDate desc limit #{offset},#{pageSize}
	</select>

	<select id="selectOrderInfo" resultMap="queryForListMap"
		parameterType="com.weshop.service.bean.Order">
		select o.*,p.*,(select weShopName from ws_merchant where
		merchantId=o.merchantId) as weshopname from ws_order o left join
		ws_order_product p on o.orderId=p.orderId where
		o.orderId=#{orderid,jdbcType=VARCHAR}


	</select>
     <select id="queryOrderCount" resultType="java.lang.Integer"
		parameterType="com.weshop.service.bean.Order">
		select count(*) from ws_order where orderStatus not in(7,8) and memberId=#{memberid,jdbcType=VARCHAR}
	</select>
	<select id="selectCountByStatus" resultMap="countResultMap"
		parameterType="java.lang.String">
		select count(*) as count,orderStatus from ws_order a left join
		ws_order_product b on a.orderId=b.orderId where
		memberId=#{orderid,jdbcType=VARCHAR} and b.isEevaluate=false group by
		orderStatus;
	</select>
	
	<select id="selectCountByMerchant" resultMap="countResultMap" parameterType="java.lang.String">
	select count(*) as count,orderStatus from ws_order a right join
		ws_order_product b on a.orderId=b.orderId where
		merchantId=#{merchantid,jdbcType=VARCHAR}  group by
		orderStatus;
	</select>

	<select id="selectPageCount" resultType="java.lang.Integer"
		parameterType="com.weshop.service.bean.Order">
		select count(*) from ws_order where 1=1
		<if test="orderid != null">
			and orderId=#{orderid}
		</if>
		<if test="merchantid != null">
			and merchantId = #{merchantid}
		</if>
		<if test="receivedate != null">
			and receiveDate = #{receivedate}
		</if>
		<if test="memberid != null">
			and memberId = #{memberid}
		</if>
		<if test="paymentdate != null">
			and paymentDate = #{paymentdate}
		</if>
		<if test="orderstatus != null">
			and orderStatus = #{orderstatus}
		</if>
		<if test="deliverdate != null">
			and deliverDate =#{deliverdate}
		</if>
		<if test="paymentfee != null">
			and paymentFee =#{paymentfee}
		</if>
		<if test="paymentname != null">
			and paymentName= #{paymentname}
		</if>
		<if test="posttype != null">
			and postType=#{posttype}
		</if>
		<if test="invoicename != null">
			and invoiceName=#{invoicename}
		</if>
		<if test="invoicecontent != null">
			and invoiceContent=#{invoicecontent}
		</if>
		<if test="invoicetype != null">
			and invoiceType =#{invoicetype}
		</if>
		<if test="startDate != null">
			and createDate >=#{startDate}
		</if>
		<if test="endDate != null">
			and createDate <=#{endDate}
		</if>
		<if test="modifydate != null">
			and modifyDate=#{modifydate}
		</if>
		<if test="createuser != null">
			and createUser=#{createuser}
		</if>
		<if test="modifieduser != null">
			and modifiedUser=#{modifieduser}
		</if>
		<if test="orderinfo != null">
			and orderInfo=#{orderinfo}
		</if>
		<if test="customermessage != null">
			and customerMessage =#{customermessage}
		</if>
	</select>



	<select id="selectList" resultMap="ResultMapWithBLOBs"
		parameterType="com.weshop.service.bean.Order">
		select
		<include refid="Base_Column_List" />
		,
		<include refid="Blob_Column_List" />
		from ws_order where 1=1
		<if test="merchantid != null">
			and merchantId = #{merchantid,jdbcType=VARCHAR}
		</if>
		<if test="receivedate != null">
			and receiveDate = #{receivedate,jdbcType=DATE}
		</if>
		<if test="memberid != null">
			and memberId = #{memberid,jdbcType=VARCHAR}
		</if>
		<if test="paymentdate != null">
			and paymentDate = #{paymentdate,jdbcType=TIMESTAMP}
		</if>
		<if test="orderstatus != null">
			and orderStatus = #{orderstatus,jdbcType=INTEGER}
		</if>
		<if test="deliverdate != null">
			and deliverDate = #{deliverdate,jdbcType=TIMESTAMP}
		</if>
		<if test="paymentfee != null">
			and paymentFee = #{paymentfee,jdbcType=DECIMAL}
		</if>
		<if test="paymentname != null">
			and paymentName = #{paymentname,jdbcType=VARCHAR}
		</if>
		<if test="posttype != null">
			and postType = #{posttype,jdbcType=VARCHAR}
		</if>
		<if test="invoicename != null">
			and invoiceName = #{invoicename,jdbcType=VARCHAR}
		</if>
		<if test="invoicecontent != null">
			and invoiceContent = #{invoicecontent,jdbcType=VARCHAR}
		</if>
		<if test="invoicetype != null">
			and invoiceType = #{invoicetype,jdbcType=BIT}
		</if>
		<if test="createdate != null">
			and createDate = #{createdate,jdbcType=DATE}
		</if>
		<if test="modifydate != null">
			and modifyDate = #{modifydate,jdbcType=DATE}
		</if>
		<if test="createuser != null">
			and createUser = #{createuser,jdbcType=VARCHAR}
		</if>
		<if test="modifieduser != null">
			and modifiedUser = #{modifieduser,jdbcType=VARCHAR}
		</if>
		<if test="customermessage != null">
			customerMessage =
			#{customermessage,jdbcType=LONGVARCHAR},
		</if>
	</select>
	<select id="selectById" resultMap="ResultMapWithBLOBs"
		parameterType="java.lang.String">
		select
		<include refid="Base_Column_List" />
		,
		<include refid="Blob_Column_List" />
		from ws_order
		where orderId = #{orderid,jdbcType=VARCHAR}
	</select>
	<delete id="deleteById" parameterType="java.lang.String">
		delete from ws_order
		where
		orderId = #{orderid,jdbcType=VARCHAR}
	</delete>
	<insert id="insert" parameterType="com.weshop.service.bean.Order">
		insert into ws_order (orderId,
		merchantId, receiveDate,
		memberId, paymentDate, orderStatus,
		deliverDate, paymentFee, paymentName,
		postType, invoiceName,
		invoiceContent,
		invoiceType, createDate, modifyDate,
		createUser,
		modifiedUser, customerMessage
		)
		values (#{orderid,jdbcType=VARCHAR},
		#{merchantid,jdbcType=VARCHAR},
		#{receivedate,jdbcType=TIMESTAMP},
		#{memberid,jdbcType=VARCHAR}, #{paymentdate,jdbcType=TIMESTAMP},
		#{orderstatus,jdbcType=INTEGER},
		#{deliverdate,jdbcType=TIMESTAMP},
		#{paymentfee,jdbcType=DECIMAL},
		#{paymentname,jdbcType=VARCHAR},
		#{posttype,jdbcType=VARCHAR}, #{invoicename,jdbcType=VARCHAR},
		#{invoicecontent,jdbcType=VARCHAR},
		#{invoicetype,jdbcType=BIT},
		#{createdate,jdbcType=TIMESTAMP},
		#{modifydate,jdbcType=TIMESTAMP},
		#{createuser,jdbcType=VARCHAR}, #{modifieduser,jdbcType=VARCHAR},
		#{customermessage,jdbcType=LONGVARCHAR}
		)
	</insert>
	<insert id="insertSelective" parameterType="com.weshop.service.bean.Order">
		insert into ws_order
		<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="orderid != null">
				orderId,
			</if>
			<if test="merchantid != null">
				merchantId,
			</if>
			<if test="receivedate != null">
				receiveDate,
			</if>
			<if test="memberid != null">
				memberId,
			</if>
			<if test="paymentdate != null">
				paymentDate,
			</if>
			<if test="orderstatus != null">
				orderStatus,
			</if>
			<if test="deliverdate != null">
				deliverDate,
			</if>
			<if test="paymentfee != null">
				paymentFee,
			</if>
			<if test="paymentname != null">
				paymentName,
			</if>
			<if test="posttype != null">
				postType,
			</if>
			<if test="invoicename != null">
				invoiceName,
			</if>
			<if test="invoicecontent != null">
				invoiceContent,
			</if>
			<if test="invoicetype != null">
				invoiceType,
			</if>
			<if test="createdate != null">
				createDate,
			</if>
			<if test="modifydate != null">
				modifyDate,
			</if>
			<if test="createuser != null">
				createUser,
			</if>
			<if test="modifieduser != null">
				modifiedUser,
			</if>
			<if test="customermessage != null">
				customerMessage,
			</if>
		</trim>
		<trim prefix="values (" suffix=")" suffixOverrides=",">
			<if test="orderid != null">
				#{orderid,jdbcType=VARCHAR},
			</if>
			<if test="merchantid != null">
				#{merchantid,jdbcType=VARCHAR},
			</if>
			<if test="receivedate != null">
				#{receivedate,jdbcType=TIMESTAMP},
			</if>
			<if test="memberid != null">
				#{memberid,jdbcType=VARCHAR},
			</if>
			<if test="paymentdate != null">
				#{paymentdate,jdbcType=TIMESTAMP},
			</if>
			<if test="orderstatus != null">
				#{orderstatus,jdbcType=INTEGER},
			</if>
			<if test="deliverdate != null">
				#{deliverdate,jdbcType=TIMESTAMP},
			</if>
			<if test="paymentfee != null">
				#{paymentfee,jdbcType=DECIMAL},
			</if>
			<if test="paymentname != null">
				#{paymentname,jdbcType=VARCHAR},
			</if>
			<if test="posttype != null">
				#{posttype,jdbcType=VARCHAR},
			</if>
			<if test="invoicename != null">
				#{invoicename,jdbcType=VARCHAR},
			</if>
			<if test="invoicecontent != null">
				#{invoicecontent,jdbcType=VARCHAR},
			</if>
			<if test="invoicetype != null">
				#{invoicetype,jdbcType=BIT},
			</if>
			<if test="createdate != null">
				#{createdate,jdbcType=TIMESTAMP},
			</if>
			<if test="modifydate != null">
				#{modifydate,jdbcType=TIMESTAMP},
			</if>
			<if test="createuser != null">
				#{createuser,jdbcType=VARCHAR},
			</if>
			<if test="modifieduser != null">
				#{modifieduser,jdbcType=VARCHAR},
			</if>
			<if test="customermessage != null">
				#{customermessage,jdbcType=LONGVARCHAR},
			</if>
		</trim>
	</insert>
	<update id="updateById" parameterType="com.weshop.service.bean.Order">
		update ws_order
		<set>
			<if test="orderinfo != null">
				orderInfo = #{orderinfo,jdbcType=VARCHAR},
			</if>
			<if test="merchantid != null">
				merchantId = #{merchantid,jdbcType=VARCHAR},
			</if>
			<if test="receivedate != null">
				receiveDate = #{receivedate,jdbcType=TIMESTAMP},
			</if>
			<if test="memberid != null">
				memberId = #{memberid,jdbcType=VARCHAR},
			</if>
			<if test="paymentdate != null">
				paymentDate = #{paymentdate,jdbcType=TIMESTAMP},
			</if>
			<if test="orderstatus != null">
				orderStatus = #{orderstatus,jdbcType=INTEGER},
			</if>
			<if test="deliverdate != null">
				deliverDate = #{deliverdate,jdbcType=TIMESTAMP},
			</if>
			<if test="paymentfee != null">
				paymentFee = #{paymentfee,jdbcType=DECIMAL},
			</if>
			<if test="paymentname != null">
				paymentName = #{paymentname,jdbcType=VARCHAR},
			</if>
			<if test="posttype != null">
				postType = #{posttype,jdbcType=VARCHAR},
			</if>
			<if test="invoicename != null">
				invoiceName = #{invoicename,jdbcType=VARCHAR},
			</if>
			<if test="invoicecontent != null">
				invoiceContent = #{invoicecontent,jdbcType=VARCHAR},
			</if>
			<if test="invoicetype != null">
				invoiceType = #{invoicetype,jdbcType=BIT},
			</if>
			<if test="createdate != null">
				createDate = #{createdate,jdbcType=TIMESTAMP},
			</if>
			<if test="modifydate != null">
				modifyDate = #{modifydate,jdbcType=TIMESTAMP},
			</if>
			<if test="createuser != null">
				createUser = #{createuser,jdbcType=VARCHAR},
			</if>
			<if test="modifieduser != null">
				modifiedUser = #{modifieduser,jdbcType=VARCHAR},
			</if>
			<if test="customermessage != null">
				customerMessage =
				#{customermessage,jdbcType=LONGVARCHAR},
			</if>
		</set>
		where orderId = #{orderid,jdbcType=VARCHAR}
	</update>
	<update id="updateByIdWithBLOBs" parameterType="com.weshop.service.bean.Order">
		update ws_order
		set merchantId = #{merchantid,jdbcType=VARCHAR},
		receiveDate =
		#{receivedate,jdbcType=TIMESTAMP},
		memberId =
		#{memberid,jdbcType=VARCHAR},
		paymentDate =
		#{paymentdate,jdbcType=TIMESTAMP},
		orderStatus =
		#{orderstatus,jdbcType=INTEGER},
		deliverDate =
		#{deliverdate,jdbcType=TIMESTAMP},
		paymentFee =
		#{paymentfee,jdbcType=DECIMAL},
		paymentName =
		#{paymentname,jdbcType=VARCHAR},
		postType =
		#{posttype,jdbcType=VARCHAR},
		invoiceName =
		#{invoicename,jdbcType=VARCHAR},
		invoiceContent =
		#{invoicecontent,jdbcType=VARCHAR},
		invoiceType =
		#{invoicetype,jdbcType=BIT},
		createDate =
		#{createdate,jdbcType=TIMESTAMP},
		modifyDate =
		#{modifydate,jdbcType=TIMESTAMP},
		createUser =
		#{createuser,jdbcType=VARCHAR},
		modifiedUser =
		#{modifieduser,jdbcType=VARCHAR},
		customerMessage =
		#{customermessage,jdbcType=LONGVARCHAR}
		where orderId =
		#{orderid,jdbcType=VARCHAR}
	</update>
	<!--用户已完成的订单 -->
	<select id="buyList" resultType="com.weshop.service.bean.Order"
		parameterType="String">
		SELECT * FROM ws_order WHERE memberId=#{memberId}
		AND orderStatus='8'
	</select>
	
	<select id="selectCancelList" parameterType="com.weshop.service.bean.Order" resultType="com.weshop.service.bean.Order">
	 select t.id from ws_order t where 1=1 and orderStatus=0  and createDate <= #{startDate} 
	</select>
	
 <update id="updateOrderByMap" parameterType="Map">
  	update ws_order set orderStatus = #{orderStatus}
  	where orderId = #{orderId}
  </update>
</mapper>

主要看里面的Sql用法管理查询和嵌套查询

mysql mybatis生成工具
11-08
mysql mybatis自动生成工具； 通过修改xml文件中的数据库连接，即可自动生成文件
网上书店 springboot mybatis mysql ssmk框架
04-12
网上书店 springboot mybatis mysql ssmk框架+sql脚本 网上书店 springboot mybatis mysql ssmk框架+sql脚本 网上书店 springboot mybatis mysql ssmk框架+sql脚本 网上书店 springboot mybatis mysql ssmk框架+sql...
MyBatis与MySQL交互
weixin_33895695的博客
04-25 560
MyBatis是我接触到的第一个框架，下面谈一谈我第一次使用MyBatis时的感悟。 首先是一些准备工作 下载相关的jar包。到GitHub上就行，上面有全面和完整的jar文件 在eclipse上安装MyBatis Generator插件（一款高效的ORM框架中的代码生成插件） 创建一个mybatis-config.xml文件，...
MYSQL mybatis
dingqilei5466的博客
02-27 185
mysql 1 每个语句的结束记得加分号; 2where条件里再做if分支 　　　　SELECT *FROM `table`WHERE IF( `parentID` is null, `plan_id` <10, `plan_id` >500 ) 　　还可以再嵌套使用 　　WHERE IF(device_id is null , IF(globle_n...
Mybatis操作MySQL
a791363509的博客
05-19 381
进行增删改查操作 只需修改接口文件、Mapper配置文件以及测试类文件 接口文件： package com.hzj.dao; import com.hzj.pojo.Users; import java.util.List; //编写接口 public interface UserDao { //查询全部用户 List<Users> getUsersList(); //根据ID查询用户 Users getUserID(int id);.
mybatis mysql bit_ibit-mybatis
weixin_42813171的博客
01-18 309
ibit-mybatis 2.x 介绍概述ibit-mybatis 是一个 Mybatis 的增强工具，在 Mybatis 的基础上增加了新的特性与功能，志在简化开发流程、提高开发效率。特性无侵入，引入”ibit-mybatis”对现有工程不会产生影响。无 xml 配置，基于注解的方式实现灵活的CRUD(增、删、改、查)操作，Mapper，支持常用的单表CRUD操作，更有强大的SQL构造器(sql...
mybatisTest_mybatismysql多线程_MYSQL_
10-03
标题 "mybatisTest_mybatismysql多线程_MYSQL_" 暗示了这是一个关于使用MyBatis框架在MySQL数据库上进行多线程性能测试的项目。MyBatis是一个流行的持久层框架，它允许开发者将SQL语句与Java代码直接关联，提供了更...
SpringBoot整合MyBatis MySql demo
04-08
本教程将详细讲解如何利用SpringBoot整合MyBatis以及MySQL数据库，实现一个简单的demo。 首先，SpringBoot是Spring框架的一个模块，它提供了“开箱即用”的功能，减少了传统Spring应用的复杂性。SpringBoot的核心...
软件开发 JAVA SpringBoot MyBatis MySQL 旅游网站 - 毕业设计
08-23
JAVA SpringBoot MyBatis MySQL 旅游网站 - 毕业设计： Spring Boot 毕业设计项目 管理系统： url：http://localhost:8080/managerLoginPage user：admin password：123 用户门户网站： url：...
基于SSM(spring springMVC mybatis mysql)框架的hrm人事管理系统后台实例
12-04
基于现如今流行的SSM(spring springMVC mybatis mysql)框架的hrm人事管理系统后台实例 sql代码与详解：http://blog.csdn.net/csdn___lyy/article/details/72887390
MyBatis实现Mysql数据库分库分表操作和总结（推荐）
08-29
主要介绍了MyBatis实现Mysql数据库分库分表操作和总结,需要的朋友可以参考下
使用Mybatis连接Mysql数据库
M11031211的博客
12-10 2015
MyBatis是支持普通SQL查询，存储过程和高级映射的优秀持久层框架。MyBatis消除了几乎所有的JDBC代码和参数的手工设置以及对结果集的检索封装。MyBatis可以使用简单的XML格式或注解用于配置和原始映射，将接口和Java的POJO（Plain Old Java Objects，普通的Java对象）映射成数据库中的记录。优点：1、简单易学：本身就很小且简单。
mybatis mysql bit_MyBatis学习与使用（一）
weixin_31943449的博客
01-18 954
写在前面——用 MyBatis 也做过几个项目了，但是一直没有很深入的去理解这个框架，最近决定从头开始学习和整理MyBatis。之前开发的项目并不是我先创建的，等我介入的时候发现他们已经稍稍封装了一下对MyBatis的使用，反正不是那种官方文档上代码的样子，所以我之前用得就糊里糊涂的，今天就从官方文档中展示的用法开始学习。正文如下——Mybatis核心类1. SqlSessionFactory用来...
MyBatis实现传输MySQL数据
yueyue763184的博客
05-13 573
MyBatis使用简单的XML或注解用于配置和原始映射，将接口或者Java持久层对象映射成数据库的记录。 下面举个例子： 1.首先来配置一下log4j.properties日志信息文件 # Global logging configuration log4j.rootLogger=ERROR, stdout # MyBatis logging configuration... log4j.logger.com.mybatis.mapper=DEBUG # Console output..
Mybatis操作MySql数据库
weixin_42291877的博客
11-27 320
1. 流程图 2.使用Mybati实现增删改查 新建maven工程，pom.xml配置文件如下 父工程 <?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://mav
mybatis+mysql
Goldstine的博客
06-29 939
（一）mysql的配置： drvername：com.mysql.jdbc.Driver url:jdbc:mysql://localhost:3360/数据库名 mysql user：XXXX mysql password：XXXX (二)数据库连接： Reader reader=Resources.getResourceAsReader("conf.xml"); SqlSessi...
MySQL+Mybatis
m0_59347746的博客
07-20 2875
MySQL主要分为Server层和引擎层，Server层主要包括连接器、查询缓存、分析器、优化器、执行器，同时还有一个日志模块（binlog），这个日志模块所有执行引擎都可以共用，redolog只有InnoDB有。引擎层是插件式的，目前主要包括，MyISAM,InnoDB,Memory等。查询语句的执行流程如下权限校验（如果命中缓存）--->查询缓存--->分析器--->优化器--->权限校验--->执行器--->引擎更新语句执行流程如下分析器---->权限校验---->执行器--->引擎---re。...
MySql&&Mybatis
最新发布
szm0225的博客
03-19 1031
SQL语句根据其功能被分为四大类：DDL、DML、DQL、DCL。
mysql.mybatis动态sql_MyBatis 动态SQL
weixin_32104797的博客
02-18 97
动态SQl是MyBatis的强大特性之一，可以完成对SQL语句的动态组装。比如说传入一个User对象，要根据这个User中的数据查询用户的完整信息：如果User对象中只有name属性有值，sql语句是：select * from user_tb where name=#{name}如果User对象中只有tel属性有值，sql语句是：select * from user_tb where tel=...
初学者入门指南：Maven与SpringMVC Mybatis Mysql整合实例
标题中提到的"Maven SpringMVC Mybatis Mysql"是Java开发中常见的技术栈，尤其在Web应用开发中广泛应用。Maven是一个项目管理工具，SpringMVC是Spring框架中用于构建Web应用程序的模型-视图-控制器（MVC）框架，...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值