出现Logon failed,不知道是为啥。
jsp1.jsp:
<%@ page import="com.crystaldecisions.report.web.viewer.CrystalReportViewer" %>
<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%@ page import="com.crystaldecisions.report.web.viewer.*" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.*"%>
<%@ page import="com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2" %>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.FormulaField" %>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="com.crystaldecisions.sdk.occa.report.data.IConnection"%>
<%@ page import="java.sql.ResultSet,
java.beans.Statement,
java.sql.DriverManager,
java.sql.*,
com.crystaldecisions.reports.reportengineinterface.JPEReportSourceFactory,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSourceFactory2,
com.crystaldecisions.sdk.occa.report.reportsource.IReportSource,
com.crystaldecisions.report.web.viewer.CrystalReportViewer,
com.crystaldecisions.reports.reportengineinterface.JPEReportSource"%>
<%@ page import="com.crystaldecisions.sdk.occa.report.toolbar.Toolbar"%>
<LINK rel="stylesheet" type="text/css" href="../crystalreportviewers/css/default.css">
<%
IReportSource reportSource = null;
if(reportSource == null)
{
String report = "/Report2.rpt";
IReportSourceFactory2 rptSrcFactory = new JPEReportSourceFactory();
reportSource = (IReportSource) rptSrcFactory.createReportSource(report,request.getLocale());
session.setAttribute("reportSource",reportSource);
}
ConnectionInfos connInfos = new ConnectionInfos();
IConnectionInfo connInfo1 = new ConnectionInfo();
connInfo1.setUserName("vcmresource");
connInfo1.setPassword("vcmresource");
connInfos.add(connInfo1);
CrystalReportViewer viewer = new CrystalReportViewer();
viewer.setReportSource(reportSource);
viewer.setEnableLogonPrompt(false);
viewer.setDatabaseLogonInfos(connInfos);
viewer.setHasRefreshButton(true);
viewer.setHasLogo(false);
viewer.setPrintMode(CrPrintMode.ACTIVEX);
viewer.setOwnPage(true);
viewer.setOwnForm(true);
viewer.refresh();
viewer.processHttpRequest(request,response,getServletConfig().getServletContext(),out);
viewer.dispose();
%>
<html>
<head>
<title>jsp1</title>
</head>
<body bgcolor="#ffffff">
<br>
<br>
<h1>JBuilder Generated JSP</h1>
<form method="post" action="jsp1.jsp">
<br>
<br>
<input type="submit" name="Submit" value="Submit">
<input type="reset" value="Reset">
<p>
<a href="jsp4.jsp">
<H1>jps4</H1>
</a>
</p>
</form>
</body>
</html>
Web.xml:
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" version="2.4">
<display-name>MyWebModule</display-name>
<jsp-config>
<taglib>
<taglib-uri>/crystal-tags-reportviewer.tld</taglib-uri>
<taglib-location>/WEB-INF/crystal-tags-reportviewer.tld</taglib-location>
</taglib>
</jsp-config>
<context-param>
<param-name>crystal_image_uri</param-name>
<param-value>crystalreportviewers10</param-value>
</context-param>
<env-entry>
<env-entry-name>jdbc/Xtreme Sample Database 10</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>!sun.jdbc.odbc.JdbcOdbcDriver!jdbc
dbc:Xtreme Sample Database 10</env-entry-value>
</env-entry>
<env-entry>
<env-entry-name>jdbc/oracle_net42</env-entry-name>
<env-entry-type>java.lang.String</env-entry-type>
<env-entry-value>!oracle.jdbc.driver.OracleDriver!jdbc
racle:thin
192.168.1.213:1521
racle</env-entry-value>
</env-entry>
</web-app>
