MyBatis的基本简单使用（适合刚入门）

步骤

1.在pom.xml中导入坐标

• mybatis
• mysql

2.创建MyBatis的配置文件SqlMapConfig.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">

• 配置环境(其中注释掉的地方可以写在单独的配置文件里jdbcConfig.property中)

<configuration>
   <!-- 配置环境-->
   <environments default="mysql">
       <environment id="mysql">
           <transactionManager type="JDBC"></transactionManager>
           <dataSource type="POOLED">
            <!--  <property name="driver" value="com.mysql.jdbc.Driver"/>
               <property name="url" value="jdbc:mysql://localhost:3306/mybatis"/>
               <property name="username" value="root"/>
               <property name="password" value="123456"/>     -->
           </dataSource>
       </environment>
   </environments>

</configuration>

• jdbcConfig.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis
jdbc.username=root
jdbc.password=123456

• 顺便把日志配置文件log4j.properties也cv到resources中(放在最后)
• 在中指定映射的配置文件，映射配置文件指的是每个dao独立的配置文件

<mappers>//resource是配置文件的方法，class是注解的方法，cn.imust.dao.UserDaoImpl
        <mapper resource="cn/imust/dao/UserDaoImpl.xml"/>
        <package>//注解方法，属性为name=“cn.imust.dao”
    </mappers>

3.创建Dao的接口映射文件UserDaoImpl.xml(resources目录文件下与Dao路径相同)

• 导入mapper文件头

<?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="Dao包路径">

<mapper/>

• 建立表之间的关系在resultMap标签中
  1.id代表主键
  其他的属性用result
  2.column属性是别名
  property属性是数据库表的字段名
  3.查询用select(parameterType是参数类型，resultMap是返回集合类型，resultType是对象类型)
  增删改用update
  log4j.properties

# 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