尚硅谷大数据技术之电信客服
2) 创建包结构,根包:com.atguigu
表13
bean |
|
|
contants |
|
|
controller |
|
|
dao |
|
|
entries |
|
|
3) 类表
表14
类名 |
备注 |
CallLog |
用于封装数据分析结果的JavaBean |
Contact |
用于封装联系人的JavaBean |
Contants |
常量类 |
CallLogHandler |
用于处理请求的Controller |
CallLogDAO |
查询某人某个维度通话记录的DAO |
ContactDAO |
查询联系人的DAO |
QueryInfo |
用于封装向服务器发来的请求参数 |
4) web目录结构,web部分的根目录:webapp
表15
文件夹名 |
备注 |
css |
存放css静态资源的文件夹 |
html |
存放html静态资源的文件夹 |
images |
存放图片静态资源文件夹 |
js |
存放js静态资源的文件夹 |
jsp |
存放jsp页面的文件夹 |
WEB-INF |
存放web相关配置的文件夹 |
5) resources目录下创建spring相关配置文件
dbconfig.properties:用于存放数据库连接配置
user=root password=000000 jdbcUrl=jdbc:mysql://hadoop102:3306/db_telecom?useUnicode=true&characterEncoding=UTF-8 driverClass=com.mysql.jdbc.Driver |
applicationContext.xml:Spring&SpringMVC配置
<?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:p="http://www.springframework.org/schema/p" 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/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <context:property-placeholder location="classpath:dbconfig.properties"/>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="user" value="${user}"/> <property name="password" value="${password}"/> <property name="driverClass" value="${driverClass}"/> <property name="jdbcUrl" value="${jdbcUrl}"/> </bean> <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <constructor-arg name="dataSource" value="#{dataSource}"></constructor-arg> </bean>
<bean id="namedParameterJdbcTemplate" class="org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate"> <constructor-arg name="dataSource" value="#{dataSource}"></constructor-arg> </bean> <!-- 包扫描 --> <context:component-scan base-package="com.atguigu.controller"></context:component-scan> <context:component-scan base-package="com.atguigu.dao"></context:component-scan> <!-- 配置视图解析器--> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/"/> <property name="suffix" value=".jsp"/> </bean>
<!--<mvc:annotation-driven />--> <!--<mvc:default-servlet-handler />--> <!--<mvc:resources location="/images/" mapping="/images/**"/>--> <!--<mvc:resources location="/js/" mapping="/js/**"/>--> <!--<mvc:resources location="/css/" mapping="/css/**"/>--> </beans> |
6) WEB-INF目录下创建web相关配置
web.xml:
<?xml version="1.0" encoding="UTF-8"?> <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" version="3.1"> <display-name>SpringMVC_CRUD</display-name> <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:applicationContext.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> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> <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> <init-param> <param-name>forceEncoding</param-name> <param-value>true</param-value> </init-param> </filter> <filter-mapping> <filter-name>CharacterEncodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping>
<servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.jpg</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.js</url-pattern> </servlet-mapping> <servlet-mapping> <servlet-name>default</servlet-name> <url-pattern>*.css</url-pattern> </servlet-mapping> </web-app> |