How to check the record in database exist or not if exist add to jtextarea else left blank (netbean)

Question

Below is my code, which isn't working.
if can please provide example code or edit my code, TY

try {
        Class.forName("com.mysql.jdbc.Driver");
        con = DriverManager.getConnection("jdbc:mysql://localhost/timetable", "root", "");
        String sql1 = "select * from tt where day like '%monday%'";
        String sql = "select * from tt where time = 8 ";
        pst = con.prepareStatement(sql);
        pst = con.prepareStatement(sql1);
        rs = pst.executeQuery();
    if (rs.next()) {
        String sC = rs.getString("subjectcode");
        String sN = rs.getString("subjectname");
        String Ln = rs.getString("lecturer");
        monday8to10.setText(sC + newline + "" + sN + newline + "" + Ln);
    } else {
        monday8to10.setText("");
    }
} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

try {
    Class.forName("com.mysql.jdbc.Driver");
    con = DriverManager.getConnection("jdbc:mysql://localhost/timetable", "root", "");
    String sql1 = "select * from tt where day like '%monday%'";
    String sql = "select * from tt where time = 10 ";
    pst = con.prepareStatement(sql1);
    pst = con.prepareStatement(sql);
    rs = pst.executeQuery();

    while (rs.next()) {
        String sC = rs.getString("subjectcode");
        String sN = rs.getString("subjectname");
        String Ln = rs.getString("lecturer");
        monday10to12.setText(sC + newline + "" + sN + newline + "" + Ln);
    }
} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

Answer 1

I believe to start, pst.executeQuery() requires an argument. You are currently no executing a query at all?

pst.executeQuery(sql1);

Seconds, you need to execute 1 query at a time: String sql1 = "select * from tt where day like '%monday%'"; String sql = "select * from tt where time = 10 ";

becomes String sql1 = "select * from tt where time = 10 and day like '%monday%'";

For example, I was just looking back at some of my old DB code.

        query = "SELECT m.title, m.year_, m.rt_picture, m.imdb_picture, m.movie_id, u.user_score, u.user_id FROM movie_navigator.movies m, movie_navigator.userratings u WHERE m.movie_id=u.movie_id AND u.movie_id=" + movieId + " LIMIT " + queryPageSize + " OFFSET " + (queryPageSize*pageNumber) + ";";
    try{
        stmt = conn.createStatement();
        results = stmt.executeQuery(query);
        while(results.next()){