correct sql statements in using java netbeans

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Paul NIcolai Sunga
    New Member
    • Mar 2008
    • 43

    correct sql statements in using java netbeans

    i have a project in my java programming and database class we are bound to connect the database and the java netbeans programming language its just that i am so confused about the statements cause the output of my program is very wrong could you help me ?.

    Could i ask if this codes are correct?

    s.execute("CREA TE table Membership1 ( column_name integer )");
    s.execute("INSE RT INTO Membership1(Las t Name, Age) values (Garcia, 13)");
    s.execute("SELE CT 'Age' from Membership1");
    s.execute("UPDA TE Membership1 set field no. = value where (condition)");
    s.execute("DELE TE from Membership1 where(condition )");

    and could you add some sql statements for me to know those statements that ive never known..thank you..
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Sql syntax is Ok . You need to check for the method to execute those with frontend you are using.

    Comment

    • Paul NIcolai Sunga
      New Member
      • Mar 2008
      • 43

      #3
      Originally posted by debasisdas
      Sql syntax is Ok . You need to check for the method to execute those with frontend you are using.
      ah ok i will it again..thanks for the help.i really appreciated it!@!!

      Comment

      Working...