增加
mapper文件
<?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.gec.mapper.UserMapper">
<!--编写定制sql
id:定制sql方法的id名
parameterType:输入类型
private String name;
private String sex;
private Integer age;
-->
<!--增加操作,parameterType输入类型是user对象-->
<insert id="insert" parameterType="user">
insert into tb_user(NAME,SEX,AGE) values (#{name},#{sex},#{age})
</insert>
</mapper>
main方法
package com.gec.test;
import com.gec.pojo.User;
import com.gec.utils.MyBatisSessionUtils;
import org.apache.ibatis.session.SqlSession;
public class MainTest {
public static void main(String[] args) {
insert();
}
//增加操作
public static void insert(){
SqlSession sqlSession= MyBatisSessionUtils.openSession();
User user = new User();
user.setName("dada2");
user.setAge("18");
user.setSex("b");
sqlSession.insert("com.gec.mapper.UserMapper.insert",user);
sqlSession.commit();
sqlSession.close();
}
}
删除
mapper文件
<!--根据id删除信息-->
<delete id="delete" parameterType="int">
delete from tb_user where id=#{5}
</delete>
main方法
//根据id删除操作
public static void delete(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 5;
sqlSession.delete("com.gec.mapper.UserMapper.delete",id);
sqlSession.commit();
sqlSession.close();
}
查询
根据id查询
mapper文件
<!--根据id查询-->
<select id="findUserById" parameterType="int" resultType="user">
select * from tb_user where id=#{id}
</select>
main方法
//根据id查询
public static void findUserById(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 7;
User user= sqlSession.selectOne("com.gec.mapper.UserMapper.findUserById",id);
System.out.println(user);
}
查询全部
mapper文件
<!--查询用户表的所有数据
resultType:结果集的数据类型(多条数据)
List<resultType>
resultType:在一种特殊的条件起作用:
刚好pojo的属性名与数据表的字段名刚才一致
-->
<select id="queryAllUserList" resultType="user">
select * from tb_user
</select>
main方法(有3种)
//查询全部
public static void queryAllUserList(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
//第一种,List返回
// List<User> list= sqlSession.selectList("com.gec.mapper.UserMapper.queryAllUserList");
// for (User user : list) {
// System.out.println(user);
// }
//第二种,迭代
// Cursor<User> cursor=sqlSession.selectCursor("com.gec.mapper.UserMapper.queryAllUserList");
// Iterator<User> iter=cursor.iterator();
//
// while (iter.hasNext())
// {
// User user=iter.next();
// System.out.println(user);
// }
//第三种,map集合
Map<Integer, User> map=sqlSession.selectMap("com.gec.mapper.UserMapper.queryAllUserList", "id");
for (Map.Entry<Integer, User> integerUserEntry : map.entrySet()) {
System.out.println("id="+integerUserEntry.getKey()+" user="+integerUserEntry.getValue());
}
}
修改
mapper文件
<!--实现更新功能-->
<update id="update" parameterType="user">
update tb_user set name=#{name},sex=#{sex},age=#{age} where id=#{id}
</update>
main方法
//修改数据
public static void update(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 7;
User user=sqlSession.selectOne("com.gec.mapper.UserMapper.findUserById",id);
user.setName("dada888");
user.setAge("20");
user.setSex("b");
sqlSession.update("com.gec.mapper.UserMapper.update",user);
sqlSession.commit();
sqlSession.close();
}
public static void main(String[] args) {
//insert();
// delete();
// findUserById();
// queryAllUserList();
update();
findUserById();
}
全部代码
mapper文件
<?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.gec.mapper.UserMapper">
<!--编写定制sql
id:定制sql方法的id名
parameterType:输入类型
private String name;
private String sex;
private Integer age;
-->
<!--增加操作,parameterType输入类型是user对象-->
<insert id="insert" parameterType="user">
insert into tb_user(NAME,SEX,AGE) values (#{name},#{sex},#{age})
</insert>
<!--根据id删除信息-->
<delete id="delete" parameterType="int" >
delete from tb_user where id=#{id}
</delete>
<!--根据id查询
resultType属性:返回的数据类型-->
<select id="findUserById" parameterType="int" resultType="user">
select * from tb_user where id=#{id}
</select>
<!--查询用户表的所有数据
resultType:结果集的数据类型(多条数据)
List<resultType>
resultType:在一种特殊的条件起作用:
刚好pojo的属性名与数据表的字段名刚才一致
-->
<select id="queryAllUserList" resultType="user">
select * from tb_user
</select>
<!--实现更新功能-->
<update id="update" parameterType="user">
update tb_user set name=#{name},sex=#{sex},age=#{age} where id=#{id}
</update>
</mapper>
main方法
package com.gec.test;
import com.gec.pojo.User;
import com.gec.utils.MyBatisSessionUtils;
import org.apache.ibatis.session.SqlSession;
import java.util.Map;
public class MainTest {
public static void main(String[] args) {
//insert();
// delete();
// findUserById();
// queryAllUserList();
update();
findUserById();
}
//增加操作
public static void insert(){
SqlSession sqlSession= MyBatisSessionUtils.openSession();
User user = new User();
user.setName("dada444");
user.setAge("18");
user.setSex("b");
sqlSession.insert("com.gec.mapper.UserMapper.insert",user);
sqlSession.commit();
sqlSession.close();
}
//根据id删除操作
public static void delete(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 7;
sqlSession.delete("com.gec.mapper.UserMapper.delete",id);
sqlSession.commit();
sqlSession.close();
}
//根据id查询
public static void findUserById(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 7;
User user= sqlSession.selectOne("com.gec.mapper.UserMapper.findUserById",id);
System.out.println(user);
}
//查询全部
public static void queryAllUserList(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
//第一种,List返回
// List<User> list= sqlSession.selectList("com.gec.mapper.UserMapper.queryAllUserList");
// for (User user : list) {
// System.out.println(user);
// }
//第二种,迭代
// Cursor<User> cursor=sqlSession.selectCursor("com.gec.mapper.UserMapper.queryAllUserList");
// Iterator<User> iter=cursor.iterator();
//
// while (iter.hasNext())
// {
// User user=iter.next();
// System.out.println(user);
// }
//第三种,map集合
Map<Integer, User> map=sqlSession.selectMap("com.gec.mapper.UserMapper.queryAllUserList", "id");
for (Map.Entry<Integer, User> integerUserEntry : map.entrySet()) {
System.out.println("id="+integerUserEntry.getKey()+" user="+integerUserEntry.getValue());
}
}
//修改数据
public static void update(){
SqlSession sqlSession=MyBatisSessionUtils.openSession();
int id = 7;
User user=sqlSession.selectOne("com.gec.mapper.UserMapper.findUserById",id);
user.setName("dada888");
user.setAge("20");
user.setSex("b");
sqlSession.update("com.gec.mapper.UserMapper.update",user);
sqlSession.commit();
sqlSession.close();
}
}