Database tutorial requests?

  • (3 Pages)
  • +
  • 1
  • 2
  • 3

32 Replies - 26229 Views - Last Post: 06 May 2013 - 04:45 PM Rate Topic: -----

#31 Jud202  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 53
  • Joined: 02-March 09

Re: Database tutorial requests?

Posted 09 November 2010 - 10:14 AM

I would like to see a tutorial for creating a Gui database. I suppose you could make, though I'm not really familiar with actually doing it, a java program to use a MySQL database and then you could make a gui over that java, but I was hoping for an actual Gui over the mysql database?
Was This Post Helpful? 0
  • +
  • -

#32 seamaster11031  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 27-September 11

Re: Database tutorial requests?

Posted 27 September 2011 - 09:40 PM

how can i SELECT SUM SQL commands?

im creating a coin table with coins names and values, and i need to use CREATE TABLE, INSERT and SELECT SUM SQL commands. now my problem is the damn SQL and how to use SQL.
package coins;

/**
*
* @author Samwize
*/
import java.util.Scanner;

public class Coins {

static String coins[] = {"pennies", "nickels", "dimes", "quarters",
"half-dollars", "dollars"};
static int values[] = {1, 5, 10, 25, 50, 100};

public static void main(String[] args) {
Scanner in = new Scanner(System.in);// standard input from console
int amount = 0; // entered value of coins

for (int i = 0; i < coins.length; i++) {
System.out.print("Please enter number of " + coins[i] + ":");
amount += values[i] * in.nextInt();
}

System.out.println("The total sum of change you entered is: " + amount
+ " cents.");
}
}

Was This Post Helpful? 0
  • +
  • -

#33 RandomlyKnighted  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 115
  • View blog
  • Posts: 1,356
  • Joined: 14-January 10

Re: Database tutorial requests?

Posted 06 May 2013 - 04:45 PM

I would really like to see a tutorial on complex joins such as having 2 or more inner joins in the same query. I'm having a hard time understanding them when I read them.
Was This Post Helpful? 0
  • +
  • -

  • (3 Pages)
  • +
  • 1
  • 2
  • 3