- 配置文件Category.xml
首先一次性修改配置文件Category.xml,提供CRUD对应的sql语句。
每个SQL如何使用在后续对应操作里一一讲解。
<?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.how2java.pojo"> <insert id="addCategory" parameterType="Category" > insert into category_ ( name ) values (#{name}) </insert> <delete id="deleteCategory" parameterType="Category" > delete from category_ where id= #{id} </delete> <select id="getCategory" parameterType="_int" resultType="Category"> select * from category_ where id= #{id} </select> <update id="updateCategory" parameterType="Category" > update category_ set name=#{name} where id=#{id} </update> <select id="listCategory" resultType="Category"> select * from category_ </select> </mapper>
- 增加
运行之后,如图所示可以看到 通过Mybatis查询出来的数据里有新增加的Category
通过session.insert调用addCategory对应的SQL语句
Category c = new Category(); c.setName("新增加的Category"); session.insert("addCategory",c);
addCategory对应的插入sql语句,#{name}会自动获取c对象的name属性值
<insert id="addCategory" parameterType="Category" > insert into category_ ( name ) values (#{name}) </insert>
<insert id="addCategory" parameterType="Category" > insert into category_ ( name ) values (#{name}) </insert>
package com.how2java; 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 com.how2java.pojo.Category; public class TestMybatis { public static void main(String[] args) throws IOException { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); Category c = new Category(); c.setName("新增加的Category"); session.insert("addCategory",c); listAll(session); session.commit(); session.close(); } private static void listAll(SqlSession session) { List<Category> cs = session.selectList("listCategory"); for (Category c : cs) { System.out.println(c.getName()); } } }
- 删除
删除id=6的对象
Category c = new Category(); c.setId(6); session.delete("deleteCategory",c);
deleteCategory对应删除的sql语句
<delete id="deleteCategory" parameterType="Category" > delete from category_ where id= #{id} </delete>
package com.how2java; 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 com.how2java.pojo.Category; public class TestMybatis { public static void main(String[] args) throws IOException { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); Category c = new Category(); c.setId(6); session.delete("deleteCategory",c); listAll(session); session.commit(); session.close(); } private static void listAll(SqlSession session) { List<Category> cs = session.selectList("listCategory"); for (Category c : cs) { System.out.println(c.getName()); } } }
<delete id="deleteCategory" parameterType="Category" > delete from category_ where id= #{id} </delete>
- 获取
通过session.selectOne获取id=3的记录
Category c= session.selectOne("getCategory",3);
getCategory对应的sql语句:
<select id="getCategory" parameterType="_int" resultType="Category"> select * from category_ where id= #{id} </select>
package com.how2java; 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 com.how2java.pojo.Category; public class TestMybatis { public static void main(String[] args) throws IOException { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); Category c= session.selectOne("getCategory",3); System.out.println(c.getName()); // listAll(session); session.commit(); session.close(); } private static void listAll(SqlSession session) { List<Category> cs = session.selectList("listCategory"); for (Category c : cs) { System.out.println(c.getName()); } } }
<select id="getCategory" parameterType="_int" resultType="Category"> select * from category_ where id= #{id} </select>
- 修改
通过session.update进行修改
session.update("updateCategory",c);
updateCategory对应的sql语句:
<update id="updateCategory" parameterType="Category" > update category_ set name=#{name} where id=#{id} </update>
package com.how2java; 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 com.how2java.pojo.Category; public class TestMybatis { public static void main(String[] args) throws IOException { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); Category c= session.selectOne("getCategory",3); c.setName("修改了的Category名稱"); session.update("updateCategory",c); listAll(session); session.commit(); session.close(); } private static void listAll(SqlSession session) { List<Category> cs = session.selectList("listCategory"); for (Category c : cs) { System.out.println(c.getName()); } } }
<update id="updateCategory" parameterType="Category" > update category_ set name=#{name} where id=#{id} </update>
- 查询所有
session.selectList执行查询语句
List<Category> cs = session.selectList("listCategory");
listCategory对应的sql语句
<select id="listCategory" resultType="Category"> select * from category_ </select>
package com.how2java; 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 com.how2java.pojo.Category; public class TestMybatis { public static void main(String[] args) throws IOException { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession session = sqlSessionFactory.openSession(); listAll(session); session.commit(); session.close(); } private static void listAll(SqlSession session) { List<Category> cs = session.selectList("listCategory"); for (Category c : cs) { System.out.println(c.getName()); } } }
<select id="listCategory" resultType="Category"> select * from category_ </select>
Mybatis基础-CRUD
最新推荐文章于 2023-11-17 14:00:16 发布