Information Technology, Discussion, IT Subject, and Exploration

Sample Program to insert data in the database using java

2010-01-21T01:58:00.000-08:00

package Queries;
import java.util.Scanner;
import java.sql.*;

public class InsertRoom {

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DATABASE_URL = "jdbc:mysql://localhost/doscstschedule";
static private PreparedStatement insertNewRoom = null;
static String roomCode;
static String deptCode;

public static void main(String[] args) {

Connection connection = null; // manages connection

// connect to database doscstschedule and query database
try {

Class.forName(JDBC_DRIVER); // load database driver class

// establish connection to database
connection = DriverManager.getConnection(DATABASE_URL, "root", "");
Scanner input = new Scanner(System.in);
System.out.print("Enter room code: ");
roomCode = input.next();
System.out.print("Enter department code: ");
deptCode = input.next();

// create Statement for querying database
insertNewRoom = connection.prepareStatement("insert into room values(?,?)");
insertNewRoom.setString(1, roomCode);
insertNewRoom.setString(2, deptCode);

insertNewRoom.executeUpdate();

System.out.println("Data successfully added");
} // end try
catch (SQLException sqlException) {
sqlException.getMessage();
System.exit(0);
} // end catch
catch (ClassNotFoundException classNotFound) {
classNotFound.getMessage();
System.exit(0);
} // end catch
finally // ensure statement and connection are closed properly
{
try {
insertNewRoom.close();
connection.close();
} // end try
catch (Exception exception) {
exception.getMessage();
System.exit(0);
} // end catch
} // end finally
}
}

Displaying data in database using java and mySQL

2010-01-15T23:59:00.000-08:00

//This is only an example program on displaying data from database using java and mysql
//important information should be considered.

import java.sql.*;

public class DisplaySubject {

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DATABASE_URL = "jdbc:mysql://localhost/doscstschedule";

public static void main(String[] args) {

Connection connection = null; // manages connection
Statement statement = null; // query statement

// connect to database books and query database
try {
Class.forName(JDBC_DRIVER); // load database driver class

// establish connection to database
connection =
DriverManager.getConnection(DATABASE_URL, "root","");

// create Statement for querying database
statement = connection.createStatement();

// query database
ResultSet resultSet = statement.executeQuery(
"SELECT subjCode,subjDesc, lecUnits, labUnits FROM subject");

// process query results
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println("Subject Table of DOSCST Class Schedule Database:");

for (int i = 1; i <= numberOfColumns; i++) {
System.out.printf("%-30s\t", metaData.getColumnName(i));
}
System.out.println();

while (resultSet.next()) {
for (int i = 1; i <= numberOfColumns; i++) {
System.out.printf("%-30s\t", resultSet.getObject(i));
}
System.out.println();
} // end while
} // end try
catch (SQLException sqlException) {
sqlException.printStackTrace();
System.exit(1);
} // end catch
catch (ClassNotFoundException classNotFound) {
classNotFound.printStackTrace();
System.exit(1);
} // end catch
finally // ensure statement and connection are closed properly
{
try {
statement.close();
connection.close();
} // end try
catch (Exception exception) {
exception.printStackTrace();
System.exit(1);
} // end catch
} // end finall
}
}

Java JDBC using MySQL Database

2010-01-12T23:11:00.000-08:00

Important notes:

You need to download the jdbc connector of mysql and java in http://dev.mysql.com/downloads/connector/j/
Add this package to your libraries
The information below is all about how to access the driver.

import java.sql.*;
import javax.swing.JOptionPane;
public class Main {

/**
* @param args the command line arguments
*/
public static void main(String[] args) throws Exception {
StringBuffer output = new StringBuffer();
output.append("Tesing MySQL Driver installation");
try {
String className = "com.mysql.jdbc.Driver";
Class driverObject = Class.forName(className);
output.append("Driver: "+driverObject+"\n");
output.append("Driver Installation Successful");
JOptionPane.showMessageDialog(null, output);
}
catch(Exception x){
output = new StringBuffer();
output.append("Driver Installation FAILED\n");
JOptionPane.showMessageDialog(null,output);
System.out.println("Failed Driver Error:" +x.getMessage());
}

}
}

