FilesExpand file tree

 master

/

Test2.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

19 lines (18 loc) · 736 Bytes

 master

/

Test2.java

Copy path

Top

File metadata and controls

• Code
• Blame

19 lines (18 loc) · 736 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

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

public class Test2 {

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

long starttime = System.currentTimeMillis();

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

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

PreparedStatement pstmt = conn.prepareStatement("insert into userinfo(name) values(?)");

for (int i = 0; i < 1000000; i++) {

pstmt.setString(1,i+"");

pstmt.addBatch();

}

pstmt.executeBatch();

conn.close();

System.out.println(System.currentTimeMillis()-starttime);

}

}