webprint.java

一个完整的

				String sConnStr = "jdbc:odbc:webprint"; 
				Class.forName(sDBDriver);
				Connection con1 = DriverManager.getConnection(sConnStr,"sa",""); 
				Statement stmt1 = con1.createStatement();
				rs1 = stmt1.executeQuery("select max(flngSendOutID) From SendOut");
				if (rs1.next()) {
					sID=rs1.getString(1);
				}
			}
			catch (Exception e2){
			}
		}

		//追加子表内容
		for(i=1;i<root.getChildNodes().getLength();i++) {
		    strSql=root.getChildNodes().item(i).getChildNodes().item(0).getNodeValue();
			strSql=fcTrans(strSql);
			strSql=strSql+sID+" )";
			stmt.executeUpdate(strSql);
		}

	}
	catch (Exception e){
		System.out.println(e.getMessage()) ;
	}
	
	return sTmp ;

}
//--------------------------------------
private String fc_update1() {
//凭证修改
	Node root = document.getChildNodes().item(0);
	String sTmp = "";
	String strSql="";
	try {
		Statement stmt = con.createStatement();
		int i;

		for(i=0;i<root.getChildNodes().getLength();i++) {
		    strSql=root.getChildNodes().item(i).getChildNodes().item(0).getNodeValue();
			strSql=fcTrans(strSql);
			stmt.executeUpdate(strSql);
		}

	}
	catch (Exception e){
		System.out.println(e.getMessage()) ;
	}
	
	return sTmp ;

}
//--------------------------------------
private String SqlToField(String strSql) {
//用一个SQL语句返回一个字段的第一个记录值
	String strR =  "";
	try {
		Statement stmt = con.createStatement();
		rs = stmt.executeQuery(strSql);
		if (rs.next()) {
		    strR = rs.getString(1) ;
		}
		rs.close();
		stmt.close();
	}
	catch (Exception e){
			//out.println("读表发生错误");
		}
	return strR;

}


//--------------------------------------
//通用函数
private String rTrim(String str){
     String rstr = str;
  if(str == null)
         {
    rstr = "";
  }
         else
         {
    if(str.length() == 0) rstr = "";
    if(str.length() > 0)
    {
      for(int i = str.length() ; i  >  0 ; i--)
             {
     if(str.substring(i-1,i).equals(" "))  
       rstr = rstr.substring(0,i-1);
     else break;
   }
     } 
       
  }
  return rstr;
} 

//--------------------------------------------
private String  XmlOut(ResultSet oRs , String sRowEntityName,long EntFormat ) 
{
	String sSet="";
	try {
		//oRs.first();
		while (oRs.next())
		{
		    sSet = sSet + RecordToXMLEntity(oRs, sRowEntityName, EntFormat) ;
		}
	}
	catch (Exception e)
	{
		return e.getMessage();
	}
	return sSet ;
}

private String  RecordToXMLEntity(ResultSet oRs , String EntityName,long EntFormat)
{
	String sEty ="";
	int iField=1;
	int iCount=1;
    try {
	    ResultSetMetaData rsmd=oRs.getMetaData();
		iCount=rsmd.getColumnCount();
		if (EntFormat==1) 
		{
		//属性
	        sEty = "<" + EntityName ;
	
	        for (iField = 1 ; iField<=iCount ;iField++ ) 
			{
	            sEty = sEty + " " + rsmd.getColumnName(iField) +"='" + oRs.getString(iField) +"'" ;
			}
	        sEty = sEty + "/>" + "\n";
		
		}
		else
		{
		//节点
		    sEty = "<" + EntityName +">" +"\n" ;
	        for (iField = 1 ; iField<=iCount ; iField++) 
	        {
	            sEty = sEty +"<" +  rsmd.getColumnName(iField) +">" + oRs.getString(iField) +"</" + rsmd.getColumnName(iField) +">";
	        }
	        sEty = sEty +"\n" +"</" + EntityName +">" +"\n";
	
		}
	}
	catch (Exception e)
	{
	}
	return sEty;
}
//-----------------------------------------------------
private Attr[] sortAttributes(NamedNodeMap attrs) {

    int len = (attrs != null) ? attrs.getLength() : 0;
    Attr array[] = new Attr[len];
    for ( int i = 0; i < len; i++ ) {
        array[i] = (Attr)attrs.item(i);
    }
    for ( int i = 0; i < len - 1; i++ ) {
        String name  = array[i].getNodeName();
        int    index = i;
        for ( int j = i + 1; j < len; j++ ) {
            String curName = array[j].getNodeName();
            if ( curName.compareTo(name) < 0 ) {
                name  = curName;
                index = j;
            }
        }
        if ( index != i ) {
            Attr temp    = array[i];
            array[i]     = array[index];
            array[index] = temp;
        }
    }

    return(array);

} // sortAttributes(NamedNodeMap):Attr[]


