package lab13;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;

import Lib.Sql;

public class Coin {

	/**
	 * @param args
	 * @throws Exception
	 */
	public static void main(String[] args) throws Exception {
		Connection con = Sql.connectSql(Sql.loadSqlConn("database.properties"));
		Statement st = con.createStatement();

		st.execute("CREATE TABLE Coin (name CHAR(20), amount FLOAT);");
		st.execute("INSERT INTO Coin VALUES ('penny', '0.01');");
		st.execute("INSERT INTO Coin VALUES ('nickel', 0.05);");
		st.execute("INSERT INTO Coin VALUES ('dime', 0.10);");
		st.execute("INSERT INTO Coin VALUES ('quarter', 0.25);");
		st.execute("INSERT INTO Coin VALUES ('half dollar', 0.50);");
		st.execute("INSERT INTO Coin VALUES ('dollar', 1.00);");

		ResultSet result = st.executeQuery("SELECT * FROM Coin");
		float sum = 0;
		while(result.next()){
			sum +=  result.getFloat("amount");
			System.out.println(result.getString("name") + " " + result.getString("amount"));
		}
		System.out.println("java : somme " + sum);

		result = st.executeQuery("SELECT sum(amount) as 'somme' FROM Coin");
		result.next();
		System.out.println("sql : somme " + result.getFloat("somme"));

		st.execute("DROP TABLE Coin");

		con.close();
	}

}