mybatis 詳解（三）

1、創建MySQL資料庫：mybatisDemo和表：user2、建立一個Java工程， 並導入相應的jar包， 具體目錄如下3、在 MyBatisTest 工程中添加資料庫設定檔 mybatis-configuration.xml4、定義表所對應的實體類5、定義操作 user 表的注解介面 UserMapper.javapackage com.ys.annocation;import org.apache.ibatis.annotations.Delete;import org.apache.ibatis.annotations.Insert;import org.apache.ibatis.annotations.Select;import org.apache.ibatis.annotations.Update;import com.ys.po.User;public interface UserMapper {//根據 id 查詢 user 表資料@Select("select * from user where id = #{id}")public User selectUserById(int id) throws Exception;//向 user 表插入一條資料@Insert("insert into user(username,sex,birthday,address) value(#{username},#{sex},#{birthday},#{address})")public void insertUser(User user) throws Exception;//根據 id 修改 user 表資料@Update("update user set username=#{username},sex=#{sex} where id=#{id}")public void updateUserById(User user) throws Exception;//根據 id 刪除 user 表資料@Delete("delete from user where id=#{id}")public void deleteUserById(int id) throws Exception;}6、向 mybatis-configuration.xml 設定檔中註冊 UserMapper.java 文件 7、創建測試類package com.ys.test;import java.io.InputStream;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Before;import org.junit.Test;import com.ys.annocation.UserMapper;import com.ys.po.User;public class UserAnnocationTest {//定義 SqlSessionSqlSession session =null;@Beforepublic void init{//定義mybatis全域設定檔String resource = "mybatis-configuration.xml";//載入 mybatis 全域設定檔InputStream inputStream = CRUDTest.class.getClassLoader.getResourceAsStream(resource);//構建sqlSession的工廠SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder.build(inputStream);//根據 sqlSessionFactory 產生 sessionsession = sessionFactory.openSession;}//注解的增刪改查方法測試@Testpublic void testAnncationCRUD throws Exception{//根據session獲取 UserMapper介面UserMapper userMapper = session.getMapper(UserMapper.class);//調用selectUserById方法User user = userMapper.selectUserById(1);System.out.println(user);//調用 insertUser 方法User user1 = new User;user1.setUsername("aliks");user1.setSex("不詳");userMapper.insertUser(user1);//調用 updateUserById 方法User user2 = new User;user2.setId(6);user2.setUsername("lbj");userMapper.updateUserById(user2);//調用 方法userMapper.deleteUserById(6);session.commit;session.close;}}

注意：注解配置我們不需要 userMapper.xml 文件了