Republic of the Philippines

Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

BASIC E-FORMS IN GRADE 12 STUDENTS IN PANGHULO

NATIONAL HIGH SCHOOL

In Partial Fulfillment
of the Requirements for
Programming (JAVA) (NCIII)

Submitted By:

Grade 12 – Charles Babbage

HARVEY M. ALONDAY

ALPHA JOY NOVILLAS

Submitted to:

Ms. Loida B. Sacueza

Date Submitted:

March 10,2020

1
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Table of Contents

The Project Proposal ............................................................................ 3

Flowchart ............................................................................................. 6

User’s Manual ...................................................................................... 9

Source Code .......................................................................................... 16

Curriculum Vitae .................................................................................... 51

2
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

THE
PROJECT
PROPOSAL

3
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

PROJECT PROPOSAL
I. Proponents : Harvey M. Alonday
Alpha Joy Novillas
II. Proposed Title : School File Sorter for Forms and Documents (E-Folder)
III. Area of Investigation : Program development
IV. Reason for the Study : The purpose of the study is to help the user to look for
all the information in short period of time for each individual with different kinds of forms
and documents. The researcher also aims to sort data’s of student documents with various
type.
V. Importance of the Study : The importance of the study is to help the Teachers or
other faculty members to sort and retrieve documents in a short period of time
VI. Methods : This research will utilize a quantitative research which
will be done using survey. The researcher will seek assistance, suggestions, and ideas from
the professionals and experts. After conducting a survey and gather information the
researcher will create a system about School File Sorter (E - Folder)
VII.GanttChart :
November December January February
1s 2n 3r 4t 1s 2n 3r 4th 1s 2n 3r 4th 1s 2nd 3r 4t
t d d h t d d t d d t d h
Proposed
Title
Title
defense
Revision
of rejected
title
Starting
papers

Making
the system

Making
papers

4
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Checking
the system
Defense

Revisions

VIII.Date Submitted : Nov 11 2019

IX.School Term : S.Y. 2019 - 2020
X.Recommending Approval :
XI.Approved By :

5
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

FLOWCHART

6
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

7
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

USER’S
MANUAL

8
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
The
students
use these tools to create the system for basic E-Folder for
grade 12 Students in Panghulo National High School.

NetBeans is an open-
source integrated development
environment (IDE) for developing
with Java, PHP, C++, and other
programming languages.
NetBeans is also referred to as a
platform of modular components
used for developing Java desktop applications.

'Java can be used to create

complete applications that may
run on a single computer or be
distributed among servers and
clients in a network. It can also
be used to build a small
application module or applet (a simply designed, small
application) for use as part of a Web page.

DB Browser for SQLite (DB4S)

is a high quality, visual, open source
tool to create, design, and
edit database files compatible
with SQLite. ... Create and
compact database files.

9
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Login – this where you login your account

to access the system.

Register – if you don’t have an account,

you need to register first.

10
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Mainform - this is the welcome page. As you can see, this page has the log-out
button, and you need to click the student data button, to access the forms.

11
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Data – this is the mainform, where you should complete the form. This is where the
information of the students should be put.

Section Type - This is the

strand where you should
choose of the section you will
print.

12
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Section- This is the sample of one of the section in the field. This is where you can generate
or print the data.

13
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Genarate/printable – this is the sample of the printing data.

14
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

SOURCE
CODE

15
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

FOR MAINCLASS

package system64;
import java.sql.*;
import javax.swing.JOptionPane;
public class System64 {

Connection con=null;
public static Connection connect()
{
try{
Class.forName("org.sqlite.JDBC");
Connection con =DriverManager.getConnection("jdbc:sqlite:System64.sqlite");

return con;
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null,"failed");
return null;

}
}
public static String type;
public static String user;
public static String picture;
}

FOR REGISTER
FOR IMPORTS

package system64;
import java.awt.Image;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.swing.ImageIcon;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;

16
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
public
class register extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
public register() {
initComponents();
con=System64.connect();
}

public void loadtable()

{
try
{
String sql = "select * from System6464";
pst=con.prepareStatement(sql);
rs=pst.executeQuery();
}
catch(Exception e)
{
}
}
private void jLabel8MouseClicked(java.awt.event.MouseEvent evt) {
Login bot=new Login();
bot.setVisible(true);
this.dispose();
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
if(user.getText().trim().isEmpty()&&pass1.getText().trim().isEmpty()){
JOptionPane.showMessageDialog(null,"Please Input Data");
return;
}
else if (user.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null,"Please Input user");
return;
}
else if (pass1.getText().trim().isEmpty())
{

JOptionPane.showMessageDialog(null,"Please Input password");

return;
}

try{

17
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
String
sql="insert
into System6464(USERNAME, PASSWORD,SSID, TYPE, PICTURE)values(?,?,?,?,?)";
pst=con.prepareStatement(sql);
pst.setString(1, user.getText());
pst.setString(2, pass1.getText());
pst.setString(3, id.getText());
pst.setString(4, type.getSelectedItem().toString());
pst.setBytes(5,photo);
pst.execute();
JOptionPane.showMessageDialog(null, "YOU ARE REGISTER YOUR CODE IS
143");
Login bot=new Login();
bot.setVisible(true);
this.dispose();
}

catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}

Public static void main(String args[]) {

try {
for (javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(register.class.getName()).log(java.util.logging.Level.SEV
ERE, null, ex);
} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(register.class.getName()).log(java.util.logging.Level.SEV
ERE, null, ex);
} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(register.class.getName()).log(java.util.logging.Level.SEV
ERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(register.class.getName()).log(java.util.logging.Level.SEV
ERE, null, ex);

18
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
}

java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new register().setVisible(true);
}
});
}
byte[] photo=null;
String filename=null;
}

FOR LOGIN

public class Login extends javax.swing.JFrame {

Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;

public Login() {
initComponents();
con=System64.connect();
FillUserType();
public void FillUserType()
{
try
{
String sql = "select * from System6464";
pst= con.prepareStatement(sql);
rs = pst.executeQuery();
rs.close();
pst.close();
}

catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);

}
}

19
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

FOR LOGIN BUTTON

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {

if(username.getText().trim().isEmpty()&& pass.getText().trim().isEmpty()){
JOptionPane.showMessageDialog(null, "please input data");
return;
}
if(username.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no username");
return;
}
if(pass.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no pass");
return;
}
if(id.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no id");
return;
}
try{
String sql="Select * from System6464 where USERNAME=? and PASSWORD=?
and SSID=? ";
pst=con.prepareStatement(sql);
pst.setString(1, username.getText());
pst.setString(2, pass.getText());
pst.setString(3, id.getText());
rs=pst.executeQuery();

if(rs.next())
{
String user = rs.getString("USERNAME");
System64.user=user;
String type = rs.getString("TYPE");
System64.type =type;

setVisible(false);
dummy bot=new dummy();
bot.setVisible(true);
this.dispose();
}
else if(id.equals("")){
JOptionPane.showMessageDialog(null,"no id");
}
else
{

20
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

JOptionPane.showMessageDialog(null,"Username/Password/ID Are Invalid");

}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}

BUTTON FOR REGISTER

private void jLabel6MouseClicked(java.awt.event.MouseEvent evt) {

register bot=new register();
bot.setVisible(true);
this.dispose();
// TODO add your handling code here:
}
PASS KEY
private void passKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode()==KeyEvent.VK_ENTER){

if(username.getText().trim().isEmpty()&& pass.getText().trim().isEmpty()){
JOptionPane.showMessageDialog(null, "please input data");
return;
}
if(username.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no username");
return;
}
if(pass.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no pass");
return;

}
if(id.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no id");
return;
}
try{
String sql="Select * from System6464 where USERNAME=? and PASSWORD=?
and SSID=? ";
pst=con.prepareStatement(sql);
pst.setString(1, username.getText());

21
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

pst.setString(2, pass.getText());
pst.setString(3, id.getText());
rs=pst.executeQuery();
if(rs.next())
{
String user = rs.getString("USERNAME");
System64.user=user;
String type = rs.getString("TYPE");
System64.type =type;
setVisible(false);
dummy bot=new dummy();
bot.setVisible(true);
this.dispose();
}
else if(id.equals("")){
JOptionPane.showMessageDialog(null,"no id");
}
else
{
JOptionPane.showMessageDialog(null,"Username/Password/ID Are Invalid");
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}
}

ID KEY PRESSED

idKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode()==KeyEvent.VK_ENTER){

if(username.getText().trim().isEmpty()&& pass.getText().trim().isEmpty()){
JOptionPane.showMessageDialog(null, "please input data");
return;
}
if(username.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no username");
return;
}
if(pass.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no pass");
return;

22
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
}

if(id.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no id");
return;
}
try{
String sql="Select * from System6464 where USERNAME=? and PASSWORD=?
and SSID=? ";
pst=con.prepareStatement(sql);
pst.setString(1, username.getText());
pst.setString(2, pass.getText());
pst.setString(3, id.getText());
rs=pst.executeQuery();
if(rs.next())
{
String user = rs.getString("USERNAME");
System64.user=user;
String type = rs.getString("TYPE");
System64.type =type;
setVisible(false);
dummy bot=new dummy();
bot.setVisible(true);
this.dispose();
}
else if(id.equals("")){
JOptionPane.showMessageDialog(null,"no id");
}
else
{
JOptionPane.showMessageDialog(null,"Username/Password/ID Are Invalid");
}

}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}
}
USERNAME
rivate void usernameKeyPressed(java.awt.event.KeyEvent evt) {
if (evt.getKeyCode()==KeyEvent.VK_ENTER){

if(username.getText().trim().isEmpty()&& pass.getText().trim().isEmpty()){
JOptionPane.showMessageDialog(null, "please input data");
return;
}

23
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

if(username.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no username");
return;
}
if(pass.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no pass");
return;
}
if(id.getText().trim().isEmpty())
{
JOptionPane.showMessageDialog(null, "no id");
return;
}
try{
String sql="Select * from System6464 where USERNAME=? and PASSWORD=?
and SSID=? ";
pst=con.prepareStatement(sql);
pst.setString(1, username.getText());
pst.setString(2, pass.getText());
pst.setString(3, id.getText());
rs=pst.executeQuery();
if(rs.next())
{
String user = rs.getString("USERNAME");
System64.user=user;
String type = rs.getString("TYPE");
System64.type =type;
setVisible(false);
dummy bot=new dummy();

bot.setVisible(true);
this.dispose();
}
else if(id.equals("")){
JOptionPane.showMessageDialog(null,"no id");
}
else
{
JOptionPane.showMessageDialog(null,"Username/Password/ID Are Invalid");
}
}
catch (Exception e)
{
JOptionPane.showMessageDialog(null, e);
}

24
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
}
}
DUMMYFORM

public class dummy extends javax.swing.JFrame {

Connection con =null;
PreparedStatement pst=null;
ResultSet rs=null;
/**
* Creates new form dummy
*/
public dummy() {
initComponents();
con =System64.connect();
type.setText(String.valueOf(System64.type).toString());
user.setText(String.valueOf(System64.user).toString());
picture.setText(String.valueOf(System64.picture).toString());
loadtable();

}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
Login bot=new Login();
bot.setVisible(true);
this.dispose();
}

