How to save file path to sql database

Question

I am developing an application where I have to open documents from the application. I have to save the path of the file to the sql database. The column in sql to which file path is inserted is of type VARCHAR(255).

If the path of a file is C:\Users\UPS21120\Downloads\doc1.pdf ,it being saved in the database as as C:UsersUPS21120Downloadsdoc1.pdf (where are the backslashes in the saved path?).

When i retrieve this path to open the file doc1.pdf, I am getting an exception which says that doc1 does not exist.Following is the code I used to save the path. Please help.

      JFileChooser fc = new JFileChooser(); 
      returnVal = fc.showOpenDialog(view_doc.this);
      File file1=fc.getSelectedFile();

      if (returnVal == JFileChooser.APPROVE_OPTION) {
      String str = "INSERT INTO document(doc_path) VALUES ('"+file+"')";
                  // open connection..execute query etc--works fine

      }

Community · Accepted Answer · 2017-05-23 10:32:00Z

1

You have to escape the value you want to insert before you insert it in the database. Or you can use prepared statements that will do that for you.

See also: Java - escape string to prevent SQL injection

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Feb 8, 2013 at 8:29

Vincent Mimoun-Prat

28.6k16 gold badges85 silver badges126 bronze badges

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

Comments

mikakun · Accepted Answer · 2013-02-08 08:31:07Z

1

to escape strings in java

http://commons.apache.org/lang/api-2.4/org/apache/commons/lang/StringEscapeUtils.html

Escapes the characters in a String using Java String rules. ... Deals correctly with quotes and control-chars (tab, backslash, cr, ff, etc.)

answered Feb 8, 2013 at 8:31

mikakun

2,2832 gold badges18 silver badges25 bronze badges

Comments

Fathah Rehman P · Accepted Answer · 2013-02-08 09:05:19Z

0

Simplest solution is use / instead of \ in path . Then you can insert path string easily in to database. There will be no error. Also java can use path with /

answered Feb 8, 2013 at 9:05

Fathah Rehman P

8,8014 gold badges43 silver badges42 bronze badges

Collectives™ on Stack Overflow

How to save file path to sql database

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related