public class User {
private int id;
private String name;
private Date birthday;
private double salary;
//set,get方法
}
三、DAO接口
?
?
public interface UserMapper {
void save(User user);
void update(User user);
void delete(int id);
User findById(int id);
List findAll();
}
四、SQL映射文件：userMapper.xml(与接口忽略大小写同名)
?
?
insert into s_user(user_name,user_birthday,user_salary)
values(#{name},#{birthday},#{salary})
update s_user
set user_name = #{name},
user_birthday = #{birthday},
user_salary = #{salary}
where user_id = #{id}
delete from s_user
where user_id = #{id}
五、Spring配置文件beans.xml
?
?
六、mybatis的配置文件: mybatis-config.xml
?
?
七、测试
?
?
@RunWith(SpringJUnit4ClassRunner.class) //使用Springtest测试框架
@ContextConfiguration("/beans.xml") //加载配置
public class SMTest {
@Autowired //注入
private UserMapper userMapper;
@Test
public void save() {
User user = new User();
user.setBirthday(new Date());
user.setName("marry");
user.setSalary(300);
userMapper.save(user);
System.out.println(user.getId());
}
@Test
public void update() {
User user = userMapper.findById(2);
user.setSalary(2000);
userMapper.update(user);
}
@Test
public void delete() {
userMapper.delete(3);
}
@Test
public void findById() {
User user = userMapper.findById(1);
System.out.println(user);
}
@Test
public void findAll() {
List users = userMapper.findAll();
System.out.println(users);
}
}