IUserDao
public interface IUserDao {
List findAll();
void update(int id,String username,String password);
void delete(int id);
void insert(String username,String password);
}
UserServece
import java.util.List;
@Service
public class UserService implements IUserService {
@Autowired
private IUserDao userDao;
@Override
public void update(int id, String username, String password) {
userDao.update(id,username,password);
}
@Override
public void delete(int id) {
userDao.delete(id);
}
@Override
public void insert(String username, String password) {
userDao.insert(username,password);
}
@Override
public List<User> findAll() {
return userDao.findAll();
}
}
UserMapper.xml
<?xml version="1.0" encoding="UTF-8"?> select * from fuser delete * from fuser where id=#{id} update fuser set username=#{username},password=#{password} where id=#{id} insert into fuser(username,password) value(#{username},#{password})test
public class test {
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext(“applicationContext.xml”);
IUserService userService = (IUserService) context.getBean(“userService”);
List users = userService.findAll();
System.out.println(users);
}
}