项目准备工作与环境搭建

一、画用例图usecase图

作用：让开发人员了解有那些角色要使用本系统，系统的用例（功能点），对整个系统的脉络有所了解。功能之间的关系，以及角色能操作哪些用例（功能）

采用Rationnal Rose（安装包大）：画顺序图、泳道图、类图、状态图（复杂业务有状态变迁图）

采用PowerDesigner（安装包小）：可画图，建立模型

二、系统功能结构图

采用visio软件：一般用来画网络结构图、建筑图

三、搭建框架

数据库————>持久层设计———>数据库访问Dao———>业务层Service————>控制层Controller————>视图层jsp

PD建模———PO持久对象，映射—————beans.xml配置文件———————springmvc-servlet.xml———web.xml，pom.xml

四、配置文件

1.sqlmapconfig.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><!-- 可配置mybatis数据库的配置，与Spring整合后可不需要配置，若配置的话此处优先加载 --></configuration>

2.mapping.xml（请根据需要重新修改）

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="cn.itcast.jk.mapper.FactoryMapper"><!-- 用来将pojo类和数据库的表对应，在这里写sql语句 --><!-- 数据库表映射 --><resultMap id="factoryRM" type="cn.itcast.jk.domain.Factory"><id property="id" column="FACTORY_ID"/><result property="fullName" column="FULL_NAME"/><result property="factoryName" column="FACTORY_NAME"/><result property="contractor" column="CONTRACTOR"/><result property="phone" column="PHONE"/><result property="mobile" column="MOBILE"/><result property="fax" column="FAX"/><result property="cnote" column="CNOTE"/><result property="orderNo" column="ORDER_NO"/><result property="state" column="STATE"/></resultMap><!-- 查询所有记录 --><select id="find" parameterType="cn.itcast.jk.domain.Factory" resultMap="factoryRM">select * from factory_cwhere 1=1</select></mapper>

3.application.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:mvc="http://www.springframework.org/schema/mvc"xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd "><!-- 管理service和dao --><!-- 是Spring的application文件，为了便于管理，将配置文件放在一起，用路径读取的方式加载配置文件而不用默认路径 --><!-- 扫描service和dao的包中的注解后注册成bean --><context:component-scan base-package="cn.itcast.jk.service,cn.itcast.jk.dao"/><-- 加载读取数据库连接配置的文件 --><context:property-placeholder location="classpath:jdbc.properties"/><!-- 数据库链接信息使用c3p0连接池用读取配置文件的方式代入参数，可以灵活修改 --><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driverClassName}"/><property name="jdbcUrl" value="${jdbc.url}"/><property name="user" value="${jdbc.username}"/><property name="password" value="${jdbc.password}"/><property name="maxPoolSize" value="${c3p0.pool.size.max}"/><property name="minPoolSize" value="${c3p0.pool.size.min}" /><property name="initialPoolSize" value="${c3p0.pool.size.ini}"/><property name="acquireIncrement" value="${c3p0.pool.size.increment}"/></bean><!-- 创建工厂bean——sqlSessionFactory 用来整合spring和myBatis --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 注入数据源，即数据库数据，放入工厂 --><property name="dataSource" ref="dataSource"/><!-- 加载sqlmapconfig.xml文件，即mybatis配置文件 --><property name="configLocation" value="classpath:sqlMapConfig.xml"/><!-- 加载映射文件，映射文件单独的包管理，批量加载 --><property name="mapperLocations" value="classpath:cn/itcast/jk/mapper/*.xml"/></bean><!-- 事务管理 也要注入数据源--><bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"/></bean><!-- 通知 AOP切面编程的配置--><tx:advice id="txAdvice" transaction-manager="txManager"><!-- 设置需要切入编程的方法并设置属性 --><tx:attributes><tx:method name="find*" read-only="true" /><tx:method name="get*" read-only="true" /><tx:method name="view*" read-only="true" /><tx:method name="insert*" propagation="REQUIRED" /><tx:method name="update*" propagation="REQUIRED" /><tx:method name="delete*" propagation="REQUIRED" /><tx:method name="*" propagation="REQUIRED" /><!-- 防止漏网之鱼 有的方法不适用于以上--></tx:attributes></tx:advice><aop:config><!-- 切点 管理所有Service的方法 --><aop:pointcut expression="execution(* cn.itcast.jk.service.*.*(..))" id="transactionPointCut"/><!-- 增强，进行事务控制 Advisor 设置切点以后，还需注入通知告诉其需要切入的方法--><aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointCut"/></aop:config></beans>

