<configuration> 
<!-- 使用mybatis需要的數(shù)據(jù)源和事務(wù)配置，后續(xù)如果整合spring之后，將不再需要 --> 
<environments default="development"> 
<!-- 配置數(shù)據(jù)源和事務(wù) --> 
<environment id="development"> 
<!-- 配置事務(wù)管理,將事務(wù)管理交給mybatis管理 --> <transactionManager type="JDBC" /> 
<!-- 配置數(shù)據(jù)源 --> 
<dataSource type="POOLED">
 <property name = "driver" value = "com.mysql.jdbc.Driver" /> 
 <property name="url" value="jdbc:mysql://localhost:3306/db_shop? useUnicode=true&amp;characterEncoding=utf-8"/>
  <property name="username" value="root"/> <property name="password" value=""/>
   </dataSource>
    </environment> 
    </environments>
     <!-- 加載**.xml配置文件 --> 
     <mappers> 
     <mapper resource="product.xml"/>
</mappers> 
</configuration>

/**** <p>Title: Product</p> * 
<p>Description: 商品類(lèi)失血模型</p> *
 @author Alon *
  @date 2020年9月27日 下午6:51:57 
  * @version 1.0 */ 
 public class Product {
  private int p_id;
   private String name; 
   private int p_number;
    private double price; 
    private String add_time;
     public Product(int p_id, String name, int p_number, double price, String add_time) { 
     super();
      this.p_id = p_id; 
      this.name = name; 
      this.p_number = p_number; 
      this.price = price; 
      this.add_time = add_time; 
      }public Product() { 
        super();
       }
       public int getP_id() { 
       return p_id; }
       public void setP_id(int p_id) { 
       this.p_id = p_id; }public String getName() { return name; }
       public void setName(String name) { this.name = name; }
       public int getP_number() { 
       return p_number; }
       public void setP_number(int p_number) { this.p_number = p_number; }
       public double getPrice() { return price; }
       public void setPrice(double price) { this.price = price; }
       public String getAdd_time() { return add_time;
}
public void setAdd_time(String add_time) { this.add_time = add_time; }
@Override 
public String toString() { 
return "Product [p_id=" + p_id + ", name=" + name + ", p_number=" + p_number + ", price=" + price + ", add_time=" + add_time + "]"; } }

<?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">
 <!-- 映射的sql文件 namespace:命名空間，可以理解成將部分的sql語(yǔ)句進(jìn)行隔離。到后面的mapper代理方式將有更 加重要的作用 --> <mapper namespace="test"> 
 <!--select:表示要執(zhí)行的查詢(xún)語(yǔ)句 id:給這個(gè)查詢(xún)語(yǔ)句取一個(gè)名字，唯一的,java中要調(diào)用的使用。
  parameterType:輸入?yún)?shù)的數(shù)據(jù)類(lèi)型 
  resultType:輸出參數(shù)的數(shù)據(jù)類(lèi)型，一般綁定成model的對(duì)象 #{value}:表示用來(lái)和占位符一樣，用來(lái)接受輸入的參數(shù)值。 --> <select id="findById" parameterType="java.lang.Integer" resultType="com.woniuxy.model.Product">
   SELECT * FROM t_product WHERE p_id = #{value}
    </select>
     </mapper>

/**** <p>Title: MybatisDemo1</p> *
 <p>Description: 查詢(xún)數(shù)據(jù)的demo</p> *
  @author Alon 
  * @date 2020年9月27日 下午7:05:32 
  * * @version 1.0 */ 
  * public class MybatisDemo1 {
  *  public static void main(String[] args) throws IOException { 
  * new MybatisDemo1().queryById(); }
  * public void queryById() throws IOException {
  *  //1、讀取到SqlMapConfig.xml文件的流 String path = "SqlMapConfig.xml"; 
  * InputStream config = Resources.getResourceAsStream(path);
//創(chuàng)建會(huì)話工廠,同時(shí)將SqlMapConfig.xml里面的數(shù)據(jù)放到工廠中 SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(config); 
//開(kāi)啟會(huì)話 SqlSession sqlSession = factory.openSession(); /** 第一個(gè)參數(shù)：要執(zhí)行哪個(gè)sql語(yǔ)句的參數(shù)，一般命名空間.id值 * 第二個(gè)參數(shù)：傳入填充#{value}的傳入?yún)?shù)值。 */ 
Object obj = sqlSession.selectOne("test.findById", 1); System.out.println(obj); } }

<!-- 在原有的xml文件中進(jìn)行配置即可，不需要新建，之前的也已經(jīng)在SqlMapConfig.xml文件中進(jìn)行了配 置 --> <select id="queryByName" parameterType="java.lang.String" resultType="com.woniuxy.model.Product"> SELECT * FROM t_product WHERE name like "%${value}%" </select> public void queryByName() throws Exception
{
 String path = "SqlMapConfig.xml"; //獲取流對(duì)象 InputStream config = Resources.getResourceAsStream(path); //獲取會(huì)話工廠 SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(config); //開(kāi)啟會(huì)話 SqlSession sqlSession = factory.openSession(); /** 因?yàn)閳?zhí)行結(jié)果有多條語(yǔ)句，那么必須使用selectList */ List<Object> list = sqlSession.selectList("test.queryByName", "旺仔"); //迭代 System.out.println(list); 
}

<!-- 新增一條數(shù)據(jù) parameterType:傳入?yún)?shù)的數(shù)據(jù)類(lèi)型，用失血模型對(duì)象即可。 --> 
<insert id="insertProduct" parameterType="com.woniuxy.model.Product"> 
INSERT INTO t_product(name,p_number,price) value(#{name},#{p_number},# {price}); 
</insert>

/**
**<p>Title: insert</p> 
*<p>Description: 新增數(shù)據(jù)</p> 
* @throws Exception 
* */ public void insert() throws Exception{ String path = "SqlMapConfig.xml"; 
* //獲取流對(duì)象 
* InputStream config = Resources.getResourceAsStream(path); //獲取會(huì)話工廠
*  SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(config); 
* //開(kāi)啟會(huì)話 
* SqlSession sqlSession = factory.openSession();
*  Product prod = new Product();
*  prod.setName("雪碧"); 
* prod.setP_number(10); 
* prod.setPrice(3.0);
*  int row = sqlSession.insert("test.insertProduct", prod); System.out.println(row); sqlSession.commit(); sqlSession.close(); }