ibatis+spring+struts 环境配置

morning2008

浏览: 115246 次
性别:
来自: 合肥

最近访客更多访客>>

woodding2008

iTommy

xieting0911

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2016-01 ( 69)
更多存档...

ibatis+spring+struts环境配置

步骤：

一、新建工程，添加ibatis、spring和struts的jars；
二、数据库设计.
三、POJO类.
四、pojo类配置文件编写
五、ibatis主配置文件编写【主配置文件只剩下sqlMap了】
六、dao接口和接口实现
七、service接口和接口实现
八、struts action实现及struts-config.xml配置
九、spring配置文件的内容【牵扯到ibatis和struts的整合】
十、测试

一、新建工程，添加ibatis、spring和struts的jars；

二、数据库设计.

mysql数据库：

Sql代码

useibatis;
droptableifexistsuser;
createtableifnotexistsuser(
IDtinyintauto_increment,
LOGIN_NAMEvarchar(10)notnull,
PASS_WORDvarchar(15)notnull,
QXvarchar(10)default'guest'notnull,
MEMOtext,
primarykey(ID)
)
type=innodb
comment="userinfo";
insertintouser(LOGIN_NAME,PASS_WORD,QX)values('leh','888','admin');
insertintouser(LOGIN_NAME,PASS_WORD)values('lek','888');
commit;

use ibatis;
drop table if exists user;

create table if not exists  user(
       ID tinyint auto_increment,
       LOGIN_NAME varchar(10) not null,
       PASS_WORD varchar(15) not null,       
       QX varchar(10) default 'guest' not null ,
       MEMO text,       
              
       primary key (ID)
)
type=innodb
comment="user info";

insert into user(LOGIN_NAME,PASS_WORD,QX) values('leh','888','admin');
insert into user(LOGIN_NAME,PASS_WORD) values('lek','888');

commit;

数据源的配置

1）、配置文件db.properties （位置：resources/properties/db.properties，这里resources和src是一类文件）

Xml代码

driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/ibatis
username=root
password=54321

driver=com.mysql.jdbc.Driver
url=jdbc\:mysql\://localhost\:3306/ibatis
username=root
password=54321

2）、注册数据源到spring

Xml代码

!--springloaddataSourceconfigurationpropertyfile-->
<beanid="propertyConfigurer"class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<propertyname="locations">
<list>
<value>properties/database.properties</value>
</list>
</property>
</bean>
<beanid="dataSource"class="org.apache.commons.dbcp.BasicDataSource"destroy-method="close">
<propertyname="driverClassName"value="${driver}"/>
<propertyname="url"value="${url}"/>
<propertyname="username"value="${username}"/>
<propertyname="password"value="${password}"/>
</bean>

!-- spring load dataSource configuration property file -->
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
		<property name="locations">
			<list>
				<value>properties/database.properties</value>
			</list>
		</property>
	</bean>
	
<!-- dataSource -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName" value="${driver}" />
		<property name="url" value="${url}" />
		<property name="username" value="${username}" />
		<property name="password" value="${password}" />
	</bean>

三、POJO类.

本例是User实例类：

Java代码

