import java.net.URL;
import java.sql.*;

public class MysqlConnection
{

    public static void main (String args [])
        throws SQLException
        {
            String url = "jdbc:mysql://mysql.cise.ufl.edu/mydb";
            Connection db;
            Statement st;
            String ins_query = "insert into foo values (10)";
            String out_query = "select bar from foo";
            String user = "myuser";
            String passwd = "mypass";

            try {
                System.err.println ( "Loading driver ..." );
                Class.forName ("com.mysql.jdbc.Driver");
            } catch (java.lang.ClassNotFoundException e) {
                System.err.print ("ClassNotFoundException:");
                System.err.println (e.getMessage());
            }

            try {
                System.err.println ( "Connecting ..." );
                db = DriverManager.getConnection (url, user, passwd);
                System.err.println ( "Preparing statement ..." );
                st = db.createStatement ();
                System.err.println ( "Executing query ..." );
                st.execute (ins_query);
                ResultSet rs = st.executeQuery (out_query);
                while (rs.next()) {
                    System.out.println(rs.getString(1));
                }
                st.close ();
                db.close ();
            } catch (SQLException ex) {
                System.err.println ( "SQLState:" + ex.getSQLState() );
                System.err.println ( "Message:" + ex.getMessage() );
                System.err.println ( "Vendor:" + ex.getErrorCode() );
            }
        }
}