mysql查询|Mybatis查询

2、树形结构的实现其实很简单的，建议你看下ztree的官方api，你只需要按照数据结构递归查询出父子节点的数据即可

3、mybatis是java中实现的方式了，至于你想怎么优化，最后都是递归查询父子节点的数据

create table driver_order (

id int(11) unsigned NOT NULL AUTO_INCREMENT,

area_start varchar(200),

area_end varchar(200),

order_number varchar(200),

create_user varchar(200),

primary key (id)

)

创建触发器：

DELIMITER $$

CREATE TRIGGER seq_driver_order_number BEFORE INSERT ON driver_order

FOR each ROW

BEGIN

DECLARE seq_type INT(10)

SET seq_type = getUserNo(NEW.create_user)

SET NEW.order_number = getNextCommSequence("motor", seq_type)

END$$

DELIMITER

以下是mybatis *** 作触发器的配置方法：

<insert id="insertOrder" parameterType="DriverOrder">

<selectKey keyProperty="id,orderNumber" keyColumn="ID,ORDER_NUMBER" order="AFTER" resultType="java.util.Map">

SELECT ID,ORDER_NUMBER FROM DRIVER_ORDER where ID = last_insert_id()

</selectKey>

INSERT INTO

DRIVER_ORDER(ID,ORDER_NUMBER,AREA_START,AREA_END,CREATE_USER,CREATE_TIME)

VALUES

(#{id},

#{orderNumber,jdbcType=VARCHAR},

#{areaStart,jdbcType=VARCHAR},

#{areaEnd,jdbcType=VARCHAR},

#{createUser,jdbcType=VARCHAR},

now())

</insert>