Spring+Ibatis整合开发实例

痛定思痛。 2022-08-14 03:40 180阅读 0赞

首先建立好数据库，序列和引擎，实现主键的自动增长，这个内容我已经在我的一篇文章中实现，这里我就不在重复。

下面来说一下我整合spring和Ibatis的过程

1、创建实体类，和数据库表的字段对应 （注意这里我写了一个无参的构造函数）

public class User {
    	private BigDecimal id;
    	private String user_name;
    	private String password;
    	/**
    	 * 注意这里写一个无参的构造函数,因为后面我遇到了一个错误，所以这里必须留着
    	 */
    	public User() {
    		super();
    	}
    	public BigDecimal getId() {
    		return id;
    	}
    	public void setId(BigDecimal id) {
    		this.id = id;
    	}
    	public User( String user_name, String password) {
    		this.user_name = user_name;
    		this.password = password;
    	}
    	public String getUser_name() {
    		return user_name;
    	}
    	public void setUser_name(String user_name) {
    		this.user_name = user_name;
    	}
    	public String getPassword() {
    		return password;
    	}
    	public void setPassword(String password) {
    		this.password = password;
    	}
    }

2、创建DAO接口

public interface IDAO {
    	public void insertToTB(User user);
    	public List getList();
    	public User getById(BigDecimal id);
    	public void update(User user);
    	public void delete(BigDecimal id);
    }

3、ibatis.xml配置文件

<?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_oracle">
    	<typeAlias alias="user" type="com.spring.ibatis.User" />
    	<resultMap class="user" id="ibatisTest">
    		<result property="id" column="id" jdbcType="DECIMAL" />
    		<result property="user_name" column="user_name" jdbcType="VARCHAR2" />
    		<result property="password" column="password" jdbcType="VARCHAR2" />
    	</resultMap>
    
    
    	<insert id="insertToTB">
    		insert into
    		td(id,user_name,password)values(#id#,#user_name#,#password#)
    	</insert>
    	<select id="getAllUsers" resultMap="ibatisTest">
    		select * from td
    	</select>
    
    
    	
    	<select id="getUserById" resultMap="ibatisTest">
    		select *from td where
    		id=#value#
    	</select>
    
    
    	
    	<update id="updateUsers" parameterClass="user">
    		update td set
    		user_name=#user_name# where id=#id#
    	</update>
    
    
    	
    	<delete id="deleteUsers">
    		delete from td where id=#value#
    	</delete>
    </sqlMap>

4、sqlmap-config.xml配置文件

<!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="ibatis.xml" />
    </sqlMapConfig>

5、spring配置文件applicationContext.xml

?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans"
    	xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx"
    	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
    
    	xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
            http://www.springframework.org/schema/conte xt
            http://www.springframework.org/schema/context/spring-context-2.5.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop-2.0.xsd">
    
    	
    	<bean id="dataSource"
    		class="org.springframework.jdbc.datasource.DriverManagerDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"></property>
    		<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"></property>
    		<property name="username" value="scott"></property>
    		<property name="password" value="123"></property>
    	</bean>
    
    	<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
    		
    		<property name="configLocation" value="classpath:sqlmap-config.xml" />
    		<property name="dataSource" ref="dataSource"></property>
    	</bean>
    
    	<bean id="iDAOImpl" class="com.spring.ibatis.IDAOImpl">
    		<property name="sqlMapClient" ref="sqlMapClient"></property>
    	</bean>
    </beans>

6、DAO实现类

public class IDAOImpl extends SqlMapClientDaoSupport implements IDAO{
    
    	/**
    	 * 向数据库中插入数据
    	 */
    	@Override
    	public void insertToTB(User user) {
    		getSqlMapClientTemplate().insert("insertToTB", user);
    	}
    
    	/**
    	 * 获取所有用户
    	 */
    	@Override
    	public List getList() {
    		return getSqlMapClientTemplate().queryForList("getAllUsers", null);
    	}
    
    	/**
    	 * 通过id获取用户
    	 */
    	@Override
    	public User getById(BigDecimal id) {
    		return (User) getSqlMapClientTemplate().queryForObject("getUserById",id);
    	}
    
    	/**
    	 * 更新用户
    	 */
    	@Override
    	public void update(User user) {
    		getSqlMapClientTemplate().update("updateUsers", user);
    	}
    
    	/**
    	 * 删除用户
    	 */
    	@Override
    	public void delete(BigDecimal id) {
    		getSqlMapClientTemplate().delete("deleteUsers", id);
    		
    	}
    }

7、测试代码

public class batisTest {
    	@Test
    	public void test() {
    		ApplicationContext ctx=new ClassPathXmlApplicationContext("/applicationContext.xml");
    		IDAO idaoImpl=(IDAO) ctx.getBean("iDAOImpl");
    		/**
    		 * 向数据库中插入数据
    		 */
    		idaoImpl.insertToTB(new User("cw","1235"));
    		
    		
    		/**
    		 * System.out.println("获得全部查询列表");
    		 */
    		List result=new ArrayList();
    		result=idaoImpl.getList();
    		for(Iterator iter=result.iterator();iter.hasNext();){
    			User u=(User) iter.next();
    			System.out.println("name:"+u.getUser_name()+" id:"+u.getId()+" password:"+u.getPassword());
    		}
    		
    		/**
    		 * 通过id获得用户对象
    		 */
    		User u=idaoImpl.getById(new BigDecimal(22));
    		System.out.println("name:"+u.getUser_name()+" id:"+u.getId()+" password:"+u.getPassword());
    		
    		
    		/**
    		 * 更新用户对象
    		 */
    		System.out.println("更新用户对象前");
    		List result1=new ArrayList();
    		result1=idaoImpl.getList();
    		for(Iterator iter=result1.iterator();iter.hasNext();){
    			User u1=(User) iter.next();
    			System.out.println("name:"+u1.getUser_name()+" id:"+u1.getId()+" password:"+u1.getPassword());
    		}
    		User u3=idaoImpl.getById(new BigDecimal(22));
    		u3.setUser_name("today");
    		idaoImpl.update(u3);
    		System.out.println("更新用户对象后");
    		List result2=new ArrayList();
    		result2=idaoImpl.getList();
    		for(Iterator iter=result2.iterator();iter.hasNext();){
    			User u4=(User) iter.next();
    			System.out.println("name:"+u4.getUser_name()+" id:"+u4.getId()+" password:"+u4.getPassword());
    		}
    		
    		/**
    		 * 删除用户
    		 */
    		idaoImpl.delete(new BigDecimal(21));
    	}
    }

之前我是直接在spring中实现了oracle数据库的增、删、查、改,这里我通过学习Spring和Ibatis的整合，也实现了另一种  
方式的oracel数据库的增、删、查、改