package com.mandi.system.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import org.apache.ibatis.annotations.Delete;
|
import org.apache.ibatis.annotations.Insert;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.apache.ibatis.annotations.Update;
|
|
import com.mandi.system.persist.User;
|
|
public interface FduserMapper {
|
|
@Select("select * from fd_user where id=#{id}")
|
public User getbyId(String id);
|
@Select("select * from fd_user where username=#{username} ")
|
public User getbyUname(String username);
|
@Delete("delete from fd_user where id=#{id}")
|
public int delbyId(String id);
|
@Delete("delete from fd_user where username=#{username} ")
|
public int delbyUname(String username);
|
@Insert("insert into fd_user (id,username,password,companyNo,phone,name,sex,state,lastlogin,utype) "
|
+ "values (#{id},#{username},#{password},#{companyNo},#{phone},#{name},#{sex},#{state},#{lastlogin},#{utype}) ")
|
public int insert(User u);
|
@Update("update fd_user set username=#{username},password=#{password},companyNo=#{companyNo},"
|
+ "phone=#{phone},name=#{name},sex=#{sex},state=#{state},lastlogin=#{lastlogin},utype=#{utype} where id=#{id}")
|
public int updatebyId(User u);
|
@Update("update fd_user set state=#{state} where id=#{id}")
|
public int valid(@Param("id")String id,@Param("state")boolean state);
|
|
public int getcount(Map<String, Object> mp);
|
|
public List<User> getList(Map<String, Object> mp);
|
|
public List<Map<String, Object>> getMList(Map<String, Object> mp);
|
|
|
}
|