스테이트먼트

1 개요[ | ]

Statement
스테이트먼트

2 예시: Java (JDBC)[ | ]

sql
Copy
Statement stmt = null;
String query = "select COF_NAME, SUP_ID, PRICE, " +
	   "SALES, TOTAL " +
	   "from " + dbName + ".COFFEES";
try {
	stmt = con.createStatement();
	ResultSet rs = stmt.executeQuery(query);
	while (rs.next()) {
		String coffeeName = rs.getString("COF_NAME");
		int supplierID = rs.getInt("SUP_ID");
		float price = rs.getFloat("PRICE");
		int sales = rs.getInt("SALES");
		int total = rs.getInt("TOTAL");
		System.out.println(coffeeName + "\t" + supplierID +
		"\t" + price + "\t" + sales +
		"\t" + total);
	}
} catch (SQLException e ) {
	JDBCTutorialUtilities.printSQLException(e);
} finally {
	if (stmt != null) { stmt.close(); }
}

3 같이 보기[ | ]