Method:
Use function. checkreplace (STR );
Package my; // specify the package of the class
Import java. SQL .*;
Import java. util. calendar;
Public class function {
/*************************************** ************************************
* Function name: checkreplace used for conversion SQL special string parameter: S: string type, character return value to be converted: converted string
* Use: String S2 = checkreplace (S1 );
**************************************** **********************************/
Public static string checkreplace (string s ){
Try {
If (S = NULL | S. Equals (""))
Return "";
Else {
Stringbuffer = new stringbuffer ();
For (INT I = 0; I <S. Length (); I ++ ){
Char c = S. charat (I );
Switch (c ){
Case 34 ://'"'
Stringbuffer. append ("& quot ;");
Break;
Case 39 ://'/''
Stringbuffer. append ("& #039 ;");
Break;
Case 124: // '|'
Stringbuffer. append ("");
Break;
Case '&':
Stringbuffer. append ("& amp ;");
Break;
Case '<':
Stringbuffer. append ("& lt ;");
Break;
Case '> ':
Stringbuffer. append ("& gt ;");
Break;
Default:
Stringbuffer. append (C );
Break;
}
}
Return stringbuffer. tostring (). Trim (); // return the converted string
}
} Catch (exception e ){
Return "";
}
}
}