Fajrina Blog Spot

File name : MyProjectAPI.java

package MyProjectAPI;

public class CreateTable

{

//table tbl_login

static final String _tbl_login = "create table tbl_login (username varchar(12), password varchar(6), access_level(1), status varchar(5), logTime varchar(20))";

/**

* return tbl_login

*/

static String tbl_login()

{

return _tbl_login;

}

//table tbl_staff

static final String _tbl_staff = "create table tbl_staff(_staffName varchar(30),_staffIc varchar (12),_staffPhone varchar (10),_staffId varchar(15), _staffPassword varchar(6),_accessLevel varchar(5),_status(5))";

/*

* return tbl_staff

*/

static String tbl_staff()

{

return _tbl_staff;

}

//tbl_pakej

static final String _tbl_pakej = "create table tbl_pakej(_pakejId varchar (10),_jenisPakej varchar(1), _namaPakej varchar(30),_tempoh varchar(20)," +

"_tarikhBertolak varchar (30),_tarikhTiba varchar (30),_harga varchar(10), _gambarHotel varchar(60),_jenisBilik varchar(15),_status varchar(15)," +

"_jenisPenerbangan varchar (25))";

/*

* return tbl_pakej

*/

static String tbl_pakej()

{

return _tbl_pakej;

}

//tbl_user

static final String _tbl_user = "create table tbl_user(_namaPertama varchar(30),_namaKedua varchar(30),_ic varchar(12)," +

",_umur varchar(3),_jantina varchar(1),_email varchar(30),_handphone varchar(10),_gambarPassport varchar(50),"+

"_telRumah varchar(9),_warganegara varchar(1),_alamat varchar(50),_accessLevel(5),_status(5),_noPassport varchar (20)," +

"_jenisPassport varchar(20),_tarikhMula varchar (15),tarikhTamat varchar(15), _pilihanPenerbangan varchar (20)," +

"_noAkaun varchar int (20),_jenisBank varchar(30),_jumlahBayaran varchar (10),_jenisPenyakit varchar(40), _ubat varchar(35),_orangKecemasan1 varchar(100)," +

"_orangKecemasan2 varchar(100),_orangKecemasan3 varchar(100))";

static String tbl_user()

{

return _tbl_user;

}

static final String _tbl_registration = "create table tbl_registration(_idRegister int (10),_tarikh varchar(20),"+

"_statusBayaran varchar(15),_keluargaTerlibat1 varchar(100),_keluargaTerlibat2 varchar(100),_keluargaTerlibat3 varchar(100)," +

"_keluargaTerlibat4 varchar(100),_keluargaTerlibat5 varchar(100))";

static String _tbl_report = "create table tbl_report(_idReport int(6),_status varchar(30),_tarikh date," +

"_idPakej varchar(30),_jenisKeterangan varchar(100))";

}