- 浏览: 54145 次
最新评论
文章列表
create or replace procedure PRC_SUM_MAIL_EXCHANGE_HAN(p_stat_date in date) is
/** 互换局邮件及时处理率
exec PRC_SUM_MAIL_EXCHANGE_HAN(to_date('20140501','yyyyMMdd'));
**/
stat_date varchar(10);
begin
stat_date := to_char(p_stat_date, 'yyyymmdd');
-- 删除当天统计过的数据
delete from SUM_MAIL_EXC ...
1.以root 身份登录ssh 修改 /etc/hosts文件
192.168.1.1 m1
192.168.1.1 m2
192.168.1.1 m3
2. 以普通用户登录 ssh 在各个节点下
1> ssh-keygen -t rsa
2> cp id_rsa.pub authrizedkeys
3> 各个节点copy authrizedkeys 内容生成一个大文件
4> 把这个大文件copy到 ${usr.dir}/.ssh/下 覆盖原来的 authrizedkeys
...
package com.cgm.test;
import java.io.File;
import java.io.FileReader;
import java.io.IOException;
import org.apache.lucene.analysis.standard.StandardAnalyzer;
import org.apache.lucene.document.Document;
import org.apache.lucene.document.Field;
import org.apache.lucene.index.CorruptIndexException;
i ...
若出现不能访问的问题
mysql登陆问题mysql中Access denied for user 'root'@'localhost' (using password:YES)(20
mysql添加用户
mysql -uroot
show databases;
use musql;
UPDATE user SET Password=PASSWORD('123456') where USER='root';
FLUSH PRIVILEGES;
mysql 对远程客户端设置访问权限
GRANT ALL ON *.* TO admin@'%' IDENTIFIED BY 'adm ...
mongoDB
- 博客分类:
- mongoDB分组统计
1.分组
> db.student.aggregate([{$group:{_id:'$class',total:{$sum:1}}}]);
{ "_id" : 121, "total" : 3 }
{ "_id" : 122, "total" : 3 }
{ "_id" : 123, "total" : 3 }
2.分组后过滤
查出班级大于22的是哪几个班 分别是多少
db.student.aggregate([{$match:{class: ...
oracle安装 64位
- 博客分类:
- 64位oracle安装plsql
plsql的
http://jingyan.baidu.com/article/22a299b51741df9e19376a90.html
Oracle 11g 64.zip
instantclient-basic-win32-11.2.0.1.0.zip
plsqldev901.exe
mongodb学习
启动
./mongod --dbpath /home/chen1234/mongodb/local/mongodb/bin/data/db --logpath ./mongod --logpath /home/chen1234/mongodb/local/mongodb/bin/log/mongod.log --fork
增加
db.person.insert({_id:3,name:'hanmaimei',hobby:['basketball','football'],intro:{title:'my love boy' ...
excel 导出及单元格合并
- 博客分类:
- web技术
合并单元格类
public ActionForward doExport(ActionMapping mapping, ActionForm form, HttpServletRequest request,
HttpServletResponse response) throws Exception {
log.info("doExport...");
request.setAttribute("nopage", "1");
this.doQuery(mapping, form, request, respon ...
参见 http://zycp.blog.163.com/blog/static/202981060201229104747214/
package com.cgm.ws;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;
import javax.xml.ws.Endpoint;
@WebService(serviceName="MyService",targetNamespace="www.vvc.com" )
public class WS_01 {
@WebResult(name="myR ...
package com.cgm.urlws;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import sun.applet.Main;
public class App {
public static void main(String[] args) {
try {
URL url=new URL("http://192.168.111.101:6789/hello?wsdl ...
package com.cgm.clientservice;
import javax.jws.WebMethod;
import javax.jws.WebParam;
import javax.jws.WebResult;
import javax.jws.WebService;
import javax.xml.ws.RequestWrapper;
import javax.xml.ws.ResponseWrapper;
/**
* This class was generated by the JAXWS SI.
* JAX-WS RI 2.0_02-b08-fcs
* Ge ...
ajax调用webservice
- 博客分类:
- webservice技术
<html>
<head>
<title>通过ajax调用WebService服务</title>
<script>
var xhr = new ActiveXObject("Microsoft.XMLHTTP");
function sendMsg(){
var name = document.getElementById('name').value;
//服务的地址
var wsUrl = 'http://192.168.1.100:6789/hello';
...
http协议和soap协议
- 博客分类:
- webservice技术
HTTP SOAP
POST/saveUser.do HTTP/1.1 POST/saveUser.do HTTP/1.1
Content-Type:text/html;charset=utf8 Content-Type:text/xml;charset=utf8
Host:192.168.1.1 Host:192.168. ...
jsp Select 级联
- 博客分类:
- web技术
<%@page import="java.util.Map"%>
<%@page import="java.util.List"%>
<%@page contentType="text/html; charset=GBK"%>
<%@taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles"%>
<%@taglib uri="/WEB-INF/struts-nested.tld" ...