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; } }
相关推荐
yupi0 2020-10-10
spring 2020-08-18
编程点滴 2020-07-29
幸运小侯子 2020-07-05
itjavashuai 2020-07-04
qingjiuquan 2020-06-29
shushan 2020-06-25
小鱿鱼 2020-06-22
咻pur慢 2020-06-18
melonjj 2020-06-17
qingjiuquan 2020-06-13
neweastsun 2020-06-05
小鱿鱼 2020-06-05
mxcsdn 2020-05-31
吾日五省我身 2020-05-27
牧场SZShepherd 2020-05-27
sweetgirl0 2020-05-14