Hibernate【3】——Service层

1:整体目录

(1)完成UserSerivce接口

(2)完成UserSerivceImpl类,继承UserSerivce接口

(3)写测试类

2:UserSerivce接口

package com.demo.service;

import java.util.List;

import com.demo.model.User;

public interface UserService {
    /**
     * 添加用户
     * @param user
     * @return
     */
    public boolean add(User user);
    
    /**
     * 修改用户
     * @param user
     * @return
     */
    public boolean update(User user);
    
    /**
     * 删除用户
     * @param user
     * @return
     */
    public boolean delete(User user);
    
    /**
     * 根据id获取用户
     * @param obj
     * @param id
     * @return
     */
    public User getById(Class obj,int id);
    
    /**
     * 统计符合一定条件用户的数量
     * @param hql
     * @param param
     * @return
     */
    public int getCount(String hql,String[] param);
    
    /**
     * 查询符合一定条件的用户
     * @param hql
     * @param param
     * @return
     */
    public List<User> query(String hql,String[] param);
    
}

3:UserSerivceImpl类

package com.demo.service;

import java.util.List;

import com.demo.dao.BaseDAO;
import com.demo.model.User;

public class UserServiceImpl implements UserService {

    private BaseDAO dao = new BaseDAO();
    @Override
    public boolean add(User user) {
        boolean flag = false;
        flag = dao.add(user);
        return flag;
    }

    @Override
    public boolean delete(User user) {
        boolean flag = false;
        flag = dao.delete(user);
        return flag;
    }

    @Override
    public User getById(Class obj, int id) {
        User u = (User)dao.get(User.class, id);
        return u;
    }

    @Override
    public int getCount(String hql, String[] param) {
        int cnt = 0;
        cnt = dao.getCount(hql, param);
        return cnt;
    }

    @Override
    public List<User> query(String hql, String[] param) {
        List<User> list = dao.query(hql, param);
        return list;
    }

    @Override
    public boolean update(User user) {
        boolean flag = false;
        flag = dao.update(user);
        return flag;
    }

}

4:TestUserSerivce类

注意统计Count的hql语句:

select count(*) from User u where u.userName=?

package com.demo.test;

import com.demo.model.User;
import com.demo.service.UserService;
import com.demo.service.UserServiceImpl;

public class TestUserService {
    public static void main(String[] args) {
        UserService us = new UserServiceImpl();
        //test add
        User user1 = new User();
        user1.setUserName("asdf");
        user1.setUserPwd("1234");
        us.add(user1);
        //test delete
        User user2 = new User();
        user2.setId(3);
        us.delete(user2);
        //test getById
        User user3 = us.getById(User.class, 4);
        System.out.println(user3.getId()+"-->"+user3.getUserName()+"-->"+user3.getUserPwd());        
        //test Count
        String[] param = {"asdf"};
        int cnt = us.getCount("select count(*) from User u where u.userName=?", param);        
        System.out.println("共有asdf "+Integer.toString(cnt)+" 个。");
        //test query
        //test update
        User user4 = new User();
        user4.setId(4);
        user4.setUserPwd("000000");
        us.update(user4);
    }
}