Advertisement
Guest User

Untitled

a guest
Jan 17th, 2019
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.61 KB | None | 0 0
  1. String sql =
  2.           "SET NOCOUNT ON; "
  3.         + "DECLARE @id INT = ?; "
  4.         + "DECLARE @col2 VARCHAR(10) = ?; "
  5.         + "DECLARE @col3 VARCHAR(10) = ?; "
  6.         + "INSERT INTO mytable "
  7.         + "SELECT @id, @col2, @col3 "
  8.         + "WHERE NOT EXISTS (SELECT 1 FROM mytable "
  9.         + "                  WHERE id = @id AND col2 = @col2 AND col3 = @col3);";
  10. PreparedStatement ps = conn.prepareStatement(sql);
  11. for (int i = 0; i < 4; i++) {
  12.     ps.setInt(1, i);
  13.     ps.setString(2, String.format("foo%s", i));
  14.     ps.setString(3, String.format("bar%s", i));
  15.     ps.addBatch();
  16. }
  17. ps.executeBatch();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement