jjs_love的博客 http://blogger.org.cn/blog/blog.asp?name=jjs_love jjs_love的博客 blogger.org.cn W3CHINA Blog webmaster@blogger.org.cn <![CDATA[Setup.rul]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=24545 jjs_love 2007/5/8 14:34:46 　//===========================================================================
//
//  File Name:    Setup.rul
//
//  Description:  Blank setup main script file
//
//  Comments:     Blank setup is an empty setup project. If you want to
//      create a new project via. step-by step instructions use the
//      Project Assistant.
//
//===========================================================================

// Included header files ----------------------------------------------------
#include "ifx.h"
//#include "functions.rul"  //引入自定义函数
string ip,user,pwd;                              

//---------------------------------------------------------------------------                                                                       
// OnFirstUIBefore
//
// First Install UI Sequence - Before Move Data
//
// The OnFirstUIBefore event is called by OnShowUI when the setup is
// running in first install mode. By default this event displays UI allowing
// the end user to specify installation parameters.
//
// Note: This event will not be called automatically in a
// program...endprogram style setup.
//---------------------------------------------------------------------------
function OnFirstUIBefore()
    number  nResult, nLevel, nSize, nSetupType;
    string  szTitle, szMsg, szOpt1, szOpt2, szLicenseFile;
    string  szName, szCompany, szTargetPath, szDir, szFeatures;
    BOOL    bLicenseAccepted; 
    string  zzJdk,zzTomcat,pathTomcat,svvalue,xmlpath;  //自定义
    NUMBER  nType, nvSize;      //自定义
begin 
  
    nSetupType = COMPLETE; 
   // szDir = TARGETDIR;
   // szName = "";
    //szCompany = "";
    bLicenseAccepted = FALSE;
   
    szDir="c:\\";
    szName = "rcom";
    szCompany = "rcom";
    zzJdk="SOFTWARE\\JavaSoft\\Java Runtime Environment\\1.5";
    zzTomcat="SOFTWARE\\Apache Software Foundation\\Tomcat\\5.0";
    pathTomcat=""; 
// Beginning of UI Sequence  

Dlg_zzb:      //查找注册表看jdk,tomcat是否安装
   

        RegDBSetDefaultRoot(HKEY_LOCAL_MACHINE); 
  if(RegDBKeyExist(zzJdk)!=1) then
       MessageBox("先安装jdk",SEVERE);  
        abort;
  endif;  
   nType = REGDB_STRING;

        if(RegDBKeyExist(zzTomcat)!=1) then
       MessageBox("先安装tomcat",SEVERE); 
       abort;
  else   
      RegDBGetKeyValueEx(zzTomcat, "InstallPath", nType, svvalue,nvSize);
      pathTomcat=svvalue; 
     endif;    
      TARGETDIR=pathTomcat+"\\webapps";    //将项目安装到指定的目录   
      if (Is(FILE_EXISTS, pathTomcat+"\\common\\endorsed\\xml-apis.jar")) then
       DeleteFile (pathTomcat+"\\common\\endorsed\\xml-apis.jar");     //将删除Tomcat目录下的多余的jar   
    // DeleteFile (pathTomcat+"\\common\\endorsed\\xml-apis.jar");     //将删除Tomcat目录下的多余的jar   
            endif;
         CopyFile(SRCDIR^"\\server.xml",pathTomcat+"\\conf\\server.xml");//拷贝server.xml文件到tomcat下面
          
            
Dlg_Start:
    nResult = 0;

Dlg_SdWelcome:
    szTitle = "";
    szMsg = "";
    //{{IS_SCRIPT_TAG(Dlg_SdWelcome)
    nResult = SdWelcome( szTitle, szMsg );
    //}}IS_SCRIPT_TAG(Dlg_SdWelcome)
    if (nResult = BACK) goto Dlg_Start;
 

     
Dlg_SdLicense2:
    szTitle = "";
    szOpt1 = "";
    szOpt2 = "";
    //{{IS_SCRIPT_TAG(License_File_Path)
    szLicenseFile = SUPPORTDIR ^ "License.rtf";
    //}}IS_SCRIPT_TAG(License_File_Path)
    //{{IS_SCRIPT_TAG(Dlg_SdLicense2)
    nResult = SdLicense2Rtf( szTitle, szOpt1, szOpt2, szLicenseFile, bLicenseAccepted );
    //}}IS_SCRIPT_TAG(Dlg_SdLicense2)
    if (nResult = BACK) then
          goto Dlg_SdWelcome;  
       else
        bLicenseAccepted = TRUE;
    endif;
    

    
Dlg_SdRegisterUser:
    szMsg = "";
    szTitle = "";
    //{{IS_SCRIPT_TAG(Dlg_SdRegisterUser) 
    nResult = SdRegisterUser( szTitle, szMsg, szName, szCompany );
    //}}IS_SCRIPT_TAG(Dlg_SdRegisterUser)
      if (nResult = BACK) goto Dlg_SdLicense2;
     
     
// Dlg_SdInitDs:
    // nResult=initDataSource();    //录入web连接信息 
     // if (nResult = -1) goto Dlg_SdInitDs;
      //if (nResult = BACK) goto Dlg_SdRegisterUser;       
     
Dlg_SetupType2:  
    szTitle = "";
    szMsg = "";
    nResult = CUSTOM;
    //{{IS_SCRIPT_TAG(Dlg_SetupType2) 
    nResult = SetupType2( szTitle, szMsg, "", nSetupType, 0 );
    //}}IS_SCRIPT_TAG(Dlg_SetupType2)
    if (nResult = BACK) then
        goto Dlg_SdRegisterUser;  
       
    else
        nSetupType = nResult;
        if (nSetupType != CUSTOM) then
            szTargetPath = TARGETDIR;
            nSize = 0;
            FeatureCompareSizeRequired( MEDIA, szTargetPath, nSize );
            if (nSize != 0) then     
                MessageBox( szSdStr_NotEnoughSpace, WARNING );
                goto Dlg_SetupType2;
            endif;
        endif;  
    endif;

Dlg_SdAskDestPath2:
    if ((nResult = BACK) && (nSetupType != CUSTOM)) goto Dlg_SetupType2;
 szTitle = "";
    szMsg = "";
    if (nSetupType = CUSTOM) then
                //{{IS_SCRIPT_TAG(Dlg_SdAskDestPath2) 
  nResult = SdAskDestPath2( szTitle, szMsg, szDir );
                //}}IS_SCRIPT_TAG(Dlg_SdAskDestPath2)
        TARGETDIR = szDir;
    endif;
    if (nResult = BACK) goto Dlg_SetupType2;

Dlg_SdFeatureTree:
    if ((nResult = BACK) && (nSetupType != CUSTOM)) goto Dlg_SdAskDestPath2;
    szTitle = "";
    szMsg = "";
    szFeatures = "";
    nLevel = 2;
    if (nSetupType = CUSTOM) then
        //{{IS_SCRIPT_TAG(Dlg_SdFeatureTree) 
        nResult = SdFeatureTree( szTitle, szMsg, TARGETDIR, szFeatures, nLevel );
        //}}IS_SCRIPT_TAG(Dlg_SdFeatureTree)
        if (nResult = BACK) goto Dlg_SdAskDestPath2; 
    endif;

Dlg_SQLServer:
    nResult = OnSQLServerInitialize( nResult );
    if( nResult = BACK ) goto Dlg_SdFeatureTree;

Dlg_ObjDialogs:
    nResult = ShowObjWizardPages( nResult );
    if (nResult = BACK) goto Dlg_SQLServer;
   
Dlg_SdStartCopy2:
    szTitle = "";
    szMsg = "";
    //{{IS_SCRIPT_TAG(Dlg_SdStartCopy2) 
    nResult = SdStartCopy2( szTitle, szMsg ); 
    //}}IS_SCRIPT_TAG(Dlg_SdStartCopy2)
    if (nResult = BACK) goto Dlg_ObjDialogs;

    // Added in 11.0 - Set appropriate StatusEx static text.
    SetStatusExStaticText( SdLoadString( IDS_IFX_STATUSEX_STATICTEXT_FIRSTUI ) );
  
    return 0;
end;


 

]]> <![CDATA[面试题目总结]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=24544 jjs_love 2007/5/8 13:04:13 遍历目录

package rcom;

import java.io.*;

public class ListFile {
 public static void main(String[] args) throws Exception{
  listFile(new File("E:\\eclipse-SDK-3.2-win32\\eclipse\\configuration\\org.eclipse.update"));
  
 
 }

  public static void listFile(File file) throws Exception {
  if(file.isFile()) {
       System.out.println("File :"+file.getAbsolutePath());
          
  } else {
  System.out.println("Dir :"+file.getAbsolutePath());
          File[] files = file.listFiles();
          for(int i = 0;i<files.length;i++) {
            listFile(files[i]);
          }
      }
  } 
  }

Unix 管道符|,将一个命令的输出作为另外一个命令的输入


 

]]> <![CDATA[filter过滤]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=23586 jjs_love 2007/3/31 11:12:22 web.xml
  <servlet>
    <description>This is the description of my J2EE component</description>
    <display-name>This is the display name of my J2EE component</display-name>
    <servlet-name>ShowImgServlet</servlet-name>
    <servlet-class>rcom.rf.common.ShowImgServlet</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>ShowImgServlet</servlet-name>
    <url-pattern>/servlet/ShowImgServlet</url-pattern>
  </servlet-mapping>
  <filter>
    <filter-name>checksessionfilter</filter-name>
    <filter-class>rcom.rf.common.CheckSessionFilter</filter-class>
  </filter>
  <filter-mapping>
    <filter-name>checksessionfilter</filter-name>
    <url-pattern>/admin/*</url-pattern>
  </filter-mapping>

CheckSessionFilter.java
  package rcom.rf.common;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class CheckSessionFilter extends HttpServlet implements Filter {

 private FilterConfig filterConfig;
   //Handle the passed-in FilterConfig
   public void init(FilterConfig filterConfig)
       throws ServletException
   {
     this.filterConfig = filterConfig;
   }

   //校验session
   public void doFilter(ServletRequest request, ServletResponse response,
          FilterChain filterChain)
   {
     HttpSession session = ((HttpServletRequest)request).getSession();
     try {
   if(session.getAttribute("username")==null){
    //System.out.println("session is null!没有登陆···");/////////////////
    ((HttpServletResponse)response).sendRedirect("/rfnet/index.jsp");
   }
   filterChain.doFilter(request, response);
  } catch (IOException e) {
   System.out.println("CheckSessionFilter ERR IOException: "+e.getMessage());///////////
    filterConfig.getServletContext().log(e.getMessage());
  } catch (ServletException e) {
   System.out.println("CheckSessionFilter ERR ServletException: "+e.getMessage());///////////////////////////////
    filterConfig.getServletContext().log(e.getMessage());
  }
   }
  

   //Clean up resources
   public void destroy()
   {
   }

}
ShowImgServlet.java
  package rcom.rf.common;

import java.io.BufferedOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Blob;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import rcom.rf.dao.ImgNewsDAO;


public class ShowImgServlet extends HttpServlet {
 private static final String CONTENT_TYPE = "text/html; charset=GBK";
 /**
  * Constructor of the object.
  */
 public ShowImgServlet() {
  super();
 }

 /**
  * Destruction of the servlet. <br>
  */
 public void destroy() {
  super.destroy(); // Just puts "destroy" string in log
  // Put your code here
 }

 /**
  * The doGet method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to get.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 //显示图片
 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  response.setContentType(CONTENT_TYPE);
  InputStream in = null;
  String id = request.getParameter("id");
  byte[] buff = new byte[10240];
  Blob blob = null;
  ImgNewsDAO imgDAO = null;
  int length = 0 ;
  try {
   BufferedOutputStream buffout = new BufferedOutputStream(response.getOutputStream());
   if(id != null && !id.equals("")){
    imgDAO = new ImgNewsDAO();
    blob = imgDAO.getImg(new Long(id));
    in = blob.getBinaryStream();
   }
   while((length = in.read(buff))!=-1){
    buffout.write(buff,0,length);
   }
   in.close();
   buffout.close();
  } catch (NumberFormatException e) {
   e.printStackTrace();
  } catch (IOException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  }
 }

 /**
  * The doPost method of the servlet. <br>
  *
  * This method is called when a form has its tag value method equals to post.
  *
  * @param request the request send by the client to the server
  * @param response the response send by the server to the client
  * @throws ServletException if an error occurred
  * @throws IOException if an error occurred
  */
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
 }

 /**
  * Initialization of the servlet. <br>
  *
  * @throws ServletException if an error occure
  */
 public void init() throws ServletException {
  // Put your code here
 }

}
http://www.javaworld.com.tw/confluence/pages/viewpage.action?pageId=2727

]]> <![CDATA[操作blob与clob]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=23368 jjs_love 2007/3/22 10:13:27 　clob

public void addArmynews(Armynews armynews, String clobstr) {
         Session session =this.getSession();
         Transaction tran = session.beginTransaction();
  try{
       armynews.setContent(Hibernate.createClob(" ")); //插入一个空的
       session.save(armynews);
       session.flush();
       session.refresh(armynews,LockMode.UPGRADE);
             SerializableClob  sc = (SerializableClob)armynews.getContent();
             Clob wrapclob = sc.getWrappedClob();
             CLOB clob = (CLOB)wrapclob;
             clob.putString(1,clobstr);
             tran.commit();

            }catch(Exception ex){
                    ex.printStackTrace();
                    tran.rollback();
                
                   
         }
           
  

  
 }

  public void editInform(Inform inform,String clobstr)
 {
  
      Session session =this.getSession();
   Transaction tran = session.beginTransaction();
 
 
   try{
   
    Inform temp=(Inform) session.load(Inform.class,inform.getId());
       temp.setContent(Hibernate.createClob(" "));
       temp.setTime1(inform.getTime1());
       temp.setTitle(inform.getTitle());
    session.flush();
    session.refresh(temp,LockMode.UPGRADE);
   
          SerializableClob  sc = (SerializableClob)temp.getContent();
          Clob wrapclob = sc.getWrappedClob();
          CLOB clob = (CLOB)wrapclob;
          clob.putString(1,clobstr);
          tran.commit();

   }catch(Exception e){
    tran.rollback();
    System.out.print(e.getMessage()+"ok");
   }
 }

 public Armynews findArmynewsID(Long id) {
  Session session =this.getSession();
  Armynews result=(Armynews) session.get(Armynews.class,id);
  java.sql.Clob clob=result.getContent();
  try{
           String str=clob.getSubString(1, (int) clob.length());
           result.setClobstr(str);
         }catch(Exception e){
         System.out.print("Error_clob:"+e.getMessage());
        }
     return result;
 }
blob

映射成byte[]类型直接保存就是了

读取图

 public ActionForward gethot(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response)
 {
 


  try{
   BufferedOutputStream buffout = new BufferedOutputStream(response.getOutputStream());
         List list=armynewsDAO.findHotArmynews();
        Armynews armynews=new Armynews();
       armynews=(Armynews) list.get(0);
       byte[] buff = armynews.getPic();
       buffout.write(buff);
      buffout.close();
  }catch(Exception e){
   System.out.print(e.getMessage());
  }finally{
  
  }
 
  return  null;
 }

]]> <![CDATA[多文件上传(服务器存文件)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=23367 jjs_love 2007/3/22 10:04:08 jsp页面

<%@ page language="java" pageEncoding="UTF-8"%>

<%@ taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-html" prefix="html" %>
<%@ taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic" %>
<%@ taglib uri="http://struts.apache.org/tags-nested" prefix="nested" %>

 

<html:html locale="true">
  <head>
    <html:base />

<title>广州军区房地产管理局图片视频上传系统</title>

<style type="text/css">
<!--
body {
 margin-left: 0px;
 margin-top: 0px;
 margin-right: 0px;
 margin-bottom: 0px;
}
.style {
 border-bottom-width: 1px;
 border-bottom-style: solid;
 border-bottom-color: #afc4d9;
}

.file { font: 10pt; color: black; }
-->
</style>
<link href="css/style.css" rel="stylesheet" type="text/css">
<SCRIPT>
function CheckFile(str){

var reg=/^[A-Z]{1}\:\\(?!\s+)([^\\]+(?:\\))*([^\s]+(?:\.))+[^\.\s]+$/;
return Check(reg,str);

}

</SCRIPT>
</head>
<html:errors/>
<body>
<html:form  method="post"  action="ks.do?method=upload" enctype="multipart/form-data"> 
<table width="760"  border="0" align="center" cellpadding="0" cellspacing="0">

    <tr>
      <td align="left" valign="top"><table width="760" border=1 align="center" cellpadding=0 bordercolorlight=#afc4d9 bordercolordark=#ffffff bgcolor=#ffffff class=p1>
        <tr>
          <td width="1001" height="25" align="center" bgcolor="#CADDFD"><span class="bt">添加试题文件</span></td>
        </tr>
      </table>
        <table
            width="100%" border=1 cellpadding=0 bordercolorlight=#afc4d9 bordercolordark=#ffffff bgcolor=#ffffff class=p1 id=Table4>
          <tbody>
         
         

            <tr align="center" valign="middle">
              <td height="20">文件列表</td>
              <td height="20" align="left" valign="top">
   <div id="fileDiv"  style='height:150px;top:150px;left:0px;overflow-x:auto;overflow-y:auto ;border-style:outset;border-width:0pt;border-color:  black;'>
     &nbsp;&nbsp;&nbsp;
     <nested:iterate  id="uploadFile"  property="uploadfiles"  name="imgForm" indexId="index"> 
        <nested:nest  property="uploadFile"> 
         文件名称:<nested:text  property="mc"  name="uploadFile"  indexed="true"/> 
                  选择文件:<nested:file  property="theFile"  name="uploadFile"  indexed="true"/> 
        </nested:nest> 
   </nested:iterate>
         <table id=conditionTable border=0  >
      </table>
      </div>
   </td>
            </tr>
           
        </table>
        <table width="760" >
         
          <tr>
            <td width="760" height="26" align="center" valign="middle" bgcolor="#CADDFD" class="style">
            <table width="49%"  border="0" cellspacing="0" cellpadding="0">
                <tr>
                  <td align="right" valign="center">
    <input  type="button"  name="btnAddFile"  value="继续添加"  onclick="addFile()"/> 
    <input  type="submit"  name="submit"  value="上  传"  />  
    <input  type="button"  name="btnBack"  value="返  回"  onclick="javascript:window.location.href='http://37.51.176.64/House'"  />
    
      </td>
            </table></td>
          </tr>
      </table></td>
    </tr>
  </table>
</html:form> 
</body> 
</html:html>

<script  language="javascript">
 


var i=0;
      function addFile() {
       i++;
     currRow=conditionTable.insertRow();
     cellc=currRow.insertCell();
     cellcContext= '&nbsp;&nbsp;&nbsp;文件名称:<input type="text" name="uploadFile['+i+'].mc" >选择文件:<input type="file" name="uploadFile['+i+'].theFile" >&nbsp;&nbsp;<button onclick="removeFile();">删除</button><br>';
     cellc.innerHTML=cellcContext;

    }
   
   
function findTD(o){
if (o.nodeName=="TR"||o.nodeName=="TABLE") return;
if(o.nodeName=="TD")
return (o);
else
return (o.parentElement);
}


function removeFile(){
  o = findTD(event.srcElement);
 conditionTable.deleteRow(o.parentElement.rowIndex*1);
  i--;
}
 
 


function MutilUpload(){
  var cnt;
  var bl=true;
  for(cnt=0;cnt<=i;cnt++){
   bl=bl&&checkOneFile(cnt);

  }
    
  if(bl){
  
            document.forms[0].submit();
   return bl;
  }else
   return bl;
}
 
function checkOneFile(j){

 var eFile=document.getElementsByName("uploadFile["+j+"].theFile").item(0).value;
 if(eFile==''||eFile==null||!CheckFile(eFile)){
  alert('文件输入错误'+eFile);
  return false;
 }else
   return true;
}

</script>

formbean

package cn.com.house.view.struts.form;

import java.util.ArrayList;
import java.util.List;

import org.apache.struts.action.ActionForm;
import org.apache.struts.upload.FormFile;


import cn.com.house.data.bo.Ks;

public class ImagForm extends ActionForm  {
 private Ks ksvo=new Ks();
    private List uploadfiles;
    private FormFile fileContent;
    public ImagForm(){
  uploadfiles=new  ArrayList();
  uploadfiles.add(new UploadFile());
 }
 

 public UploadFile getUploadFile(int index) {
        int size = uploadfiles.size();
        if(index>0){
          uploadfiles.add(new UploadFile());
          size++;
         }
        return (UploadFile)uploadfiles.get(size-1);
 }

 public void setUploadFile(List uploadfiles) {
 
  this.uploadfiles = uploadfiles;
 }
 
 public List getUploadfiles() {
  return uploadfiles;
 }


 public Ks getKsvo() {
  return ksvo;
 }


 public void setKsvo(Ks ksvo) {
  this.ksvo = ksvo;
 }


 public FormFile getFileContent() {
  return fileContent;
 }


 public void setFileContent(FormFile fileContent) {
  this.fileContent = fileContent;
 }

 

 

 

 


}

Action

package cn.com.house.view.struts.action;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.net.URLDecoder;
import java.text.SimpleDateFormat;
import java.util.List;
import java.util.Random;
import java.util.UUID;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.apache.struts.upload.FormFile;

import cn.com.house.data.bo.Ks;
import cn.com.house.data.dao.impl.ArmynewsDAO;
import cn.com.house.view.struts.form.ImagForm;

import cn.com.house.view.struts.form.UploadFile;


public class KsAction  extends DispatchAction{
 private final static String  hql="from Ks as k where k.type=? order by k.id asc";
 private ArmynewsDAO  armynewsDAO;
    private String  filename;
    private String  filenamereal;
 public ArmynewsDAO getArmynewsDAO() {
  return armynewsDAO;
 }

 public void setArmynewsDAO(ArmynewsDAO armynewsDAO) {
  this.armynewsDAO = armynewsDAO;
 }
 
 
 public ActionForward kslist(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
          saveToken(request);
          String type=request.getParameter("type");
          List list=armynewsDAO.findAllObj(hql,"1");
          request.setAttribute("list",list);
          String path="/ks/kslist.jsp?type="+type;
    return new ActionForward(path);
  
   }
 
 public ActionForward imgupload(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
          saveToken(request);

    return new ActionForward("/ks/addimag.jsp");
  
   }
 
 public ActionForward del(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
          String id=request.getParameter("id");
   
           armynewsDAO.delKs(new Long(id),getUploadPath());
           
             String path="/ks.do?method=kslist&type=1";
       return new ActionForward(path);
   }
 
 public ActionForward upload(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response)

 {
  
  ImagForm formvo=(ImagForm) form;
  if(isTokenValid(request,true)){
  List list=formvo.getUploadfiles();
  int size=list.size();
  String mc="";
  for(int i=0;i<size;i++){
   FormFile file=((UploadFile) list.get(i)).getTheFile();
   mc=((UploadFile) list.get(i)).getMc();
   if(file==null){
    
   }else{
    
    uploadfile(file);
    if(mc==null|| mc.equals("")){
     saveDB(this.getFilenamereal(),"1");
    }else{
     saveDB(mc,"1");
     
    }
    
   }
  } 
  }


           String path="/ks.do?method=kslist&type=1";
     return new ActionForward(path);
  }
 
 
 public ActionForward ks(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {

                 saveToken(request);
           return new ActionForward("/ks/ks.jsp");
  
   }
 
 public ActionForward reslut(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response)   {

   
          ImagForm formvo=(ImagForm) form;
        try{
    if(isTokenValid(request,true)){
     FormFile file= formvo.getFileContent();
     String mc="";
     mc=request.getParameter("mc");
     uploadfile(file);
     if(mc==null|| mc==""){
      
      saveDB(this.getFilenamereal(),"2");
     }else{
      saveDB(mc,"2");
      
     }
     request.setAttribute("result","ok");
                  
    }else{
     request.setAttribute("result","token");
     
    }
   
        }catch(Exception e){
       request.setAttribute("result","no");
        
        }
           return  new ActionForward("/ks/reslut.jsp");
  
   }
 
 
 public ActionForward reslutlist(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
          saveToken(request);
          List list=armynewsDAO.findAllObj(hql,"2");
          request.setAttribute("list",list);
    return new ActionForward("/ks/reslutlist.jsp");
  
   }
 
 
 public ActionForward delreslut(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
          String id=request.getParameter("id");
   
           armynewsDAO.delKs(new Long(id),getUploadPath());
           
     
           return  reslutlist(mapping,form,request,response);
  
   }
 

 
 
 public ActionForward getXls(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
  try{
         String file=request.getParameter("file");
         String path=this.getUploadPath()+"/ks/Upload/"+file;
   response.reset();
   response.setContentType("application/vnd.ms-excel");  
   InputStream ips =new FileInputStream(path);       
   OutputStream ops=response.getOutputStream();  
   int   data=-1;  
   while((data   = ips.read())!=-1)   {  
     ops.write(data);
   }
   ops.flush();
   ips.close();
   
  }catch(Exception e){
   e.printStackTrace();
   
  }

    return  null;//kslist(mapping,form,request,response);
  
   }

 public void uploadfile(FormFile files)
    {
 
  PrintWriter buff=null;

  try{
   
   String formart = "yyyyMMddHHmmss";
   Random random = new Random();
   String fileName = new SimpleDateFormat(formart).format(new java.util.Date());
   fileName += Math.abs(random.nextInt()) % 100;
   String rndstr=fileName;
   //String rndstr=UUID.randomUUID().toString();
      String laststr=files.getFileName().substring(files.getFileName().lastIndexOf("."));
      String pst=files.getFileName().substring(0,files.getFileName().lastIndexOf("."));
      this.setFilenamereal(pst);
   String filename=files.getFileName().substring(0,files.getFileName().lastIndexOf(".")).concat(rndstr)+laststr;
      this.setFilename(filename);
   File newdir=new File(ArmynewsAction.getUploadPath()+"/ks/Upload/");
   if(!newdir.exists()){
    newdir.mkdir();
   }
   String path=ArmynewsAction.getUploadPath()+"/ks/Upload/"+filename;
   File savefile=new File(path);
   final int size=8192;
   InputStream input=files.getInputStream();
   BufferedInputStream buffinput=new BufferedInputStream(input);
         FileOutputStream fileout=new FileOutputStream(savefile);
   BufferedOutputStream buffout=new BufferedOutputStream(fileout);
   byte []buffer=new byte[size];
   while(buffinput.read(buffer,0,size)!=-1){
    buffout.write(buffer,0,size);
   }
   buffout.close();
   fileout.close();
   buffinput.close();
   input.close();
         
  }catch(Exception e){
   e.printStackTrace();
   
  }

 }
 
 

  
 public static  String getUploadPath(){
        String testStr=ArmynewsAction.class.getClassLoader().getResource("").getPath();
  testStr=testStr.substring(0,testStr.lastIndexOf("/"));
  testStr=testStr.substring(0,testStr.lastIndexOf("/"));
  testStr=testStr.substring(0,testStr.lastIndexOf("/"));
  testStr=URLDecoder.decode(testStr);
  return testStr;
 }
 
 
 public void  saveDB(String mc,String type){
  Ks kss=new Ks();
  kss.setPath(this.getFilename());
  kss.setType(type);
        kss.setMc(mc);
  armynewsDAO.saveObj(kss);
 }

 public String getFilename() {
  return filename;
 }

 public void setFilename(String filename) {
  this.filename = filename;
 }

 public String getFilenamereal() {
  return filenamereal;
 }

 public void setFilenamereal(String filenamereal) {
  this.filenamereal = filenamereal;
 }
 
 
 public ActionForward test(
   ActionMapping mapping,
   ActionForm form,
   HttpServletRequest request,
   HttpServletResponse response) {
       
   
           armynewsDAO.delKs(new Long(1),getUploadPath());
           
     
           return  null;
  
   }
 
}

]]> <![CDATA[DetachedCriteria]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=23366 jjs_love 2007/3/22 10:00:33 DetachedCriteria detachedCriteria =DetachedCriteria.forClass(UserVO.class)
 //.add(Restrictions.like("username","sz",MatchMode.ANYWHERE));
   .add(org.hibernate.criterion.Expression.disjunction()  //or查询把add放到外面是and查询,MatchMode.ANYWHERE糊查询
        .add(org.hibernate.criterion.Property.forName("username").like("s", MatchMode.ANYWHERE))
        .add(org.hibernate.criterion.Property.forName("password").like("c", MatchMode.ANYWHERE))
        );

 

多对一情况  
DetachedCriteria  zlbdc=DetachedCriteria.forClass(ZlZlxm.class, "zlb");
                     //  .createAlias("zlb.zl", "t")
                        // .setProjection(Property.forName("t.id").count())
                       //.add(Property.forName("t.id").eq(new  Long(1)))
                       org.hibernate.criterion.Projection projection=org.hibernate.criterion.Projections.projectionList()
                                   .add(org.hibernate.criterion.Property.forName("zlb.fdxx"),"id");
                       zlbdc.setProjection(projection);
                                     //zlbdc.createCriteria("zl");//加上这句是内联接(inner join)zl为集合
投影查询，得到一是object[]


  DetachedCriteria  zlbdc=DetachedCriteria.forClass(ZlZlxm.class, "zlb")
  //zlbdc.createCriteria("zl"); //此处为对象
                       .createAlias("zlb.zl", "t") //别名
                       .setProjection(Property.forName("t.id").count())
                       .add(Property.forName("t.id").eq(new  Long(1))); //这里统计的是个数内联接(inner join)
         //zladc.setFetchMode("zla.zlZlxm", org.hibernate.FetchMode.JOIN);//无作用(集合lazy)？？？，如果not lazy将会是全部查出

]]> <![CDATA[spring 学习的一些网上资料(不断更新当中)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=22613 jjs_love 2007/2/8 12:57:32 　使用Spring的JdbcTemplate实现分页功能
http://blog.csdn.net/f9inux/archive/2006/06/23/825176.aspx
spring in action 学习笔记  http://blog.csdn.net/qutr
Pro Spring学习  http://www.blogjava.net/jinfeng_wang/category/480.html]]> <![CDATA[oracle 学习的一些网上资料(不断更新当中)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=22612 jjs_love 2007/2/8 12:53:06 　 大量数据分页处理 http://blog.csdn.net/baggio785/articles/623659.aspx

Oracle SQL FAQ   http://www.cnblogs.com/wtiancai/archive/2005/09/29/246651.html
oracle常用命令   http://www.cnblogs.com/wtiancai/archive/2005/07/05/186710.html
oracle函数大全   http://www.cnblogs.com/wtiancai/archive/2005/03/29/127909.html
数据据学习     

http://blog.csdn.net/softj/category/149670.aspx
 http://blog.csdn.net/AppleBBS/category/83516.aspx?PageNumber=1

Oracle时间日期操作  http://till.javaeye.com/blog/41164

uml学习  http://www.blogjava.net/jelver/category/7679.html
oracle笔记录: http://itpub120.itpub.net/post/25009/233377

]]> <![CDATA[应用JDOM处理xml(实践)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=14649 jjs_love 2006/5/23 10:48:09 package com.jdom;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.net.URL;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.jdom.Attribute;
import org.jdom.Document;
import org.jdom.Element;
import org.jdom.JDOMException;
import org.jdom.input.SAXBuilder;
import org.jdom.output.XMLOutputter;


import java.util.Date;
import java.text.SimpleDateFormat;

public class jdom {
  private static  String xmlfile="com/jdom/bus.xml";
  private static jdom xmlReadWrite = null;
  private static Object obj=new Object();
 public static jdom getInstance(){
  if(xmlReadWrite==null){
     synchronized(obj){
      if(xmlReadWrite==null){
       xmlReadWrite=new jdom();
     }
     }
  }
  return xmlReadWrite;
  
  
 }


   
    public String getRealPath(String path){
     URL url = null;
        try{
            url  = this.getClass().getClassLoader().getResource(path);
         
        }
        catch(Exception e){
           System.out.print(e.getMessage());
        }
        return url.getFile();
    }
   
 
   public bus loadxml(String xmlfile,int id){
      try{
          SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
          bus a=new bus();
          ArrayList list=new ArrayList();
    SAXBuilder sb = new SAXBuilder(false);
    Document doc=sb.build(xmlfile);
    Element root=doc.getRootElement();
    List book=root.getChildren();
    for(int i=0;i<book.size();i++){
     Element booka=(Element)book.get(i);
     String ids=booka.getChild("id").getText();
     if(ids.equals(String.valueOf(id))){
   
      a.setName(booka.getChild("name").getText());
      a.setAuthor(booka.getChild("author").getText());
      String price=booka.getChild("price").getText();
      a.setPrice(Double.valueOf(price));
      String datePrice=booka.getChild("publishDate").getText();
      Date start_date=sdf.parse(datePrice);
      a.setPublishDate(start_date);
     
     }
    
    }
       return a;
      }catch(Exception e){
    System.out.print(e.getMessage());
  }
      return null;
   
   
   }
  
    public Iterator  LoadXML(String xmlfile){
     try{
          SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
    ArrayList list=new ArrayList();
    SAXBuilder sb = new SAXBuilder(false);
    Document doc=sb.build(xmlfile);
    Element root=doc.getRootElement();
    List bus = root.getChildren();
    for(int i=0;i<bus.size();i++){
     bus a=new bus();
     Element book=(Element)bus.get(i);
     String id=book.getChild("id").getText();
     a.setId(Long.parseLong(id));
     a.setName(book.getChild("name").getText());
     a.setAuthor(book.getChild("author").getText());
     String price=book.getChild("price").getText();
     a.setPrice(Double.valueOf(price));
    
     String datePrice=book.getChild("publishDate").getText();
     Date start_date=sdf.parse(datePrice);
     //System.out.print(sdf.format(start_date));
     a.setPublishDate(start_date);
     list.add(a);
    }
    return list.iterator();
      }catch(Exception e){
    System.out.print(e.getMessage());
  }
      return null;
    }   

    public void DelXML(String xmlfile,Long i){
     try{
      
   SAXBuilder sb = new SAXBuilder(false);
   Document doc=sb.build(xmlfile);
   Element root=doc.getRootElement();
   List bus = root.getChildren();
 
   bus.remove(1);

  
   BufferedOutputStream out =new BufferedOutputStream(new FileOutputStream(xmlfile));
   //XMLOutputter outputer = new XMLOutputter();


    XMLOutputter outputer =new XMLOutputter(org.jdom.output.Format.getPrettyFormat());
   outputer.output(root, out);
  
   System.out.print("ok");
   System.out.print("\n");
     }catch(Exception e){
      System.out.print(e.getMessage());
     }
    }
   
    public void addXML(String xmlfile,bus b){
  try{
    SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
    SAXBuilder sb = new SAXBuilder(false);
    Document doc=sb.build(xmlfile);
   
    Element root=doc.getRootElement();
    Element book=new Element("book");
    book.setAttribute("id","6");
   
    Element id=new Element("id");
    Element name=new Element("name");
    Element author=new Element("author");
    Element price=new Element("price");
    Element publishDate=new Element("publishDate");
   
    id.setText(String.valueOf(b.getId()));
    name.setText(b.getName());
    author.setText(b.getAuthor());
    price.setText(String.valueOf(b.getPrice()));
    publishDate.setText(sdf.format(b.getPublishDate()));
   
    book.addContent(id);
    book.addContent(name);
    book.addContent(author);
    book.addContent(price);
    book.addContent(publishDate);
   
    root.addContent(book);
    BufferedOutputStream out =new BufferedOutputStream(new FileOutputStream(xmlfile));
     XMLOutputter outputer =new XMLOutputter(org.jdom.output.Format.getPrettyFormat());
        outputer.output(root, out);
  }catch(Exception e){
   System.out.print(e.getMessage());
  }

     
     
     
    }
   
    public void findXML(String xmlfile,Long id){
  try{

    SAXBuilder sb = new SAXBuilder(false);
    Document doc=sb.build(xmlfile);
    Element root=doc.getRootElement();
    List books=root.getChildren();
    for(int i=0;i<books.size();i++){
     Element book=(Element)books.get(i);
     Long idstr=Long.parseLong(book.getChild("id").getText());
     if(idstr==id){
     
      book.getChild("name").setText("fff");
      System.out.print("ok");
     }
    
    }
    BufferedOutputStream out =new BufferedOutputStream(new FileOutputStream(xmlfile));
     XMLOutputter outputer =new XMLOutputter(org.jdom.output.Format.getPrettyFormat());
        outputer.output(root, out);
  }catch(Exception e){
   System.out.print(e.getMessage());
  }

     
     
     
    }
 public static void main(String[] args) {
   Date today=new Date();
   jdom jdoms=jdom.getInstance().getInstance();
   SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
   String filepath=jdoms.getRealPath(xmlfile);
   jdoms.findXML(filepath,2l);
 
  
  
  Iterator it=jdoms.LoadXML(filepath);
     while(it.hasNext()){
    bus f=(bus)it.next();
    System.out.print(f.getId()+" ");
    System.out.print(f.getName()+" ");
    System.out.print(f.getAuthor()+" ");
    System.out.print(f.getPrice()+" ");
    System.out.print(sdf.format(f.getPublishDate())+"\n");
    System.out.print("\n");
   }
 }
 

}

 

<?xml version="1.0" encoding="GBK"?>   
<bookList>    
<book id="3">      
  <id>1</id>
  <name>Java编程入门</name>     
  <author>张三</author>      
  <publishDate>2006-5-22</publishDate>
  <price>35.0</price> 
</book>   
<book id="4"> 
  <id>2</id>   
  <name>XML在Java中的应用</name>  
  <author>李四</author>   
  <publishDate>2006-5-24</publishDate>   
  <price>92.0</price>
</book>
<book id="5"> 
  <id>3</id>   
  <name>我的xml</name>  
  <author>暨景书</author>   
  <publishDate>2006-5-24</publishDate>   
  <price>92.0</price>
</book>
</bookList>  

 

]]> <![CDATA[日期js]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=13567 jjs_love 2006/4/18 13:10:08 Calendar.js

function Calendar(formatString) {
 var today = new Date();
 
 this.currYear = today.getYear();
 this.currMonth = today.getMonth();
 this.currDate = today.getDate();
 this.currHour = today.getHours();
 this.currMinute = today.getMinutes();
 this.currSecond = today.getSeconds();
 this.currMeridiem = (this.currHour >= 12 ? 'PM' : 'AM');
 var property = null;

 var self = document.createElement('div');
 self.className = "calendarBox";
 self.eventHandler = this;
 self.onmouseover = function() {
  this.eventHandler.calendar_MouseEnter(this, event);
 };
 self.onmouseout = function() {
  this.eventHandler.calendar_MouseOut(this, event);
 };
 document.body.appendChild(self);
 
 this.width = 0;
 this.height = 0;
 this.top = 0;
 this.left = 0;
 this.offsetWidth = self.offsetWidth;
 this.offsetHeight = self.offsetHeight;
 
 Calendar.prototype.getHead = function(year, month) {
  var calendarHead = document.createElement('table');
  calendarHead.width = "100%";
  calendarHead.className = "head";
  var tbody = document.createElement('tbody');
  var ctrlBar = document.createElement('tr');
  
  var btnPrevYear = document.createElement('td');
  btnPrevYear.innerHTML = "7";
  btnPrevYear.className = "ctrlButton";
  btnPrevYear.align = "center";
  btnPrevYear.valign = "middle";
  btnPrevYear.eventHandler = this;
  btnPrevYear.onclick = function() {
   this.eventHandler.btnPrevYear_Click(this, event);
  };
  btnPrevYear.onmouseover = function() {
   this.eventHandler.ctrlButton_RollOver(this, event);
  };
  btnPrevYear.onmouseout = function() {
   this.eventHandler.ctrlButton_RollOut(this, event);
  };
  
  var btnPrevMonth = document.createElement('td');
  btnPrevMonth.className = "ctrlButton";
  btnPrevMonth.innerHTML = "3";
  btnPrevMonth.align = "center";
  btnPrevMonth.valign = "middle";
  btnPrevMonth.eventHandler = this;
  btnPrevMonth.onclick = function() {
   this.eventHandler.btnPrevYear_Click(this, event);
  };
  btnPrevMonth.onmouseover = function() {
   this.eventHandler.ctrlButton_RollOver(this, event);
  };
  btnPrevMonth.onmouseout = function() {
   this.eventHandler.ctrlButton_RollOut(this, event);
  };
  
  var btnPrevMonth = document.createElement('td');
  btnPrevMonth.className = "ctrlButton";
  btnPrevMonth.innerHTML = "3";
  btnPrevMonth.align = "center";
  btnPrevMonth.valign = "middle";
  btnPrevMonth.eventHandler = this;
  btnPrevMonth.onclick = function() {
   this.eventHandler.btnPrevMonth_Click(this, event);
  };
  btnPrevMonth.onmouseover = function() {
   this.eventHandler.ctrlButton_RollOver(this, event);
  };
  btnPrevMonth.onmouseout = function() {
   this.eventHandler.ctrlButton_RollOut(this, event);
  };
  
  var btnNextMonth = document.createElement('td');
  btnNextMonth.className = "ctrlButton";
  btnNextMonth.innerHTML = "4";
  btnNextMonth.align = "center";
  btnNextMonth.valign = "middle";
  btnNextMonth.eventHandler = this;
  btnNextMonth.onclick = function() {
   this.eventHandler.btnNextMonth_Click(this, event);
  };
  btnNextMonth.onmouseover = function() {
   this.eventHandler.ctrlButton_RollOver(this, event);
  };
  btnNextMonth.onmouseout = function() {
   this.eventHandler.ctrlButton_RollOut(this, event);
  };
  
  var btnNextYear = document.createElement('td');
  btnNextYear.className = "ctrlButton";
  btnNextYear.innerHTML = "8";
  btnNextYear.align = "center";
  btnNextYear.valign = "middle";
  btnNextYear.eventHandler = this;
  btnNextYear.onclick = function() {
   this.eventHandler.btnNextYear_Click(this, event);
  };
  btnNextYear.onmouseover = function() {
   this.eventHandler.ctrlButton_RollOver(this, event);
  };
  btnNextYear.onmouseout = function() {
   this.eventHandler.ctrlButton_RollOut(this, event);
  };
  
  var title = document.createElement('td');
  title.className = "title";
  title.align = "center";
  
  var sltYear = document.createElement('span');
  sltYear.className = 'select';
  sltYear.innerHTML = year;
  sltYear.eventHandler = this;
  sltYear.onclick = function() {
   this.eventHandler.sltMoreYear_Click(this, event);
  };
  sltYear.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltYear.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var sltMonth = document.createElement('span');
  sltMonth.className = 'select';
  sltMonth.innerHTML = subZero((month + 1), 2);
  sltMonth.eventHandler = this;
  sltMonth.onclick = function() {
   this.eventHandler.sltMoreMonth_Click(this, event);
  };
  sltMonth.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltMonth.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var spnBlank = document.createElement('span');
  spnBlank.innerHTML = '&nbsp;';
  var spnYear = document.createElement('span');
  spnYear.innerHTML = '&nbsp;Äê&nbsp;';
  var spnMonth = document.createElement('span');
  spnMonth.innerHTML = '&nbsp;ÔÂ&nbsp;';
  
  title.appendChild(spnBlank);
  title.appendChild(sltYear);
  title.appendChild(spnYear);
  title.appendChild(sltMonth);
  title.appendChild(spnMonth);
  
  ctrlBar.appendChild(btnPrevYear);
  ctrlBar.appendChild(btnPrevMonth);  
  ctrlBar.appendChild(title);
  ctrlBar.appendChild(btnNextMonth);
  ctrlBar.appendChild(btnNextYear);  
  tbody.appendChild(ctrlBar);
  calendarHead.appendChild(tbody);
  return calendarHead;
 };

 Calendar.prototype.getBody = function(year, month) {
  var calendarBody = document.createElement('table');
  calendarBody.width = "100%";
  calendarBody.className = "body";
  var tbody = document.createElement('tbody');
  tbody.appendChild(getWeekNames());
  if (property == null) {
   property = new Array(monthDays(year, month));
  }
  
  var day = 1;
  for (var rowLoop=0; rowLoop<6; rowLoop++) {
   var row = document.createElement('tr');
   
   for (var colLoop=0; colLoop<7; colLoop++) {
    var col = document.createElement('td');
    col.align = "center";
    col.valign = "meddle";
    
    if (rowLoop == 0 && colLoop < firstDayOfWeek(year, month)) {
     col.innerHTML = '&nbsp;';
     col.className = "none";
     
    } else if (day <= monthDays(year, month)) {
     if (property[(day - 1)] != undefined && property[(day - 1)] != "") {
      var properties = property[(day - 1)].split("-");
      
      if (properties[1] == properties[2] || properties[1] >= 3) {       
       if (properties[1] == 4) {
        col.className = "examined";
        
       } else if (properties[1] == 1) {
        col.className = "planed";
        
       } else if (properties[1] == 2) {
        col.className = "summarized";        
       }
      
      }
      col.property = property[(day - 1)];
      
     } else if (year == today.getYear() && month == today.getMonth() && day == today.getDate()) {
      col.className = "today";
     
     } else if (year == this.currYear && month == this.currMonth && day == this.currDate) {
      col.className = "select";     
     }
     
     col.innerHTML = day++;
     
     if (colLoop == 0 || colLoop == 6) {
      col.id = "feast";
     }
     
     col.eventHandler = this;
     col.ondblclick = function() {
      this.eventHandler.tdDay_DblClick(this, event);
     };
     col.onclick = function() {
      this.eventHandler.tdDay_Click(this, event);
     };
    
    } else {
     col.innerHTML = '&nbsp;';
     col.className = "none";
    }
    
    row.appendChild(col);
   }
   
   tbody.appendChild(row);
  }
  
  function getWeekNames() {
   var row = document.createElement('tr');
   row.className = "weekName";
   
   var colSunday = document.createElement('td');
   colSunday.innerHTML = 'Sun';//'ÐÇÆÚÈÕ';
   colSunday.id = "feast";
   colSunday.align = "center";
   var colNonday = document.createElement('td');
   colNonday.innerHTML = 'Non';//'ÐÇÆÚÒ»';
   colNonday.align = "center";
   var colTuesday = document.createElement('td');
   colTuesday.innerHTML = 'Tue';//'ÐÇÆÚ¶þ';
   colTuesday.align = "center";
   var colWendnesday = document.createElement('td');
   colWendnesday.innerHTML = 'Wen';//'ÐÇÆÚÈý';
   colWendnesday.align = "center";
   var colThursday = document.createElement('td');
   colThursday.innerHTML = 'Thu';//'ÐÇÆÚËÄ';
   colThursday.align = "center";
   var colFriday = document.createElement('td');
   colFriday.innerHTML = 'Fri';//'ÐÇÆÚÎå';
   colFriday.align = "center";
   var colSaturday = document.createElement('td');
   colSaturday.innerHTML = 'Sat';//'ÐÇÆÚÁù';
   colSaturday.id = "feast";
   colSaturday.align = "center";
   
   row.appendChild(colSunday);
   row.appendChild(colNonday);
   row.appendChild(colTuesday);
   row.appendChild(colWendnesday);
   row.appendChild(colThursday);
   row.appendChild(colFriday);
   row.appendChild(colSaturday);
   return row;
  }
  
  calendarBody.appendChild(tbody);
  return calendarBody;
 };
 
 Calendar.prototype.getFoot = function(hour, minute, second) {
  var tabFoot = document.createElement('table');
  tabFoot.width = "100%";
  var tbody = document.createElement('tbody');
  var tr = document.createElement('tr');
  var td = document.createElement('td');
  td.align = "right";

  var sltMeridiem = document.createElement('span');
  sltMeridiem.className = 'select';
  sltMeridiem.innerHTML = this.currMeridiem;
  sltMeridiem.eventHandler = this;
  sltMeridiem.onclick = function() {
   this.eventHandler.btnMeridiem_Click(this, event);
  };
  sltMeridiem.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltMeridiem.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var sltHour = document.createElement('span');
  sltHour.className = 'select'; 
  if (formatString.indexOf("HH") > 0) {
   sltHour.innerHTML = subZero(hour, 2);
  
  } else if (formatString.indexOf("hh") > 0) {
   sltHour.innerHTML = subZero((hour == 0 || hour == 12 ? 12 : hour % 12), 2);
  }  
  sltHour.eventHandler = this;
  sltHour.onclick = function() {
   this.eventHandler.btnHour_Click(this, event);
  };
  sltHour.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltHour.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var sltMinute = document.createElement('span');
  sltMinute.className = 'select';
  sltMinute.innerHTML = subZero(minute, 2);
  sltMinute.eventHandler = this;
  sltMinute.onclick = function() {
   this.eventHandler.btnMinute_Click(this, event);
  };
  sltMinute.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltMinute.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var sltSecond = document.createElement('span');
  sltSecond.className = 'select';
  sltSecond.innerHTML = subZero(second, 2);
  sltSecond.eventHandler = this;
  sltSecond.onclick = function() {
   this.eventHandler.btnSecond_Click(this, event);
  };
  sltSecond.onmouseover = function() {
   this.eventHandler.select_RollOver(this, event);
  };
  sltSecond.onmouseout = function() {
   this.eventHandler.select_RollOut(this, event);
  };
  
  var spnBlank = document.createElement('span');
  spnBlank.innerHTML = '&nbsp;&nbsp;';
  var spnColon = document.createElement('span');
  spnColon.innerHTML = '<b>&nbsp;:&nbsp;</b>';
  
  if (formatString.indexOf("am") > 0) {
   td.appendChild(sltMeridiem);
  }
  
  if (formatString.indexOf("am") > 0
   && ((formatString.indexOf("mi") > 0)
    || (((formatString.indexOf("hh")) > 0 || (formatString.indexOf("HH") > 0))
    || (formatString.indexOf("ss") > 0)))) {
   td.appendChild(spnBlank);
  }
  
  if ((formatString.indexOf("hh")) > 0 || (formatString.indexOf("HH") > 0)) {
   td.appendChild(sltHour);
  }
  
  if ((formatString.indexOf("mi") > 0)
   && (((formatString.indexOf("hh")) > 0 || (formatString.indexOf("HH"))))) {
   td.appendChild(spnColon);
  }
  
  if (formatString.indexOf("mi") > 0) {
   td.appendChild(sltMinute);
  }
  
  if ((formatString.indexOf("ss") > 0)
   && (((formatString.indexOf("hh")) > 0 || (formatString.indexOf("HH"))))) {
   
   if ((formatString.indexOf("mi") > 0)
    && (((formatString.indexOf("hh")) > 0 || (formatString.indexOf("HH"))))) {
    td.appendChild(spnColon.cloneNode(true));
   } else {
    td.appendChild(spnColon);
   }
  }
  
  if (formatString.indexOf("ss") > 0) {
   td.appendChild(sltSecond);
  }
  
  tr.appendChild(td);
  tbody.appendChild(tr);
  tabFoot.appendChild(tbody);
  return tabFoot;
 };
  
 Calendar.prototype.btnPrevYear_Click = function (sender, event) {
  this.previousYear();
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.btnPrevMonth_Click = function (sender, event) {
  this.previousMonth();
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.btnNextMonth_Click = function (sender, event) {
  this.nextMonth();
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.btnNextYear_Click = function (sender, event) {
  this.nextYear();
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.optSelectYear_Click = function (sender, event) {
  this.setYear(sender.innerHTML);
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.optSelectMonth_Click = function (sender, event) {
  this.setMonth((Number(sender.innerHTML) - 1));
  this.onCalendar_Update();
  this.update();
 };
 
 Calendar.prototype.sltMoreYear_Click = function (sender, event) {
  var height = self.childNodes[1].offsetHeight;
  this.showMore(1900, 2100, height, Number(sender.innerHTML), "selectYear");
 };
 
 Calendar.prototype.sltMoreMonth_Click = function (sender, event) {
  var height = self.childNodes[1].offsetHeight;
  this.showMore(1, 12, height, Number(sender.innerHTML), "selectMonth");
 };
 
 Calendar.prototype.tdDay_DblClick = function (sender, event) {
  this.setDate(Number(sender.innerHTML));
  this.calendar_DblClick(sender, event);
 };
 
 Calendar.prototype.tdDay_Click = function (sender, event) {
  
 };
 
 Calendar.prototype.btnMeridiem_Click = function (sender, event) {
  sender.innerHTML = (sender.innerHTML == 'AM' ? 'PM' : 'AM');
  this.currMeridiem = sender.innerHTML;
 };
 
 Calendar.prototype.optSelectHour_Click = function (sender, event) {
  this.setHour(Number(sender.innerHTML));
  this.update();
 };
 
 Calendar.prototype.optSelectMinute_Click = function (sender, event) {
  this.setMinute(Number(sender.innerHTML));
  this.update();
 };
 
 Calendar.prototype.optSelectSecond_Click = function (sender, event) {
  this.setSecond(Number(sender.innerHTML));
  this.update();
 };
 
 Calendar.prototype.optSelect_OnMouseOver = function (sender, event) {
  sender.originClassName = sender.className;
  sender.className = "onMouseOver";
 };
 
 Calendar.prototype.optSelect_OnMouseOut = function (sender, event) {
  sender.className = sender.originClassName;
 };
 
 Calendar.prototype.btnHour_Click = function (sender, event) {
  if (formatString.indexOf("HH") > 0) {
   this.showMore(0, 23, 70, Number(sender.innerHTML), "selectHour");
   
  } else if (formatString.indexOf("hh") > 0) {
   this.showMore(1, 12, 70, Number(sender.innerHTML), "selectHour");
  }
 };
 
 Calendar.prototype.btnMinute_Click = function (sender, event) {
  this.showMore(0, 59, 70, Number(sender.innerHTML), "selectMinute");
 };
 
 Calendar.prototype.btnSecond_Click = function (sender, event) {
  this.showMore(0, 59, 70, Number(sender.innerHTML), "selectSecond");
 };
 
 
 Calendar.prototype.select_RollOver = function (sender, event) {
  sender.className = "selectRollOver";
 };
 
 Calendar.prototype.select_RollOut = function (sender, event) {
  sender.className = "selectRollOut";
 };
 
 Calendar.prototype.ctrlButton_RollOver = function (sender, event) {
  sender.className = "ctrlButtonRollOver";
 };
 
 Calendar.prototype.ctrlButton_RollOut = function (sender, event) {
  sender.className = "ctrlButtonRollOut";
 };
 
 Calendar.prototype.calendar_MouseEnter = function (sender, event) {
 };
 
 Calendar.prototype.calendar_MouseOut = function (sender, event) {
 };
 
 Calendar.prototype.calendar_DblClick = function (sender, event) {
 };
 
 Calendar.prototype.getYear = function() {
  return this.currYear;
 }
 
 Calendar.prototype.getMonth = function() {
  return this.currMonth;
 }
 
 Calendar.prototype.getDate = function() {
  return this.currDate;
 }
 
 Calendar.prototype.setProperty = function(pro) {
  property = pro.split(", ");
 }
 
 Calendar.prototype.onCalendar_Update = function() {
 }
 
 this.showMore = function(starNum, endNum, height, selectedValue, method) {
  var object = window.event.srcElement;
  var selectedIndex = selectedValue - starNum;
  
  if(object.selectBox) {
   object.selectBox.selectedIndex = selectedIndex;
   object.selectBox.show(height);
   return;
  }
  
  var selectBox = window.document.createElement("div");
  selectBox.className = "selectBox";
  selectBox.style.top = window.event.clientY - window.event.offsetY + window.event.srcElement.offsetHeight
         - this.top;
  selectBox.style.left = window.event.clientX - object.offsetWidth - this.left;
  selectBox.show  = showBox;
  selectBox.selectedIndex = selectedIndex;
  
  var table = window.document.createElement("table");
  table.border = "0";
  table.cellspacing = "0";
  table.cellpadding = "0";
  table.width = "100%";
  var tbody = window.document.createElement("tbody");
  for (var loop=starNum; loop<=endNum; loop++) {
   var tr = window.document.createElement("tr");
   var td = window.document.createElement("td");
   td.innerHTML = subZero(loop, 2);
   td.align = "center";
   td.className = "unselect";
   td.eventHandler = this;
   if (method == "selectYear") {
    td.onclick = function() {
     this.eventHandler.optSelectYear_Click(this, event);
    };
    
   } else if (method == "selectMonth") {
    td.onclick = function() {
     this.eventHandler.optSelectMonth_Click(this, event);
    };
   
   } else if (method == "selectHour") {
    td.onclick = function() {
     this.eventHandler.optSelectHour_Click(this, event);
    };
   
   } else if (method == "selectMinute") {
    td.onclick = function() {
     this.eventHandler.optSelectMinute_Click(this, event);
    };
   
   } else if (method == "selectSecond") {
    td.onclick = function() {
     this.eventHandler.optSelectSecond_Click(this, event);
    };
   
   }
   
   td.onmouseover = function() {
    this.eventHandler.optSelect_OnMouseOver(this, event);
   };
   
   td.onmouseout = function() {
    this.eventHandler.optSelect_OnMouseOut(this, event);
   };
   
   tr.appendChild(td);
   tbody.appendChild(tr);
  }
  table.appendChild(tbody);
  selectBox.appendChild(table);
  
  self.appendChild(selectBox); 
  object.selectBox = selectBox;
  object.selectBox.show(height);
 };
 
 this.setFormatString = function(formatString) {
  formatString = formatString;
 }
 
 this.show = function(src) {  
  self.style.width = this.width;
  self.style.height = this.height;
  self.style.top = this.top;
  self.style.left = this.left;
  this.display();
  
  if (src != undefined) {
   this.format(src);
  }

  this.update();
 };
 
 this.update = function() {
  while (self.childNodes.length > 0) {
   self.removeChild(self.childNodes(0));
  }

  self.appendChild(this.getHead(this.currYear, this.currMonth));
  self.appendChild(this.getBody(this.currYear, this.currMonth));
  self.appendChild(this.getFoot(this.currHour, this.currMinute, this.currSecond));
 };
 
 this.hide = function() {
  self.style.display = "none";
 };
 
 this.display = function() {
  self.style.display = "block";
 };
 
 this.nextMonth = function() {
  if (this.currMonth == 11) {
   this.currMonth = 0;
   this.currYear++;
  
  } else {
   this.currMonth++;
  }
 };
 
 this.previousMonth = function() {
  if (this.currMonth == 0) {
   this.currMonth = 11;
   this.currYear--;
  
  } else {
   this.currMonth--;
  }
 };
 
 this.setMonth = function(month) {
  this.currMonth = month;
 };
 
 this.nextYear = function() {
  this.currYear++;
 };
 
 this.previousYear = function() {
  this.currYear--;
 };
 
 this.setYear = function(year) {
  this.currYear = year;
 };
 
 this.setDate = function(date) {
  this.currDate = date;
 };
 
 this.setHour = function(hour) {
  this.currHour = hour;
 };
 
 this.setMinute = function(minute) {
  if (formatString.indexOf("HH") > 0) {
   this.currMinute = minute;
  
  } else if (formatString.indexOf("hh") > 0) {
   this.currMinute = this.currMeridiem == 'AM' ? minute : minute + 12;
  }
 };
 
 this.setSecond = function(second) {
  this.currSecond = second;
 };
 
 this.toString = function() {
  var returnString = formatString;
  returnString = returnString.replace("yyyy", this.currYear);
  returnString = returnString.replace("MM", subZero((this.currMonth + 1), 2));
  returnString = returnString.replace("dd", subZero(this.currDate, 2));
  returnString = returnString.replace("hh", subZero((this.currHour > 12 ? (this.currHour - 12) : this.currHour), 2));
  returnString = returnString.replace("HH", subZero(this.currHour, 2));
  returnString = returnString.replace("mi", subZero(this.currMinute, 2));
  returnString = returnString.replace("ss", subZero(this.currSecond, 2));
  returnString = returnString.replace("am", this.currMeridiem);
  
  return returnString;
 };
 
 this.format = function(str) {
  try {
   var beginIndex = formatString.indexOf("yyyy");
   if (beginIndex >= 0) {
    var year = Number(str.substring(beginIndex, (beginIndex + 4)));
    if (year == 'NaN' || year < 1900 || year > 2100) {
     throw new DateFormatException();
    }   
    this.currYear = year;
   }
  
   beginIndex = formatString.indexOf("MM");
   if (beginIndex >= 0) {
    var month = Number(str.substring(beginIndex, (beginIndex + 2))) - 1;
    if (month == 'NaN' || month < 0 || month > 11) {
     throw new DateFormatException();
    }   
    this.currMonth = month;
   }
   
   beginIndex = formatString.indexOf("dd");
   if (beginIndex >= 0) {
    var date = Number(str.substring(beginIndex, (beginIndex + 2)));
    if (date == 'NaN' || date < 1 || date > monthDays(this.currYear, this.currMonth)) {
     throw new DateFormatException();
    }   
    this.currDate = date;
   }
   
   beginIndex = formatString.indexOf("am");
   if (beginIndex >= 0) {
    var meridiem = str.substring(beginIndex, (beginIndex + 2));
    if (meridiem != "AM" && meridiem != "PM") {
     throw new DateFormatException();
    }   
    this.currMeridiem = meridiem;
   }
   
   beginIndex = formatString.indexOf("HH");
   if (beginIndex >= 0) {
    var hour = Number(str.substring(beginIndex, (beginIndex + 2)));
    if (hour == 'NaN' || hour < 0 || hour > 23) {
     throw new DateFormatException();
    }   
    this.currHour = hour;
   }
   
   beginIndex = formatString.indexOf("hh");
   if (beginIndex >= 0) {
    var hour = Number(str.substring(beginIndex, (beginIndex + 2)));
    if (hour == 'NaN' || hour < 0 || hour > 12) {
     throw new DateFormatException();
    }
    this.currHour = this.currMeridiem == "AM" ? hour : hour + 12;
   }
   
   beginIndex = formatString.indexOf("mi");
   if (beginIndex >= 0) {
    var minute = Number(str.substring(beginIndex, (beginIndex + 2)));
    if (minute == 'NaN' || minute < 0 || minute > 59) {
     throw new DateFormatException();
    }   
    this.currMinute = minute;
   }
   
   beginIndex = formatString.indexOf("ss");
   if (beginIndex >= 0) {
    var second = Number(str.substring(beginIndex, (beginIndex + 2)));
    if (second == 'NaN' || second < 0 || second > 59) {
     throw new DateFormatException();
    }   
    this.currSecond = second;
   }
  
  } catch (dfe) {
   this.currYear = today.getYear();
   this.currMonth = today.getMonth();
   this.currDate = today.getDate();
   this.currHour = today.getHours();
   this.currMinute = today.getMinutes();
   this.currSecond = today.getSeconds();
   this.currMeridiem = (this.currHour >= 12 ? 'PM' : 'AM');
  }
  
 };
 
 function monthDays(year, month) {
  var days = new Array(31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31);
  
  if (month == 1) {
   return (((year % 4 == 0) && (year % 100 != 0) || (year % 400 == 0))? 29: 28);
  }
  
  return days[month];
 };
 
 function firstDayOfWeek(year, month) {
  return ((new Date(year, month, 1)).getDay());
 };
 
 function showBox(iHeight) {
  var box = this;
  box.style.height = 1;
  box.style.display = "block";
  window.clearInterval(box.timeHandle);
  box.timeHandle = window.setInterval(interValHandle, 1);
  
  var s = 0;
  var t = 1;
  function interValHandle() {
   box.scrollTop = 1000000;
   s = s + t * t;
   t += 0.5;
   box.style.height = parseInt(box.style.height) + Math.floor(s);
   box.style.width = (iHeight != 70 ? 50 : 35) / iHeight * box.offsetHeight;
   if( box.offsetHeight > iHeight ) {
    window.clearInterval(box.timeHandle);
    box.style.height = iHeight;
    var tbody = box.childNodes[0].childNodes[0]
    box.scrollTop = (tbody.childNodes[0].childNodes[0].offsetHeight + 2) * box.selectedIndex;
    tbody.childNodes[box.selectedIndex].childNodes[0].className = "selected";
    window.document.attachEvent("onclick", box.hide = function() {
                   box.style.display = "none";
                   window.document.detachEvent("onclick", box.hide);
                  });
   }
   
  }
  
 };
 
 function subZero(str, digit) {
  str = str.toString();
  
  for (var loop=str.length; loop<digit; loop++) {
   str = '0' + str;
  }
  
  return str;
 };
}

function getDateString(formIndex, targetName, type) {
 var targetForm = document.forms[formIndex];
 var target = targetForm[targetName];
 
 if (target.calendar == null) { 
  if (type == "long") {
   target.calendar = new Calendar("yyyy-MM-dd HH:mi");
   
  } else if (type == "short") {
   target.calendar = new Calendar("yyyy-MM-dd");
  }
  
  target.calendar.width = 250;
  target.calendar.height = 150;
 }
 
 if (type == "long") {
  target.calendar.setFormatString("yyyy-MM-dd HH:mi");
  
 } else if (type == "short") {
  target.calendar.setFormatString("yyyy-MM-dd");
 }
 
 target.calendar.left = window.event.clientX - target.calendar.offsetWidth > 600
       ? 600 : window.event.clientX - target.calendar.offsetWidth;
 target.calendar.top = window.event.clientY - window.event.offsetY + window.event.srcElement.offsetHeight
      - target.offsetHeight;
 target.calendar.show(target.value);
 
 target.calendar.calendar_DblClick = function () {
  target.value = target.calendar.toString();
  target.calendar.hide();
 };
 
 target.calendar.calendar_MouseEnter = function () {
  target.calendar.display();
 };
 
 target.calendar.calendar_MouseOut = function () {
  target.calendar.hide();
 };
}

Calendar.css:

.calendarBox {
 font-family: "ËÎÌå";
 font-size: 12.5px;
 position: absolute;
 z-index: 1;
 background: #FFFFFF;
}

.calendarBox td {
 font-family: "ËÎÌå";
 font-size: 12.5px;
 background: #FFFFFF;
 border: none;
}

.calendarBox .head .ctrlButton {
 font-family: Webdings;
 cursor: hand;
 border: #999999 solid 1px;
 color: #333333;
 background: #CCCCCC;
 width: 10%;
}

.calendarBox .head .ctrlButtonRollOver {
 font-family: Webdings;
 cursor: hand;
 border: #999999 solid 1px;
 color: #FF6600;
 background: #CCCCCC;
 width: 10%;
}

.calendarBox .head .ctrlButtonRollOut {
 font-family: Webdings;
 cursor: hand;
 border: #999999 solid 1px;
 color: #333333;
 background: #CCCCCC;
 width: 10%;
}

.calendarBox .head .title {
 background: #FFFFFF;
 border: #CCCCCC dashed 1px;
 width: 60%;
}

.calendarBox .select {
 cursor: hand;
 color: #000000;
}

.calendarBox .selectRollOver {
 cursor: hand;
 color: #006699;
 font-weight: bold;
}

.calendarBox .selectRollOut {
 cursor: hand;
 color: #000000;
}

.calendarBox .selectBox {
 z-index: 2;
 cursor: hand;
 position: absolute;
 border: 1px solid #425E87;
 overflow-y: scroll;
 overflow-x: hidden;
 background-color: #FFFFFF;
 FILTER: progid:DXImageTransform.Microsoft.Shadow(Color=#999999, offX=10, offY=10, direction=120, Strength=5);
}

.calendarBox .selectBox .unselect {
 font-weight: normal;
}

.calendarBox .selectBox .selected {
 color: #003366;
 font-weight: bold;
}

.calendarBox .selectBox .onMouseOver {
 font-weight: bold;
 color: #006699;
}

.calendarBox .body td {
 cursor: pointer;
 border: #CCCCCC dashed 1px;
}

.calendarBox .body #feast {
 color: #990000;
}

.calendarBox .body .weekName td {
 font-weight: bold;
}

.calendarBox .body .weekName .feast {
 color: #990000;
}

调用方法:

<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>

<%  

     
     Date today = new Date();
     SimpleDateFormat sdfShort = new SimpleDateFormat("yyyy-MM-dd");
  String startDate = request.getParameter("startDate");
 if (startDate == null || startDate.equals("")) {
  Date start = null;
  
  if (today.getMonth() == 0) {
   start = new Date((today.getYear() - 1), 11, today.getDate());
  
  } else {
   start = new Date(today.getYear(), (today.getMonth() - 1), today.getDate());
  }
  
  startDate = sdfShort.format(start);
 }
 
 String endDate = request.getParameter("endDate");
 if (endDate == null || endDate.equals("")) {
  endDate = sdfShort.format(today);
 }

 

  Date start_date=sdfShort.parse(startDate);
  Date end_date=sdfShort.parse(endDate);
%>

 

]]> <![CDATA[使用JDBC和Hibernate来写入Blob型数据到Oracle中(转载robbin)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=13364 jjs_love 2006/4/11 13:16:36 Oracle的Blob字段比较特殊，他比long字段的性能要好很多，可以用来保存例如图片之类的二进制数据。

写入Blob字段和写入其它类型字段的方式非常不同，因为Blob自身有一个cursor，你必须使用cursor对blob进行操作，因而你在写入Blob之前，必须获得cursor才能进行写入，那么如何获得Blob的cursor呢？

这需要你先插入一个empty的blob，这将创建一个blob的cursor，然后你再把这个empty的blob的cursor用select查询出来，这样通过两步操作，你就获得了blob的cursor，可以真正的写入blob数据了。

看下面的JDBC的demo，把oraclejdbc.jar这个二进制文件写入数据库表javatest的content字段(这是一个blob型字段)

java代码: 

import java.sql.*;
import java.io.*;
import oracle.sql.*;
public class WriteBlob {

  public static void main(String[] args) {

    try {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","fankai","fankai");
      conn.setAutoCommit(false);

      BLOB blob = null;

      PreparedStatement pstmt = conn.prepareStatement("insert into javatest(name,content) values(?,empty_blob())");
      pstmt.setString(1,"fankai");
      pstmt.executeUpdate();
      pstmt.close();

      pstmt = conn.prepareStatement("select content from javatest where name= ? for update");
      pstmt.setString(1,"fankai");
      ResultSet rset = pstmt.executeQuery();
      if (rset.next()) blob = (BLOB) rset.getBlob(1);

      String fileName = "oraclejdbc.jar";
      File f = new File(fileName);
      FileInputStream fin = new FileInputStream(f);
      System.out.println("file size = " + fin.available());

      pstmt = conn.prepareStatement("update javatest set content=? where name=?");

      OutputStream out = blob.getBinaryOutputStream();

      int count = -1, total = 0;
      byte[] data = new byte[(int)fin.available()];
      fin.read(data);
      out.write(data);
      /*
      byte[] data = new byte[blob.getBufferSize()];  另一种实现方法,节省内存
      while ((count = fin.read(data)) != -1) {
        total += count;
        out.write(data, 0, count);
      }
      */

      fin.close();
      out.close();

      pstmt.setBlob(1,blob);
      pstmt.setString(2,"fankai");

      pstmt.executeUpdate();
      pstmt.close();

      conn.commit();
      conn.close();
    } catch (SQLException e) {
      System.err.println(e.getMessage());
      e.printStackTrace();
    } catch (IOException e) {
      System.err.println(e.getMessage());
    }
  }

}





仔细看上例，分三步：

1、插入空blob
into javatest(name,content) values(?,empty_blob());

2、获得blob的cursor
select content from javatest where name= ? for update;

注意！！！必须加for update，这将锁定该行，直至该行被修改完毕，保证不产生并发冲突。

3、update javatest set content=? where name=

用cursor往数据库写数据

这里面还有一点要提醒大家：

JDK1.3带的JDBC2.0规范是不完善的，只有读Blob的接口，而没有写Blob的接口，JDK1.4带的JDBC3.0加入了写Blob的接口。你可以使用JDBC3.0的接口，也可以直接使用Oracle的JDBC的API，我在上例中使用了Oracle的JDBC的API。

另外要注意的是：

java.sql.Blob
oracle.sql.BLOB

注意看blob的大小写，是不一样的。写程序的时候不要搞混了。

下面看看用Hibernate怎么写，原理是一样的，也要分三步，但是代码简单很多

这是Cat对象定义
java代码: 

package com.fankai;

import java.sql.Blob;

public class Cat {
  private String id;
  private String name;
  private char sex;
  private float weight;
  private Blob image;
  public Cat() { }

  public String getId() { return id; }
  public void setId(String id) { this.id = id; }

  public String getName() { return name; }
  public void setName(String name) { this.name = name; }

  public char getSex() { return sex; }
  public void setSex(char sex) { this.sex = sex; }

  public float getWeight() { return weight; }
  public void setWeight(float weight) { this.weight = weight; }
 
  public Blob getImage() { return image; }
  public void setImage(Blob image) { this.image = image;}
}



这是Cat.hbm.xml

java代码: 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping SYSTEM "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>
    <class name="com.fankai.Cat" table="cat">
        <!--jcs-cache usage="read-only"/-->
        <id name="id" unsaved-value="null">
            <generator class="uuid.hex"/>
        </id>
        <property name="name" length="16" not-null="true"/>
        <property name="sex" length="1" not-null="true"/>
        <property name="weight" />
        <property name="image" />
    </class>
</hibernate-mapping>




下面是完整的用Hibernate写入Blob的例子，相比JDBC，已经简单轻松多了，也不用写那些Oracle特殊的sql了：

java代码: 

package com.fankai;

import java.sql.Blob;
import net.sf.hibernate.*;
import oracle.sql.*;
import java.io.*;

public class TestCatHibernate { 
  public static void testBlob() {
    Session s = null;   
    byte[] buffer = new byte[1];
    buffer[0] = 1;
    try {
      SessionFactory sf = HibernateSessionFactory.getSessionFactory();
      s = sf.openSession(); 
      Transaction tx = s.beginTransaction();
      Cat c = new Cat();
      c.setName("Robbin");
      c.setImage(Hibernate.createBlob(buffer));
      s.save(c);
      s.flush();
      s.refresh(c, LockMode.UPGRADE);   
      BLOB blob = (BLOB) c.getImage();     
      OutputStream out = blob.getBinaryOutputStream();   
      String fileName = "oraclejdbc.jar";
      File f = new File(fileName);
      FileInputStream fin = new FileInputStream(f);   
      int count = -1, total = 0;
      byte[] data = new byte[(int)fin.available()];
      fin.read(data);
      out.write(data);     
      fin.close();
      out.close();
      s.flush();
      tx.commit();
   
    } catch (Exception e) {
      System.out.println(e.getMessage());
    } finally {
      if (s != null)
        try {
          s.close();
        } catch (Exception e) {}
    }   
   
  }
}

 

 

附:可以采用通用信,例如把blob映射为byte[]，clob映射为char[],操作他们和操作其它数据库的大字段是一样的，把oracle的blob/clob移植到sybase的image/text，甚至access的OLE对象，不需要修改一行代码和配置.

]]> <![CDATA[各种排序算法java实现(转)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=13229 jjs_love 2006/4/6 13:43:26 插入排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;
/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class InsertSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int temp;
        for(int i=1;i<data.length;i++){
            for(int j=i;(j>0)&&(data[j]<data[j-1]);j--){
                SortUtil.swap(data,j,j-1);
            }
        }       
    }

}
冒泡排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class BubbleSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int temp;
        for(int i=0;i<data.length;i++){
            for(int j=data.length-1;j>i;j--){
                if(data[j]<data[j-1]){
                    SortUtil.swap(data,j,j-1);
                }
            }
        }
    }

}

选择排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class SelectionSort implements SortUtil.Sort {

    /*
     * (non-Javadoc)
     *
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int temp;
        for (int i = 0; i < data.length; i++) {
            int lowIndex = i;
            for (int j = data.length - 1; j > i; j--) {
                if (data[j] < data[lowIndex]) {
                    lowIndex = j;
                }
            }
            SortUtil.swap(data,i,lowIndex);
        }
    }

}

Shell排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class ShellSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        for(int i=data.length/2;i>2;i/=2){
            for(int j=0;j<i;j++){
                insertSort(data,j,i);
            }
        }
        insertSort(data,0,1);
    }

    /**
     * @param data
     * @param j
     * @param i
     */
    private void insertSort(int[] data, int start, int inc) {
        int temp;
        for(int i=start+inc;i<data.length;i+=inc){
            for(int j=i;(j>=inc)&&(data[j]<data[j-inc]);j-=inc){
                SortUtil.swap(data,j,j-inc);
            }
        }
    }

}

快速排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class QuickSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        quickSort(data,0,data.length-1);       
    }
    private void quickSort(int[] data,int i,int j){
        int pivotIndex=(i+j)/2;
        //swap
        SortUtil.swap(data,pivotIndex,j);
       
        int k=partition(data,i-1,j,data[j]);
        SortUtil.swap(data,k,j);
        if((k-i)>1) quickSort(data,i,k-1);
        if((j-k)>1) quickSort(data,k+1,j);
       
    }
    /**
     * @param data
     * @param i
     * @param j
     * @return
     */
    private int partition(int[] data, int l, int r,int pivot) {
        do{
           while(data[++l]<pivot);
           while((r!=0)&&data[--r]>pivot);
           SortUtil.swap(data,l,r);
        }
        while(l<r);
        SortUtil.swap(data,l,r);       
        return l;
    }

}
改进后的快速排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class ImprovedQuickSort implements SortUtil.Sort {

    private static int MAX_STACK_SIZE=4096;
    private static int THRESHOLD=10;
    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int[] stack=new int[MAX_STACK_SIZE];
       
        int top=-1;
        int pivot;
        int pivotIndex,l,r;
       
        stack[++top]=0;
        stack[++top]=data.length-1;
       
        while(top>0){
            int j=stack[top--];
            int i=stack[top--];
           
            pivotIndex=(i+j)/2;
            pivot=data[pivotIndex];
           
            SortUtil.swap(data,pivotIndex,j);
           
            //partition
            l=i-1;
            r=j;
            do{
                while(data[++l]<pivot);
                while((r!=0)&&(data[--r]>pivot));
                SortUtil.swap(data,l,r);
            }
            while(l<r);
            SortUtil.swap(data,l,r);
            SortUtil.swap(data,l,j);
           
            if((l-i)>THRESHOLD){
                stack[++top]=i;
                stack[++top]=l-1;
            }
            if((j-l)>THRESHOLD){
                stack[++top]=l+1;
                stack[++top]=j;
            }
           
        }
        //new InsertSort().sort(data);
        insertSort(data);
    }
    /**
     * @param data
     */
    private void insertSort(int[] data) {
        int temp;
        for(int i=1;i<data.length;i++){
            for(int j=i;(j>0)&&(data[j]<data[j-1]);j--){
                SortUtil.swap(data,j,j-1);
            }
        }      
    }

}

