|
Hi,
Yes, you have to create DSN
people
and try to execute the class using
java in command prompt (dont forget to include your class in class
path).
Best regards,
ngurah j.
----- Original Message -----
Sent: May 31, 2002 1:42 AM
Subject: ODBC
Hello,
I hope someone can help me with this simple
problem. I have some code below.
***
import java.sql.*;
public class lookup {
public static void main(String[] args)
{
String dbUrl =
"jdbc:odbc:people";
String user =
"";
String password = "";
try
{
// 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 FIRST, LAST, EMAIL "
+
"FROM names people
" ! +
"WHERE "
+
"(LAST='" +
args[0] + "') " +
"
AND (EMAIL Is Not Null) "
+
"ORDER BY
FIRST");
while(r.next())
{
// Capitalization doesn't
matter:
System.out.println(
r.getString("Last") + ",
"
+
r.getString("fIRST")
+ ": " + r.getString("EMAIL") );
}
s.close(); // Also closes
ResultSet
} catch(Exception e)
{
e.printStackTrace();
&!
nbsp; }
}
}
***
I am running "j2sdk1.4.0" with the web server JSWDK WebServer Version
1.0.1
The question is how do I execute this class having already
compiled the java code, created a DSN and created a TABLE with data?
Do I have to run this servlet from a web page?
Al
Get your FREE download of MSN Explorer at http://explorer.msn.com.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of
the message "signoff SERVLET-INTEREST". Archives:
http://archives.java.sun.com/archives/servlet-interest.html Resources:
http://java.sun.com/products/servlet/external-resources.html LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
|
