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.iteye.com/blog/970036