Haiyoung

Redis的数据结构字符串 String字符串列表 list字符串集合 set有序字符串集合 sorted set哈希 hash常用命令设置值set [key] [value]先获取再设置getset [key] [value]获取值get  

ppt中部分图片来自于网络，侵删。

org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.异常堆栈信息参考问题、解决办法及建议org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend...

postgreSqlpostgreSql 自增主键计数器重置postgreSql数据库中 表的自增主键映射 JPApostgresql数据库json字段查询postgresql多表联合批量更新postgreSQL分页查询SQL查看postgresql当前连接postgreSqlpostgreSql 自增主键计数器重置select setval('table_name...

配置druid连接池的内置监控统计功能打开监控统计功能配置StatViewServlet监控页面展示配置druid连接池的内置监控统计功能打开监控统计功能Druid的监控统计功能是通过filter-chain扩展实现，如果你要打开监控统计功能，配置StatFilter，具体如下所示<!-- 数据库连接 --> <bean id="dataBas...

org.springframework.data.mapping.MappingException: Map key xxx.yyyyy contains dots but no replacement was configured!当map中key包含 "." 时，默认会抛出异常,需要显示的配置替换策略，可以在数据源配置里设置mapKeyDotReplacement的值org.sprin...

spring data mongo Aggregation 聚合查询 子文档过滤对文档的values字段按照时间进行过滤原始文档{ "_id" : ObjectId("5ad43fbdbe65d9168fe22a6d"), "key" : "test", "values" : [ { "p" : 20.3199

初始化一个web项目mybatis_test，pom文件如下所示：pom.xml文件<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...

antlr.MismatchedTokenException: expecting CLOSE, found 'null'Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1, column 335[from actor a where a.latestV...

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace

update table_p as p set p_name = a.name,p_user = a.user_id,p_type = 'P02'from (select x.user_id,x.name,x.p_id from table_u xjoin table_p y on x.p_id = y.p_id) as a where p.p_id = a.p_id;ps: 试了好几种...

select x.variable::json->>'imageId' as imageId, x.status, y.image_name from task x join image y on x.variable::json->>'imageId' = y.image_idwhere x.variable::json->>'imageId' is no...

插入测试数据：package com.haiyoung.biz;import org.bson.Document;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.data.mongodb.core.MongoTemplate;import org.spring...

from pymongo import MongoClientimport psycopg2import datetimeimport randomimport osos.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'import sysfrom decimal import *def get_date(days):...

---sqlselect concat('insert into user(user_id,user_name,pswd) values(','''',user_id,''',','''',user_name,''',','''',pswd,'''',');') from user;---result| insert into user(user_id,user_name,pswd) v

下载好mongodb-linux-x86_64-ubuntu1604-3.4.10.tgz并解压到 /usr/local/mongodb在根目录下创建路径 /data/db$ sudo mkdir -p /data/db$ export PATH= /usr/local/mongodb/bin:$PATH $ mongod $ mongo 运行报错如下所示： $ ...

Mac Mysql 忘记密码后重置登录密码进入终端输入：cd /usr/local/mysql/bin/关闭mysql服务 ./mysql.server stop回车后 登录管理员权限 sudo su回车后输入以下命令来禁止mysql验证功能 ./mysqld_safe --skip-grant-tables &回车后mysql会自动重启（偏好设置中mysql的状态会变成ru...