Mybatis实现单表的增删改查

mybtis快速入门–查询单表所有字段

①首先导入依赖

<dependencies>
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.12</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
    </dependency>
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.5</version>
    </dependency>
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>
</dependencies>

②需要有接口 接口中有方法

新建四个包 web service dao domain

这个新写的接口放入dao中

另外返回的list集合中的user也要进行创建 在domain中进行创建

public interface UserDao {
   public List<User> findAllUser();
}

③主配置文件–SqlSessionConfiguraction.xml , 直接new File 即可

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql:///ssm"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
    </environments>
<!--建立和sql映射文件的关系-->
    <mappers>
        <mapper resource="UserDao.xml"/>
    </mappers>
</configuration>

④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.nantian.dao.UserDao">
    <select id="findAllUser" resultType="com.nantian.domain.User">
    select * from t_user
  </select>
</mapper>

⑤最后在写一个测试类进行测试即可

   InputStream is = Resources.getResourceAsStream("SqlSessionConfiguraction.xml");
   SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
   SqlSessionFactory sqlSessionFactory = builder.build(is);
   SqlSession sqlSession = sqlSessionFactory.openSession();
   UserDao userDao = sqlSession.getMapper(UserDao.class);
   List<User> users = userDao.findAll();
   System.out.println(users);
   sqlSession.close();

总结一下:

主配置文件 :

首先主配置文件需要连接到数据库 configuration , 然后在连接到Sql配置文件→mappers , resources写sql配置文件

 <mappers>
        <mapper resource="UserDao.xml"/>
 </mappers>

Sql配置文件 :

关键字mapper , namespace找到唯一的接口 , id 是方法名 , 进一步定位 , resultType是返回值结果

如果是List<对象> 对象全限定类名 , 如果是基本类型 使用基本类型名称

<mapper namespace="com.nantian.dao.UserDao">
    <select id="findAllUser" resultType="com.nantian.domain.User">
    select * from t_user
  </select>
</mapper>

mybatis增删改查

只需要修改UserDao.xml 文件

以及测试文件即可

<mapper namespace="com.itheima.dao.UserDao">

  <select id="findAllUser" resultType="com.itheima.domain.User">
    select * from tbl_user;
  </select>

  <insert id="saveUser" parameterType="com.itheima.domain.User">
    insert into tbl_user VALUES (null,#{username},#{PASSWORD},#{gender},#{email},#{telephone});
  </insert>

  <delete id="deleteUserById" parameterType="int">
    delete from tbl_user where id= #{id};
  </delete>

  <update id="updateUser" parameterType="com.itheima.domain.User" >
    update tbl_user set username= #{username} where id=#{id};
  </update>
</mapper>

测试文件

public class test01 {
    @Before
    public void A() throws IOException {
        InputStream is = Resources.getResourceAsStream("SqlSessionConfiguraction.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        SqlSessionFactory sqlSessionFactory = builder.build(is);
         sqlSession = sqlSessionFactory.openSession();
    }
    private  SqlSession sqlSession;
    //增
    @Test
    public void saveUser() throws IOException {

        UserDao userDao = sqlSession.getMapper(UserDao.class);
        User user = new User();
        user.setUsername("张帅");
        user.setGender("男");
        user.setPassword("1111");
        user.setTelephone("13258960266");
        user.setEmail("753835341@qq.com");
        userDao.saveUser(user);
        System.out.println(user);
        sqlSession.commit();
    }

    //删
    @Test
    public void deleteUserById(){
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        userDao.deleteUserById(9);
        sqlSession.commit();
    }
    //改
    @Test
    public void updateUser(){
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        User user = new User();
        user.setUsername("james");
        userDao.updateUser(user);
        sqlSession.commit();
    }

    //查
    @Test
    public void  findAllUser() throws IOException {
        UserDao userDao = sqlSession.getMapper(UserDao.class);
        List<User> users = userDao.findAllUser();
        System.out.println(users);
    }

    @After
    public  void B(){
        sqlSession.close();
    }
}

  parameterType:
        对象 : 全限定类名
        如果是基本数据类型 string 直接写名称即可(名称不区分大小写)
        TypeAliasRegistry 别名(外号)注册器
    #{} 如果是对象类型 书写 是get/set方法 去掉....
    #{} 如果参数只有一个 并且是基本数据类型 #{随便写}