Tutorial by Examples: le

The FileSystem API of Java 7 allows to read and add entries from or to a Zip file using the Java NIO file API in the same way as operating on any other filesystem. The FileSystem is a resource that should be properly closed after use, therefore the try-with-resources block should be used. Reading ...

import java.util.stream.IntStream; public class Concurrent { public static void printAndWait(String s) { System.out.println(s); try { Thread.sleep(1000); } catch (Exception e) {} } public static void main(String[] args) { Threa...

The loop macro has two forms: the "simple" form and the "extended" form. The extended form is covered in another documentation topic, but the simple loop is useful for very basic loop. The simple loop form takes a number of forms and repeats them until the loop is exited using ...

Care must be taken when initializing variables of type float to literal values or comparing them with literal values, because regular floating point literals like 0.1 are of type double. This may lead to surprises: #include <stdio.h> int main() { float n; n = 0.1; if (n > ...

Description This is a self-contained running example including/showcasing: minimum dependencies needed, Java Configuration, Bean declaration by annotation and Java Configuration, Dependency Injection by Constructor and by Property, and Pre/Post hooks. Dependencies These dependencies are needed in...

What is a "Shape"? You typically save your shapes by creating a JavaScript "shape" object representing each shape. var myCircle = { x:30, y:20, radius:15 }; Of course, you're not really saving shapes. Instead, you're saving the definition of how to draw the shapes. Then put...

Here is an example of an IntentService that pretends to load images in the background. All you need to do to implement an IntentService is to provide a constructor that calls the super(String) constructor, and you need to implement the onHandleIntent(Intent) method. public class ImageLoaderIntentSe...

Given the 3 points of a quadratic curve the following function returns the length. function quadraticBezierLength(x1,y1,x2,y2,x3,y3) var a, e, c, d, u, a1, e1, c1, d1, u1, v1x, v1y; v1x = x2 * 2; v1y = y2 * 2; d = x1 - v1x + x3; d1 = y1 - v1y + y3; e = v1x - 2 * x1; ...

Open Script Editor. 2.12.4 With Mac OS X Leopard and earlier, and OS X Yosemite and later, Script Editor is located at /Applications/Utilities/Script Editor.app 2.12.4 Between Mac OS X Snow Leopard and OS X Mavericks inclusive, Script Editor is AppleScript Editor. /Applications/Utiliti...

This attribute is ignored. It was not ported over from VB6. In VB6, it was used in combination with the VB_Exposed attribute to control accessibility of classes outside of the current project. VB_Exposed=True VB_Creatable=True Would result in a Public Class, that could be accessed from other ...

let's generate a DataFrame first: df = pd.DataFrame(np.arange(10).reshape(5,2), columns=list('ab')) print(df) # Output: # a b # 0 0 1 # 1 2 3 # 2 4 5 # 3 6 7 # 4 8 9 drop rows with indexes: 0 and 4 using drop([...], inplace=True) method: df.drop([0,4], inplace=True) ...

INSERT INTO Invoices [ /* column names may go here */ ] VALUES (123, '1234abc', '2016-08-05 20:18:25.770', 321, 5, '2016-08-04'); Column names are required if the table you are inserting into contains a column with the IDENTITY attribute. INSERT INTO Invoices ([ID], [Num], [DateTime], [Tota...

CREATE TABLE [dbo].[Customers] ( CustomerID INT DEFAULT (NEXT VALUE FOR [dbo].[CustomersSeq]) NOT NULL, CustomerName VARCHAR(100), );

INSERT INTO [dbo].[Customers] ([CustomerName]) VALUES ('Jerry'), ('Gorge') SELECT * FROM [dbo].[Customers] Results CustomerIDCustomerName10001Jerry10002Gorge

DELETE FROM [dbo].[Customers] WHERE CustomerName = 'Gorge'; INSERT INTO [dbo].[Customers] ([CustomerName]) VALUES ('George') SELECT * FROM [dbo].[Customers] Results CustomerIDCustomerName10001Jerry10003George

SCOPE_IDENTITY() returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch. INSERT INTO ([col...

Will be available till the current connection persists for the user. Automatically deleted when the user disconnects. The name should start with # (#temp) CREATE TABLE #LocalTempTable( StudentID int, StudentName varchar(50), Student...

Will start with ## (##temp). Will be deleted only if user disconnects all connections. It behaves like a permanent table. CREATE TABLE ##NewGlobalTempTable( StudentID int, StudentName varchar(50), StudentAddress varchar(150)) Insert ...

Create a Job To add a job first we have to use a stored procedure named sp_add_job USE msdb ; GO EXEC dbo.sp_add_job @job_name = N'Weekly Job' ; -- the job name Then we have to add a job step using a stored procedure named sp_add_jobStep EXEC sp_add_jobstep @job_name = N'W...

Depending on the structure of your data, you can create variables that update dynamically. DECLARE @CurrentID int = (SELECT TOP 1 ID FROM Table ORDER BY CreateDate desc) DECLARE @Year int = 2014 DECLARE @CurrentID int = (SELECT ID FROM Table WHERE Year = @Year) In most cases, you will want...