Mybatis-初学

一.环境的搭建
1.导入mybatis.jar
2.写核心配置文件Configuration.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration    PUBLIC "-//mybatis.org//DTD Config 3.0//EN"    "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>  <settings>    <setting name="useGeneratedKeys" value="false"/>    <setting name="useColumnLabel" value="true"/>  </settings>  <environments default="development">    <environment id="development">      <transactionManager type="JDBC">        <property name="" value=""/>      </transactionManager>      <dataSource type="UNPOOLED">        <property name="driver" value="com.mysql.jdbc.Driver"/>        <property name="url" value="jdbc:mysql://localhost:3306/people"/>        <property name="username" value="root"/>        <property name="password" value="password"/>      </dataSource>    </environment>  </environments>  <mappers>    <mapper resource="cn/wuyun/cw/User.xml"/>  </mappers></configuration>

3.编写副本配置文件 User.xml

<?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"><mapper namespace="User">  <resultMap type="cn.csin.bean.People" id="User">    <id column="id" jdbcType="INTEGER" property="id"/>    <result column="name" jdbcType="VARCHAR" property="name"/>    <result column="age" jdbcType="INTEGER" property="age"/>  </resultMap>  <select id="findByName" parameterType="String" resultMap="User">    SELECT * FROM people WHERE name = #{_parameter}  </select>  <delete id="deleteById" parameterType="int"  >    DELETE FROM people WHERE id=#{_parameter}  </delete></mapper>

4.导入log4j.jar
5.编写log4.xml文件

log4j.rootLogger=DEBUG,Console#配置输出的级别 debug info  warn error 级别依次增高log4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.org.apache=INFO