masuwen博客

原创 mac redis自启动,启动,launchctl list |grep redis

1，将redis的启动文件放到shell脚本中执行sudo vi redis-launchd.sh#! /bin/sh#! 备注,把redis安装目录里的 redis-server 和 redis.conf 分别复制到 bin 和 etc 目录,如果没有目录 则新建/usr/local/redis-4.0.14/bin/redis-server /usr/local/red...

原创 java解析日志文件,转为json数组,new Throwable() .getStackTrace()[0].getClassName()使用

此类包括获取上一天日志方法, 关闭文件流方法技术点:JSONObject.fromObject('字符串');JSONArray.add(JSONObject.fromObject('字符串'));package com.log;import net.sf.json.JSONArray;import net.sf.json.JSONObject;import org....

原创 MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk

MISCONF Redis is configured to save RDB snapshots, but it is currently not able to persist on disk. Commands that may modify the data set are disabled, because this instance is configured to report er...

原创 mysql模式匹配, 查找名称包含5个字符的动物, 表数据sql在上一篇文章里

-- 要查找包含五个字符的名称SELECT * FROM pet WHERE name LIKE '_____'-- Claws Gwen cat m 1994-03-17 NULL--查询名称以b开头的动物SELECT * FROM pet WHERE name REGEXP '^b';-- 查找名称以fy结束的动物SELECT * FROM pet WHERE name...

原创 查询动物的出生日期,名称, 年龄(以年为单位)

# ************************************************************# Sequel Pro SQL dump# Version 4541## Host: 127.0.0.1 (MySQL 5.7.15)# Database: menagerie# Generation Time: 2019-08-31 04:15:19 ...

原创 mac mysql5.7.17 64位dmg首次安装后修改root密码

Stop MySQLsudo /usr/local/mysql/support-files/mysql.server stopStart it in safe mode:sudo mysqld_safe --skip-grant-tablesThis will be an ongoing command until the process is finished so open an...

原创 java继承，方法重载例子

