然后我测试如下
2.jsp
<%@ page import="java.io.*"%>
<%@include file="1.jsp"%>
<%
out.print(as);
%>
1.jsp <%
String as="hello word";
%>
结果可以输出 hello word
2.jsp
<%@ page import="java.io.*"%>
<%@include file="1.jsp"%>
<%
out.print(as);
%>
1.jsp <%
String as="hello word";
%>
结果可以输出 hello word
Stmt没有定义 但是我在data.jsp里面定义了 为什么?
<%@ page contentType="text/html;charset=gb2312"%>;
<%@ page import="java.sql.*"%>;
<%@ page import="java.util.*"%>;
<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
String company_date=request.getParameter("company_date");
String sql="insert into company(company_date) values ('"+company_date+"')";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try{
Conn=DriverManager.getConnection("jdbc:odbc:crm","","");
Stmt=Conn.createStatement();
Stmt.executeUpdate(sql);
out.print("Ìí¼Ó×ÊÁÏÍê³ÉÊÇ·ñ¼ÌÐø£¿");
}
catch(Exception e){
out.print(""); };
%>
文件一调用文件二
<%@ page contentType="text/html;charset=gb2312"%>;
<%@ page import="java.sql.*"%>;
<%@ page import="java.util.*"%>;
<%
String company_date=request.getParameter("company_date");
String sql="insert into company (company_date) values ('"+company_date+"')";
try{
Stmt.executeUpdate(sql);
out.print("Ìí¼Ó×ÊÁÏÍê³ÉÊÇ·ñ¼ÌÐø£¿");
}
catch(Exception e){
out.print(""); };
%>
文件二
<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
String company_date=request.getParameter("company_date");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try{
Conn=DriverManager.getConnection("jdbc:odbc:crm","","");
Stmt=Conn.createStatement();
}
catch(Exception e){
out.print(""); };
%>不可以用
文件一调用文件二
<%@ page contentType="text/html;charset=gb2312"%>;
<%@ page import="java.sql.*"%>;
<%@ page import="java.util.*"%>;
<%
String company_date=request.getParameter("company_date");
String sql="insert into company (company_date) values ('"+company_date+"')";
try{
Stmt.executeUpdate(sql);
out.print("Ìí¼Ó×ÊÁÏÍê³ÉÊÇ·ñ¼ÌÐø£¿");
}
catch(Exception e){
out.print(""); };
%>
文件二
<%
java.sql.Connection Conn;
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
String company_date=request.getParameter("company_date");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
try{
Conn=DriverManager.getConnection("jdbc:odbc:crm","","");
Stmt=Conn.createStatement();
}
catch(Exception e){
out.print(""); };
%>不可以用
<%@ include file="data.jsp"%>了没?
报措说是Stmt没有声明和定义
可是我在data.jsp里面声明和定义了
java.sql.Statement Stmt;
java.sql.ResultSet Rst;
------------>
java.sql.Connection Conn = null;
java.sql.Statement Stmt = null;
java.sql.ResultSet Rst = null;
应该初始化,因为文件二中连接数据库可能出异常
java.lang.ClassNotFoundException: com.microsoft.sqlserver.SQLServerDriver
is an unknown class in DynamicClassLoader[SimpleLoader[/D:/resin/resin-3.0.0-beta/doc/WEB-INF/work]]
at com.caucho.loader.DynamicClassLoader.loadClass(DynamicClassLoader.java:546)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at _crm._11__jsp._jspService(/crm/data.jsp:4)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.pageservice(Page.java:549)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:184)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:221)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:257)
at com.caucho.server.port.WorkerThread.run(WorkerThread.java:123)
at java.lang.Thread.run(Thread.java:536)
换成sqlserver啊?驱动包没找到。