Java + MS Access SQL

private void addRecipe()
{
Scanner keyboard = new Scanner(System.in);
System.out.print("Recipe name: ");
String name = keyboard.next();
System.out.print("Ingredients: ");
String ingredients = keyboard.next();
String sql = "INSERT INTO RECIPESTABLE(RECIPENAME, INGREDIENTS)" +
"VALUES('name','ingredients')";
System.out.println("\nAdding a recipe : ");

try
{
Statement statement = con.createStatement();
int result = statement.executeUpdate(sql);
System.out.println(" Added " + result + " recipe(s).");
}
catch (Exception ex)
{
System.out.println("Error adding a recipe!");
System.out.println(ex);
}
}

String sql = "INSERT INTO RECIPESTABLE(RECIPENAME, INGREDIENTS)" +
"VALUES('"+name+"','"+ingredients+"')";

ZiN (2) skrev:

Bemærk at du bør påføre noget check om name og ingredients er strings. :-)

import java.util.Scanner;

private void addRecipe()
{
Scanner keyboard = new Scanner(System.in);
System.out.print("Recipe name: ");
String name = keyboard.nextLine();

String lineInput = "";
StringBuilder sb = new StringBuilder();

String ingredientString;

int ingrCnt = 1;
while(true)
{
System.out.print("Ingredient " + ingrCnt + ": ");
lineInput = keyboard.nextLine();
if(lineInput.equals("."))
{
ingredientString = sb.toString().substring(0, sb.toString().length()-1);
break;
}
sb.append(lineInput + ",");
ingrCnt++;
}




String sql = "INSERT INTO RECIPESTABLE(RECIPENAME, INGREDIENTS) " +
"VALUES ('" + name + "', '" + ingredientString + "')";
System.out.println("\nAdding a recipe : ");

System.out.println(sql);

try
{
Statement statement = con.createStatement();
int result = statement.executeUpdate(sql);

System.out.println(" Added " + result + " recipe(s).");
}
catch (Exception ex)
{
System.out.println("Error adding a recipe!");
System.out.println(ex);
}
}

StringBuilder sb = new StringBuilder();

ZiN (2) skrev:

String sql = "INSERT INTO RECIPESTABLE(RECIPENAME, INGREDIENTS)" +
"VALUES('"+name+"','"+ingredients+"')";

Bemærk at du bør påføre noget check om name og ingredients er strings. :-)

squad2nd (19) skrev:

Læs hans primære spørgsmål. Gerne to gange.