Insert Path of a file with \\ in mysql using java

Question

I am making a standalone application using java,and in that i need to insert the path of the image that user chooses from file chooser. I am getting the path of the file but when i store it in the database(mysql) it doesn't stores the \,so when i retrieve that path,the file doesn't show up.

How to store the path of file with \\ so that one gets escaped using java code?

i tried using replaceall method but its giving an error of illegal character set.

filename.replaceall("\","\\");

But this didn't work out.

Are you going to use the stored path in another Java application, or is it used for something else? — Jonathan B
– Jonathan B, Commented Jan 21, 2011 at 20:08

Jigar Joshi · Accepted Answer · 2011-01-21 20:06:18Z

5

Use Prepared statement to store path containing \.PreparedStatement doesn't escape anything

answered Jan 21, 2011 at 20:06

Jigar Joshi

241k42 gold badges409 silver badges446 bronze badges

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

Comments

BalusC · Accepted Answer · 2011-01-21 20:08:49Z

Since String is immutable and all methods you call on it doesn't change Strings internal value, but rather return the modified result, you need to assign the result of the replace to a variable. Also, since you want replace chars, not regex patterns, the replace() method is more than sufficient. The replaceAll() takes regex and the \ is a special character in regex as well.

filename = filename.replace("\\", "\\\\");

However, forward slashes are supposed to work as good in Windows.

filename = filename.replace("\\", "/");

However #2, you might want to store it in DB using PreparedStatement which sanitizes bad and SQL-injection-sensitive characters for you away. Prepare here.

Unrelated to the concrete problem, why would you like to store the file path in a DB? This is prone to portability errors. I'd suggest to store only the (unique) filename and have the actual files in a single common path which is configureable as application setting.

jzd · Accepted Answer · 2011-01-21 20:07:05Z

0

The slash should not be an issue. Make sure your path has the slash before you insert into the database. Also make sure you are using a PreparedStatement to insert the data.

answered Jan 21, 2011 at 20:07

jzd

23.6k9 gold badges58 silver badges76 bronze badges

Comments

r.piesnikowski · Accepted Answer · 2011-01-21 20:29:38Z

-1

With respect to Your posts BalusC but I think I cannot agree with you in one thing. Indeed Strings are immutable but filename.replace("a","b") return new instance of string.

So I think assigning to new variable is not necessary?

answered Jan 21, 2011 at 20:29

r.piesnikowski

2,9711 gold badge28 silver badges33 bronze badges

Comments

Alexander · Accepted Answer · 2013-03-07 12:25:44Z

-1

We can also use addslashes function for saving the file path,

addslashes($filepath)

edited Mar 7, 2013 at 12:25

Alexander

23.5k11 gold badges65 silver badges74 bronze badges

answered Aug 1, 2012 at 7:03

Sanaan Barzinji

571 bronze badge

Collectives™ on Stack Overflow

Insert Path of a file with \\ in mysql using java

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related