国产chinesehdxxxx野外,国产av无码专区亚洲av琪琪,播放男人添女人下边视频,成人国产精品一区二区免费看,chinese丰满人妻videos

App下載
首頁javastatementJava JDBC - 如何限制并行流中的并發(fā)評(píng)估數(shù)...

Java JDBC - 如何限制并行流中的并發(fā)評(píng)估數(shù)...

我們想知道如何限制并行流中的并發(fā)評(píng)估數(shù)。...
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class Main {
  public static void main(String args[]) throws Exception {
    String URL = "jdbc:microsoft:sqlserver://yourServer:1433;databasename=pubs";
    String userName = "yourUser";
    String password = "yourPassword";

    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
    Connection con = DriverManager.getConnection(URL, userName, password);
    CallableStatement callstmt = con
        .prepareCall("INSERT INTO myIdentTable (col2) VALUES (?);SELECT @@IDENTITY");
    callstmt.setString(1, "testInputBatch");
    callstmt.execute();

    int iUpdCount = callstmt.getUpdateCount();
    boolean bMoreResults = true;
    ResultSet rs = null;
    int myIdentVal = -1; // to store the @@IDENTITY

    while (bMoreResults || iUpdCount != -1) {
      rs = callstmt.getResultSet();
      if (rs != null) {
        rs.next();
        myIdentVal = rs.getInt(1);
      }
      bMoreResults = callstmt.getMoreResults();
      iUpdCount = callstmt.getUpdateCount();
    }
    callstmt.close();
    con.close();
  }
}