归并排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class MergeSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int[] temp=new int[data.length];
        mergeSort(data,temp,0,data.length-1);
    }
   
    private void mergeSort(int[] data,int[] temp,int l,int r){
        int mid=(l+r)/2;
        if(l==r) return ;
        mergeSort(data,temp,l,mid);
        mergeSort(data,temp,mid+1,r);
        for(int i=l;i<=r;i++){
            temp[i]=data[i];
        }
        int i1=l;
        int i2=mid+1;
        for(int cur=l;cur<=r;cur++){
            if(i1==mid+1)
                data[cur]=temp[i2++];
            else if(i2>r)
                data[cur]=temp[i1++];
            else if(temp[i1]<temp[i2])
                data[cur]=temp[i1++];
            else
                data[cur]=temp[i2++];           
        }
    }

}

改进后的归并排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class ImprovedMergeSort implements SortUtil.Sort {

    private static final int THRESHOLD = 10;

    /*
     * (non-Javadoc)
     *
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        int[] temp=new int[data.length];
        mergeSort(data,temp,0,data.length-1);
    }

    private void mergeSort(int[] data, int[] temp, int l, int r) {
        int i, j, k;
        int mid = (l + r) / 2;
        if (l == r)
            return;
        if ((mid - l) >= THRESHOLD)
            mergeSort(data, temp, l, mid);
        else
            insertSort(data, l, mid - l + 1);
        if ((r - mid) > THRESHOLD)
            mergeSort(data, temp, mid + 1, r);
        else
            insertSort(data, mid + 1, r - mid);

        for (i = l; i <= mid; i++) {
            temp[i] = data[i];
        }
        for (j = 1; j <= r - mid; j++) {
            temp[r - j + 1] = data[j + mid];
        }
        int a = temp[l];
        int b = temp[r];
        for (i = l, j = r, k = l; k <= r; k++) {
            if (a < b) {
                data[k] = temp[i++];
                a = temp[i];
            } else {
                data[k] = temp[j--];
                b = temp[j];
            }
        }
    }

    /**
     * @param data
     * @param l
     * @param i
     */
    private void insertSort(int[] data, int start, int len) {
        for(int i=start+1;i<start+len;i++){
            for(int j=i;(j>start) && data[j]<data[j-1];j--){
                SortUtil.swap(data,j,j-1);
            }
        }
    }

}
堆排序:

