build/classes/com/yh/mapper/OrderMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.yh.mapper.OrderMapper">

	<select id="selAll" resultType="order">
		select * from t_order
	</select>
	



	<insert id="insert" parameterType="order">
		<selectKey keyProperty="id" order="AFTER" resultType="int">
			select LAST_INSERT_ID()
		</selectKey>
		insert into t_order (id,ordernum,productid,peoplecount,orderdesc,paytype,orderstatus,memberid) 
			values (#{id},#{ordernum},#{productid},#{peoplecount},#{orderdesc},#{paytype},#{orderstatus},#{memberid})
	</insert>

	<insert id="insertPa" parameterType="passenger">
		<selectKey keyProperty="id" order="AFTER" resultType="int">
			select LAST_INSERT_ID()
		</selectKey>
		insert into t_passenger (id,name,sex,phonenum,credentialstype,credentialsnum,travellertype)
			values (#{id},#{name},#{sex},#{phonenum},#{credentialstype},#{credentialsnum},#{travellertype})
	</insert>
	
	<insert id="insertOP" parameterType="map">
		insert into t_order_passenger values (null,#{oid},#{pid})
	</insert>
	
	
	
	<delete id="delete" parameterType="int">
		delete from t_order where id=#{id}
	</delete>

	
	<select id="findPro" resultType="product">
		select * from t_product
	</select>
	<select id="findMe" resultType="member">
		select * from t_member
	</select>
	


	<resultMap type="order" id="orderResultMap">
		<id column="oid" property="id"/>
		<result column="orderNum" property="ordernum"/>
		<result column="orderTime" property="ordertime"/>
		<result column="peopleCount" property="peoplecount"/>
		
		<association property="product" javaType="product">
			<id column="pid" property="id"/>
			<result column="cityName" property="cityname"/>
			<result column="DepartureTime" property="departuretime"/>