import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Students {

    public static void main(String[] args) {
        Connection con = null;
        Statement stmt = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/studentdb";
            con = DriverManager.getConnection(url, "root", "12345");
            stmt = con.createStatement();

            // insert data to studentdb
            int result = stmt.executeUpdate("insert into student(student_name, age) values('papat',40)");
            result += stmt.executeUpdate("insert into student(student_name, age) values('wannida', 30)");
            result += stmt.executeUpdate("insert into student(student_name, age) values('wandee', 45)");
            System.out.println("Inserted " + result + " row success");
            //Query data
            ResultSet rs = stmt.executeQuery("select * from student order by idstudent");
            while (rs.next()) {
                int id = rs.getInt("idstudent");
                String name = rs.getString("student_name");
                int age = rs.getInt("age");
                System.out.println("ID : " + id + " Name : " + name + " Age :" + age);
            }
            rs.close();
        } catch (ClassNotFoundException ex1) {
            ex1.printStackTrace();
        } catch (SQLException ex2) {
            ex2.printStackTrace();
        } catch (Exception ex3) {
            ex3.printStackTrace();
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (SQLException err) {
                err.printStackTrace();
            }
        }

    }
}