匹配行 ^.*内容.*$ ^.*内容.*\r?\n 删除字符 A之后字符：A.*$ A之前字符：^([^s]*)A 换行: \n

建表 1 2 3 4 5 CREATE INDEX idx_table_name_column_name ON table_name(column_name); CREATE UNIQUE INDEX idx_table_name_column_name ON table_name(column_name); CREATE sequence seq_table_name; COMMENT ON TABLE table_name IS 'table_name'; COMMENT ON COLUMN table_name.column_name IS 'column_name'; 修改表 1 2 3 4 DROP sequence seq_name; ALTER TABLE table_name ADD (column_name datatype,column_name datatype); ALTER TABLE table_name MODIFY (column_name datatype,column_name datatype); ALTER TABLE table_name DROP (column_name,column_name); 复制表 1 CREATE TABLE NEW_TAB AS

批量merge Oracle 参数做判断，需要传入map 1 2 3 4 5 6 <statement id="merge" parameterClass="map"> <iterate property="list" open="begin" close=";end;" conjunction=";"> merge into... <isNotEmpty property="list[].id"> id=id, </isNotEmpty> 不用判断参数，传入list 1 2 3 <statement id="merge" parameterClass="list"> <iterate open="begin" close=";end;" conjunction=";"> merge into... #list[].id# mysql 1 2

settings.xml 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <?xml version="1.0" encoding="UTF-8"?> <settings xmlns="http://maven.apache.org/SETTINGS/1.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/SETTINGS/1.0.0 http://maven.apache.org/xsd/settings-1.0.0.xsd"> <localRepository>C:\repository</localRepository> <mirrors> <mirror> <id>aliyun</id> <mirrorOf>central</mirrorOf> <name>Nexus aliyun</name> <url>http://maven.aliyun.com/nexus/content/groups/public</url> </mirror> </mirrors> </settings> 脚本 1 2 mkdir %USERPROFILE%\.m2 copy .\settings.xml %USERPROFILE%\.m2\

基础配置 project 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> </properties> <build> <!-- 打包后的名称war/jar --> <finalName>pkgName</finalName> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>2.3.2</version> <configuration> <encoding>utf-8</encoding> <source>1.8</source> <target>1.8</target> <!-- 打包跳过测试