±Û¾´ÀÌ :±èÇÊÈ£ 1998³â 12¿ù 09ÀÏ 18:06:12
In Reply to: [Áú¹®] ½Ì±ÛÄõÅ×À̼ÇÀÌ µÎ°³ ¿¬¼ÓÀ̶ó... posted by Á¤ÁØ¿ø on 1998³â 12¿ù 09ÀÏ 17:08:47:
insert into table (content) values ('''Å×½ºÆ®''')
ÇؾßÁö content Çʵ忡 'Å×½ºÆ®' °¡ µË´Ï´Ù.
String a = "'Å×½ºÆ®'";
String query = "insert into table (content) values ('" + a + "')";
·Î ÇÏ°í, java.sql.Statement.executeUpdate( query ) Çϸé
' ¹®Á¦ ¶§¹®¿¡ SQL ¹® ¿¡·¯°¡ ¹ß»ýÇÕ´Ï´Ù.
±×·¡¼ ' ¸¦ ¸ðµÎ '' ·Î ¹Ù²Ù´Â °úÁ¤ÀÌ ÇÊ¿äÇÏÁö¿ä.
replace() ¸Þ¼Òµå¸¦ ÀÛ´çÈ÷ ±¸ÇöÇÏ¿©
String a = replace("'Å×½ºÆ®'", "'", "'');
String query = "insert into table (content) values ('" + a + "')";
·Î ÇÏ°í, java.sql.Statement.executeUpdate( query ) Çϸé
ÇØ°áµË´Ï´Ù.
relace() ¸Þ½îµå´Â "Java¿Í ÇѱÛ" °Ô½ÃÆÇ¿¡ ÀÌ¹Ì ÀÖ½À´Ï´Ù.
Àú´Â ÀÌ replace() ¸¦ ¿©·¯ °÷¿¡¼ Àû¿ëÇÏ°í ÀÖ½À´Ï´Ù.
Âü°í·Î, String Ŭ·¡½º ¾È¿¡ ÀÖ´Â replace() ¸Þ½îµå´Â
char ¸¦ char ·Î ¹Ù²Ù´Â ±â´É¸¸ ÀÖ½À´Ï´Ù.