4.springmvc.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:mvc="http://www.springframework.org/schema/mvc"xmlns:context="http://www.springframework.org/schema/context"xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd "><!-- 加载注释驱动，读取注释后的类 --><mvc:annotation-driven/><!-- 扫描controller包以创建bean --><context:component-scan base-package="cn.itcast.jk.controller"/><!-- 内部资源视图解析器，用来return路径设置 --><bean id="jspInternalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver"><!-- 前缀 --><property name="prefix" value="/WEB-INF/pages/"/><!-- 后缀，一般不配置，防止需要传递参数 --><property name="suffix" value=""/></bean></beans>

5.web.xml

<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"id="WebApp_ID" version="3.0"><display-name>ssm</display-name><!-- spring整合 --><!-- 加载spring的配置文件 --><context-param><param-name>contextConfigLocation</param-name><param-value>classpath:beans.xml</param-value></context-param><listener><!-- 设置监听器，当启动时加载spring配置文件 --><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><!-- 加载springMVC servlet --><servlet><!-- 设置前端控制器 --><servlet-name>spingmvc</servlet-name><servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class><!-- 初始化加载springmvc—servlet.xml文件 --><init-param><param-name>contextConfigLocation</param-name><param-value>classpath:springmvc-servlet.xml</param-value></init-param></servlet><!-- 设置拦截路径 --><servlet-mapping><servlet-name>spingmvc</servlet-name><url-pattern>*.action</url-pattern></servlet-mapping></web-app>

6.pom.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">  <modelVersion>4.0.0</modelVersion>  <groupId>cn.itcast.jk</groupId>  <artifactId>jk1111</artifactId>  <packaging>war</packaging>  <version>0.0.1-SNAPSHOT</version>  <name>jk1111 Maven Webapp</name>  <url>http://maven.apache.org</url>    <properties><org.springframework.version>3.2.2.RELEASE</org.springframework.version></properties>      <dependencies><dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${org.springframework.version}</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId><version>${org.springframework.version}</version></dependency><dependency><groupId>org.aspectj</groupId><artifactId>com.springsource.org.aspectj.weaver</artifactId><version>1.6.8.RELEASE</version></dependency> <dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.2.2</version></dependency><dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>1.2.0</version></dependency> <dependency><groupId>c3p0</groupId><artifactId>c3p0</artifactId><version>0.9.1.2</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.10</version></dependency><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.13</version></dependency><dependency><groupId>org.apache.poi</groupId><artifactId>poi</artifactId><version>3.9</version></dependency><dependency><groupId>org.apache.poi</groupId><artifactId>poi-ooxml</artifactId><version>3.9</version></dependency><dependency><groupId>jfree</groupId><artifactId>jfreechart</artifactId><version>1.0.13</version></dependency><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.9</version></dependency><dependency><groupId>commons-fileupload</groupId><artifactId>commons-fileupload</artifactId><version>1.2.2</version></dependency><dependency><groupId>commons-io</groupId><artifactId>commons-io</artifactId><version>2.0.1</version></dependency><dependency><groupId>javax.servlet.jsp.jstl</groupId><artifactId>jstl-api</artifactId><version>1.2</version></dependency><dependency><groupId>org.glassfish.web</groupId><artifactId>jstl-impl</artifactId><version>1.2</version></dependency><dependency><groupId>jexcelapi</groupId><artifactId>jxl</artifactId><version>2.4.2</version></dependency>  </dependencies>  <build>    <finalName>jk1111</finalName>  </build></project>

以上，请根据需要引用修改