CushionTheBlow (구 BluemoonSoft)

Regular expressions are used by many text editors, utilities, and programming languages to search and manipulate text based on patterns. For example, Perl and Tcl have a powerful regular expression engine built directly into their syntax. Several utilities provided by Unix distributions—including the editor ed and the filter grep—were the first to popularize the concept of regular expressions. "Regular expression" is often shortened to regex or regexp (singular), or regexes, regexps, or regexen (plural). Some authors distinguish between regular expression and abbreviated forms such as regex, restricting the former to true regular expressions, which describe regular languages, while using the latter for any regular expression-like pattern, including those that describe languages that are not regular. As only some authors observe this distinction, it is not safe to rely upon it.

As an example of the syntax, the regular expression \bex can be used to search for all instances of the string "ex" that occur at word boundaries (signified by the \b). Thus in the string, "Texts for experts," \bex matches the "ex" in "experts," but not in "Texts" (because the "ex" occurs inside the word there and not immediately after a word boundary).

Many modern computing systems provide wildcard characters in matching filenames from a file system. This is a core capability of many command-line shells and is also known as globbing. Wildcards differ from regular expressions in that they generally only express very restrictive forms of alternation.

public class MySQLKoreanInsertDemo {
 public static void main(String[] args) {
  try {
   Class.forName("com.mysql.jdbc.Driver").newInstance();
  } catch (ClassNotFoundException e) {
   System.err.println(e);
  } catch (InstantiationException e) {
   System.err.println(e);
  } catch (IllegalAccessException e) {
   System.err.println(e);
  }

  String server = "localhost";
  String dbname = "vsms";
  String username = "user1";
  String password = "passwd1";

  String url = "jdbc:mysql://" + server + "/" + dbname
    + "?user=" + username
    + "&password=" + password
    + "&useUnicode=true&characterEncoding=euc_kr";

  try {
   Connection conn = DriverManager.getConnection(url);
   Statement stmt = conn.createStatement();

   String query = "INSERT INTO test (data) VALUES ('임정묵')";

   stmt.executeUpdate(query);

   stmt.close();
   conn.close();
  } catch (SQLException e) {
   System.err.println(e);
  }
 }
}