private void jLabel4MouseClicked(java.awt.event.MouseEvent evt) {

mainform bot=new mainform();

bot.setVisible(true);
this.dispose();
MAINFORM INPUT
import com.itextpdf.text.Document;
import com.itextpdf.text.FontFactory;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.pdf.PdfWriter;
import com.toedter.calendar.JDateChooser;
import java.awt.Font;
import java.awt.event.KeyEvent;
import java.io.File;
import java.io.FileOutputStream;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;

25
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
import

javax.swing.RowFilter;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableRowSorter;
import javax.swing.text.AttributeSet;
import javax.swing.text.BadLocationException;
import javax.swing.text.PlainDocument;
import net.proteanit.sql.DbUtils;
public class mainform extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
/**
* Creates new form mainform
*/
public mainform() {
initComponents();
con=System64.connect();
loadtable();
}
public class mainform extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
public mainform() {

initComponents();
con=System64.connect();
loadtable();
public void loadtable(){
try{
String sql= "select * from DATA64";
pst=con.prepareStatement(sql);
rs=pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));

}
catch(Exception e) {

}
}
public void clear()
{
LRN.setText("");
name.setText("");
birthdate.setDate(null);
bar.setText("");

26
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

city.setText("");
province.setText("");
father.setText("");
mother.setText("");
guardian.setText("");
contact.setText("");
schoolid.setText("");
division.setText("");
region.setText("");
}
private void searchKeyPressed(java.awt.event.KeyEvent evt) {
DefaultTableModel abanana=(DefaultTableModel)tbl.getModel();
String search_data = search.getText().toUpperCase();
TableRowSorter<DefaultTableModel> tr = new
TableRowSorter<DefaultTableModel>(abanana);
tbl.setRowSorter(tr);
tr.setRowFilter(RowFilter.regexFilter(search_data));
}
private void searchKeyReleased(java.awt.event.KeyEvent evt) {

int bananaa =search.getCaretPosition();

search.setText(search.getText().toUpperCase());
search.setCaretPosition(bananaa);

}
private void ADDActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql="insert into
DATA64(LRN,NAME,SEX,BIRTHDATE,RELIGION,BARANGAY,CITY,PROVINCE,F
ATHERSNAME,MOTHERSNAME,GUARDIAN,CONTACT,SCHOOLID,DIVISION,RE
GION,STRAND)values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
pst = con.prepareStatement(sql);
pst.setString(1, LRN.getText());
pst.setString(2, name.getText());
pst.setString(3, gender.getSelectedItem().toString());
SimpleDateFormat df= new SimpleDateFormat("MM-dd-yyyy");
String date = df.format(birthdate.getDate());
pst.setString(4, date);
pst.setString(5, strand.getSelectedItem().toString());
pst.setString(6, bar.getText());
pst.setString(7, city.getText());
pst.setString(8, province.getText());
pst.setString(9, father.getText());
pst.setString(10, mother.getText());
pst.setString(11, guardian.getText());
pst.setString(12, contact.getText());
pst.setString(13, schoolid.getText());

27
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

