select * from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA = 'DBNAME' order by create_time desc;
導出數據庫
直接使用命令：
mysqldump -u root -p abc >abc.sql
然后回車輸入密碼就可以了；
mysqldump -u 數據庫鏈接用戶名 -p 目標數據庫 > 存儲的文件名
文件會導出到當前目錄下
導入數據庫（sql文件）
mysql -u 用戶名 -p 數據庫名 < 數據庫名.sql
mysql -u abc -p abc < abc.sql
注意sql文件必須在當前目錄下，如果不在當前目錄下需要在< 之后加上具體sql文件路徑
GBK: create database test2 DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
UTF8: CREATE DATABASE `test2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
DELIMITER //
CREATE PROCEDURE proc_tmp()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE product_Id VARCHAR(255);
DECLARE yuanliao VARCHAR(255);
DECLARE miaoshu VARCHAR(255);
DECLARE shazhi VARCHAR(255);
DECLARE midu VARCHAR(255);
DECLARE mf VARCHAR(255);
DECLARE zuzhi VARCHAR(255);
DECLARE quality VARCHAR(255);
DECLARE shuliang VARCHAR(255);
DECLARE jiage VARCHAR(255);
DECLARE price_date VARCHAR(255);
DECLARE idCur CURSOR FOR SELECT productId,yl,ylms,sz,md,fk,zz,qa,amount,price,pricedate FROM sheet1;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
OPEN idCur;
REPEAT
FETCH idCur INTO product_Id,yuanliao,miaoshu,shazhi,midu,mf,zuzhi,quality,shuliang,jiage,price_date;
IF NOT done THEN
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'yl',yuanliao,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'ylms',miaoshu,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'sz',shazhi,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'md',midu,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'fk',mf,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'zz',zuzhi,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'qa',quality,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'amount',shuliang,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'price',jiage,product_Id);
INSERT INTO static_data(model_id,dataKey,dataVal,product_id) VALUES(3,'pricedate',price_date,product_Id);
END IF;
UNTIL done END REPEAT;
CLOSE idCur;
END//
DELIMITER ;
CALL proc_tmp();
DROP PROCEDURE proc_tmp;
DELETE FROM sheet1;
定義的變量不能和select里的同名
摘要: 小編整理的“宜興市主要鄉村旅游點瓜果采摘攻略”，希望能成為您瓜果采摘的好幫手！！！農家樂聯系人手機采摘項目籬笆園農家樂黃亞云13815118337草莓5月-11月挖筍 野菜 采茶 制烏米飯3-5月桑葚 4月油桃 5月 楊梅 6月下旬-7月中下旬 葡萄 7月-9月 挖百合 8月 板栗 9月底-10月份 綠緣生態農業有限公司陳慶元13701539886挖筍 挖野菜 3-4月 ...
閱讀全文
桑葚采
摘
好去處
芳橋
1、綠大地果桑種植基地 13063669929
2、碧園春生態園 13771359607
3、張慕果園 13812203223
4、金沙灘蔬果園 13585035093
建議采摘路線：市區→東氿大道→百合大道→芳塍路往北（詳見地圖指示）
西渚
◆【1】甲有農林生態園
地址：宜興市西渚鎮張戴公路白塔村部旁（近振元南路）
◆【2】白塔云芯林果專業合作社桑葚采摘園
地址：白塔村委入口斜對面張戴公路邊
◆【3】小杭采摘園
自駕線路： 宜興——橫山水庫
◆【4】白塔瓜果基地
自駕線路：導航即到
徐舍
◆ 蘇合農產品銷售專業合作聯社
自駕線路：麥德龍——G104（行駛16.6公里）——徐舍鎮潘東村
湖?
◆【1】籬笆園農家樂
地址：宜興市湖?鎮洑西村
◆【2】金沙灣農莊
地址：宜興市湖?鎮東興村
【燒烤清單】
1‘.燒烤工具：
燒烤架、網架、木炭、燒烤叉、小毛刷、打火機、助燃劑、竹簽、牙簽、水果刀、報紙、
一次性筷、一次性碗、一次性盤、一次性隔熱手套、紙杯、餐巾紙、濕巾紙、桌布、燒烤圍裙、垃圾袋燒烤夾(夾取生食)
2.調料：
調和油、鹽、醬油、燒烤醬（汁）、辣椒粉（老干媽）、孜然、五香粉、番茄醬、芝麻、胡蘿卜醬、甜面醬、海鮮調料、大蒜、姜、蔥花、蜂蜜、
3、食品：
葷菜：雞翅、排骨、香腸、火腿腸、牛肉、羊肉、五花肉、各式魚丸肉丸、雞珍、黃花魚、秋刀魚、鯽魚、魷魚、墨魚仔、蝦等
素菜：玉米、韭菜、蘑菇、茄子、土豆、青椒、生菜（生菜包肉）、花菜、香干、臭干子、小鏝頭、年糕、面包片、棉花糖、皮蛋、胡蘿卜/黃瓜、藕片、等
水果：香蕉、木瓜、蘋果、梨、菠蘿、哈密瓜等
4、飲料：礦泉水、可樂（去油膩）、涼茶（降火）、橙汁、啤酒等
$.ajax({
url:"${base}/bosImg.xml",
dataType:"xml",
success:function(data){
$(data).find("bosPicture[wlbh='"+wlbh+"'][size='800']").find("imgs").each(function (i){
$('#showbox').empty();
$(this).children('img').each(function (ii){
$('#showbox').append('<img src="'+$(this).text()+'" width="280" height="280" />');
})
});
},
error:function(XMLHttpRequest, textStatus, errorThrown) {
alert(XMLHttpRequest.status);
alert(XMLHttpRequest.readyState);
alert(textStatus);
}
grep -rn "2002675" ./catalina.out
命令行下具體用法如下： mysqldump -u用戶名 -p密碼 -d 數據庫名 表名 腳本名;
1、導出數據庫為dbname的表結構（其中用戶名為root,密碼為dbpasswd,生成的腳本名為db.sql）
mysqldump -uroot -pdbpasswd -d dbname >db.sql;
2、導出數據庫為dbname某張表(test)結構
mysqldump -uroot -pdbpasswd -d dbname test>db.sql;
3、導出數據庫為dbname所有表結構及表數據（不加-d）
mysqldump -uroot -pdbpasswd dbname >db.sql;
4、導出數據庫為dbname某張表(test)結構及表數據（不加-d）
mysqldump -uroot -pdbpasswd dbname test>db.sql;
D:\MyDrivers\software\mysql-5.6.26-winx64\bin>mysqldump -h192.168.2.4 -uroot -p -d dy cotton>ee.sql
可以看到solr有哪些子命令，如 start, stop, restart, status, healthcheck, create, create_core, create_collection, delete, version
啟動start
bin/solr start -help 查看start幫助
bin/solr start -p 8984 指定端口啟動
bin/solr start -cloud 啟動分布式版本
bin/solr start -e cloud -noprompt -e表示要啟動一個現有的例子，例子名稱是cloud，cloud這個例子是以SolrCloud方式啟動的
bin/solr restart 重啟項目
create
如果是單機版要創建core，如果是分布式的要創建collection
bin/solr create -help 查看create幫助
abc目錄的位置創建在solr.solr.home（默認是solr的server/solr目錄）目錄下
post提交數據生成索引
bin/post -c abc docs/
向名為abc的core或collection提交數據，數據源在docs/目錄中
刪除
bin/solr delete -c abc 刪除一個core或collection
刪除索引
bin/post -c abc -d "<delete><id>/home/matthewi/software/solr-5.4.1/docs/solr-morphlines-core/allclasses-noframe.html</id></delete>"
重新執行上面的搜索可以看到搜索結果的數量少了一條：numFound列
bin/post -c abc -d "<delete><query>*:*</query></delete>"
刪除所有數據
狀態
摘要: nginx.conf配置:location / { proxy_pass http://127.0.0.1:8080/myweb/;proxy_redirect off;proxy_set_header Host $host;proxy_set_header X-Real-IP $remote_addr;proxy_set_header X-Forwarded-For $proxy_ad...
閱讀全文
package org.yla.test;
import java.net.URI;
import java.util.ArrayList;
import java.util.List;
import org.apache.commons.httpclient.HttpClient;
import org.apache.commons.httpclient.methods.GetMethod;
import org.apache.http.Header;
import org.apache.http.HttpEntity;
import org.apache.http.HttpHost;
import org.apache.http.auth.AuthScope;
import org.apache.http.auth.Credentials;
import org.apache.http.auth.UsernamePasswordCredentials;
import org.apache.http.client.CredentialsProvider;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.CloseableHttpResponse;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.BasicCredentialsProvider;
import org.apache.http.impl.client.CloseableHttpClient;
import org.apache.http.impl.client.HttpClientBuilder;
import org.apache.http.impl.client.HttpClients;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.util.EntityUtils;
import org.junit.Test;
public class HttpClientTest {
String url = "xxxxxxxxxxxxxxxxxxxxxxxxx";
String ip = "202.107.233.85";
int port = 8080;
String username = "";
String password = "";
/**
* 使用HttpClient4實現代理 202.107.233.85 8080
*
* @throws Exception
*/
@Test
public void test1() throws Exception {
HttpClientBuilder build = HttpClients.custom();
HttpHost proxy = new HttpHost(ip, port);
CloseableHttpClient client = build.setProxy(proxy).build();
HttpGet request = new HttpGet(url);
CloseableHttpResponse response = client.execute(request);
HttpEntity entity = response.getEntity();
System.out.println(EntityUtils.toString(entity));
}
/**
* 使用httpclient3實現代理
*
* @throws Exception
*/
@Test
public void test2() throws Exception {
HttpClient httpClient = new HttpClient();
httpClient.getHostConfiguration().setProxy(ip, port);
GetMethod method = new GetMethod(url);
httpClient.executeMethod(method);
String result = new String(method.getResponseBody());
System.out.println(result);
}
/**
* 使用httpclient4實現代理(帶密碼的代理)
*
* @throws Exception
*/
@Test
public void test3() throws Exception {
HttpClientBuilder build = HttpClients.custom();
CredentialsProvider credentialsProvider = new BasicCredentialsProvider();
AuthScope authscope = new AuthScope(ip, port);
Credentials credentials = new UsernamePasswordCredentials(username,
password);
credentialsProvider.setCredentials(authscope, credentials);
CloseableHttpClient client = build.setDefaultCredentialsProvider(
credentialsProvider).build();
HttpGet request = new HttpGet(url);
CloseableHttpResponse response = client.execute(request);
HttpEntity entity = response.getEntity();
System.out.println(EntityUtils.toString(entity));
}
/**
* 使用httpclient3實現代理(帶密碼的代理)
*
* @throws Exception
*/
@Test
public void test4() throws Exception {
HttpClient httpClient = new HttpClient();
org.apache.commons.httpclient.auth.AuthScope authscope = new org.apache.commons.httpclient.auth.AuthScope(
ip, port);
org.apache.commons.httpclient.Credentials credentials = new org.apache.commons.httpclient.UsernamePasswordCredentials(
username, password);
httpClient.getState().setProxyCredentials(authscope, credentials);
GetMethod method = new GetMethod(url);
httpClient.executeMethod(method);
String result = new String(method.getResponseBody());
System.out.println(result);
}
/**
* 模擬登錄官網（http://mis.pyc.com.cn??
*
* @throws Exception
*/
@Test
public void testLogin() throws Exception {
HttpClientBuilder build = HttpClients.custom();
CloseableHttpClient client = build.build();
HttpPost post = new HttpPost("http://mis.pyc.com.cn/login.aspx");
List<BasicNameValuePair> params = new ArrayList<BasicNameValuePair>();
params.add(new BasicNameValuePair("__VIEWSTATE",
"/wEPDwUJNjUwNzE0MTM4ZGQzh+vF2xGjdG8Q15kIqgR0CpxhmPucdCqZOPcglRZr/w=="));
params.add(new BasicNameValuePair(
"__EVENTVALIDATION",
"/wEWBQLYtKSdCALEhISFCwKd+7qdDgKC3IeGDAK7q7GGCOqhJpRD8S8yy3ZAlPTSsmPzRUoXMK0mQvGgzlk6hm+G"));
params.add(new BasicNameValuePair("txtName", "xxxxx"));
params.add(new BasicNameValuePair("txtPwd", "xxxxxx"));
params.add(new BasicNameValuePair("btnLogin", "xxxx"));
HttpEntity entity = new UrlEncodedFormEntity(params, "UTF-8");
post.setEntity(entity);
CloseableHttpResponse response = client.execute(post);
int statusCode = response.getStatusLine().getStatusCode();
System.err.println("狀態" + statusCode);
if (statusCode == 302) {
Header[] location = response.getHeaders("location");
String rediretUrl = null;
if (location.length == 1) {
rediretUrl = "http://mis.pyc.com.cn" + location[0].getValue();
System.err.println("跳轉地址: " + rediretUrl);
}
Header[] allHeaders = response.getAllHeaders();
System.out.println("==================response===================");
for (Header header : allHeaders) {
System.err.println(header.getName() + ": " + header.getValue());
}
Header cookieHeader = response.getFirstHeader("Set-Cookie");
String cookie = cookieHeader.getValue();
System.out.println("cookie: " + cookie);
HttpGet httpGet = new HttpGet(rediretUrl);
httpGet.addHeader("Accept",
"text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8");
// httpGet.addHeader("Accept-Encoding", "gzip, deflate, sdch");
// httpGet.addHeader("Accept-Language", "zh-CN,zh;q=0.8");
httpGet.addHeader("Connection", "keep-alive");
httpGet.addHeader("Cookie", cookie);
httpGet.addHeader("Host", "mis.pyc.com.cn");
httpGet.addHeader("Referer", "http://mis.pyc.com.cn/login.aspx");
httpGet.addHeader(
"User-Agent",
"ozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/40.0.2214.115 Safari/537.36");
response = client.execute(httpGet);
HttpEntity entity2 = response.getEntity();
System.out
.println("----------------------------------------------");
System.out.println(EntityUtils.toString(entity2));
}
}
}
一、系統環境
yum update升級以后的系統版本為
[root@yl-web yl]# cat /etc/redhat-release CentOS Linux release 7.1.1503 (Core)
二、mysql安裝
# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm # rpm -ivh mysql-community-release-el7-5.noarch.rpm # yum install mysql-community-server
安裝成功后重啟mysql服務。
初次安裝mysql，root賬戶沒有密碼。
[root@yl-web yl]# mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.6.26 MySQL Community Server (GPL) Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | test | +--------------------+ 4 rows in set (0.01 sec) mysql>
設置密碼
mysql> set password for 'root'@'localhost' =password('password'); Query OK, 0 rows affected (0.00 sec) mysql> 不需要重啟數據庫即可生效。
三、配置mysql
1、編碼
mysql配置文件為/etc/my.cnf
最后加上編碼配置
[mysql] default-character-set =utf8
這里的字符編碼必須和/usr/share/mysql/charsets/Index.xml中一致。
2、遠程連接設置
把在所有數據庫的所有表的所有權限賦值給位于所有IP地址的root用戶。
mysql> grant all privileges on *.* to root@'%'identified by 'password';
如果是新用戶而不是root，則要先新建用戶
mysql>create user 'username'@'%' identified by 'password';
此時就可以進行遠程連接了。