ʽʾӦó — ûע
ʽʾӦó — ûע
ڣ2004 9 28 Ŀ¼
Ӧó Ӧó Ӧó ʾӦóļ ο
Ⱦ
Ҫ˽ʾӦóûӦ·֪ʶ
ʽʹıݵһǿߡֱԺͽűԾֱָ֧ʽ Oracle ݿ 10g SQL PL/SQL Ҳṩ֧֡ Ϊʹıļģʽṩһַʽ API ݿıȡʽʹ
°汾 Oracle ݿ — Oracle ݿ 10g — º SQL PL/SQL оУʽʵʽ֧֣
- REGEXP_LIKE — LIKE һһʽƥ䣬
- REGEXP_REPLACE — øƥַģʽ滻һַ
- REGEXP_INSTR — һַʽƥĵһַʼλ
- REGEXP_SUBSTR — ʽƥַ
ʽԱģʽı˼áDZΪдıݵӦóִַ֤ʽ֮ķʽ⣬ǻϢѧʶ DNA ͵СѧʹʽоȻԡ Oracle ݿΪ SQL PL/SQL ʽԭ֧ͨڲѯݶַṩıݿʹı
Ӧó
ڴʾӦóУͨûעijʾ REGEXP_LIKE ʽʹáӦóʱʾһûϸϢݿд洢 CHECK_EMAIL CHECK_PHONE ʹ REGEXP_LIKE жûĵʼ͵绰ȷԡûύʱDBManager ݿⲢִͨûĹ̡Ч洢̽׳һ SQL ôϢʾûʼ͵绰Чûݲ뵽ݿС
úдʾӦó
|
|
|
<SAMPLE_HOME>
|
ʾѹڵĿ¼
|
| <JAVA_HOME>
|
װ JAVA Ŀ¼
|
| <ORACLE_HOME>
|
Oracle ݿİװĿ¼ |
Ӧó
- ѹص RegExpValidate.zipļݽѹ <SAMPLE_HOME> Ŀ¼С
⽫Դļ REGEXPValidate ļ
- SQL ʾ scott/tiger ӣȻ <SAMPLE_HOME>/REGEXPValidate/config ļ RegExp.sql ű⽫Ӧóı̡
- ʹõı༭༭ REGEXPvalidate/config/Connection.properties ļ HostNamePortSIDUserName Password ӵԼݿ⣬
|
|
= |
localhostݿװڵķƣ
|
|
SID
|
= |
ORCL
|
|
Port
|
= |
1521
|
|
û
|
= |
Scott
|
|
|
= |
tiger
|
Ӧó
·ʽ֮һиӦó
ʹ JDeveloper 10g иӦó
òֽʹ Oracle JDeveloper 10g иӦóIJ衣
- Oracle JDeveloper 10gʹ File/Open ѡ <SAMPLE_HOME>/RegExpValidate Ŀ¼
ѡ RegExpValidate.jws
- ţ˵ѡ Project/Make RegExpValidate.jpr
- ڣ˵ѡ Run/Run RegExpValidate.jpr⽫ Registration Form ܡ
ʹ JDK иӦó
ò˵бʾӦó漰IJ衣
- ʾĿ¼ <SAMPLE_HOME>/RegExpValidate/src
- classpath JDBC ⣨ classes12.jar ojdbc14.jarConnection.properties ͵ǰĹĿ¼磬
CLASSPATH=d:\<ORACLE_HOME>\jdbc\lib\classes12.jar;<SAMPLE_HOME>/REGEXPValidate/config; ;
- ʹЩ
javac oracle/otnsamples/plsql/*.java
- ִʾ
Java oracle.otnsamples.plsql.Registration
- ⽫ʾ Registration Form ܡֵ“ύ”
ʾӦóļ
òֽԱʽṩʾӦóļӦĿ¼λԼļӦó巽á
| Ŀ¼ |
ļ |
˵ |
|
REGEXPvalidate\doc
|
readme.html
|
ļ
|
|
REGEXPvalidate\src\oracle\otnsamples\plsql
|
*.java |
ʾӦóʹõ Java Դļ |
|
REGEXPvalidate\config
|
Connection.properties
|
ݿϸϢļ |
|
REGEXPvalidate\config
|
RegExp.sql
|
SQL ļڴбʾӦóı̡ |
ο
˴ԸʾӦó
|