房间预订检查

Question

在我的项目中，我创建了一个预订房间的系统。我的问题涉及在同一天预订房间。这是关于预订的数据库。

id_book,login,email,typeroom,numroom,arrivaldate,departureddate。

这是检查某个时间段内房间是否可用的代码：

try {

            Class.forName("com.mysql.cj.jdbc.Driver");

      //  out.println("driver loaded");

            Connection  con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Hotel?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root" ,"123456789");

            out.println("Connect");

            Statement  st =  con.createStatement();

            Statement stmt = con.createStatement();

            out.println("connection successfull");

            String check = ("SELECT res1.id_prenotazione, res1.typeroom, res1.arrivaldate, res1.departuredate\n" + 

                    "FROM reservation res1, reservation res2\n" + 

                    "WHERE ( res1.typeroom = res2.typeroom ) \n" + 

                    "AND (res1.arrivaldate <= res2.departuredate)\n" + 

                    "AND (res2.arrivaldate <= res1.departuredate)");

            String check1 = ("SELECT count(*) FROM reservation WHERE arrivaldate");

            ResultSet rs2  = stmt.executeQuery(check);

            ResultSet rs3 = stmt.executeQuery(check1);

            if( rs2 != rs3) {

            int rs =  st.executeUpdate("insert into reservation (login,email,typeroom,numroom,arrivaldate,departuredate)values ('"+login+"','"+email+"','"+typeroom+"','"+numroom+"','"+arrivaldate+"','"+departuredate+"')");

            }

            String getResultSet = ("SELECT count(*) FROM reservation WHERE arrivaldate ='"+arrivaldate+"'");

            String rs1 = ("SELECT count(*) FROM reservation WHERE arrivaldate");

            if (getResultSet != rs1) {

                int i=st.executeUpdate("DELETE FROM reservation WHERE id_prenotazione ='"+id_prenotazione+"'");

            }

问题是这样我一直在记录相同日期的相同房间，我该如何解决？