Java中的JDBC實例

小鳳尾

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

xiaozhen

大哥的,弄點兒有水平的,小兒科的東西拿得出手嗎?