#

# Global logging configuration

log4j.rootLogger=DEBUG, stdout

# Console output...

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%

<?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>

    <!-- 和spring整合后 environments配置将废除 -->

    <environments default="development">

        <environment id="development">

            <!-- 使用jdbc事务管理 -->

            <transactionManager type="JDBC" />

            <!-- 数据库连接池 -->

            <dataSource type="POOLED">

                <property name="driver" value="com.mysql.jdbc.Driver" />

                <property name="url" value="jdbc:mysql://localhost:3306/php1?characterEncoding=utf-8" />

                <property name="username" value="root" />

                <property name="password" value="123456" />

            </dataSource>

        </environment>

    </environments>

    <mappers>-- 此处配合下面的文件配置

        <mapper resource="cn/zys/mapper/p1Mapper.xml" />

    </mappers>

</configuration>

创建一个包，存放表操作的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="p1">-- 表名

    <select id="getp1ById"-- 给方法起名 parameterType="Integer"  resultType="cn.zys.pojo.p1bean">

        select * from p1 where id=#{id}

    </select>

    <!-- 模糊查询 -->

    <select id="getuserbyusername" parameterType="String" resultType="cn.zys.pojo.p1bean">

        <!-- select * from p1 where info like #{info} -->

        <!-- select * from p1 where info like '%${value}%' -->

        select * from p1 where info like "%"#{info}"%"

    </select>

    <!-- 新增 -->

    <insert id="addinfo" parameterType="cn.zys.pojo.p1bean"  >

        insert into p1(info) values(#{info})

    </insert>

    <!-- 修改 -->

    <update id="upp1" parameterType="cn.zys.pojo.p1bean">

        update p1 set info=#{info} where id=#{id}

    </update>

    <!--删除  -->

    <delete id="delinfo" parameterType="Integer">

        delete from p1 where id=#{id}

    </delete>

</mapper>

package cn.zys.mapper;

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 cn.zys.pojo.p1bean;

public class test {

    public static void main(String[] args) throws IOException {

        update();

    }

    public static void sel() throws IOException{

        // 1. 创建SqlSessionFactoryBuilder对象

        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

        // 2. 加载SqlMapConfig.xml配置文件

        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");

        // 3. 创建SqlSessionFactory对象

        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);

        // 4. 创建SqlSession对象

        SqlSession sqlSession = sqlSessionFactory.openSession();

        //5.sqlseisson

        List<p1bean> arr=sqlSession.selectList("p1.getuserbyusername","4");

        System.out.println(arr);

        //释放资源

        sqlSession.close();

    }

    public static void update() throws IOException{

        // 1. 创建SqlSessionFactoryBuilder对象

        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

        // 2. 加载SqlMapConfig.xml配置文件

        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");

        // 3. 创建SqlSessionFactory对象

        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);

        // 4. 创建SqlSession对象

        SqlSession sqlSession = sqlSessionFactory.openSession();

        //5.sqlseisson

        p1bean p=new p1bean();

        p.setId(22);

        p.setInfo("赛文");

        int arr=sqlSession.insert("p1.upp1",p);

        System.out.println(arr);

        sqlSession.commit();//提交事务，增删改必须要提交

        //释放资源

        sqlSession.close();

    }

    public static void add() throws IOException{

        // 1. 创建SqlSessionFactoryBuilder对象

        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

        // 2. 加载SqlMapConfig.xml配置文件

        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");

        // 3. 创建SqlSessionFactory对象

        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);

        // 4. 创建SqlSession对象

        SqlSession sqlSession = sqlSessionFactory.openSession();

        //5.sqlseisson

        p1bean p=new p1bean();

        p.setInfo("迪迦");

        int arr=sqlSession.insert("p1.addinfo",p);

        System.out.println(arr);

        sqlSession.commit();//提交事务，增删改必须要提交

        //释放资源

        sqlSession.close();

    }

    public static void del() throws IOException{

        // 1. 创建SqlSessionFactoryBuilder对象

        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

        // 2. 加载SqlMapConfig.xml配置文件

        InputStream inputStream = Resources.getResourceAsStream("SqlMapConfig.xml");

        // 3. 创建SqlSessionFactory对象

        SqlSessionFactory sqlSessionFactory = sqlSessionFactoryBuilder.build(inputStream);

        // 4. 创建SqlSession对象

        SqlSession sqlSession = sqlSessionFactory.openSession();

        //5.sqlseisson

        int arr=sqlSession.insert("p1.delinfo",23);

        System.out.println(arr);

        sqlSession.commit();//提交事务，增删改必须要提交

        //释放资源

        sqlSession.close();

    }

}