csgo配置要求高吗:jsp 编程问题 null 值

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/27 11:05:15
exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 10 in the jsp file: /login_confirm.jsp

Generated servlet error:
[javac] Compiling 1 source file

D:\jsp相关软件\tomcat5.0\tomcat5.0\Tomcat 5.0\work\Catalina\localhost\190Site\org\apache\jsp\login_005fconfirm_jsp.java:65: cannot resolve symbol
symbol : class connData
location: class connData.connData
connData.connData loginBean = null;
^

An error occurred at line: 10 in the jsp file: /login_confirm.jsp

Generated servlet error:
D:\jsp相关软件\tomcat5.0\tomcat5.0\Tomcat 5.0\work\Catalina\localhost\190Site\org\apache\jsp\login_005fconfirm_jsp.java:67: cannot resolve symbol
symbol : class connData
location: class connData.connData
loginBean = (connData.connData) pageContext.getAttribute("loginBean", PageContext.PAGE_SCOPE);
^

An error occurred at line: 10 in the jsp file: /login_confirm.jsp

Generated servlet error:
D:\jsp相关软件\tomcat5.0\tomcat5.0\Tomcat 5.0\work\Catalina\localhost\190Site\org\apache\jsp\login_005fconfirm_jsp.java:69: cannot resolve symbol
symbol : class connData
location: class connData.connData
loginBean = new connData.connData();
^
3 errors

package connData;
import java.sql.*;
public class connData
{
String DBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String DBname="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=login";
String DBuser="sa";
String DBpassword="";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
public connData()
{
try
{
Class.forName(DBDriver);
}
catch(ClassNotFoundException e)
{
System.err.println("类找不到");
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(DBname,DBuser,DBpassword);
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("SQL异常");
}
return rs;
}
public void executeUpdate(String sql)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(DBname,DBuser,DBpassword);
stmt=conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.out.print("SQL异常");
}
}
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
System.out.print("关闭失败");
}
}
public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
System.out.print("关闭异常");
}
}
}

有哪位高手指点一下
处理LOGIN页面的JSP:

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*"%>
/*<%@ include file="codeToString.txt"%>*/
<%@ page import="connData.connData"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=gb2312">
<title>注册确认</title>
</head>
<body>
<jsp:useBean id="loginBean" scope="page" class="connData.connData"/>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
String sql=new String("select*from loginInfo where username='"+username.trim()+"' and password='"+password.trim()+"'");
ResultSet rs=loginBean.executeQuery(sql);
if(rs.next())
{
rs.close();
loginBean.closeStmt();
loginBean.closeConn();
%>
<jsp:forward page="index.jsp"/>
<%
}
else
{
rs.close();
loginBean.closeStmt();
loginBean.closeConn();
%>
<jsp:forward page="regist.jsp"/>
<%
}
%>
</body>
</html>

把你的jsp代码贴出来看下
我把我的jsp代码先给你,你可以对比下,我的用的是sql server自带的类,可以直接编译运行
============================================================
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
String sql="select * from jobs";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>

</body>
</html>