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

最新推荐文章于 2023-10-16 14:14:08 发布

huey2672

最新推荐文章于 2023-10-16 14:14:08 发布

阅读量3.4k

点赞数

分类专栏： Java/ZK 文章标签： ZK Spring MyBatis

本文链接：https://blog.csdn.net/huey2672/article/details/38439087

版权

Java/ZK 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

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;
	}

	@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));
		}
	}
	
}

huey2672

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
1
评论
ZK(7.0.1)+Spring(2.3.2)+MyBatis(2.3.2)整合的简单示例

1. 在eclipse中建立一个web项目，导入所需的jar包。 2. 在数据库创建一张表students：3. 实体类：4. mybatis映射器：5. 配置mybatis映射文件StudentMapper.xml：6. mybatis配置文件mybatis-config.xml（无需配置environments元素）：7. jdbc数据库连接属性配置：8. spri
复制链接

扫一扫