concatenate a CREATE TABLE statement with my values from the first

[mixahlel]

i am trying to write a program in java where i would concatenate a CREATE TABLE statement with my values from the first row of excel file and hold the fields name to create the SQLStatement.

To be more specific i would like to create a table to store the data in a database where it will have as field the content of the first row of the excel file. I have a couple of excel files and for each of them i would like to create a table. Can anyone help me?

The excel file contain data as the above:

ID NAME SURNAME TELEPHONE
12 XXX YYYY 45782148
... ... ... ....
etc.

I am using APACHE POI to read the data and i store them in a list.

public class readexcel{
public static void main(String[] args) throws Exception {
String filename = "C:\...\example.xls";
List sheetData = new ArrayList();
FileInputStream fis = null;
try {
fis = new FileInputStream(filename);
HSSFWorkbook workbook = new HSSFWorkbook(fis);
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator rows = sheet.rowIterator();
while (rows.hasNext()) {
HSSFRow row = (HSSFRow) rows.next();
Iterator cells = row.cellIterator();
List data = new ArrayList();
while (cells.hasNext()) {
HSSFCell cell = (HSSFCell) cells.next();
data.add(cell);
}
sheetData.add(data);
}
} catch (IOException e) {
e.printStackTrace();
} finally {
if (fis != null) {
fis.close();
}
}
private static void showExcelData(List sheetData) {
for (int i = 0; i < sheetData.size(); i++) {
List list = (List) sheetData.get(i);
for (int j = 0; j < list.size(); j++) {
Cell cell = (Cell) list.get(j);
if (cell.getCellType() == Cell.CELL_TYPE_NUMERIC) {
System.out.print(cell.getNumericCellValue());
} else if (cell.getCellType() == Cell.CELL_TYPE_STRING) {
System.out.print(cell.getRichStringCellValue());
} else if (cell.getCellType() == Cell.CELL_TYPE_BOOLEAN) {
System.out.print(cell.getBooleanCellValue());
}
if (j < list.size() - 1) {
System.out.print(", ");
}
}
System.out.println("");
}
}
}

and for store the data in database:

Statement  stmt = con.createStatement();


try
{
stmt.executeUpdate( "USE databasename;" );
}
catch( SQLException e )
{
System.out.println( "SQLException: " + e.getMessage() );
System.out.println( "SQLState:     " + e.getSQLState() );
System.out.println( "VendorError:  " + e.getErrorCode() );
}

try
{
**String table = "CREATE TABLE newtable( "
+ "id INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY,"
+......
+ "year INTEGER(4)"
+....
+ ");";
System.out.println( "Create a new table in the database..." );**
stmt.executeUpdate( table );
}
catch( SQLException e ) 

.....

etc

What i want is the String table = "CREATE TABLE newtable... to give the first column of the excel with the fields that contain and that has read from the previous code.Which fuction i have to use?

[r035198x]

Again, Java is an object oriented language. You will find life a lot easier if you think objects every time.
Separate the activities by,

1.) create a Column class that has properties name and type.
2.) create a Table class that has properties

String name

,

List<Column> columns

and

List<Records> tableData

where Record is the class that you created earlier to represent each excel row record.
3.) write a method that takes your excel file and produces a List<Table> records by reading the values from excel using poi.
4.) That a method that accepts a List<Table> parameter and creates the required sql scripts.

[mixahlel]

Could you provide me with code?