packagecom.leadtone.ibatis.domain;
importjava.io.Serializable;
publicclassUserimplementsSerializable{
privateintid;
privateStringname;
privateStringpassword;
privateStringqx;
privateStringmemo;
publicintgetId(){
returnid;
}
/**
*setter和getter方法省略
*/

package com.leadtone.ibatis.domain;

import java.io.Serializable;

public class User implements Serializable{
	
	private int id;
	private String name;
	private String password;
	private String qx;
	private String memo;
	
	public int getId() {
		return id;
	}
               /**
	 *setter和getter方法省略	
           */

四、pojo类配置文件编写

本例是User.xml:(位置：com.leadtone.sqlmap.User.xml)

Xml代码

<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEsqlMap
PUBLIC"-//ibatis.apache.org//DTDSQLMap2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMapnamespace="User">
<typeAliasalias="user"type="com.leadtone.ibatis.domain.User"/>
<resultMapclass="user"id="UserResult">
<resultproperty="id"column="ID"/>
<resultproperty="name"column="LOGIN_NAME"/>
<resultproperty="password"column="PASS_WORD"/>
<resultproperty="qx"column="QX"/>
<resultproperty="memo"column="MEMO"/>
</resultMap>
<selectid="selectAllUsers"resultMap="UserResult">
select*fromuser
</select>
<selectid="selectUserById"parameterClass="int"resultMap="UserResult">
selectID,LOGIN_NAME,PASS_WORD,QX,MEMOfromuserwhereID=#id#
</select>
<selectid="selectUserByUser2"parameterClass="map"resultMap="UserResult">
selectID,LOGIN_NAME,PASS_WORD,QX,MEMOfromuserwhereLOGIN_NAME=#name#andPASS_WORD=#password#
</select>
<selectid="selectUserByUser"parameterClass="user"resultMap="UserResult">
selectID,LOGIN_NAME,PASS_WORD,QX,MEMOfromuserwhereLOGIN_NAME=#name#andPASS_WORD=#password#
</select>
<selectid="selectUsersByName"parameterClass="String"resultMap="UserResult">
selectID,LOGIN_NAME,PASS_WORD,QX,MEMOfromuserwheresnamelike'%$name$%'
</select>
<!--
<insertid="addUser"parameterClass="User">
insertintouser(ID,LOGIN_NAME,PASS_WORD,QX,MEMO)values(#id#,#name#,#birth#,#score#)
</insert>
-->
<updateid="updateUser"parameterClass="User">
updateusersetLOGIN_NAME=#name#,PASS_WORD=#password#,QX=#qx#,memo=#memo#whereID=#id#
</update>
<deleteid="deleteUser"parameterClass="int">
deletefromuserwhereID=#id#
</delete>
</sqlMap>

<?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="User">

	<typeAlias alias="user" type="com.leadtone.ibatis.domain.User"/>

	<resultMap class="user" id="UserResult">
		<result property="id" column="ID"/>	
		<result property="name" column="LOGIN_NAME"/>	
		<result property="password" column="PASS_WORD"/>	
		<result property="qx" column="QX"/>	
		<result property="memo" column="MEMO"/>	
	</resultMap>
	
	<!-- query all Users -->
	<select id="selectAllUsers" resultMap="UserResult">
		select * from user
	</select>
	
	<!-- query user by id -->
	<select id="selectUserById" parameterClass="int" resultMap="UserResult">
		select ID,LOGIN_NAME,PASS_WORD,QX,MEMO from user where ID=#id#
	</select>
	
	<!-- query user by user -->
	<select id="selectUserByUser2" parameterClass="map" resultMap="UserResult">
		select ID,LOGIN_NAME,PASS_WORD,QX,MEMO from user where LOGIN_NAME=#name# and PASS_WORD=#password#
	</select>
	
	
	<select id="selectUserByUser" parameterClass="user" resultMap="UserResult">
		select ID,LOGIN_NAME,PASS_WORD,QX,MEMO from user where LOGIN_NAME=#name# and PASS_WORD=#password#
	</select>
	
	<select id="selectUsersByName" parameterClass="String" resultMap="UserResult">
		select ID,LOGIN_NAME,PASS_WORD,QX,MEMO from user where sname like '%$name$%'
	</select>
	<!--  
	<insert id="addUser" parameterClass="User">
		insert into user(ID,LOGIN_NAME,PASS_WORD,QX,MEMO ) values(#id#,#name#,#birth#,#score#)
	</insert>
	-->
	
	<update id="updateUser" parameterClass="User">
		update user set LOGIN_NAME=#name#,PASS_WORD=#password#,QX=#qx#,memo=#memo# where  ID=#id#
	</update>
	
	<delete id="deleteUser" parameterClass="int">
		delete from user where ID=#id#
	</delete>

</sqlMap>

五、ibatis主配置文件编写【主配置文件只剩下sqlMap了，事务和数据源都交给spring进行配置和管理】

本例为sql-map-config.xml:(位置：)

Xml代码

<?xmlversion="1.0"encoding="UTF-8"?>
<!DOCTYPEsqlMapConfig
PUBLIC"-//ibatis.apache.org//DTDSQLMapConfig2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<sqlMapresource="com/leadtone/ibatis/sqlmap/User.xml"/>
</sqlMapConfig>

<?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>
     <sqlMap resource="com/leadtone/ibatis/sqlmap/User.xml"/>
</sqlMapConfig>

六、dao接口和接口实现

1）、本例为UserDao：

Java代码

packagecom.leadtone.ibatis.dao;
importjava.util.List;
importcom.leadtone.ibatis.domain.User;
publicinterfaceIUserDao{
publicList<User>queryAllUsers();
publicUserqueryUserById(intid);
publicUserqueryUserByUser(Useruser);
publicList<User>queryUserByName(Stringname);
publicvoidaddUser(Useruser);
publicvoidaddUserBySequence(Useruser);
publicvoidupdateUser(Useruser);
publicvoiddeleteUser(intid);
}

package com.leadtone.ibatis.dao;

import java.util.List;
import com.leadtone.ibatis.domain.User;

public interface IUserDao {
	public List<User> queryAllUsers();
	public User queryUserById(int id);
	public User queryUserByUser(User user);	
	public List<User> queryUserByName(String name);
	
	public void addUser(User user);
	public void addUserBySequence(User user);
	
	public void updateUser(User user);
	
	public void deleteUser(int id);
}

2）、实现类UserDaoImpl：

Java代码

packagecom.leadtone.ibatis.dao.ibatis;
importjava.util.List;
importorg.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
importcom.leadtone.ibatis.dao.IUserDao;
importcom.leadtone.ibatis.domain.User;
publicclassUserDaoImplextendsSqlMapClientDaoSupportimplementsIUserDao{
//注意这里的SqlMapClient接口的声明和下面的static静态代码都不需要了，
//因为这里继承了spring提供的ibatis模板template类SqlMapClientDaoSupport，不是用原生的SqlMapClient
//privatestaticSqlMapClientsqlMapClient=null;
/*
static{
Readerreader=null;
try{
reader=Resources.getResourceAsReader("com/leadtone/ibatis/sqlmap/SqlMapConfig.xml");
sqlMapClient=SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
}catch(IOExceptione){
e.printStackTrace();
}
}
*/
publicvoidaddUser(Useruser){
getSqlMapClientTemplate().insert("addUser",user);
}
publicUserqueryUserByUser(Useruser){
System.out.println("---UserDaoImpl---");
return(User)this.getSqlMapClientTemplate().queryForObject("selectUserByUser",user);
}
/*
*这里主要演示一个模拟用户登录系统验证的操作，主要用了queryUserByUser(Useruser)方法
*/
}

package com.leadtone.ibatis.dao.ibatis;

import java.util.List;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.leadtone.ibatis.dao.IUserDao;
import com.leadtone.ibatis.domain.User;

public class UserDaoImpl extends SqlMapClientDaoSupport implements IUserDao {

	//注意这里的SqlMapClient接口的声明和下面的static静态代码都不需要了，



                // 因为这里继承了spring提供的ibatis模板template类SqlMapClientDaoSupport，不是用原生的SqlMapClient


                
                 //private static SqlMapClient sqlMapClient=null;
	/*
	static{
		Reader reader=null;
		try {
			reader=Resources.getResourceAsReader("com/leadtone/ibatis/sqlmap/SqlMapConfig.xml");
			sqlMapClient=SqlMapClientBuilder.buildSqlMapClient(reader);
			
			reader.close();
		} catch (IOException e) {
			e.printStackTrace();
		}
		
	}
	*/
	public void addUser(User user) {
		getSqlMapClientTemplate().insert("addUser", user);
	}

	public User queryUserByUser(User user) {
		System.out.println("---UserDaoImpl---");
		return (User) this.getSqlMapClientTemplate().queryForObject("selectUserByUser", user);
		
	}
/*
* 这里主要演示一个模拟用户登录系统验证的操作，主要用了queryUserByUser(User user)方法
*/
}

3）、在spring配置文件中配置这个bean

Xml代码

<beanid="<SPANstyle="COLOR:#000000">sqlMapClient</SPAN>"class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<propertyname="configLocation"value="sqlmap/sql-map-config.xml"/>
<propertyname="dataSource"ref="dataSource"/>
</bean>
<beanid="userDao"class="com.leadtone.ibatis.dao.ibatis.UserDaoImpl">
<propertyname="sqlMapClient"ref="<SPANstyle="COLOR:#000000">sqlMapClient</SPAN>"></property>
</bean>

<!--sqlMapClient  -->
	<bean id="sqlMapClient " class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
		<property name="configLocation" value="sqlmap/sql-map-config.xml"/>
		<property name="dataSource" ref="dataSource" />
	</bean>

<!-- validate loginUser -->
	<!-- dao -->
	<bean id="userDao" class="com.leadtone.ibatis.dao.ibatis.UserDaoImpl">
	      <property name="sqlMapClient" ref="sqlMapClient "></property>
	</bean>

七、service接口和接口实现

1）IUserLoginService接口

Java代码

packagecom.leadtone.ibatis.service;
importcom.leadtone.ibatis.domain.User;
publicinterfaceIUserLoginService{
publicbooleanisLoginUser(Useruser);
}

package com.leadtone.ibatis.service;

import com.leadtone.ibatis.domain.User;

public interface IUserLoginService {
	public boolean isLoginUser(User user);
}

2）UserLoginSerivceImpl实现类

Java代码

packagecom.leadtone.ibatis.service.impl;
importcom.leadtone.ibatis.dao.IUserDao;
importcom.leadtone.ibatis.domain.User;
importcom.leadtone.ibatis.service.IUserLoginService;
publicclassUserLoginServiceImplimplementsIUserLoginService{
privateIUserDaouserDao;
publicIUserDaogetUserDao(){
returnuserDao;
}
publicvoidsetUserDao(IUserDaouserDao){
this.userDao=userDao;
}
publicbooleanisLoginUser(Useruser){
returnnull!=userDao.queryUserByUser(user)?true:false;
}
}

package com.leadtone.ibatis.service.impl;

import com.leadtone.ibatis.dao.IUserDao;
import com.leadtone.ibatis.domain.User;
import com.leadtone.ibatis.service.IUserLoginService;

public class UserLoginServiceImpl implements IUserLoginService {

	private IUserDao userDao;

	public IUserDao getUserDao() {
		return userDao;
	}
	
	public void setUserDao(IUserDao userDao) {
		this.userDao = userDao;
	}
	public boolean isLoginUser(User user) {
		return null!=userDao.queryUserByUser(user)?true:false;
	}

}

3）在spring中注册这个bean

Xml代码

<beanid="userLoginService"class="com.leadtone.ibatis.service.impl.UserLoginServiceImpl">
<propertyname="userDao"ref="userDao"></property>
</bean>

<!-- service -->
<bean id="userLoginService" class="com.leadtone.ibatis.service.impl.UserLoginServiceImpl">
        <property name="userDao" ref="userDao"></property>
</bean>

八、struts action实现及struts-config.xml配置(牵扯到struts和spring的整合)

1）action：

Java代码

packagecom.leadtone.web.struts.action;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importorg.apache.struts.action.Action;
importorg.apache.struts.action.ActionForm;
importorg.apache.struts.action.ActionForward;
importorg.apache.struts.action.ActionMapping;
importcom.leadtone.ibatis.

顶

踩

猜你在找

<script type="text/javascript" src="http://csdnim.qtmojo.com/main/s?user=csdn%7Cblog%7Cbanner2&db=csdnim&border=0&local=yes&js=ie" charset="gbk"></script>

查看评论

* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场