Advertisement
Guest User

Untitled

a guest
Jan 29th, 2020
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. drop alias if exists method1; CREATE ALIAS method1 AS $$
  2. import java.sql.Connection;
  3. import java.sql.PreparedStatement;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6. import java.util.Collection;
  7. import java.util.HashSet;
  8. import java.util.stream.Collectors;
  9. @CODE
  10. ResultSet method1(final Connection conn, final String wl_full_name, String drop_down, String date) throws SQLException
  11. {
  12.  
  13. PreparedStatement ps = conn.prepareStatement("SELECT * from ou2byqcb54i6vc4haaaqebilc40 where wl_full_name='" + wl_full_name + "' and text_input = '" + drop_down + "' and wl_start_time = '" + date + "'");
  14. return ps.executeQuery();
  15. }
  16. $$;
  17. {call method1(?,?,?);}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement