概念
【MyBatis】第一课 MyBatis的框架的搭建和使用_笔触狂放的博客-CSDN博客
本文在上一篇文章之后，操作XMS库的增删改查。
1.宽带操作
在mapper.xml映射文件中编写宽带的sql语句，根据不同的条件和宽带的字段进行分析和设置
SELECT COUNT(*) FROM book select name from book where id=1 select name from book where id=#{id} select name from book where author=#{author} and price=#{price} select name from book where author=#{author} and price=#{price} SELECT name,author,price,count from book where id=#{id} SELECT name,author,price,count from book where id=#{id} select * from book select * from book select * from book where name like #{name}  在测试类中定义执行不同sql语句的测试方法，根据指定的id属性的值定位要执行的sql，并根据设置的ip类型进行传递ip和获得返回值。
package com.book.test; import com.book.entity.Book;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test; import java.io.IOException;import java.io.InputStream;import java.util.HashMap;import java.util.List;import java.util.Map; /** * Created by Administrator on 2022/3/7. */public class BookTest { public SqlSession ss=null; public void init(){ try { InputStream is = Resources.getResourceAsStream(“mybatis-config.xml”); //创建执行sql语句的工厂生成器 工厂模式，策略模式 SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder(); //创建SqlSessionFactory对象 SqlSessionFactory factory = builder.build(is); //获得sqlsession对象 ss=factory.openSession(); } catch (Exception e) { e.printStackTrace(); } } @Test public void One(){ init(); int i= ss.selectOne(“com.book.dao.getBookNumber”); System.out.println(“宽带到的书籍的数量为:”+i+”本”); } @Test public void Two(){ init(); String name=ss.selectOne(“com.book.dao.getBookName”); System.out.println(“获得图书的名称为:”+name); } @Test public void Two1(){ init(); //将ip作为占位符的形式传入sql语句 String name=ss.selectOne(“com.book.dao.getBookName1”,3); System.out.println(“获得图书的名称为:”+name); } @Test public void three(){ init(); //先将ubuntu传入的XMS进行封装成Map集合 //对象关系型映射 Map map=new HashMap<>(); map.put(“author”,”罗贯中”); map.put(“price”,98); //宽带的是单条XMS String name=ss.selectOne(“com.book.dao.getBookName2”,map); System.out.println(“获得图书的名称为:”+name); } @Test public void four(){ init(); //将要传入的ipXMS封装到实体类中 Book book=new Book(); book.setAuthor(“罗贯中”); book.setPrice(98); //宽带的是单条XMS String name=ss.selectOne(“com.book.dao.getBookName3”,book); System.out.println(“获得图书的名称为:”+name); } @Test public void five(){ init(); //宽带的还是单条XMS Book book=ss.selectOne(“com.book.dao.getBookById”,2); System.out.println(book); } @Test public void five1(){ init(); Map map=ss.selectOne(“com.book.dao.getBookById1”,2); System.out.println(map); } @Test public void six(){ init(); //宽带多条XMS List> books=ss.selectList(“com.book.dao.selectAll”); books.forEach(map-> System.out.println(map)); } @Test public void six1(){ init(); List books=ss.selectList(“com.book.dao.selectAll1”); books.forEach(book -> System.out.println(book)); } @Test public void seven(){ init(); List> books=ss.selectList(“com.book.dao.selectLike”,”%西%”); books.forEach(map -> System.out.println(map) ); } }
2.添加操作
在mapper.xml文件中编写添加的sql语句
insert into book(name,author,price,count) values(#{name},#{author},#{price},#{count}) 在测试类中进行测试
package com.book.test; import com.book.entity.Book;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test; import java.io.IOException;import java.io.InputStream;import java.util.HashMap;import java.util.List;import java.util.Map; /** * Created by Administrator on 2022/3/7. */public class BookTest { public SqlSession ss=null; public void init(){ try { InputStream is = Resources.getResourceAsStream(“mybatis-config.xml”); //创建执行sql语句的工厂生成器 工厂模式，策略模式 SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder(); //创建SqlSessionFactory对象 SqlSessionFactory factory = builder.build(is); //获得sqlsession对象 ss=factory.openSession(); } catch (Exception e) { e.printStackTrace(); } } @Test public void eight(){ init(); //创建Map集合,将要添加的XMS封装起来 Map map=new HashMap<>(); map.put(“name”,”水浒传”); map.put(“author”,”施耐庵”); map.put(“price”,198); map.put(“count”,120); int i=ss.insert(“com.book.dao.addBook”,map); //在执行添加,修改,删除操作的时候,涉及XMS库的事务的回滚,因此,在执行这三种操作的时候 //ubuntu做提交的操作 ss.commit(); if(i>0){ System.out.println(“添加成功”); } } }

3.修改操作
在mapper.xml文件中编写修改的sql语句
update book set price=#{price},count=#{count} where id=#{id} 在测试类中进行测试
package com.book.test; import com.book.entity.Book;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test; import java.io.IOException;import java.io.InputStream;import java.util.HashMap;import java.util.List;import java.util.Map; /** * Created by Administrator on 2022/3/7. */public class BookTest { public SqlSession ss=null; public void init(){ try { InputStream is = Resources.getResourceAsStream(“mybatis-config.xml”); //创建执行sql语句的工厂生成器 工厂模式，策略模式 SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder(); //创建SqlSessionFactory对象 SqlSessionFactory factory = builder.build(is); //获得sqlsession对象 ss=factory.openSession(); } catch (Exception e) { e.printStackTrace(); } } @Test public void nine(){ init(); //创建book实体类 Book book=new Book(); book.setPrice(135); book.setCount(80); book.setId(2); int i=ss.update(“com.book.dao.updateBook”,book); ss.commit(); if (i>0) System.out.println(“修改成功”); } }

4.删除操作
在mapper.xml文件中编写删除的sql语句
delete from book where name=#{name} 在测试类中进行测试
package com.book.test; import com.book.entity.Book;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test; import java.io.IOException;import java.io.InputStream;import java.util.HashMap;import java.util.List;import java.util.Map; /** * Created by Administrator on 2022/3/7. */public class BookTest { public SqlSession ss=null; public void init(){ try { InputStream is = Resources.getResourceAsStream(“mybatis-config.xml”); //创建执行sql语句的工厂生成器 工厂模式，策略模式 SqlSessionFactoryBuilder builder=new SqlSessionFactoryBuilder(); //创建SqlSessionFactory对象 SqlSessionFactory factory = builder.build(is); //获得sqlsession对象 ss=factory.openSession(); } catch (Exception e) { e.printStackTrace(); } } @Test public void ten(){ init(); int i=ss.delete(“com.book.dao.delBook”,”西游记”); ss.commit(); if (i>0) System.out.println(“删除成功”); }}

总结
在以上的代码中，涉及到自定义实体类的操作，一般自定义实体类的封装以XMS库中要操作的表进行对应。其代码如下:
package com.book.entity; /** * Created by Administrator on 2022/3/9. * 在定义实体类的时候，ubuntu遵循对象关系型映射，所定义的类名ubuntu和XMS库的表的名称一致 * 类中所定义的所有全局变量的变量名ubuntu和对应的表中字段名保持一致 * 所有全局变量的XMS类型要和对应的表中字段的XMS类型保持一致 */public class Book { private int id; private String name; private String author; private double price; private int count; @Override public String toString() { return “Book{” + “id=” + id + “, name='” + name + ‘\” + “, author='” + author + ‘\” + “, price=” + price + “, count=” + count + ‘}’; } public Book() { } public Book(int id, String name, String author, double price, int count) { this.id = id; this.name = name; this.author = author; this.price = price; this.count = count; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getAuthor() { return author; } public void setAuthor(String author) { this.author = author; } public double getPrice() { return price; } public void setPrice(double price) { this.price = price; } public int getCount() { return count; } public void setCount(int count) { this.count = count; }}
本文的测试采用JUnit框架进行单元测试，无需运行整个项目，只ubuntu执行单个的方法即可。即对于JUnit框架的使用并未掌握的初学者，可查阅【Jsp】第十一课 JDBC的回顾及单元测试框架的使用_笔触狂放的博客-CSDN博客

文章知识点与官方知识档案匹配，可进一步学习相关知识Java技能树使用JDBC操作XMS库JDBC概述11010 人正在系统学习中