| |
import java.sql.*;
/**
* simple demo of how to perform a sql query using jdbc.
**/
public class jdbc
{
public static void main(string args[]) throws exception
{
class.forname("sun.jdbc.odbc.jdbcodbcdriver");
connection conn = drivermanager.getconnection("jdbc:odbc:empprjdb", "admin", "letmein");
statement stmt = conn.createstatement();
resultset rslt = stmt.executequery("select name, city from employee");
while (rslt.next())
{
system.out.println("hello world from "
+ rslt.getstring(1) // you can use getstring(columnnumber)
+ " in "
+ rslt.getstring("city")); // or, you can use getstring(columnname)
}
rslt.close();
stmt.close();
conn.close();
}
}
|
|
