一.打开eclipse创建maven工程
这里不多说了
二.在pom.xml里加入jar包
注意不同版本之间的jar包可能会有冲突,也不要全都加最新版本的jar包,到时解决起来很麻烦
直接点击官网搜索jar包名下载相应jar包
基本所需的jar包给大家发出来
1.spring webmvc 4.3.7
2.spring jdbc 4.3.7
3.spring aspects 4.3.7
4.c3p0 0.9.5.2
5.mybatis 3.4.6
6.mysql 5.1.45
7.jstl 1.2
8.servlet-api 3.1.0
9.mybatis-spring 1.3.2 框架整合
10.junit 4.12 测试
11.mybatis-generator1.3.5 逆向工程
12.pagehelper 5.1.7 分页插件
13.jackson 2.9.6 返回json对象
14.hibernate-validator 5.4.1 后端验证
14.fileupload 1.3.1 文件上传
这里把我的pom.xml发出来
<!-- spring-webmvc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- spring-aspects -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aspects</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- c3p0 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.6</version>
</dependency>
<!-- mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>
</dependency>
<!-- jstl -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- javax.servlet-api -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.1.0</version>
<scope>provided</scope>
</dependency>
<!-- mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.2</version>
</dependency>
<!-- junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- mybatis-generator-core -->
<dependency>
<groupId>org.mybatis.generator</groupId>
<artifactId>mybatis-generator-core</artifactId>
<version>1.3.5</version>
</dependency>
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.7</version>
</dependency>
<!-- jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.6</version>
</dependency>
<!-- hibernate-validator -->
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-validator</artifactId>
<version>5.4.1.Final</version>
</dependency>
<!-- commons-fileupload -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.1</version>
</dependency>
三.配置文件
springmvc的配置文件 springMVC-servlet.xml
1.包扫描(只包含controller层)
2.静态资源的处理方式
3.提供一些高级功能
4.视图解析器
<!-- 包扫描(只包含controller) -->
<context:component-scan base-package="com.zhiyou.bg.controller">
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 静态资源处理方式 -->
<mvc:default-servlet-handler/>
<!-- 高级功能 -->
<mvc:annotation-driven></mvc:annotation-driven>
<!-- 注册拦截器 -->
<mvc:interceptors>
<mvc:interceptor>
<mvc:mapping path="/**"/><!-- 过滤所有 -->
<mvc:exclude-mapping path="/adminLogin"/><!-- 不过滤登录 -->
<mvc:exclude-mapping path="/**/*.js"/><!-- 不过滤静态资源 -->
<mvc:exclude-mapping path="/**/*.css"/>
<bean class="com.zhiyou.bg.interceptor.LoginInterceptor"></bean>
</mvc:interceptor>
</mvc:interceptors>
<!-- 视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
spring的配置文件 application.xml
1引入属性文件
2.包扫描(排除controller层)
3.配置数据源
4.配置SqlSessionFactory
5.配置mybatis接口的扫描
6.配置事物管理类
7.配置意见
8.配置切面
9.配置文件上传
<!-- 属性文件 -->
<context:property-placeholder location="classpath:db.properties" />
<!-- 包扫描 -->
<context:component-scan base-package="com.zhiyou.bg">
<!-- 排除controller层 -->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!-- 数据源 -->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="jdbcUrl" value="${jdbc.url}"></property>
<property name="driverClass" value="${jdbc.driver}"></property>
</bean>
<!-- 配置sqlSessionFectoryBean -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!-- <property name="configLocation" value="classpath:mybatis.xml"></property> -->
<property name="mapperLocations" value="classpath:com/zhiyou/bg/mapper/*.xml"></property>
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<!--使用下面的方式配置参数,一行配置一个 -->
<value>reasonable=true</value>
</property>
</bean>
</array>
</property>
</bean>
<!-- mybatis接口的扫描 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.zhiyou.bg.dao"></property>
</bean>
<!-- 配置事务管理类 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- 配置意见 -->
<tx:advice id="advice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="query*" read-only="true"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>
<!-- 切面 -->
<aop:config>
<aop:pointcut expression="execution(* com.zhiyou.bg.*.*(..))" id="pointcut"/>
<aop:advisor advice-ref="advice" pointcut-ref="pointcut"/>
</aop:config>
该配置文件里的<property name="configLocation" value="classpath:mybatis.xml"></property>
是引用mybatis的配置文件,mybatis的配置基本上都能在该配置文件里写全,所以不需要再写mybatis的配置文件.
该配置文件里的
<property name="plugins">
<array>
<bean class="com.github.pagehelper.PageInterceptor">
<property name="properties">
<!--使用下面的方式配置参数,一行配置一个 -->
<value>reasonable=true</value>
</property>
</bean>
</array>
</property>
是设置pagehelper分页插件的
属性文件 db.properties
jdbc.user=root
jdbc.password=root
jdbc.url=jdbc:mysql://localhost:3306/crowdfunding?characterEncoding=utf-8
jdbc.driver=com.mysql.jdbc.Driver
以上三个文件全部放在src/main/resources目录下
三.web.xml
1.配置编码的过滤器
2.DispatcherServlet配置springMvc
3. 配置spring启动的listener
<!-- 配置编码的过滤器 -->
<filter>
<filter-name>encoding</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>encoding</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- 配置springMVC -->
<servlet>
<servlet-name>springDispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springMvc-servlet.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>springDispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
<!-- 配置spring启动的listener -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
四.逆向工程
1.配置文件 mybatisGenerator.xml
2.测试驱动
该配置文件直接建在工程下,与pom.xml同级
<generatorConfiguration>
<classPathEntry location="D:\ziliao\mysql-connector-java-5.1.45.jar" />
<context id="DB2Tables" targetRuntime="MyBatis3">
<!-- 去掉注释 -->
<commentGenerator>
<property name="suppressAllComments" value="true" />
</commentGenerator>
<!-- 数据库信息源 -->
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://localhost:3306/ssm"
userId="root"
password="root">
</jdbcConnection>
<javaTypeResolver >
<property name="forceBigDecimals" value="false" />
</javaTypeResolver>
<javaModelGenerator targetPackage="com.zhiyou.lsh.bean" targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
<property name="trimStrings" value="true" />
</javaModelGenerator>
<sqlMapGenerator targetPackage="com.zhiyou.lsh.mapper" targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</sqlMapGenerator>
<javaClientGenerator type="XMLMAPPER" targetPackage="com.zhiyou.lsh.dao" targetProject=".\src\main\java">
<property name="enableSubPackages" value="true" />
</javaClientGenerator>
<table tableName="emp" domainObjectName="Emp" >
<property name="useActualColumnNames" value="true"/>
<generatedKey column="ID" sqlStatement="DB2" identity="true" />
<columnOverride column="DATE_FIELD" property="startDate" />
<ignoreColumn column="FRED" />
<columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" />
</table>
<table tableName="dept" domainObjectName="Dept" >
<property name="useActualColumnNames" value="true"/>
<generatedKey column="ID" sqlStatement="DB2" identity="true" />
<columnOverride column="DATE_FIELD" property="startDate" />
<ignoreColumn column="FRED" />
<columnOverride column="LONG_VARCHAR_FIELD" jdbcType="VARCHAR" />
</table>
</context>
</generatorConfiguration>
写我们的测试类来驱动生成
public class Test1 {
public static void main(String[] args) throws Exception{
List<String> warnings = new ArrayList<String>();
boolean overwrite = true;
File configFile = new File("mybatisGenerator.xml");
ConfigurationParser cp = new ConfigurationParser(warnings);
Configuration config = cp.parseConfiguration(configFile);
DefaultShellCallback callback = new DefaultShellCallback(overwrite);
MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
myBatisGenerator.generate(null);
}
}
五.
在dao层和mapper映射中,增加自己想要的方法
mybatis是没有链表查询的,我们可以自己增加自己想要的链表查询sql语句或者其他
六.
service层编写接口和接口实现类,编写自己的方法来调用dao层的方法
然后可以先写测试类来测试我们service层的方法是否可行
七.
再通过controller层编写自己的方法来调用service层的方法并连接到jsp页面
八.
最后编写我们的jsp页面