• Home
• com.ajaxjs
• ajaxjs-cms
• 1.0.3
• source code
• Attachment_pictureDao.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

com.ajaxjs.cms.app.attachment.Attachment_pictureDao Maven / Gradle / Ivy

package com.ajaxjs.cms.app.attachment;

import java.util.List;

import com.ajaxjs.framework.DataDict;
import com.ajaxjs.framework.IBaseDao;
import com.ajaxjs.orm.annotation.Delete;
import com.ajaxjs.orm.annotation.Select;
import com.ajaxjs.orm.annotation.TableName;
import com.ajaxjs.orm.annotation.Update;

@TableName(value = "attachment_picture", beanClass = Attachment_picture.class)
public interface Attachment_pictureDao extends IBaseDao {
	@Select("SElECT * FROM ${tableName} WHERE owner = ?")
	public List findByOwner(Long owner);

	@Delete("DELETE FROM ${tableName} WHERE `owner` = ?")
	boolean deleteByOwnerId(Long ownerUid);

	@Update("UPDATE ${tableName} SET `index` = ? WHERE id = ?")
	public int saveImgIndex(int index, Long imgId);

	@Select("SElECT * FROM ${tableName} WHERE owner = ? AND catelog = " + DataDict.PIC_in_GALLERY)
	public List findAttachmentPictureByOwner(Long owner);
}