package org.rut.util.algorithm.support;

import org.rut.util.algorithm.SortUtil;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class HeapSort implements SortUtil.Sort{

    /* (non-Javadoc)
     * @see org.rut.util.algorithm.SortUtil.Sort#sort(int[])
     */
    public void sort(int[] data) {
        MaxHeap h=new MaxHeap();
        h.init(data);
        for(int i=0;i<data.length;i++)
            h.remove();
        System.arraycopy(h.queue,1,data,0,data.length);
    }


     private static class MaxHeap{
        
       
        void init(int[] data){
            this.queue=new int[data.length+1];
            for(int i=0;i<data.length;i++){
                queue[++size]=data[i];
                fixUp(size);
            }
        }
        
        private int size=0;

        private int[] queue;
               
        public int get() {
            return queue[1];
        }

        public void remove() {
            SortUtil.swap(queue,1,size--);
            fixDown(1);
        }
        //fixdown
        private void fixDown(int k) {
            int j;
            while ((j = k << 1) <= size) {
                if (j < size && queue[j]<queue[j+1])
                    j++;
                if (queue[k]>queue[j]) //不用交换
                    break;
                SortUtil.swap(queue,j,k);
                k = j;
            }
        }
        private void fixUp(int k) {
            while (k > 1) {
                int j = k >> 1;
                if (queue[j]>queue[k])
                    break;
                SortUtil.swap(queue,j,k);
                k = j;
            }
        }

    }

}

 

