The Computer Society

We're moving

2012-03-07T21:54:00.002-08:00

To all readers,

We apologize to the followers of this blog that support and updates on bsitpupt.blogspot.com will be discontinued. We are currently moving to a new site codersfriend.net. We also consider migrating existing posts here to the new site. This site will remain here for archive purposes only.

I would like to take this opportunity to thank you for spending some time in this website. I would like to encourage you to visit our new site, codersfriend.net and share your knowledge with us.

Thank you
jeremejazz

Mysql Date Calculation

2011-07-14T01:11:00.000-07:00

Simple Function for Date Computation.. useful in archive retrieval

ADDDATE(date,INTERVAL expr type)
ADDDATE(date_field,INTERVAL 1 DAY)
ADDDATE(date,INTERVAL 2 DAY)
ADDDATE and SUBDATE perform date arithmetic calculations.

date is a DATETIME or DATE value specifying the starting date.
expr is an expression specifying the interval value to be added or subtracted from the starting date. expr is a string; it may start with a .-. for negative intervals.
type is a unit keyword indicating the units in which the expression should be interpreted.
Type Unit Expected Format
SECOND SECONDS
MINUTE MINUTES
HOUR HOURS
DAY DAYS
WEEK WEEKS
MONTH MONTHS
QUARTER QUARTERS
YEAR YEARS
Here we use the SUBDATE function to select products and their images added within the last month:


SELECT p.id, product_code, product_name, filename, date_added 
FROM product_tbl p 
INNER JOIN image_tbl i 
ON p.id=i.product_id 
WHERE date_added>SUBDATE(CURDATE(),INTERVAL 2 MONTH);

Source: Mysql Date Calulation - liamdelahunty.com

Computer Society in Tumblr

2011-05-11T08:48:00.001-07:00

Check us out on tumblr.com

Computer Society

Android Ebooks

2010-11-16T03:18:00.000-08:00

You can learn the basics android programming here :

for a hard copy of the book :

Turbo C/C++ Bundled

2010-10-15T05:27:00.000-07:00

You can download a bundled Turbo C/C++ here...

Download TCP_Bundle

I've also configured it so that you won't have any problems with copying it to different directories :D

Sink the Bismarck

2010-09-21T04:11:00.001-07:00

I have just updated the game I've been developing. It now comes with an animation.

Download v2

Input Validation in VB.Net

2010-08-24T01:54:00.000-07:00

Basic Backup and Restore for MS SQL Server 2000

2010-04-25T03:55:00.000-07:00

Here is a simple tutorial for backup and restore in SQL Server 2000. This tutorial covers the basic procedures in creating backup and restoring databases. In this tutorial, we will be using Northwind Database as our example since it available on the sample databases of SQL Server

Backup

Before we backup our database, we have to create a logical backup device for our database.
On the query analyzer, make the database in use by selecting it on the drop down menu or by executing the code:



Use Northwind

Now we will create our logical backup device. Make sure the path exists when you execute this. If you execute this without errors it means that you are doing right.

EXEC sp_addumpdevice 'disk', 'NWINDBackup',
'c:\NorthwindSystems\Backup\NWind_backup.bak'
--NWINDBackup will be the name of our logical backup drive

After successful execution, you cannot run this code again since it already exists¹
Then we will now backup our database with the following code:

As I said(or typed :o)) earlier, you should make sure that the path you created exists².

BACKUP DATABASE Northwind TO NWINDBackup

Restore

Now we will restore are database based on the backup file we have created.

RESTORE DATABASE Northwind
FROM NWINDBackup

The syntax follows as:

RESTORE DATABASE [your db name]
FROM [logical drive]

Notes:
¹"Honestly, I haven't figured out yet how to alter that logical backup thing but please stay tuned for updates. You can also post some suggestions for this"-jereme

². Tip: Or at least tell your front end application to create folders if it does not exist.

Opening Another Program in VB.NET

2010-04-23T03:38:00.000-07:00

Hey I got this code from the website www.dreamincode.net/forums

Try
Dim p As New System.Diagnostics.Process
'the location of your program
p.StartInfo.FileName = "K:\Uni\Year 2\Visual Basic\Report\MSDN\Absolute Beginner's Series VB Lesson 1\01 VB Code\Lesson01\HelloWorld.exe" 
p.Start()
Catch ex As Exception
MsgBox("Error - " + ex.Message)
End Try

