@sbuscribe U R SUCH A BLESSING!! Thank u for this thread, im a newbie to java and the programming entity generally, but your explanation is so detailed, thanks soo much.

@sbucareer oops!! i'm soo sorry i muddled up the identity (subsribe instead of sbucareer), thanks neeways

[size=24pt]
Creating Database with Java
[/size]

What is database
"The term or expression database originated within the computer industry. Although its meaning has been broadened by popular use, even to include non-electronic databases, this article takes a more technical perspective towards the topic. Database like records have been in existence since well before the industrial revolution in the form of ledgers, sales receipts and other business related collections of data. A possible definition is that a database is a structured collection of records or data which is stored in a computer so that a program can consult it to answer queries. The records retrieved in answer to queries become information that can be used to make decisions. The computer program used to manage and query a database is known as a database management system (DBMS). The properties and design of database systems are included in the study of information science." 1

The definition above is just too good. It says something about database being a structured collection of records or data which is stored in a computer so that a program can consult it to answer queries

When he said program I know you mind must have directed you to Java. Java provides some set of API's that actually allows you to interact with database. i.e. javax.sql.*

Database is made up of two lanaguages

1. DDL (Data Definition Language)
2. DML (Data Manipulation Language)

DDL, is used by database developer or engineers to design and build database while DML is used by administrator or programmer to query the database DDL.

These two languages takes different shape and forms depending on the database. But the DML was agreed by Database consortium to achive compactibilty to use SQL for DML. Even, many vendors still have their own version of SQL.

SQL is  sequential query language used by programmers or DBA (Database Administrator) to query the information stored in a database.

Because the engine that processes DML is incompactible with many language, Java came up with interface called JDBC (Java DataBase Connectivity) with many API's to interact with DML.

For this trail we are going to use Access database as a benchmark for newbies following the trail. If you have used database before, use can download and use MYSQL. although the content page said we are going to use MYSQL, it is up to you to let me know which one you want.

I am looking at the configuration issues, because in the past many people have shown difficulties with configuration. Microsoft operating systems comes with JDBC by default. We will use ODBC (Object Database Connectivity) with is microsoft API's for DML interface to bridge our JDBC to interact with Access database. You MUST have access database installed on you Pc to follow this.

If you want to use MYSQL, download and install the later version excluding any beta. Find MYSQL JDBC driver, download and install the driver at a prefered location and copy the driver (usually a jar file to) C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib and set the jar file to the CLASSPATH i.e

MYSQL_HOME=C:\mysq_connector4.1
PATH=;%MYSQL_HOME%\bin
CLASSPATH=C:\mysq_connector4.1\lib\jdbc.jar

These are just a guide, I really do not know their names and directories. I use Oracle. Oracle is difficult to install and configure. With a dialup connection it would probably take you 3days to download.

Have a go with MYSQL, if you have issues let me know.

@Sbucareer,
Good day, Pls I tried to correct the errors in the servlet, yet I have an error which I just cant seem to figure out, from my command prompt the error is on line 55. pls can you give me a lead. This is the code at that point. Sorry I am asking to be spoon fed. Never mind I will catch up in no time.


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.ServletResponse;
import javax.servlet.*;
import java.io.*;
import java.util.*;

public class interestRate extends HttpServlet{



private double loanAmount = 6400;
private double interestRate = 40.9; //Too expensive
private int numYears = 4;

public void doGet(
HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException{
response.setContentType("text/html";

PrintWriter out = response.getWriter();

out.println("<html>";
out.println("<head>";
out.println("<title>Loan calculation</title>";
out.println("</head>";
out.println("<body>";
out.println("<h2>Loan Calculation</h2>";

out.println("Loan Amount:";
out.println("<br/>";
out.println("Interest Rate:";
out.println("<br/>";

out.println("*****************************";
out.println("<br/>";
out.println("Number of years:";
out.println("<br/>";
out.println("Total interest:";
calculateInterest(loanAmount,interestRate,numYears);
out.println("<br/>";
out.println("******************************";
out.println("<br/>";
out.println("Monthly repayments:";
loanRepayments(loanAmount,interestRate,numYears);
out.println("<br/>";

//Change the value of years
numYears++;

out.println("*****************************";
out.println("<br/>";
out.println("Number of years:";
out.println("<br/>";
out.println("Total interest:";

double calculateInterest(double loanAmount,double interestRate,int numYears){
return numYears * interestRate * loanAmount / 100;

out.println("<br/>";

out.println("******************************";
out.println("<br/>";
out.println("Monthly repayments:";

String loanRepayments(double loanAmount,
double interestRate,
int numYears){
perc2 = new DecimalFormat("$#,##0.00;{$#,##0.00}";
return perc2.format(( calculateInterest(loanAmount,interestRate,numYears) + loan ) / (numYears *12));
out.println("</body>";
out.println("</html>";


}//End doGet

public void doPost(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException{
doGet(request, response);
}//End doPost

}//End Process
}
}


Good bless Sbucareer!

Excellent tutorial! Keep up the good work sbucareer.

I just want to mention that, if you are referencing any javabean objects from your JSP, tomcat 5.0 and above requires that thay be in a package. If not the JSP compiler will not be able to find them.

Good day,
Pls I tried running this file from my netbeans, and encountered the following problems
It had errors on lines 45
<td><b><jsp:getProperty name="pizza" property="hawaiia" v/></b></td></tr>
on correcting this line, another error came up on line 28
<td><b> <jsp:getProperty name="pizza" property="purchaseType" value="0"/> </b></td></tr>
The compiler was complaining that the getProperty has invalid attribute: value
After all attempts the I could only get the green light when I removed the value attribute entirely from lines 28 and 32
Yet on attempting to run the file it failed giving me this error
init:
deps-module-jar:
deps-ear-jar:
deps-jar:
library-inclusion-in-archive:
library-inclusion-in-manifest:
compile:
compile-jsps:
org.apache.jasper.JasperException: The value for the useBean class attribute com.nairaland.beans.Pizza is invalid.
C:/J2EEProjects/sbucareer/build/web/pizzas.jsp(10,3)
C:\J2EEProjects\sbucareer\nbproject\build-impl.xml:353: Java returned: 1
BUILD FAILED (total time: 3 seconds)

Funny enough attempting to compile and run my file from the command prompt via Textpad, my file ran displaying this image in my dreamweaver viewer and my internet Explorer



Over to you sir, Pls what is it that I am not doing right?

@Sbucareer,
Sorry you havent heard from me 'cos I have being really sick, so I will resume classes next week. thanx

@sbucareer
let's face it u've been a real source of help 2 people like me. keep it up man. av been 4llowing u8r tutorial on jsp, i tried to install netbeans 5.0 which has a bundled apache tomcat server inside and i couldn't get through with configuring the server properties i choose port 8084 cos i already have IIs runnin on port 80. the tomcat server keeps requesting for password for manager role which i don't know. plz help me out. 10x

Did you try blank? I think that's the default. Under tomcatDir/conf/tomcat-user.xml what password do you have associated with the manager role? Exactly what are you trying to doi that it keeps asking for the admin PW?

teeewai:

the tomcat server keeps requesting for password for manager role which i don't know. plz help me out. 10x

@SBUCAREER,
good day My dear LECTURER! so sorry I didnt mean to discourage you, I feel really ill, I had though that I will be back in class this week but some how, I had to travel to accra with my sweetheart so pls I will be back in class in another 10days. I really appreciate you. you r such a blessing, meanwhile I have seen my mistake from the line of code you sent, unfortunately I am not equiped to run codes here, i really miss running codes though. thanx so very much for your understanding.