|
import java.sql.*;
public class JDBC
{
public static void main(String args[]) throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbcdbc: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();
}
}
此程序只要记住Connection,Statement ,ResultSet 三个类就很容易掌握了!!!
转帖自:http://www.hljcre.com/dispbbs.asp?boardID=15&ID=1916 |
|