- Drivers :
- PostgreSQL:
String dbURL = "jdbc:postgresql://localhost:5432/pgsdemo1";
String user = "postgres"; String pwd = "postgre_manas9";
- MySQL :
String dbURL = "jdbc:mysql://localhost/test?";
String user = "Manas9"; String pwd = "Manas9237";
- SQL :: Create and Drop Table :
- MYSQL ::Create
String sqlCreate = "create table mysqlVisitor1A(" + "idV1A
int(3) NOT NULL PRIMARY KEY,"
+ "fname varchar(30)," + "lname varchar(30),"
+ "age int(2)NOT NULL"
+") ENGINE=InnoDB DEFAULT CHARSET=utf8;";
- PostgreSQL ::Create
String sqlCreate = "create table pgsVisitor1A" + "(id NUMERIC(3)
CONSTRAINT PK_v1A PRIMARY KEY,"
+ "fname varchar(30)," + "lname varchar(30),"
+ "age numeric(2)) ";
- MySQL :: Drop Table
String sqldrop= "drop table if exists mysqlVisitor1A";
String sqlQuery ="Select * from mysqlVisitor1A";
- PostgreSQL Drop :: Query ALL columns
String sqldrop= "drop table if exists pgsVisitor1A;";
String sqlQuery ="Select * from pgsVisitor1A";
- INSERT Statement :: MYSQL and PostGreSQL
- String strInsert0 ="INSERT INTO mysqlVisitor1A values
(101,'John', 'Doe', 40)";
- String strInsert1="INSERT INTO mysqlVisitor1A
values(102,'Peter', 'Pan', 44)";
- String strInsert2 ="INSERT INTO mysqlVisitor1A
values(103,'Jean', 'Zenis', 29)";
- String strInsert3 ="INSERT INTO mysqlVisitor1A values(104,'Savita',
'Jha', 34)";
- String [] strInsert = new String[]{strInsert1, strInsert2,
strInsert3, strInsert0};
- ---------
-
|