Struts2+spring+MyBatis增删改查操作（2）

编写ISBookServices接口类

package com.dou.book.data.services;

import java.util.List;

import org.springframework.transaction.annotation.Transactional;

import com.dou.book.data.pojo.SBook;

@Transactional
@SuppressWarnings("unchecked")
public interface ISBookServices {
    /**
     * 添加一本图书至数据库中
     *
     * @param book
     *            图书对象
     * @throws RuntimeException
     */
    public void saveBook(SBook book) throws RuntimeException;

    /**
     * 删除图书信息
     *
     * @param id
     *            ID编码
     * @throws RuntimeException
     */
    public void removeBook(int id) throws RuntimeException;

    /**
     * 通过出版社查找此出版社出版的所有图书列表
     *
     * @param publisher
     *            出版社名称
     * @return 返回特定出版社下的所有图书列表
     * @throws RuntimeException
     */
    public List<SBook> getBooksByPublisher(String publisher)
            throws RuntimeException;

    /**
     * 通过图书对应的唯一的ISBN号查找图书
     *
     * @param isbn
     *            图书唯一的ISBN号码
     * @return 返回此ISBN号对应的图书
     * @throws RuntimeException
     */
    public SBook getBookByISBN(String isbn) throws RuntimeException;

    /**
     * 更新一本图书的信息
     *
     * @param book
     *            图书对象
     * @throws RuntimeException
     */
    public void updateBook(SBook book) throws RuntimeException;

    /**
     * 查找库中所有的图书
     *
     * @return 返回图书列表
     * @throws RuntimeException
     */
    public List findAllBook() throws RuntimeException;

    /**
     * 通过图书ID号得到图书对象
     *
     * @param id
     *            图书ID号码
     * @return 返回此ID对应的图书信息
     * @throws RuntimeException
     */
    public SBook getBookById(int id) throws RuntimeException;
}

编写ISBookServices接口的实现类SBookServices

package com.dou.book.data.services.impl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.dou.book.data.ISBookMapper;
import com.dou.book.data.pojo.SBook;
import com.dou.book.data.services.ISBookServices;

@Service("bookServices")
@SuppressWarnings("unchecked")
public class SBookServices implements ISBookServices {
    @Autowired    
    ISBookMapper bookMapper;

    public List findAllBook() throws RuntimeException {
        return bookMapper.findAllBook();
    }

    public SBook getBookByISBN(String isbn) throws RuntimeException {
        return bookMapper.findBookByISBN(isbn);
    }

    public List<SBook> getBooksByPublisher(String publisher)
            throws RuntimeException {
        return bookMapper.findBooksByPublisher(publisher);
    }

    public void removeBook(int id) throws RuntimeException {
        bookMapper.deleteBook(id);
    }

    public void saveBook(SBook book) throws RuntimeException {
        bookMapper.saveBook(book);
    }

    public void updateBook(SBook book) throws RuntimeException {
        bookMapper.updateBook(book);
    }

    public SBook getBookById(int id) throws RuntimeException {
        return bookMapper.findBookById(id);
    }

}

编写ISBookMapper类

package com.dou.book.data;

import java.util.List;

import com.dou.book.data.pojo.SBook;

public interface ISBookMapper {
    /**
     * 添加一本图书至数据库中
     *
     * @param book
     *            图书对象
     * @throws RuntimeException
     */
    public void saveBook(SBook book) ;

    /**
     * 删除图书信息
     *
     * @param id
     *            ID编码
     * @throws RuntimeException
     */
    public void deleteBook(int id) throws RuntimeException;

    /**
     * 通过出版社查找此出版社出版的所有图书列表
     *
     * @param publisher
     *            出版社名称
     * @return 返回特定出版社下的所有图书列表
     * @throws RuntimeException
     */
    public List<SBook> findBooksByPublisher(String publisher)
            throws RuntimeException;

    /**
     * 通过图书对应的唯一的ISBN号查找图书
     *
     * @param isbn
     *            图书唯一的ISBN号码
     * @return 返回此ISBN号对应的图书
     * @throws RuntimeException
     */
    public SBook findBookByISBN(String isbn) throws RuntimeException;

