ireportÔÚjspÖеĵ÷ÓÃÀý×Ó
<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>
<%@ page import="java.io.*,java.sql.*,net.sf.jasperreports.engine.*" %>
<%@ page import="com.microsoft.sqlserver.jdbc.SQLServerDriver" %>
<%@ include file="/common/header.jsp" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<title>±¨±í´òÓ¡</title>
<link rel="stylesheet" type="text/css" href="<s:property value="%{default_css}"/>" />
</head>
<body id="Body">
<%
String reportName = request.getParameter("reportName");
//±¨±í±àÒëÖ®ºóµÄ.jasperÎļþµÄ´æ·ÅλÖÃ
File reportFile = new File(application.getRealPath("/report/resource/jasper/"+reportName+".jasper"));
String url = "jdbc:sqlserver://liubin:1433;DatabaseName=db_forest_police";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
//´«µÝ±¨±íÖÐÓõ½µÄ²ÎÊýÖµ£¬ÕâÀïÊÇ¿ÕÖµ
Map parameters = new HashMap();
System.out.println("-----------conn---------");
//Á¬½Óµ½Êý¾Ý¿â
Connection conn = DriverManager.getConnection(url,"sa","time0442");
System.out.println("----------jasper begin-----------");
//ÔÚ¿ØÖÆÌ¨´òÓ¡±¨±íÎļþµÄÎïÀí·¾¶
System.out.println("****ÎïÀí·¾¶ ***"+reportFile.getPath());
&nb
Ïà¹ØÎĵµ£º
ÓÉÓÚϵͳÐèÇó£¬×î½üÔÚ¿ª·¢¹ý³ÌÖн«ÏµÍ³´ÓÔÀ´µÄMySQL×ªÒÆµ½SQL
2000Ï£¬ÆäÖÐÓöµ½ÁËÖî¶àÎÊÌ⣬»¨·ÑÁËÎÒ²»ÉÙʱ¼ä¡£ÏÖÔÚ°ÑÎҵľÑéÄóöÀ´¸æËß´ó¼Ò£¬ºÃÈôó¼ÒÉÙ×ßÍä·£¬½ÚԼʱ¼ä¡£
¡¡¡¡Ê×ÏÈÊÇSQL
2000Êý¾Ý¿âµÄ°²×°ÎÊÌ⣬ÔÚ´ËÎÒÖ÷Òª½²Ð©¹ØÓÚSQL 2000µÄ°æ±¾Óë²Ù×÷ϵͳµÄ¼æÈÝÐÔÎÊÌ⣺SQL
2000×ܹ²ÓÐ7¸ö²»Í¬°æ±¾£¬ÊÊ ......
ÅäÖóÌÐòµÄÔËÐÐĿ¼ÓëJDBCÊý¾ÝÔ´:
<Context path="/test" docBase="F:\JSPLesson\test" reloadable="true">
<Resource name="jdbc/bookstore" auth="Container" type="javax.sql.DataSource"
maxActive="1 ......
<%@ page contentType="text/html; charset=GBK" language="java"%>
<%
String[] cookiename = {"JSESSIONID","SECURE_AUTH_ROOT_COOKIE","SECURITY_AUTHENTICATION_COOKIE"};
for(int index = 0, len = cookiename.length; index < len; index ++) {
javax.servlet.http.Cookie c = new javax.s ......
ºÍJavaÒ»Ñù£¬JSPÊÇĿǰ±È½ÏÈÈÃŵÄÒ»¸ö»°Ìâ¡£ËüÊÇÒ»ÖÖÔÚ·þÎñÆ÷¶Ë±àÒëÖ´ÐеÄWebÉè¼ÆÓïÑÔ£¬ÒòΪ½Å±¾ÓïÑÔ²ÉÓÃÁËJava£¬ËùÒÔJSP¼Ì³ÐÁËJavaµÄËùÓÐÓŵ㡣¿ÉÊÇÔÚʹÓÃJSP³ÌÐòµÄ¹ý³ÌÖУ¬³£Óöµ½ÖÐÎÄÂÒÂëÎÊÌ⣬ºÜ¶àÈËΪ´ËÍ·ÌÛ²»ÒÑ£¬±ÊÕß¾ÍÉîÊÜÆäº¦£¬¶øÇÒʹÓÃÆ½Ì¨²»Í¬£¬ÖÐÎÄÂÒÂëÎÊÌâµÄ½â¾ö·½·¨Ò²²»Í¬£¬ÎÞÐÎÖÐÔö¼ÓÁËѧϰJSPµÄÄѶȡ£Æäʵ£¬Ô ......
JSP ʵÔÚservlet Ö®ºó·¢Õ¹ÆðÀ´µÄ¼¼Êõ¡£
ÔËÐлúÖÆ£º
1£ºjspÎļþÌá½»·þÎñÆ÷£¬·þÎñÆ÷ £¨Tomcat£©£¬³õʼ»¯ ÇëÇóºÍÏìÓ¦¶ÔÏó £¬È»ºóÅжÏjspÎļþÊÇ·ñ´æÔÚ £¬Èç¹û²»´æÔÚ 404 ´íÎ󣬴æÔÚ £¬±àÒë³ÉΪ ¡£java Îļþ ----¡·¡£class Îļþ ¡£¾ÍÊÇÒ»¸öjavaµÄÀà £¬Õâ¸öÀà £¬¼Ì³Ð×Ô httpjspbase £¬Õâ¸öhttpjsppageÀà ÓÖ ÊµÏÖÁË» ......