import java.io.FileInputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class InsertTextFileToMySQL {
  public static Connection getConnection () throws Exception {
    String driver = "org.gjt.mm.mysql.Driver" ;
    String url = "jdbc:mysql://localhost/databaseName" ;
    String username = "root" ;
    String password = "root" ;
    Class .forName ( driver ) ;
    Connection conn = DriverManager.getConnection ( url, username, password ) ;
    return conn;
  }
  public static void main ( String [] args ) throws Exception {
    String id = "001" ;
    String fileName = "fileName.txt" ;
   Â
    FileInputStream fis = null ;
    PreparedStatement pstmt = null ;
    Connection conn = null ;
    try {
      conn = getConnection () ;
      conn.setAutoCommit ( false ) ;
      File file = new File ( fileName ) ;
      fis = new FileInputStream ( file ) ;
      pstmt = conn.prepareStatement ( "insert into DataFiles(id, fileName, fileBody) values (?, ?, ?)" ) ;
      pstmt.setString ( 1 , id ) ;
      pstmt.setString ( 2 , fileName ) ;
      pstmt.setAsciiStream ( 3 , fis, ( int ) file.length ()) ;
      pstmt.executeUpdate () ;
      conn.commit () ;
    } catch ( Exception e ) {
      System.err.println ( "Error: " + e.getMessage ()) ;
      e.printStackTrace () ;
    } finally {
      pstmt.close () ;
      fis.close () ;
      conn.close () ;
    }
  }
}
1. oncontextmenu="window.event.returnValue=false" ž®†å½»åº•å±è”½é¼ æ ‡å³é”?br /><table border oncontextmenu=return(false)><td>no</table> å¯ç”¨äºŽTable
2. <body onselectstart="return false"> å–消选å–ã€é˜²æ¢å¤åˆ?br />
3. onpaste="return false" ä¸å‡†¾_˜è„“
4. oncopy="return false;" oncut="return false;" 防æ¢å¤åˆ¶
5. <link rel="Shortcut Icon" href="favicon.ico"> IE地å€æ å‰æ¢æˆè‡ªå·±çš„图æ ?/p>
6. <link rel="Bookmark" href="favicon.ico"> å¯ä»¥åœ¨æ”¶è—夹ä¸æ˜¾½Cºå‡ºä½ çš„å›¾æ ‡
7. <input style="ime-mode:disabled"> å…³é—输入æ³?/p>
8. 永远都会带ç€æ¡†æž¶
<script language="JavaScript"><!--
if (window == top)top.location.href = "frames.htm"; //frames.htm为框架网™å?br />// --></script>
9. 防æ¢è¢«ähframe
<SCRIPT LANGUAGE=JAVASCRIPT><!--
if (top.location != self.location)top.location=self.location;
// --></SCRIPT>
10. ¾|‘页ž®†ä¸èƒ½è¢«å¦å˜ä¸?br /><noscript><iframe src=*.html></iframe></noscript>
11. <input type=button value=查看¾|‘页æºä»£ç ?
onclick="window.location = "view-source:"+ "
13. å–得控äšgçš„ç»å¯¹ä½¾|?br />//Javascript
<script language="Javascript">
function getIE(e){
var t=e.offsetTop;
var l=e.offsetLeft;
while(e=e.offsetParent){
t+=e.offsetTop;
l+=e.offsetLeft;
}
alert("top="+t+"/nleft="+l);
}
</script>
//VBScript
<script language="VBScript"><!--
function getIE()
dim t,l,a,b
set a=document.all.img1
t=document.all.img1.offsetTop
l=document.all.img1.offsetLeft
while a.tagName<>"BODY"
set a = a.offsetParent
t=t+a.offsetTop
l=l+a.offsetLeft
wend
msgbox "top="&t&chr(13)&"left="&l,64,"得到控äšgçš„ä½¾|?
end function
--></script>
14. å…‰æ ‡æ˜¯åœåœ¨æ–‡æœ¬æ¡†æ–‡å—的最å?br /><script language="javascript">
function cc()
{
var e = event.srcElement;
var r =e.createTextRange();
r.moveStart("character",e.value.length);
r.collapse(true);
r.select();
}
</script>
<input type=text name=text1 value="123" onfocus="cc()">
15. 判æ–上一™å늚„æ¥æº
javascript:
document.referrer
16. 最ž®åŒ–ã€æœ€å¤§åŒ–ã€å…³é—窗å?br /><object id=hh1 classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">
<param name="Command" value="Minimize"></object>
<object id=hh2 classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">
<param name="Command" value="Maximize"></object>
<OBJECT id=hh3 classid="clsid:adb880a6-d8ff-11cf-9377-00aa003b7a11">
<PARAM NAME="Command" VALUE="Close"></OBJECT>
<input type=button value=最ž®åŒ– onclick=hh1.Click()>
<input type=button value=最大化 onclick=hh2.Click()>
<input type=button value=å…³é— onclick=hh3.Click()>
本例适用于IE
17.å±è”½åŠŸèƒ½é”®Shift,Alt,Ctrl
<script>
function look(){
if(event.shiftKey)
alert("¼›æ¢æŒ‰Shifté”?"); //å¯ä»¥æ¢æˆALT　CTRL
}
document.onkeydown=look;
</script>
18. ¾|‘页ä¸ä¼šè¢«ç¼“å?br /><META HTTP-EQUIV="pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Cache-Control" CONTENT="no-cache, must-revalidate">
<META HTTP-EQUIV="expires" CONTENT="Wed, 26 Feb 1997 08:21:57 GMT">
或�lt;META HTTP-EQUIV="expires" CONTENT="0">
|
19.æ€Žæ ·è®©è¡¨å•æ²¡æœ‰å‡¹å‡¸æ„ŸåQ?br /><input type=text style="border:1 solid #000000"> 20.<div><span>&<layer>的区别？ 21.让弹出窗å£æ€ÀL˜¯åœ¨æœ€ä¸Šé¢: 22.ä¸è¦æ»šåŠ¨æ? 23.æ€Žæ ·åŽÀLŽ‰å›„¡‰‡é“¾æŽ¥ç‚¹å‡»åŽï¼Œå›„¡‰‡å‘¨å›´çš„虚¾U¿ï¼Ÿ 24.电åé‚®äšg处ç†æäº¤è¡¨å• 25.在打开的å½H—å£åˆäh–°çˆ¶çª—å£çš„代ç 里如何写åQ?br />window.opener.location.reload() 26.如何讑֮šæ‰“å¼€™åµé¢çš„大ž®?br /><body onload="top.resizeTo(300,200);"> 27.在页é¢ä¸å¦‚ä½•åŠ å…¥ä¸æ˜¯æ»¡é“ºçš„背景图ç‰?拉动™åµé¢æ—¶èƒŒæ™¯å›¾ä¸åŠ¨ 28. ‹‚€æŸ¥ä¸€ŒDµå—½W¦ä¸²æ˜¯å¦å…¨ç”±æ•°å—¾l„æˆ 29. 获得一个窗å£çš„å¤§å° 30. 怎么判æ–是å¦æ˜¯å—½W?br />if (/[^/x00-/xff]/g.test(s)) alert("å«æœ‰æ±‰å—"); 31.TEXTAREA自适应文å—行数的多ž®?br /><textarea rows=1 name=s1 cols=27 onpropertychange="this.style.posHeight=this.scrollHeight"> 32. 日期å‡åŽ»å¤©æ•°½{‰äºŽ½W¬äºŒä¸ªæ—¥æœ?br /><script language=Javascript> 33. 选择了哪一个Radio 34.脚本æ°æ€¸å‡ºé”™ 35.ENTERé”®å¯ä»¥è®©å…‰æ ‡¿UÕdˆ°ä¸‹ä¸€ä¸ªè¾“入框 |
|
36. ‹‚€‹¹‹æŸä¸ªç½‘站的链接速度åQ?br />把如下代ç åŠ å…?lt;body>区域ä¸? onclick=window.open(this.form.url"+i+".value)><br>") onerror=auto("http://"+autourl+"")>")} 37. å„ç§æ ·å¼çš„å…‰æ ?br />auto åQšæ ‡å‡†å…‰æ ?br />default åQšæ ‡å‡†ç®å¤?br />hand åQšæ‰‹å½¢å…‰æ ?br />wait åQšç‰å¾…å…‰æ ?br />text åQšI形光æ ?br />vertical-text åQšæ°´òq³I形光æ ?br />no-drop åQšä¸å¯æ‹–动光æ ?br />not-allowed åQšæ— 效光æ ?br />help åQ?å¸®åŠ©å…‰æ ‡ 38.™åµé¢˜q›å…¥å’Œé€€å‡ºçš„ç‰ÒŽ•ˆ 40.¾|‘页是å¦è¢«æ£€ç´?br /><meta name="ROBOTS" content="属性å€?> |
]]>
1ã€è®¤è¯†Cron
cron是一个linux下的定时执行工具åQŒå¯ä»¥åœ¨æ— 需人工òq²é¢„的情况下˜q行作业。由于Cron 是Linux的内¾|®æœåŠ¡ï¼Œä½†å®ƒä¸è‡ªåŠ¨è“væ¥ï¼Œå¯ä»¥ç”¨ä»¥ä¸‹çš„æ–ÒŽ³•å¯åŠ¨ã€å…³é—这个æœåŠ¡ï¼š
/sbin/service crond start //å¯åŠ¨æœåŠ¡
/sbin/service crond stop //å…³é—æœåŠ¡
/sbin/service crond restart //é‡å¯æœåŠ¡
/sbin/service crond reload //é‡æ–°è½½å…¥é…ç½®
ä½ ä¹Ÿå¯ä»¥ž®†è¿™ä¸ªæœåŠ¡åœ¨¾pÈ»Ÿå¯åŠ¨çš„时候自动å¯åŠ¨ï¼š
åœ?etc/rc.d/rc.local˜q™ä¸ªè„šæœ¬çš„末ž®‘ÖŠ 上：
/sbin/service crond start
2ã€CronæœåŠ¡
1)直接用crontab命ä×o¾~–辑
cronæœåŠ¡æä¾›crontab命ä×oæ¥è®¾å®šcronæœåŠ¡çš„，以下是这个命令的一些å‚æ•îC¸Žè¯´æ˜ŽåQ?/p>
crontab -u //讑֮šæŸä¸ªç”¨æˆ·çš„cronæœåŠ¡åQŒä¸€èˆ¬root用户在执行这个命令的时候需è¦æ¤å‚æ•°
crontab -l //列出æŸä¸ªç”¨æˆ·cronæœåŠ¡çš„详¾l†å†…å®?/p>
crontab -r //åˆ é™¤æ²¡ä¸ªç”¨æˆ·çš„cronæœåŠ¡
crontab -e //¾~–辑æŸä¸ªç”¨æˆ·çš„cronæœåŠ¡
比如说root查看自己的cron讄¡½®åQšcrontab -u root -l
å†ä¾‹å¦‚，root惛_ˆ 除fredçš„cron讄¡½®åQšcrontab -u fred -r
在编辑cronæœåŠ¡æ—Óž¼Œ¾~–辑的内å®ÒŽœ‰ä¸€äº›æ ¼å¼å’Œ¾U¦å®šåQŒè¾“入：crontab -u root -e
åQˆæ³¨åQšå¤§å“¥å¤§å§ï¼Œçœ‹æ–‡ç« 时别忘记关注我哟，嘿嘿åQ?/font>˜q›å…¥vi¾~–辑模å¼åQŒç¼–辑的内容一定覽W¦åˆä¸‹é¢çš„æ ¼å¼ï¼š*/1 * * * * ls >> /tmp/ls.txt
˜q™ä¸ªæ ¼å¼çš„å‰ä¸€éƒ¨åˆ†æ˜¯å¯¹æ—‰™—´çš„设定，åŽé¢ä¸€éƒ¨åˆ†æ˜¯è¦æ‰§è¡Œçš„命令，如果è¦æ‰§è¡Œçš„命ä×o太多åQŒå¯ä»¥æŠŠ˜q™äº›å‘½ä×o写到一个脚本里é¢ï¼Œç„¶åŽåœ¨è¿™é‡Œç›´æŽ¥è°ƒç”¨è¿™ä¸ªè„šæœ¬å°±å¯ä»¥äº†ï¼Œè°ƒç”¨çš„时候记得写出命令的完整路径。时间的讑֮šæˆ‘们有一定的¾U¦å®šåQŒå‰é¢äº”ä¸?å·ä»£è¡¨äº”个数å—，数å—çš„å–å€ÆDŒƒå›´å’Œå«ä¹‰å¦‚下åQ?/p>
分钟　åQ?-59åQ?/p>
ž®æ™‚　åQ?-23åQ?/p>
日期　åQ?-31åQ?/p>
月䆾　åQ?-12åQ?/p>
星期　åQ?-6åQ?/0代表星期å¤?/p>
除了数嗘q˜æœ‰å‡ 个个特ŒDŠçš„½W¦å·ž®±æ˜¯"*"ã€?/"å’?-"ã€?,"åQ?代表所有的å–å€ÆDŒƒå›´å†…çš„æ•°å—，"/"代表æ¯çš„æ„æ€?"*/5"表示æ¯?个å•ä½ï¼Œ"-"代表从æŸä¸ªæ•°å—到æŸä¸ªæ•°å—,","åˆ†å¼€å‡ ä¸ª¼›ÀL•£çš„æ•°å—。以下ä‹Då‡ ä¸ªä¾‹å说明问题åQ?/p>
æ¯å¤©æ—©ä¸Š6ç‚?/p>
0 6 * * * echo "Good morning." >> /tmp/test.txt //注æ„å•çº¯echoåQŒä»Žå±å¹•ä¸Šçœ‹ä¸åˆ°ä»ÖM½•è¾“出åQŒå› 为cron把ä“Q何输出都email到rootçš„ä¿¡½Ž×ƒº†ã€?/p>
æ¯ä¸¤ä¸ªå°æ—?/p>
0 */2 * * * echo "Have a break now." >> /tmp/test.txt
晚上11点到早上8点之间æ¯ä¸¤ä¸ªž®æ—¶åQŒæ—©ä¸Šå…«ç‚?/p>
0 23-7/2åQ? * * * echo "Have a good dreamåQšï¼‰" >> /tmp/test.txt
æ¯ä¸ªæœˆçš„4å·å’Œæ¯ä¸ª½C¼æ‹œçš„礼拜一到礼拜三的早ä¸?1ç‚?/p>
0 11 4 * 1-3 command line
1�日早��/p>
0 4 1 1 * command line
æ¯æ¬¡¾~–辑完æŸä¸ªç”¨æˆïLš„cron讄¡½®åŽï¼Œcron自动åœ?var/spool/cron下生æˆä¸€ä¸ªä¸Žæ¤ç”¨æˆ·åŒåçš„æ–‡äšgåQŒæ¤ç”¨æˆ·çš„cronä¿¡æ¯éƒ½è®°å½•åœ¨˜q™ä¸ªæ–‡äšgä¸ï¼Œ˜q™ä¸ªæ–‡äšg是ä¸å¯ä»¥ç›´æŽ¥¾~–辑的，åªå¯ä»¥ç”¨crontab -e æ¥ç¼–辑。cronå¯åŠ¨åŽæ¯˜q‡ä¸€ä»½é’Ÿè¯ÖM¸€‹Æ¡è¿™ä¸ªæ–‡ä»Óž¼Œ‹‚€æŸ¥æ˜¯å¦è¦æ‰§è¡Œé‡Œé¢çš„å‘½ä»¤ã€‚å› æ¤æ¤æ–‡äšg修改åŽä¸éœ€è¦é‡æ–°å¯åŠ¨cronæœåŠ¡ã€?/p>
åQˆæœ‰äº†ä½ 们的å…Ïx³¨åQŒæ‰æœ‰æˆ‘¾l§ç®‹å†™ä¸‹åŽÈš„动力åQ）è¯ïL‚¹ä¸‹é¢çš„广告å§åQ?/font>
2)¾~–辑/etc/crontab æ–‡äšgé…ç½®cron
cronæœåŠ¡æ¯åˆ†é’Ÿä¸ä»…è¦è¯ÖM¸€‹Æ?var/spool/cron内的所有文ä»Óž¼Œ˜q˜éœ€è¦è¯»ä¸€‹Æ?etc/crontab,å› æ¤æˆ‘们é…ç½®˜q™ä¸ªæ–‡äšg也能˜q用cronæœåŠ¡åšä¸€äº›äº‹æƒ…。用crontabé…置是针å¯ÒŽŸä¸ªç”¨æˆïLš„åQŒè€Œç¼–è¾?etc/crontab是针对系¾lŸçš„ä»ÕdŠ¡ã€‚æ¤æ–‡äšgçš„æ–‡ä»¶æ ¼å¼æ˜¯åQ?/p>
SHELL=/bin/bash
PATH=/sbin:/bin:/usr/sbin:/usr/bin
MAILTO=root //如果出现错误åQŒæˆ–者有数æ®è¾“出åQŒæ•°æ®ä½œä¸ºé‚®ä»¶å‘¾l™è¿™ä¸ªå¸å?br />HOME=/ //使用者è¿è¡Œçš„路径,˜q™é‡Œæ˜¯æ ¹ç›®å½•
# run-parts
01 * * * * root run-parts /etc/cron.hourly //æ¯å°æ—¶æ‰§è¡?etc/cron.hourly内的脚本
02 4 * * * root run-parts /etc/cron.daily //æ¯å¤©æ‰§è¡Œ/etc/cron.daily内的脚本
22 4 * * 0 root run-parts /etc/cron.weekly //æ¯æ˜ŸæœŸæ‰§è¡?etc/cron.weekly内的脚本
42 4 1 * * root run-parts /etc/cron.monthly //æ¯æœˆåŽÀL‰§è¡?etc/cron.monthly内的脚本
3ã€å®žä¾?/p>
我在/etc/crontab æ–‡äšgä¸é…¾|®cronåQ?/p>
#product price trend picture
0 1 * * * root sh /home1/picture/myconfig.sh   åQˆæ¯å¤?ç‚šw’Ÿæ—¶æ‰§è¡Œroot用户ä¸çš„/home1/picture/myconfig.sh åQ?/p>
我的myconfig.shåQ?/p>
JAVA_HOME=/home1/jdk1.5.0_03;export JAVA_HOME
JAVA_OPTS="-server -Djava.awt.headless=true";export JAVA_OPTSÂ
åQˆç”±äºŽæˆ‘的应用是一个绘囑ֺ”用，所以è¦ä»¥ä¸Šä¸¤æ®µåQŒæŒ‡å®šJDK½{‰ï¼‰
cd /home1/picture/lib åQˆæŒ‡å®šæˆ‘çš„JARæ–‡äšg所在ä½åQ?br />/home1/jdk1.5.0_03/bin/java -cp /home1/picture/lib/PriceTrendPicture.jar:/home1/picture/lib/classes12.jar:/home1/picture/lib/ibatis-common-2.jar:/home1/picture/lib/ibatis-dao-2.jar:/home1/picture/lib/ibatis-sqlmap-2.jar:log4j-1.2.8.jar:/home1/picture/lib/xmlparserv2.jar:/home1/picture/lib/commons-logging.jar com.yesky.run.PriceTrendPicture
/home1/jdk1.5.0_03/bin/java -cp ˜q™æ˜¯æˆ‘çš„JDKä½ç½®Â éšåŽåŠ 上所有ä‹É用的JARæ–‡äšg 最åŽæ˜¯æœ‰main()的执行类
   那如何实现在™åµé¢çš„JavaScriptä¸ä‹É用jspä¸çš„æ•°æ®æˆ–是在jspä¸ä‹É用页é¢çš„JavaScriptæ•°æ®å‘¢ï¼Ÿ
一ã€é¡µé¢ä¸çš„JavaScriptçš„æ•°æ®å¦‚何æ交给åŽå°çš„jsp½E‹åº
   â‘?å¯ä»¥ž®†JavaScriptçš„æ•°æ®ä»¥xxx.JSP?var1=aaa&var2=bbbçš„åÅžå¼ä½œä¸ºURLçš„å‚æ•îC¼ ¾l™JSP½E‹åºåQŒæ¤æ—¶åœ¨jspä¸ç”¨
<%String strVar1=request.getParameter("var1");%>ž®±å¯ä»¥èŽ·å–到JavaScriptè„šæœ¬ä¼ é€’è¿‡æ¥çš„æ•°æ®åQ?
   â‘?使用JavaScript通过在表å•é‡ŒåŠ å…¥éšè—域信æ¯ï¼Œç„¶åŽç”¨è¡¨å•æ交的方å¼æŠŠæ•°æ®ä¼ 递给JSP½E‹åºã€?
Â
Â
二ã€é¡µé¢ä¸çš„JavaScriptçš„æ•°æ®å¦‚何ä‹É用åŽå°çš„JSP½E‹åºçš„æ•°æ?
   ˜q™ä¸ªæ¯”较½Ž€å•ï¼Œç›´æŽ¥åœ¨JavaScript脚本ä¸ç”¨<%åQstrVar1%>ž®±å¯ä»¥æŠŠjsp½E‹åºä¸çš„æ•°æ®ä¼ 递给JavaScript脚本使用了ã€?
三ã€å‚考下é¢ä¾‹å：
1ã€test.jsp
<%@ page contentType="text/html; charset=gb2312" %>
<%
 String s1="Hello ";
 String s2="World!!";
%>
<script language="JavaScript">
<!--
/***************************************************************
* JavaScript脚本åQŒæ”¾¾|®åœ¨™åµé¢ä¸çš„ä»ÖM½•ä½ç½®éƒ½å¯ä»?
* insertclick()函数获å–JSPä¼ é€’åˆ°™åµé¢ä¸çš„å˜é‡s1åQ?
* 然厞®±å¯ä»¥åœ¨JavaScriptä¸ä¿®æ”¹è¿™ä¸ªå˜é‡çš„å€û|¼Œå†é€šè¿‡
* postçš„æ–¹å¼æ交给JSP½E‹åºæ¥ä‹É用ã€?
***************************************************************/
function insertclick(){
 var1 ="<%=s1 %>";
 document.forms["insertForm"].mc.value = var1 + document.forms["insertForm"].mc.value ;
 document.insertForm.submit();
}
//-->
</script>
<!-- html™åµé¢form表å•åQŒæ”¾¾|®åœ¨html™åµé¢ä¸çš„ä½ç½®ä¸é™ -->
<form name="insertForm" method="post" action="get.jsp">
<!-- 下题q™ä¸€å¥æ˜¯èŽ·å–JSP½E‹åºä¸ä¼ 递过æ¥çš„å˜é‡å€?-->
<input type="hidden" name="mc" value="<%=s2 %>">
<input type="button" value="æ交" onclick="insertclick()">
</form>
2ã€get.jsp
<%
 String strVar1=request.getParameter("mc");
 out.print(strVar1);
%>
AS
declare @actionid integer
declare @mid varchar(100)
declare @service_id varchar(100)
declare case1   cursor forÂ
   SELECT mid,service_id from bird_user_2006_03 where type=0Â
declare case2   cursor forÂ
   SELECT mid,service_id from bird_user_2006_03 where type=1
Â
open case1
 fetch next from case1 into @mid,@service_id
 while (@@fetch_status=0)
   begin
       select top 1 @actionid=bb.actionid from operation_temp_0526 as bb
              where bb.serviceid=@service_id and bb.mid=@mid
       order by bb.id desc
    if (@actionid=1)       Â
       insert into bird_user_2006_04(mid,service_id,type,portal_id) values(@mid,@service_id,'1','10000')
    else
        print 'ooooooo'    Â
       fetch next from case1 into @mid,@service_id
  end
deallocate case1
open case2
 fetch next from case2 into @mid,@service_id
 while (@@fetch_status=0)
   begin
       select top 1 @actionid=bb.actionid from operation_temp_0526 as bb
              where bb.serviceid=@service_id and bb.mid=@mid
       order by bb.id desc
    if (@actionid != 2)         Â
       insert into bird_user_2006_04(mid,service_id,type,portal_id) values(@mid,@service_id,'2','10000')
       fetch next from case2 into @mid,@service_id
  end
deallocate case2
GO