lyggkj/gkaq/yjpt-java/trunk/yjpt/Service.jsp

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.io.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.net.*" %>
<%@ page import="DBstep.iDBManager2000.*" %>
<%@ page import="DBstep.*" %>
<%@page import="oracle.jdbc.OracleResultSet"%>
<%@page import="oracle.sql.BLOB"%>

<%
    DBstep.iDBManager2000 ObjConnBean = new DBstep.iDBManager2000();
	String mCommand;
	String mDocumentID = "";
	String mSignatureID = "";
	byte[] mSignature;	
	String mSignatures;
	String strSql;
  String mUserName;
  String mExtParam;
	int mSignatureSize;
	String mSignature_1="";
	
	boolean mResult;
	java.lang.String KeyName;                 //文件名
	java.io.File ObjFile;                     //文件对象
	java.io.FileReader ObjFileReader;         //读文件对象
	char[] ChrBuffer;                        //缓冲
	int intLength;                            //实际读出的字符数

	String mSignatureName;			  //印章名称
	String mSignatureUnit;			  //签章单位
	String mSignatureUser;			  //持章人
	String mSignatureSN;			  //签章SN
	String mSignatureGUID;			  //全球唯一标识符

	String mMACHIP;			  //机器IP
	String OPType;			  //操作标志
	String mKeySn;       //KEY序列号
	mCommand=request.getParameter("COMMAND");
	mUserName=new String(request.getParameter("USERNAME").getBytes("8859_1"));
	mExtParam=new String(request.getParameter("EXTPARAM").getBytes("8859_1"));

    System.out.println("");
    System.out.println("ReadPackage");
    System.out.println(mCommand);    
	if(mCommand.equalsIgnoreCase("SAVESIGNATURE")){        //保存签章数据信息
		mDocumentID=new String(request.getParameter("DOCUMENTID").getBytes("8859_1"));
		mSignatureID=new String(request.getParameter("SIGNATUREID").getBytes("8859_1"));
		mSignature=request.getParameter("SIGNATURE").getBytes("8859_1");
	    mSignatureSize=mSignature.length;
		System.out.println("DocuemntID:"+mDocumentID);
		System.out.println("SignatureID:"+mSignatureID);
		//System.out.println("Signature:"+mSignature);
   		if (ObjConnBean.OpenConnection()){
			  strSql="SELECT * from HTMLSignature Where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
    		ResultSet rs = null;
    		rs = ObjConnBean.ExecuteQuery(strSql);
    		if (rs.next()) {
       			//strSql = "update HTMLSignature set DocumentID='"+mDocumentID+"',SIGNATUREID='"+mSignatureID+"',Signature='"+mSignature+"'";
       			//strSql = strSql + "  Where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
		    	strSql="update HTMLSignature set DocumentID=?,SignatureID=?,SignatureSize=?,Signature=EMPTY_BLOB() where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
		    	//ObjConnBean.ExecuteUpdate(strSql);
    		}else{  			
				  //取得唯一值(mSignature)
   				java.util.Date dt=new java.util.Date();
   				long lg=dt.getTime();
   				Long ld=new Long(lg);
   				mSignatureID=ld.toString();
       			strSql="insert into HTMLSignature (DocumentID,SignatureID,SignatureSize,Signature) values (?,?,?,EMPTY_BLOB()) ";	
       			}   
       			rs.close();	
       			try{	
        			java.sql.PreparedStatement prestmt=null;			
		    	    prestmt=ObjConnBean.Conn.prepareStatement(strSql);
        			prestmt.setString(1, mDocumentID);
			        prestmt.setString(2, mSignatureID);
			        prestmt.setInt(3, mSignatureSize);
			        ObjConnBean.Conn.setAutoCommit(true);
        			prestmt.execute();
		    	    ObjConnBean.Conn.commit();
        			prestmt.close();
			        Statement stmt = null;
			         ObjConnBean.Conn.setAutoCommit(false);
		            stmt = ObjConnBean.Conn.createStatement();
		            OracleResultSet update = (OracleResultSet) stmt.executeQuery("select Signature from HTMLSignature where DocumentID=" + mDocumentID + " and SignatureID=" + mSignatureID + " for update");
		            if (update.next()) {
		              try {
		                // PutAtBlob(((oracle.jdbc.OracleResultSet) update).getBLOB("FileBody"), SignatureSize);
		                BLOB vField=((oracle.jdbc.OracleResultSet) update).getBLOB("Signature");
		                OutputStream outstream = vField.getBinaryOutputStream();
				        outstream.write(mSignature, 0, mSignatureSize);
				        outstream.close();
		              }
		              catch (IOException e) {
		                System.out.println(e.toString());
		                mResult = false;
		              }
		            }
		            update.close();
		            stmt.close();
		            ObjConnBean.Conn.commit();
		            mSignature = null; 
            		mResult = true;
				}
      			catch(SQLException e){
       		 		System.out.println("保存签章错误:"+e.toString());
        			mResult=false;
      			}
    		
  		ObjConnBean.CloseConnection();
  		}
		out.clear();
		out.print("SIGNATUREID="+mSignatureID+"\r\n");
		out.print("RESULT=OK");
	}

	if(mCommand.equalsIgnoreCase("GETNOWTIME")){         //获取服务器时间
		java.sql.Date mDate;
		Calendar cal  = Calendar.getInstance();
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
		String mDateTime=formatter.format(cal.getTime());
		out.clear();
		out.print("NOWTIME="+mDateTime+"\r\n");
		out.print("RESULT=OK");
	}
	if(mCommand.equalsIgnoreCase("DELESIGNATURE")){   //删除签章数据信息
		mDocumentID=request.getParameter("DOCUMENTID");
		mSignatureID=request.getParameter("SIGNATUREID");
		System.out.println("DocuemntID:"+mDocumentID);
		System.out.println("SignatureID:"+mSignatureID);
   		if (ObjConnBean.OpenConnection()){
  			strSql="SELECT * from HTMLSignature Where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
			ResultSet rs=null;
			rs = ObjConnBean.ExecuteQuery(strSql);
			if(rs.next()){
				try{
					strSql="DELETE from HTMLSignature Where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
					ObjConnBean.ExecuteUpdate(strSql);
				}
				catch(Exception ex){
					out.println(ex.toString());
				}
			}
			ObjConnBean.CloseConnection();
  		}
		out.clear();
		out.print("RESULT=OK");
	}

	if(mCommand.equalsIgnoreCase("LOADSIGNATURE")){    //调入签章数据信息
		mDocumentID=request.getParameter("DOCUMENTID");
		mSignatureID=request.getParameter("SIGNATUREID");
		System.out.println("DocuemntID:"+mDocumentID);
		System.out.println("SignatureID:"+mSignatureID);
   		if (ObjConnBean.OpenConnection()){
  			strSql="SELECT * from HTMLSignature Where SignatureID='"+mSignatureID+"' and DocumentID='"+mDocumentID+"'";
			ResultSet rs=null;
			rs = ObjConnBean.ExecuteQuery(strSql);
			if(rs.next()){
			try{
				
					mSignatureSize=rs.getInt("SignatureSize");
					BLOB vField=((OracleResultSet) rs).getBLOB("Signature");
					mSignature=new byte[mSignatureSize];
					InputStream instream = vField.getBinaryStream();
					instream.read(mSignature, 0, mSignatureSize);
	        		instream.close();
	        		mSignature_1=new String(mSignature);
	        	}
	        	catch (IOException ex) {
                	System.out.println(ex.toString());
               }
			}
			ObjConnBean.CloseConnection();
  		}
  		System.out.println(mSignature_1);
		out.clear();
		out.print(mSignature_1+"\r\n");
		out.print("RESULT=OK");
	}


	if(mCommand.equalsIgnoreCase("SHOWSIGNATURE")){   //获取当前签章SignatureID，调出SignatureID，再自动调LOADSIGNATURE数据
		  mDocumentID=request.getParameter("DOCUMENTID");
		  System.out.println("DocuemntID:"+mDocumentID);
    	mSignatures="";
   		if (ObjConnBean.OpenConnection()){
  			strSql="SELECT * from HTMLSignature Where DocumentID='"+mDocumentID + "'";
			ResultSet rs=null;
			rs = ObjConnBean.ExecuteQuery(strSql);
			while(rs.next()){
				mSignatures=mSignatures+rs.getString("SignatureID")+";";
			}
			ObjConnBean.CloseConnection();
  		}
		out.clear();
		out.print("SIGNATURES="+mSignatures+"\r\n");
		out.print("RESULT=OK");
	}


	//---------------------------------------------------------------------------------------
	if(mCommand.equalsIgnoreCase("GETSIGNATUREDATA")){           //批量签章时，获取所要保护的数据
		String mSignatureData = "";
		mDocumentID = request.getParameter("DOCUMENTID");
		System.out.println(new String(request
				.getParameter("FIELDSLIST").getBytes("8859_1")));
		System.out.println(request.getParameter("FIELDSNAME"));
		 
		String targetUrl = "http://" + request.getServerName() + ":"
				+ request.getServerPort() + request.getContextPath()
				+ "/GetmSignatureData.do" + "?documentID="
				+ mDocumentID;
		try {
			URL url = new URL(targetUrl);
			HttpURLConnection connection = (HttpURLConnection) url
					.openConnection();// 此时cnnection只是为一个连接对象,待连接中 
			connection.setRequestMethod("GET");
			//设置通用的请求属性  
			connection.setRequestProperty("accept", "*/*");
			connection.setRequestProperty("connection", "Keep-Alive");
			connection
					.setRequestProperty("user-agent",
							"Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)");

			connection.connect();
			BufferedReader bf = new BufferedReader(
					new InputStreamReader(connection.getInputStream(),
							"gb2312"));
			String line;
			StringBuilder sb1 = new StringBuilder(); // 用来存储响应数据

			// 循环读取流,若不到结尾处
			while ((line = bf.readLine()) != null) {
				sb1.append(line);
			}
			bf.close(); // 重要且易忽略步骤 (关闭流,切记!) 
			connection.disconnect(); // 销毁连接

			String result = "";
			try {
				result = java.net.URLDecoder.decode(sb1.toString(),
						"gb2312");
			} catch (UnsupportedEncodingException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		 
			String[] arrResult = result.split("\r\n");
			Map<String, String> map = new HashMap<String, String>();//字符串转换为map
			for (String tmp : arrResult) {
				String[] arrTmp = tmp.split("=");
				try {
					map.put(arrTmp[0].trim(), arrTmp[1]);
				} catch (Exception e) {
					map.put(arrTmp[0], "");
				}
			}

			//---------------------------------------------------------------------------
			StringBuffer sb = new StringBuffer();
			sb.append("BH=" + (map.get("BH")!=null?map.get("BH").trim():null)+ "\r\n");
			sb.append("ZYDW=" +(map.get("ZYDW")!=null?map.get("ZYDW").trim():null) + "\r\n");
			sb.append("ZYWTR="+(map.get("ZYWTR")!=null?map.get("ZYWTR").trim():null) + "\r\n");
			sb.append("CM=" + (map.get("CM")!= null?map.get("CM").trim():null) + "\r\n");
			sb.append("XCGLFZR=" + (map.get("XCGLFZR")!=null? map.get("XCGLFZR").trim():null) + "\r\n");
			sb.append("WXHWMCBH=" +(map.get("WXHWMCBH")!=null? map.get("WXHWMCBH").trim():null) + "\r\n");
			sb.append("WPBH=" + (map.get("WPBH")!=null? map.get("WPBH").trim():null) + "\r\n");
			sb.append("JSPM=" + (map.get("JSPM")!=null? map.get("JSPM").trim():null) + "\r\n");
			sb.append("BZ=" + (map.get("BZ")!=null? map.get("BZ").trim():null) + "\r\n");
			sb.append("WXPLB=" +(map.get("WXPLB")!=null? map.get("WXPLB").trim():null) + "\r\n");
			sb.append("BYZD4=" +(map.get("BYZD4")!=null? map.get("BYZD4").trim():null) + "\r\n");
			sb.append("INOROUT=" +(map.get("INOROUT")!=null? map.get("INOROUT").trim():null) + "\r\n");
			sb.append("ZYSL=" +(map.get("ZYSL")!=null? map.get("ZYSL").trim():null) + "\r\n");
			sb.append("SG=" + (map.get("SG")!=null? map.get("SG").trim():null) + "\r\n");
			sb.append("XG=" + (map.get("XG")!=null? map.get("XG").trim():null) + "\r\n");
			sb.append("MAO=" + (map.get("MAO")!=null? map.get("MAO").trim():null) + "\r\n");
			sb.append("HZWXX=" +(map.get("HZWXX")!=null? map.get("HZWXX").trim():null) + "\r\n");
			sb.append("DXDJ=" + (map.get("DXDJ")!=null? map.get("DXDJ").trim():null) + "\r\n");
			sb.append("WRLB=" + (map.get("WRLB")!=null? map.get("WRLB").trim():null) + "\r\n");
			sb.append("JZXSL=" +(map.get("JZXSL")!=null? map.get("JZXSL").trim():null) + "\r\n");
			sb.append("HC=" +(map.get("HC")!=null? map.get("HC").trim():null) + "\r\n");
			sb.append("HWZL=" +(map.get("HWZL")!=null? map.get("HWZL").trim():null) + "\r\n");
			sb.append("HWXS=" +(map.get("HWXS")!=null? map.get("HWXS").trim():null) + "\r\n");
			sb.append("LHXZ=" +(map.get("LHXZ")!=null? map.get("LHXZ").trim():null) + "\r\n");
			sb.append("ZYDD=" +(map.get("ZYDD")!=null? map.get("ZYDD").trim():null) + "\r\n");
			sb.append("ZYSJQ=" +(map.get("ZYSJQ")!=null? map.get("ZYSJQ").trim():null) + "\r\n");
			sb.append("ZYSJZ=" +(map.get("ZYSJZ")!=null? map.get("ZYSJZ").trim():null) + "\r\n");
			sb.append("AQFFCS=" +(map.get("AQFFCS")!=null? map.get("AQFFCS").trim():null) + "\r\n");
			sb.append("BGR=" +(map.get("BGR")!=null? map.get("BGR").trim():null) + "\r\n");
			sb.append("LXFS=" +(map.get("LXFS")!=null? map.get("LXFS").trim():null) + "\r\n");
			sb.append("BGSJ=" +(map.get("BGSJ")!=null? map.get("BGSJ").trim():null) + "\r\n");
			sb.append("BYZD2=" +(map.get("BYZD2")!=null? map.get("BYZD2").trim():null) + "\r\n");
			//审核前审核的数据还没入库
			//sb.append("SHYJ=" +(map.get("SHYJ")!=null? map.get("SHYJ").trim():null) + "\r\n");
			//sb.append("SHR=" +(map.get("SHR")!=null? map.get("SHR").trim():null) + "\r\n");
			//sb.append("SHSJ=" + (map.get("SHSJ")!=null? map.get("SHSJ").trim():null) + "\r\n");
			mExtParam = URLDecoder.decode(mExtParam,"utf-8");
			//System.out.println(mExtParam);
			sb.append(mExtParam);
			//##############################################################

			//mSignatureData = session.getAttribute("mSignatureData").toString();
			//session.putValue("mSignatureData",null);
			mSignatureData = sb.toString();

		} catch (Exception e) {
			e.printStackTrace();
		}

		 
		mSignatureData = java.net.URLEncoder.encode(mSignatureData);
		out.clear();
		out.print("SIGNATUREDATA=" + mSignatureData + "\r\n");
		out.print("RESULT=OK");
	}

	if(mCommand.equalsIgnoreCase("PUTSIGNATUREDATA")){            //批量签章时，写入签章数据
		mDocumentID=new String(request.getParameter("DOCUMENTID").getBytes("8859_1"));
		mSignature=request.getParameter("SIGNATURE").getBytes("8859_1");
		mSignatureSize=mSignature.length;
   		if (ObjConnBean.OpenConnection()){
      			java.sql.PreparedStatement prestmt=null;
      			try{
				//取得唯一值(mSignature)
    				java.util.Date dt=new java.util.Date();
    				long lg=dt.getTime();
    				Long ld=new Long(lg);
    				mSignatureID=ld.toString();
        			String Sql="insert into HTMLSignature (DocumentID,SignatureID,SignatureSize,Signature) values (?,?,?,EMPTY_BLOB()) ";
		    	    prestmt =ObjConnBean.Conn.prepareStatement(Sql);
        			prestmt.setString(1, mDocumentID);
			        prestmt.setString(2, mSignatureID);
    	    		prestmt.setInt(3, mSignatureSize);
			        ObjConnBean.Conn.setAutoCommit(true);
        			prestmt.execute();
		    	    ObjConnBean.Conn.commit();
        			prestmt.close();
			        Statement stmt = null;
			        ObjConnBean.Conn.setAutoCommit(false);
		            stmt = ObjConnBean.Conn.createStatement();
		           OracleResultSet update = (OracleResultSet) stmt.executeQuery("select Signature from HTMLSignature where DocumentID=" + mDocumentID + " and SignatureID=" + mSignatureID + " for update");
		            if (update.next()) {
		              try {
		                BLOB vField=((oracle.jdbc.OracleResultSet) update).getBLOB("Signature");
		                OutputStream outstream = vField.getBinaryOutputStream();
				        outstream.write(mSignature, 0, mSignatureSize);
				        outstream.close();
		                mSignature_1=new String(mSignature);
		              }
		              catch (IOException e) {
		                System.out.println(e.toString());
		                mResult = false;
		              }
		            }
		            update.close();
		            stmt.close();
		            ObjConnBean.Conn.commit();
		            mSignature = null; 
			        mResult=true;
    	  		}
      			catch(SQLException e){
       		 		System.out.println(e.toString());
        			mResult=false;
      			}
  		ObjConnBean.CloseConnection();
  		}
		out.clear();
		out.print("SIGNATUREID="+mSignature_1+"\r\n");
		out.print("RESULT=OK");
	}

	//---------------------------------------------------------------------------------------


	if(mCommand.equalsIgnoreCase("SIGNATUREKEY")){
		//mUserName=new String(request.getParameter("USERNAME").getBytes("8859_1")); 
		String RealPath =mUserName+"\\"+mUserName+".key";
		KeyName=application.getRealPath(RealPath);

		ObjFile=new java.io.File(KeyName);         //创建文件对象 
		ChrBuffer=new char[10];
		try{
			if(ObjFile.exists()){//文件存在 
				InputStreamReader isr=new InputStreamReader(new FileInputStream(KeyName));
				//ObjFileReader = new java.io.FileReader(ObjFile); 		//创建读文件对象 
				//ObjFileReader.skip(1);
				//ObjFileReader.read(ChrBuffer, 0, 1);
				//System.out.println(ChrBuffer);
				while((intLength=isr.read(ChrBuffer))!=-1){    //读文件内容 
					out.write(ChrBuffer,0,intLength);         
				} 
				out.write("\r\n");
				out.write("RESULT=OK");
				isr.close(); //关闭读文件对象 
			} 
			else{
				out.println("File Not Found"+KeyName); //文件不存在 
			} 
		}
		catch(Exception e){
                        
			System.out.println(e.toString());
		}		
	}



	if(mCommand.equalsIgnoreCase("SAVEHISTORY")){    //保存签章历史信息
		mSignatureName=new String(request.getParameter("SIGNATURENAME").getBytes("8859_1"));//印章名称
		mSignatureUnit=new String(request.getParameter("SIGNATUREUNIT").getBytes("8859_1"));//印章单位
		mSignatureUser=new String(request.getParameter("SIGNATUREUSER").getBytes("8859_1"));//印章用户名
		mSignatureSN=new String(request.getParameter("SIGNATURESN").getBytes("8859_1"));//印章序列号
		mSignatureGUID=new String(request.getParameter("SIGNATUREGUID").getBytes("8859_1"));//全球唯一标识
		mDocumentID=new String(request.getParameter("DOCUMENTID").getBytes("8859_1"));//页面ID
		mSignatureID=new String(request.getParameter("SIGNATUREID").getBytes("8859_1"));//签章序列号
		mMACHIP=new String(request.getParameter("MACHIP").getBytes("8859_1"));//签章机器IP
		OPType=new String(request.getParameter("LOGTYPE").getBytes("8859_1"));//日志标志
    mKeySn=new String(request.getParameter("KEYSN").getBytes("8859_1"));//KEY序列号
    if (ObjConnBean.OpenConnection()){
      java.sql.PreparedStatement prestmt=null;
      try{
				java.sql.Date mDate;
				Calendar cal  = Calendar.getInstance();
        SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
				String mDateTime=formatter.format(cal.getTime());

        strSql="insert into HTMLHistory(SignatureName,SignatureUnit,SignatureUser,SignatureSN,";
        strSql=strSql+"SignatureGUID,DocumentID,SignatureID,IP,LogTime,LogType,KeySN)";
        strSql=strSql+" values(?,?,?,?,?,?,?,?,?,?,?)";
        prestmt =ObjConnBean.Conn.prepareStatement(strSql);

        prestmt.setString(1, mSignatureName);
        prestmt.setString(2, mSignatureUnit);
        prestmt.setString(3, mSignatureUser);
        prestmt.setString(4, mSignatureSN);
        prestmt.setString(5, mSignatureGUID);
        prestmt.setString(6, mDocumentID);
        prestmt.setString(7, mSignatureID);
        prestmt.setString(8, mMACHIP);
        prestmt.setString(9,mDateTime);
        prestmt.setString(10,OPType);
        prestmt.setString(11,mKeySn);
        ObjConnBean.Conn.setAutoCommit(true);
        prestmt.execute();
        ObjConnBean.Conn.commit();
        prestmt.close();
        mResult=true;
      }
      catch(SQLException e){
        System.out.println(e.toString());
        mResult=false;
      }
  		ObjConnBean.CloseConnection();
    }
		out.clear();
		out.print("SIGNATUREID="+mSignatureID+"\r\n");
		out.print("RESULT=OK");
	}
%>