Thread: Fundamental steps to create a database program in java

Hi,
I am new to java programming.And i want to create a database named vehicle info. I need to program it in Android eclipse .
The requirements are 1.I should do program code to create a database named vehicle info.Then i should get the details from the MySQl databse, store new informations etc...
Which all software i should install in my system
I have Android SDK , i have to do in eclipse.
i dont have any other software installed in my system related to this as i dont know what all thigs i need ..and i dont know the procedures to setup.
can anyone help me to create databse.
then do the connection
and veiw ,update ,delete operations..

Which all software i should install in my system
I have Android SDK , i have to do in eclipse.

If you google for "Android SDK" you'll find it at once, and it contains Eclipse already setup, so that installing the whole thing is as easy as lying.

can anyone help me to create databse.
then do the connection
and veiw ,update ,delete operations..

You'd better compose yourself and write it yourself if you need it. The program is not complicated (you can use SQLite in Android) and with Android tutorials (at the same site) it will not be hard. However it will really take some time so I doubt anyone is interested to do this stuff for you (at least without good payment).

Android SDK | Android Developers

Getting Started | Android Developers

I have already installed eclipse.But for my application i need to create a database called vehicleinfo .It is with MySQL . I installed mysql and the mysql driver also.
Now i just want to know how can i create a database with all these utilites and to connect my eclipse with the created database.
Thanks for help!!!!!!

Hi, Thanks for your answer.
Now i created a database .After creating MySQL database from MySQL I move to eclipse.I choose Data development perspective . I choose new Database connections in data source explorer.Then next choose MySQL as database next give database name which i created next select jdbc driver which is locsted in MySQL directory , the jar file ...next give name ,user and password details.. then i tried for test connection and i am getting error as
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorEx ception: Unknown database 'database'
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInsta nce(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newI nstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:41 1)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1054)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4190)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4122)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:927)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggab leAuthentication(MysqlIO.java:1709)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 52)
What might be the issue with my connection or with something else ?
Thanks !!!!!

Originally Posted by Sharonswaroop

What might be the issue with my connection or with something else ?

Looks like you specified wrong database name in your connection url or properties.

i created database in mysql , the name is vehicleinfo .So i just give that name in the eclipse .Also i provided the path for jdbc driver .
But the ping is got failed. Is there any suggestions ?

i created a database called vehicleinfo in MySQL and the table name details

i can paste my program code below in my eclipse .

import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
public class DisplayAuthors
{
//database URL
static final String DATABASE_URL= "jdbc:mysql://localhost/vehiclinfo";

//launch application
public static void main(String args[])
{
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
try
{
connection = DriverManager.getConnection(DATABASE_URL,"root","r oot");
statement = connection.createStatement();
resultSet = statement.executeQuery("SELECT ID,LicenseNumber,Model,Yearofreg FROM details");
ResultSetMetaData metaData = resultSet.getMetaData();
int numberOfColumns = metaData.getColumnCount();
System.out.println("details Table of vehicleinfo Database:\n");
for (int i = 1;i <= numberOfColumns; i++ )
System.out.printf("%-8s\t",metaData.getColumnName(i));
System.out.println();
while (resultSet.next())
{
for(int i = 1;i<= numberOfColumns; i++)
System.out.printf("%8s\t",resultSet.getObject(i));
System.out.println();
}
}
catch(SQLException sqlException)
{
sqlException.printStackTrace();
}
finally
{
try
{
resultSet.close();
statement.close();
connection.close();
}
catch (Exception exception)
{
exception.printStackTrace();
}
}

}
}


Then i create a new database connection drom Database development perspective ....as below :
Data connections --->new -->select MySQL-->name vehicleinfo --> set path for jdbc driver --> give username and password of databse ---> Test connection
Then i got ping failed error

.

Please help me to resolve the issue

Hi...
Now it is ping message came.
But when i run as java application the error is coming as driver not found.
Can anybody suggest how to define program's classpath,
Where we should define program's class path like as below
java -classpath
.;C:\Program Files (x86)\MySQL\Connector J 5.1.26\mysql-connector-java-5.1.26-bin.jar classname ?

thanks !!!!!

Here are the results of searches you could have done yourself. Don't be helpless:

Oracle: How to set the classpath.

Javarevisited: Setting the classpath.