MyBaits保存更新删除

添加客户

<!--保存用户-->
<insert id="saveCustomer" parameterType="com.qc.domain.Customer">
    INSERT INTO `customer`
    (cust_name,cust_profession,cust_phone,email) VALUES
    (#{cust_name},#{cust_profession},#{cust_phone},#{email})
</insert>

测试类调用，需要手动提交事务，sqlSession 调用的方法名，以及参数

/**
 * @author 30315
 * @title: MyTest
 * @projectName MyBatisPro-01
 * @description: TODO
 * @date 2020-03-0112:24
 */
public class MyTest {

    @Test
    public void test() throws IOException {
        // 1.SqlSessionFactoryBuilder 加载配置文件
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();

        // 2.读取配置文件
        InputStream resourceAsStream = Resources.getResourceAsStream("SqlMappingConfig.xml");

        // 3.获取Session工厂
        SqlSessionFactory sessionFactory = sqlSessionFactoryBuilder.build(resourceAsStream);

        // 4.获取回话   --- JDBC连接
        SqlSession sqlSession = sessionFactory.openSession();

        // 5.执行SQL
        Customer customer = new Customer();
        customer.setCust_name("疾风剑豪");
        customer.setCust_profession("刺客");
        customer.setCust_phone("13754784512");
        customer.setEmail("303158131@qq.com");
        sqlSession.insert("saveCustomer",customer);

        // 6.提交事务
        sqlSession.commit();

        // 7.释放资源
        sqlSession.close();
    }

}

返回添加过后自增的主键

<!--保存用户-->
<insert id="saveCustomer" parameterType="com.qc.domain.Customer">
    <selectKey keyColumn="cust_id" keyProperty="cust_id" order="AFTER" resultType="Long">
        SELECT LAST_INSERT_ID()
    </selectKey>

    INSERT INTO `customer`
    (cust_name,cust_profession,cust_phone,email) VALUES
    (#{cust_name},#{cust_profession},#{cust_phone},#{email})
</insert>

执行完插入语句后，打印添加之前对象的 ID,resultType 的类型要和 domain 的类型一致

System.out.println(customer.getCust_id());

更新客户

<!--更新客户-->
<update id="updateCustomerById" parameterType="com.qc.domain.Customer">
    UPDATE `customer` SET
    cust_name = #{cust_name} WHERE cust_id = #{cust_id}
</update>

删除客户

<delete id="deleteCustomerById" parameterType="Long">
    DELETE FROM `customer` WHERE
    cust_id = #{cust_id}
</delete>