public static void main(String[] args) {
        // TODO code application logic here
        Connection conn=null;
        PreparedStatement ps=null;
        try{
            String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
            String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;User=sa;Password=123456;databasename=test";
            Class.forName(driver);
            conn = DriverManager.getConnection(url);
            conn.setAutoCommit(false);
            String sql = "insert into tbl_test3(id,rq) values(?,?)";//tbl_test3有2個字段，id：int，rq：datetime
            ps = conn.prepareStatement(sql);
            int i=0;
            for (i = 1; i <= 50000; i++) {
                ps.setObject(1, i);
                ps.setObject(2, (new java.util.Date()).toLocaleString());
                ps.addBatch();
                if (0 == i % 1000) {
                    System.out.println("==>>i:" + i);
                    ps.executeBatch();
                }
            }
            conn.commit();
            System.out.println("last==>>i:" + i);
           
        }catch(Exception e){
            System.out.println("Exception:"+e);
        }finally{
            try {
                if(ps!=null)ps.close();
                if(conn!=null)
                    conn.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    }