This can be useful in opening other applications (especially Microsoft VB.NET applications). The problems is that there are chances of error especially when the program is missing, or the program has been moved.

As a solution to that problem, I suggest that you would make the separate application relative to your executable file so that
moving the whole project to another location whould not affect the path you specified.
Your file path should look like this.

p.StartInfo.FileName = "Your Program.exe"  'your relative path, no need to include the drive location for portability

Just make sure that the program is located beside the program you are debugging.
You can do this by adding another project as a reference to your main project so that everytime you compile, the executables automatically
proceed to the bin where they would reside as they are executed.
To add a refecence, you can follow these steps:

If the other program (VB Project) is not yet part of the Solution:
1. go to File > Add Existing project
2. Then select the project file of the program you want to link it with.
You will notice in the solution explorer that another project is added.

Now, you can make that program part of the main program by adding it as a reference.
On your solution explorer, right click your main project, Choose Add reference.

As the add reference dialog opens, choose projects then select the project file of the other program.

Query Displayer JAVA Program

2010-04-08T19:30:00.000-07:00

As a continuation for my earlier post in JDBC, here is a sample program I got from Java™ How to Program, by H.M. Deitel,

It looks like a query analyzer. You can use this to test the retrieval of data.

You can download the source at:
Query Displayer.zip

Just modify the following lines of code on DisplayQueryResults.java

static final String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
static final String DATABASE_URL = "jdbc:odbc:NWIND";
static final String USERNAME= "";
static final String PASSWORD= "";

// default query selects all rows from authors table
static final String DEFAULT_QUERY = "SELECT * FROM Products";

For a copy of the ebook Java how to Program, visit
javaforbidden.4shared.com
The password is: itspot
(shhh... please don't tell them about this, ok?)

STEPS IN INTEGRATING HELP FILE IN YOUR VB.NET APPLICATION

2010-04-03T13:29:00.000-07:00

1. Place this code inside your sub-menu (when clicked under main menu or button if you choose it instead). Make sure you follow the syntax below:

Help.ShowHelp(Me, [url]);

Since you use VB as programming language, it should be 'Me' not 'this' because ‘this’ is for C#. By the way, what does it mean is ‘Me’ is your main form which will become the parent of the newly opened help file (in your case, your pdf file).

Next parameter is ‘url’. In this type of parameter, it requires you to input the whole directory together with your pdf file.. For example, your help file is sample.pdf located at 'c:\program files\system'. Just add sample.pdf at the end of 'c:\program files\system' which becomes 'c:\program files\system\sample.pdf'.

So the final output of your ShowHelp() method is:

Help.ShowHelp(Me, "c:\program files\system\sample.pdf");

But there is one problem on this method if you install it in your client's computer; there is a possibility that his/her computer’s directories are different from yours. So if that's the case, follow this:

1. Place your sample.pdf file inside your project's bin-->debug folder (and bin-->release folder if there is) found in your project folder.

2. Then change your code into this

Help.ShowHelp(Me, Path.GetFullPath("sample.pdf"))

For example this is your whole code

--> You need to import System.IO at the top of your code, like this

Imports System.IO

NOTICE:

This tutorial will work only in Microsoft Visual Studio esp. 2008 (not sure in 2003 and 2005 because I used Path class which I don’t know if existing in .NET 1.1 and .NET 2.0). 2008 uses .NET 3.5.
I notice that chm, doc and pdf files will open once after clicking the button or submenu under main menu while txt will open as many times you click it.

Hope that helps! =) Always here to post useful tutorials for you guys!

JAVA to MySQL Connection(ODBC)

2010-04-03T01:21:00.000-07:00

Here we are going to discuss how to connect JAVA to MySQL
For portability and general purposes, we will be using the Open Database Connectivity(ODBC). Connecting to MySQL with the use of Open Database is similar to connecting to MS Access only with some additional steps.
Here's a copy of the database(dump file) I used in this tutorial. Just import it into your mysql. Download

Installing the Driver

1. Download MySQL ODBC Connector. I have a copy for windows users at www.mysqlodbccon.4shared.com . Please refer to the link below for more info.(Don't bother the filename if it says noinstall, you're still going to be installing it anyway)

