30 items | 4 visits
Java Server Pages codes,tips etc
Updated on Dec 27, 11
Created on Dec 02, 09
Category: Computers & Internet
URL:
ManojKumar 's List: j2ee
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Dec 02, 09
-
INSERT command
// SQL INSERT command String SQL = "INSERT INTO Customers (Company,[First Name]," + "[Last Name]) VALUES ('MyCompany','Linglom','My Last Name')"; int rowsEffected = stmt.executeUpdate(SQL); System.out.println(rowsEffected + " rows effected");
UPDATE command
// SQL UPDATE command String SQL = "UPDATE Customers SET [Last Name] = 'New Last Name'" + "WHERE [First Name] = 'Linglom'"; int rowsEffected = stmt.executeUpdate(SQL); System.out.println(rowsEffected + " rows effected");
DELETE command
// SQL DELETE command String SQL = "DELETE FROM Customers WHERE [First Name] = 'Linglom'"); int rowsEffected = stmt.executeUpdate(SQL); System.out.println(rowsEffected + " rows effected");
-
-
-
-
-
List Comments
(0)
List Info