database conetivity

[rehan4uusmalik]

it is my fisrt java program that have one error plz correct this




import java.sql.*;
import java.io.*;
public class database
{
public static void main(String arg[]}
{

String url;
String userID = "jim";
String password = "keogh";
Connection Db;
Statement DataRequest;

ResultSet Results;
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver");
db = DriverManager.getConnection("jdbc:odbc:db1","","") ;
}
catch(Exception e)
{
}

try
{
String query = "SELECT * FROM table1";
//DataRequest = Database.createStatement();
DataRequest = Db.createStatement();
Results = DataRequest.executeQuery (query);

}
catch(Exception ae)
{
System.out.println(" exception of request");
}

/*
String FirstName;
String LastName;
String printrow;
boolean Records = Results.next();
if (!Records )
{
System.out.println( "No data returned");
return;
}
else
{
do
{
FirstName = Results.getString (name) ;
LastName = Results.getString (password) ;
printrow = " " + LastName;
System.out.println(printrow);
}
while ( Results.next() );
}
*/

DataRequest.close();
Db.close();
}

}

[JosAH]

it is my fisrt java program that have one error plz correct this

What do you want us to do? Guess what the error is?

kind regards,

Jos

[rehan4uusmalik]

find the error and correct it

[Norm]

@JosAH - this is a test. If you can pass this one, the OP will award you a prize.
If you fail, you'll have to go back to the beginning.
You have 30 seconds. On your mark, get set. GOOOOOOOOOOOO!

[JosAH]

@JosAH - this is a test. If you can pass this one, the OP will award you a prize.
If you fail, you'll have to go back to the beginning.
You have 30 seconds. On your mark, get set. GOOOOOOOOOOOO!

Oh dear, and now the OP is even giving me orders "find the error and correct it". I can't even read that code, I don't stand a chance ... I wonder how much he is paying ...

kind regards,

Jos ;-)

[ujjal.ruet]

/////

import java.sql.*;
import java.io.*;

public class data{

public static void main(String arg[])
{

String url = "jdbc:mysql://localhost/cse300";
String userID = "root";
String password = "123456";
Connection db=null;
Statement DataRequest=null;

ResultSet Results=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
db = DriverManager.getConnection(url,userID,password) ;
}
catch(Exception e)
{
}

try
{

String query = "SELECT * FROM articlee";
//DataRequest = Database.createStatement();
DataRequest = db.createStatement();
Results = DataRequest.executeQuery (query);

}
catch(Exception ae)
{
System.out.println(" exception of request");
}

/*
String FirstName;
String LastName;
String printrow;
boolean Records = Results.next();
if (!Records )
{
System.out.println( "No data returned");
return;
}
else
{
do
{
FirstName = Results.getString (name) ;
LastName = Results.getString (password) ;
printrow = " " + LastName;
System.out.println(printrow);
}
while ( Results.next() );
}
*/
String s;
try{
if(Results.next()){

s=Results.getString(1);
System.out.println(s);
}
}
catch (SQLException ex) {
ex.printStackTrace();
// System.out.println(query);

}
/*DataRequest.close();
db.close();
*/}

}