一、说明
本节是从一个新的项目出发,回顾之前的知识点,练习所需资料下载页面
二、环境搭建分析
创建工程(Project&Module) 导入静态页面(见资料jsp页面) 导入需要坐标(见资料中的pom.xml) 创建包结构(controller、service、dao、domain、utils) 导入数据库脚本(见资料test.sql) 创建POJO类(见资料User.java和Role.java) 创建配置文件(applicationContext.xml、spring-mvc.xml、jdbc.properties、log4j.properties
三、环境搭建具体步骤
新创建一个工程demo04 导入静态页面 导入坐标
< dependencies>
< dependency>
< groupId> mysql< / groupId>
< artifactId> mysql- connector- java< / artifactId>
< version> 5.1 .32 < / version>
< / dependency>
< dependency>
< groupId> c3p0< / groupId>
< artifactId> c3p0< / artifactId>
< version> 0.9 .1 .2 < / version>
< / dependency>
< dependency>
< groupId> com. alibaba< / groupId>
< artifactId> druid< / artifactId>
< version> 1.1 .10 < / version>
< / dependency>
< dependency>
< groupId> junit< / groupId>
< artifactId> junit< / artifactId>
< version> 4.12 < / version>
< scope> test< / scope>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- context< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- test< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- web< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- webmvc< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> javax. servlet< / groupId>
< artifactId> javax. servlet- api< / artifactId>
< version> 3.0 .1 < / version>
< scope> provided< / scope>
< / dependency>
< dependency>
< groupId> javax. servlet. jsp< / groupId>
< artifactId> javax. servlet. jsp- api< / artifactId>
< version> 2.2 .1 < / version>
< scope> provided< / scope>
< / dependency>
< dependency>
< groupId> com. fasterxml. jackson. core< / groupId>
< artifactId> jackson- core< / artifactId>
< version> 2.9 .0 < / version>
< / dependency>
< dependency>
< groupId> com. fasterxml. jackson. core< / groupId>
< artifactId> jackson- databind< / artifactId>
< version> 2.9 .0 < / version>
< / dependency>
< dependency>
< groupId> com. fasterxml. jackson. core< / groupId>
< artifactId> jackson- annotations< / artifactId>
< version> 2.9 .0 < / version>
< / dependency>
< dependency>
< groupId> commons- fileupload< / groupId>
< artifactId> commons- fileupload< / artifactId>
< version> 1.3 .1 < / version>
< / dependency>
< dependency>
< groupId> commons- io< / groupId>
< artifactId> commons- io< / artifactId>
< version> 2.3 < / version>
< / dependency>
< dependency>
< groupId> commons- logging< / groupId>
< artifactId> commons- logging< / artifactId>
< version> 1.2 < / version>
< / dependency>
< dependency>
< groupId> org. slf4j< / groupId>
< artifactId> slf4j- log4j12< / artifactId>
< version> 1.7 .7 < / version>
< / dependency>
< dependency>
< groupId> log4j< / groupId>
< artifactId> log4j< / artifactId>
< version> 1.2 .17 < / version>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- jdbc< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> org. springframework< / groupId>
< artifactId> spring- tx< / artifactId>
< version> 5.0 .5 . RELEASE< / version>
< / dependency>
< dependency>
< groupId> jstl< / groupId>
< artifactId> jstl< / artifactId>
< version> 1.2 < / version>
< / dependency>
< / dependencies>
创建包结构 导入数据库,进入数据库中执行命令:source /root/test.sql
将素材中的pojo导入进项目的domain目录下 创建配置文件——log4j.properties的方法:直接复制 创建配置文件——jdbc.properties
jdbc.driver= com.mysql.jdbc.Driver
jdbc.url= jdbc:mysql://192.168.10.134:3306/test
jdbc.username= root
jdbc.password= 970725
创建springconfig配置文件——applicationContext.xml和spring-mvc.xml 配置web.xml
< web-app>
< display-name> Archetype Created Web Application</ display-name>
< context-param>
< param-name> contextConfigLocation</ param-name>
< param-value> classpath:applicationContext.xml</ param-value>
</ context-param>
< filter>
< filter-name> CharacterEncodingFilter</ filter-name>
< filter-class> org.springframework.web.filter.CharacterEncodingFilter</ filter-class>
< init-param>
< param-name> encoding</ param-name>
< param-value> UTF-8</ param-value>
</ init-param>
</ filter>
< filter-mapping>
< filter-name> CharacterEncodingFilter</ filter-name>
< url-pattern> /*</ url-pattern>
</ filter-mapping>
< listener>
< listener-class> org.springframework.web.context.ContextLoaderListener</ listener-class>
</ listener>
< servlet>
< servlet-name> dispatcherServlet</ servlet-name>
< servlet-class> org.springframework.web.servlet.DispatcherServlet</ servlet-class>
< init-param>
< param-name> contextConfigLocation</ param-name>
< param-value> classpath:spring-mvc.xml</ param-value>
</ init-param>
< load-on-startup> 1</ load-on-startup>
</ servlet>
< servlet-mapping>
< servlet-name> dispatcherServlet</ servlet-name>
< url-pattern> /</ url-pattern>
</ servlet-mapping>
</ web-app>
配置spring-mvc.xml
< beans xmlns = " http://www.springframework.org/schema/beans"
xmlns: xsi= " http://www.w3.org/2001/XMLSchema-instance"
xmlns: mvc= " http://www.springframework.org/schema/mvc"
xmlns: context= " http://www.springframework.org/schema/context"
xsi: schemaLocation= "
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
" >
< mvc: annotation-driven/>
< bean class = " org.springframework.web.servlet.view.InternalResourceViewResolver" >
< property name = " prefix" value = " /pages/" />
< property name = " suffix" value = " .jsp" />
</ bean>
< mvc: default-servlet-handler/>
< context: component-scan base-package = " controller" />
</ beans>
配置applicationContext.xml
< 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"
xsi: schemaLocation= "http: / / www. springframework. org/ schema/ beans http: / / www. springframework. org/ schema/ beans/ spring- beans. xsd
http: / / www. springframework. org/ schema/ context http: / / www. springframework. org/ schema/ context/ spring- context. xsd">
< ! -- 1 、加载jdbc. properties-- >
< context: property- placeholder location= "classpath:jdbc.properties" / >
< ! -- 2 、配置数据源对象-- >
< bean id= "dataSource" class = "com.alibaba.druid.pool.DruidDataSource" >
< property name= "driverClassName" value= "${jdbc.driver}" / >
< property name= "url" value= "${jdbc.url}" / >
< property name= "username" value= "${jdbc.username}" / >
< property name= "password" value= "${jdbc.password}" / >
< / bean>
< ! -- 3 、配置JdbcTemplate 对象-- >
< bean id= "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate" >
< property name= "dataSource" ref= "dataSource" / >
< / bean>
< / beans>