* on this part is an example of how to connect the mysql database using java

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.DriverManager;
import java.sql.SQLException;

public class JDBCDriverInformation {

static String userid = "root";
static String password = "";
static String url = "jdbc:mysql://localhost:3306/databaseapp";
static Connection con = null;
static String className = "com.mysql.jdbc.Driver";

public static void main(String[] args) throws Exception {
Connection con = getMySQLJDBCConnection();
if (con != null) {
System.out.println("Got Connection");
DatabaseMetaData meta = con.getMetaData();
System.out.println("Driver Name : " + meta.getDriverName());
System.out.println("Driver Version : " + meta.getDriverVersion());
} else {
System.out.println("Could not get connection");
}
}

public static Connection getMySQLJDBCConnection() {

try {
Class.forName(className);

} catch (java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}

try {
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/databaseapp", userid, password);
} catch (SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());

}

return con;
}
}

Hope you can run successfully in this given example.

My New Website

2009-08-20T21:45:00.000-07:00

This is my first time created a web application..

I need comments for this. Please send me comments at my email: jonathancabrera85@yahoo.com

Website: www.doscst.co.nr/gctc

thanks

nathan

Am I an IT Professional?

2009-03-24T19:56:00.000-07:00

Before I answer the question, let me first define the profession. According to Webster's Dictionary, a "profession is a calling requiring specialized knowledge and often long and intensive academic preparation". The United States Code of Federal Regulations [29 CFR Sec. 541.3] defines a person " employed in a professional capacity" as one who meets these four criteria:

One's primary duties consist of the performance of work requiring knowledge of an advanced type in a field of science or learning customarily acquired by a prolonged course of specialized intellectual instruction and study or work.
One's instruction, study, or work is original and creative in character in a recognized fields of artistic endeavor and the result of which depends primarily on the invention, imagination, or talent of the employee.
One's work requires the consistent exercise of discretion and judgment on its performance.
One's work is predominately intellectual and varied in character and is of such character that the output produced or the result accomplished cannot be standardized in relation to a given period of time.

reference: Ethics in Information Technology Book by George Reynolds

In other words, a professional is someone who requires advanced training and experience, must exercise discretion and judgment in the course of his or her work, and whose work cannot be standardized. Many people would add that they expect a professional to contribute to society, to participate in a life-long training program (both formal and informal), to keep abreast of developments in their field, and to help develop other professionals. In addition, many professional roles carry with them special rights and special responsibilities. Doctors, for example, are allowed to are also expected to help individuals who are hurt in accidents or emergencies. Accountants, lawyers, priests and licensed engineers also have special rights and responsibilities.

Given the definition of "professional," My answer is,YES, I am an IT Professional. There are many business workers whose duties,background and training, and work could qualify them to be classified as professionals. These people include marketing analysts, financial consultants, and IT specialists. A partial list of IT specialists includes programmers, systems analysts, software engineers, database administrators, LAN Administrators and Chief Information Officers (CIOs).

From my own standpoint, I am IT professional in the sense that my duties consist of the performance of work requiring knowledge of an advanced type in a field of science and I also exercise the field. I've worked as an computer technician, IT consultant of one business in our place and I am a Instructor. I've passed some certification in TESDA also. I'll always practicing this field today and forever with ETHICAL WAYS

From a practical standpoint, the IT industry recognizes people from a wide set of backgrounds,education and personal experience in many different roles as IT professionals-provided they can do the job required by such a role.

"I AM PROUD TO SAY THAT I AM AN IT PROFESSIONAL"

Case 3 - Orchid Seller

2009-03-19T20:52:00.000-07:00

