public InsertItem ( ) {
}
public void loadDriver ( ) throws ClassNotFoundException, Exception {
Class.forName ( "oracle.jdbc.driver.OracleDriver" ) .newInstance ( ) ;
}
public void insert ( BoardData data, String remoteAddr ) throws SQLException {
String url = "jdbc:oracle:thin:@localhost:1521:etri" ;
Connection con ;
Statement stmt ;
String name = data.name ;
String email = data.email ;
String title = data.title ;
String content = data.content ;
String password = data.password ;
con = DriverManager.getConnection ( url, "scott", "tiger" ) ;
stmt = con.createStatement ( ) ;
String CountQuery = "select max ( BNUM ) as rc from board " ;
ResultSet rc = stmt.executeQuery ( CountQuery ) ;
rc.next ( ) ;
int num = rc.getInt ( "rc" ) + 1 ;
System.out.println ( "num = " + num ) ;
String query = "insert into board ( BNUM, BDATE, BNAME, BEMAIL, BTITLE, BCONTENT, BPASSWORD ) values ( " + num + ", SYSDATE, '" + toHangul(name) + "', '" + toHangul(email) + "', '" + toHangul(title) + "', '" + toHangul(content) + "', '" + password + "', '" +  remoteAddr + "' )";
ResultSet rs = stmt.executeQuery ( query ) ;
stmt.close ( ) ;
con.close ( ) ;
}
private String toHangul ( String str ) {
if ( str == null ) return null;
try {
return new String ( str.getBytes ( "8859_1" ) , "KSC5601" ) ;
}
catch ( UnsupportedEncodingException e ) {
}
return null ;
}
private String hangulTo ( String str ) {
if ( str == null ) return null;
try {
return new String ( str.getBytes ( "KSC5601" ) , "8859_1" ) ;
}
catch ( UnsupportedEncodingException e ) {
}
return null ;
}
