bybatis入门补充

最新推荐文章于 2024-06-12 16:52:54 发布

xupen.wu

最新推荐文章于 2024-06-12 16:52:54 发布

阅读量151

点赞数

本文链接：https://blog.youkuaiyun.com/xupeng1997/article/details/105702994

版权

package wuxupeng.Test;
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 wuxupeng.domain.Student;
import java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class Test {
    public static void main(String[] args) {
        String resource = "mybatis-config.xml";
        InputStream inputStream =null;
        try {
            inputStream= Resources.getResourceAsStream(resource);
        } catch (IOException e) {
            e.printStackTrace();
        }
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
      /*  SqlSession session = sqlSessionFactory.openSession(); 为啥不可通用我也不知道*/

        //删除的方法
      /*  SqlSession session = sqlSessionFactory.openSession();
        int delete = session.delete("text1.delete", "2");
        System.out.println("================="+delete);
        //此时实物并未真实提交，(增删改都要提交事务)
        // 提交事务
        session.commit();
        System.out.println("================="+delete);*/

      //更新的方法
      /*  SqlSession session = sqlSessionFactory.openSession();
        Student ss = new Student();
        ss.setId("12");
        ss.setName("11");
        ss.setAge(12);
        int insert = session.insert("text1.insert", ss);
        session.commit();
        System.out.println("================="+insert);*/

     //查询的方法单条
       /* SqlSession sqlSession = sqlSessionFactory.openSession();
        Student o = sqlSession.selectOne("text1.getByid", "3");
        System.out.println(o);*/

      // 更新的方法
      Student s = new Student();
        s.setId("11");
        s.setName("wee");
        s.setAge(23);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        int update = sqlSession.update("text1.update", s);
        sqlSession.commit();
        System.out.println("===受影响的行数======"+update);

  /* //查询全部
        SqlSession sqlSession = sqlSessionFactory.openSession();
        List<Student> list= sqlSession.selectList("text1.queryAll");
        for (Student s:list
             ) {
            System.out.println(s);
        }
*/
    }
}

<?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="text1">

    <delete id="delete" parameterType="wuxupeng.domain.Student">
        delete  from stu where id=#{id}
    </delete>

    <insert id="insert"  parameterType="wuxupeng.domain.Student">
        insert  into stu(id,name,age) values (#{id},#{name},#{age})
    </insert>


    <select id="getByid" parameterType="java.lang.String" resultType="wuxupeng.domain.Student">
       SELECT * FROM stu WHERE id= #{id}
   </select>



    <update id="update" parameterType="wuxupeng.domain.Student">
        update  stu set name=#{name},age=#{age} where id=#{id}
    </update>


    <select id="queryAll"  resultType="wuxupeng.domain.Student">
       SELECT * FROM stu
   </select>

</mapper>