That's is true. I did not think about it. Thank you very much!! appreciate it. I am going to try it out now.
Kat. On Sat, Oct 31, 2009 at 9:30 PM, Anand <[email protected]> wrote: > hi, > > TestCaseId1, TestCaseName1, TestResults1 should not be in string quotes > > String table = "INSERT INTO JAPTestResults(TestCaseId, TestCaseName, > TestResults) VALUES ( "+TestCaseId1+",' "+ TestCaseName1+ > " ',' " + TestResults1 +" ' )"; > > database always accept values in single quotes for string and direct incase > of integer. > > anand > > > > On Sat, Oct 31, 2009 at 8:27 PM, kat Owen <[email protected]> wrote: > >> >> >> Hi all >> >> Thanks for all your help!! >> >> I need more help . >> >> >> Now I am able to conenct to the db and create a table and insert values ; >> But when I try to parameterize the values. I bump into some SQLException: >> >> The problem is in the following line : when I use values like 5, >> 'AddConn', 'Passed' But when I parameterize them it throws this >> excepiton . >> >> >> String table = "INSERT INTO JAPTestResults(TestCaseId, TestCaseName, >> TestResults) VALUES (TestCaseId1, TestCaseName1, TestResults1)"; >> >> //String table = "INSERT INTO JAPTestResults(TestCaseId, TestCaseName, >> TestResults) VALUES (5, 'AddConn', 'Passed')"; >> >> >> * >> >> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException >> *: Unknown column 'TestCaseId1' in 'field list' >> >> at com.mysql.jdbc.SQLError.createSQLException( >> *SQLError.java:936*) >> >> at com.mysql.jdbc.MysqlIO.checkErrorPacket( >> *MysqlIO.java:2985*) >> >> at com.mysql.jdbc.MysqlIO.sendCommand( >> *MysqlIO.java:1631*) >> >> at com.mysql.jdbc.MysqlIO.sqlQueryDirect( >> *MysqlIO.java:1723*) >> >> at com.mysql.jdbc.Connection.execSQL( >> *Connection.java:3277*) >> >> at com.mysql.jdbc.Statement.executeUpdate( >> *Statement.java:1402*) >> >> at com.mysql.jdbc.Statement.executeUpdate( >> *Statement.java:1317*) >> >> at createTable2.insertResults( >> *createTable2.java:107*) >> >> at createTable2.main( >> *createTable2.java:161*) >> >> >> >> >> >> >> >> >> >> my main program : >> >> >> * >> >> public >> **static* *void* main(String args[]) >> >> { >> >> *int* testcaseId = 5; >> >> String TestCaseName = >> "AddConn"; >> >> String TestCaseResults = >> "Passed"; >> >> *try* >> >> { >> >> createTable2 abc = >> *new* createTable2(); >> >> //*abc*.createTab(); >> >> System. >> *out*.println(" before calling the methos" + testcaseId + TestCaseName + >> TestCaseResults ); >> >> abc.insertResults(testcaseId, TestCaseName, TestCaseResults); >> >> } >> *catch* (Exception e) >> >> { >> >> e.printStackTrace(); >> >> } >> >> } >> >> } >> >> >> * >> >> public >> **void* insertResults(*int* testCaseId, String testCaseName, String >> testResults) >> >> { >> >> Connection connection = >> *null*; >> >> Statement statement = >> *null*; >> >> *int* TestCaseId1 = 0; >> >> String TestCaseName1 = >> "First"; >> >> String TestResults1 = >> "PassedORFailed"; >> >> *try* { >> >> System. >> *out*.println(" In the method first call" + testCaseId + testCaseName + >> testResults ); >> >> /* TestCaseId1 = testCaseId; >> >> TestCaseName1 = testCaseName; >> >> TestResults1 = testResults;*/ >> >> System. >> *out*.println("in the method second call " + TestCaseId1 + TestCaseName1 >> + TestResults1 ); >> >> // load the driver class >> >> Class.*forName*( >> *DRIVER*); >> >> // establish the connection >> >> connection = DriverManager.*getConnection*( >> *DATABASE_URL*,"root","root"); >> >> statement= connection.createStatement(); >> >> String table = >> "INSERT INTO JAPTestResults(TestCaseId, TestCaseName, TestResults) VALUES >> (TestCaseId1, TestCaseName1, TestResults1)"; >> >> //String table = "INSERT INTO JAPTestResults(TestCaseId, TestCaseName, >> TestResults) VALUES (5, 'AddConn', 'Passed')"; >> >> statement.executeUpdate(table); >> >> System. >> *out*.println("Table Insert process successfully!"); >> >> //connection.prepareStatement("INSERT INTO JAPTestResults2 (id, data) >> VALUES (1,'ABA')"); >> >> } >> *catch* (SQLException insert) >> >> { >> >> insert.printStackTrace(); >> >> } >> >> *catch* (ClassNotFoundException classNotFound) >> >> { >> >> classNotFound.printStackTrace(); >> >> } >> >> *finally* >> >> { >> >> *try* { >> >> statement.close(); >> >> connection.close(); >> >> } >> *catch* (Exception e) >> >> { >> >> e.printStackTrace(); >> >> } >> >> } >> >> >> >> } >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > > -- > Regards, > > AnAnD, > Software Engineer, > ZEDO AdServing > > . > --~--~---------~--~----~------------~-------~--~----~ To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/javaprogrammingwithpassion?hl=en -~----------~----~----~----~------~----~------~--~---
