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

/**
 * Created by andredsnogueira on 03/07/16.
 */

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/dbintellij","andre","");
            st = con.createStatement();
        }catch (Exception e){
            System.out.println(e + " connect");
        }
    }

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


        }catch (Exception e){
            System.out.println(e + " get");
        }
    }

    public void insertData(){
        try{
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbintellij","andre","");
            st = con.createStatement();
            String sql= "insert into persons"+ " (id, name, age)" + " values(5, 'Kiko', '20')";
            st.executeLargeUpdate(sql);
            System.out.println("Inserted");
        }catch (Exception e){
            System.out.println(e + " insert");
        }
    }


}