SSM简单整合(Mybatis,Spring,SpringMVC,基于注解和xml文件配置)
来源:互联网 发布:新天龙八部注册软件 编辑:程序博客网 时间:2024/06/06 00:22
SSM简单整合
1.环境
- JDK1.8
- Eclipse
- Maven构建工具
2.依赖包配置(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/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.lyx</groupId> <artifactId>ssm_hrs</artifactId> <version>1.0</version> <dependencies> <!-- https://mvnrepository.com/artifact/junit/junit --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/javax.servlet-api --> <dependency> <groupId>javax.servlet</groupId> <artifactId>javax.servlet-api</artifactId> <version>3.1.0</version> <scope>provided</scope> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet.jsp/javax.servlet.jsp-api --> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>javax.servlet.jsp-api</artifactId> <version>2.3.1</version> <scope>provided</scope> </dependency> <!-- https://mvnrepository.com/artifact/javax.servlet/jstl --> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- mybatis的依赖包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.4.5</version> </dependency> <!-- mybatis整合Spring的依赖包 --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.3.1</version> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.40</version> </dependency> <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 --> <dependency> <groupId>org.apache.commons</groupId> <artifactId>commons-dbcp2</artifactId> <version>2.1.1</version> </dependency> <!-- https://mvnrepository.com/artifact/commons-codec/commons-codec --> <dependency> <groupId>commons-codec</groupId> <artifactId>commons-codec</artifactId> <version>1.10</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-webmvc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.3.10.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-orm --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-orm</artifactId> <version>4.3.10.RELEASE</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-test --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-test</artifactId> <version>4.3.10.RELEASE</version> <scope>test</scope> </dependency> <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjrt --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjrt</artifactId> <version>1.8.10</version> </dependency> <!-- https://mvnrepository.com/artifact/org.aspectj/aspectjweaver --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.10</version> </dependency> <!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind --> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.9.0</version> </dependency> <!-- freemarker 模板引擎 --> <dependency> <groupId>org.freemarker</groupId> <artifactId>freemarker</artifactId> <version>2.3.23</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-context-support --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context-support</artifactId> <version>4.3.10.RELEASE</version> </dependency> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.9.0</version> </dependency> </dependencies> <build> <!-- 将类路径下的.xml加载(默认类路径是只加载.java文件的) --> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> </resources> <plugins> <!-- Maven打包插件 --> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-war-plugin</artifactId> <version>3.2.0</version> <!-- 即使没有web.xml文件也不报错 --> <configuration> <failOnMissingWebXml>false</failOnMissingWebXml> </configuration> </plugin> <!-- Tomcat插件(可以通过服务器插件部署项目) --> <plugin> <groupId>org.apache.tomcat.maven</groupId> <artifactId>tomcat7-maven-plugin</artifactId> <version>2.2</version> </plugin> <!-- Maven编译插件 --> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <!-- 使用JDK版本 --> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> </build> <packaging>war</packaging></project>
3.web.xml配置文件
<?xml version="1.0" encoding="UTF-8"?><web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1"> <!-- 配置前端控制器(门面模式) --> <servlet> <servlet-name>frontController</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <!-- 指定SpringMVC配置文件的路径和名字(不配置的话默认WEB-INF目录下frontController-servlet.xml文件) --> <init-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/spring-config/mvc.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> <!-- 服务器一启动就实例化控制器 --> <multipart-config /> <!-- 原生的支持文件上传 --> </servlet> <servlet-mapping> <servlet-name>frontController</servlet-name> <url-pattern>/</url-pattern> <!-- 一定要写斜杠(所有请求交给前端控制器) --> </servlet-mapping> <!-- 指定Spring配置文件的路径 --> <context-param> <param-name>contextConfigLocation</param-name> <!-- 名字必须该名字,一字不差 --> <param-value>/WEB-INF/spring-config/spring.xml</param-value> <!-- spring.xml-Spring配置文件的名字 --> </context-param> <!-- 配置监听器-服务器一启动就启动Spring IoC容器(Spring的IoC容器) --> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <!-- 配置编码过滤器 --> <filter> <filter-name>encodingFilter</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>utf-8</param-value> </init-param> --> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <!-- Open Session in view(将Hibernate的Session作用延长到view-视图渲染完成) --> <!-- 反模式-访问量过大就崩了-最好在业务层组装DTO --> <!-- <filter> <filter-name>osiv</filter-name> <filter-class>org.springframework.orm.hibernate5.support.OpenSessionInViewFilter</filter-class> </filter> <filter-mapping> <filter-name>osiv</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> --> <!-- 配置发生异常跳转的页面 --> <!-- <error-page> <error-code>404</error-code> <location>/404.html</location> </error-page> --> <!-- 发生错误跳转的页面 --> <!-- <error-page> <exception-type>java.lang.Throwable</exception-type> <location>/error.jsp</location> </error-page> --> <display-name>1011house</display-name> <welcome-file-list> <welcome-file>index.html</welcome-file> <welcome-file>index.jsp</welcome-file> </welcome-file-list></web-app>
4.SpringMVC的配置文件(mvc.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:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" 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/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd"> <!-- 拦截器 --> <!-- <mvc:interceptors> <mvc:interceptor> <mvc:mapping path="/toPublish" /> <mvc:mapping path="/doPublish" /> <bean class="com.lyx.house.interceptor.LoginInterceptor" /> </mvc:interceptor> </mvc:interceptors> --> <!-- 在哪个包以及子包下搜索被@Controller注解标记的控制器 --> <context:component-scan base-package="com.lyx.hrs.controller" /> <!-- 通过注解配置Spring MVC --> <mvc:annotation-driven conversion-service="conversionService"> <mvc:message-converters> <!-- 消息转换器(需要注解@ResponseBody),把返回的东西经过转换放入回应的消息体中 --> <!-- 将图片输出流经过转换放入回应的消息体中(需要设置MIME类型-资源的媒体类型) --> <bean class="org.springframework.http.converter.BufferedImageHttpMessageConverter" /> <bean class="org.springframework.http.converter.StringHttpMessageConverter" /> <!-- 将返回的对象转换成JSOn数据格式(直接返回对象就好)(底层通过Jackson工具类转换实现) --> <bean class="org.springframework.http.converter.json.MappingJackson2HttpMessageConverter" /> </mvc:message-converters> </mvc:annotation-driven> <!-- 配置转换服务的工厂对象(前端传过来的有些数据需要转换成指定格式就需要配置,例如前端给的日期本身是字符串--Date日期格式;一串有规律的字符串--自定义的一个对象) --> <bean id="conversionService" class="org.springframework.format.support.FormattingConversionServiceFactoryBean"> <!-- 指定自定义转换器 --> <property name="converters"> <set> <bean class="com.lyx.hrs.converter.DateConverter" /> </set> </property> </bean> <!-- 配置使用应用服务器(Tomcat)默认的Servlet处理静态资源 --> <mvc:default-servlet-handler /> <!-- 为静态资源配置资源映射(如上是将全部的静态资源进行默认处理,这里是详细的进行自定义处理) --> <!-- <mvc:resources location="/css/**" mapping="/css/**" /> <mvc:resources location="/images/**" mapping="/image/**"/> <mvc:resources location="/js/**" mapping="/js/**" /> --> <!-- 配置上传文件的视图解析器 --> <!-- Servlet 3 - StandardServletMultipartResolver --> <!-- Apache Commons FileUpload - CommonsMultipartResolver --> <!-- 如果使用Servlet 3原生的文件上传支持那么需要在配置DispatcherServlet时指定multipart-config --> <!-- 如果使用Apache的Commons-FileUpload那么需要在依赖项中加入commons-fileupload的jar文件 --> <bean class="org.springframework.web.multipart.support.StandardServletMultipartResolver" /> <!-- 配置JSP的视图解析器对象 --> <!-- <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" /> <property name="prefix" value="/WEB-INF/jsp/" /> <property name="suffix" value=".jsp" /> <!-- 视图解析器的优先级(数值越大,优先级越低) --> <property name="order" value="10" /> </bean> --> <!-- freemarker的配置器 --> <bean class="org.springframework.web.servlet.view.freemarker.FreeMarkerConfigurer"> <property name="templateLoaderPath" value="/WEB-INF/ftl/"/> <property name="defaultEncoding" value="utf-8"/> <property name="freemarkerSettings"> <props> <prop key="classic_compatible">true</prop> </props> </property> </bean> <!-- freemarker的视图解析器 --> <bean class="org.springframework.web.servlet.view.freemarker.FreeMarkerViewResolver"> <property name="contentType" value="text/html; charset=utf-8" /> <property name="cache" value="true"/> <property name="prefix" value=""/> <property name="suffix" value=".ftl"/> <property name="order" value="4"/> </bean></beans>
5.Spring的配置文件(spring.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: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/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/aophttp://www.springframework.org/schema/aop/spring-aop.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- Spring扫包(将打了@Repository,@Service注解的类纳入IoC容器进行管理) --> <context:component-scan base-package="com.lyx.hrs"> <!-- 排除掉控制层 --> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /> <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice" /> </context:component-scan> <!-- 表示基于注解配置Spring --> <context:annotation-config /> <!-- 配置连接池 DBCP2/C3P0/Druid(该处使用的DBCP2) --> <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <property name="url" value="jdbc:mysql://localhost:3306/hrs"></property> <property name="username" value="root"></property> <property name="password" value="951112"></property> <property name="initialSize" value="10"></property> <property name="maxTotal" value="100"></property> <property name="maxWaitMillis" value="5000"></property> </bean> <!-- 配置mybatis的SqlSessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource" /> <!-- 指定Mybtis配置文件的路径和名字 --> <property name="configLocation" value="classpath:mybatis-config.xml" /> </bean> <!-- 配置MapperScannerConfigurer对象 --> <!-- 该对象将指定包下的Mapper接口自动生成实现类,并纳入SpringIoC容器的管理 --> <!-- 该配置可以将Mapper对象依赖注入到业务对象中 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.lyx.hrs.mapper" /> <property name="sqlSessionFactoryBeanName" ref="sqlSessionFactory"/> </bean> <!-- 配置事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"></property> </bean> <!-- 配置声明式事务(打注解-@Transaction-业务层-事务脚本模式) --> <tx:annotation-driven transaction-manager="transactionManager" /> <!-- 自己写的切面代理(通过自动生成代理) --> <!-- <aop:aspectj-autoproxy></aop:aspectj-autoproxy> --></beans>
6.Mybatis的配置文件
<?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> <!-- 配置类型别名 --> <typeAliases> <!-- 单独一个个的配置 --> <!-- <typeAlias alias="student" type="com.lyx.mybatis.domain.Student" /> --> <!-- 默认把该包下的类名首字母小写作别名 --> <package name="com.lyx.hrs.domain"></package> </typeAliases> <!-- 映射器 XML文件的位置 --> <mappers> <!-- 单独一个个的配置 --> <!-- <mapper resource="com/lyx/mybatis/mapper/StudentMapper.xml" /> --> <!-- 默认把该包下的配置文件加载进来(映射器的xml文件和接口名字一样) --> <package name="com.lyx.hrs.mapper"></package> </mappers></configuration>
(5.6)另一种-将Mybatis的配置整合到Spring的配置中
<?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:context="http://www.springframework.org/schema/context" xmlns:mybatis="http://mybatis.org/schema/mybatis-spring" 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/context http://www.springframework.org/schema/context/spring-context.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <!-- 配置扫描哪个包及其子包来发现需要纳入Spring IoC容器管理的对象 --> <!-- Spring扫包(将打了@Repository,@Service注解的类纳入IoC容器进行管理) --> <context:component-scan base-package="com.lyx.hrms"> <!-- 排除掉控制层 --> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /> <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.ControllerAdvice" /> </context:component-scan> <context:annotation-config/> <!-- 配置属性占位符的处理对象 该对象可以读取指定的配置文件获取参数 --> <!-- 如果参数值是经过特殊处理的值 那么就需要继承该类自定义属性占位符处理对象 --> <bean class="com.lyx.hrms.util.MyPlaceholderConfigurer"> <property name="locations" value="classpath:jdbc.properties"/> </bean> <!-- 配置数据库连接池 --> <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> <!-- 基本属性 url、user、password --> <property name="url" value="${jdbc_url}" /> <property name="username" value="${jdbc_user}" /> <property name="password" value="${jdbc_password}" /> <!-- 配置初始化大小、最小、最大 --> <property name="initialSize" value="1" /> <property name="minIdle" value="1" /> <property name="maxActive" value="20" /> <!-- 配置获取连接等待超时的时间 --> <property name="maxWait" value="3000" /> <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 --> <property name="timeBetweenEvictionRunsMillis" value="60000" /> <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 --> <property name="minEvictableIdleTimeMillis" value="300000" /> <property name="validationQuery" value="SELECT 'x'" /> <property name="testWhileIdle" value="true" /> <property name="testOnBorrow" value="false" /> <property name="testOnReturn" value="false" /> <!-- 打开PSCache,并且指定每个连接上PSCache的大小 --> <property name="poolPreparedStatements" value="true" /> <property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> <!-- 配置监控统计拦截的filters --> <property name="filters" value="stat" /> </bean> <!-- 配置mybatis的sqlSessionFactory --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <!-- 配置类型别名 --> <property name="typeAliasesPackage" value="com.lyx.hrms.domain"/> <!-- 配置映射器xml文件 --> <property name="mapperLocations" value="classpath*:mapper/*.xml"/> <!-- 配置mybatis的类型转换器 --> <property name="typeHandlersPackage" value="com.lyx.hrms.handler"/> </bean> <!-- 配置mybatis的映射器,将包下的接口自动生成实现类并纳入Ioc容器的管理 --> <mybatis:scan base-package="com.lyx.hrms.mapper"/> <!-- 配置事务管理 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <!-- 配置声明式事务 --> <tx:annotation-driven transaction-manager="transactionManager"/></beans>
7.接口,接口对应的Mybaits的实现文件(持久层)
Department.java(实体类)
package com.lyx.hrs.domain;import java.io.Serializable;/** * 部门表 */public class Department implements Serializable { private static final long serialVersionUID = 1L; private Integer no; private String name; private String location; public Department() { super(); } public Integer getNo() { return no; } public void setNo(Integer no) { this.no = no; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getLocation() { return location; } public void setLocation(String location) { this.location = location; } @Override public String toString() { return "Department [no=" + no + ", name=" + name + ", location=" + location + "]"; }}
Employee.java(实体类)
package com.lyx.hrs.domain;import java.io.Serializable;import java.util.Date;/** * 员工类实体 */public class Employee implements Serializable{ private static final long serialVersionUID = 1L; private Integer no; //编号 private String name;//姓名 private Boolean sex; // true 男 private String job; //工作 private Double salary; //工资 private Date hiredate; //入职时间 private Boolean status; //是否在职 private String photoPath; //头像 private String tel; private Employee mgr; //主管(自关联 多对一) private Department dept; //所在部门 (关联部门表 多对一) public Integer getNo() { return no; } public void setNo(Integer no) { this.no = no; } public String getName() { return name; } public void setName(String name) { this.name = name; } public Boolean getSex() { return sex; } public void setSex(Boolean sex) { this.sex = sex; } public String getJob() { return job; } public void setJob(String job) { this.job = job; } public Employee getMgr() { return mgr; } public void setMgr(Employee mgr) { this.mgr = mgr; } public Double getSalary() { return salary; } public void setSalary(Double salary) { this.salary = salary; } public Date getHiredate() { return hiredate; } public void setHiredate(Date hiredate) { this.hiredate = hiredate; } public Boolean getStatus() { return status; } public void setStatus(Boolean status) { this.status = status; } public String getPhotoPath() { return photoPath; } public void setPhotoPath(String photoPath) { this.photoPath = photoPath; } public String getTel() { return tel; } public void setTel(String tel) { this.tel = tel; } public Department getDept() { return dept; } public void setDept(Department dept) { this.dept = dept; } public Employee() { super(); }}
DepartmentMapper.java(接口)
package com.lyx.hrs.mapper;import java.util.List;import com.lyx.hrs.domain.Department;public interface DepartmentMapper{ int save(Department dept); int deleteById(Integer no); int update(Department dept); Department findById(Integer id); List<Department> findAll(); int countEmpById(Integer no);}
DepartmentMapper.xml(与Department.java接口对应的Mybatis实现文件,Mybatis会根据该文件生成DepartmentMapper.java的实现类)
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 命名空间-对应相应的接口 --><mapper namespace="com.lyx.hrs.mapper.DepartmentMapper"> <!-- 配置实体类与数据库表的对应关系 --> <resultMap type="department" id="departmentResultMap"> <!-- 实体类属性名 对应 数据库列名 --> <id property="no" column="dno" /> <result property="name" column="dname" /> <result property="location" column="dloc" /> </resultMap> <!-- id对应接口的方法名,paramType对应参数类型,resultType对应返回的数据类型(如int,string), 若返回的是实体类或容器中装的是实体类,则resultMap对应实体类 --> <insert id="save" parameterType="department"> insert into tb_dept (dno,dname,dloc) values(#{no},#{name},#{location}) </insert> <delete id="deleteById" parameterType="int"> delete from tb_dept where dno=#{no} </delete> <update id="update" parameterType="department"> update tb_dept <set> <if test="name!=null">dname=#{name},</if> <if test="location!=null">dloc=#{location},</if> </set> where dno=#{no} </update> <select id="findById" resultMap="departmentResultMap" parameterType="int"> select dno,dname,dloc from tb_dept where dno=#{no} </select> <select id="findAll" resultMap="departmentResultMap"> select dno,dname,dloc from tb_dept </select> <select id="countEmpById" resultType="int"> select count(1) from tb_emp where dno=#{no} </select></mapper>
EmployeeMapper.java(接口)
package com.lyx.hrs.mapper;import java.util.List;import org.apache.ibatis.annotations.Param;import com.lyx.hrs.domain.Department;import com.lyx.hrs.domain.Employee;/** * 员工数据访问对象接口 */public interface EmployeeMapper{ int save(Employee emp); int leaveByNo(Integer no); int update(Employee emp); Employee findById(Integer no); //@Param--多参数时,在Mybatis实现文件中可以使用该注解配置的名字进行占位 List<Employee> findByPage(@Param("dept")Department dept,@Param("offset")Integer offset,@Param("pageSize")Integer pageSize); int findTotalEmpByDept(Department dept);}
EmployeetMapper.xml(EmployeeMapper.java接口的Mybatis的实现文件)
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!-- 命名空间-对应相应的接口 --><mapper namespace="com.lyx.hrs.mapper.EmployeeMapper"> <!-- 被关联的 --> <resultMap type="department" id="departmentResultMap"> <!-- 只查询被关联的某些列 --> <id property="no" column="dno" /> <result property="name" column="dname" /> <result property="location" column="dloc" /> </resultMap> <resultMap type="employee" id="mgrResultMap"> <!-- 因为自关联列名一样,所以(column)进行别名 --> <id property="no" column="mgrno" /> <result property="name" column="mgrname" /> </resultMap> <!-- 配置实体类与数据库表的对应关系 --> <resultMap type="employee" id="employeeResultMap"> <id property="no" column="eno" /> <result property="name" column="ename" /> <result property="sex" column="esex" /> <result property="job" column="ejob" /> <result property="salary" column="esal" /> <result property="hiredate" column="ehiredate" /> <result property="status" column="estatus" /> <result property="photoPath" column="ephoto" /> <result property="tel" column="etel" /> <!-- 外键列的关联映射(多对一) --> <association property="mgr" column="emgr" resultMap="mgrResultMap"/> <association property="dept" column="dno" resultMap="departmentResultMap"/> </resultMap> <insert id="save" parameterType="employee"> insert into tb_emp (eno,ename,esex,ejob,esal,ehiredate,estatus,ephoto,etel,emgr,dno) values (#{no},#{name},#{sex},#{job},#{salary},#{hiredate},#{status},#{photoPath},#{tel},#{mgr.no},#{dept.no}) </insert> <update id="leaveByNo" parameterType="int"> update tb_emp set estatus=0 where eno=#{no} </update> <update id="update" parameterType="employee"> update tb_emp <set> <if test="name!=null">ename=#{name},</if> <if test="job!=null">ejob=#{job},</if> <if test="salary!=null">esal=#{salary},</if> <if test="tel!=null">etel=#{tel},</if> </set> where eno=#{no} </update> <select id="findById" resultMap="employeeResultMap" parameterType="int"> <!-- 进行多表查询 --> select t1.eno,t1.ename,t1.esex,t1.ejob,t1.esal,t1.ehiredate,t1.estatus,t1.ephoto,t1.etel, t2.eno as mgrno,t2.ename as mgrname,t3.dno,dname,dloc from tb_emp as t1 left outer join tb_emp as t2 on t1.emgr=t2.eno left outer join tb_dept as t3 on t1.dno=t3.dno where t1.eno=#{no} </select> <select id="findByPage" resultMap="employeeResultMap"> <!-- 多参数 --> select eno,ename,esex,ejob,estatus,etel from tb_emp where dno=#{dept.no} and estatus=1 limit #{offset},#{pageSize} </select> <select id="findTotalEmpByDept" resultType="int" parameterType="department"> select count(1) from tb_emp where dno=#{no} </select></mapper>
8.自定义的转换器
package com.lyx.hrs.converter;import java.text.ParseException;import java.text.SimpleDateFormat;import java.util.Date;import org.springframework.core.convert.converter.Converter;//自定义的转换器,需要实现 import org.springframework.core.convert.converter.Converter 接口public class DateConverter implements Converter<String, Date>{ @Override public Date convert(String dateString) { if (dateString==null||dateString=="") { throw new RuntimeException("入职时间不能为空"); } else { SimpleDateFormat myFormat = new SimpleDateFormat("yyyy-MM-dd"); try { return myFormat.parse(dateString); } catch (ParseException e) { throw new RuntimeException("字符串转日期格式出错!!!", e); } } }}
9.杂项
Mybatis调用存储过程示例
<!-- 调用存储过程 --> <select id="findAvgSalary" statementType="CALLABLE"> {call sp_getAvgSal( #{name,jdbcType=VARCHAR,mode=IN}, #{avgSal,jdbcType=DOUBLE, mode=OUT} )} </select>
Mybatis主键回显示例
<!-- 主键回显 --> <insert id="save" parameterType="user" useGeneratedKeys="true" keyProperty="id"> insert into tb_user(username,userpass,email,phone,realname) values(#{username},#{password},#{email},#{phone},#{realname}) </insert>
阅读全文
0 0
- SSM简单整合(Mybatis,Spring,SpringMVC,基于注解和xml文件配置)
- SSM(spring+springMVC+Mybatis)简单整合
- SSM(spring+springMVC+mybatis)整合配置
- 纯代码(基于注解和代码,零xml)整合SSHM(Spring、SpringMVC、Hibernate、Mybatis)
- spring、springmvc、mybatis整合配置(注解)
- SSHM(Spring,SpringMVC,Hibernate,Mybatis)基于xml文件和注解(@Annotation)
- 基于Maven的SSM框架整合(Spring+SpringMVC+MyBatis)
- SSM简单整合(Spring+SpringMVC+Mybatis)
- SSM(Spring+SpringMVC+Mybatis)框架整合配置方法
- SSM框架整合( Spring 、 SpringMVC 和 Mybatis )
- SSM框架整合( Spring 、 SpringMVC 和 Mybatis )
- SSM框架整合( Spring 、 SpringMVC 和 Mybatis )
- SSM框架整合( Spring 、 SpringMVC 和 Mybatis )
- SSM框架整合( Spring 、 SpringMVC 和 Mybatis )
- 简单的SSH整合(基于注解和xml文件的配置)
- maven工程建立和SSM(springMVC+spring+mybatis)整合
- SSM(Spring、SpringMVC和Mybatis)框架整合404问题解决
- SSM(Spring+SpringMVC+MyBatis)框架详细整合和多数据源配置
- 水晶头制作过程
- java2
- Siri已经落伍,会话式UI才是下一代人机交互方式?
- C# SendMessage WPARAM大全 (收集)
- 空心三角形的输出oj题目详解
- SSM简单整合(Mybatis,Spring,SpringMVC,基于注解和xml文件配置)
- leetcode 205
- 【Android】理解活动的生命周期
- 微信再发大招!原创保护上线新分享样式
- 死咬苹果,三星也正式宣布自研手机GPU
- 大疆退出中国市场?到底谁传的
- java 大整数开方模板与常用方法
- 函数参数的不同和“夸张”的引用
- ZOJ 1058