Mybatis

MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Old Java Objects,普通的 Java对象)映射成数据库中的记录。

public interface IUserDao {
    List<User>findAll();
    void deletById(int id);
    void updateById(User user );
    void insert(User user );
}

<?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.zhongruan.dao.IUserDao">
    <select id="findAll" resultType="com.zhongruan.bean.User">
        select * from tb_user
    </select>

    <delete id="deleteById" parameterType="int">
        delete from tb_user where id=#{id}
    </delete>
    <update id="updateById" parameterType="com.zhongruan.bean.User">
        update tb_user set username=#{username},password=#{password} where id=#{id}
    </update>

    <insert id="insert" parameterType="com.zhongruan.bean.User">
        insert into tb_user (username,password)value (#{username},#{password})
    </insert>

</mapper>

package com.zhongruan.test;

import com.zhongruan.bean.User;
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 java.io.IOException;
import java.io.Reader;
import java.util.List;

public class Test {
    public static void main(String[] args) throws IOException {
        Reader reader=Resources.getResourceAsReader("sqlMapConfig .xml");
        SqlSessionFactory build = new SqlSessionFactoryBuilder().build(reader);
        SqlSession session = build.openSession();
        //List<User> users =session.selectList("findAll");
        //System.out.println(users);
       // session.delete("deleteById",46);
       // User user = new User();
       // user.setId(9);
       //user.setUsername("jjjj");
       // user.setPassword("1011");
       // session.update("updateById", user);

        User user=new User();
        user.setUsername("ggg");
        user.setPassword("kkk");
        session.insert("insert",user);
        session.commit();
        session.close();

        }
    }