rpm --help
用法: rpm [选项...]

Query/Verify package selection options:
  -a, --all                          query/verify all packages
  -f, --file                         query/verify package(s) owning file
  -g, --group                        query/verify package(s) in group
  -p, --package                      query/verify a package file
      --pkgid                        query/verify package(s) with package
                                     identifier
      --hdrid                        query/verify package(s) with header
                                     identifier
      --triggeredby                  query the package(s) triggered by the
                                     package
      --whatrequires                 query/verify the package(s) which require
                                     a dependency
      --whatprovides                 query/verify the package(s) which provide
                                     a dependency
      --whatrecommends               query/verify the package(s) which
                                     recommends a dependency
      --whatsuggests                 query/verify the package(s) which
                                     suggests a dependency
      --whatsupplements              query/verify the package(s) which
                                     supplements a dependency
      --whatenhances                 query/verify the package(s) which
                                     enhances a dependency
      --nomanifest                   do not process non-package files as
                                     manifests

Query options (with -q or --query):
  -c, --configfiles                  list all configuration files
  -d, --docfiles                     list all documentation files
  -L, --licensefiles                 list all license files
  -A, --artifactfiles                list all artifact files
      --dump                         dump basic file information
  -l, --list                         list files in package
      --queryformat=QUERYFORMAT      use the following query format
  -s, --state                        display the states of the listed files

Verify options (with -V or --verify):
      --nofiledigest                 don't verify digest of files
      --nofiles                      don't verify files in package
      --nodeps                       don't verify package dependencies
      --noscript                     don't execute verify script(s)

Install/Upgrade/Erase options:
      --allfiles                     install all files, even configurations
                                     which might otherwise be skipped
      --allmatches                   remove all packages which match <package>
                                     (normally an error is generated if
                                     <package> specified multiple packages)
      --badreloc                     relocate files in non-relocatable package
  -e, --erase=<package>+             erase (uninstall) package
      --excludedocs                  do not install documentation
      --excludepath=<path>           skip files with leading component <path> 
      --force                        short hand for --replacepkgs
                                     --replacefiles
      --force-debian                 force installation of rpm on Debian system
  -F, --freshen=<packagefile>+       upgrade package(s) if already installed
  -h, --hash                         print hash marks as package installs
                                     (good with -v)
      --ignorearch                   don't verify package architecture
      --ignoreos                     don't verify package operating system
      --ignoresize                   don't check disk space before installing
  -i, --install                      install package(s)
      --justdb                       update the database, but do not modify
                                     the filesystem
      --nodeps                       do not verify package dependencies
      --nofiledigest                 don't verify digest of files
      --nocontexts                   don't install file security contexts
      --nocaps                       don't install file capabilities
      --noorder                      do not reorder package installation to
                                     satisfy dependencies
      --noscripts                    do not execute package scriptlet(s)
      --notriggers                   do not execute any scriptlet(s) triggered
                                     by this package
      --oldpackage                   upgrade to an old version of the package
                                     (--force on upgrades does this
                                     automatically)
      --percent                      print percentages as package installs
      --prefix=<dir>                 relocate the package to <dir>, if
                                     relocatable
      --relocate=<old>=<new>         relocate files from path <old> to <new>
      --replacefiles                 ignore file conflicts between packages
      --replacepkgs                  reinstall if the package is already
                                     present
      --test                         don't install, but tell if it would work
                                     or not
  -U, --upgrade=<packagefile>+       upgrade package(s)
      --reinstall=<packagefile>+     reinstall package(s)

Common options for all rpm modes and executables:
  -D, --define='MACRO EXPR'          define MACRO with value EXPR
      --undefine=MACRO               undefine MACRO
  -E, --eval='EXPR'                  print macro expansion of EXPR
      --target=CPU-VENDOR-OS         Specify target platform
      --macros=<FILE:...>            read <FILE:...> instead of default file(s)
      --noplugins                    don't enable any plugins
      --nodigest                     don't verify package digest(s)
      --nosignature                  don't verify package signature(s)
      --rcfile=<FILE:...>            read <FILE:...> instead of default file(s)
  -r, --root=ROOT                    use ROOT as top level directory (default:
                                     "/")
      --dbpath=DIRECTORY             use database in DIRECTORY
      --querytags                    display known query tags
      --showrc                       display final rpmrc and macro
                                     configuration
      --quiet                        provide less detailed output
  -v, --verbose                      provide more detailed output
      --version                      print the version of rpm being used

