Mybatis-----CRUD

　　　　　　　　　　　　　　　　　　学而不思则罔，思而不学则殆。

mybatis 增删改查，用到了MyEclipse中自带的Junit4做单元测试，没啥难度，作为练习。关于jar包和目录结构请参考上一篇，这里直接上代码。

<?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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC" />
            <!-- 配置数据源 相当于JDBC连接数据库
              Class.forName("oracle.jdbc.driver.OracleDriver");
              String user = "scott";
               String password = "tiger";
              String url = "jdbc:oracle:thin:@localhost:1521:orcl";
            -->
            <dataSource type="POOLED">
                <property name="driver" value="oracle.jdbc.driver.OracleDriver"/>
                <property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl"/>
                <property name="username" value="scott" />
                <property name="password" value="tiger" />
            </dataSource>
        </environment>
    </environments>
    <!-- 读取Mapper包下的UserinfoMapper.xml文件 -->
    <mappers>
        <mapper resource="Mapper/UserinfoMapper.xml" />
    </mappers>
</configuration>

package TEST;


import java.io.IOException;
import java.io.InputStream;

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 bean.Userinfo;


public class Demo {


    //根据ID查询用户
    @Test
    public void findbyuserinfoID() throws Throwable{
        
        // TODO Auto-generated method stub

                // 加载Mybatis的主配置文件
                InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
                
                // 创建生产session的工厂类 session不是作用域 -- 相当于connection
                SqlSessionFactoryBuilder sfb = new SqlSessionFactoryBuilder();
                SqlSessionFactory ssf = sfb.build(is);
                // 打开session
                SqlSession session=ssf.openSession();
                //执行sql语句

                String  name=session.selectOne("UserinfoMapper.getuser", 3);
                System.out.println("name:"+ name);
                session.close();
                System.out.println("over");
        
    }

    //添加用户
    @Test
    public void insertuserinfo() throws Throwable{
        
        System.out.println("添加用户");
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        
        // 创建生产session的工厂类 session不是作用域 -- 相当于connection
        SqlSessionFactoryBuilder sfb = new SqlSessionFactoryBuilder();
        SqlSessionFactory ssf = sfb.build(is);
        // 打开session
        SqlSession session=ssf.openSession();
        //执行sql语句
        int  result=session.delete("UserinfoMapper.deleteuser", 3);
        //String  name=session.selectOne("UserinfoMapper.deleteUser", 1);
        System.out.println("result:"+ result);
        //如果删除没有成功，可能是因为没有提交事务   一定要注意
        session.commit();
        session.close();
    }
    
    //删除用户
    @Test
    
    public void deleteuserinfoid() throws Throwable{
        System.out.println("删除用户");
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        
        // 创建生产session的工厂类 session不是作用域 -- 相当于connection
        SqlSessionFactoryBuilder sfb = new SqlSessionFactoryBuilder();
        SqlSessionFactory ssf = sfb.build(is);
        // 打开session
        SqlSession session=ssf.openSession();
        //执行sql语句
    //    int  result=session.delete("UserinfoMapper.deleteuser", 3);
        Userinfo u = new Userinfo();
        u.setUname("文刀山豆几");
        u.setUpass("123");
        u.setId(5);
        
        int Statement  = session.insert("UserinfoMapper.adduser", u);
        //String  name=session.selectOne("UserinfoMapper.deleteUser", 1);
        System.out.println("result:"+ Statement);
        //如果删除没有成功，可能是因为没有提交事务   一定要注意
        session.commit();
        session.close();
    }
    //修改用户
    @Test
    public void updateuserinfo() throws Throwable{
        
        System.out.println("修改用户");
        InputStream is = Resources.getResourceAsStream("SqlMapConfig.xml");
        
        // 创建生产session的工厂类 session不是作用域 -- 相当于connection
        SqlSessionFactoryBuilder sfb = new SqlSessionFactoryBuilder();
        SqlSessionFactory ssf = sfb.build(is);
        // 打开session
        SqlSession session=ssf.openSession();
        //执行sql语句
    //    int  result=session.delete("UserinfoMapper.deleteuser", 3);
        
        Userinfo user = new Userinfo();
        user.setId(1);
        user.setUname("aaaaa");
        user.setUpass("fff");
        System.out.println("aaa");
        int a  = session.update("UserinfoMapper.updateuser",user);
        
        //String  name=session.selectOne("UserinfoMapper.deleteUser", 1);
        System.out.println("a:"+ a);
        //如果删除没有成功，可能是因为没有提交事务   一定要注意
        session.commit();
        session.close();
    }
    
}

下一篇会写关于配置文件优化，联合查询，以及使用注解的方式，客官们不要着急！