/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package tcf;
import java.sql.*;
/**
 *
 * @author ScottJR
 */
public class Tcf {
    private static final String USERNAME="root";
    private static final String PASSWORD="scooter";
    private static final String CONN_STRING=
            "jdbc:mysql://localhost/Coach_info";
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {

    Connection conn = null;

    try {
        conn = DriverManager.getConnection(CONN_STRING,USERNAME,PASSWORD);
        System.out.println("Connected!!");
        Statement stmt = (Statement) conn.createStatement();
        String Fname= "Shawn";
        String Lname= "Scott";
         String insert= "INSERT INTO basic_info(Fname, Lname, Location, Email, phone#)" +
        "VALUES (?, ?, ?, ?, ?)";
        PreparedStatement preparedStatement = conn.prepareStatement(insert);
        preparedStatement.setString(1, "Steven");
        preparedStatement.setString(2, "Spidey Scott");

        preparedStatement.executeUpdate();
    }catch(SQLException e){
        System.err.println(e);
    }

    }

}