SSH整合开发Demo--酒店预订系统-->DAO层设计

DAO层设计的主要任务是创建DAO接口以及创建DAO接口的实现类。
本系统一共定义了4个DAO接口。

AdminDAO.java文件：

package com.integration.dao;
import java.util.List;
import com.integration.entity.Admin;
public interface AdminDAO {
    public void saveAdmin(Admin admin);
    public List<Admin> findAllAdmin();
    public void removeAdmin(Admin admin);
    public void updateAdmin(Admin admin);
    public Admin findAdminById(Integer id);
    public Admin loginAdmin(Admin admin);
}

RoomDAO.java文件：

package com.integration.dao;
import java.util.List;
import com.integration.entity.Room;
public interface RoomDAO {
    public void saveRoom(Room room);
    public List<Room> findAllRoom();        
    public void removeRoom (Room room); 
    public void updateRoom (Room room); 
    public Room findRoomById(Integer id);   
}

OrderDAO.java文件：

package com.integration.dao;
import java.util.List;
import com.integration.entity.Order;
import com.integration.entity.User;
public interface OrderDAO {
    public void saveOrder(Order order);
    public List<Order> findAllOrder();
    public void removeOrder(Order order);
    public void updateOrder(Order order);
    public Order findOrderById(Integer id);
    public List<Order> getUserOrder(User user);
    public Order findOrderByUseridAndRoomid(int userid, int roomid);
}

UserDAO.java文件：

package com.integration.dao;
import java.util.List;
import com.integration.entity.User;
public interface UserDAO {
    public void saveUser(User user);
    public List<User> findAllUsers();
    public void removeUser(User user);
    public void updateUser(User user);
    public User findUserById(Integer id);
    public User loginUser(User user);
}

DAO接口实现类也有4个，分别实现了AdminDAO、HotelDAO、OrderDAO和UserDAO这4个接口。

AdminDAOImpl.java文件：

package com.integration.dao.impl;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.integration.entity.Admin;
import com.integration.dao.AdminDAO;
public class AdminDAOImpl extends HibernateDaoSupport implements AdminDAO {
    @SuppressWarnings("unchecked")
    public List<Admin> findAllAdmin() {
        String hql = "from Admin admin order by admin.username desc)";
        return (List<Admin>) this.getHibernateTemplate().find(hql);
    }
    public Admin findAdminById(Integer id) {
        return (Admin) this.getHibernateTemplate().get(Admin.class, id);
    }
    public void removeAdmin(Admin admin) {
        this.getHibernateTemplate().delete(admin);
    }
    public void saveAdmin(Admin admin) {
        this.getHibernateTemplate().save(admin);
    }
    public void updateAdmin(Admin admin) {
        this.getHibernateTemplate().update(admin);
    }
    @SuppressWarnings("unchecked")
    public Admin loginAdmin(Admin admin) {
        String hql = "from Admin admin where admin.username='"
                + admin.getUsername() + "' and admin.password='"
                + admin.getPassword() + "'";
        List<Admin> admins = (List<Admin>) this.getHibernateTemplate()
                .find(hql);
        if (admins.size() > 0) {
            return admins.get(0);
        }
        return null;
    }

}

OrderDAOImpl.java文件：

package com.integration.dao.impl;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.integration.entity.Order;
import com.integration.entity.User;
import com.integration.dao.OrderDAO;
public class OrderDAOImpl extends HibernateDaoSupport implements OrderDAO {
    @SuppressWarnings("unchecked")
    public List<Order> findAllOrder() {
        String hql = "from Order ord order by ord.orderid desc";
        return (List<Order>) this.getHibernateTemplate().find(hql);
    }
    public Order findOrderById(Integer id) {
        return (Order) this.getHibernateTemplate().get(Order.class, id);
    }
    public void removeOrder(Order order) {
        this.getHibernateTemplate().delete(order);
    }
    public void saveOrder(Order order) {
        this.getHibernateTemplate().save(order);
    }
    public void updateOrder(Order order) {
        this.getHibernateTemplate().update(order);
    }
    @SuppressWarnings("unchecked")
    public List<Order> getUserOrder(User user) {
        String hql = "from Order ord where ord.userid='" + user.getUserid()
                + "'";
        return (List<Order>) this.getHibernateTemplate().find(hql);
    }
    @SuppressWarnings("unchecked")
    public Order findOrderByUseridAndRoomid(int userid, int roomid) {
        String hql = "from Order ord where ord.userid=" + userid
                + " and ord.roomid=" + roomid + "";
        List<Order> orders = (List<Order>) this.getHibernateTemplate()
                .find(hql);
        return orders == null ? null : orders.get(0);
    }
}

RoomDAOImpl.java文件：

package com.integration.dao.impl;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.integration.entity.Room;
import com.integration.dao.RoomDAO;
public class RoomDAOImpl extends HibernateDaoSupport implements RoomDAO {
    @SuppressWarnings("unchecked")
    public List<Room> findAllRoom() {
        String hql = "from Room room order by room.roomid desc";
        return (List<Room>) this.getHibernateTemplate().find(hql);
    }
    public Room findRoomById(Integer id) {
        return (Room) this.getHibernateTemplate().get(Room.class, id);
    }
    public void removeRoom(Room room) {
        this.getHibernateTemplate().delete(room);
    }
    public void saveRoom(Room room) {
        this.getHibernateTemplate().save(room);
    }
    public void updateRoom(Room room) {
        this.getHibernateTemplate().update(room);
    }
}

UserDAOImpl.java文件：

package com.integration.dao.impl;
import java.util.List;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import com.integration.entity.User;
import com.integration.dao.UserDAO;
public class UserDAOImpl extends HibernateDaoSupport implements UserDAO {
    public void saveUser(User user) {
        this.getHibernateTemplate().save(user);
    }
    @SuppressWarnings("unchecked")
    public List<User> findAllUsers() {
        String hql = "from User user order by user.userid desc";
        return (List<User>) this.getHibernateTemplate().find(hql);
    }
    public void removeUser(User user) {
        this.getHibernateTemplate().delete(user);
    }
    public void updateUser(User user) {
        this.getHibernateTemplate().update(user);
    }
    public User findUserById(Integer id) {
        User user = (User) this.getHibernateTemplate().get(User.class, id);

        return user;
    }
    @SuppressWarnings("unchecked")
    public User loginUser(User user) {
        String hql = "from User user where user.username='"
                + user.getUsername() + "' and user.password='"
                + user.getPassword() + "'";
        List<User> users = (List<User>) this.getHibernateTemplate().find(hql);
        if (users.size() > 0) {
            return users.get(0);
        }
        return null;
    }
}

后面马上继续业务逻辑层设计……