SortUtil:

package org.rut.util.algorithm;

import org.rut.util.algorithm.support.BubbleSort;
import org.rut.util.algorithm.support.HeapSort;
import org.rut.util.algorithm.support.ImprovedMergeSort;
import org.rut.util.algorithm.support.ImprovedQuickSort;
import org.rut.util.algorithm.support.InsertSort;
import org.rut.util.algorithm.support.MergeSort;
import org.rut.util.algorithm.support.QuickSort;
import org.rut.util.algorithm.support.SelectionSort;
import org.rut.util.algorithm.support.ShellSort;

/**
 * @author treeroot
 * @since 2006-2-2
 * @version 1.0
 */
public class SortUtil {
    public final static int INSERT = 1;

    public final static int BUBBLE = 2;

    public final static int SELECTION = 3;

    public final static int SHELL = 4;

    public final static int QUICK = 5;

    public final static int IMPROVED_QUICK = 6;

    public final static int MERGE = 7;

    public final static int IMPROVED_MERGE = 8;

    public final static int HEAP = 9;

    public static void sort(int[] data) {
        sort(data, IMPROVED_QUICK);
    }
    private static String[] name={
            "insert","bubble","selection","shell","quick","improved_quick","merge","improved_merge","heap"
    };
   
    private static Sort[] impl=new Sort[]{
            new InsertSort(),
            new BubbleSort(),
            new SelectionSort(),
            new ShellSort(),
            new QuickSort(),
            new ImprovedQuickSort(),
            new MergeSort(),
            new ImprovedMergeSort(),
            new HeapSort()
    };

    public static String toString(int algorithm){
        return name[algorithm-1];
    }
   
    public static void sort(int[] data, int algorithm) {
        impl[algorithm-1].sort(data);
    }

    public static interface Sort {
        public void sort(int[] data);
    }

    public static void swap(int[] data, int i, int j) {
        int temp = data[i];
        data[i] = data[j];
        data[j] = temp;
    }
}


 JAVA中金额的中文大写方式
 
题意:

读入一个浮点数值,将其转化为中文金额的大写方式.

试验要求:

当金额为整数时,只表示整数部分,省略小数部分,并添加"整"字.

当金额中含有连续的0时,只需要一个"零"即可.

10的表示方式.例如110--壹佰一拾元整,10---一拾元整

  1import java.io.*;
  2class chineseMoney...{
  3    private String number[]=...{"","壹","贰","叁","肆","伍","陆","柒","捌","玖"};
  4    private String unit[]=...{"元","拾","佰","仟","万","拾","佰","仟","亿","拾","佰"};
  5    private String small[]=...{"角","分"};
  6    private String strNumber,strUnit,strAll;
  7
  8    private String onlyInt(int intInt)
  9    ...{
10        String strInt;
11        strInt=String.valueOf(intInt);
12        strNumber="";strUnit="";strAll="";
13        int l=strInt.length ();
14        int j,k,zeorCount;
15        zeorCount=0;
16        for (k=0;k<l;k++)
17        ...{
18            String strTemp=strInt.substring(k,k+1);
19            int intTemp=Integer.parseInt(strTemp);
20            strNumber=number[intTemp];
21            j=l-1-k;
22            strUnit=unit[j];
23            if (intTemp==0)
24            ...{
25                if (zeorCount==0)
26                ...{
27                    strUnit=strUnit.replace('拾','零');
28                    strUnit=strUnit.replace('佰','零');
29                    strUnit=strUnit.replace('仟','零');
30                    strUnit=strUnit.replace('万','零');   
31                }
32                else
33                ...{
34                    strUnit=strUnit.replaceAll("拾","");
35                    strUnit=strUnit.replaceAll("佰","");
36                    strUnit=strUnit.replaceAll("仟","");
37                    strUnit=strUnit.replaceAll("万","");       
38                }
39                zeorCount++;
40            }       
41            strAll+=strNumber+strUnit;
42        }
43        return strAll;
44   
45    }
46   
47    private String onlySmall(int intSmall)
48    ...{
49       
50        strNumber="";strUnit="";strAll="";
51        String strSmall,strTemp;
52        strSmall=String.valueOf(intSmall);
53        int i;
54        if (intSmall>=10)
55        ...{
56            for (i=0;i<strSmall.length();i++)
57            ...{
58                strTemp=String.valueOf(intSmall).substring(i,i+1);
59                if (Integer.parseInt(strTemp)!=0)
60                ...{
61                    strNumber=number[Integer.parseInt(strTemp)];
62                    strUnit=small[i];   
63                    strAll+=strNumber+strUnit;
64                }
65            }
66        }
67        else
68        ...{
69            if (intSmall!=0)
70            ...{
71                strNumber=number[intSmall];
72                strUnit=small[1];   
73                strAll+=strNumber+strUnit;
74            }
75        }
76
77        return strAll;
78    }
79   
80    public String getChineseMoney(double number)
81    ...{
82        //四舍五入
83        number=(number*100+0.5)/100;
84       
85        String strAll,strChineseInt,strChineseSmall,strZheng;;
86        int intInt,intSmall;
87        strChineseInt="";strChineseSmall="";strZheng="";
88       
89        //整数部分
90        intInt=(int)( number*100/100);
91        if (intInt!=0)
92        ...{
93            strChineseInt=onlyInt(intInt);
94        }
95        //小数部分
96        double temp=(number-intInt)*100*100/100;
97        //对小数部分四舍五入
98        intSmall=(int)(temp*100+0.5)/100;
99        if (intSmall!=0)
100        ...{
101            strChineseSmall=onlySmall(intSmall);
102        }
103        else
104        ...{
105            strZheng="整";
106        }
107        strAll=strChineseInt+strChineseSmall+strZheng;
108        return strAll;
109    }
110    public static void main(String args[]) throws IOException
111    ...{
112        chineseMoney cm=new chineseMoney();
113        double money;
114        String strMoney,strChineseMoney;
115        strMoney="";
116        //读取
117        System.out.println("输入货币(四舍五入):");
118        BufferedReader cin = new BufferedReader(new InputStreamReader( System.in));
119        strMoney = cin.readLine();
120        money=Double.parseDouble(strMoney);
121        strChineseMoney=cm.getChineseMoney(money);
122        System.out.println(strChineseMoney);
123    }
124}


 

]]> <![CDATA[用JS写联动]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=13006 jjs_love 2006/3/29 15:36:13 js如下

<%!
public String getDeptUsers(Connection conn) {
 StringBuffer users = new StringBuffer();
 String sql = "SELECT dept_CODE, dept_NAME, user_code, user_name "
      + "FROM SYS_DIC_dept, sys_dic_user "
      + "WHERE user_dept = dept_CODE(+) "
      + "ORDER BY dept_CODE";
 Statement stmt = null;
 ResultSet rs = null;
 
 try {
  
  stmt = conn.createStatement();
  rs = stmt.executeQuery(sql);
  
  while (rs.next()) {
   users.append((rs.getString("dept_CODE") != null ? rs.getString("dept_CODE").trim() : "") + ", "
      + (rs.getString("dept_NAME") != null ? rs.getString("dept_NAME").trim() : "") + ", "
      + (rs.getString("user_code") != null ? rs.getString("user_code").trim() : "") + ", "
      + (rs.getString("user_name") != null ? rs.getString("user_name").trim() : "") + ", ");
  }
  
 } catch (SQLException sqle) {
 } finally {
  try {
   if (rs != null) {
    rs.close();
   }
   
   if (stmt != null) {
    stmt.close();
   }
  } catch (SQLException ignore) {
  }
 }
 
 return users.toString();
}

%>

<script language="javascript" type="text/javascript">
 var deptUsers = new Array();
 var errorMessage = "";
 
 function DeptUser() {
  this.deptId = "";
  this.deptName = "";
  this.userIds = new Array();
  this.userNames = new Array();
 }
 
 function initUserData(users) {
  var tempArr = users.split(", ");
  
  var currId = "";
  var user = null;
  for (var loop=0; loop<tempArr.length-1; loop+=4) {
   if (currId.toUpperCase() != tempArr[loop + 1].toUpperCase()) {
    user = new DeptUser();
    deptUsers.push(user);
    currId = tempArr[loop + 1];   
   }
    
   user.deptId = tempArr[loop];
   user.deptName = tempArr[loop + 1];
   user.userIds.push(tempArr[loop + 2]);
   user.userNames.push(tempArr[loop + 3]);   
  }
 }

 function getDepts(formIndex, deptTarget, name) {
  var target = document.forms[formIndex][deptTarget].options;
  
  for (var index=0; index<deptUsers.length; index++) {
   var opt = new Option();
   opt.value = deptUsers[index].deptId;
   opt.text = deptUsers[index].deptName;
   target.add(opt, index);   
  }
  
  for (var index=0; index<target.length&&name!=""; index++) {
   if (target[index].text == name || target[index].value == name) {
    target[index].selected = true;
   }
  }
 }
 
 function getDeptUsers(formIndex, deptTarget, userTarget, userCode) {
  var deptIndex = -1;
  var targetForm = document.forms[formIndex];
  var dept = targetForm[deptTarget];
  var users = targetForm[userTarget];
  
  for (var index=0; index<dept.options.length; index++) {
   if (dept.options[index].selected) {
    deptIndex = index;
   }
  }
  
  for (var index=0; index<users.length; index++) {
   users.remove(index);
   index--;
  }
  
     for (var index=0; index<deptUsers[deptIndex].userIds.length; index++) {
   var target = users.options;
   var opt = new Option();
   opt.value = deptUsers[deptIndex].userIds[index];
   opt.text = deptUsers[deptIndex].userNames[index];
   target.add(opt, index);
  }
  
  for (var index=0; (index<target.length)&&(userCode!=""); index++) {
   if (target[index].value == userCode) {
    target[index].selected = true;
   }
  }
 }
 
 function addOptions(formIndex, fromName, toName) {
  var targetForm = document.forms[formIndex];
  var optFrom = targetForm[fromName].options;
  var optTo = targetForm[toName].options;
  
  for (var index=0; index<optFrom.length; index++) {
   if (optFrom[index].selected && !isExist(optTo, optFrom[index].text)) {
    var opt = new Option();
    opt.value = optFrom[index].value;
    opt.text = optFrom[index].text;
    optTo.add(opt, optTo.length);
   }
  }
 }
 
 function addAllOptions(formIndex, fromName, toName) {
  var targetForm = document.forms[formIndex];
  var optFrom = targetForm[fromName].options;
  var optTo = targetForm[toName].options;
  
  for (var index=0; index<optFrom.length; index++) {
   if (!isExist(optTo, optFrom[index].text)) {
    var opt = new Option();
    opt.value = optFrom[index].value;
    opt.text = optFrom[index].text;
    optTo.add(opt, optTo.length);
   }
  }
 }
 
 function removeOptions(formIndex, targetName) {
  var target = document.forms[formIndex][targetName].options;
  
  for (var index=0; index<target.length; index++) {
   if (target[index].selected) {
    target.remove(index);
    index--;
   }
  }
 }
 
 function removeAllOptions(formIndex, targetName) {
  var target = document.forms[formIndex][targetName].options;
  
  for (var index=0; index<target.length; index++) {
   target.remove(index);
   index--;
  }
 }
 
 function isExist(object, str) {
  for (var index=0; index<object.length; index++) {
   if (object[index].text == str) {
    return true;
   }
  }
  
  return false;
 }
</script>

jsp如下

   <script>initUserData("<%=getDeptUsers(conn)%>");</script>
          <select name="user_dept" onChange="getDeptUsers(0,'user_dept', 'fileplan_man');">
             <script>getDepts(0,"user_dept");</script>
          </select>
        <select name="fileplan_man">
   <script>getDeptUsers(0,"user_dept", "fileplan_man");</script>
    </select>

]]> <![CDATA[java文件操作大全 (转载)]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=12838 jjs_love 2006/3/23 13:12:25 作者：yesjoy　来源：www.javaresearch.org

java文件操作大全




文件的建立/检查与删除
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>文件的建立、检查与删除</title>
</head>
<body>
<%
String path=request.getRealPath("");
//out.println(path);
File f=new File(path,"File.txt");
//out.println(f);
//out.println(f.exists());

if(f.exists()){//检查File.txt是否存在
f.delete();//删除File.txt文件
out.println(path + "\\File.txt 存在，已删除。");
}else{
f.createNewFile();//在当前目录下建立一个名为File.txt的文件
out.println(path + "\\File.txt 不存在，已建立。");//输出目前所在的目录路径
}
%>

目录的建立/检查与删除
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>目录的建立/检查与删除</title>
</head>
<body>
<%
String path=request.getRealPath("");
path=path + "\\Sub";//将要建立的目录路径
File d=new File(path);//建立代表Sub目录的File对象，并得到它的一个引用
if(d.exists()){//检查Sub目录是否存在
d.delete();
out.println("Sub目录存在，已删除");
}else{
d.mkdir();//建立Sub目录
out.println("Sub目录不存在，已建立");
}
%>
</body>
</html>


如何在JSP中处理虚拟目录
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>JSP中如何处理虚拟目录</title>
</head>
<body>
取得虚拟目录对应的磁盘路径<br>
Web站点主目录的位置为<font color=#ff0000><%=request.getRealPath("/")%></font><br>
JSP网页所在的目录位置<font color=#ff0000><%=request.getRealPath("./")%></font><br>
JSP网页所在目录上一层目录的位置<font color=#ff0000><%=request.getRealPath("../")%></font><br>
</body>
</html>


文件属性的取得
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.util.Date,java.io.*"%>
<html>
<head>
<title>文件属性的取得</title>
</head>
<body>
<%
String path=request.getRealPath("/");
File f=new File(path,"ReadData.txt");
if(f.exists()){
%>
<%=f.getName()%>的属性如下：<br><br>
文件长度为：<%=f.length()%>
<%=f.isFile()?"是文件":"不是文件"%><br>
<%=f.isDirectory()?"是目录":"不是目录"%><br>
<%=f.canRead()?"可读取":"不可读取"%><br>
<%=f.canWrite()?"可写入":"不可写入"%><br>
<%=f.isHidden()?"是隐藏文件":"不是隐藏文件"%><br>
文件的最后修改日期为：<%=new Date(f.lastModified())%><br>
<%
}else{
f.createNewFile();//在当前目录下建立一个名为ReaData.txt的文件
%> 
<%=f.getName()%>的属性如下：<br><br>
文件长度为：<%=f.length()%>
<%=f.isFile()?"是文件":"不是文件"%><br>
<%=f.isDirectory()?"是目录":"不是目录"%><br>
<%=f.canRead()?"可读取":"不可读取"%><br>
<%=f.canWrite()?"可写入":"不可写入"%><br>
<%=f.isHidden()?"是隐藏文件":"不是隐藏文件"%><br>
文件的最后修改日期为：<%=new Date(f.lastModified())%><br>
<%
}
%>
</body>
</html>


取出目录中文件的方法
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>取出目录中文件的方法--列出目录中的文件</title>
</head>
<body>
<%
String path=request.getRealPath("/");
File d=new File(path);//建立当前目录中文件的File对象
File list[]=d.listFiles();//取得代表目录中所有文件的File对象数组
out.println("<font color=#ff0000>" + path + "目录下的文件：</font><br>");
for(int i=0;i<list.length;i++){
if(list<I>.isFile()){
out.println(list<I>.getName() + "<br>");
}
}
out.println("<br><font color=#ff0000>" + path + "目录下的目录：</font><br>");
for(int i=0;i<list.length;i++){
if(list<I>.isDirectory()){
out.println(list<I>.getName() + "<br>");
}
}
%>
</body>
</html>


判断是否为空白文件
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>判断是否为空白文件</title>
</head>
<body>
<%
String path=request.getRealPath("/");
out.println(path);
FileReader fr=new FileReader(path + "\\AtEnd.txt");//建立FileReader对象，并实例化为fr
//对FileReader类生成的对象使用read()方法，可以从字符流中读取下一个字符。
if(fr.read()==-1)//判断是否已读到文件的结尾
{
out.print("AtEnd.txt文件中没有数据<br>");
}else{
out.println("AtEnd.txt文件中有数据");
}
fr.close();
%>
</body>
</html>


读取所有的文件数据
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*,java.lang.*"%>
<html>
<head>
<title>读取所有的文件数据</title>
</head>
<body>
<%
String path=request.getRealPath(".");
FileReader fr=new FileReader(path + "\\ReadData.txt");
//关键在于读取过程中，要判断所读取的字符是否已经到了文件的末尾，并且这个字符是不是文件中的断行符，即判断该字符值是否为13。
int c=fr.read();//从文件中读取一个字符
//判断是否已读到文件结尾
while(c!=-1){
out.print((char)c);//输出读到的数据
c=fr.read();//从文件中继续读取数据
if(c==13){//判断是否为断行字符
out.print("<br>");//输出分行标签
fr.skip(1);//略过一个字符
//c=fr.read();//读取一个字符
}
}
fr.close();
%>
</body>
</html>


一行一行读取数据
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>文件读取</title>
</head>
<body>
<%
String path=request.getRealPath("");//取得当前目录的路径
FileReader fr=new FileReader(path + "\\file\\inc\\t.txt");//建立FileReader对象，并实例化为fr
BufferedReader br=new BufferedReader(fr);//建立BufferedReader对象，并实例化为br
String Line=br.readLine();//从文件读取一行字符串
//判断读取到的字符串是否不为空
while(Line!=null){
out.println(Line + "<br>");//输出从文件中读取的数据
Line=br.readLine();//从文件中继续读取一行数据
}
br.close();//关闭BufferedReader对象
fr.close();//关闭文件
%>
</body>
</html>


略过文件中的字符不读取
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>略过字节不读取</title>
</head>
<body>
<%
String path=request.getRealPath(".");
FileReader fr=new FileReader(path + "\\ReadData.txt");
fr.skip(2);//跳过2个字节
int c=fr.read();//读取一个字节
while(c!=-1){
out.print((char)c);
c=fr.read();
}
fr.close();
%>
</body>
</html>


将数据写入文件
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>将数据写入文件</title>
</head>
<body>
<%
String path=request.getRealPath(".");
FileWriter fw=new FileWriter(path + "\\WriteData.txt");//建立FileWriter对象，并实例化fw
//将字符串写入文件
fw.write("大家好！");
fw.write("本书是《JSP编程技巧》");
fw.write("请多多指教！");
fw.write("email:stride@sina.com");
fw.close();

FileReader fr=new FileReader(path + "\\WriteData.txt");
BufferedReader br=new BufferedReader(fr);//建立BufferedReader对象，并实例化为br
String Line=br.readLine();
//读取一行数据
out.println(Line + "<br>");
br.close();//关闭BufferedReader对象
fr.close();
%>
</body>
</html>


将写入文件的数据分行
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>将写入文件的数据分行</title>
</head>
<body>
<%
String path=request.getRealPath(".");
FileWriter fw=new FileWriter(path + "\\WriteData.txt");
BufferedWriter bw=new BufferedWriter(fw);
bw.write("大家好！");
bw.write("本书是《JSP编程技巧》。");
bw.newLine();//断行
bw.write("请多多指教！");
bw.newLine();//断行
bw.write("email: stride@sina.com");
bw.flush();//将数据更新至文件
fw.close();//关闭文件流
out.println("写入文件内容为：<br>");
FileReader fr=new FileReader(path + "\\WriteData.txt");
BufferedReader br=new BufferedReader(fr);
String Line=br.readLine();//读取一行数据
while(Line!=null){
out.println(Line + "<br>");
Line=br.readLine();
}
fr.close();
%>
</body>
</html>
如何将数据追加写入到文件
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>将写入文件的数据分行</title>
</head>
<body>
<%
String path=request.getRealPath(".");
RandomAccessFile rf=new RandomAccessFile(path + "\\WriteData.txt","rw");//定义一个类RandomAccessFile的对象，并实例化
rf.seek(rf.length());//将指针移动到文件末尾
rf.writeBytes("\nAppend a line to the file!");
rf.close();//关闭文件流
out.println("写入文件内容为：<br>");
FileReader fr=new FileReader(path + "\\WriteData.txt");
BufferedReader br=new BufferedReader(fr);//读取文件的BufferedRead对象
String Line=br.readLine();
while(Line!=null){
out.println(Line + "<br>");
Line=br.readLine();
}
fr.close();//关闭文件
%>
</body>
</html></I></I></I></I>

]]> <![CDATA[url中传中文]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=12739 jjs_love 2006/3/21 11:49:47 　<%@ page language="java" contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*, java.net.*,java.io.*,java.util.* " %>

<%   request.getLocale().setDefault(Locale.CHINA);
  String s="中国人";
        try
  { 
                   s = URLEncoder.encode(s,"UTF-8");
%>  
 <a href="b.jsp?s=<%=s%>">sdf</a>
<% } catch(Exception e){
   out.print(e.getMessage());
   }

%>

如果是用js来处理传中文的问题可以采用如下方法

var title="传中文"; 

var act_str="<%=request.getContextPath()%>/tzwZlTj.do?method=fzTjFx&title="+encodeURIComponent(title);

]]> <![CDATA[ORACLE 中ID自动增加字段]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=12561 jjs_love 2006/3/15 9:14:17 　自动增加字
 CREATE TABLE t_topic (
  topicId       NUMBER(18,0)   NOT NULL  ,                       -- 主题ID
 topicTitle   VARCHAR2(100)  NOT NULL ,                         -- 主题名
 topicContent varchar2(2000) NOT NULL ,                       -- 主题内容
 topicAuthor   VARCHAR2(20)   NOT NULL ,                        -- 主题发表者(论坛帖子发表人)
 topicBoaId   NUMBER(1,0)    NOT NULL REFERENCES t_board(boaId) , -- 主题属于论坛哪个模块
 topicHits     NUMBER(18,0)   DEFAULT '0' ,                    -- 主题点击数
 topicElite   NUMBER(1,0)    DEFAULT '0' ,                     -- 是否为精华帖子 0、否 1、是
 topicTop     NUMBER(1,0)    DEFAULT '0' ,   -- 是否置顶主题 0、否 1、是
 topicLock     NUMBER(1,0)    DEFAULT '0' ,   -- 是否禁止回复 0、否 1、是
 topicDel     NUMBER(1,0)    DEFAULT '0' ,   -- 是否删除回复 0、否 1、是(特殊用途,管理员文章不让跟贴)
 topicPubTime DATE NOT NULL,                -- 主题被创建时间
  topicReNum   NUMBER(18,0)   DEFAULT '0' ,    -- 回复主题的总数
 topicReUser   VARCHAR2(20)   DEFAULT '' ,       -- 最后回复的作者
 topicReTime   DATE           ,      -- 最后回复的时间
 topicIp      VARCHAR2(15) DEFAULT '' ,       -- 发表人的IP
 PRIMARY KEY (topicId)
);

Create Sequence t_topic_Id_sequence                                    --主题序列
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE;

 

CREATE OR REPLACE TRIGGER t_topic_Id_trigger //触发器
BEFORE INSERT
ON t_topic
FOR EACH ROW
DECLARE
newId NUMBER(18,0);
BEGIN
SELECT t_topic_Id_sequence.nextval INTO newId FROM dual;
:new.topicId := newId;
END;

]]> <![CDATA[MYSQL到ORACLE程序迁移的注意事项]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=12493 jjs_love 2006/3/13 14:04:09 　MYSQL到ORACLE程序迁移的注意事项            

         


    有很多应用项目, 刚起步的时候用MYSQL数据库基本上能实现各种功能需求，随着应用用户的增多，
数据量的增加，MYSQL渐渐地出现不堪重负的情况：连接很慢甚至宕机，于是就有把数据从MYSQL迁到
ORACLE的需求，应用程序也要相应做一些修改。本人总结出以下几点注意事项，希望对大家有所帮助。

1． 自动增长的数据类型处理
    MYSQL有自动增长的数据类型，插入记录时不用操作此字段，会自动获得数据值。
ORACLE没有自动增长的数据类型，需要建立一个自动增长的序列号，插入记录时要把序列号的下一个
值赋于此字段。

    CREATE SEQUENCE 序列号的名称 (最好是表名+序列号标记) INCREMENT BY 1  START  WITH  1
MAXVALUE  99999  CYCLE  NOCACHE;
    其中最大的值按字段的长度来定, 如果定义的自动增长的序列号 NUMBER(6) , 最大值为999999
    INSERT 语句插入这个字段值为: 序列号的名称.NEXTVAL

2. 单引号的处理
    MYSQL里可以用双引号包起字符串，ORACLE里只可以用单引号包起字符串。在插入和修改字符串
前必须做单引号的替换：把所有出现的一个单引号替换成两个单引号。

3.  翻页的SQL语句的处理
    MYSQL处理翻页的SQL语句比较简单，用LIMIT 开始位置, 记录个数；PHP里还可以用SEEK定位到结果
集的位置。
    ORACLE处理翻页的SQL语句就比较繁琐了。每个结果集只有一个ROWNUM字段标明它的位置, 并且只能
用ROWNUM<100, 不能用ROWNUM>80。
    以下是经过分析后较好的两种ORACLE翻页SQL语句( ID是唯一关键字的字段名 )：
    语句一：
 SELECT ID, [FIELD_NAME,...] FROM TABLE_NAME WHERE ID IN ( SELECT ID FROM (SELECT
 ROWNUM AS NUMROW, ID FROM TABLE_NAME WHERE 条件1 ORDER BY 条件2) WHERE NUMROW > 80 AND
 NUMROW < 100 ) ORDER BY 条件3;
 
    语句二：
 SELECT * FROM (( SELECT ROWNUM AS NUMROW, c.* from (select [FIELD_NAME,...] FROM
TABLE_NAME WHERE 条件1 ORDER BY 条件2) c) WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY 条件3;

4． 长字符串的处理
    长字符串的处理ORACLE也有它特殊的地方。INSERT和UPDATE时最大可操作的字符串长度小于等于
4000个单字节, 如果要插入更长的字符串, 请考虑字段用CLOB类型，方法借用ORACLE里自带的DBMS_LOB程序
包。插入修改记录前一定要做进行非空和长度判断，不能为空的字段值和超出长度字段值都应该提出警告,
返回上次操作。

5.  日期字段的处理
    MYSQL日期字段分DATE和TIME两种，ORACLE日期字段只有DATE，包含年月日时分秒信息，用当前数据库
的系统时间为SYSDATE, 精确到秒，或者用字符串转换成日期型函数TO_DATE(‘2001-08-01’,’YYYY-MM-DD’)
年-月-日 24小时:分钟:秒 的格式YYYY-MM-DD HH24:MI:SS TO_DATE()还有很多种日期格式, 可以参看
ORACLE DOC.
    日期型字段转换成字符串函数TO_CHAR(‘2001-08-01’,’YYYY-MM-DD HH24:MI:SS’)

    日期字段的数学运算公式有很大的不同。
    MYSQL找到离当前时间7天用
 DATE_FIELD_NAME > SUBDATE（（NOW（），INTERVAL 7 DAY）
  ORACLE找到离当前时间7天用
 DATE_FIELD_NAME >SYSDATE - 7;

6.  空字符的处理
    MYSQL的非空字段也有空的内容，ORACLE里定义了非空字段就不容许有空的内容。
    按MYSQL的NOT NULL来定义ORACLE表结构, 导数据的时候会产生错误。因此导数据时要对空字符进行判
断，如果为NULL或空字符，需要把它改成一个空格的字符串。

7. 字符串的模糊比较
   MYSQL里用  字段名 like '%字符串%'
   ORACLE里也可以用 字段名 like '%字符串%'  但这种方法不能使用索引, 速度不快
   用字符串比较函数  instr(字段名,'字符串')>0  会得到更精确的查找结果 

8. 程序和函数里，操作数据库的工作完成后请注意结果集和指针的释放。

]]> <![CDATA[取得程序的物理路径]]> http://blogger.org.cn/blog/more.asp?name=jjs_love&id=12490 jjs_love 2006/3/13 12:59:55 取得程序的物理路径

 private String getClassPath()
    {
    String strClassName = getClass().getName();
    String strPackageName = "";
    if(getClass().getPackage() != null)
    {
    strPackageName = getClass().getPackage().getName();
    }

    String strClassFileName = "";
    if(!"".equals(strPackageName))
    {
    strClassFileName = strClassName.substring(strPackageName.length() + 1,strClassName.length());
    }
    else
    {
    strClassFileName = strClassName;
    }

    URL url = null;
    url = getClass().getResource(strClassFileName + ".class");
    String strURL = url.toString();
    strURL = strURL.substring(strURL.indexOf('/') + 1,strURL.indexOf("/WEB-INF/"));
    strURL = strURL.replaceAll("%20"," "); //防止路径中存在空格
    return strURL;
    }

]]>