mybatis（一）

mybatis初体验

1.创建一个Web项目或者创建一个 控制台 应用程序    做一个简单的增删改查操作

首先看项目结构图

 

 mybatis的配置文件configuration.xml此文件作为mybatis的配置文件 

<?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>      <!-- 加载数据源配置文件 -->     <properties resource="jdbc.properties"></properties>     <!-- 设置类型别名 -->     <typeAliases>       <typeAlias alias="BookInfo" type="com.dragon.entity.BookInfo"/>      </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>         <!-- 加入映射文件 的类-->        <mappers>         <mapper resource="com/dragon/entity/BookInfo.xml"/>        </mappers>  </configuration> 

jdbc.properties配置文件
 driver=oracle.jdbc.driver.OracleDriverurl=jdbc:oracle:thin:@127.0.0.1:1521:orclusername=systempassword=orcl

book实体类

package com.dragon.entity;
import java.io.Serializable;
public class BookInfo implements Serializable{ public BookInfo() {  super(); } public BookInfo(int bookId, String bookTitle, Double bookPrice) {  super();  book_id = bookId;  book_title = bookTitle;  book_price = bookPrice; } /**  *   */ private static final long serialVersionUID = 1L; private int  book_id; private String book_title;  private Double book_price; public int getBook_id() {  return book_id; } public void setBook_id(int bookId) {  book_id = bookId; } public String getBook_title() {  return book_title; } public void setBook_title(String bookTitle) {  book_title = bookTitle; } public Double getBook_price() {  return book_price; } public void setBook_price(Double bookPrice) {  book_price = bookPrice; } 
}
bookMapper配置文件    BookInfo.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.dragon.entity.BookInfo" >  <!-- 创建insert   parameterType 参数为设置传入类型  insert没有返回类型-->  <insert id="inserts"  parameterType="com.dragon.entity.BookInfo" >   insert into     BookInfo(book_id,book_title,book_price)    values    (#{book_id},#{book_title},#{book_price})  </insert>   <!-- 创建查询语句  parameterType 为设置传入参数 -->  <select id="get" parameterType="com.dragon.entity.BookInfo"  resultType="BookInfo">   select * from      BookInfo  </select>  <!-- 根据编号查询 -->    <select id="selById" parameterType="int" resultType="BookInfo">   SELECT * FROM     BookInfo    WHERE     book_id = #{book_id}  </select>  <!-- 根据编号删除 -->  <delete id="deleteBook" parameterType="int">   DELETE FROM     BookInfo    WHERE     book_id = #{book_id}  </delete>  <!-- 更新 -->  <update id="updateBook" parameterType="com.dragon.entity.BookInfo">   UPDATE      BookInfo    SET     book_title = #{book_title},    book_price = #{book_price}    WHERE     book_id = #{book_id}  </update></mapper>
控制台测试
package com.dragon.test;
import java.io.IOException;import java.io.InputStream;import java.util.List;
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 com.dragon.entity.BookInfo;
public class Test {
 /**  * @param args  */ @SuppressWarnings("unchecked") public static void main(String[] args) {  // TODO Auto-generated method stub  //定义文件  文件名称为mybatis的配置文件的名称  String resource = "configuration.xml";   //创建文件输入流  InputStream stream;  try {
   stream = Resources.getResourceAsStream(resource);   //创建sqlSessionFactory对象   SqlSessionFactory  sqlSessionFactory = new SqlSessionFactoryBuilder().build(stream);    //打开session对象   SqlSession session = sqlSessionFactory.openSession();
   /////////////////查全部//////////////////   //调用mapper文件中的id为get的sql方法   List<BookInfo> list  = session.selectList("com.dragon.entity.BookInfo.get");   System.out.println("图书的信息是：\n编号\t名称\t价格");   for (BookInfo bookInfo : list) {    System.out.println(bookInfo.getBook_id()+"\t"+bookInfo.getBook_title()+"\t"+bookInfo.getBook_price());   }   System.out.println("---------------------------------------------------------------------");   /////////////根据编号查询   BookInfo bookInfo = (BookInfo)session.selectOne("com.dragon.entity.BookInfo.selById", 1);   System.out.println("图书的信息是：\n编号\t名称\t价格");   System.out.println(bookInfo.getBook_id()+"\t"+bookInfo.getBook_title()+"\t"+bookInfo.getBook_price());
   /////////////新增   int result =session.insert("com.dragon.entity.BookInfo.inserts", new BookInfo(4,"net培训教程3",78.53));   //提交事务   session.commit();   ///////插入成功则返回1    System.out.println(result);   ////////删除   int delResult = session.delete("com.dragon.entity.BookInfo.deleteBook", 3);   session.commit();   ////删除成功返回1   System.out.println(delResult);   //////更新   int updateResult = session.update("com.dragon.entity.BookInfo.updateBook", new BookInfo(1,"net培训教程",78.53) );   session.commit();   System.out.println(updateResult);        } catch (IOException e) {   // TODO Auto-generated catch block   e.printStackTrace();  } }
}
一个简单的jdbc对mybatis的操作  希望能够对您有所帮助！

数据库

CREATE TABLE BookInfo (book_id number(5) PRIMARY key not null,book_title nvarchar2(50) ,book_price number(6,2));insert into BookInfo values (1,'java',54.8);insert into BookInfo values(2,'C#编程',66);commit;select * from BookInfo;DROP TABLE BookInfo;