- 浏览: 93299 次
- 性别:
- 来自: 湖南
文章分类
最新评论
ibatis结合Struts2.0, Spring实现增,删,改,查的基本功能
1.JavaBean:Person.java
package com.baoz.ibatis.entity;
import java.util.Date;
public class Person {
private Integer id;
private String firstName;
private String lastName;
private Date birthDate;
private Double weight;
private Double height;
public Date getBirthDate() {
return birthDate;
}
public void setBirthDate(Date birthDate) {
this.birthDate = birthDate;
}
public String getFirstName() {
return firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public double getHeight() {
return height;
}
public void setHeight(double height) {
this.height = height;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getLastName() {
return lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public Double getWeight() {
return weight;
}
public void setWeight(Double weight) {
this.weight = weight;
}
public void setHeight(Double height) {
this.height = height;
}
}
2.ibatis映射配置:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="person">
<typeAlias alias="Person" type="com.baoz.ibatis.entity.Person"/>
<select id="readForId" resultClass="Person" parameterClass="java.lang.Integer">
select * from person where id=#value#
</select>
<select id="queryList" resultClass="Person">
select * from person
</select>
<insert id="add" parameterClass="Person" >
insert into person (firstName, lastName, birthDate, weight, height) values(#firstName#, #lastName#, #birthDate#, #weight#, #height#)
</insert>
<update id="update" parameterClass="Person">
update person set firstName=#firstName#, lastName=#lastName#, birthDate=#birthDate#, weight=#weight#, height=#height# where id=#id#
</update>
<delete id="delete" parameterClass="java.lang.Integer">
delete from person where id=#value#
</delete>
</sqlMap>
3.ibatis配置实例
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings useStatementNamespaces="true"/>
<sqlMap resource="com/baoz/ibatis/xmls/person.xml"/>
</sqlMapConfig>
4.struts2.0的配置文件:
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<constant name="struts.enable.DynamicMethodInvocation" value="false" />
<constant name="struts.devMode" value="true" />
<constant name="struts.i18n.encoding" value="UTF-8" />
<include file="struts-default.xml"></include>
<package name="myAction" extends="struts-default">
<action name="person" class="com.baoz.ibatis.action.PersonAction">
<result name="list">/personList.jsp</result>
<result name="add">/personEdit.jsp</result>
</action>
</package>
</struts>
5.spring的配置文件
6.怎样用ibatis的dao: 7.Service: 8.Action:
9.JSP: index.jsp:
personList.jsp:<?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-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd">
<context:annotation-config />
<context:component-scan base-package="com.baoz" />
<bean
class="org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor" />
<bean id="myDataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://127.0.0.1:3306/ibatisDB">
</property>
<property name="username" value="root"></property>
<property name="password" value="root"></property>
</bean>
<bean id="myIbatis"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation"
value="sqlMapConfigExample.xml">
</property>
<property name="dataSource" ref="myDataSource"></property>
</bean>
<bean id="personDao" class="com.baoz.ibatis.dao.PersonDao">
<property name="sqlMapClient" ref="myIbatis"></property>
</bean>
<bean id="personService" name="personService" class="com.baoz.ibatis.service.PersonService" scope="singleton">
</bean>
</beans>
package com.baoz.ibatis.dao;
import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.baoz.ibatis.entity.Person;
public class PersonDao extends SqlMapClientDaoSupport {
public Person readForId(int id){
return (Person)getSqlMapClientTemplate().queryForObject("person.readForId", id);
}
public List queryList(){
return getSqlMapClientTemplate().queryForList("person.queryList");
}
public void add(Person person){
getSqlMapClientTemplate().insert("person.add", person);
}
public void update(Person person){
getSqlMapClientTemplate().update("person.update", person);
}
public void delete(int id){
getSqlMapClientTemplate().delete("person.delete", id);
}
}
package com.baoz.ibatis.IService;
import java.util.List;
import com.baoz.ibatis.entity.Person;
public interface IPersonService {
public void insert(Person person);
public List queryList();
public Person readForid(int id);
public void update(Person person);
public void delete(int id);
}
package com.baoz.ibatis.service;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import com.baoz.ibatis.IService.IPersonService;
import com.baoz.ibatis.dao.PersonDao;
import com.baoz.ibatis.entity.Person;
public class PersonService implements IPersonService {
@Autowired
@Qualifier("personDao")
private PersonDao personDao;
public Person readForid(int id){
return personDao.readForId(id);
}
public void insert(Person person){
personDao.add(person);
}
public void add(Person person){
personDao.add(person);
}
public void update(Person person){
personDao.update(person);
}
public void delete(int id){
personDao.delete(id);
}
public PersonDao getPersonDao() {
return personDao;
}
public void setPersonDao(PersonDao personDao) {
this.personDao = personDao;
}
public List queryList() {
return personDao.queryList();
}
}
package com.baoz.ibatis.action;
import java.util.List;
import org.apache.commons.beanutils.MethodUtils;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.baoz.ibatis.IService.IPersonService;
import com.baoz.ibatis.entity.Person;
import com.opensymphony.xwork2.Action;
public class PersonAction implements Action {
private IPersonService personService;
private List list;
private Person person;
private String method;
private String id;
public Person getPerson() {
return person;
}
public void setPerson(Person person) {
this.person = person;
}
public String execute() throws Exception {
if(method != null && !method.equals("")){
return (String)MethodUtils.invokeMethod(this, method, new Object[]{});
}
return null;
}
public String list(){
list = this.getPersonService().queryList();
return "list";
}
public String addOrEdit(){
if(person.getId() != null ){
this.getPersonService().update(person);
}else{
this.getPersonService().insert(person);
}
return list();
}
public String toEdit(){
if(id != null && !id.equals("")){
int editId = Integer.parseInt(id);
person = getPersonService().readForid(editId);
}
return "add";
}
public String delete(){
if(id != null && !id.equals("")){
int deleteId = Integer.parseInt(id);
this.getPersonService().delete(deleteId);
}
return list();
}
public IPersonService getPersonService() {
if(personService == null){
ApplicationContext context = new ClassPathXmlApplicationContext("bean_main.xml");
personService=(IPersonService)context.getBean("personService");
}
return personService;
}
public void setPersonService(IPersonService personService) {
this.personService = personService;
}
public String getMethod() {
return method;
}
public void setMethod(String method) {
this.method = method;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public List getList() {
return list;
}
public void setList(List list) {
this.list = list;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
</head>
<body>
<a href="person.action?method=list">用户管理</a>
</body>
</html>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ taglib prefix="s" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>My JSP 'personList.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> </head> <body> <table align="center" border="1"> <tr align="center"><td align="center" colspan="6">用户管理</td></tr> <tr align="center"><td align="right" colspan="6"><s:a href="personEdit.jsp">用户新增</s:a></td></tr> <tr align="center"> <td align="center">名字</td> <td align="center">姓氏</td> <td align="center">出生日期</td> <td align="center">体重(Kg)</td> <td align="center">身高(cm)</td> <td align="center">操作</td> </tr> <s:iterator id="person" value="list"> <tr align="center"> <td align="center"><s:property value="firstName"/></td> <td align="center"><s:property value="lastName"/></td> <td align="center"><s:property value="birthDate"/></td> <td align="center"><s:property value="weight"/></td> <td align="center"><s:property value="height"/></td> <td align="center"> <a href='<s:url action="person"><s:param name="method">toEdit</s:param><s:param name="id" value="id"></s:param></s:url>'>编辑</a> <a href='<s:url action="person"><s:param name="method">delete</s:param><s:param name="id" value="id"></s:param></s:url>'>删除</a></td> </tr> </s:iterator> </table> </body> </html>
personEdit.jsp:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <%@ taglib prefix="s" uri="/struts-tags" %> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <s:head theme="ajax"/> <head> <base href="<%=basePath%>"> <title>My JSP 'personEdit.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> </head> <body> <s:form action="person.action?method=addOrEdit"> <s:hidden name="person.id"></s:hidden> <table align="center" border="1"> <tr align="center"><td> 用户新增</td></tr> <tr align="center"><td><s:textfield name="person.firstName" label="名字"></s:textfield></td></tr> <tr align="center"><td><s:textfield name="person.lastName" label="姓氏"></s:textfield><br/></td></tr> <tr align="center"><td><s:datetimepicker name="person.birthDate" toggleType="fade" label="出生日期"></s:datetimepicker><br/></td></tr> <tr align="center"><td><s:textfield name="person.weight" label="体重"></s:textfield><br/></td></tr> <tr align="center"><td><s:textfield name="person.height" label="身高"></s:textfield><br/></td></tr> <tr align="center"><td><s:submit value="提交"></s:submit></td></tr> </table> <br/> </s:form> </body> </html>
10.web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"> <!-- context-param> <param-name>contextConfigLocation</param-name> <param-value> /WEB-INF/classes/bean_main.xml </param-value> </context-param> --> <context-param> <param-name>log4jConfigLocation</param-name> <param-value>/WEB-INF/classes/log4j.properties</param-value> </context-param> <filter> <filter-name>struts2</filter-name> <filter-class> org.apache.struts2.dispatcher.FilterDispatcher </filter-class> </filter> <listener> <listener-class>org.springframework.web.util.Log4jConfigListener</listener-class> </listener> <!-- listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> --> <filter-mapping> <filter-name>struts2</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <welcome-file-list> <welcome-file>index.jsp</welcome-file> </welcome-file-list> </web-app>
11.log4j.properties
log4j.rootLogger=info,console log4j.appender.console=org.apache.log4j.ConsoleAppender log4j.appender.console.layout=org.apache.log4j.SimpleLayout log4j.logger.com.wehave=DEBUG # log4j.logger.org.springframework=DEBUG # SqlMap logging configuration... # log4j.logger.com.ibatis=DEBUG # log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG # log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG # log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=info log4j.logger.java.sql.PreparedStatement=info log4j.logger.java.sql.ResultSet=info log4j.logger.javax.sql=info
发表评论
-
parameterMap的应用
2009-09-03 16:28 2729ibatis中的parameterMap的应用 在上篇文章中 ... -
ibatis的部分属性
2009-09-02 15:45 2401ibatis的部分属性 1.映射配置文件中的节点: ... -
ibatis好处
2009-08-31 14:58 2008ibatis优点 1.对于应用层而言,程序员面对的是传统意义 ... -
ibatis介绍
2009-08-31 14:35 907ibatis介绍 相对Hibernate和Apache OJ ... -
ibatis语法1
2009-08-31 14:16 2278详细信息请见: http://www.blogjava.net ...
相关推荐
这个小例子展示了如何将这些技术整合在一起,实现一个基本的增删改查功能。下面我们将详细探讨这四个技术以及它们在实际应用中的工作原理。 **Struts1.2** 是一款基于MVC设计模式的Java Web框架,主要负责控制层的...
标题 "ibatis+struts2.0+spring" 指的是一个集成开发环境,它结合了三个重要的Java企业级框架:iBatis、Struts2.0和Spring。这个项目可能是为了帮助开发者理解如何在实际应用中整合这三个组件,以便构建更高效、可...
在本示例中,Ibatis 将作为数据库操作的主要工具,处理增、删、改、查(CRUD)操作,并可能包括对存储过程的调用。 2. **Struts2.0**:Struts2 是一个基于MVC(Model-View-Controller)设计模式的Web应用框架。它...
**ibatis & struts 2.0 详解** 在Java Web开发领域,ibatis和Struts 2.0是两个非常重要的框架,它们分别在数据访问层和表现层发挥着关键作用。本篇将深入探讨这两个框架的核心概念、功能及整合方式。 **一、ibatis...
包含了spring ibatis struts2.0整合需要的jar包 有需要的就下吧
Ibatis Struts1.2 Spring 2.0 整合终极版,Ibatis Struts1.2 Spring 2.0 整合终极版,Ibatis Struts1.2 Spring 2.0 整合终极版
本演示示例主要使用目前最新,最流行技术Struts2.1 +Spring 2.5.1+ibatis2.3整合开发而成,这与我以前发布的版本中最大特色是整合了Spring2.5.1中的注解功能和半自动化工具ibatis技术,这是本示例的两大特色,简化了配置...
Struts2.0、Spring、iBatis和JSON是Java Web开发中常用的技术栈,它们在构建企业级应用中发挥着关键作用。这篇详细的解释将深入探讨这些技术以及它们如何协同工作。 首先,Struts2.0是一个基于MVC(模型-视图-控制...
Struts2.0、Spring和iBATIS是Java开发中常用的三大开源框架,它们的集成使用可以构建出高效、灵活的企业级应用。本文档主要涵盖了这三者在实际项目中的配置与应用。 首先,我们来看Struts2.0框架的配置。Struts2的...
【标题】"Maven+Spring+Ibatis+Struts2.0+MQ+Memcached 项目构建"涉及了多个核心的Java开发技术和框架,这些技术的集成应用在现代企业级应用开发中非常常见。让我们逐一深入理解这些技术及其在项目中的作用。 1. ...
Struts2.0+Spring+Ibatis讲义
Struts2.2.3、Spring3.1和iBatis2.0是经典的Java Web开发框架组合,常被用于构建高效、灵活的企业级应用程序。这个压缩包包含了这三大框架的核心库,便于开发者进行集成和使用。下面我们将深入探讨这三个框架以及...
"spring2.0+struts2.0+ibatis2.3完整整合"是一个经典的Java Web开发组合,这个组合在过去的许多年里被广泛应用,为开发者提供了强大的功能和灵活的架构。 **Spring框架(2.0版本)** Spring是一个全面的后端应用...
这个名为"spring\struts2.0\ibatis简单整合"的项目正是展示了如何将这三大框架融合,实现数据访问层、业务逻辑层和视图层的有效分离,提高代码的可维护性和可扩展性。 首先,Spring作为核心容器,负责管理对象的...
Struts2.0+Spring2.5.1+ibatis2.3的整合是一个常见的Java Web应用程序开发模式,主要用于构建高效、可维护性高的企业级系统。这种整合将Struts2作为表现层框架,Spring作为控制层和业务层框架,而iBatis则作为数据...
此案例是学习struts2 spring3 ibatis整合的极品案例,里面涉及到了增删改查,数据库使用oracle数据库。页面请求全部使用ajax请求,数据传输以JSON格式传输,并且使用的是struts2 的JSON技术。页面js使用Jquery1.6 ,...
Struts2.0还集成了其他流行的开源项目,如Tiles2用于页面布局,Hibernate或iBatis用于持久化,Spring用于依赖注入,这些集成使得开发大型企业级应用更为便捷。 在实际开发中,性能优化也是重要的考虑因素。Struts...
关于struts2.0+spring+ibatis框架的一个增删改查及分页和排序 数据库:sqlserver 2000 服务器:tomcat 如果是oracle的只需修改Spring配置文件的 驱动 及 数据库对应的表即可
在新闻发布系统中,iBATIS可能用于处理新闻的增删改查操作,与Spring的DAO(Data Access Object)一起工作,为业务层提供透明的数据访问服务。 至于`website-jstl`,这可能是包含JSTL(JavaServer Pages Standard ...
这两个字段可能是员工的唯一标识和姓名,它们在业务逻辑中起到了关键作用,例如,增删改查员工信息。 整合这三个框架,开发者可能需要做以下工作: 1. 配置Struts1的struts-config.xml,定义Action和ActionForward...