Options implemented via popt alias/exec:
      --scripts                      list install/erase scriptlets from
                                     package(s)
      --setperms                     set permissions of files in a package
      --setugids                     set user/group ownership of files in a
                                     package
      --conflicts                    list capabilities this package conflicts
                                     with
      --obsoletes                    list other packages removed by installing
                                     this package
      --provides                     list capabilities that this package
                                     provides
      --requires                     list capabilities required by package(s)
      --recommends                   list capabilities recommended by
                                     package(s)
      --suggests                     list capabilities suggested by package(s)
      --supplements                  list capabilities supplemented by
                                     package(s)
      --enhances                     list capabilities enhanced by package(s)
      --info                         list descriptive information from
                                     package(s)
      --changelog                    list change logs for this package
      --changes                      list changes for this package with full
                                     time stamps
      --xml                          list metadata in xml
      --triggers                     list trigger scriptlets from package(s)
      --filetriggers                 list filetrigger scriptlets from
                                     package(s)
      --last                         list package(s) by install time, most
                                     recent first
      --dupes                        list duplicated packages
      --filesbypkg                   list all files from each package
      --fileclass                    list file names with their classes
      --filecolor                    list file names with their colors
      --fileprovide                  list file names with their provides
      --filerequire                  list file names with requires
      --filecaps                     list file names with their POSIX1.e
                                     capabilities

帮助选项:
  -?, --help                         显示这个帮助信息
      --usage                        显示简短的使用说明

UPDATE tablename SET  field = REPLACE(REPLACE(field, CHAR(10), ”), CHAR(13), ”);

char(10):  换行符
char(13):  回车符

UPDATE gt_user SET NAME = REPLACE(NAME, 0xE38080, '')

/**
 * 下载excel文件,内容使用MAP存放
 * 
 * @param response
 * @param headName
 * @param tableHead
 * @param tableBody
 * @throws IOException
 */
public static void downloadExcelMap(HttpServletResponse response, String headName, List<String> tableHead,
        List<Map<Object, Object>> tableBody) throws IOException {
    headName=StringUtils.replaceAllSpecial(headName);
    // 1:创建一个workbook
    HSSFWorkbook workbook = new HSSFWorkbook();

    // 创建样式
    HSSFCellStyle style = workbook.createCellStyle();
    Font font = workbook.createFont();
    font.setBoldweight(Font.BOLDWEIGHT_BOLD); // 粗体
    style.setFont(font);
    style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平居中
    style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 垂直居中
    style.setBorderTop((short) 1);
    style.setBorderBottom((short) 1);
    style.setBorderLeft((short) 1);
    style.setBorderRight((short) 1);
    style.setWrapText(true);

    // 设置合计样式
    HSSFCellStyle style1 = workbook.createCellStyle();
    style1.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 水平居中
    style1.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); // 垂直居中
    style1.setBorderTop((short) 1);
    style1.setBorderBottom((short) 1);
    style1.setBorderLeft((short) 1);
    style1.setBorderRight((short) 1);
    style.setWrapText(true);

    HSSFSheet sheet = (HSSFSheet) workbook.createSheet(headName);
    // 2：合并单元格，表头。并设置值
    CellRangeAddress cra = new CellRangeAddress(0, 0, 0, tableHead.size() - 1);
    sheet.addMergedRegion(cra);
    HSSFRow row = sheet.createRow(0);
    HSSFCell tableName = row.createCell(0);
    tableName.setCellStyle(style);
    tableName.setCellValue(headName);

    //存储最大列宽
    Map<Integer,Integer> maxWidth = new HashMap<Integer,Integer>();
    
    // 3：设置表head
    HSSFRow row1 = sheet.createRow(1);
    for (int i = 0; i < tableHead.size(); i++) {
        Cell createCell = row1.createCell(i);
        createCell.setCellValue(tableHead.get(i));
        createCell.setCellStyle(style);
        maxWidth.put(i,createCell.getStringCellValue().getBytes().length  * 256 + 200);
    }
    // 4：表格内容
    for (int i = 0; i < tableBody.size(); i++) {
        HSSFRow rows = sheet.createRow(i + 2);
        int j = 0;
        for (Map.Entry<Object, Object> entry : tableBody.get(i).entrySet()) {
            HSSFCell createCell = rows.createCell(j);
            if(PropertyUtil.objectNotEmpty(entry.getValue())){
                createCell.setCellValue(entry.getValue().toString());
            }else{
                createCell.setCellValue("");
            }
            int length = createCell.getStringCellValue().getBytes().length  * 256 + 200;
            //这里把宽度最大限制到15000
            if (length>15000){
                length = 15000;
            }
            maxWidth.put(j,Math.max(length,maxWidth.get(j)));
            j++;
            createCell.setCellStyle(style1);
        }
    }
    
    // 列宽自适应
    for (int i = 0; i < tableHead.size(); i++) {
        sheet.setColumnWidth(i,maxWidth.get(i));
    }

    // 5：设置头
    response.setHeader("Content-disposition",
            "attachment; filename=" + new String(headName.getBytes("GB2312"), "ISO8859-1") + ".xls");
    // 6：设置头类型
    response.setContentType("application/vnd.ms-excel");
    
    // 7：写出
    OutputStream toClient = response.getOutputStream();
    workbook.write(toClient);
    toClient.flush();
    toClient.close();

}