private  String fcTrans(String sSource) 
{
	//
	//XML节点中的汉字经8859_1==>UTF-8转换后用System.out.println输出正常

	String unicodesR ="";
	try {
		byte [] by = sSource.getBytes("8859_1"); //GB2312
		unicodesR = new String(by,"UTF-8");
	}
	catch (Exception e)
	{
	}
	//System.out.println(unicodesR);
	return unicodesR;
	///


}
//--------------------------------------------
//WebCode中用
private  String sqltoxml() 
{
		Node root=document.getChildNodes().item(0);

		String strpage=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
		String strsql=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
		strsql=fcTrans(strsql);
		String strsearch=root.getChildNodes().item(2).getChildNodes().item(0).getNodeValue();
		String strrownum=root.getChildNodes().item(3).getChildNodes().item(0).getNodeValue();
		String showcheckbox=root.getChildNodes().item(4).getChildNodes().item(0).getNodeValue();
		String blnempty=root.getChildNodes().item(5).getChildNodes().item(0).getNodeValue();
		//加空行
		showcheckbox=showcheckbox.toUpperCase();
		int intpage=Integer.parseInt(strpage);//开始页
		int intrownum=Integer.parseInt(strrownum);//页尺寸
		String strX="";
	try {

//建立数据库连接
		Statement stmt = con.createStatement();

		
//执行查询建立结果集
//-----------------
		//System.out.print(strsearch);
		int i=1;
		if (strsearch.compareTo("###")!=0){
			rs = stmt.executeQuery(strsql);
			boolean bfind=false;
	
			while(rs.next()){
				String searchone=rs.getString(1);
					//out.print(searchone);
				if (searchone.equals(strsearch)){
					bfind=true;
					break;
				}
				i=i+1;
			}
			rs.close();
			if (bfind==true){
				if (i<=intrownum){
					intpage=1;
				}
				else {
					if (i%intrownum>0){
						intpage=i/intrownum+1;
					}
					else {
						intpage=i/intrownum;
					}
				}
			}
			//自动定位到当前选择所在值的页
		}
		//out.print("intpage="+intpage);
//-----------------
//		System.out.print(intpage);



		rs = stmt.executeQuery(strsql);

		ResultSetMetaData rsmd=rs.getMetaData();

		strX="<root>";
		String sLabel="";
		int k=0;
		int thisrow=0;
		int pagenumber=0;//总页数
		int iFind=0; //控制在开始处插入一个空白行
		while (rs.next()) {
			if (blnempty.equals("true") && iFind==0) {
			//插入一个空白行
				strX=strX+"<tr height='16'>";
				for (i=1;i<=rsmd.getColumnCount();i++) {
			        strX = strX + "<td></td>";
				}
				strX=strX+"</tr>";
				iFind=1;
			}

			if (k>=(intpage-1)*intrownum && k<(intpage)*intrownum){
				strX = strX + "<tr>";
				for (i=1;i<=rsmd.getColumnCount();i++) {
			        sLabel=rsmd.getColumnLabel(i);
			        //System.out.println(rsmd.getColumnTypeName(i));
					String sT=rs.getString(i);
					if (sT==null) sT="";
			        strX = strX + "<td>" + sT + "</td>";
				}
				if (showcheckbox.equals("TRUE"))
				 	strX = strX + "<td width='30'><input type='checkbox'></input></td>"+"</tr>";
                else 
                    strX = strX + "</tr>";
			}
			k=k+1;
		}

		if (k%intrownum>0)
    		pagenumber=k/intrownum+1;
       	else 
           	pagenumber=k/intrownum;

		strX=strX+"<pagenumber>"+pagenumber+"</pagenumber><intpage>"+intpage+"</intpage></root>";
		

	} catch (Exception e){
		strX=e.getMessage();
	}
	return strX;
}

}