Hotel_service_system/ReserveDaoImp.java

package com.lsy.dao.impl;

import com.lsy.dao.ReserveDao;
import com.lsy.model.Accountlsy;
import com.lsy.model.Reserve;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Collections;
import java.util.List;

public class ReserveDaoImp implements ReserveDao {

    @Override
    public List<Reserve> findAll() {
        return Collections.emptyList();
    }

    @Override
    public Reserve findByroomN(String roomN) {

        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        Reserve reserve = null;
        try {
            conn = DBHelper.getConnection();
            String sql = "select * from Reserve where roomN = ?";
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, roomN);
            rs = pstmt.executeQuery();
            if (rs.next()) {
                reserve = new Reserve();

                reserve.setRoomN(rs.getString("roomN"));
                reserve.setName(rs.getString("name"));
                reserve.setNum(rs.getString("num"));
                reserve.setState(rs.getString("state"));
                reserve.setService(rs.getString("service"));
                reserve.setTime(rs.getDate("time"));
                reserve.setPhone(rs.getString("phone"));


            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException e) {
                }
            }
            if (pstmt != null) {
                try {
                    pstmt.close();
                } catch (SQLException e) {
                }
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                }
            }

        }
        return reserve;
    }

    @Override
    public int create(Reserve Reserve) {
        return 0;
    }

    @Override
    public int modify(Reserve Reserve) {
        return 0;
    }

    @Override
    public int delect(Reserve Reserve) {
        return 0;
    }

    public static void main(String[] args) {
        ReserveDaoImp dao = new ReserveDaoImp();

        Reserve  reserve= new Reserve();
//        Scanner scanner = new Scanner(System.in);
//        accountlsy.setUseridlsy(scanner.next());
//        accountlsy.setPasswordlsy("123456");
//        accountlsy.setEmaillsy("admin");
//        accountlsy.setNamelsy("admin");
//        accountlsy.setAddrlsy("admin");
//        accountlsy.setCitylsy("admin");
//        accountlsy.setCountrylsy("admin");
//        accountlsy.setPhonelsy("admin");
//        dao.delect(accountlsy);
//        dao.create(accountlsy);
        dao.findByroomN("1");
//        dao.findAll();

    }
}