style.setWrapText(true);

[ERROR] Failed to execute goal org.apache.maven.plugins:maven-assembly-plugin:2.5.5:single (default) on project ycsb: Failed to create assembly: Artifact: com.yahoo.ycsb:riak-binding:jar:0.3.1-RC1-SNAPSHOT (included by module) does not have an artifact with a file. Please ensure the package phase is run before the assembly is generated. -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.apache.maven.plugins:maven-assembly-plugin:2.5.5:single (default) on project ycsb: Failed to create assembly: Artifact: com.yahoo.ycsb:riak-binding:jar:0.3.1-RC1-SNAPSHOT (included by module) does not have an artifact with a file. Please ensure the package phase is run before the assembly is generated.

<plugin>
  <artifactId>maven-assembly-plugin</artifactId>
  <configuration>
    <archive>
      <manifest>
        <mainClass>com.test.MainClassName</mainClass>
      </manifest>
    </archive>
    <descriptorRefs>
      <descriptorRef>jar-with-dependencies</descriptorRef>
    </descriptorRefs>
  </configuration>
  <executions>
    <execution>
      <id>make-assembly</id> 
      <phase>package</phase> <!-- packaging phase -->
      <goals>
        <goal>single</goal>
      </goals>
    </execution>
  </executions>
</plugin>

$ uname -r

$ yum update

tee /etc/yum.repos.d/docker.repo <<-'EOF'
[dockerrepo]
 
name=DockerRepository
 
baseurl=https://yum.dockerproject.org/repo/main/centos/$releasever/
 
enabled=1
 
gpgcheck=1
 
gpgkey=https://yum.dockerproject.org/gpg
 
EOF

$ yum install -y docker-engine

$systemctl start docker.service

$ sudo systemctl enable docker

application exception overridden by commit exception

@Transactional(rollbackFor = DemoException.class)

$(document).on('show.bs.modal', '.modal', function(event) {
    $(this).appendTo($('body'));
}).on('shown.bs.modal', '.modal.in', function(event) {
    setModalsAndBackdropsOrder();
}).on('hidden.bs.modal', '.modal', function(event) {
    setModalsAndBackdropsOrder();
});


function setModalsAndBackdropsOrder() {  
    var modalZIndex = 1040;
    $('.modal.in').each(function(index) {
        var $modal = $(this);
        modalZIndex++;
        $modal.css('zIndex', modalZIndex);
        $modal.next('.modal-backdrop.in').addClass('hidden').css('zIndex', modalZIndex - 1);
    });
    $('.modal.in:visible:last').focus().next('.modal-backdrop.in').removeClass('hidden');
}

finally block does not complete normally

<?xml version="1.0" encoding="UTF-8"?>

<class> 
  <student> 
    <name>张三</name>  
    <sid>111111</sid> 
  </student>  
  <student id="stu1"> 
    <name>李四</name>  
    <sid>222222</sid> 
  </student> 
</class>

import java.util.List;
import org.dom4j.Document;
import org.dom4j.Node;
import org.dom4j.io.SAXReader;
public class Dom4jXpath {

    public static void main(String[] args) throws Exception {
        select();//查询所有name的值
        //select2();//查询id=stu1的学生的name的值
    }
    //查询所有name的值
    private static void select() throws Exception {
        SAXReader saxReader=new SAXReader();
        Document document=saxReader.read("src/1.xml");
        List<Node>list=document.selectNodes("//name");
        for(int i=0;i<list.size();i++)
            System.out.println(list.get(i).getText());
    }
    //查询id=stu1的学生的name的值
    private static void select2() throws Exception {
        SAXReader saxReader=new SAXReader();
        Document document=saxReader.read("src/1.xml");
        Node node=document.selectSingleNode("//student[@id='stu1']/name");
        System.out.println(node.getText());
    }
}