用SpringMVC +弹簧+ mybaits基本整合:
applicationContext文件:
<?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:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.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/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!--开启注解扫描 -->
<context:component-scan base-package="com.parkingms.service"></context:component-scan>
<context:component-scan base-package="com.parkingms.dao.ICompanyDao"></context:component-scan>
<!-- 开启事务控制的注解支持 -->
<tx:annotation-driven transaction-manager="transactionManager" />
<!--***************************************整合mybatis******************************** -->
<!--配置dataSource:数据库基本信息 -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="url" value="jdbc:mysql://localhost:3306/parkingms"></property>
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="username" value="root"></property>
<property name="password" value=""></property>
</bean>
<!--配置工厂类注入:SqlSessionFacotry -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<!--配置mybatis配置文件 -->
<property name="configLocation" value="classpath:config/config.xml"></property>
<!--映射文件注入:xml文件形式mapper注入 -->
<property name="mapperLocations">
<array>
<value>classpath:com/parkingms/mapper/CompanyMapper.xml</value>
</array>
</property>
</bean>
<!--创建数据映射器:映射接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.parkingms.dao"></property>
</bean>
<!-- 创建事务管理器: -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
mybaits配置文件配置:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<settings>
<!-- 配置log4j日志信息 -->
<setting name="logImpl" value="LOG4J"></setting>
<!-- 开启懒加载 -->
<setting name="lazyLoadingEnabled" value="true"></setting>
<!-- 将积极加载变成消极加载 -->
<setting name="aggressiveLazyLoading" value="false"></setting>
</settings>
<!-- 设置别名 -->
<typeAliases>
<package name="com.parkingms.bean" />
</typeAliases>
</configuration>
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:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
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/tx
http://www.springframework.org/schema/tx/spring-tx.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/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!-- spring包扫描功能 -->
<context:component-scan base-package="com.parkingms.action" />
<!-- 配置注解映射处理器 -->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping" />
<!-- 配置注解处理器适配器 -->
<bean class="org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter">
<!--适配器识别json文件 -->
<property name="messageConverters">
<list>
<ref bean="jackson"></ref>
</list>
</property>
</bean>
<!-- 配置视图解析器 -->
<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<!--配置前缀 -->
<!-- <property name="prefix" value="/jsp"></property> -->
<!--配置后缀 -->
<!-- <property name="suffix" value=".action"></property> -->
</bean>
<!--注册文件上传组件,id固定 -->
<bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
<!-- 限制文件上传最大值 -->
<property name="maxUploadSize">
<value>52428800</value>
</property>
</bean>
<!-- 注册json解析器 -->
<bean id="jackson" class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter">
<property name="supportedMediaTypes">
<list>
<value>application/json;charset=utf-8</value>
<value>text/html;charset=utf-8</value>
<value>text/json;charset=utf-8</value>
</list>
</property>
</bean>
</beans>
基础pom文件
<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/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.parkingms.service</groupId>
<artifactId>service-enterprise</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>war</packaging>
<name>service-enterprise</name>
<properties>
<webVersion>3.0</webVersion>
<!-- failOnMissingWebXml:true告诉maven项目,web.xml可以缺失 -->
<failOnMissingWebXml>false</failOnMissingWebXml>
<!-- maven默认使用gbk编码,设置为utf-8 -->
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<!-- 先定义jar包版本 -->
<spring.version>4.2.8.RELEASE</spring.version>
</properties>
<build>
<plugins>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
</plugins>
</build>
<dependencies>
<!-- servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>3.0.1</version>
<scope>provided</scope>
</dependency>
<!-- c3p0连接池 -->
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.1</version>
</dependency>
<!-- junit -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<!-- JSTL -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-expression</artifactId>
<version>${spring.version}</version>
</dependency>
<!-- mysql -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.34</version>
</dependency>
<!-- 日志 -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!-- 文件上传 -->
<dependency>
<groupId>commons-fileupload</groupId>
<artifactId>commons-fileupload</artifactId>
<version>1.3.3</version>
</dependency>
<!-- json -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.6.0</version>
</dependency>
<!-- mybaits -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.2.8</version>
</dependency>
<!--mybatis spring 插件 -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
</dependencies>
</project>
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" 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>Spring_Hibernate</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<!-- 配置前端控制器 -->
<servlet>
<servlet-name>springmvc</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!-- 前端控制器要加载的配置文件 -->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:config/springmvc-servlet.xml</param-value>
</init-param>
<!-- 服务器启动就加载springmvc的配置 -->
<!-- <load-on-startup>1</load-on-startup> -->
</servlet>
<servlet-mapping>
<servlet-name>springmvc</servlet-name>
<url-pattern>*.action</url-pattern>
</servlet-mapping>
<!-- 配置编码方式过滤器 -->
<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>
<!-- 配置 HiddenHttpMethodFilter过滤器,使得DELETE、PUT等请求可转换为标准的http方法 -->
<!-- <filter>
<filter-name>hiddenHttpMethodFilter</filter-name>
<filter-class>org.springframework.web.filter.HiddenHttpMethodFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>hiddenHttpMethodFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping> -->
<!-- log4j日志配置 -->
<!-- <context-param>
<param-name>log4jConfigLocation</param-name>
<param-value>classpath:config/log4j.properties</param-value>
</context-param>-->
<!-- 定义log4j监听器 -->
<!--<listener>
<listener-class>org.springframework.web.util.Log4jConfigListener</listener-class>
</listener>-->
<!-- 配置spring环境 -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath*:config/applicationContext.xml</param-value>
</context-param>
<!-- 使用监听器加载spring配置文件 -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
</web-app>
持久层dao:
注释:@Repository持久层注释,spring自动注入到容器,不需要实现类。通关映射产生代理对象
package com.parkingms.dao;
import java.util.List;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;
import org.springframework.stereotype.Repository;
import com.parkingms.bean.CbdcarBean;
import com.parkingms.bean.CompanyBean;
import com.parkingms.bean.CompanytreatyBean;
/**
* 企业用户dao接口
* @author BHH
*
*/
@Repository
public interface ICompanyDao {
/**
* 增加企业用户
* @param bean
* @return
*/
@Select(value = "call add_company(#{account},#{addr},#{contact},#{tel},#{account},#{pwd},#{character})")
@Options(statementType = StatementType.CALLABLE)
public Boolean insertCompanyBean(CompanyBean bean);
/**
* 删除企业用户
* @param bean
* @return
*/
@Select(value = "call delete_company(#{id})")
@Options(statementType = StatementType.CALLABLE)
public Boolean deleteCompanyBean(CompanyBean bean);
/**
* 查询企业用户,如果全为空,默认查询全部
* @param bean
* @return
*/
public List<CompanyBean> selectCompanyBean(CompanyBean bean);
/**
* 查询企业租赁的车位
* @param bean
* @return
*/
public List<CompanytreatyBean> selectCompanyCbdCar(CompanyBean bean);
}
业务层实现类:
注解:@Service,业务层注释,自动注入到容器 @Autowired,spring自动注入指定对象(类型注入)
package com.parkingms.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Isolation;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;
import com.parkingms.bean.CbdcarBean;
import com.parkingms.bean.CompanyBean;
import com.parkingms.bean.CompanytreatyBean;
import com.parkingms.dao.ICompanyDao;
import com.parkingms.service.ICompanyService;
import com.parkingms.util.MD5_Encoding;
import com.parkingms.util.RegularCheck;
/**
* 企业业务层实现类
* @author BHH
*
*/
@Service
@Transactional(isolation = Isolation.DEFAULT, propagation = Propagation.REQUIRED)
public class CompanyServiceImpl implements ICompanyService {
@Autowired
private ICompanyDao dao;
/**
* 需要检测登录名是否已经存在。调用注册接口
*/
@Override
public String insertCompanyBean(CompanyBean bean) {
if (bean.getAccount() == "") {
return "登录名不能为空";
} else if (bean.getPwd() != "") {
return "登录密码不能为空";
} else if (bean.getName() != "") {
return "企业名不能为空";
} else if (bean.getAddr() != "") {
return "企业地址不能为空";
} else if (bean.getContact() != "") {
return "企业联系人不能为空";
} else if (bean.getTel() != "") {
return "企业联系不能为空";
}
String account = bean.getAccount();
String pwd = bean.getPwd();
String tel = bean.getTel();
if (!RegularCheck.accountCheck(account)) {
return "登录名格式不正确";
}
if (!RegularCheck.callCheck(tel) || !RegularCheck.telCheck(tel)) {
return "联系方式格式不正确";
}
if (RegularCheck.pwdCheck(pwd)) {
return "密码格式不正确";
}
bean.setPwd(MD5_Encoding.lowerMD5(pwd));
dao.insertCompanyBean(bean);
return "注册成功";
}
@Override
public boolean deleteCompanyBean(CompanyBean bean) {
dao.deleteCompanyBean(bean);
return false;
}
@Override
public List<CompanyBean> selectCompanyBean(CompanyBean bean) {
List<CompanyBean> list = dao.selectCompanyBean(bean);
return list;
}
@Override
public List<CompanytreatyBean> selectCompanyCbdCar(CompanyBean bean) {
List<CompanytreatyBean> list = dao.selectCompanyCbdCar(bean);
return list;
}
}