Java核心代码例程之：JDBC.java

发表日期：2008-1-5

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();
   }
}

上一篇：Java核心代码例程之：JNIExample.cpp 人气:583
下一篇：菜鸟初学Java的备忘录(十) 人气:562

浏览全部Java的内容 Dreamweaver插件下载网页广告代码祝你圣诞节快乐 2009年新年快乐