class Animal { public void move() { System.out.println("Animals can move"); }}class Dog extends Animal { public void move() { System.out.println("Dogs can walk and run"); }...

原创 在线解压工具

https://extract.me/cn/解压成功提供保存为zip文件

原创 gitignore.txt

# Windows image file cachesThumbs.dbehthumbs.db# Folder config fileDesktop.ini# Recycle Bin used on file shares$RECYCLE.BIN/# Windows Installer files*.cab*.msi*.msm*.msp# Windows shor...

原创 mysql 根据id查所有父级或子级

--查询父级SELECT T2.jgid, T2.`sjjgid` ,t2.`jgmc`FROM ( SELECT @r AS _id, (SELECT @r := sjjgid FROM `yygl_jgxx` WHERE jgid = _id) AS 2v2, @l := @l + 1 AS lvl ...

原创 Formatting Numeric Print Output

import java.util.Calendar;import java.util.Locale;public class TestFormat { public static void main(String[] args) { long n = 461012; System.out.format("%d%n", n); // --...

原创 idea mvn tomcat7:run能启动但无法访问

原创 Oracle提示错误消息 ORA-28001: the password has expired

Oracle提示错误消息 ORA-28001: the password has expired，是由于Oracle11G的新特性所致，Oracle11G创建用户时缺省密码过期限制是180天（即6个月），如果超过180天用户密码未做修改则该用户无法登录。Oracle公司是为了数据库的安全性默认在11G中引入了这个默认功能，但是这个默认的功能很容易被DBA或者是开发人员给疏忽，一旦...

原创 tomcat配置https(二)

cd /tomcat7/conf/service.xml中1. 注释掉 8080 的 连接端口      如:       <!-- <Connector port="8080" protocol="HTTP/1.1"               connectionTimeout="20000"               redirectPort="8443" ...

原创 Mac java keytool生成 https证书(一)

java keytool http://www.kafeitu.me/sso/2010/11/05/sso-cas-full-course.html 1.keytool -genkey -alias wsria -keyalg RSA -keystore /Users/mac/documents/wsriakey  2 .  keytool -expor...

原创 Unable to open debugger port (127.0.0.1:51202): java.net.SocketException "Socket closed"

idea 启动项目, 报的  端口占用,连接关闭, 重启电脑也不管用, 比如出现以下问题:Unable to open debugger port (127.0.0.1:51202): java.net.SocketException "Socket closed" 解决办法:mac 系统编辑您的  sudo vim /etc/hosts一定把 127.0.0.1    l...

原创 opensaml.pom,opensaml1.1b无法下载

<?xml version="1.0" encoding="UTF-8"?><project> <modelVersion>4.0.0</modelVersion> <groupId>opensaml</groupId> <artifactId>opensaml

原创 mac os 安装redis

Download, extract and compile Redis with:$ wget http://download.redis.io/releases/redis-5.0.3.tar.gz$ tar xzf redis-5.0.3.tar.gz$ cd redis-5.0.3$ makeThe binaries that are now compiled are ava...

原创 Intellij IDEA 一个Tomcat启动多个Web的设置

第一步: 打开idea 配置  增加多个tomcat, 注意:tomcat可复制,但把3个端口改掉,  启动端口, 链接端口,JPA端口)第二步骤: 应用配置tomcat多端口第三步:打开项目结构,如图:最后点击 OK如果部署多个tomcat端口,依次重复上面三步. 备注:springboot就不要这么配置了....

原创 windows C盘生成ssh,并上传到glthub上.

进入c:盘 user/administrator1、新建文件夹，最好为英文名project2、进入文件夹，空白处右键，选择gitbash here,键入git init会生成.git文件（如果没有，或许被隐藏了，无关紧要）3、配置本地仓库的账号邮箱git$ git config --global user.name "nademo"$ git config --global...

原创 mysql游标应用

BEGINDECLARE a,b,c VARCHAR(32);DECLARE IS_FOUND INT;DECLARE cur1 CURSOR FOR SELECT id, paper_name,paper_fraction FROM examination_paper;DECLARE CONTINUE HANDLER FOR NOT FOUND SET IS_FOUND=0;...

原创 mysql insert into 例子

INSERT into examination_score_info (student_code,student_name,class_id,class_name)  SELECT student_id,paper_id,score from e功能说明: 把一个表的字段查询出来插入到另外一个表中 ....

原创 Jquery table rowspan，jquery合并表格中的单元格

<!DOCTYPE html><html><head><meta charset="utf-8"><title></title><script src="js/jquery.min.js"></script><styl

原创 E230001: Server SSL certificate verification failed: certificate issued for a different hostname, is

idea更新项目报E230001: Server SSL certificate verification failed: certificate issued for a different hostname, issuer is not trusted错误. 解决办法: 用TortoiseSVN, 执行下checkout, 会提示输入svn账号 , 密码, 选择第一个(大概意思:永久保存), ...

原创 [Err] 1221 - Incorrect usage of UNION and LIMIT

遇到这个问题,与mysql版本有关, 5.5 能通过,5.7通不过;解决办法: 把 limit 放在order by后面, limit 不要与 union 出现在同一个位置.

原创 sql injection violation, comment not allow, mybatis,mysql,诡异的错误. sql语句可以执行,但是用mybatis操作就报错.

//读取数据库配置 loadPropertyFile("classes/config/mysql.properties"); DruidPlugin dp = new DruidPlugin(getProperty("jdbcUrl"),getProperty("user"),getProperty("password")); //WallFilter wall = new WallFi...

原创 Array与List互转的正确写法

// list -> array，构造数组时不需要设定大小String[] array = (String[])list.toArray(); //WRONG;String[] array = list.toArray(new String[0]); //RIGHTString[] array = list.toArray(new String[list.size()]); //RIG...

原创 linux idea 链接svn的时候报错: Server certificate verification failed: issuer is not trusted

can you try to run svn checkout once manually to your URL https://yoururl/trunk C:\ant-1.8.1\Test_Checkout using command line and accept certificate.

原创 java log4j配置

# Output pattern : date [thread] priority category - messagelog4j.rootLogger= INFO , Console,RollingFileInfo,RollingFileErr#设置每天生成一个文件名后添加的名称,备份名称：年月日.log#log4j.appender.dailyFile.DatePattern='.'y...

原创 多个tomcat启动,走classpath默认的解决方法

在tomcat/bin 目录下  找到 start.bat文件 ;找到  setlocal , 加入set java_home,set catalina_homesetlocalset JAVA_HOME=E:\Program Files\Java\jdk1.7.0_75set CATALINA_HOME=E:\apache-tomcat-7.0.59-8098...

原创 Error “can't use subversion command line client : svn” when opening android project checked out from

把默认的svn改为 D:\Program Files\TortoiseSVN\bin\svn.exe              最后点OK

原创 js css鼠标悬停显示下拉菜单

<div class="swss_xx"> <ul class="clearfix"> <li id="xxwh"><a href="#" onclick="javascript:studentInfoUpdate()">个人信息维护&

原创 Java正则表达式过滤出字母

public class Test { public static void main(String[] args) throws Exception { // 替换 将4个或4个以上的连续的数字替换成* String str="wei232123jin234"; String ragex = "\\d{4,}"; Strin...

原创 Oracle INSERT INTO SELECT

INSERT INTO target_table (col1, col2, col3)SELECT col1, col2, col3FROM source_tableWHERE condition;

原创 SELECT INTO using Oracle

If NEW_TABLE already exists then ...insert into new_table select * from old_table/If you want to create NEW_TABLE based on the records in OLD_TABLE ...create table new_table as select * from old...

原创 java比较2个list是否相等

public boolean equalList(List list1, List list2) { if (list1.size() != list2.size()) return false; for (Object object : list1) { if (!list2.contains(object)) return false; } return t...

原创 list grouping

import java.util.*;public class Grouping { /** * @param args the command line arguments */ public static void main(String[] args) { List<Student> studlist = new Arr...

原创 java 日期过期比较

public class LicenseVerifier { public static void main(String[] args) { try { DateFormat DATE_FORMAT = new SimpleDateFormat("MM/dd/yyyy"); ...

原创 Usage: catalina.sh ( commands ... ) ./start.sh

 怎么会出现这个界面了,tomcat启动不了

原创 eclipse debug配置

--vm argarmsn-server -Xms512m -Xmx512m -XX:NewSize=128m -XX:MaxNewSize=256m -XX:MaxPermSize=512m -Xss4096k