package appsample;

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



public class Mondai {

    public static void main(String[] args)
    	throws Exception {

        Connection con = DBManager.getConnection();
        String sql=
        "INSERT INTO ACCOUNT(ID, NAME, MONEY) " +
        "VALUES(?, ?, ?)";

        PreparedStatement smt =
        	con.prepareStatement(sql);
        //？に値をset
        smt.setInt(1, 20);
        smt.setString(2, "マーシャ");
        smt.setInt(3, 2000);

        //smt.executeUpdate("DELETE FROM ACCOUNT WHERE ID=4");
        int count = smt.executeUpdate();

        System.out.println("update count : " + count);

        sql="SELECT * FROM ACCOUNT WHERE ID=?";
        //事前にコンパイルするので
        //前もってSQLをセットする
        PreparedStatement smt2 
        = con.prepareStatement(sql);

        //値のset
        smt2.setInt(1, 4);
        ResultSet rs = 
        	smt2.executeQuery();

        if(rs.next()){
			System.out.println(
					"ID=" + rs.getInt("ID")
					+ ",TITLE=" + rs.getString("NAME")
					+ ",PRICE=" + rs.getInt("MONEY")
				);
        }else{
        	System.out.println("該当なし");
        }
        //finallyでclose()すべき
        smt.close();
        con.close();
    }
}