Registration Form Source Code
import [Link].*;
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
public class RegForm extends [Link] {
public RegForm() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new [Link]();
jLabel1 = new [Link]();
jLabel2 = new [Link]();
jLabel3 = new [Link]();
jLabel4 = new [Link]();
Mname = new [Link]();
Lname = new [Link]();
Fname = new [Link]();
MidName = new [Link]();
jLabel6 = new [Link]();
jLabel7 = new [Link]();
jLabel8 = new [Link]();
jLabel9 = new [Link]();
Snumber = new [Link]();
Eaddress = new [Link]();
Cnumber = new [Link]();
jLabel10 = new [Link]();
jLabel11 = new [Link]();
jLabel12 = new [Link]();
Fathersname = new [Link]();
Mothersname = new [Link]();
CbSex = new [Link]<>();
jLabel13 = new [Link]();
jLabel14 = new [Link]();
jLabel15 = new [Link]();
CBCourse = new [Link]<>();
CBYearLevel = new [Link]<>();
CBSection = new [Link]<>();
jLabel16 = new [Link]();
jScrollPane1 = new [Link]();
Paddress = new [Link]();
BtnDb = new [Link]();
BtnCancel = new [Link]();
BtnReg = new [Link]();
DcBday = new [Link]();
DcAdate = new [Link]();
setDefaultCloseOperation([Link].EXIT_ON_CLOSE);
setTitle("ECST - REGISTRATION SYSTEM");
[Link](new [Link](0, 255, 0));
[Link](new [Link]("Segoe UI Black", 1, 18)); // NOI18N
[Link](new [Link](255, 255, 255));
[Link]("ECST - STUDENT REGISTRATION FORM");
[Link] jPanel1Layout = new [Link](jPanel1);
[Link](jPanel1Layout);
[Link](
[Link]([Link])
.addGroup([Link]()
.addGap(156, 156, 156)
.addComponent(jLabel1)
.addContainerGap([Link].DEFAULT_SIZE, Short.MAX_VALUE))
);
[Link](
[Link]([Link])
.addGroup([Link],
[Link]()
.addContainerGap([Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel1)
.addContainerGap())
);
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("FIRST NAME");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("DATE OF BIRTH");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("LAST NAME");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("MIDDLE NAME");
[Link](new [Link]() {
public void keyTyped([Link] evt) {
LnameKeyTyped(evt);
}
});
[Link](new [Link]() {
public void keyTyped([Link] evt) {
FnameKeyTyped(evt);
}
});
[Link](new [Link]() {
public void keyTyped([Link] evt) {
MidNameKeyTyped(evt);
}
});
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Student No.");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Email Address");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Admission Date");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Contact Number");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
SnumberActionPerformed(evt);
}
});
[Link](new [Link]() {
public void keyTyped([Link] evt) {
SnumberKeyTyped(evt);
}
});
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
EaddressActionPerformed(evt);
}
});
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
CnumberActionPerformed(evt);
}
});
[Link](new [Link]() {
public void keyTyped([Link] evt) {
CnumberKeyTyped(evt);
}
});
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Mother's Maiden Name");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Father's Name");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Sex");
[Link](new [Link]<>(new String[] { "MALE",
"FEMALE" }));
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Diploma Course");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Year Level");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("Section");
[Link](new [Link]<>(new String[]
{ "INFORMATION TECHNOLOGY", "COMPUTER ENGINEERING TECHNOLOGY", "HOTEL &
RESTAURANT TECHNOLOGY", "TOURISM & TRAVEL MANAGEMENT TECHNOLOGY" }));
[Link](new [Link]<>(new String[] { "1ST
YEAR", "2ND YEAR", "3RD YEAR", "4TH YEAR" }));
[Link](new [Link]<>(new String[] { "IT -101",
"IT -102", "IT - 201", "IT - 202", "IT - 301", "IT - 302", "CET -101", "CET -102", "CET - 201", "CET -
202", "CET - 301", "CET - 302", "HRT -101", "HRT -102", "HRT -201", "HRT -202", "HRT -301",
"HRT -302", "TTMT -101", "TTMT -102", "TTMT - 201", "TTMT - 202", "TTMT - 301", "TTMT -
302", " ", " ", " " }));
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("PERMANENT ADDRESS");
[Link](20);
[Link](5);
[Link](Paddress);
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("DATABASE");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
BtnDbActionPerformed(evt);
}
});
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("CANCEL");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
BtnCancelActionPerformed(evt);
}
});
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("REGISTER");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
BtnRegActionPerformed(evt);
}
});
[Link] layout = new [Link](getContentPane());
getContentPane().setLayout(layout);
[Link](
[Link]([Link])
.addComponent(jPanel1, [Link],
[Link].DEFAULT_SIZE, [Link].DEFAULT_SIZE,
Short.MAX_VALUE)
.addGroup([Link]()
.addGap(44, 44, 44)
.addGroup([Link]([Link])
.addGroup([Link]()
.addComponent(jScrollPane1)
.addContainerGap())
.addGroup([Link]()
.addComponent(BtnReg)
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(BtnDb)
.addGap(179, 179, 179)
.addComponent(BtnCancel)
.addGap(76, 76, 76))
.addGroup([Link]()
.addGroup([Link]([Link]
NG)
.addGroup([Link]()
.addGroup([Link]([Link]
ADING)
.addComponent(jLabel13)
.addComponent(jLabel16)
.addComponent(CBCourse, [Link].PREFERRED_SIZE, 178,
[Link].PREFERRED_SIZE))
.addGap(0, 98, Short.MAX_VALUE))
.addGroup([Link],
[Link]()
.addGroup([Link]([Link]
ADING)
.addGroup([Link]([Link].
TRAILING, false)
.addComponent(Cnumber, [Link],
[Link].DEFAULT_SIZE, 100, Short.MAX_VALUE)
.addComponent(Lname, [Link]))
.addComponent(jLabel9)
.addComponent(jLabel4))
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup([Link]([Link]
ADING)
.addComponent(jLabel6, [Link].PREFERRED_SIZE, 68,
[Link].PREFERRED_SIZE)
.addComponent(Fname, [Link].PREFERRED_SIZE, 100,
[Link].PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(Snumber, [Link].PREFERRED_SIZE, 100,
[Link].PREFERRED_SIZE)))
.addGroup([Link]()
.addGroup([Link]([Link]
ADING)
.addComponent(jLabel11)
.addComponent(Fathersname, [Link].PREFERRED_SIZE,
178, [Link].PREFERRED_SIZE))
.addPreferredGap([Link],
[Link].DEFAULT_SIZE, Short.MAX_VALUE)))
.addGroup([Link]([Link]
NG)
.addComponent(jLabel10)
.addComponent(jLabel14)
.addComponent(Mothersname, [Link].PREFERRED_SIZE,
189, [Link].PREFERRED_SIZE)
.addComponent(CBYearLevel, [Link].PREFERRED_SIZE, 115,
[Link].PREFERRED_SIZE)
.addGroup([Link]()
.addGap(75, 75, 75)
.addGroup([Link]([Link]
ADING)
.addComponent(Mname)
.addComponent(MidName, [Link].PREFERRED_SIZE,
100, [Link].PREFERRED_SIZE)
.addComponent(jLabel7)
.addComponent(Eaddress, [Link].PREFERRED_SIZE, 100,
[Link].PREFERRED_SIZE))))
.addGap(71, 71, 71)
.addGroup([Link]([Link]
NG)
.addGroup([Link]([Link]
ILING)
.addComponent(jLabel3)
.addGroup([Link]([Link]
ADING)
.addComponent(DcAdate, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(jLabel8)
.addComponent(jLabel12, [Link].PREFERRED_SIZE, 52,
[Link].PREFERRED_SIZE)
.addComponent(CbSex, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)))
.addComponent(jLabel15)
.addComponent(CBSection, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addGroup([Link]()
.addGap(1, 1, 1)
.addComponent(DcBday, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)))
.addGap(57, 57, 57))))
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addComponent(jPanel1, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel3, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addComponent(jLabel4, [Link],
[Link].PREFERRED_SIZE, 27, [Link].PREFERRED_SIZE)
.addGroup([Link]([Link]
E)
.addComponent(jLabel2, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addComponent(Mname, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addGroup([Link]([Link]
E)
.addComponent(Lname, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(Fname, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(MidName, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addComponent(DcBday, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(jLabel7, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addComponent(jLabel8, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addGroup([Link]([Link]
E)
.addComponent(jLabel9, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addComponent(jLabel6, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addGroup([Link]()
.addComponent(Eaddress, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addGroup([Link]([Link]
NG)
.addGroup([Link]()
.addComponent(jLabel10, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addComponent(Mothersname, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addGroup([Link]()
.addComponent(jLabel12, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addComponent(CbSex, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))))
.addComponent(DcAdate, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addGroup([Link],
[Link]()
.addGroup([Link]([Link]
NE)
.addComponent(Cnumber, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(Snumber, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addComponent(jLabel11, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addComponent(Fathersname, [Link].PREFERRED_SIZE, 22,
[Link].PREFERRED_SIZE)))
.addGap(26, 26, 26)
.addGroup([Link]([Link],
false)
.addComponent(jLabel13, [Link].DEFAULT_SIZE, 27,
Short.MAX_VALUE)
.addComponent(jLabel14, [Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jLabel15, [Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE))
.addPreferredGap([Link])
.addGroup([Link]([Link])
.addComponent(CBCourse, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(CBYearLevel, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addComponent(CBSection, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE))
.addPreferredGap([Link])
.addComponent(jLabel16, [Link].PREFERRED_SIZE, 27,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addComponent(jScrollPane1, [Link].PREFERRED_SIZE, 58,
[Link].PREFERRED_SIZE)
.addGap(18, 18, 18)
.addGroup([Link]([Link])
.addGroup([Link]([Link]
)
.addComponent(BtnCancel, [Link],
[Link].PREFERRED_SIZE, 33, [Link].PREFERRED_SIZE)
.addComponent(BtnReg, [Link].PREFERRED_SIZE, 31,
[Link].PREFERRED_SIZE))
.addComponent(BtnDb, [Link].PREFERRED_SIZE, 33,
[Link].PREFERRED_SIZE))
.addGap(0, 0, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void EaddressActionPerformed([Link] evt) {
private void SnumberActionPerformed([Link] evt) {
private void BtnDbActionPerformed([Link] evt) {
DATABASE df = new DATABASE ();
[Link](true);
}
private void BtnRegActionPerformed([Link] evt) {
int get = [Link](this, "SAVE IN THE DATABASE?","SELECT AN
OPTION", JOptionPane.YES_NO_CANCEL_OPTION, JOptionPane.QUESTION_MESSAGE);
if (get == JOptionPane.YES_OPTION){
[Link](this, "REGISTRATION SAVED!");
}
try{
[Link]("[Link]");
Connection conn =
[Link]("jdbc:mysql://localhost:3306/studdb","root","Qwerty12");
String sql = "insert into studdbtable values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement pstmt = [Link](sql);
[Link](1,([Link]()));
[Link](2, [Link]());
[Link](3, [Link]());
SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd");
String Birthday = [Link]([Link]());
[Link] (4, Birthday);
[Link](5, [Link]([Link]()));
[Link](6, [Link]([Link]()));
[Link](7, [Link]());
String AdmiDate = [Link]([Link]());
[Link] (8, AdmiDate);
[Link](9, [Link]());
[Link](10, [Link]());
String sex;
sex = [Link]().toString();
[Link](11, sex);
String course;
course = [Link]().toString();
[Link](12, course);
String yearlevel;
yearlevel = [Link]().toString();
[Link](13, yearlevel);
String sec;
sec = [Link]().toString();
[Link](14, sec);
[Link](15, [Link]());
[Link]();
[Link](null, "insertion successfull");
[Link]();
}catch(Exception e){
[Link](null, e);
}
private void BtnCancelActionPerformed([Link] evt) {
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link](0);
[Link](0);
private void CnumberKeyTyped([Link] evt) {
char j = [Link]();
if([Link](j)){
[Link]();
}
}
private void SnumberKeyTyped([Link] evt) {
char j = [Link]();
if([Link](j)){
[Link]();
}
}
private void CnumberActionPerformed([Link] evt) {
private void LnameKeyTyped([Link] evt) {
char j = [Link]();
if([Link](j)){
[Link]();
}
}
private void FnameKeyTyped([Link] evt) {
char j = [Link]();
if([Link](j)){
[Link]();
}
}
private void MidNameKeyTyped([Link] evt) {
char j = [Link]();
if([Link](j)){
[Link]();
}
}
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new RegForm().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] BtnCancel;
private [Link] BtnDb;
private [Link] BtnReg;
private [Link]<String> CBCourse;
private [Link]<String> CBSection;
private [Link]<String> CBYearLevel;
private [Link]<String> CbSex;
private [Link] Cnumber;
private [Link] DcAdate;
private [Link] DcBday;
private [Link] Eaddress;
private [Link] Fathersname;
private [Link] Fname;
private [Link] Lname;
private [Link] MidName;
private [Link] Mname;
private [Link] Mothersname;
private [Link] Paddress;
private [Link] Snumber;
private [Link] jLabel1;
private [Link] jLabel10;
private [Link] jLabel11;
private [Link] jLabel12;
private [Link] jLabel13;
private [Link] jLabel14;
private [Link] jLabel15;
private [Link] jLabel16;
private [Link] jLabel2;
private [Link] jLabel3;
private [Link] jLabel4;
private [Link] jLabel6;
private [Link] jLabel7;
private [Link] jLabel8;
private [Link] jLabel9;
private [Link] jPanel1;
private [Link] jScrollPane1;
// End of variables declaration
}
Database Source Code
import [Link].*;
import [Link];
import [Link];
import [Link];
import [Link];
public class DATABASE extends [Link] {
Connection con;
Statement st;
PreparedStatement pst;
ResultSet rs;
public DATABASE() {
initComponents();
showData();
}
public void showData(){
try {
con =
[Link]("jdbc:mysql://localhost:3306/studdb","root","Qwerty12");
String q;
q = "select * from studdbtable";
pst = [Link](q);
rs = [Link]();
[Link]([Link](rs));
} catch (Exception ex) {
[Link](this, ex);
}
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel2 = new [Link]();
jLabel1 = new [Link]();
BtnBack = new [Link]();
jScrollPane1 = new [Link]();
StudTable = new [Link]();
setDefaultCloseOperation([Link].EXIT_ON_CLOSE);
setTitle("DATABASE");
[Link](new [Link](0, 255, 0));
[Link](new [Link]("Segoe UI", 1, 24)); // NOI18N
[Link](new [Link](255, 255, 255));
[Link]("ECST - STUDENT REGISTRATION SYSTEM");
[Link](new [Link]("Segoe UI", 1, 12)); // NOI18N
[Link]("BACK");
[Link](new [Link]() {
public void actionPerformed([Link] evt) {
BtnBackActionPerformed(evt);
}
});
[Link] jPanel2Layout = new [Link](jPanel2);
[Link](jPanel2Layout);
[Link](
[Link]([Link])
.addGroup([Link],
[Link]()
.addContainerGap()
.addComponent(BtnBack, [Link].PREFERRED_SIZE, 62,
[Link].PREFERRED_SIZE)
.addPreferredGap([Link], 341,
Short.MAX_VALUE)
.addComponent(jLabel1)
.addGap(248, 248, 248))
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addContainerGap()
.addGroup([Link]([Link]
ADING)
.addComponent(jLabel1, [Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(BtnBack))
.addContainerGap())
);
[Link](new [Link](
new Object [][] {
},
new String [] {
"Last Name", "Fist Name", "Middle Name", "Birthday", "Contact Number", "Student
No.", "Email Address", "Admission Date", "Father's Name", "Mother's Name", "Sex", "Diploma
Course", "Year ", "Section", "Address"
}
));
[Link](StudTable);
[Link] layout = new [Link](getContentPane());
getContentPane().setLayout(layout);
[Link](
[Link]([Link])
.addComponent(jPanel2, [Link].DEFAULT_SIZE,
[Link].DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jScrollPane1)
);
[Link](
[Link]([Link])
.addGroup([Link]()
.addComponent(jPanel2, [Link].PREFERRED_SIZE,
[Link].DEFAULT_SIZE, [Link].PREFERRED_SIZE)
.addPreferredGap([Link])
.addComponent(jScrollPane1, [Link].DEFAULT_SIZE, 572,
Short.MAX_VALUE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void BtnBackActionPerformed([Link] evt) {
[Link](false);
public static void main(String args[]) {
[Link](new Runnable() {
public void run() {
new DATABASE().setVisible(true);
}
});
}
// Variables declaration - do not modify
private [Link] BtnBack;
private [Link] StudTable;
private [Link] jLabel1;
private [Link] jPanel2;
private [Link] jScrollPane1;
// End of variables declaration
}