Designing Relational Database

Creating Tables Using MS Access
1. Orchid

2. OrchidItem

3. Wholesaler

Query 1: Greenhouse Requirements

Result:

Query 2: Orchids That Died

Query 3: Orchids Not in Bloom

Query 4: Best Sellers

Query 5 : Most Profitable Orchids Groups

Report: Profit by Supplier

2009-02-19T19:58:00.000-08:00

Case 2 - The Outsourcing Bookkeeping and Payroll Company

Designing Database Tables

Created Tables using Ms Access

Form: Jobs Input

Query 1: Sales Calls

Query 2: Hours Worked Per Client

Report 1: Clients by ZIP

Report 2: Workers and Times for Client

Conquering Mt. Apo

2009-02-09T02:24:00.000-08:00

Purpose: Manghinlo ta kay APO 2008
(the best things happen in my life........................)

I was excited to climb the highest pick of the Philippines to prove my self that i'm a Mountaineer.
This is the story in our journey......

October 22, 2008...Day 1
Club Tikod ( one of the mountaineering society in DOSCST) arrived at assembly area-NCCC Mall Davao. And at around 8 am, we went to Digos City for registration. Then, we forwarded to our jump-off area for the Campsite 1, Barangay Kapatagan.

We finally reached the jump-off area at around 2pm. Along the way the rain showers welcomed us together with the hosts group, AMOSS and HADAMS. At that day, I felt I am in the Bagiuo.... it's so lamig....hooowooooooooooo.........

Super hagok.....zzzzzzzzZZZZZZZZZZZZZZZ...
Overnight rest at Campsite1

October 23, 2008 Day2 trail to Gudi-gudi forest.....everyone was excited....

We are in the middle of the forest.... (hadlok, dami malalaking tree) and foggy masyado....huhuhuh... nasaan na sila?????

Nilindol kami (earthquake) around 6pm......Ok lang may signal din naman, text text while earthquaking, jejejejejeje

October 24, 2008 Day3 This day,the day we starting to climb to the BOULDERS, then to CRATER, and then to PEAK.

A good place for picture taking....also a good spot over sight-seeing..

....from the small rocks the the huge rocks, they are called BOULDERS (it so rocky here....)

foggy masyado ... nasaan na sila??? smile always kahit nahirapan na.......

we reached the sulfur... la ako jan.. bawal may ubo ako.......

introducing the Mt. APO CRATER.....dry masyado... hindi na kasi active...

Finally we reached the SUMMIT.....

ang lamig .....gggggggrrrrrrrrrrrrrrrrr............

October 25, 2008 Day4 Next journey,LAKE VENADO ..Amazing... picture pa lang yan na kuha sa malayo.. nice lake..whew......... Kinda Excited

October 26, 2008 Day 5 We are now going to return to Digos City...our happy memories that encounter with natures doesn't perished...but wait we also dropped by the CENTURY TREE...Hope our trees would really reach century years..

Motto: Bring nothing but memories. Leave nothing but footprints....abot unsa tong sunod.hehehheheeh

GOD Gives US this thing and we should preserve this for the future generation....

(until next time... marami pang journey and adventure ang ilagay ko dito... C....U... fRnD...)

Revenue From Customers - December 2005 Report in Misty Valley Country Inn Database

2009-02-05T21:45:00.001-08:00

Rooms Booked the Week of 12/12/2005 Query in Misty Valley Country Inn Database

2009-02-05T19:51:00.000-08:00

Money Generated by Room Query in Misty Valley Country Inn Database

2009-02-05T19:49:00.000-08:00

Rooms Table in Misty Valley Country Inn Database

2009-02-05T19:45:00.000-08:00

Reservations Table in Misty Valley Country Inn Database

2009-02-05T19:41:00.000-08:00

Customers Table in Misty Valley Country Inn Database

2009-02-05T19:36:00.000-08:00

Part 7- Web Preassessment Result

