Technology Share

先定义需要查询到的字段名称，在写级联查询语句 CUSTOMER_ID, CUSTOMER_NAME, CUSTOMER_PHONE_NUM, CUSTOMER_EMAIL, DEPART_ID, TEAM_ID, DESK_NUM, STATUS, TAG, TEAM_NAME, DEPART_NAME select from

mybatis用序列当作id并随数据一起插入到表中的方法为： 就是在普通的insert语句前加一个selecKey>标签 　　　 select CUSTOMER_ID.nextVal from dual 　　 insert into CUSTOMER_INFO_T ...... )