Mapper基础设置

Mapper步骤

文件目录

• db.properties、log4j.properties、sqlMapConfig.xml
• com.entity(实体类–数据库表)、com.factory(Utils–DaoUtlis)、com.mapper(接口与解析文件名称一致)、com.yh(测试类)

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

###\u5C06\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u63A7\u5236\u53F0###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %m %n
###\u628A\u65E5\u5FD7\u4FE1\u606F\u8F93\u51FA\u5230\u6587\u4EF6\u4E2D###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=sysInfo.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %m %n
###\u8BBE\u7F6E\u65E5\u5FD7\u7684\u4F18\u5148\u7EA7\u522B###
log4j.rootLogger=debug,stdout,file

<?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>

<properties resource="db.properties">
</properties>


<settings>
	<setting name="logImpl" value="LOG4J"/>
</settings>


<typeAliases>
	<!-- <typeAlias type="com.entity.User" alias="user"/> -->
	
	<!-- 批量定义别名    别名就是类名 -->
	<package name="com.entity"/>
</typeAliases>



<environments default="development">
	<environment id="development">
		<transactionManager type="JDBC"/>
		<dataSource type="POOLED">
			<property name="driver" value="${jdbc.driver}"/>
			<property name="url"