MyBatis增删改查的简单实现
核心代码如下:
Mapper文件
<mapper namespace="com.lzj.mapper.FlowerMapper3">
<!--public int insert(Flower fl); -->
<insert id="insert" >
insert into flower values(DEFAULT ,#{name},#{price},#{production})
</insert>
<!--public int update(Flower fl)-->
<update id="update">
update flower set name =#{name},price=#{price} WHERE id =#{id}
</update>
<!--public int delete(int id);-->
<delete id="delete">
DELETE from flower where id =#{0}
</delete>
</mapper>
测试类
public static void main(String[] args) throws Exception {
//【1】解析mybatis.xml
InputStream inputStream = Resources.getResourceAsStream("MyBatis.xml");
//[2]获得session工厂
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
//[3]获得session对象
SqlSession session = factory.openSession(true);
//[4]调用方法
Flower flower=new Flower();
flower.setName("夕颜123");
flower.setPrice(15);
//flower.setProduction("中国");
flower.setId(6);
int insert = session.insert("com.lzj.mapper.FlowerMapper3.insert", flower);
session.update("com.lzj.mapper.FlowerMapper3.update",flower);
int delete = session.delete("com.lzj.mapper.FlowerMapper3.delete", 6);
//[5]关闭
session.close();
}
[注]:mybatis中我们的增加、删除、修改操作都是需要自己手动提交
A、session.commit();
B、SqlSession session = factory.openSession(true);