java与数据库连接后如何实现两个表之间的查询

SELECT t.* FROM student st JOIN teach t ON st.teach_id=t.id

WHERE st.studentNo=?

List B

for(int i=0i<A.size()i++)

if(!B.contains(A.get(i)))

insert(A.get(i))