SQL MULTIPLE TABLE

Question

Below is an example of inserting values into one table(MemberRecord)

//CreateUser method

        public boolean createUser(){
            boolean success = false;
            DBController db = new DBController();
            db.getConnection();
            String sql = "INSERT INTO MemberRecord(id, name, email, contactNo, password, gender, nationality, dateOfBirth, address, postalCode, secQues, secAns, userType)";
            sql += "VALUES('" + id + "','" + name + "','" + email + "','" + cNo + "','" + pwd + "','" +gen + "','" + nationality + "','" + dob + "','" + address + "','" + pCode + "','" + secQuestion +"','"+secAnswer +userType + "')";


            if (db.updateRequest(sql)==1) success = true;
            db.terminate();
            return success;

        }

How to insert values into 2 tables? When I tried the code below, I got duplicate variables. Even when I change the variables name, it still gives me errors.

//CreateUser method
        public boolean createUser(){
            boolean success = false;
            DBController db = new DBController();
            db.getConnection();
            String sql = "INSERT INTO MemberRecord(id, name, email, contactNo, password, gender, nationality, dateOfBirth, address, postalCode, secQues, secAns, userType)";
            sql += "VALUES('" + id + "','" + name + "','" + email + "','" + cNo + "','" + pwd + "','" +gen + "','" + nationality + "','" + dob + "','" + address + "','" + pCode + "','" + secQuestion +"','"+secAnswer +userType + "')";

            String sql = "INSERT INTO PaymentDetails(creditCardNo,creditCardType,expiryDate,CVV)";
            sql += "VALUES('" + cCardNo + "','" + cCardType + "','" + expiryDate + "','" + cvv + "')";

            if (db.updateRequest(sql)==1) success = true;
            db.terminate();
            return success;

        }

Check out [Here](http://stackoverflow.com/questions/11964982/java-mysql-insert-into-multiple-tables-using-preparedstatement). This May Help you. — Romesh, Jun 20 '13 at 04:41

score 1 · Answer 1 · answered Jun 20 '13 at 03:59

Try this:

String sql = "INSERT INTO MemberRecord(id, name, email, contactNo, password, gender, nationality, dateOfBirth, address, postalCode, secQues, secAns, userType)";
sql += "VALUES('" + id + "','" + name + "','" + email + "','" + cNo + "','" + pwd + "','" +gen + "','" + nationality + "','" + dob + "','" + address + "','" + pCode + "','" + secQuestion +"','"+secAnswer +userType + "');";

sql += "INSERT INTO PaymentDetails(creditCardNo,creditCardType,expiryDate,CVV)";
sql += "VALUES('" + cCardNo + "','" + cCardType + "','" + expiryDate + "','" + cvv + "')";

I have added a ; at the end of first sql statement.

score 1 · Answer 2 · answered May 01 '15 at 06:20

If Datatype for dob and expriry date is date following code could help

TO_DATE('"+ str+"','yyyy/mm/dd')

Modified code is given below

String sql = "INSERT INTO MemberRecord(id, name, email, contactNo, password, gender, nationality, dateOfBirth, address, postalCode, secQues, secAns, userType)";
sql += "VALUES('" + id + "','" + name + "','" + email + "','" + cNo + "','" + pwd + "','" +gen + "','" + nationality + "',TO_DATE('" + dob + "','yyyy/mm/dd'),'" + address + "','" + pCode + "','" + secQuestion +"','"+secAnswer +userType + "');";

sql += "INSERT INTO PaymentDetails(creditCardNo,creditCardType,expiryDate,CVV)";
sql += "VALUES('" + cCardNo + "','" + cCardType + "',TO_DATE('" + expiryDate + "','yyyy/mm/dd'),'" + cvv + "')";

SQL MULTIPLE TABLE

2 Answers2