为什么使用<%@ include file=; %>出错?
main.jsp的代码:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Test";
Connection conn= DriverManager.getConnection(url);
String sql ="select * from a_oper where (myid=?) and (mypass=?)";
PreparedStatement
stmt=conn.prepareStatement(sql);
//String user=request.getParameter("user");
//String pwd=request.getParameter("pwd");
stmt.setString(1,request.getParameter("user"));
stmt.setString(2,request.getParameter("pwd"));
ResultSet rs=stmt.executeQuery();
if (rs.next()){%>
<%@ include page="test.jsp"; %>
<%}else{
out.print("登陆失败!");}%>
<%rs.close();
stmt.close();
conn.close();
%>
</HTML>
test.jsp的代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<HEAD><TITLE>Welcome User</TITLE></HEAD>
<BODY>
<%String user=request.getParameter("user"); %>
<H3>Welcome <%= (user==null) ? "" : user %></H3>
<P><B> Today is <%= new java.util.Date() %>. Have a nice day! :-)</B></P>
<b>Enter Name:</b>
<FORM METHOD=post>
<INPUT TYPE="text" name="user" size=15>
<INPUT TYPE="SUBMIT" value="submit name">
</FORM>
<%Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:Test"; //pubs为你的数据库的
//String usr="sa";
//String password="";
Connection conn= DriverManager.getConnection(url);
Statement
stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql ="select * from a_test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
第一个字段内容为:<%=rs.getString(1)%>
第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功!");%>
<%rs.close();
stmt.close();
conn.close();
%>
</BODY>
在运行main.jsp页面时出现如下错误:
org.apache.jasper.compiler.ParseException: E:\tomcat\jakarta-tomcat-4.0-b1\webapps\ROOT\test\main.jsp(18,30) Attribute ; has no value
请哪位兄弟解答一下,分不够可以再加.