MDAC from Microsoft

Microsoft Data Access Components

Free!!


String sql = "INSERT INTO Addresses(AddressID, FullName, ZipCode)"
	+ " VALUES(1, 'Joe Sweeney', '12345');";



SELECT AddressID, FullName, ZipCode
FROM Addresses;



sql = "UPDATE Addresses SET"
	+ " ZipCode = '85716', "
	+ " State = 'AZ';";
	
	
	
sqlb = new StringBuffer(100);

sqlb.append("UPDATE Addresses SET");
sqlb.append(" ZipCode = '85716', ");
sqlb.append(" State = 'AZ';");


DELETE * FROM Addresses;
DELETE FROM Addresses;


SELECT AddressID, FullName, ZipCode
FROM Addresses
WHERE FullName In ('Joe Sweeney','Diane Sokal');


WHERE Not AddressID = 1;



Joining Two Tables

SELECT AddressID, FullName, ZipCode, City, State
FROM Addresses, ZipCodes
WHERE Addresses.ZipCode = ZipCodes.ZipCode
ORDER BY State DESC, FullName



Object Manipulation



CREATE TABLE Addresses(AddressID INT CONSTRAINT PrimaryKey PRIMARY KEY, FullName TEXT(50) CONSTRAINT FullName NOT NULL);


ALTER TABLE Addresses(ADD ZipCode TEXT(5));





CREATE TABLE Addresses(AddressID INT, FullName TEXT(50));