import java.sql.*;

public class DBconnect {

    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBconnect() {
        try {
            Class.forName("com.mysql.jdbc.Driver");

            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
            st = con.createStatement();

        } catch(Exception ex) {
            System.out.println("Error: " + ex);
        }
    }
   /*

    String query2 = "insert into persons VALUES(8,'sami'4585')";
          int result = st.executeUpdate(query2);
    */
    public void setData() {
         try {
            String query2 = "insert into persons VALUES('8','sami','4585')";
          int result = st.executeUpdate(query2);

        } catch(Exception ex) {
            System.out.println("Error: " + ex);
        }
    }


    public void getData() {
        try {
             String query = "select * from persons";
             rs = st.executeQuery(query);
             System.out.println("Records from database");
             while(rs.next()){
                 String name = rs.getString("name");
                 String age = rs.getString("age");
                 System.out.println("Name: "+name+"  "+"age: "+age);

             }

        }catch (Exception ex){
            System.out.println(ex);
        }

    }
}