FilesExpand file tree

 master

/

Test.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

22 lines (21 loc) · 948 Bytes

 master

/

Test.java

Copy path

Top

File metadata and controls

• Code
• Blame

22 lines (21 loc) · 948 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

public class Test {

public static void main(String[] args) throws Exception{

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/db1","root","123456");

PreparedStatement pstmt = conn.prepareStatement("insert into rental(rental_date,inventory_id,customer_id,return_date,staff_id,last_update) values (?,?,?,?,?,?);");

for (int i = 200000; i < 5000000; i++) {

pstmt.setDate(1,new Date(new java.util.Date().getTime()));

pstmt.setInt(2,1);

pstmt.setInt(3,1);

pstmt.setDate(4,new Date(new java.util.Date().getTime()));

pstmt.setInt(5,1);

pstmt.setDate(6,new Date(new java.util.Date().getTime()));

pstmt.execute();

}

conn.close();

}

}