Hunter的大杂烩 技术学习笔记

2012-02-06

linux下tomcat7/apache2.2/mysql 5.1安装配置

Filed under: 技术话题 — hunter @ 10:51 am

参考资料:

http://www.iteye.com/topic/757125
http://www.cnblogs.com/leader_89/archive/2011/08/01/2109181.html
1. rpm -i jdk-7u2-linux-x64.rpm
2. vi  /etc/bash.bashrc
3. JAVA_HOME=/usr/java/default
CLASSPATH=/usr/java/default/lib:/usr/local/default/jre/lib
4. tar zxvf  apache-tomcat-7.0.25.tar.gz
5. mv apache-tomcat-7.0.25 /usr/local
6. cd /usr/local; ln -s apache-tomcat-7.0.25 tomcat
7. vi /etc/bash.bashrc
CATALINA_HOME=/usr/local/tomcat
8. tar zxvf commons-daemon-native.tar.gz
cd commons-daemon-1.0.8-native-src/unix
./configure  –with-java=/usr/java/default/
make
cp jsvc ../../
cd ../../
9. tar jxvf httpd-2.2.21.tar.bz2
10. cd httpd-2.2.21/
(more…)

2012-02-03

excle常用函数(不断更新中)

Filed under: 技术话题 — hunter @ 11:16 am

1. 用于处理类似(http://data.caixin.com/macro/industry_data_more.html?id=I0034#top)累积额的方法,判断下一行是否为12月,如果是则不减

=IF(ISERROR(FIND(“12月”,TEXT(A200,”yyyy年mm月”))),B199-B200,B199)

Powered by WordPress