常用配置文件
1. jdbc.properties
driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF-8 username=root password=root
2. log4j.properties
#log4j日志级别如下: #A:off 最高等级,用于关闭所有日志记录。 #B:fatal 指出每个严重的错误事件将会导致应用程序的退出。 #C:error 指出虽然发生错误事件,但仍然不影响系统的继续运行。 #D:warn 表明会出现潜在的错误情形。 #E:info 一般和在粗粒度级别上,强调应用程序的运行全程。 #F:debug 一般用于细粒度级别上,对调试应用程序非常有帮助。 #G:all 最低等级,用于打开所有日志记录。 #但log4j只建议使用4个级别,优先级从高到低分别是: #error>warn>info>debug log4j.rootLogger =debug,systemOut #输出到控制台(systemOut) log4j.appender.systemOut = org.apache.log4j.ConsoleAppender log4j.appender.systemOut.layout = org.apache.log4j.PatternLayout log4j.appender.systemOut.layout.ConversionPattern = [%-5p][%-22d{yyyy/MM/dd HH:mm:ssS}][%l]%n%m%n log4j.appender.systemOut.Target = System.out #输出到文件(logFile) log4j.appender.logFile = org.apache.log4j.FileAppender log4j.appender.logFile.layout = org.apache.log4j.PatternLayout log4j.appender.logFile.layout.ConversionPattern = [%-5p][%-22d{yyyy/MM/dd HH:mm:ssS}][%l]%n%m%n log4j.appender.logFile.File = E:/log/log4j.log log4j.appender.logFile.Encoding = UTF-8 #将日志输记录到MySQL数据库 #log4j.appender.logDB = org.apache.log4j.jdbc.JDBCAppender #log4j.appender.logDB.layout = org.apache.log4j.PatternLayout #log4j.appender.logDB.Driver = com.mysql.jdbc.Driver #log4j.appender.logDB.URL = jdbc:mysql://localhost:3306/log4j?characterEncoding=utf-8 #log4j.appender.logDB.User = root #log4j.appender.logDB.Password = root #log4j.appender.logDB.Sql = INSERT INTO t_log4j(project_name,create_date,level,category,file_name,thread_name,line,all_category,message)values('mybatis','%d{yyyy-MM-ddHH:mm:ss}','%p','%c','%F','%t','%L','%l','%m') #若出现问题:Log4j: ERROR Failed to load driver, java.lang.ClassNotFoundException: com.mysql.jdbc.Driver #解决方法:将log4j.properties 中每行后面的空格都删除就解决了.
3. Mybatis相关
(1) mybatis-config.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> <properties resource="db.properties"/> <settings> <setting name="mapUnderscoreToCamelCase" value="true"/> <setting name="logImpl" value="LOG4J"/> settings> <typeAliases> <package name="com.wszpan.pojo"/> typeAliases> <environments default="development"> <environment id="development"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="${driver}"/> <property name="url" value="${url}"/> <property name="username" value="${password}"/> <property name="password" value="${username}"/> dataSource> environment> environments> <mappers> <mapper class="com.wszpan.dao.BlogMapper"/> mappers> configuration>
(2) BlogMapper.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="com.wszpan.dao.BlogMapper"> <insert id="addBlog" parameterType="Blog"> insert into blog(id,title,author,views,create_time) values (#{id},#{title},#{author},#{views},#{createTime}) insert> mapper>
4.ehcache.xml(自定义缓存文件)
<?xml version="1.0" encoding="UTF-8"?> <ehcache xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://ehcache.org/ehcache.xsd" updateCheck="false"> <diskStore path="./tmpdir/Tmp_EhCache"/> <defaultCache eternal="false" maxElementsInMemory="10000" overflowToDisk="false" diskPersistent="false" timeToIdleSeconds="1800" timeToLiveSeconds="259200" memoryStoreEvictionPolicy="LRU"/> <cache name="cloud_user" eternal="false" maxElementsInMemory="5000" overflowToDisk="false" diskPersistent="false" timeToIdleSeconds="1800" timeToLiveSeconds="1800" memoryStoreEvictionPolicy="LRU"/> ehcache>