?? webprint.java
字號:
/**
公司：北京方成科技發展有限公司
作者：梅勇
日期：2001.08.24
*/
import java.io.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
//import explato.database.*;
import sun.io.ByteToCharConverter;
import org.xml.sax.* ;
import org.apache.xerces.dom.TextImpl;
import org.w3c.dom.Attr;
import org.w3c.dom.Document;
import org.w3c.dom.NamedNodeMap;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import dom.DOMParserWrapper;
import dom.wrappers.DOMParser;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class WebPrint extends HttpServlet {
private int iPosition=1; //用于fc_select類查詢中傳位置參數
//數據源名稱,用戶名,密碼.用于報表查詢時連接另外的數據源使用,用于fc_select1,fc_select2
private String strDataSource="";
private String strUserName="";
private String strPassword="";
private String strXml="";
private ResultSet rs = null;
private ResultSet rs1 = null;
private ResultSet rs2 = null;
private Connection con = null;
//private ConnectionManager cm=null;
private Document document=null;
private javax.sql.DataSource ds=null;
public void init() {
try {
/* Create a connection to the WebLogic JNDI Naming Service:
*/
javax.naming.InitialContext ctx = new InitialContext();
/* Create a new DataSource by Locating It in the Naming Service:
OracleThinPool is the name of the connection pool name configed in the WebLogic server container.
WebLogic data connection pool configration:
{
URL: jdbc:oracle:thin:@pyds:1521:toptais //"toptais" is database name in our RDBMS. "pyds" is DB server name.
Driver Classname: oracle.jdbc.driver.OracleDriver
Properties (key=value): user=scott
password=tiger
dll=ocijdbc8
protocol=thin
}
*/
ds = (javax.sql.DataSource)
ctx.lookup ("sqlpool");
} catch (Exception E) {
/*
Handle exception here.
*/
System.out.println("Init Error: " + E);
}
}
public void doPost(HttpServletRequest req,
HttpServletResponse res)
throws IOException, ServletException
{
//設置演示版,
/*
long Time1=1026000000+23328000;
long curTime=0;
curTime=System.currentTimeMillis();
curTime=curTime/1000;
//每天的時間為 86400
if(curTime>Time1){
System.out.println("演示版已到期,系統將不正常!");
return ;
}
//------------------
*/
res.setContentType("text/html;charset=UTF-8");
PrintWriter out = res.getWriter();
try {
//ServletContext application = getServletContext();
//ConnectionManager cm= (ConnectionManager)application.getAttribute("fcConPoolManager");
//cm=(ConnectionManager)application.getAttribute ( "fcConPoolManager" );
//demo是配置文件中邏輯數據庫的名字，同時也是連接池的名字
// String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
// String sConnStr = "jdbc:odbc:ereport";
// Class.forName(sDBDriver);
// con = DriverManager.getConnection(sConnStr,"sa","");
//con = cm.getConnection( "demo" ); //或者 con = cm.getConnection( "demo", 30000 ); //30000是不能馬上取到連接時的等待時間(以毫秒計)
con = ds.getConnection();
//-----------------------
/*
Statement stmt = con.createStatement();
//rs = stmt.executeQuery("SELECT * FROM test");
con.setAutoCommit(false);
stmt.executeUpdate("insert into test values('aaa','adfsdfsd')");
int tran1=stmt.getUpdateCount();
if (tran1>0){
con.commit();
}else{
con.rollback();
}
// out.println("tran1="+tran1);
/*String tt;
while (rs.next()) {
tt = rs.getString("fstr1");
out.print("<LI>" + rs.getString("fstr2") + "</LI>");
out.print("<pre>" + tt + "</pre>");
}
rs.close();*/
//----------------------
} catch (Exception e){
//out.println("讀表發生錯誤");
System.out.println("Service Error: " + e);
}
/*
finally {
if( con != null ){
cm.freeConnection( "demo", con );
}
}
*/
//-------------------------------------------------------
//strKey為？后的值
String strKey=new String(req.getQueryString());
//計算前臺SEND來的XML串 存入strXml中
BufferedReader in = req.getReader();
String line = null;
strXml="";
while ((line = in.readLine()) != null) {
strXml=strXml+line;
}
//parse XML串
try {
DOMParserWrapper parser =
(DOMParserWrapper)Class.forName("dom.wrappers.DOMParser").newInstance();
document = parser.parseXml(strXml);
}
catch (Exception e) {
}
//--------------------------------------------------------
//用一個CASE語句來處理各種方法
if (strKey.equals("fillcombox")) out.print(fillcombox());
//用于用SQL語句填充combox
if (strKey.equals("GetReportCell")) out.print(GetReportCell()); //跨表取數
if (strKey.equals("fc_insert")) out.print(fc_insert());
if (strKey.equals("fc_insert1")) out.print(fc_insert1()); //新增主子表
if (strKey.equals("fc_update1")) out.print(fc_update1()); //新增主子表
if (strKey.equals("fc_select")) out.print(fc_select());
if (strKey.equals("fc_FieldToTable")) out.print(fc_FieldToTable());
if (strKey.equals("GetDB")) out.print(GetDB());
if (strKey.equals("fc_select1")) out.print(fc_select1()); //多個SQL同時查的查詢
if (strKey.equals("fc_select2")) out.print(fc_select2()); //明細和匯總都要的查詢
if (strKey.equals("twors")) out.print(twors());//兩個結果集的測試
if (strKey.equals("sqltoxml")) out.print(sqltoxml());//兩個結果集的測試
if (strKey.equals("dsnSetSession"))
{
Node root = document.getChildNodes().item(0);
String strName=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
String strValue="";
try {
//當此節點值為空時
strValue=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
}
catch (Exception e) { }
HttpSession session = req.getSession(true);
session.setAttribute(strName, strValue);
out.print("");
}
if (strKey.equals("dsnGetSession"))
{
Node root = document.getChildNodes().item(0);
String strName=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
HttpSession session = req.getSession(true);
String strSR=session.getAttribute(strName).toString();;
out.print(strSR);
}
if (strKey.equals("loadprint")) {
String strX="function%20detachPage%28%29%7B%20htmlToptmp%3DhtmlTop%3B%20htmlBottomtmp%3DhtmlBottom%3B%20var%20iStart%3D0%3B%20var%20iEnd%3D0%3B%20var%20lngEndLine%3Dt.rows.length-tabCauda%3B%20var%20colwidthXML%3DLoadUserData%28%22setcolwidth%22%2C%22ReportColWidth%22+ReportName%29%3B%20effectiveWidth%3DparseInt%28repWidth-tabLeft-tabRight%29%3B%20var%20oXML1%3Dnew%20ActiveXObject%28%22Microsoft.XMLDOM%22%29%3B%20oXML1.async%3D%22false%22%3B%20oXML1.loadXML%28%22%3Croot%3E%22%20+colwidthXML+%22%3C/root%3E%22%29%3B%20sumcol%3D0%3B%20var%20compressRate%3D1%3B%20if%28prnSet.compressWidth%3D%3D1%29%20%7B%20for%20%28var%20j%3D0%3Bj%3CMaxCols%3Bj++%29%7B%20if%20%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colSelect%22%29%3D%3D%22block%22%29%7B%20sumcol%3Dsumcol+parseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29%3B%20%7D%20%7D%20compressRate%3DeffectiveWidth/%28sumcol+MaxCols%29%3B%20if%28compressRate%3E%3D1%20%29%20%7B%20compressRate%3D1%3B%20%7D%20compressColWidth%28compressRate%29%3B%20%7D%20var%20hcompressRate%3D1%3B%20var%20t_outerHTMLbak%3Dt.outerHTML%3B%20if%28prnSet.compressHeight%3D%3D1%29%20%7B%20cur1%3D0%3B%20for%20%28var%20i%3DtabHead%3Bi%3ClngEndLine%3Bi++%29%20%7B%20cur1%3Dcur1+parseInt%28t.rows%28i%29.style.height%29%3B%20%7D%20hcompressRate%3D%28repHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29/%28cur1+lngEndLine-tabHead%29%20%3B%20if%28hcompressRate%3E%3D1%20%29%20%7B%20hcompressRate%3D1%3B%20%7D%20compressRowHeight%28hcompressRate%2CtabHead%2ClngEndLine%29%3B%20%7D%20if%20%28prnSet.compressFont%21%3D1%29%20%7B%20var%20compressFont%3D0%3B%20if%28hcompressRate%3CcompressRate%29%20%7B%20compressFont%3DhcompressRate%3B%20%7D%20else%20%7B%20compressFont%3DcompressRate%3B%20%7D%20if%28compressFont%3C1%29%7B%20t.style.fontSize%3DparseFloat%28t.style.fontSize%29*compressFont%3B%20%7D%20%7D%20setAutoturnRow%28%29%3B%20cur1%3D0%3B%20for%20%28var%20i%3DtabHead%3Bi%3ClngEndLine%3Bi++%29%20%7B%20cur1%3Dcur1+parseInt%28t.rows%28i%29.style.height%29%3B%20if%20%28cur1%3E%3DrepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%7C%7C%20i%3D%3DlngEndLine-1%29%7B%20if%20%28cur1%3D%3DrepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%20%7B%20cur1%3D0%3B%20%7D%20else%20%7B%20cur1%3DparseInt%28t.rows%28i%29.style.height%29%3B%20%7D%20sumcol%3D0%3B%20var%20bFind%3Dfalse%3B%20iStart%3D0%3B%20iEnd%3D0%3B%20if%20%28i%3D%3DlngEndLine-1%29%7B%20perPageHTML%3DperPageHTML+t.rows%28i%29.outerHTML%20%3B%20%7D%20for%20%28var%20j%3D0%3Bj%3CMaxCols%3Bj++%29%7B%20if%20%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colSelect%22%29%3D%3D%22block%22%29%7B%20sumcol%3Dsumcol+parseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29*compressRate%3B%20%7D%20if%20%28sumcol%3E%3DeffectiveWidth%20%7C%7C%20j%3D%3DMaxCols-1%29%7B%20if%20%28sumcol%3C%3DeffectiveWidth%29%7B%20iEnd%3Dj%3B%20sumcol%3D0%3B%20%7D%20else%20%7B%20iEnd%3Dj-1%3B%20sumcol%3DparseInt%28oXML1.documentElement.childNodes.item%28j%29.getAttribute%28%22colWidth%22%29%29*compressRate%3B%20%7D%20var%20s1%3DHideCol%28strCol%2CiStart%2CiEnd%29%3B%20bFind%3Dtrue%3B%20PageDataAdd%28Pages%29%3B%20arrPage%5BPages%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+PageHeadHTML%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+perPageHTML+PageCaudaHTML+%22%3C/Table%3E%22%20+%22%3Cimg%20%3E%22%3B%20if%20%28i%3D%3DlngEndLine-1%29%7B%20if%28cur1%3ErepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%7B%20PageDataAdd%28Pages+1%29%3B%20arrPage%5BPages+1%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages+1%5D%3DarrPage%5BPages+1%5D+PageHeadHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20%7D%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20if%20%28%28j%3D%3DMaxCols-1%20%29%20%26%26%20%28iEnd%3D%3Dj-1%29%20%29%7B%20var%20s1%3DHideCol%28strCol%2CMaxCols-1%2CMaxCols-1%29%3B%20bFind%3Dtrue%3B%20PageDataAdd%28Pages%29%3B%20arrPage%5BPages%5D%3DhtmlTop+htmlBottom+tabstyle+s1%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+PageHeadHTML%3B%20arrPage%5BPages%5D%3DarrPage%5BPages%5D+perPageHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20if%20%28i%3D%3DlngEndLine-1%29%7B%20if%28cur1%3ErepHeight-tabBottom-tabTop-PageHeadHeight-PageCaudaHeight-heightTop-heightBottom%29%7B%20PageDataAdd%28Pages+1%29%3B%20arrPage%5BPages+1%5D%3DhtmlTop+htmlBottom+tabstyle+s1%20%3B%20arrPage%5BPages+1%5D%3DarrPage%5BPages+1%5D+PageHeadHTML+PageCaudaHTML+%22%3C/Table%3E%22+%22%3Cimg%20%3E%22%3B%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20%7D%20biglabel.innerHTML%3Dbiglabel.innerHTML%20+%22%3Cdiv%20class%3DpreviewDiv%20%3E%u6B63%u5728%u8BA1%u7B97...%3C/DIV%3E%22%3B%20Pages%3DPages+1%3B%20%7D%20iStart%3DiEnd+1%3B%20%7D%20%7D%20perPageHTML%3D%22%22%3B%20%7D%20perPageHTML%3DperPageHTML+t.rows%28i%29.outerHTML%20%3B%20%7D%20mdblRate%3D1%3B%20htmlTop%3D%22%22%3B%20htmlBottom%3D%22%22%3B%20t.outerHTML%3Dt_outerHTMLbak%3B%20t.style.display%3D%22none%22%3B%20for%28var%20i%3D0%3Bi%3CPages%3Bi++%29%7B%20arrPage%5Bi%5D%3Dfc_RepStr%28arrPage%5Bi%5D%2C%22%28P%29%22%2CPages+%22%22%29%3B%20%7D%20%7D%20";
out.println(strX);
}
}
//下面是自定義的方法
//--------------------------------------
//兩個結果集的示例,第一個用連接池打開,第二個用一般方式打開
private String twors() {
// Node root = document.getChildNodes().item(0);
// String sField=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
// String sTable=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
String strSql="select flngVoucherID,fstrVoucherTypeName from Voucher" ;
String sTmp="";
try {
Statement stmt = con.createStatement();
rs = stmt.executeQuery(strSql);
while (rs.next()) {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:ereport";
Class.forName(sDBDriver);
Connection con1 = DriverManager.getConnection(sConnStr,"sa","");
String sT=rs.getString(1);
Statement stmt1 = con1.createStatement();
rs1 = stmt1.executeQuery("select fstrAccountName from voucherdetail Where flngVoucherId="+sT);
while (rs1.next()) {
System.out.println("科目:"+rs1.getString(1));
}
}
}
catch (Exception e){
sTmp=e.getMessage() ;
}
return sTmp;
}
//--------------------------------------
private String fc_FieldToTable() {
Node root = document.getChildNodes().item(0);
String sField=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
String sTable=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
String strSql="select "+sField+" From "+sTable ;
String sTmp="";
try {
Statement stmt = con.createStatement();
rs = stmt.executeQuery(strSql);
}
catch (Exception e){
sTmp=e.getMessage() ;
}
return sTmp;
}
//--------------------------------------
private String GetDB() {
Node root = document.getChildNodes().item(0);
String sConnect=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
String sSql=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
sSql=fcTrans(sSql);
//System.out.println(sSql);
String sR="";
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //建立數據庫連接
String sConnStr = "jdbc:odbc:"+sConnect ;
try {
Class.forName(sDBDriver);
con = DriverManager.getConnection(sConnStr,"sa","");
Statement stmt = con.createStatement();
rs = stmt.executeQuery(sSql);//執行查詢建立結果集
if (rs.next()) {
sR=rs.getString(1);
}
rs.close();
stmt.close();
}
catch (Exception e){
sR=e.getMessage();
}
return sR;
}
//--------------------------------------
private String fc_select() {
Node root = document.getChildNodes().item(0);
String strSql=root.getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
String strPageNo=root.getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
int iPageNo=Integer.parseInt(strPageNo,10);//頁號
String strPageSize=root.getChildNodes().item(2).getChildNodes().item(0).getNodeValue();
int iPageSize=Integer.parseInt(strPageSize,10);//頁尺寸
strSql=fcTrans(strSql);
//System.out.println("fc_select:"+strSql);
String strX = "<root>";
String sTmp = "";
int iField=1;
int iCount=1;
int i=1;
try {
Statement stmt = con.createStatement();
rs = stmt.executeQuery(strSql);
ResultSetMetaData rsmd=rs.getMetaData();
while (rs.next()) {
//每頁30行
if (i>(iPageNo-1)*iPageSize && i<=iPageNo*iPageSize) {
strX = strX + "<record>";
iCount=rsmd.getColumnCount();
for (iField = 1 ; iField<=iCount ;iField++ )
{
//當有NULL字段名時,表示此則無需給值.用fcnull標記名區分.
String colName=rsmd.getColumnName(iField);
if (colName==null) {
strX = strX + "<fcnull></fcnull>" ;
}
else {
String sT=rs.getString(iField);
if (sT==null) sT="";
strX = strX + "<fc>" + sT +"</fc>" ;
}
}
strX = strX + "</record>";
}
i = i + 1;
}
i=i-1;
if (i>0) {
strX = strX + "<pages>"+i+"</pages>";
}
strX = strX + "</root>";
rs.close();
}
catch (Exception e){
sTmp=e.getMessage() ;
System.out.println(sTmp);
e.printStackTrace();
}
return strX ;
}
//--------------------------------------
private String fc_select1() {
//將頁號和頁尺寸兩個節點從第一個子節點和第二個子節點改為第一個子節點下的第一個子節點和第二個子節點
//將第二個子節點空出來給設置數據源用.
//第二個子節點下將有三個子節點:數據源名稱,用戶名,密碼.
Node root = document.getChildNodes().item(0);
String strPageNo=root.getChildNodes().item(0).getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
int iPageNo=Integer.parseInt(strPageNo,10);//頁號
String strPageSize=root.getChildNodes().item(0).getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
int iPageSize=Integer.parseInt(strPageSize,10);//頁尺寸
//數據源
strDataSource=root.getChildNodes().item(1).getChildNodes().item(0).getChildNodes().item(0).getNodeValue();
strUserName=root.getChildNodes().item(1).getChildNodes().item(1).getChildNodes().item(0).getNodeValue();
try {
strPassword=root.getChildNodes().item(1).getChildNodes().item(2).getChildNodes().item(0).getNodeValue();
}
catch (Exception e){
strPassword="";
}
//-------
//多SQL查詢
String strX = "<root>";
int ii=0;
int i=1;
//按順序取出SQL節點
for(ii=2;ii<root.getChildNodes().getLength();ii++){
String strSql=root.getChildNodes().item(ii).getChildNodes().item(0).getNodeValue();
strX=strX+fc_selectTmp(iPageNo,iPageSize,i,strSql);
i=iPosition;
} //For循環結束
i=i-1;
if (i>0) {
strX = strX + "<pages>"+i+"</pages>";
}
strX = strX + "</root>";
return strX ;
}
//--------------------------------------
//計算一個SQL查詢,供fc_select1 fc_select2類函數使用
private String fc_selectTmp(int iPageNo,int iPageSize,int iPos,String strSql) {
//iPageNo為起始頁號,iPageSize為頁尺寸,iPos為所有查詢結果的行位置,strSql為要執行的SQL語句
//返回SQL語句的運行結果,結果為以<record>...</record>形式的XML串
//
strSql=fcTrans(strSql);
String sTmp = "";
String strX = "";
int iField=1;
int iCount=1;
int i=iPos;
try {
//String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
//String sConnStr = "jdbc:odbc:"+strDataSource;
//Class.forName(sDBDriver);
Connection conTmp = ds.getConnection();
Statement stmtTmp = conTmp.createStatement();
ResultSet rsTmp = stmtTmp.executeQuery(strSql);
ResultSetMetaData rsmdTmp=rsTmp.getMetaData();
while (rsTmp.next()) {
//每頁30行
if (i>(iPageNo-1)*iPageSize && i<=iPageNo*iPageSize) {
strX = strX + "<record>";
iCount=rsmdTmp.getColumnCount();
for (iField = 1 ; iField<=iCount ;iField++ )
{
//當有NULL字段名時,表示此則無需給值.用fcnull標記名區分.
String colName=rsmdTmp.getColumnName(iField);
if (colName==null) {
strX = strX + "<fcnull></fcnull>" ;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -