1.BooksMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.vx202158.dao.BooksMapper">
<!-- 添加 -->
<insert id="addBooks" parameterType="com.vx202158.pojo.Books">
insert into books
values (#{bookId}, #{bookName}, #{bookCounts}, #{datail});
</insert>
<!--删除-->
<delete id="delBooks" parameterType="int">
delete
from books
where bookId = #{bookId}
</delete>
<!-- 修改 -->
<update id="updateBooks" parameterType="com.vx202158.pojo.Books">
update books
set bookName=#{bookName},
bookCounts= #{bookCounts},
datail= #{datail}
where bookId = #{bookId}
</update>
<!-- 查询 -->
<select id="queryBooks" parameterType="int" resultType="com.vx202158.pojo.Books">
select * from books where bookId = #{bookId}
</select>
<!-- 查询所有-->
<select id="queryAllBooks" resultType="com.vx202158.pojo.Books">
select * from books
</select>
</mapper>
2.BooksMapper
package com.vx202158.dao;
import com.vx202158.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BooksMapper {
//添加一本书
int addBooks(Books books);
//删除一本书
int delBooks(@Param("bookId") int bookId);
//修改一本书
int updateBooks(Books books);
//查询一本书
Books queryBooks(@Param("bookId") int bookId);
//查询所有书
List<Books> queryAllBooks();
}
3.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>
<package name="com.vx202158.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/ssmbuild?serverTimezone=UTC"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<mappers><mapper resource="com/vx202158/dao/BooksMapper.xml"></mapper></mappers>
</configuration>
4.测试类
@Test
public void test2() throws IOException {
InputStream resourceAsStream = Resources.getResourceAsStream("mybatis-config.xml");
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = build.openSession(true);
List<Object> objects = sqlSession.selectList("sqlSession");
System.out.println("objects = " + objects);
}