I am just trying to get text from a JtextField and I want to implement it inside a sql injection to create a table. Here is my code: try { Class.forName("org.sqlite.JDBC"); conni = DriverManager.getConnection("jdbc:sqlite://C://Users//Asus//Dropbox//Admin.sqlite");
stmt = conni.createStatement();
String sql = "CREATE TABLE" + projectname.getText() +
"(ID INT PRIMARY KEY NOT NULL," +
" NAME TEXT NOT NULL, " +
" EstQuantity INT NOT NULL, " +
" UnitPrice CHAR(50), " +
" TotalPrice REAL)";
stmt.executeUpdate(sql);
stmt.close();
conni.close();
} catch ( Exception e ) {
System.err.println( e.getClass().getName() + ": " + e.getMessage() );
System.exit(0);
}
JOptionPane.showMessageDialog(null, "Project Created!");
This is the basic structure. When I input my table name it says java.sql.SQLException: near "(my input)CREATE": syntax error Please help!
Aucun commentaire:
Enregistrer un commentaire