| | |
| | | s.setCodeUrl(softcode.getCodeUrl()); |
| | | s.setCodeName(softcode.getCodeName()); |
| | | s.setCreateTime(new Date()); |
| | | softcodeList.add(s); |
| | | } |
| | | codeMapper.insertBatchSomeColumn(softcodeList); |
| | | return new Response().set(1,true,"批量添加源码包"); |
| | |
| | | select * from tb_software where file_url=#{fileUrl} and lock_flag = #{lockFlag} |
| | | </select> |
| | | <select id="getFileNameByOwnerWithCode" resultType="com.whyc.pojo.Software"> |
| | | SELECT distinct file_name,based_version,owner |
| | | SELECT distinct w.file_name,based_version,owner |
| | | FROM tb_software w |
| | | LEFT JOINtb_softcode c ON w.file_name = c.file_name |
| | | WHERE c.file_name IS NULL; |
| | | LEFT JOIN tb_softcode c ON w.file_name = c.file_name |
| | | WHERE c.file_name IS NULL |
| | | and w.owner = #{owner}; |
| | | </select> |
| | | </mapper> |