2. Extract the Zip File and Run Install.bat (see, like I told you... although the batch (.bat) file copies the library(.dll) files into your operating system unlike real installers where they involve file extraction)

3. A message will prompt that the instalation (copying of libraries) was successful.

Setting up the Data Source

1. We will now create a Data Source Name(DNS) which will be used as a reference by the program. First go to your control panel then Administrative Tools > Data Sources(ODBC)

2. The ODBC Data Source Dialog will then appear, select the System DSN tab.

3. Click on the Add button then another Dialog Box containing the Drivers will appear. Select MySQL ODBC Driver then click Finish.

4. Another Dialog Box will appear for the final configuration. Just fill up the neccessary inputs, the Data Source Name that you will be using on the text box. The Server should contain the local server name(you can use localhost or your computer name). Enter the user and password fields, and the database that you will be using as source.

5. When your done, click finish and you will notice that the data source has been added on the list of System Data Sources.

Coding

We will now explain the coding for connecting to the database
1. First import the neccessary libraries for Database connection, java.sql:

import java.sql.*;

2. Then instantiate your connection variables

Connection con;
Statement stmt;
ResultSet rs;

3. On your procedural method, create an exception handler

try{

//Your Code Goes Here
}catch(Exception e){
System.err.println(e);
}

4.In the try block, insert your connection code, First is the forced loading of the Database Driver in Class.forName() followed by the declaration of objects we instantiated earlier.

//Load the JdbcOdbc Driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Specify the Database URL where the DNS will be and the user and password
con = DriverManager.getConnection("jdbc:odbc:TOY2","root","root");

//Initialize the statement to be used, specify if rows are scrollable
stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ResultSet will hold the data retrieved
rs = stmt.executeQuery("SELECT * FROM Humans");

//Display the results
while(rs.next()){
System.out.println(rs.getInt("ID") + " " + rs.getString("LastName") + " " + rs.getString("FirstName"));
}

For a full source code listing:

import java.sql.*;

public class ViewingMySQL {

public static void main(String[] args) {
Connection con;
Statement stmt;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:TOY2","root","root");

stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery("SELECT * FROM Humans");


while(rs.next()){
System.out.println(rs.getInt("ID") + " " + rs.getString("LastName") + " " + rs.getString("FirstName"));
}
}catch(Exception e){
System.err.println(e);
}
}
}

For more information about MySQL ODBC 5.1 Driver, including
installation instructions, please visit;
http://www.mysql.com/products/myodbc/index.html

Programming Solutions by Language

2010-04-02T20:23:00.000-07:00

"Rosetta Code is a programming chrestomathy site. The idea is to present solutions to the same task in as many different languages as possible, to demonstrate how languages are similar and different, and to aid a person with a grounding in one approach to a problem in learning another. Rosetta Code currently has 387 tasks, and covers 225 languages, though we do not (and cannot) have solutions to every task in every language.
A variety of tasks are listed, and visitors to this site are invited to solve the tasks in the language of their choice. The tasks cover everything from the mundane Empty Program to the classic Towers of Hanoi, the practical User Input, the mathematically-inclined Lucas-Lehmer test, and the involved yet entertaining RCRPG."

//SnailviN -- Based on one of its labels, this site is just for reference. Please do not rely on it too much because you will not experience the problems and will not learn it by yourself. =3 Hope this helps.

Detailed Instructions on How to Download SharpDevelop and .NET Framework 3.5 SP1

2010-03-28T10:14:00.000-07:00

This is the first time I do the posting here. The guy who is behind this blog (site specifically for all geeks like us) always asks me to post something useful like articles, tutorials and other things which can grasp your interests. Hope you like my first tutorial.

This is the present view (as of March 29, 2010) of the link I provided on his latest post.

To start using SharpDevelop, you need first to download it. Click LABEL 1 (refer to the image above) to download it to your computer. You will be transferred into their download page and save dialog box will appear.

Go to the directory you want this installer to save. Example, I want it to save in c drive.

SharpDevelop_3.2.0.5505_setup.msi will be saved in Local Drive (C:).

After you download it, .NET Framework is also needed in order your program to run. And that is .NET Framework 3.5 SP1 to be specific.

