SQL映射文件

1. 定义sql映射xml文件：

 

 1 <insert id="insertUser" parameterType="com.atguigu.ibatis.bean.User">
 2     insert into users(name, age) values(#{name}, #{age});
 3 </insert>
 4 
 5 <delete id="deleteUser" parameterType="int">
 6     delete from users where id=#{id}
 7 </delete>
 8         
 9 <update id="updateUser" parameterType="com.atguigu.ibatis.bean.User">
10     update users set name=#{name},age=#{age} where id=#{id}
11 </update>
12         
13 <select id="selectUser" parameterType="int" resultType="com.atguigu.ibatis.bean.User">
14     select * from users where id=#{id}
15 </select>
16         
17 <select id="selectAllUsers" resultType="com.atguigu.ibatis.bean.User">
18     select * from users
19 </select>
View Code

 

2.在config.xml中注册这个映射

 

1 <mapper resource=" com/atguigu/ibatis/bean/userMapper.xml"/>
View Code

 

3 配置接口实现xml读取

1 //注意xml必须在接口同一个包下
2 <mapper class=" com.atguigu.ibatis.bean.userMapper"/>
View Code

 3.1在dao类中调用

 

1 public User getUserById(int id) {
2     SqlSession session = sessionFactory.openSession();
3     UserMapper mapper = session.getMapper(UserMapper.class);
4     User user = mapper.getUserById(id);
5     return user;
6 }
View Code

 

4注解开发

 1 public interface UserMapper {
 2     @Insert("insert into users(name, age) values(#{name}, #{age})")
 3     public int insertUser(User user);
 4 
 5     @Delete("delete from users where id=#{id}")
 6     public int deleteUserById(int id);
 7             
 8     @Update("update users set name=#{name},age=#{age} where id=#{id}")
 9     public int updateUser(User user);
10 
11     @Select("select * from users where id=#{id}")
12     public User getUserById(int id);
13 
14     @Select("select * from users")
15     public List<User> getAllUser();
16 }
View Code

4.1在config中注册这个映射接口

 

1 <mapper class="com.atguigu.ibatis.crud.ano.UserMapper"/>
View Code

 

 

 

 

posted @ 2018-12-01 20:09  MacJerry  阅读(37)  评论(0)    收藏  举报