import java.sql.*;

public class JdbcConnection {

    public static void main(String args[]) {

        Connection con = null;

        String url = "jdbc:mysql://vikingsec1.db.5837770.hostedresource.com";
        String db = "vikingsec1";
        String driver = "com.mysql.jdbc.Driver";
        String user = "vikingsec1";
        String pass = "BisBeta1963";

        try {
            Class.forName(driver);

            con = DriverManager.getConnection(url + "/" + db, user, pass);
            System.out.println("test2");
            System.out.println("jdbc driver for mysql : " + driver);
            System.out.println("test3");

            System.out.println("Connection url : " + url + db);
            System.out.println("Connection is created...");

            // declare object of Statement interface that uses for executing sql statements.
            Statement statement = null;

            // declare a resultset that uses as a table for output data from the table.
            ResultSet rs = null;
            int updateQuery = 0;

            /* createStatement() is used for create
            statement object that is used for sending sql
            statements to the specified database. */
            statement = con.createStatement();

            // sql query of string type to create a data base.
            //String QueryString = "CREATE TABLE values(temp INTEGER , trip INTEGER)";
            //updateQuery = statement.executeUpdate(QueryString);


            // sql query to insert values in the specified table.
            String query = "UPDATE 'values' SET 'temp'=1 WHERE 'temp'=0 AND 'trip'=0 LIMIT 1";
            updateQuery = statement.executeUpdate(query);

            if (updateQuery != 0) {
                System.out.println("table is created successfully and " + updateQuery + " row is inserted.");
            }


            con.close();
            System.out.println("Connection is closed...");
        } catch (Exception e) {
        	e.printStackTrace();
            System.out.println(e);
        }
    }
}