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

2019-11-18 15:14:37

字体：大中小

来源：转载

供稿：网友

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的备忘录(十)

下一篇：Java核心代码例程之：JNIExample.cpp