    /**
     * 更新一本图书的信息
     *
     * @param book
     *            图书对象
     * @throws RuntimeException
     */
    public void updateBook(SBook book) throws RuntimeException;

    /**
     * 查找库中所有的图书
     *
     * @return 返回图书列表
     * @throws RuntimeException
     */
    public List<SBook> findAllBook() ;

    /**
     * 通过ID查找特定的图书
     *
     * @param id
     *            图书的ID号
     * @return 返回此ID对应的图书信息
     * @throws RuntimeException
     */
    public SBook findBookById(int id) throws RuntimeException;
}

编写映射文件SBookMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dou.book.data.ISBookMapper">

    <resultMap type="SBook" id="sBookResultMap">
        <id property="id" column="id" />
        <result property="title" column="title" />
        <result property="author" column="author" />
        <result property="total" column="total" />
        <result property="price" column="price" />
        <result property="isbn" column="isbn" />
        <result property="publisher" column="publisher" />       
    </resultMap>

    <!-- 查询班级list -->
    <select id="findAllBook" resultMap="sBookResultMap">
        SELECT * from sbook;
    </select>

    <insert id="saveBook" parameterType="SBook">
        <selectKey keyProperty="id" resultType="int" order="BEFORE">
            SELECT LAST_INSERT_ID() AS VALUE
        </selectKey>
        INSERT INTO sbook(
         title
        ,author
        ,total
        ,price
        ,isbn
        ,publisher
        )
            VALUES(
            #{title}
            ,#{author}
            ,#{total}
            ,#{price}
            ,#{isbn}
            ,#{publisher}
            )
    </insert>
    <select id="findBookById" parameterType="int" resultMap="sBookResultMap">
        SELECT * from sbook where id = #{id} ;
    </select>
    <update id="updateBook" parameterType="int">  
        update sbook set title = #{title}, author = #{author},
        total = #{total}, price = #{price}, isbn = #{isbn}, publisher = #{publisher}
        where id = #{id}  
    </update>
    <delete id="deleteBook" parameterType="int">  
        delete from sbook where id = #{id}  
    </delete> 

</mapper>

一些配置文件

applicationContext-common.xml

<?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:jdbc="http://www.springframework.org/schema/jdbc"
      xmlns:context="http://www.springframework.org/schema/context"
      xsi:schemaLocation="      
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.0.xsd
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd"
     default-autowire="byName">
   <context:annotation-config />
    <!-- 导入属性配置文件 -->
    <context:property-placeholder location="classpath:mysql.properties" />
    <context:component-scan base-package="com.dou.book" />
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
    </bean>

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource" />
    </bean>

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="configLocation" value="classpath:mybatis-config.xml" />
        <property name="dataSource" ref="dataSource" />
    </bean>
  <bean id="bookMapper" class="org.mybatis.spring.MapperFactoryBean">
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
        <property name="mapperInterface" value="com.dou.book.data.ISBookMapper"/>       
    </bean>

</beans>

mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases>
        <typeAlias alias="SBook" type="com.dou.book.data.pojo.SBook" />       
    </typeAliases>
    <mappers>
        <mapper resource="com/dou/book/data/mappers/SBookMapper.xml" />       
    </mappers>
</configuration>       

mysql.properties文件

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/book_mybatis?user=root&password=111111&useUnicode=true&characterEncoding=UTF-8

struts.properties文件

struts.objectFactory = spring
struts.multipart.saveDir = /tmp
struts.multipart.maxSize =1000000000

sql代码：

CREATE TABLE `sbook` (
  `id` INTEGER(11) NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
  `author` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `total` INTEGER(11) DEFAULT NULL,
  `price` FLOAT DEFAULT NULL,
  `isbn` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL,
  `publisher` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=13 CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='InnoDB free: 11264 kB';

 

 

源代码下载：

http://dingqinghu.javaeye.com/blog/970036