//dbjava
import java.sql.*;

public class MyJDBC {

    private static final String MYURL = "jdbc:mysql://localhost/army";
    private static final String USERNAME = "root";
    private static final String PASSWORD = "";

    public static void main(String[] args) {
        Connection con = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection(MYURL, USERNAME, PASSWORD);
            if (con != null) {
                System.out.println("Successfully connect");
            } else {
                System.out.println("Connection fail!");
            }
            Statement stmt = con.createStatement();

            String army = "INSERT INTO mytable_5730213093  VALUES (6,'David')";
            stmt.executeUpdate( army);
            army = "INSERT INTO mytable_5730213093  VALUES (7,'Jacob')";
            stmt.executeUpdate( army);
            army = "INSERT INTO mytable_5730213093  VALUES (8,'Nick')";
            stmt.executeUpdate( army);
           army= "INSERT INTO mytable_5730213093  VALUES (9,'Ronald')";
            stmt.executeUpdate( army);

            PreparedStatement Statement = con.prepareStatement("UPDATE mytable_5730213093 SET NAME = 'Donna' WHERE ID = 1");
            PreparedStatement Statement2 = con.prepareStatement("UPDATE mytable_5730213093 SET NAME = 'Xio' WHERE ID = 2");
            Statement.executeUpdate();
            Statement2.executeUpdate();


            ResultSet rs = stmt.executeQuery("SELECT * FROM mytable_5730213093 ");
            while (rs.next()) {
                int num = rs.getInt("ID");
                String name = (String) rs.getString("NAME");
                System.out.println(num + ":" + name);

            }

        } catch (Exception e) {
            e.printStackTrace();
        } finally {
        }
    }
}