글쓴이 :이원영 1998년 9월 16일 19:34:11
In Reply to: [질문] posted by 이진호 on 1998년 9월 16일 18:04:04:
Web Browser에서 입력받은 한글은
servlet에 도착할 때 8859_1으로 도착합니다.
이를 DB에 넣을 때 KSC5601로 변환후 넣으세요.
Select할 땐 반대로 KSC5601을 8859_1으로
바꾸어 주세요.
예제
<pre>
<b>[UserObject.java]</b>
import young.addressbook.entity.*;
import young.util.*;
import java.sql.*;
import java.lang.*;
import java.io.*;
public class UserObject extends java.lang.Object
{
...........
public synchronized boolean updatePassword( User user )
{
if( !isInitialized() ) return false;
String id = user.getID();
String password = user.getPassword();
try {
updatePasswordStmt.executeUpdate(
"UPDATE tb_user " +
"SET password = '" + CharConversion.K2E(password) +"' " +
"WHERE id = '" + CharConversion.K2E(id) + "'"
);
}catch( SQLException e ){
e.printStackTrace();
return false;
}
return true;
}
public synchronized User select( User user )
{
if( !isInitialized() ) return null;
User selectedUser = new User();
String id = user.getID();
try {
ResultSet rs = null;
rs = selectStmt.executeQuery(
"SELECT id, password, name, phone, email " +
"FROM tb_user " +
"WHERE id = '" + CharConversion.K2E(id) + "'"
);
if ( rs.next() ) {
selectedUser.setID(CharConversion.E2K(rs.getString(1)));
selectedUser.setPassword(CharConversion.E2K(rs.getString(2)));
selectedUser.setName(CharConversion.E2K(rs.getString(3)));
selectedUser.setPhone(CharConversion.E2K(rs.getString(4)));
selectedUser.setEmail(CharConversion.E2K(rs.getString(5)));
}
}catch( SQLException e ){
e.printStackTrace();
return null;
}
return selectedUser;
}
............
}
<b>[CharConversion.java]</b>
import java.lang.*;
import java.io.UnsupportedEncodingException;
public class CharConversion
{
private static String korean = null;
private static String english = null;
public static synchronized String E2K( String english )
{
//if (english == null ) return null;
if (english == null ) return "";
try {
korean = new String(new String(english.getBytes("8859_1"), "KSC5601"));
}
catch( UnsupportedEncodingException e ){
korean = new String(english);
}
return korean;
}
public static synchronized String K2E( String korean )
{
//if (korean == null ) return null;
if (korean == null ) return "";
try {
english = new String(new String(korean.getBytes("KSC5601"), "8859_1"));
}
catch( UnsupportedEncodingException e ){
english = new String(korean);
}
return english;
}
}
</pre>