# Set root category priority to INFO and its only appender to CONSOLE.
#log4j.rootCategory=INFO, CONSOLE debug info warn error fatal
log4j.rootCategory=debug, CONSOLE, LOGFILE
# Set the enterprise logger category to FATAL and its only appender to CONSOLE.
log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
# CONSOLE is set to be a ConsoleAppender using a PatternLayout.
log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601}%-6r [%15.15t]%-5p %30.30c %x -%m\n
# LOGFILE is set to be a File appender using a PatternLayout.
log4j.appender.LOGFILE=org.apache.log4j.FileAppender
log4j.appender.LOGFILE.File=d:\axis.log
log4j.appender.LOGFILE.Append=true
log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601}%-6r [%15.15t]%-5p %30.30c %x -%m\n
/**
* 保存用户
* @param user
*/@Insert("insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday})")voidsaveUser(User user);/**
* 更新用户
* @param user
*/@Update("update user set username=#{username},sex=#{sex},birthday=#{birthday},address=#{address} where id=#{id}")voidupdateUser(User user);/**
* 删除用户
* @param userId
*/@Delete("delete from user where id=#{id} ")voiddeleteUser(Integer userId);/**
* 根据id查询用户
* @param userId
* @return
*/@Select("select * from user where id=#{id} ")
User findById(Integer userId);/**
* 根据用户名称模糊查询
* @param username
* @return
*///@Select("select * from user where username like #{username} ")@Select("select * from user where username like '%${value}%' ")
List<User>findUserByName(String username);/**
* 查询总用户数量
* @return
*/@Select("select count(*) from user ")intfindTotalUser();