2009-01-30T01:47:00.000-08:00

This is my ICDL Part 7 Unit 2 - Messaging Fundamentals preassessment result. I've got (137 of 145) 94%.
Exam Date: January 30,2009

Part 7- Web Preassessment Result

2009-01-30T01:43:00.000-08:00

This is my ICDL Part 7 Unit 1 - Web Browsing Fundamentals preassessment result. I've got (37 of 39) 94%.
Exam Date: January 30,2009

Part 6- Powerpoint Preassessment Result

2009-01-30T01:38:00.000-08:00

This is my ICDL Part 6 Unit 2 - Powerpoint 2000 Advanced Features preassessment result. I've got (204 of 230) 88%.
Exam Date: January 29,2009

Part 6- Powerpoint Preassessment Result

2009-01-30T01:33:00.000-08:00

This is my ICDL Part 6 Unit 1 - Powerpoint 2000 Basics preassessment result. I've got (86 of 97) 88%.
Exam Date: January 29,2009

Part 5- Access Preassessment Result

2009-01-30T01:26:00.000-08:00

This is my ICDL Part 5 Unit 2 - Access 2000 Advanced Features preassessment result. I've got (63 of 74) 85%.
Exam Date: January 19,2009

Part 5- Access Preassessment Result

2009-01-30T01:22:00.000-08:00

This is my ICDL Part 5 Unit 1 - Access 2000 Basics preassessment result. I've got (47 of 53) 88%.
Exam Date: January 14,2009

Part 4- Spreadsheets Preassessment Result

2009-01-30T01:18:00.000-08:00

This is my ICDL Part 4 Unit 2 - Excel 2000 Advanced Features preassessment result. I've got (80 of 87) 91%.
Exam Date: January 14,2009

Part 4- Spreadsheets Preassessment Result

2009-01-30T01:13:00.000-08:00

This is my ICDL Part 4 Unit 1 - Excel 2000 Basic preassessment result. I've got (80 of 89) 89%.
Exam Date: January 13,2009

Part 3- Word Processing Preassessment result

2009-01-30T01:08:00.000-08:00

This is my ICDL Part 3 Unit 2 - Word 2000 Advanced Features preassessment result. I've got (168 of 184) 91%.
Exam Date: January 13,2009

Part 3- Word Processing Preassessment result

2009-01-30T00:58:00.000-08:00

This is my ICDL Part 3 Unit 1 - Word 2000 Basic preassessment result. I've got (93 of 103) 90%.
Exam Date: January 13,2009

Part 2- Computer and File Management Preasssessment Result

2009-01-30T00:41:00.000-08:00

This is my ICDL Part 2- Using the computer and managing files Preassessment result. I've got (81 of 86) 94%.
Exam Date: January 12, 2009

Part 1 - Basic Concepts of IT Preassessment Result

2009-01-29T22:32:00.000-08:00

This is my ICDL Part 1- Preassessment result. I've got (80 of 84) 95%.
Exam Date: January 12, 2009

Personal Finance

2009-01-23T23:05:00.000-08:00

How to Solve Financial Problems

Some Observations:

1. Personal finance or study on personal handling of money is not included in our basic education curriculum

2. Young professionals are left by themselves to discover about money matters when they get their first salaries

3. Many Filipino workers are trapped in 'loan cycle' leaving them no opportunity to save

4. Filipinos generally are not saving

5. New Filipino psyche: get rich quick by working or migrating abroad! (Costly, lots of risk, not
entirely wrong), its hopeless here!

A Personal Finance Road Map:

1. This brief overview will tell you where are you at (financially) and where are you going.

2. We will define 'financial independence' as one of your map's destination.

3. It will tell, what are the elements of your speed in getting where you want to go.

Financial Stages: A road map

Stage 1 Financial Dependence

Stage 2 Financial Sustainability

Stage 3 Financial Stability

Stage 4 Financial Independence

