Java DAO: Query Appointments by Nurse with Two Fuzzy Search Criteria

public List queryByNurse(PageModel page, String key1, String key2, String docId) {\n List list = new ArrayList<>();\n Connection connection = null;\n try {\n //定义集合存放数据\n //获取链接\n connection = DbUtil.getConnection();\n //定义sql语句\n String sql = "SELECT av.*, u.qrcode\n" +\n "FROM user u\n" +\n "JOIN appointment_view av ON u.id = av.user_id\n" +\n "JOIN vaccinum v ON av.vaccinum_id = v.id\n" +\n "JOIN vaccinum_type vt ON v.type = vt.id\n" +\n "WHERE u.qrcode = 1 \n" +\n "AND doctor_id=?\n" +\n "AND vt.status = 1 \n" +\n "AND user_name LIKE ? \n" +\n "AND av.address LIKE ? \n" +\n "ORDER BY av.status ASC \n" +\n "LIMIT ?,?;";\n PreparedStatement statement = connection.prepareStatement(sql);\n statement.setString(1, docId);\n statement.setString(2, "%" + key1 + "%");\n statement.setString(3, "%" + key2 + "%");\n statement.setInt(4, page.getSqlStart());\n statement.setInt(5, page.getNums());\n //查询输出\n ResultSet resultSet = statement.executeQuery();\n //result循环遍历\n while (resultSet.next()) {\n int id = resultSet.getInt("id");\n int userId = resultSet.getInt("user_id");\n int vaccinumId = resultSet.getInt("vaccinum_id");\n int doctorId = resultSet.getInt("doctor_id");\n String address = resultSet.getString("address");\n String appDate = resultSet.getString("app_date");\n String injectedTime = resultSet.getString("injected_time");\n int status = resultSet.getInt("status");\n String createTime = resultSet.getString("create_time");\n\n String vaccinumName = resultSet.getString("vaccinum_name");\n String doctorName = resultSet.getString("doctor_name");\n String userName = resultSet.getString("user_name");\n\n Appointment appointment = new Appointment(id, userId, vaccinumId, doctorId, address, appDate, injectedTime, status, createTime, userName, vaccinumName, doctorName);\n int qrcode = resultSet.getInt("qrcode");\n appointment.setQrcode(qrcode);\n //添加对象到list集合\n list.add(appointment);\n }\n //返回\n return list;\n } catch (Exception e) {\n System.err.println("出现异常" + e.getMessage());\n e.printStackTrace();\n return null;\n } finally {\n //关闭链接\n DbUtil.close(connection);\n }\n }