Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void tapahtumatTesti() {
- long alku = System.nanoTime();
- String lause = "INSERT INTO Tapahtuma (Paikka_id, Paikka_nimi, Paketti_seurantakoodi, kuvaus, aika) VALUES (?,?,?,?,?)";
- try (Connection conn = Connect.connect()) {
- PreparedStatement ps = conn.prepareStatement("BEGIN");
- ps.executeUpdate();
- ps = conn.prepareStatement(lause);
- for (int i = 1, j = 1; i < 1001 && j < 1001; i++) {
- if (i == 1000) {
- j++;
- i = 1;
- }
- ps.setInt(1, 123);
- ps.setString(2, "P" + j);
- ps.setString(3, "ABC" + j);
- ps.setString(4, "asd");
- ps.setString(5, "asd");
- ps.executeUpdate();
- }
- ps = conn.prepareStatement("COMMIT");
- ps.executeUpdate();
- } catch (SQLException e) {
- System.out.println("Tapahtuman lisäys epäonnistui");
- }
- long loppu = System.nanoTime();
- double kestoSekunteina = 1.0 * (loppu - alku) / 1000000000;
- System.out.println("Tapahtumat: " + kestoSekunteina);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement