【Mybatis 之应用篇】 5_Mybatis总结（附20道练习题以及答案）
生活随笔
收集整理的這篇文章主要介紹了
【Mybatis 之应用篇】 5_Mybatis总结（附20道练习题以及答案）
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
文章目錄
- Mybatis創建流程總結
- 1.mybatis核心配置文件
- 2.配置數據庫連接配置文件
- 3.寫生成SQLSession對象
- 4.測試用例的設置
- 5.綜合練習
- (1) BillDao
- (2) ProviderDao
- (3) RoleDao
- (4) UserDao
Mybatis創建流程總結
1.mybatis核心配置文件
mybatis-config.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"> <!--configuration核心配置文件--> <configuration><!--引入外部文件--><properties resource="db.properties" /><!--設置一些內容，如：日志--><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings><!--設置別名，設置一個較短的名字--><typeAliases><!--1.可以減少類完全限定名的冗余--><!-- <typeAlias type="entity.User" alias="User"></typeAlias>--><!--可以設置包名，此時引用的類名是類的小寫--><package name="entity"></package></typeAliases><!--這是數據庫驅動配置--><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="${driver}"/><property name="url" value="${url}"/><property name="username" value="${username}"/><property name="password" value="${password}"/></dataSource></environment></environments><!--每一個Mapper.xml都需要在Mybatis核心配置文件中注冊--><!--綁定接口--><mappers><mapper class="dao.BlogMapper"/></mappers> </configuration>在這一核心配置文件中，有如下標簽（有嚴格的先后順序）：properties,settings,typeAliases,typeHandlers,objectFactory,objectWrapperFactory,reflectorFactory,plugins,environments,databaseIdProvider,mappers
2.配置數據庫連接配置文件
db.properties
driver=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/smbms?characterEncoding=utf8&serverTimezone=UTC&useUnicode=true username=root password=root3.寫生成SQLSession對象
public class MybatisUtil {private static SqlSessionFactory sqlSessionFactory;static {try {//使用Mybatis第一步：獲取sqlSessionFactory對象String resource = "mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);} catch (IOException e) {e.printStackTrace();}}//既然有了 SqlSessionFactory，顧名思義，我們就可以從中獲得 SqlSession 的實例了。// SqlSession 完全包含了面向數據庫執行 SQL 命令所需的所有方法。public static SqlSession getSqlSession() {return sqlSessionFactory.openSession(true);} }4.設立實體類
5.設立Mapper接口與接口對應的Mapper.xml
Mapper.java(接口)
public interface BlogMapper {int addBlog(Blog blog);//查詢博客List<Blog> findBlogByIF(Map map);//根據title或author屬屬性查詢List<Blog> findBlogByChoose(Map map);//更新一條信息void updateBlogById(Map map); }Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--configuration核心配置文件,namespace中確定與那個java接口對接--> <mapper namespace="dao.BlogMapper"><!--id是方法名，parameterType是參數類型，resultType是返回值類型--><insert id="addBlog" parameterType="blog">insert into mybatis.blog(id, title, author, create_time, views)values(#{id}, #{title}, #{author}, #{createTime}, #{views});</insert><select id="findBlogByIF" parameterType="map" resultType="blog">select * from mybatis.blog where 1=1<if test="title != null">and title = #{title}</if><if test="author != null">and author = #{author}</if></select><select id="findBlogByChoose" parameterType="map" resultType="blog">select * from mybatis.blog<where><choose><when test="title != null">and title = #{title}</when><when test="author != null">and author = #{author}</when><otherwise>1=1</otherwise></choose></where></select><update id="updateBlogById" parameterType="map">update mybatis.blog<set><if test="title != null">title = #{title}</if><if test="author != null">author = #{author}</if></set><where><if test="id != null">id = #{id}</if><if test="views != null">views = #{views}</if></where></update> </mapper>4.測試用例的設置
public class BlogTest {@Testpublic void addaBlogTest(){SqlSession sqlSession = MybatisUtil.getSqlSession();BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);Blog blog = new Blog();blog.setId(IDUtil.getId());blog.setAuthor("ffideal");blog.setTitle("跟著大佬學SSM");blog.setCreateTime(new Date());blog.setViews(10086);mapper.addBlog(blog);sqlSession.close();}@Testpublic void testIF(){SqlSession sqlSession = MybatisUtil.getSqlSession();BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);Map<Object,Object> map = new HashMap<>();map.put("title","SSM");map.put("author","ffideal");List<Blog> blogs = mapper.findBlogByIF(map);for(Blog blog : blogs){System.out.println(blog);}sqlSession.close();}@Testpublic void testChoose(){SqlSession sqlSession = MybatisUtil.getSqlSession();BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);HashMap<Object, Object> map = new HashMap<>();map.put("title","SSM");mapper.findBlogByChoose(map);sqlSession.close();}@Testpublic void testWhere(){SqlSession sqlSession = MybatisUtil.getSqlSession();BlogMapper mapper = sqlSession.getMapper(BlogMapper.class);HashMap<Object, Object> map = new HashMap<>();map.put("title","test");map.put("id","160e85c2343c4c7ea19add8662b7b4dd");mapper.updateBlogById(map);sqlSession.close();} }5.綜合練習
配置文件
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"> <!--configuration核心配置文件--> <configuration><!--引入外部文件--><properties resource="database.properties" /><settings><setting name="logImpl" value="STDOUT_LOGGING"/></settings><!--設置別名，設置一個較短的名字--><typeAliases><!--1.可以減少類完全限定名的冗余--><!-- <typeAlias type="entity.User" alias="User"></typeAlias>--><!--可以設置包名，此時引用的類名是類的小寫--><package name="entity"></package><package name="dao"></package></typeAliases><!--這是數據庫驅動配置--><environments default="development"><environment id="development"><transactionManager type="JDBC"/><dataSource type="POOLED"><property name="driver" value="${driver}"/><property name="url" value="${url}"/><property name="username" value="${username}"/><property name="password" value="${password}"/></dataSource></environment></environments><!--每一個Mapper.xml都需要在Mybatis核心配置文件中注冊--><!--綁定接口--><mappers><mapper class="dao.bill.BillDao"/><mapper class="dao.provider.ProviderDao"/><mapper class="dao.role.RoleDao"/><mapper class="dao.user.UserDao"/></mappers> </configuration>建立會話工廠
public class MybatisUtil {private static SqlSessionFactory sqlSessionFactory;static {try {//使用Mybatis第一步：獲取sqlSessionFactory對象String resource = "mybatis-config.xml";InputStream inputStream = Resources.getResourceAsStream(resource);sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);} catch (IOException e) {e.printStackTrace();}}//既然有了 SqlSessionFactory，顧名思義，我們就可以從中獲得 SqlSession 的實例了。// SqlSession 完全包含了面向數據庫執行 SQL 命令所需的所有方法。public static SqlSession getSqlSession() {return sqlSessionFactory.openSession(true);}(1) BillDao
BillDao.java
public interface BillDao {/*** 增加訂單* @param bill* @return* @throws Exception*/public int add(Bill bill)throws Exception;/*** 通過查詢條件獲取供應商列表-模糊查詢-getBillList* @param bill* @return* @throws Exception*/public List<Bill> getBillList(Bill bill)throws Exception;/*** 通過delId刪除Bill* @param delId* @return* @throws Exception*/public int deleteBillById(String delId)throws Exception;/*** 通過billId獲取Bill* @param id* @return* @throws Exception*/public Bill getBillById(String id)throws Exception;/*** 修改訂單信息* @param bill* @return* @throws Exception*/public int modify(Bill bill)throws Exception;/*** 根據供應商ID查詢訂單數量* @param providerId* @return* @throws Exception*/public int getBillCountByProviderId(String providerId)throws Exception;}BillDao.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--configuration核心配置文件--> <mapper namespace="dao.bill.BillDao"><insert id="add" parameterType="bill">INSERT INTO smbms.smbms_bill (id, billCode, productName, productDesc, productUnit, productCount, totalPrice, isPayment, createdBy, creationDate, modifyBy, modifyDate, providerId)VALUES (#{id}, #{billCode}, #{productName}, #{productDesc}, #{productUnit}, #{productCount}, #{totalPrice}, #{isPayment}, #{createdBy}, #{creationDate}, #{modifyBy}, #{modifyDate}, #{providerId});</insert><!--通過查詢條件獲取供應商列表-模糊查詢-可以通過名稱、類別、價格來做模糊查詢。使用choose/when/otherwise--> <!-- <select id="getBillList" parameterType="bill" resultType="bill">select * from smbms.smbms_bill<where><if test="productName != null">and productName like "%"#{productName}"%"</if><if test="productDesc != null">and productDesc like "%"#{productDesc}"%"</if><if test="productCount != null">and productCount like "%"#{productCount}"%"</if></where></select>--><select id="getBillList" parameterType="bill" resultType="bill">select * from smbms.smbms_bill<where><if test="productName != null">and productName like CONCAT('%',#{productName},'%')</if><if test="productDesc != null">and productDesc like CONCAT('%',#{productDesc},'%')</if><if test="productCount != null">and productCount like CONCAT('%',#{productCount},'%')</if></where></select><!--通過delId刪除Bill--><delete id="deleteBillById" parameterType="String">delete from smbms.smbms_bill<where>id = #{id}</where></delete><!--通過billId獲取Bill--><select id="getBillById" parameterType="String" resultType="bill">select * from smbms.smbms_bill<where>id = #{id}</where></select><!--修改訂單信息--><update id="modify" parameterType="bill">update smbms.smbms_bill<set><if test="productName != null">productName = #{productName},</if><if test="productDesc != null">productDesc = #{productDesc},</if><if test="productUnit != null">productUnit = #{productUnit},</if><if test="productCount != null">productCount = #{productCount},</if></set><where>id = #{id}</where></update><!--根據供應商ID查詢訂單數量--><select id="getBillCountByProviderId" parameterType="String" resultType="int">select count(*) from smbms.smbms_bill<where>providerId = #{providerId}</where></select> </mapper>BillDaoTest.java
package dao.bill;import Utils.MybatisUtil; import entity.Bill; import org.apache.ibatis.session.SqlSession; import org.junit.Test;import java.math.BigDecimal; import java.util.Date; import java.util.List;/*** @ClassName: BillDaoTest* @description:* @author: FFIDEAL* @Date: 2020/5/31 10:53*/public class BillDaoTest {@Testpublic void testAdd() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);Bill bill = new Bill();bill.setId(18);bill.setBillCode("BILL2016_018");bill.setProductName("娃哈哈");bill.setProductDesc("飲料");bill.setProductUnit("瓶");bill.setProductCount(BigDecimal.valueOf(2000.00));bill.setTotalPrice(BigDecimal.valueOf(4000.00));bill.setIsPayment(2);bill.setCreatedBy(1);bill.setCreationDate(new Date());bill.setProviderId(2);mapper.add(bill);sqlSession.close();}/*測試getBillList*/@Testpublic void testGetBillList() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);Bill bill = new Bill();//bill.setProductCount(BigDecimal.valueOf(2000.00));bill.setProductName("油");List<Bill> billList = mapper.getBillList(bill);for (Bill bill1 : billList) {System.out.println(bill1);}sqlSession.close();}/*測試deleteBillById*/@Testpublic void testDeleteBillById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);mapper.deleteBillById("18");sqlSession.close();}/*通過billId獲取Bill*/@Testpublic void testGetBillById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);mapper.getBillById("17");sqlSession.close();}/*修改訂單信息*/@Testpublic void testModify() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);Bill bill = new Bill();bill.setId(12);bill.setProductName("修改訂單信息");mapper.modify(bill);sqlSession.close();}/*根據供應商ID查詢訂單數量*/@Testpublic void testGetBillCountByProviderId() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();BillDao mapper = sqlSession.getMapper(BillDao.class);int billCountByProviderId = mapper.getBillCountByProviderId("14");System.out.println("一共有" + billCountByProviderId + "條。");sqlSession.close();} }(2) ProviderDao
ProviderDao.java
public interface ProviderDao {/*** 增加供應商* @param provider* @return* @throws Exception*/public int add(Provider provider)throws Exception;/*** 通過供應商名稱、編碼獲取供應商列表-模糊查詢-providerList* @param proName* @return* @throws Exception*/public List<Provider> getProviderList(@Param("proName") String proName, @Param("proCode")String proCode)throws Exception;/*** 通過proId刪除Provider* @param delId* @return* @throws Exception*/public int deleteProviderById( String delId)throws Exception;/*** 通過proId獲取Provider* @param id* @return* @throws Exception*/public Provider getProviderById(String id)throws Exception;/*** 修改用戶信息* @param user* @return* @throws Exception*/public int modify(Provider provider)throws Exception;}ProviderDao.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--configuration核心配置文件--> <mapper namespace="dao.provider.ProviderDao"><!--增加供應商--><insert id="add" parameterType="provider">insert into smbms.smbms_provider(id, proCode, proName, proDesc, proContact, proPhone, proAddress, proFax, createdBy, creationDate, modifyDate, modifyBy)values(#{id}, #{proCode}, #{proName}, #{proDesc}, #{proContact}, #{proPhone}, #{proAddress}, #{proFax}, #{createdBy}, #{creationDate}, #{modifyDate}, #{modifyBy} )</insert><!--通過供應商名稱、編碼獲取供應商列表-模糊查詢-providerList--><select id="getProviderList" parameterType="String" resultType="provider">select * from smbms.smbms_provider<where><if test="proName != null">and proName like CONCAT('%',#{proName},'%')</if><if test="proCode != null">and proCode like CONCAT('%',#{proCode},'%')</if></where></select><!--通過proId刪除Provider--><delete id="deleteProviderById" parameterType="String">delete from smbms.smbms_provider<where>id = #{id}</where></delete><!--通過proId獲取Provider--><select id="getProviderById" parameterType="String" resultType="provider">select * from smbms.smbms_provider<where>id = #{id}</where></select><!--修改用戶信息proCode, proName, proDesc, proContact, proPhone--><update id="modify" parameterType="provider">update smbms.smbms_provider<set><if test="proCode != null">proCode = #{proCode},</if><if test="proName != null">proName = #{proName},</if><if test="proDesc != null">proDesc = #{proDesc},</if><if test="proContact">proContact = #{proContact},</if><if test="proPhone">proPhone = #{proPhone},</if></set><where>id = #{id}</where></update> </mapper>ProviderDaoTest.java
package dao.provider;import Utils.MybatisUtil; import entity.Provider; import org.apache.ibatis.session.SqlSession; import org.junit.Test;import java.util.Date; import java.util.List;public class ProviderDaoTest {@Testpublic void testAdd() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);Provider provider = new Provider();provider.setId(15);provider.setProCode("ZJ_GYS002");provider.setProName("樂擺日用品廠");provider.setProDesc("長期合作伙伴，主營產品：各種中、高檔塑料杯，塑料樂扣水杯（密封杯）、保鮮杯（保鮮盒）、廣告杯、禮品杯");provider.setProContact("王世杰");provider.setProPhone("13212331567");provider.setProAddress("浙江省金華市義烏市義東路");provider.setProFax("0579-34452321");provider.setCreatedBy(1);provider.setCreationDate(new Date());mapper.add(provider);sqlSession.close();}@Testpublic void testGetProviderList() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);List<Provider> providerList = mapper.getProviderList("廠", "GZ");for (Provider provider : providerList) {System.out.println(provider);}sqlSession.close();}@Testpublic void testDeleteProviderById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);mapper.deleteProviderById("1");sqlSession.close();}/*測試 getProviderById*/@Testpublic void testGetProviderById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);Provider providerById = mapper.getProviderById("2");System.out.println(providerById);sqlSession.close();}/*測試modify*/@Testpublic void testModify() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();ProviderDao mapper = sqlSession.getMapper(ProviderDao.class);Provider provider = new Provider();provider.setId(2);provider.setProPhone("12345678903");provider.setProContact("王者q");mapper.modify(provider);sqlSession.close();} }(3) RoleDao
RoleDao.java
public interface RoleDao {public List<Role> getRoleList()throws Exception;}RoleDao.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--configuration核心配置文件--> <mapper namespace="dao.role.RoleDao"><!--getRoleList--><select id="getRoleList" resultType="role">select * from smbms.smbms_role</select> </mapper>RoleDaoTest.java
public class RoleDaoTest {@Testpublic void testGetRoleList() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();RoleDao mapper = sqlSession.getMapper(RoleDao.class);List<Role> roleList = mapper.getRoleList();for (Role role : roleList) {System.out.println(role);}sqlSession.close();} }(4) UserDao
UserDao.java
public interface UserDao {/*** 增加用戶信息* @param user* @return* @throws Exception*/public int add(User user)throws Exception;/*** 通過userCode獲取User* @param userCode* @return* @throws Exception*/public User getLoginUser(String userCode)throws Exception;/*** 通過條件查詢-userList* @param userName* @param userRole* @return* @throws Exception*/public List<User> getUserList(@Param("userName") String userName, @Param("userRole") int userRole, @Param("currentPageNo")int currentPageNo, @Param("pageSize")int pageSize)throws Exception;/*** 通過條件查詢-用戶表記錄數* @param userName* @param userRole* @return* @throws Exception*/public int getUserCount(@Param("userName") String userName, @Param("userRole")int userRole)throws Exception;/*** 通過userId刪除user* @param delId* @return* @throws Exception*/public int deleteUserById(Integer delId)throws Exception;/*** 通過userId獲取user* @param id* @return* @throws Exception*/public User getUserById(int id)throws Exception;/*** 修改用戶信息* @param user* @return* @throws Exception*/public int modify( User user)throws Exception;/*** 修改當前用戶密碼* @param id* @param pwd* @return* @throws Exception*/public int updatePwd(@Param("id") int id, @Param("userPassword") String userPassword)throws Exception;}UserDao.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--configuration核心配置文件--> <mapper namespace="dao.user.UserDao"><!--增加用戶信息 User--><insert id="add" parameterType="user">insert into smbms.smbms_user(id, userCode, userName, userPassword, gender, birthday, phone, address, userRole, createdBy, creationDate, modifyBy, modifyDate)values (#{id}, #{userCode}, #{userName}, #{userPassword}, #{gender}, #{birthday}, #{phone}, #{address}, #{userRole}, #{createdBy}, #{creationDate}, #{modifyBy}, #{modifyDate})</insert><!--通過userCode獲取User--><select id="getLoginUser" parameterType="String" resultType="user">select * from smbms.smbms_user<where>userCode = #{userCode}</where></select><!--通過條件查詢-userListString userName, int userRole,int currentPageNo,int pageSize--><select id="getUserList" parameterType="String" resultType="user">select * from smbms.smbms_user<where><if test="userName != null">and userName = #{userName}</if><if test="userRole != null">and userRole = #{userRole}</if></where>limit #{currentPageNo},#{pageSize}</select><!--通過條件查詢-用戶表記錄數 String userName, int userRole--><select id="getUserCount" parameterType="String" resultType="int">select count(*) from smbms.smbms_user<where>userName = #{userName} and userRole = #{userRole}</where></select><!--通過userId刪除user Integer delId--><delete id="deleteUserById" parameterType="int">delete from smbms.smbms_user<where>id = #{id}</where></delete><!--通過userId獲取user String id--><select id="getUserById" parameterType="String" resultType="user">select * from smbms.smbms_user<where>id =#{id}</where></select><!--修改用戶信息 User user set會自動去掉逗號--><update id="modify" parameterType="user">update smbms.smbms_user<set><if test="userCode != null">userCode = #{userCode},</if><if test="userName != null">userName = #{userName},</if><if test="phone != null">phone = #{phone},</if></set><where>id = #{id}</where></update><!--修改當前用戶密碼 int id, String pwd--><update id="updatePwd" parameterType="String">update smbms.smbms_user<set>userPassword = #{userPassword}</set><where>id = #{id}</where></update></mapper>UserDaoTest.java
public class UserDaoTest {@Testpublic void testAdd() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);User user = new User();user.setId(16);user.setUserCode("zhouzhiruo");user.setUserName("周芷若");user.setUserPassword("1234567");user.setGender(1);user.setBirthday(new Date());user.setPhone("12345678900");user.setAddress("北京市昌平區天通苑3區12號樓");user.setUserRole(2);user.setCreatedBy(1);user.setCreationDate(new Date());mapper.add(user);sqlSession.close();}@Testpublic void testGetLoginUser() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);User sunlei = mapper.getLoginUser("sunlei");System.out.println(sunlei);sqlSession.close();}@Testpublic void testGgetUserList() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);List<User> userList = mapper.getUserList("周芷若", 2, 0, 4);for (User user : userList) {System.out.println(user);}sqlSession.close();}@Testpublic void testGetUserCount() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);int userCount = mapper.getUserCount("趙敏", 2);System.out.println(userCount);sqlSession.close();}@Testpublic void testDeleteUserById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);mapper.deleteUserById(5);sqlSession.close();}@Testpublic void testGetUserById() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);User userById = mapper.getUserById(13);System.out.println(userById);sqlSession.close();}@Testpublic void testModify() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);User user = new User();user.setUserName("修改用戶名");user.setId(7);user.setUserCode("changeUserName");mapper.modify(user);sqlSession.close();}@Testpublic void testUpdatePwd() throws Exception{SqlSession sqlSession = MybatisUtil.getSqlSession();UserDao mapper = sqlSession.getMapper(UserDao.class);mapper.updatePwd(6,"123456");sqlSession.close();} }總結
以上是生活随笔為你收集整理的【Mybatis 之应用篇】 5_Mybatis总结（附20道练习题以及答案）的全部內容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 【Mybatis 之应用篇】 4_动态S
- 下一篇： 【Python】【入门】一文带你掌握Py