MyBatis And Spring Demo

新风花雪月

Spring相关配置

//数据源
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></property>
<property name="url" value="jdbc:sqlserver://127.0.0.1:1433;databaseName=ibatisDB"></property>
<property name="username" value="sa"></property>
<property name="password" value="zhaoyu"></property>
</bean>
//MyBatis支持
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="classpath:sqlMapConfig.xml"></property>
<property name="dataSource" ref="dataSource"></property>
</bean>
<bean id="dao" class="com.dao.impl.DaoImpl">
//注入
<property name="sqlMapClient" ref="sqlMapClient"></property>
</bean>
//事务管理器
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource">
<ref local="dataSource"/>
</property>
</bean>
//通过引用bean方式配置事物(不是更加方便的设置切入点方式)
<bean id="DaoProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>
<property name="target">
<ref local="dao"/>
</property>
<property name="transactionAttributes">
<props>
<prop key="search*">PROPAGATION_REQUIRED,readOnly</prop>
<prop key="*">PROPAGATION_REQUIRED</prop>
</props>
</property>
</bean>

MyBatis相关配置

<?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> <!-- 都写在spring配置文件中，这里只需要配置映射文件 -->
<sqlMap resource="com/entity/User.xml"/>
</sqlMapConfig>


实体类

package com.entity;
public class User {
private int id;
private String name;
private int age;
//省略get set
@Override
public String toString() {
// TODO Auto-generated method stub
return "编号："+id+"　姓名："+name+"　年龄："+age;
}
}


配置SQL

<?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.entity.User"/>  //alias别名 type类型
<select id="getUsers" resultClass="user" >
<![CDATA[select * from t_user]]>
</select>
<insert id="insert" parameterClass="user">
insert into t_user(name,age) values(#name#,#age#)
</insert>
<update id="update" parameterClass="java.util.Map">
<![CDATA[update t_user set name=#name#,age=#age# where id = #id#]]>
</update>
<delete id="delete" parameterClass="int">
<![CDATA[delete from t_user where id = #id#]]>
</delete>
</sqlMap>


DAO代码

package com.dao.impl;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.orm.ibatis.SqlMapClientCallback;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import com.dao.Dao;
import com.entity.User;
import com.ibatis.sqlmap.client.SqlMapExecutor;
public class DaoImpl extends SqlMapClientDaoSupport implements Dao {
public void save(User user) {
getSqlMapClientTemplate().insert("insert", user);
}
public void delete(int id) {
getSqlMapClientTemplate().delete("delete",id);
}
public void update(String name, int age, int id) {
Map<String,Object> map = new HashMap<String,Object>();
map.put("name", name);
map.put("age", age);
map.put("id", id);
getSqlMapClientTemplate().update("update",map);
}
@SuppressWarnings("unchecked")
public List<User> searchUsers() {
return getSqlMapClientTemplate().queryForList("getUsers");
}
/**
* 类似hibernate的回调接口,在此是一个demo
* @return
*/
public List<User> demo(){
getSqlMapClientTemplate().execute(new SqlMapClientCallback() {
public Object doInSqlMapClient(SqlMapExecutor sqlMap) throws SQLException {
//sqlMap.queryForObject(arg0)
return null;
}
});
return null;
}
}


相关调用代码

package com;
import java.util.Iterator;
import java.util.List;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import com.dao.Dao;
import com.entity.User;
public class Demo {
public static void main(String[] args) {
save();
showUser();
update();
delete();
}
//保存
public static void save(){
Dao dao = daoFartory();
User user = new User("zhaoliang228",24);
dao.save(user);
}
//修改
public static void update(){
Dao dao = daoFartory();
dao.update("zl", 100, 5);
}
public static void delete(){
Dao dao = daoFartory();
dao.delete(6);
}
//查询
public static void showUser(){
Dao dao = daoFartory();
List<User> users = dao.searchUsers();
Iterator<User> i = users.iterator();
while(i.hasNext()){
System.out.println(i.next());
}
}
public static Dao daoFartory(){
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
Dao dao = (Dao) ctx.getBean("dao");
return dao;
}
}