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.OracleDriver
url=jdbc:oracle:thin:@127.0.0.1:1521:orcl
username=system
password=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的操作  希望能够对您有所帮助！

<wbr></wbr>

数据库

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;