1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
 
public class Go {
 
  public static void main(String[] args) {
    for (int i = 0; i < 10000; i++) {//**回圈套在外面**
      try {
 
        Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
 
        String str = "jdbc:microsoft:sqlserver://localhost:1433"//路徑
            + ";databasename=XMLDB5";
 
        Connection con = DriverManager.getConnection(str, "sa", "1234");//建立本機連線
        Statement stmt = con.createStatement();//建立方法
 
        String ssql1 = "  INSERT INTO F (Q)  Values('keo')  ";
        stmt.executeUpdate(ssql1);
        System.out.println(i);
 
        con.close();
 
      } catch (Exception ex) {
        ex.printStackTrace();
      }
    }
  }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

public class Go {
 
  public static void main(String[] args) {
 
    try {
 
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
 
      String str = "jdbc:microsoft:sqlserver://localhost:1433"//路徑
          + ";databasename=XMLDB5";
 
      Connection con = DriverManager.getConnection(str, "sa", "1234");//建立本機連線
      Statement stmt = con.createStatement();//建立方法
      for (int i = 0; i < 10000; i++) {//**迴圈套在裡面**
        String ssql1 = "  INSERT INTO F (Q)  Values('keo')  ";
        stmt.executeUpdate(ssql1);
        System.out.println(i);
      }
      con.close();
 
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }
 
}

1
2
3
4
5
6
7
8
9
10
11

java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
  at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
  at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
  at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
  at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
  at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
  at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
  at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at Go.main(Go.java:30

1
2
3
4
5
6
7
8
9
10
11

  private static Connection conn;
  static {
    try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      String str = "jdbc:microsoft:sqlserver://localhost:1433;databasename=One";
      Connection con = DriverManager.getConnection(str, "sa", "1234");//建立本機連線
      Statement stmt = con.createStatement();//建立方法
    } catch (Exception ex) {
      System.out.println("SQLException: " + ex.getMessage());
    }
  }