ZK(7.0.1)+Spring(2.3.2)+MyBatis(2.3.2)整合的简单示例

1. 在eclipse中建立一个web项目，导入所需的jar包。 

2. 在数据库创建一张表students：

DROP TABLE IF EXISTS students;CREATE TABLE students(stud_no INTEGER NOT NULL,stud_name VARCHAR(50) NOT NULL,birthday DATE NOT NULL,email VARCHAR(128),PRIMARY KEY (stud_no));

3. 实体类：

package com.huey.zk.entity;import java.util.Date;import com.huey.mybatis.utils.DateUtil;/** * 学生实体 * @author huey2672 * @version 1.0 * @created 2014-7-25 */public class Student {private Integer no;private String name;private Date birthday;private String email;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 getBirthday() {return DateUtil.dateToStr(birthday, "yyyy-MM-dd");}public void setBirthday(Date birthday) {this.birthday = birthday;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public Student() {super();}public Student(Integer no, String name, Date birthday, String email) {super();this.no = no;this.name = name;this.birthday = birthday;this.email = email;}@Overridepublic String toString() {return "Student [no=" + no + ", name=" + name + ", birthday="+ getBirthday() + ", email=" + email + "]";}}

4. mybatis映射器：

package com.huey.mybatis.mapper;import java.util.List;import com.huey.zk.entity.Student;/** * 映射器StudentMapper * 定义了对学生实体的一些基本操作 * @author huey2672 * @version 1.0 * @created 2014-7-25 */public interface StudentMapper {/** * 根据关键字查询学生记录 * @param keyword * @return */public List<Student> searchStudents(String keyword);}

5. 配置mybatis映射文件StudentMapper.xml：

<?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"><!--注意：此处的命名空间是StudentMapper的全限定类名--><mapper namespace="com.huey.mybatis.mapper.StudentMapper"><!-- ResultMaps被用来将 SQL SELECT语句的结果集映射到JavaBeans的属性中 --><resultMap type="Student" id="studentMap"><!-- 映射主键 --><id property="no" column="stud_no" /><!-- 映射普通字段 --><result property="name" column="stud_name"/><result property="birthday" column="birthday"/><result property="email" column="email"/></resultMap><select id="searchStudents" parameterType="string" resultMap="studentMap">select * from studentswhere concat(stud_no) like #{keyword} or stud_name like #{keyword} or email like #{keyword} </select></mapper>

6. mybatis配置文件mybatis-config.xml（无需配置environments元素）：

<?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 type="com.huey.zk.entity.Student" alias="Student" /></typeAliases><!-- mapper对应的xml配置文件 --><mappers><mapper resource="com/huey/mybatis/mapper/StudentMapper.xml" /></mappers></configuration>

7. jdbc数据库连接属性配置：

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=UTF-8&autoReconnect=truejdbc.username=rootjdbc.password=root

8. spring配置文件applicationContext.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: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-3.0.xsd     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-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/context http://www.springframework.org/schema/context/spring-context-3.0.xsd"><!-- 启动@AspectJ支持 --><aop:aspectj-autoproxy proxy-target-class="true" /><!-- 自动扫描指定包及其子包下的所有Bean类 --><context:component-scan base-package="com.huey" /><!-- 将配置值具体化到一个属性文件中，并且使用属性文件的key名作为占位符 --><context:property-placeholder location="classpath:jdbc.properties"/><!-- 配置数据源  --><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="50" /><property name="minPoolSize" value="1" /><property name="initialPoolSize" value="1" /><property name="maxIdleTime" value="20" /></bean><!-- 配置SqlSessionFactory交由Spring管理 --><bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"><property name="dataSource" ref="dataSource" /><property name="configLocation" value="classpath:mybatis-config.xml" /></bean><!-- 扫描并注册包中的映射器 Mapper接口 --><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.huey.mybatis.mapper" /></bean><!-- 将事务交由Spring管理 --><bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource" /></bean><!-- 启用spring @Transactional注解 --><tx:annotation-driven /></beans>

9. 业务逻辑层接口StudentServ：

package com.huey.mybatis.serv;import java.util.List;import com.huey.zk.entity.Student;/** * 业务逻辑层接口StudentServ * @author huey2672 * @version 1.0 * @created 2014-7-25 */public interface StudentServ {/** * 根据关键字查询学生记录 * @param keyword * @return */public List<Student> searchStudents(String keyword);}

10. 业务逻辑层实现StudentServImpl：

package com.huey.mybatis.serv.impl;import java.util.ArrayList;import java.util.List;import javax.annotation.Resource;import org.springframework.stereotype.Service;import org.springframework.transaction.annotation.Transactional;import com.huey.zk.entity.Student;import com.huey.mybatis.mapper.StudentMapper;import com.huey.mybatis.serv.StudentServ;/** * 业务逻辑层实现StudentServImpl * @author huey2672 * @version 1.0 * @created 2014-7-25 */@Service@Transactionalpublic class StudentServImpl implements StudentServ {@Resourceprivate StudentMapper studentMapper;@Overridepublic List<Student> searchStudents(String keyword) {List<Student> students = new ArrayList<Student>();try {students = studentMapper.searchStudents("%" + keyword + "%");} catch (Exception e) {e.printStackTrace();}return students;}}

11. log4j.properties配置：

log4j.rootLogger=info, Console#Consolelog4j.appender.Console=org.apache.log4j.ConsoleAppenderlog4j.appender.Console.layout=org.apache.log4j.PatternLayoutlog4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%nlog4j.logger.java.sql.ResultSet=DEBUGlog4j.logger.org.apache=DEBUGlog4j.logger.java.sql.Connection=DEBUGlog4j.logger.java.sql.Statement=DEBUGlog4j.logger.java.sql.PreparedStatement=DEBUG

12. 配置web.xml，配置zk相关的listener和servlet以及spring的相关配置：

<?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_2_5.xsd"id="WebApp_ID" version="2.5"><context-param><param-name>contextConfigLocation</param-name><param-value>classpath*:applicationContext*.xml</param-value></context-param><listener><description>  Used to cleanup when a session is destroyed</description><display-name>ZK Session cleaner</display-name><listener-class>org.zkoss.zk.ui.http.HttpSessionListener</listener-class></listener><listener><listener-class>org.springframework.web.context.ContextLoaderListener</listener-class></listener><servlet><description>  The ZK loader for ZUML pages</description><servlet-name>zkLoader</servlet-name><servlet-class>org.zkoss.zk.ui.http.DHtmlLayoutServlet</servlet-class><init-param><param-name>update-uri</param-name><param-value>/zkau</param-value></init-param><load-on-startup>1</load-on-startup></servlet><servlet><description>  The asynchronous update engine for ZK</description><servlet-name>auEngine</servlet-name><servlet-class>org.zkoss.zk.au.http.DHtmlUpdateServlet</servlet-class></servlet><servlet-mapping><servlet-name>zkLoader</servlet-name><url-pattern>*.zul</url-pattern></servlet-mapping><servlet-mapping><servlet-name>zkLoader</servlet-name><url-pattern>*.zhtml</url-pattern></servlet-mapping><servlet-mapping><servlet-name>auEngine</servlet-name><url-pattern>/zkau/*</url-pattern></servlet-mapping><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>index.zul</welcome-file></welcome-file-list></web-app>

13. zk配置文件zk.xml：

<?xml version="1.0" encoding="UTF-8"?><zk></zk>

14. zul页面：

<?page title="Hello ZK"?><!--variable-resolver指令，为zscript解释器指定一个变量分解器用以分解未知变量这里分解了在Spring框架中声明的Java Beans，这样我们可以直接访问到它们。--><?variable-resolver class="org.zkoss.zkplus.spring.DelegatingVariableResolver" ?><!-- apply属性用el表达式赋值，而不是类的完全限定名 --><window title="Hello ZK" border="normal" width="600px" apply="${studentSearchController}" ><hbox><textbox id="keywordBox" width="250px" /><button id="searchButton" label="Search" image="/img/search.png"  /></hbox><listbox id="studentListbox" style="margin-top:10px"><listhead><listheader label="学号" /><listheader label="姓名" /><listheader label="生日" /><listheader label="E-mail" /></listhead><template name="model"><listitem><listcell label="${each.no}" /><listcell label="${each.name}" /><listcell label="${each.birthday}" /><listcell label="${each.email}" /></listitem></template></listbox></window>

15. zk组件控制器：

package com.huey.zk.controller;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Controller;import org.zkoss.zk.ui.Component;import org.zkoss.zk.ui.select.SelectorComposer;import org.zkoss.zk.ui.select.annotation.Listen;import org.zkoss.zk.ui.select.annotation.Wire;import org.zkoss.zul.ListModelList;import org.zkoss.zul.Listbox;import org.zkoss.zul.Textbox;import com.huey.mybatis.serv.StudentServ;import com.huey.zk.entity.Student;/** * 控制器层StudentSearchController * @author huey2672 * @version 1.0 * @created 2014-8-8 */// 注入控制层Bean@Controller("studentSearchController")public class StudentSearchController extends SelectorComposer<Component> {/** *  */private static final long serialVersionUID = -8042049993596716142L;@Wireprivate Textbox keywordBox;@Wireprivate Listbox studentListbox;private StudentServ studentServ;@Autowiredpublic void setStudentServ(StudentServ studentServ) {this.studentServ = studentServ;}/** * 注册监听器，将该方法与id为searchButton的Button的onClick绑定 */@Listen("onClick=#searchButton")public void search() {String keyword = keywordBox.getValue();List<Student> students = studentServ.searchStudents(keyword);if (studentListbox != null) {studentListbox.setModel(new ListModelList<Student>(students));}}}