Thanks Dav for reply, lets see if I can make the question more specific:
take the code below for example:
import java.sql.*;
public class SelectFromPer {
public static void main(
String argv[]) {
try {
// Load the JDBC-ODBC bridge
Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
// specify the ODBC data source's URL
String url = "jdbc
dbc:SSPer";
// connect
Connection con = DriverManager.getConnection(url,"North","Ken");
// create and execute a SELECT
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery
("SELECT Surname,FirstName,Category FROM Per");
System.out.println("Class is SelectFromPer\n");
// traverse through results
System.out.println("Found row:");
while (rs.next()) {
// get current row values
String Surname = rs.getString(1);
String FirstName = rs.getString(2);
int Category = rs.getInt(3);
// print values
System.out.print (" Surname=" + Surname);
System.out.print (" FirstName=" + FirstName);
System.out.print (" Category=" + Category);
System.out.print(" \n");
}
// close statement and connection
stmt.close();
con.close();
} catch (java.lang.Exception ex) {
ex.printStackTrace();
}
}
}
Questions:
String url = "jdbc
dbc:SSPer";
does this mean, i'm using a file named SSPer? SSPer.sql?
("SELECT Surname,FirstName,Category FROM Per");
Surname, FirstName are column's of a sql file? how do I know what column's are in a sql file?
I guess where I'm stuck now, is that I need a sql file with known username and password and known column names. In case, how to create such a file is out of the scope, is there any way to get a file where I know all those?
or something is wrong with my understanding?
