MyBatis的的xml+接口方式实现接口方式实现crud功能功能
Mybatis的的xml+接口方式实现接口方式实现crud功能功能
User.java
package com.qfedu.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class User {
private int uid;
private String username;
private String password;
private int age;
private String addr;
}
IUserDao.java
package com.qfedu.dao;
import com.qfedu.pojo.User;
import java.util.List;
public interface IUserDao {
/**
* 查询所有的User对象
* @return User对象的列表
*/
List getAllUsers();
/**
* 新增一个User对象
* @param u 要新增的用户对象
* @return 受影响的行数
*/
int saveUser(User u);
}
UserMapper.xml
select * from user
insert into user values(null, #{username}, #{password}, #{age}, #{addr})
update user set username = #{username}, password =#{password}, age=#{age}, addr = #{addr} where uid = #{uid}
SessionUtils.java
package com.qfedu.util;
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 java.io.IOException;
public class SessionUtils {
private static SqlSession mSession = null;
private static SqlSessionFactory mFactory = null;
评论0
最新资源