presidents.java

来自「21天学通JAVA2（第三版）（专业参考版）」· Java 代码 · 共 26 行

import java.sql.*;

public class Presidents {
    public static void main(String[] arguments) {
        String data = "jdbc:JDataConnect://127.0.0.1/Presidents";
        try {
            Class.forName("JData2_0.sql.$Driver");
            Connection conn = DriverManager.getConnection(
                data, "", "");
            Statement st = conn.createStatement();
            ResultSet rec = st.executeQuery(
                "SELECT * FROM Contacts ORDER BY NAME");
            while(rec.next()) {
                System.out.println(rec.getString("NAME") +  "\n"
                    + rec.getString("ADDRESS1") + "\n"
                    + rec.getString("ADDRESS2") + "\n"
                    + rec.getString("PHONE") + "\n"
                    + rec.getString("E-MAIL") + "\n");
            }
            st.close();
        } catch (Exception e) {
            System.out.println("Error -- " + e.toString());
        }
    }
}