Stage 5 Financial Legacy

Financial Dependence

1. Needs to be supported. e.g. student, pension-less retiree, income-less unemployed

2. Very limited economic choice

3. Lives on the kindness and will of the supporter or lender

4. May have little income not enough to cover for basic needs

5. Money concerns are others'

6. Normal at young age to 18 or 21

Financial Sustainability

1. There is a livelihood to cover basic needs without incurring debts (or loans) e.g. food, shelter,
clothing, education, living expenses.

2. Income may come from work or livelihood business.

3. Income and expenses are break even, subsistence.

4. Not stable; vulnerable to shocks (e.g. sickness, emergencies), may revert back to dependence level.

5. Money is foreground concern.

6. Normal for newly employed young people

Critical Skills needed to move from dependence to sustainability:

1. Ability to create income

2. Ability to balance income and lifestyle

Financial Stability

1. This is characterized by the opportunity and ability to save for the future

2. Some Filipinos have unhealthy belief on savings

3. Savings and investment is a Biblical principle

4. Two types of savings: Emergency Fund and Security savings

5. Accumulating real estate and insurances

6. Money at the background: you are richer than before

7. There is 'cushion' in times of economic shocks

8. Simultaneously start to protect your wealth: insure your money, be a wise steward, be careful
of others taking advantage

Savings:

1. Emergency fund: a good value suggested by financial experts (for minor e-shocks) is 3-month
income level

2. Security Fund: you are beginning to step at stability stage when you have built up 6-month
income level savings

3. Suggested savings: 10 - 20% of income or more!

4. Savings is securing the future, debt is stealing the future

Financial Independence

1. Income from investment is enough to support a chosen lifestyle for a lifetime without working

2. Savings is large enough to put part of it to investments

3. Investments can be passive or active

4.When emergency savings program is completed savings can be broken into wealth building
activities: (1) Long-term pension; (2) Insurances; (3) Real estate; (4) Financial Portfolio (or
more!)

Financial Legacy

1. Perpetual fund to support a cause or charity

2. You have enough money that you want to share 'wisely' with others to build up their lives

3. However, giving is an attitude to be practiced at whatever stage you are, we have a formula
how and why you can do this on the next slide!

4. You use your money to leave this world a better place

Income Balancing: a vehicle to financial road map:

50% needs : Why is 50% level lifestyle a wise one?

20% savings: Aside from the ability to earn, this is the accelerator of your speeding up

How to Solve Financial Problems

20% wants : because we need to live and enjoy life without guilt or worry

10% others (ministry, charity): because giving is an indicator of being rich and secured inside!

Elements of Movements

1. Opportunity and ability to earn (some may be beyond our control)

2. Size of income and lifestyle: Income balancing as vehicle

3. Size of savings: the accelerator

4. Opportunity and ability to invest

5. Stewardship: wise use and wealth protection

6. God's hand

Evaluation:

1. What is your financial stage?

2. Can you start adjusting towards 'Income Balance'?

3. What are your current financial setbacks? How would you solve it?

4. Is this consistent with our need for 'daily grace'?

Conclusion:

1. This is just an overview and simple model

2. It's relevance may vary from person to person

3. It is a hope that you will be encouraged to start personally to study about 'personal finance': be
a student of money

4. It is of the assumption that God is the provider who determines each one's wealth and that
there is a 'unique point' for each one as to where God's provision and one's responsibility meets.

5. Now that you know what stage you are, you can ask for grace and opportunity to move on to
where you want to go.

Credits:

Groups of friends who heard this presentation and shared insights

Sir Roy Ponce

Authors of books where the various ideas came from and gave me opportunity to learn:

Elizabeth Warren & Amelia Warren Tyagi, 'All Your Worth: the ultimate lifetime money plan'

Jerrold Mundis, 'How to get out of debt, stay out of debt and live prosperously'

Tiki Kusternmacher,'How to simplify your life'