prepareStatement pstmt=conn.prepareStatement("select * from et where id=? and i=? and j=?"); ps.setInt(1,id); ps.setString(2,i); ps.setString(3,j); ResultSet rs = ps.executeQuery(); while(rs.next()) { .... }
select top ? id, i, j from et where id=? and i=? and j=? group by id,i,j
pstmt.setInt(1, state);
pstmt.setInt(2, repayId);
pstmt.execute();
select id, i, j from et where id=? and i=? and j=? limit ?
ps.setInt(1,id);
ps.setString(2,i);
ps.setString(3,j);
ResultSet rs = ps.executeQuery();
while(rs.next())
{
....
}