package dao;
import java.util.List;
import model.User;
public interface UserDao {
public User getUser(int i);
public List<User> getAllUser();
public int insertUser(User u);
public int updateUser(User u);
public int deleteUser(int i);
}
<?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="dao.UserDao">
<select id="getUser" parameterType="int"
resultType="User">
select * from t_user where id=#{id}
</select>
<select id="getAllUser" resultType="User">
select * from t_user
</select>
<delete id="deleteUser" parameterType="int" >
delete from t_user where id=#{id}
</delete>
<update id="updateUser" parameterType="User">
update t_user set username=#{username}, password=#{password} where id=#{id}
</update>
<insert id="insertUser" parameterType="User">
insert into t_user(username,password) values(#{username},#{password})
</insert>
</mapper>
package model;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Component;
@Component
@Scope("prototype")
public class User {
private int id;
private String username;
private String password;
public User() {
super();
}
public User(String username, String password) {
super();
this.username = username;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
package service;
import java.util.List;
import model.User;
public interface IUserSrv {
public User getUser(int i);
public List<User> getAllUser();
public int insertUser(User u);
public int updateUser(User u);
public int deleteUser(int i);
}
package service;
import java.util.List;
import javax.annotation.Resource;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
import dao.UserDao;
import model.User;
@Component
@Transactional
public class UserSrv implements IUserSrv {
@Resource
private UserDao userDao;
@Override
public User getUser(int i) {
// TODO 自动生成的方法存根
return userDao.getUser(i);
}
@Override
public List<User> getAllUser() {
// TODO 自动生成的方法存根
return userDao.getAllUser();
}
@Override
public int insertUser(User u) {
// TODO 自动生成的方法存根
return userDao.insertUser(u);
}
@Override
public int updateUser(User u) {
// TODO 自动生成的方法存根
return userDao.updateUser(u);
}
@Override
public int deleteUser(int i) {
// TODO 自动生成的方法存根
return userDao.deleteUser(i);
}
}
package test;
import javax.annotation.Resource;
import org.springframework.stereotype.Component;
import model.User;
import service.IUserSrv;
import util.BeanHelper;
@Component
public class Test {
@Resource
private User user;
public static void main(String[] args) {
IUserSrv userSrv = (IUserSrv) BeanHelper.getBean("userSrv");
System.out.println(userSrv.getUser(1).getUsername());
Test t = (Test) BeanHelper.getBean("test");
t.user.setUsername("dd");
t.user.setPassword("xxx");
System.out.println(userSrv.insertUser(t.user));
}
}
package util;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class BeanHelper {
private BeanHelper(){}
private static ApplicationContext ac = new ClassPathXmlApplicationContext("spring.xml");
public static Object getBean(String beanName){
return ac.getBean(beanName);
}
}