Follow these steps to have it:

1. Click LABEL 2 (refer to the first image above).

2. You will be transferred to this page:

3. Click Download

4. Microsoft download page will load upon doing step 3.

5. If the download does not start after 30 seconds, click the Start Download link.

Save dialog box will appear and asking you where to put it. After choosing the desired location, click save to download it.

6. And voila! You have it.

After you install all of these installers, (.NET Framework should be installed first before the SharpDevelop) you can start using it and develop your first program in whatever programming language you prefer. (either in vb, c# and others)

Hope this tutorial will be a help guys! Have a happy and enjoyable life. See you on my next post! ^^,

SharpDevelop: Open Source Visual Studio .NET

2010-03-18T18:08:00.001-07:00

Fot those who are looking for an alternative IDE for Microsoft Visual Studio .NET, something that costs less (actually free), and does not require a lot of hardware specification, this this article may be of help.

SharpDevelop is a free IDE that imitates the user interface of Microsoft Visual Studio. It contains a lot of features similar to Visual Studio such as the project explorer, drag-and-drop design view, resource manager, syntax highlighting... etc. It uses the free distributable .NET Framework for compiling source codes. (So it requires .NET Framework installed first)

SharpDevelop may not posses the same quality and features which may be found at Microsoft Visual Studio but this could also be a good option for starters especially in Visual Basic and C# Programming. Users who are already used to may not feel comfortable because of some features. However, projects in SharpDevelop may still be opened in MS Visual Studio.

SharpDevelop may be downloaded at
icsharpcode.net

Latest Version for Microsoft .NET Framework
.NET Framework Page

Using Continue

2009-11-17T07:40:00.000-08:00

In Programming languages such as C/C++, JAVA, PHP, Python.. etc the keyword continue is a jump statement like break and goto.
This is used to skip inside an iteration.
An example for this is the following for loop statement that prints all even numbers from 0 - 10.

for(int num = 0;num <= 10; num++){
if ((num % 2) > 0)
continue;
printf("%d ", num);
}

The code is written in C Language (actually it is more like an algotithm)
so even JAVA programmers can easily translate them.
Another example, for more sophisticated programming, continue may be also used for deleting entries in file manipulation.

Downloadable JAVA EBOOKS

2009-11-13T19:50:00.000-08:00

Free JAVA Lectures (Slideshow).exe Free Java Lectures

How to Program in JAVA.rar JAVA How to Program - the password in this ebook is itspot.
This is a fully featured book where you can learn Java. The best book I know in that programming language.

Thinking in JAVA
I have a copy of this book and I find it easy to understand because of the detailed explanation.

The JAVA turoial A short course on the basics.chm This book helped me a lot on projects in school

squidoo.com/itebooks

C Recommended Books

2009-10-21T07:38:00.000-07:00

Title:The C Programming Language ANSI C Version
Author:Kernighan & Ritchie
Publisher:Prentice Hall Software Series
ISBN:0-13-110362-8

Comment:Ideal reference book and goes well beyond the level of this course. It is expensive but the serious C programmer will kick themself if they don't buy this book.

Title:ANSI C - Made Easy
Author:Herbert Schildt
Publisher:Osborne McGraw-Hill
ISBN:0-07-881500-2
Comment:

Title:Learning to Program in C
Author:N. Kantaris
Publisher: Babani
ISBN:0-85934-203-4
Comment:A good cheap beginners guide.

Title:Illustrating ANSI C
Author:Donald Alcock
Publisher:Cambridge University Press
ISBN:0-521-42483-6
Comment:A good book for the mathematically inclined.

Title:C - The Complete Reference
Author:Herbert Schildt
Publisher:Osborne McGraw-Hill
ISBN:0-07-881263-1
Comment:

Title:Numerical Recipies in C
Author:W.H.Press, et al
Comment:An advanced level book with, as the name implies, ready-made solutions to your programming problems.

Turbo C - Free Download

2009-10-10T04:25:00.000-07:00

Light version of Borland Turbo C
Best for Starters

JAVA to Microsoft Access Connection

2009-10-05T01:30:00.000-07:00

(Using the JDBC-ODBC bridge)
A video tutorial is also available Click here to watch
ODBC can be used to connect on any databases though processing is slow... but it would still be very helpful, and that's what were gonna use to connect a JAVA Program to an MS Access Database.
We'll be using Northwind Database, a sample database made by Microsoft Corporation for learning purposes. A database of this is also available in SQL server 2000. Click on the link to download the mdb File:

NWIND.mdb

1. Configure the ODBC Settings
a. Go to Control Pane, then Choose Administrative Tools >> Datasources(ODBC)

b. In the ODBC Dialog box, choose the System DSN tab, then click the [Add] button.
c. A Dialog box appears, choose Microsoft Access Driver (*.mdb)

(Extension name Depends on what version of MS access you are using, in this article, we'll refer to Microsoft Access 2000)
Then choose [finish].

c. Another Dialog box will open. Fill up the Data Source name with the name you want. This will be used on Step # 2
(In this example, we will be naming this NWIND for the sample source code). Then on the Database Panel, click [Select] and browse for your database file.

d. Click the OK Button and you will see that your database has been added in the System Data Sources List.

2. The Source Code

Here's a sample code I got from the book, Thinking in JAVA by Bruce Eckel. I've modified some of its parts so that it will work on our sample database, Northwind.

//: c15:jdbc:JLookup.java
// Looks up email addresses in a
// local database using JDBC.
import java.sql.*;

public class JLookup
{
public static void main(String[] args)
throws ClassNotFoundException {
try{
String dbUrl = "jdbc:odbc:NWIND";
String user = "";
String password = "";

// Load the driver (registers itself)
Class.forName(
"sun.jdbc.odbc.JdbcOdbcDriver");
Connection c = DriverManager.getConnection(
dbUrl, user, password);
Statement s = c.createStatement();
// SQL code:
ResultSet r =
s.executeQuery(
"SELECT * " +
"FROM Products");

while(r.next()) {
// Capitalization doesn't matter:
System.out.println(
r.getString("ProductID") + " " +
r.getString("ProductName"));
}
s.close(); // Also closes ResultSet
}
catch(SQLException se)
{
System.err.println(se);
}
}
}

*From Thinking in JAVA, www.bruceeckel.com

Another code that makes use on the JOptionPane. Some parts of it are simplified (if you find the Objects and Indentations a fuss on the previous example)
By Mykell Dick Soria

import javax.swing.*;
import java.sql.*;
import java.io.*;
public class ConnectionTask
{

private JTextArea txtView;
private JScrollPane jsp;

public ConnectionTask(){
txtView = new JTextArea(20,30);
txtView.setEditable(false);
jsp = new JScrollPane(txtView);

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection jereme = DriverManager.getConnection("jdbc:odbc:NWIND","","");
Statement jer = jereme.createStatement();

jer.executeQuery("SELECT * FROM Customers");
ResultSet je = jer.getResultSet();

while(je.next())
{
txtView.append(je.getString(1) + "\n" + je.getString(2) + "\n" + je.getString(3) + "\n");
}
JOptionPane.showMessageDialog(null, jsp, "Database Products", JOptionPane.INFORMATION_MESSAGE);
}catch(Throwable exp){

JOptionPane.showMessageDialog(null,exp,"Error",JOptionPane.ERROR_MESSAGE);
System.err.println(exp);
}
}

public static void main(String[] args){
ConnectionTask app = new ConnectionTask();
}
}

Well, you'll know if you're doing right if your program displays the content you selected. The catch statement will display any errors about the connection

Exceptions Used In the Programs:
1. ClassNotFoundException
2 . SQLException
3. Throwable (if you've included this, you don't need to bother putting the first two)
4. IOException - though not in the example, according to Mr. Soria, it can also be substituted for SQLException.

enjoy! :D

Hello World!

2008-12-13T00:29:00.000-08:00

Welcome to the unofficial blog of Computer Society, the organization of Polytechnic University of Taguig that deals with computers and technology. Here, well be discussing very useful topics. Feel free to post your comments and suggestions on any posts in the blog. If you have any suggestions to be posted, just send them to
jeremejazz15@bsitpupt.com

We are also looking for bloggers who can join this site.
.
Please note that any information posted within this blog is not guaranteed to be correct. By reading this blog, you agree that any information you may choose to use is to be used at your own risk, and that you will not hold the writer responsible for any possible outcomes for your use of the information.