The database table does not exist-CodePudding

Today to write data into the database but show database does not exist,
The code for

 String tableName=request. The getParameter (" tableName ");//database table name 
String excelname=request. The getParameter (" excelname ");//to import excel file name 

String TABLE_NAME=tableName;//database table name 
String PATH="E: \ \ mine detection \ \ matlab mine ground pressure real-time monitoring and disaster warning system V2.38.200616 \ \ data \ ";//file path 
String EXCEL_PATH=+ excelname PATH;//excel path 

String INSERT_SQL="insert into" + TABLE_NAME + 
"(no, date, time, days, value1, direction1, dip1, value2, direction2, dip2, value3, direction3, dip3, StressDifference, remark)" + 
"Values (?,?,?,?,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,? ,?) "; 

String UPDATE_SQL="update" + 
TABLE_NAME + 
"No=? , the date=? , time=? , days=? , value1=? , direction1=? , dip1=? , value2=? , direction2=? , dip2=? , value3=? , "+ 
"Direction3=? , dip3=? , StressDifference=? That remark=? Where id=? "; 
String SELECT_ALL_SQL="select id, no, the date, time, days, value1, direction1, dip1, value2, direction2, dip2, value3, direction3, dip3, StressDifference, remark from" + TABLE_NAME; 

String SELECT_SQL="select * from + TABLE_NAME" + "where time like";

Transfer to a database table named y001, but display an error, error code section below

Database y001 table exists, is this why??????

CodePudding user response:

String INSERT_SQL="insert into" + TABLE_NAME +
Lack of space led to into and the library together