pst.setString(14, division.getText());
pst.setString(15, region.getText());
pst.setString(16, st.getSelectedItem().toString());
pst.execute();
clear();
rs.close();
pst.close();
loadtable();
}
catch(Exception e)
{
JOptionPane.showMessageDialog(null, "Please Fill The Information");
}
}
private void UPDATEActionPerformed(java.awt.event.ActionEvent evt) {
try{
String val1=LRN.getText();
String val2=name.getText();
String val3=gender.getSelectedItem().toString();
SimpleDateFormat df= new SimpleDateFormat("MM-dd-yyyy");
String val4 = df.format(birthdate.getDate());
String val5=strand.getSelectedItem().toString();

String val6=bar.getText();
String val7=city.getText();
String val8=province.getText();
String val9=father.getText();
String val10=mother.getText();
String val11=guardian.getText();
String val12=contact.getText();
String val13=schoolid.getText();
String val14=division.getText();
String val15=region.getText();
String val16=st.getSelectedItem().toString();
String sql="update DATA64 set
NAME='"+val2+"',SEX='"+val3+"',BIRTHDATE='"+val4+"',RELIGION='"+val5+"',BARA
NGAY='"+val6+"',CITY='"+val7+"',PROVINCE='"+val8+"',FATHERSNAME='"+val9+"',
MOTHERSNAME='"+val10+"',GUARDIAN='"+val11+"',CONTACT='"+val12+"'
,SCHOOLID='"+val13+"',DIVISION='"+val14+"',REGION='"+val15+"',STRAND='"+val16
+"'where LRN='"+val1+"'";
pst= con.prepareStatement(sql);
pst.execute();
JOptionPane.showMessageDialog(null, "data updated");
loadtable();
rs.close();
pst.close();
clear();

28
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
}

catch(Exception e)
{
JOptionPane.showMessageDialog(null, e);
}
}
private void EDITActionPerformed(java.awt.event.ActionEvent evt) {
clear();
}
private void REMOVEActionPerformed(java.awt.event.ActionEvent evt) {
try{

int i=JOptionPane.showConfirmDialog(null, "Are you Sure You want to delete

this?","Delete",JOptionPane.YES_NO_OPTION);
if (i==0){
String sql="delete from DATA64 where LRN=?";
pst=con.prepareStatement(sql);
pst.setString(1,LRN.getText());
pst.execute();
loadtable();

clear();
}
else{
}
rs.close();
pst.close();
}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
} }
private void LRNKeyTyped(java.awt.event.KeyEvent evt) {
char a=evt.getKeyChar();
if(!(Character.isDigit(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
}
}
private void EDIT1ActionPerformed(java.awt.event.ActionEvent evt) {
dummy bot=new dummy();
bot.setVisible(true);
this.dispose();
}
private void tblMouseClicked(java.awt.event.MouseEvent evt) {
try{
DefaultTableModel tab1=(DefaultTableModel) tbl.getModel();
int selectedRowIndex=tbl.getSelectedRow();

29
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

LRN.setText(tab1.getValueAt(selectedRowIndex,0).toString());
name.setText(tab1.getValueAt(selectedRowIndex,1).toString());

String potato=( tab1.getValueAt(selectedRowIndex,2).toString());

switch(potato)
{
case "MALE":
gender.setSelectedIndex(0);
break;
case "FEMALE":
gender.setSelectedIndex(1);
break;
}
Date date =new SimpleDateFormat("MM-dd-
yyyy").parse((String)tab1.getValueAt(selectedRowIndex, 3));
birthdate.setDate(date);
String banana=( tab1.getValueAt(selectedRowIndex,4).toString());

switch(banana)
{
case "CHRISTIANITY":
strand.setSelectedIndex(0);
break;
case "OTHERS":
strand.setSelectedIndex(1);
break;
}
bar.setText(tab1.getValueAt(selectedRowIndex,5).toString());
city.setText(tab1.getValueAt(selectedRowIndex,6).toString());
province.setText(tab1.getValueAt(selectedRowIndex,7).toString());
father.setText(tab1.getValueAt(selectedRowIndex,8).toString());
mother.setText(tab1.getValueAt(selectedRowIndex,9).toString());
guardian.setText(tab1.getValueAt(selectedRowIndex,10).toString());
contact.setText(tab1.getValueAt(selectedRowIndex,11).toString());
schoolid.setText(tab1.getValueAt(selectedRowIndex,12).toString());
division.setText(tab1.getValueAt(selectedRowIndex,13).toString());
region.setText(tab1.getValueAt(selectedRowIndex,14).toString());
String potatomarga=(tab1.getValueAt(selectedRowIndex,15).toString());
switch(potatomarga)
{
case "ANIMATION":
st.setSelectedIndex(0);
break;
case "PROGRAMMING":
st.setSelectedIndex(1);
break;

30
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
case
"ABM":
st.setSelectedIndex(2);
break;
case "HE":
st.setSelectedIndex(3);
break;
}
}
catch (Exception e)
{
}
}
private void sortActionPerformed(java.awt.event.ActionEvent evt) {
datatyp64 bot=new datatyp64();
bot.setVisible(true);
this.dispose();
}

private void barKeyTyped(java.awt.event.KeyEvent evt) {

int bananaa =bar.getCaretPosition();
bar.setText(bar.getText().toUpperCase());
bar.setCaretPosition(bananaa);
char a=evt.getKeyChar();
if(!(Character.isLetter(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
}
}
private void cityKeyTyped(java.awt.event.KeyEvent evt) {
int bananaa =city.getCaretPosition();
city.setText(city.getText().toUpperCase());
city.setCaretPosition(bananaa);
char a=evt.getKeyChar();
if(!(Character.isLetter(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
}
}
private void provinceKeyTyped(java.awt.event.KeyEvent evt) {
int bananaa =province.getCaretPosition();
province.setText(province.getText().toUpperCase());
province.setCaretPosition(bananaa);
char a=evt.getKeyChar();
if(!(Character.isLetter(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{

31
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

evt.consume();
} }
private void LRNKeyPressed(java.awt.event.KeyEvent evt) {
String lrn = LRN.getText();
int length =lrn.length();
char c= evt.getKeyChar();

if(evt.getKeyChar()>='0' && evt.getKeyChar()<='9')

{
if(length<12){
LRN.setEditable(true);

}else{
LRN.setEditable(false);
}

}else{
if (evt.getExtendedKeyCode()==KeyEvent.VK_BACK_SPACE ||
evt.getExtendedKeyCode()==KeyEvent.VK_DELETE){
LRN.setEditable(true);
}else{
LRN.setEditable(false);
}
}
}
private void contactKeyPressed(java.awt.event.KeyEvent evt) {
String lrn = contact.getText();
int length =lrn.length();
char c= evt.getKeyChar();

if(evt.getKeyChar()>='0' && evt.getKeyChar()<='9')

{
if(length<11){
contact.setEditable(true);

}else{
contact.setEditable(false);
}
}else{
if (evt.getExtendedKeyCode()==KeyEvent.VK_BACK_SPACE ||
evt.getExtendedKeyCode()==KeyEvent.VK_DELETE){

32
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

contact.setEditable(true);
}else{
contact.setEditable(false);
}
} }
private void schoolidKeyTyped(java.awt.event.KeyEvent evt) {
char a=evt.getKeyChar();
if(!(Character.isDigit(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
} private void schoolidKeyPressed(java.awt.event.KeyEvent evt) {
String lrn = schoolid.getText();

int length =lrn.length();

char c= evt.getKeyChar();

if(evt.getKeyChar()>='0' && evt.getKeyChar()<='9')

{
if(length<6){
schoolid.setEditable(true);

}else{
schoolid.setEditable(false);
}
}else{
if (evt.getExtendedKeyCode()==KeyEvent.VK_BACK_SPACE ||
evt.getExtendedKeyCode()==KeyEvent.VK_DELETE){
schoolid.setEditable(true);
}else{
schoolid.setEditable(false);
}
}
}

private void divisionKeyTyped(java.awt.event.KeyEvent evt) {

int bananaa =division.getCaretPosition();
division.setText(division.getText().toUpperCase());
division.setCaretPosition(bananaa);
char a=evt.getKeyChar();
if(!(Character.isLetter(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
}
private void regionKeyTyped(java.awt.event.KeyEvent evt) {

33
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
int
bananaa
=region.getCaretPosition();
region.setText(region.getText().toUpperCase());
region.setCaretPosition(bananaa);
char a=evt.getKeyChar();
if(!(Character.isLetter(a)||a==KeyEvent.VK_BACK_SPACE||
a==KeyEvent.VK_DELETE))
{
evt.consume();
}
}
private void nameKeyReleased(java.awt.event.KeyEvent evt) {

int NAME = name.getCaretPosition();

name.setText(name.getText().toUpperCase());
name.setCaretPosition(NAME);
}
private void barKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = bar.getCaretPosition();
bar.setText(bar.getText().toUpperCase());
bar.setCaretPosition(NAME); }
private void cityKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = city.getCaretPosition();
city.setText(city.getText().toUpperCase());
city.setCaretPosition(NAME);
}
private void provinceKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = province.getCaretPosition();
province.setText(province.getText().toUpperCase());
province.setCaretPosition(NAME);
}
private void fatherKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = father.getCaretPosition();
father.setText(father.getText().toUpperCase());
father.setCaretPosition(NAME);
}
private void motherKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = mother.getCaretPosition();
mother.setText(mother.getText().toUpperCase());
mother.setCaretPosition(NAME);
}
private void guardianKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = guardian.getCaretPosition();
guardian.setText(guardian.getText().toUpperCase());
guardian.setCaretPosition(NAME);
}

34
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
private
void
regionKeyReleased(java.awt.event.KeyEvent evt) {
int NAME = region.getCaretPosition();
region.setText(region.getText().toUpperCase());
region.setCaretPosition(NAME);
}
}
public datatyp64() {
initComponents();
}
private void heActionPerformed(java.awt.event.ActionEvent evt) {
he64 bot=new he64();
bot.setVisible(true);

this.dispose();
}
private void animationActionPerformed(java.awt.event.ActionEvent evt) {
animation64 bot=new animation64();
bot.setVisible(true);
this.dispose();
}
private void programmingActionPerformed(java.awt.event.ActionEvent evt) {
programming64 bot=new programming64();
bot.setVisible(true);
this.dispose();
}
private void abmActionPerformed(java.awt.event.ActionEvent evt) {
abm64 bot=new abm64();
bot.setVisible(true);
this.dispose();
}
}

ANIMATION TABLE PACKAGE

package system64;
import com.itextpdf.text.Document;
import com.itextpdf.text.DocumentException;
import com.itextpdf.text.FontFactory;
import com.itextpdf.text.Image;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import java.awt.Font;
import java.awt.event.KeyEvent;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;

35
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
import

java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.text.SimpleDateFormat;
import java.util.Date;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
import javax.swing.RowFilter;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableRowSorter;
import javax.swing.text.AttributeSet;

import javax.swing.text.BadLocationException;
import javax.swing.text.PlainDocument;
import net.proteanit.sql.DbUtils;
ublic class animation64 extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
public animation64() {
initComponents();
con=System64.connect();
loadtable();
fetch();
}
ublic void loadtable(){
try{
String sql= "select * from DATA64";
pst=con.prepareStatement(sql);
rs=pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));
}
catch(Exception e) {
}
}
public void fetch() {
try {
String q = "select *from DATA64 WHERE STRAND = 'ANIMATION' ";
pst = con.prepareStatement(q);
rs = pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));

} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void tblKeyPressed(java.awt.event.KeyEvent evt) {

36
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

tbl.removeEditor();
private void animationActionPerformed(java.awt.event.ActionEvent evt) {

JFileChooser dialog=new JFileChooser();

dialog.setSelectedFile(new File("ANIMATION"+"-SF1 FORMS"+".pdf"));

int dialogResult=dialog.showSaveDialog(null);
if(dialogResult==JFileChooser.APPROVE_OPTION){

String path=dialog.getSelectedFile().getPath();
try{
Document doc=new Document(PageSize.A4.rotate());
// Image image =Image.getInstance("deped.png");
//document.add(new Paragraph("Image"));
/// document.add(image);
PdfWriter.getInstance(doc, new FileOutputStream(path+" "+jLabel5.getText()+"
"+".pdf"));

try{

doc.open();

doc.add(new Paragraph(" "+"School Form 1

School Register for Senior High School (SF1-
SHS)",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"Maya-Maya St.
Kaunlaran Village, Longos, Malabon City
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
"+"PANGHULO NATIONAL HIGH SCHOOL
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"LUNCH COUNTER REP ORT FOR THE
MONTH O F" +Month.getSelectedItem()
+taon.getYear(),FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

// doc.add ( new Paragraph("

"+Month.getSelectedItem(),FontFactory.getFont(FontFactory.TIMES_ROMAN,25,Paragrap
h.ALIGN_CENTER)));

doc.add(new
Paragraph("--------------------------------------------------------------------------------------------------

37
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
---- -------------
---- -------------
--------------------------------- ",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14,
Font.BOLD)));
doc.add(new Paragraph("
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

PdfPTable table=new PdfPTable(16);

//ADDING HEADER

table.addCell("LRN");
table.addCell("NAME");
table.addCell("SEX");
table.addCell("BIRTHDATE");
table.addCell("RELIGION");
table.addCell("BARANGGAY");
table.addCell("CITY");
table.addCell("PROVINCE");
table.addCell("FATHER'S NAME");
table.addCell("MOTHER'S NAME");
table.addCell("GUARDIAN");
table.addCell("CONTACT");
table.addCell("SCHOOL ID");
table.addCell("DIVISION");
table.addCell("REGION");
table.addCell("STRAND");

for (int i = 0; i< tbl.getRowCount(); i++){

String lrn=tbl.getValueAt(i,1).toString();
String name=tbl.getValueAt(i,2).toString();
String gender=tbl.getValueAt(i,3).toString();
String birthdate=tbl.getValueAt(i,4).toString();
String strand=tbl.getValueAt(i,5).toString();
String bar =tbl.getValueAt(i,6).toString();
String city=tbl.getValueAt(i,6).toString();
String province=tbl.getValueAt(i,7).toString();
String father=tbl.getValueAt(i,8).toString();
String mother=tbl.getValueAt(i,9).toString();
String guardian=tbl.getValueAt(i,10).toString();
String contact=tbl.getValueAt(i,11).toString();
String schoolid=tbl.getValueAt(i,12).toString();
String division=tbl.getValueAt(i,13).toString();
String region=tbl.getValueAt(i,14).toString();
String st=tbl.getValueAt(i,15).toString();
table.addCell(lrn);
table.addCell(name);
table.addCell(gender);

38
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

table.addCell(birthdate);
table.addCell(strand);
table.addCell(bar);
table.addCell(city);
table.addCell(province);
table.addCell(father);
table.addCell(mother);
table.addCell(guardian);

table.addCell(contact);
table.addCell(schoolid);
table.addCell(division);
table.addCell(region);
table.addCell(st);
}
doc.add(table);
} catch (DocumentException ex) {
}
doc.close();
fetch();}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
}

private void EDIT1ActionPerformed(java.awt.event.ActionEvent evt) {

mainform bot=new mainform();
bot.setVisible(true);
this.dispose();
// TODO add your handling code here:
}public static void main(String args[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and
feel.
* For details see
http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
for (javax.swing.UIManager.LookAndFeelInfo info :
javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}

39
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
} catch

(ClassNotFoundException ex) {

java.util.logging.Logger.getLogger(animation64.class.getName()).log(java.util.logging.Level
.SEVERE, null, ex);
} catch (InstantiationException ex) {

java.util.logging.Logger.getLogger(animation64.class.getName()).log(java.util.logging.Level
.SEVERE, null, ex);
} catch (IllegalAccessException ex) {

java.util.logging.Logger.getLogger(animation64.class.getName()).log(java.util.logging.Level
.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {

java.util.logging.Logger.getLogger(animation64.class.getName()).log(java.util.logging.Level
.SEVERE, null, ex);
}
//</editor-fold>

/* Create and display the form */

java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new animation64().setVisible(true);
}
});
}
}
ABM
public class abm64 extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
/**
* Creates new form abm64
*/
public abm64() {
initComponents();
con=System64.connect();
loadtable();
fetch();
}
public void loadtable(){

try{
String sql= "select * from DATA64";
pst=con.prepareStatement(sql);

rs=pst.executeQuery();

40
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

tbl.setModel(DbUtils.resultSetToTableModel(rs));

}
catch(Exception e) {

}
}
public void fetch() {

try {

String q = "select *from DATA64 WHERE STRAND = 'ABM' ";

pst = con.prepareStatement(q);
rs = pst.executeQuery();

tbl.setModel(DbUtils.resultSetToTableModel(rs));

} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void tblMouseExited(java.awt.event.MouseEvent evt) {
tbl.removeEditor();
private void animationActionPerformed(java.awt.event.ActionEvent evt) {

JFileChooser dialog=new JFileChooser();

dialog.setSelectedFile(new File("ABM"+"-SF1 FORMS"+".pdf"));

int dialogResult=dialog.showSaveDialog(null);
if(dialogResult==JFileChooser.APPROVE_OPTION){
String path=dialog.getSelectedFile().getPath();
try{
Document doc=new Document(PageSize.A4.rotate());
PdfWriter.getInstance(doc, new FileOutputStream(path+" "+jLabel5.getText()+"
"+".pdf"));

try{

doc.open();

41
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

doc.add(new Paragraph(" "+"School Form 1 School

Register for Senior High School (SF1-
SHS)",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"Maya-Maya St.
Kaunlaran Village, Longos, Malabon City
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
"+"PANGHULO NATIONAL HIGH SCHOOL
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"LUNCH COUNTER REP ORT FOR THE
MONTH O F" +Month.getSelectedItem()
+taon.getYear(),FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

// doc.add ( new Paragraph("

"+Month.getSelectedItem(),FontFactory.getFont(FontFactory.TIMES_ROMAN,25,Paragrap
h.ALIGN_CENTER)));

doc.add(new
Paragraph("--------------------------------------------------------------------------------------------------
-------------------------------------------------------------------
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

PdfPTable table=new PdfPTable(16);

//ADDING HEADER

table.addCell("LRN");
table.addCell("NAME");
table.addCell("SEX");
table.addCell("BIRTHDATE");
table.addCell("RELIGION");
table.addCell("BARANGGAY");
table.addCell("CITY");
table.addCell("PROVINCE");
table.addCell("FATHER'S NAME");
table.addCell("MOTHER'S NAME");
table.addCell("GUARDIAN");
table.addCell("CONTACT");
table.addCell("SCHOOL ID");
table.addCell("DIVISION");
table.addCell("REGION");
table.addCell("STRAND");

for (int i = 0; i< tbl.getRowCount(); i++){

42
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
String

lrn=tbl.getValueAt(i,1).toString();
String name=tbl.getValueAt(i,2).toString();
String gender=tbl.getValueAt(i,3).toString();
String birthdate=tbl.getValueAt(i,4).toString();
String strand=tbl.getValueAt(i,5).toString();
String bar =tbl.getValueAt(i,6).toString();
String city=tbl.getValueAt(i,6).toString();
String province=tbl.getValueAt(i,7).toString();
String father=tbl.getValueAt(i,8).toString();
String mother=tbl.getValueAt(i,9).toString();
String guardian=tbl.getValueAt(i,10).toString();
String contact=tbl.getValueAt(i,11).toString();
String schoolid=tbl.getValueAt(i,12).toString();
String division=tbl.getValueAt(i,13).toString();
String region=tbl.getValueAt(i,14).toString();
String st=tbl.getValueAt(i,15).toString();
table.addCell(lrn);
table.addCell(name);
table.addCell(gender);
table.addCell(birthdate);
table.addCell(strand);
table.addCell(bar);
table.addCell(city);
table.addCell(province);
table.addCell(father);
table.addCell(mother);
table.addCell(guardian);
table.addCell(contact);
table.addCell(schoolid);
table.addCell(division);
table.addCell(region);
table.addCell(st);
}
doc.add(table);
} catch (DocumentException ex) {
}
doc.close();
fetch();}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
}
}

}
public class he64 extends javax.swing.JFrame {
Connection con=null;

43
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

PreparedStatement pst=null;
ResultSet rs=null;
/**
* Creates new form he64
*/
public he64() {
initComponents();
con=System64.connect();
loadtable();
fetch();
}
public void loadtable(){
try{
String sql= "select * from DATA64";
pst=con.prepareStatement(sql);

rs=pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));
}
catch(Exception e) {
}
}
public void fetch() {
try {
String q = "select *from DATA64 WHERE STRAND = 'HE' ";
pst = con.prepareStatement(q);
rs = pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
}
}
private void animationActionPerformed(java.awt.event.ActionEvent evt) {

JFileChooser dialog=new JFileChooser();

dialog.setSelectedFile(new File("HE"+"-SF1 FORMS"+".pdf"));

int dialogResult=dialog.showSaveDialog(null);
if(dialogResult==JFileChooser.APPROVE_OPTION){
String path=dialog.getSelectedFile().getPath();
try{
Document doc=new Document(PageSize.A4.rotate());
PdfWriter.getInstance(doc, new FileOutputStream(path+" "+jLabel5.getText()+"
"+".pdf"));

44
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
try{

doc.open();

doc.add(new Paragraph(" "+"School Form 1

School Register for Senior High School (SF1-
SHS)",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"Maya-Maya St.
Kaunlaran Village, Longos, Malabon City
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
"+"PANGHULO NATIONAL HIGH SCHOOL
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"LUNCH COUNTER REP ORT FOR THE
MONTH O F" +Month.getSelectedItem()
+taon.getYear(),FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

// doc.add ( new Paragraph("

"+Month.getSelectedItem(),FontFactory.getFont(FontFactory.TIMES_ROMAN,25,Paragrap
h.ALIGN_CENTER)));

doc.add(new
Paragraph("--------------------------------------------------------------------------------------------------
-------------------------------------------------------------------
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

PdfPTable table=new PdfPTable(16);

//ADDING HEADER

table.addCell("LRN");
table.addCell("NAME");
table.addCell("SEX");
table.addCell("BIRTHDATE");
table.addCell("RELIGION");

table.addCell("BARANGGAY");
table.addCell("CITY");
table.addCell("PROVINCE");
table.addCell("FATHER'S NAME");
table.addCell("MOTHER'S NAME");
table.addCell("GUARDIAN");
table.addCell("CONTACT");
table.addCell("SCHOOL ID");

45
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

table.addCell("DIVISION");
table.addCell("REGION");
table.addCell("STRAND");

for (int i = 0; i< tbl.getRowCount(); i++){

String lrn=tbl.getValueAt(i,1).toString();
String name=tbl.getValueAt(i,2).toString();
String gender=tbl.getValueAt(i,3).toString();
String birthdate=tbl.getValueAt(i,4).toString();
String strand=tbl.getValueAt(i,5).toString();
String bar =tbl.getValueAt(i,6).toString();
String city=tbl.getValueAt(i,6).toString();
String province=tbl.getValueAt(i,7).toString();
String father=tbl.getValueAt(i,8).toString();
String mother=tbl.getValueAt(i,9).toString();
String guardian=tbl.getValueAt(i,10).toString();
String contact=tbl.getValueAt(i,11).toString();
String schoolid=tbl.getValueAt(i,12).toString();
String division=tbl.getValueAt(i,13).toString();
String region=tbl.getValueAt(i,14).toString();
String st=tbl.getValueAt(i,15).toString();
table.addCell(lrn);
table.addCell(name);
table.addCell(gender);
table.addCell(birthdate);
table.addCell(strand);
table.addCell(bar);
table.addCell(city);
table.addCell(province);
table.addCell(father);
table.addCell(mother);
table.addCell(guardian);
table.addCell(contact);
table.addCell(schoolid);
table.addCell(division);
table.addCell(region);
table.addCell(st);

}
doc.add(table);
} catch (DocumentException ex) {
}
doc.close();
fetch();}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}

46
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
}
}
public class programming64 extends javax.swing.JFrame {
Connection con=null;
PreparedStatement pst=null;
ResultSet rs=null;
public programming64() {
initComponents();
con=System64.connect();
loadtable();
fetch();
}
public void loadtable(){
try{
String sql= "select * from DATA64";
pst=con.prepareStatement(sql);
rs=pst.executeQuery();
tbl.setModel(DbUtils.resultSetToTableModel(rs));
}
catch(Exception e) {
}
}
public void fetch() {
try {
String q = "select *from DATA64 WHERE STRAND = 'PROGRAMMING' ";
pst = con.prepareStatement(q);
rs = pst.executeQuery();

tbl.setModel(DbUtils.resultSetToTableModel(rs));
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e);
} }
private void programmingActionPerformed(java.awt.event.ActionEvent evt) {

JFileChooser dialog=new JFileChooser();

dialog.setSelectedFile(new File("PROGRAMMING"+"-SF1 FORMS"+".pdf"));

int dialogResult=dialog.showSaveDialog(null);
if(dialogResult==JFileChooser.APPROVE_OPTION){
String path=dialog.getSelectedFile().getPath();
try{
Document doc=new Document(PageSize.A4.rotate());
PdfWriter.getInstance(doc, new FileOutputStream(path+" "+jLabel5.getText()+"
"+".pdf"));

47
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL
try{

doc.open();

doc.add(new Paragraph(" "+"School Form 1

School Register for Senior High School (SF1-
SHS)",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"Maya-Maya St.
Kaunlaran Village, Longos, Malabon City
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
"+"PANGHULO NATIONAL HIGH SCHOOL
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
// doc.add(new Paragraph(" "+"LUNCH COUNTER REP ORT FOR THE
MONTH O F" +Month.getSelectedItem()
+taon.getYear(),FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

// doc.add ( new Paragraph("

"+Month.getSelectedItem(),FontFactory.getFont(FontFactory.TIMES_ROMAN,25,Paragrap
h.ALIGN_CENTER)));

doc.add(new
Paragraph("--------------------------------------------------------------------------------------------------
-------------------------------------------------------------------
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));
doc.add(new Paragraph("
",FontFactory.getFont(FontFactory.TIMES_ROMAN, 14, Font.BOLD)));

PdfPTable table=new PdfPTable(16);

//ADDING HEADER

table.addCell("LRN");
table.addCell("NAME");
table.addCell("SEX");
table.addCell("BIRTHDATE");
table.addCell("RELIGION");
table.addCell("BARANGGAY");
table.addCell("CITY");
table.addCell("PROVINCE");
table.addCell("FATHER'S NAME");
table.addCell("MOTHER'S NAME");
table.addCell("GUARDIAN");
table.addCell("CONTACT");
table.addCell("SCHOOL ID");
table.addCell("DIVISION");

48
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

table.addCell("REGION");
table.addCell("STRAND");

for (int i = 0; i< tbl.getRowCount(); i++){

String lrn=tbl.getValueAt(i,1).toString();
String name=tbl.getValueAt(i,2).toString();
String gender=tbl.getValueAt(i,3).toString();
String birthdate=tbl.getValueAt(i,4).toString();
String strand=tbl.getValueAt(i,5).toString();
String bar =tbl.getValueAt(i,6).toString();
String city=tbl.getValueAt(i,6).toString();
String province=tbl.getValueAt(i,7).toString();
String father=tbl.getValueAt(i,8).toString();
String mother=tbl.getValueAt(i,9).toString();
String guardian=tbl.getValueAt(i,10).toString();
String contact=tbl.getValueAt(i,11).toString();
String schoolid=tbl.getValueAt(i,12).toString();
String division=tbl.getValueAt(i,13).toString();
String region=tbl.getValueAt(i,14).toString();
String st=tbl.getValueAt(i,15).toString();
table.addCell(lrn);
table.addCell(name);
table.addCell(gender);
table.addCell(birthdate);
table.addCell(strand);
table.addCell(bar);
table.addCell(city);
table.addCell(province);
table.addCell(father);
table.addCell(mother);
table.addCell(guardian);
table.addCell(contact);
table.addCell(schoolid);
table.addCell(division);
table.addCell(region);
table.addCell(st);
}
doc.add(table);
} catch (DocumentException ex) {
}
doc.close();
fetch();}
catch(Exception e){
JOptionPane.showMessageDialog(null, e);
}
}
}

49
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Curriculum
Vitae

50
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Harvey M. Alonday
#165 MH Del Pilar St., Santulan Malabon City
0999-511-4735 (mobile)
harvey.alonday@gmail.com

Objective

Good and Honest Student of Panghulo National High School (SHS) respectful and kind to the other
employee.

Work Experience

January 13,2020 – February 13, 2020 Work Immersion in Key Media Phillipines.

Balangkas Valenzuela City

Skills Summary

 Visual Graphics Design

 Adobe Photoshop
 HTML 5, Java and JavaScript
 Robot Programming/building

Education Year Graduated

Senior High School Panghulo National High School 2019-present

Panghulo, Malabon City

Junior High School Panghulo National High School Graduated

Panghulo, Malabon City April,2017

Elementary Panghulo Elementary School Graduated

Panghulo, Malabon City April,2014

Accomplishments

National National Certificates

Visual Graphics Design

SEMINARS/Trainings attended

March 14, 2019 DepEd CyberExpo (Grade 11)

Philippine International Convention Center
Pasay, Metro Manila

October 7, 2019 ICC JAVA Training (Grade 12)

Interface Computer College
10th Avenue

51
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Nov, 19,2017 Bert Seminar Meeting and Training

Winnings/Awards
April, 2019 With Honors (Grade 11)
Panghulo National High School

Nov, 2019 Robotics Science Fair Competition

Champion (Firefighting)

April 2018 Robotics Science Fair Competition

Champion (Color Sorter)
First Runner up (Sumo Bot)

Other Skills

 Adobe Photoshop
 MS Word, and MS PowerPoint
 Robot Programming

Interests and Hobbies

Playing computer games, playing drums, internet surfing, playing mobile games, listening to rock and rap
music

Character References

Andres P. Bonifacio (+639) 0966-018-1898

Master Teacher l, Panghulo National High School andres.bonifacio@deped.gov.ph
Malabon City

Loida B. Sacueza (+639) 0956-977-1169

Work Immersion Facilitator, Panghulo National High School loida.sacueza@deped.gov.ph
MalabonCity

Demetrio Pable Jr. (+639)0905-269-2518

Trainer / Assessor pabledemetrio027@gmail.com
Caloocan City

52
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

ALPHA JOY NOVILLAS

#306 Raja Lapu-lapu st., Daanghari Navotas City
Contact no.: 0923-168-8020 (mobile) 351-1085 (phone)
E-mail: alphajoy.novillas@gmail.com

Skills Summary

 Visual Graphics Design

 Adobe Photoshop
 HTML 5, CSS3, Java and JavaScript
 Computer Hardware and Software servicing

Education Year Graduated

Senior High School Panghulo National High School 2019-present

Panghulo, Malabon City

Junior High School Navotas National High School Graduated with Honors
Sipac, Navotas City April, 2018

Elementary Daangahari Elementary School

Daanghari, Navotas City March,2014

Accomplishments

Work Experience

January 13 – February 14 Work Immersion at Interface Computer

College (Technical Support/ Editor)

National National Certificates

Visual Graphics Design

SEMINARS/Trainings attended

October- December 5, 2019 Joint Delivery Voucher Program (JDVP)

Interface Computer Collage, Caloocan City

March 12,2019 Cyber Expo DepEd

Philippine International Convention Center

January 31, 2019 Golden Opportunity in Web Development

Panghulo National High School

53
 Republic of the Philippines
Department of Education
National Capital Region
SCHOOLS DIVISION OFFICE - MALABON CITY
PANGHULO NATIONAL HIGH SCHOOL

Other Skills

 Filmora Video Editor

 MS Word, MS Excel, MS PowerPoint and MS Publisher
 Adobe Photoshop Photo Editor

Interests and Hobbies

Listening to music, internet surfing, watching k-dramas, cartoons

Character References

Andres P. Bonifacio (+639) 0966-018-1898

Master Teacher I, Panghulo National High School andres.bonifacio@deped.gov.ph
Malabon City

Loida B. Sacueza (+639) 0956-977-1169

Work Immersion Facilitator, Panghulo National High School loida.sacueza@deped.gov.ph
Malabon City

Demetrio Pable Jr. (+639) 0905-269-2518

Trainer/Assessor pabledemetrio027@gmail.com
Malabon City

54