How can I insert java Strings into Database table?

Question

I have a database that I manage through a jsp file. I want to add some data to it, but I need the data to be taken from a String variable. I tried the following code but the "VALUES" parameter doesn't accept variables. Any help?

function UploadNot() {
     <%
          String NotificationToUpload = "Test Notification";
          Class.forName("org.sqlite.JDBC");
          conn = DriverManager.getConnection("jdbc:sqlite:d:\\Databases\\DataBase1.db");
          stat = conn.createStatement();
          String sql = "INSERT INTO Nots (Notifications) " +
               "VALUES (NotificationToUpload);";  //ERROR here, Does not accept variables, only direct Strings
          stat.executeUpdate(sql);
     %>
}

BluEOS · Accepted Answer · 2018-01-13 18:15:01Z

1

You forget the "+" operator in order to concatenate your value.

String sql = "INSERT INTO Nots (Notifications) VALUES ('" +NotificationToUpload+ "');";

edited Jan 13, 2018 at 18:15

answered Jan 13, 2018 at 18:02

BluEOS

6167 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Smirlianos Over a year ago

It doesn't work, I get a syntax error: "javax.servlet.ServletException: org.sqlite.SQLiteException: [SQLITE_ERROR] SQL error or missing database (near "Notification": syntax error)"

BluEOS Over a year ago

You have to quote the value if it's not an integer field.

BluEOS Over a year ago

I edited your correction, you added incorrect whitespaces.

Collectives™ on Stack Overflow

How can I insert java Strings into Database table?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related