# 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
<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--nameSpace确定该方法在哪个dao接口--><mapper namespace="cn.lzc.mapper.UserMapper"><resultMap id="userMap" type="cn.lzc.domain.User"><id property="id" column="id"></id><result property="username" column="username"></result><result property="birthday" column="birthday"></result><result property="sex" column="sex"></result><result property="address" column="address"></result></resultMap><!-- 抽取重复的sql语句,不要加分号,在下面的sql语句中用
<include refid="default"></include>进行引入
--><sql id="default">
select * from user
</sql><!-- result Type表示要把数据封装到哪--><select id="findAll" resultType="user"><include refid="default"></include><!--select * from user--></select><insert id="saveUser" parameterType="cn.lzc.domain.User"><!-- selectKey 新增时来获取id ,keyProperty用来对应实体类,keyColumn用来对应数据库,resultType结果集,
order执行顺序--><selectKey keyProperty="id" keyColumn="id" resultType="int" order="AFTER">
select last_insert_id()</selectKey>
insert into user(username,birthday,sex,address)values(#{username},#{birthday},#{sex},#{address})</insert><update id="updateUser" parameterType="cn.lzc.domain.User">
update user set username=#{username},birthday=#{birthday},sex=#{sex},address=#{address}</update><delete id="deleteUser" parameterType="java.lang.Integer">
delete from user where id=#{id}</delete><select id="findById" parameterType="java.lang.Integer" resultType="cn.lzc.domain.User">
select * from user where id=#{id}</select><select id="findByName" parameterType="java.lang.String" resultType="cn.lzc.domain.User"><!-- 在进行模糊查询时,查询语句没有写%,则在测试时需要加上%--><!--select * from user where username like #{%name%}-->
select * from user where username like '%${value}%'</select><select id="findTotal" resultType="int">
select count(id) from user
</select><select id="findUserByQueryVo" parameterType="cn.lzc.domain.QueryVo" resultType="cn.lzc.domain.User">
select * from user where username like #{user.username}</select><!--<select id="findByCondition" resultMap="userMap" parameterType="user">
select * from user where 1=1<if test="username!=null">
and username=#{username}</if><if test="sex!=null">
and sex=#{sex}</if></select>--><select id="findByCondition" resultMap="userMap" parameterType="user">
select * from user
<where><if test="username!=null">
and username=#{username}</if><if test="sex!=null">
and sex=#{sex}</if></where></select><select id="findUserInIds" resultMap="userMap" parameterType="queryvo">
select * from user
<where><if test="ids!=null and ids.size>0"><foreach collection="ids" open="and id in (" close=")" item="uid" separator=",">
#{uid}</foreach></if></where></select></mapper>