org.mybatis
mybatis
${mybatis.version}
org.mybatis
mybatis-spring
1.2.2
org.mybatis.generator
mybatis-generator-core
1.3.5
mysql
mysql-connector-java
5.1.29
junit
junit
4.11
test
javax.servlet
jstl
1.2
javax.servlet.jsp
jsp-api
2.2.1-b03
provided
javax.servlet
servlet-api
2.5
provided
com.fasterxml.jackson.core
jackson-core
2.7.1
com.fasterxml.jackson.core
jackson-annotations
2.7.1
com.fasterxml.jackson.core
jackson-databind
2.7.1
net.sf.json-lib
json-lib
2.4
jdk15
commons-lang
commons-lang
2.4
commons-logging
commons-logging
1.1
commons-pool
commons-pool
1.5.6
commons-dbcp
commons-dbcp
1.4
commons-beanutils
commons-beanutils
1.8.3
commons-httpclient
commons-httpclient
3.1
commons-collections
commons-collections
3.1
commons-codec
commons-codec
1.9
javax.annotation
jsr250-api
1.0
net.sf.ezmorph
ezmorph
1.0.6
javax.activation
activation
1.1
taglibs
standard
1.1.2
log4j
log4j
${log4j.version}
org.slf4j
slf4j-api
${slf4j.version}
org.slf4j
slf4j-log4j12
${slf4j.version}
commons-fileupload
commons-fileupload
1.3.1
commons-io
commons-io
2.4
elegantjc
maven-clean-plugin
3.1.0
maven-resources-plugin
3.0.2
maven-compiler-plugin
3.8.0
maven-surefire-plugin
2.22.1
maven-war-plugin
3.2.2
maven-install-plugin
2.5.2
maven-deploy-plugin
2.8.2
org.mybatis.generator
mybatis-generator-maven-plugin
1.3.2
true
true
然后jdbc.properties:
driver=com.mysql.jdbc.Driver
#game_message为我本地的数据库名
url=jdbc:mysql://localhost:3306/game_message?useUnicode=true&characterEncoding=utf-8
username=root
#下面输入自己数据库的密码
password=root
#定义初始连接数
initialSize=0
#定义最大连接数
maxActive=20
#定
【一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义】
义最大空闲
maxIdle=20
#定义最小空闲
minIdle=1
#定义最长等待时间
maxWait=60000
然后log4j.properties:
#log4j.rootLogger=debug,console,debug,info,warn,error,fatal
log4j.rootLogger=INFO,info,warn,error,fatal
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.PatternLayout
log4j.appender.console.Encoding=UTF-8
log4j.appender.console.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
#log4j.logger.java.sql.ResultSet=INFO
#log4j.logger.org.apache=INFO
#log4j.logger.java.sql.Connection=INFO
#log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.ResultSet=INFO
log4j.logger.org.apache=INFO
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG
log4j.logger.org.springframework=ERROR
log4j.logger.org.mybatis=ERROR
log4j.logger.org.hibernate=ERROR
log4j.logger.com.mchange=ERROR
log4j.logger.org.quartz=ERROR
log4j.logger.debug=debug
log4j.appender.debug=org.apache.log4j.DailyRollingFileAppender
log4j.appender.debug.layout=org.apache.log4j.PatternLayout
log4j.appender.debug.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
log4j.appender.debug.datePattern=’.'yyyy-MM-dd-HH
log4j.appender.debug.Threshold=DEBUG
log4j.appender.debug.append=true
log4j.appender.debug.Encoding=UTF-8
log4j.appender.debug.File=${loghome}/mall_debug.log
log4j.logger.info=info
log4j.appender.info=org.apache.log4j.DailyRollingFileAppender
log4j.appender.info.layout=org.apache.log4j.PatternLayout
log4j.appender.info.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
log4j.appender.info.datePattern=’.'yyyy-MM-dd-HH
log4j.appender.info.Threshold=INFO
log4j.appender.info.append=true
log4j.appender.info.Encoding=UTF-8
log4j.appender.info.File=${loghome}/mall_info.log
log4j.logger.warn=warn
log4j.appender.warn=org.apache.log4j.DailyRollingFileAppender
log4j.appender.warn.layout=org.apache.log4j.PatternLayout
log4j.appender.warn.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
log4j.appender.warn.datePattern=’.'yyyy-MM-dd-HH
log4j.appender.warn.Threshold=WARN
log4j.appender.warn.append=true
log4j.appender.warn.Encoding=UTF-8
log4j.appender.warn.File=${loghome}/mall_warn.log
log4j.logger.error=error
log4j.appender.error=org.apache.log4j.DailyRollingFileAppender
log4j.appender.error.layout=org.apache.log4j.PatternLayout
log4j.appender.error.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
log4j.appender.error.datePattern=’.'yyyy-MM-dd-HH
log4j.appender.error.Threshold=ERROR
log4j.appender.error.append=true
log4j.appender.error.Encoding=UTF-8
log4j.appender.error.File=${loghome}/mall_error.log
log4j.logger.fatal=fatal
log4j.appender.fatal=org.apache.log4j.DailyRollingFileAppender
log4j.appender.fatal.layout=org.apache.log4j.PatternLayout
log4j.appender.fatal.layout.ConversionPattern= %p %d{MM-dd_HH:mm:ss} %F %L %m %n
log4j.appender.fatal.datePattern=’.'yyyy-MM-dd-HH
log4j.appender.fatal.Threshold=FATAL
log4j.appender.fatal.append=true
log4j.appender.fatal.Encoding=UTF-8
log4j.appender.fatal.File=${loghome}/mall_fatal.log
#The log output to the directory
#loghome=/log/tomcat/zqgameapi_logs
#loghome=/data/logs/tomcat/admin.gamelaoyou.com
loghome=F:\log_data
mybatis.xml:
<?xml version="1.0" encoding="UTF-8"?>applicationContext.xml:
<?xml version="1.0" encoding="UTF-8"?><beans xmlns=“http://www.springframework.org/schema/beans”
xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance”
xmlns:context=“http://www.springframework.org/schema/context”
xmlns:beans=“http://www.springframework.org/schema/beans”
xmlns:mvc=“http://www.springframework.org/schema/mvc”
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-4.3.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd" >
<context:component-scan base-package=“com.springmvc”/>
<mvc:annotation-driven />
<mvc:resources location="/images/" mapping="/images/**"/>
<mvc:resources location="/css/" mapping="/css/**"/>
<mvc:resources location="/styles/" mapping="/styles/**"/>
<mvc:resources location="/js/" mapping="/js/**"/>
application/json;charset=UTF-8
classpath:jdbc.properties
mvc:interceptors
</mvc:interceptors>
web.xml:
<?xml version="1.0" encoding="UTF-8"?>elegantjc
encodingFilter
org.springframework.web.filter.CharacterEncodingFilter
encoding
UTF-8
forceEncoding
true
encodingFilter
/*
springServlet
org.springframework.web.servlet.DispatcherServlet
contextConfigLocation
classpath:spring/applicationContext.xml
1
springServlet
/
org.springframework.web.context.ContextLoaderListener
default
*.md
contextConfigLocation
classpath:spring/applicationContext.xml
/WEB-INF/index.jsp
600
generator.properties:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/game_message?useUnicode=true&characterEncoding=utf-8
username=root
password=root
#entity 包名和 java目录
modelPackage=com.springmvc.entity
modelProject=src/main/java
#sqlmap包名 和resources目录
sqlPackage=sqlmap
sqlProject=src/main/resources
#mapper包名和 java目录
mapperPackage=com.springmvc.dao
mapperProject=src/main/java
#数据库需要自动逆向生成的表的名字
table=messageboard
generatorConfig.xml:
<?xml version="1.0" encoding="UTF-8" ?><classPathEntry
location=“C:\Users\Administrator.m2\repository\mysql\mysql-connector-java\5.1.29\mysql-connector-java-5.1.29.jar” />
<jdbcConnection driverClass="${driver}"
connectionURL="${url}"
userId="${username}"
password="${password}" />
<javaModelGenerator targetPackage="${modelPackage}"
targetProject="${modelProject}" />
<javaClientGenerator targetPackage="${mapperPackage}"
targetProject="${mapperProject}" type=“XMLMAPPER” />
enableUpdateByExample=“false” enableDeleteByExample=“false”
enableSelectByExample=“false” selectByExampleQueryId=“false”/>