MyBatis框架的搭建和基本的写法事列

一.将需要的包拷贝到lib中

总共的包为：

二.在src中写相应的代码 eg:

1）在src下建立一个mybatis-config.xml用来连接项目数据库，代码如下：

<?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="config.properties">  
      </properties>
  <environments default="development">
    <environment id="development">
      <transactionManager type="JDBC"/>    
      <dataSource type="POOLED">
        <property name="driver" value="${jdbc.driverClass}"/>
        <property name="url" value="${jdbc.jdbcUrl}"/>
        <property name="username" value="${jdbc.user}"/>
        <property name="password" value="${jdbc.password}"/>
      </dataSource>
    </environment>
  </environments>
  <mappers>
    <mapper resource="com/gxa/bj/modle/UserInfoMapper.xml"/>
  </mappers>
</configuration>

2）在src下建立一个config.properties方便其他项目调用，代码如下：

jdbc.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.user=bbs
jdbc.password=123

3）搭建modle,dao和dao.imp层：

dao接口层：

package com.gxa.bj.dao;
import java.sql.SQLException;
import java.util.List;
/**
 * @author Administrator
 *针对数据库中增删改查的方法的接口
 * @param <T>
 */
public interface IDaoBBs<T> { 
/**
* @param t
* @return 向数据库表里添加一条数据的方法
* @throws SQLException
*/
public int addItem(T t) ;
/**
* @param objId
* @return 从数据库表里删除一条数据的方法
* @throws SQLException
*/
public int removeItem(Object objId) ;
/**
* @param t
* @return 跟新数据库表里一条字段的方法
* @throws SQLException
*/
public int updateItem(T t) ;
/**
* @param objId
* @return 根据主键的字段获取该条信息，并将它转化为实体的对象
* @throws SQLException
*/
public T getMolde(Object objId) ;
/**
* @param t
* @return 根据查询条件获取多条数据，并转化为相应的集合
* @throws SQLException
*/
public List<T> getList(T t) ;
}

modle层，除了数据表的外添加一个针对某个数据表的增，删，改，查的mapper.xml  like:UserInfoMapper.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="<span style="background-color: rgb(255, 0, 0);">com.gxa.bj.dao.imp.UserMapper</span>">用来连接到dao.imp
 <insert id="addItem" parameterType="com.gxa.bj.modle.UserInfo">
  insert into UserInfo(userId,userName,userPwd,userEmail)
  values(usernext.nextval,#{userName},#{userPwd},#{userEmail})
  </insert>
   <delete id="removeItem" >
    delete from UserInfo where userId = #{id}
  </delete>
  <update id="updateItem" parameterType="com.gxa.bj.modle.UserInfo">
  update UserInfo set userName=#{userName},userPwd=#{userPwd},userEmail=#{userEmail}
  where userId=#{userId}
  </update>
   <select id="getMolde" resultType="com.gxa.bj.modle.UserInfo">
    select * from UserInfo where userId = #{id}
  </select>
   <select id="getUsers" parameterType="java.lang.String" resultSets="com.gxa.bj.modle.UserInfo" resultType="com.gxa.bj.modle.UserInfo">
    select * from UserInfo where userName like '%${value}%'
  </select>
</mapper>

dao.imp层，通过接口来实现接口里的方法，建立一个接口UserMapper来继承dao中的接口：

package com.gxa.bj.dao.imp;
import java.util.List;
import com.gxa.bj.dao.IDaoBBs;
import com.gxa.bj.modle.UserInfo;
public interface UserMapper extends IDaoBBs<UserInfo>{
/**
* 跟据用户名进行一个模糊查询，获取用户表中该用户的信息集合
* @author chenqing
*
*/
public List<UserInfo> getUsers(String name); //查询集合时调用
}

实现TestUI:

package com.gxa.bj.dao.imp;
import java.io.IOException;
import java.io.InputStream;
import java.sql.SQLException;
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.gxa.bj.modle.UserInfo;
public class TestUI {
public static void main(String[] args) {
// TODO Auto-generated method stub
String resource = "mybatis-config.xml";
InputStream inputStream = null;
try {
inputStream = Resources.getResourceAsStream(resource);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
   SqlSession sqlSessin=sqlSessionFactory.openSession();
   UserMapper userMapper=sqlSessin.getMapper(UserMapper.class);
  // 添加
  /* UserInfo u=new UserInfo();
   u.setUserName("李四");
   u.setUserPwd("123");
   u.setUserEmail("www.@66.oo");   
if(userMapper.addItem(u)>0){
sqlSessin.commit();
System.out.println("添加成功");
}else{
System.out.println("添加失败");
} */
   //删除
/*if(userMapper.removeItem(4)>0){
sqlSessin.commit();
System.out.println("删除成功");
}else{
System.out.println("删除失败");
}*/
   //修改
  /* UserInfo u=new UserInfo();
   u.setUserId(7);
   u.setUserName("李流");
   u.setUserPwd("123");
   u.setUserEmail("www.@66.oo");   
if(userMapper.updateItem(u)>0){
sqlSessin.commit();
System.out.println("修改成功");
}else{
sqlSessin.rollback();
System.out.println("修改失败");
} */
   //查询单个
  /* Integer userId=7;
   UserInfo u=userMapper.getMolde(userId);
   System.out.println("查询到用户名为："+u.getUserName());*/
 //查询集合
   String userName="陶渊明";
   List<UserInfo> u1= userMapper.getUsers(userName);
   System.out.println("查询到用户信息为："+ u1.get(0).getUserId()+u1.get(0).getUserPwd());
   sqlSessin.close();
}
}

jbc.jdbcUrl=jdbc:oracle:thin:@127.0.0.1:1521:orcl
jdbc.driverClass=oracle.jdbc.driver.OracleDriver
jdbc.user=bbs
jdbc.password=123