querycoffees.java

来自「一个简单的连接数据库的小程序,适合新手学习JAVA用」· Java 代码 · 共 33 行

import java.sql.*;

public class QueryCoffees {
	public static void main(String args[]) {
		String url = "jdbc:odbc:MyDB";
		Connection con;
		String query = "SELECT COF_NAME,PRICE FROM COFFEES";
		Statement stmt;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		} catch (java.lang.ClassNotFoundException e) {
			System.err.print("ClassNotFoundException:");
			System.err.println(e.getMessage());
		}
		try {
			con = DriverManager.getConnection(url);
			stmt = con.createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while (rs.next()) {
				String s = rs.getString("COF_NAME");
				float n = rs.getFloat("PRICE");
				System.out.println(s + "  " + n);
			}
			stmt.close();
			con.close();
		} catch (SQLException ex) {
			System.err.println("SQLException:" + ex.getMessage());
		}
	}
}