import java.sql.*;
class Update {
public static void main(String args[]) {
System.out.println("argslength="+args.length);
for (int i=0;i");
return;
}
try {
Class.forName("COM.imaginary.sql.msql.MsqlDriver");
String url = "jdbc:msql://xxx.yyy.zzz:4333/mydb";
Connection con = DriverManager.getConnection(url, "yoonforh", "");
Statement s = con.createStatement();
ResultSet rs=s.executeQuery("SELECT * from dict ORDER BY dict_id");
int dict_id=0;
for (; rs.next(); dict_id++);
System.out.println("Executed Select");
System.out.println("dict_id="+dict_id);
dict_id++;
args[0]=convert_to_ascii(args[0]);
args[1]=convert_to_ascii(args[1]);
args[2]=convert_to_ascii(args[2]);
s.executeUpdate("INSERT INTO dict (dict_id, initialism, origin, meaning) " +
"VALUES(" + dict_id+ ", '" + args[0] + "', '" + args[1] + "', '" + args[2] + "')");
System.out.println("Insert succeeded.");
s.close();
con.close();
}
catch( Exception e ) {
e.printStackTrace();
}
}
private static String convert_to_ascii(String str) {
String result=null;
try {
byte[] kscBytes=str.getBytes("KSC5601");
result=new String(kscBytes, "8859_1");
} catch (java.io.UnsupportedEncodingException e) {
System.err.println(e.toString());
}
return result;
}
}