src/com/rain/dao/UserDao.java

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

package com.rain.dao;

import static com.rain.util.common.Constants.USERTABLE;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;

import com.rain.dao.provider.UserDynaSqlProvider;
import com.rain.domain.User;

public interface UserDao {

	@Select("select * from "+USERTABLE+" ")
	List<User> get_List();
	@Select("select * from "+USERTABLE+"  where loginname like CONCAT('%',#{content},'%')")
	List<User> get_LikeList(String content);

	@Select("select * from "+USERTABLE+"  where loginname = #{loginname} AND password = #{password}")
	User get_login(@Param("loginname") String loginname,
			@Param("password") String password);
	
	@SelectProvider(type=UserDynaSqlProvider.class,method="insert_Notice")
	void insert_Info(User employee);
	
	@Select("select * from "+USERTABLE+" where id = #{id}")
	User get_Info(Integer id);

	@SelectProvider(type=UserDynaSqlProvider.class,method="update_Notice")
	void update_Info(User employee);
	// 根据id删除部门
	@Delete(" delete from "+USERTABLE+" where id = #{id} ")
	void delete_Info(Integer id);

}