I have two problems: 1. I need to create tool that will create a test database and later on to populate it. The first problem is connected with creating the file. I do not know whether this is possible or not, but I want to create a file in which later on I can create tables and insert some values in the tables. 2. In this problem I want to input meaningfull values in the database columns? I do not know how this could be done.
Also at the moment I am have created the application and connect the application with a database file created from MS Access, with ODBC driver through the Control Panel.. What I mean to do is to create dinamicaly file according to the user input, and to populate that file with meaningfull data(values) later on. This is all done automatically, the user do not have to insert the values in the database, but through For loop at the moment I am inserting some kind of values, rows in the database, according the users input.
Any tips and help regarding any of the two above problems will be appreciated.
Use a BufferedReader to read the lines. Then evaluate the lines.
1. Sql-Syntax for appending data to a table: insert into tbname (columnName1, columnName2, columnName3, columnName4) values (123, 'text', null, true)
2. Sql-Syntax for editing data update tablename set columnName1 = 123, columnName = 'text' where conditionColumnName1 = false and conditionColumnName2 = 3
Previous Topic
