1. 在eclipse中建立一个web项目,导入所需的jar包。
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;
}
@Override
public 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 students
where 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.Driver
jdbc.url=jdbc:mysql://localhost:3306/mybatis?characterEncoding=UTF-8&autoReconnect=true
jdbc.username=root
jdbc.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
@Transactional
public class StudentServImpl implements StudentServ {
@Resource
private StudentMapper studentMapper;
@Override
public 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
#Console
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.java.sql.ResultSet=DEBUG
log4j.logger.org.apache=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.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;
@Wire
private Textbox keywordBox;
@Wire
private Listbox studentListbox;
private StudentServ studentServ;
@Autowired
public 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));
}
}
}