python ssh 连接mysql

#!/usr/bin/python # -- coding: UTF-8 -- from bs4 import BeautifulSoup import pymysql import re from urllib import urlopen import requests import json import math from sshtunnel ...

BeautifulSoup处理空行

def bs_preprocess(html): """remove distracting whitespaces and newline characters""" pat = re.compile('(^[\s]+)|([\s]+$)', re.MULTILINE) html = re.sub(pat, '', html) # remove l....

2018/10/27 17:30
813
sql 判断连续数字

设表名为TABLENAME,字段名为FIELD1则: SELECT FIELDN = FIELD1 FROM TABLENAME WHERE NOT EXISTS ( SELECT FIELD1 FROM TABLENAME A WHERE A.FIELD1 = tablename.field1 + 1 ) UNION SELECT...

2018/10/09 23:45
2K
Mysql 主从复制

master配置 server-id=1 log-bin=mysql-bin log-bin-index=binlog.index #binlog_format=statement general_log_file = mysql.log general_log = 1 binlog-do-db = youxia 2.master 创建用户...

2018/10/06 21:12
62
MySQL增加新用户

1.CREATE USER 'json'@'localhost' IDENTIFIED BY '123456'; 2.GRANT ALL PRIVILEGES ON * . * TO 'json'@'localhost'; 3.FLUSH PRIVILEGES; 4.use mysql; 5.update user set Host='%' where...

2018/10/06 10:44
87
update 多表

UPDATE base_teacher_attendance_schedule JOIN base_attendance_setting_record ON base_teacher_attendance_schedule.recordsettingid = base_attendance_setting_record.id SET base_teac...

2018/09/18 16:36
108
Qualifier

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager" > <property name="dataSource" ref="dataSource"/> <qualifier va...

2018/09/16 00:19
60
spring mvc test

import org.junit.Before; import org.junit.Test; import org.junit.runner.RunWith; import org.mockito.Mockito; import org.springframework.beans.factory.annotation.Autowired; impor...

poi comment

public static void main(String[] args) { try (FileOutputStream out = new FileOutputStream("/Users/chanming/work_note/abc.xls")) { HSSFWorkbook wb = new HSSFWorkbook(); ......

POI
2018/08/26 23:16
509
poi 复制

package cn.thinkjoy.kidscare.utils; import java.util.HashMap; import java.util.Map; import org.apache.poi.hssf.usermodel.*; import org.apache.poi.hssf.util.CellRangeAddress; imp...

POI
2018/08/26 23:14
152
抽象类和接口的区别

  1. 抽象类可以提供成员方法的实现细节,而接口中只能存在public abstract 方法;   2. 抽象类中的成员变量可以是各种类型的,而接口中的成员变量只能是public static final类型的;  ...

2018/07/27 08:24
20
MySQL 获取不同字段最大值最小值

GREATEST LEAST 两个函数

2018/07/25 08:09
2.3K
Spring上下文

Spring 自带了多种类型的的应用上下文。下面罗列的几个是你最有可能遇到的。 AnnotationConfigApplicationContext:从一个或多个基于Java的配置类中加载Spring应用上下文章。 AnnotationConf...

2018/07/24 22:05
77
springMVC的流程

1.用户发送请求至前端控制器DispatcherServlet 2.DispatcherServlet收到请求调用HandlerMapping处理器映射器。 3.处理器映射器根据请求url找到具体的处理器,生成处理器对象及处理器拦截器(...

2018/07/24 00:46
84
Java 后台判断是否为ajax请求

/**    * 是否是Ajax请求    * @param request    * @return    */   public static boolean isAjax(ServletRequest request){     return "XMLHttpRequest".equalsIgnoreCase(((HttpServletReques...

2018/06/18 11:43
362
mysql 1067 invalid default value for

在执行的sql第一句加上 set sql_mode = '';

2018/06/13 16:48
405

没有更多内容

加载失败,请刷新页面