请教大家,我写个类,向表user中更新用户的口令,在执行JSP过程中出现:org.apache.jasper.JasperException: Unable to compile class for JSP这样的错误,请大家帮我看看是什么原因?多谢啦!表user中包括3个字段,id(自动编号),user_name(用户名),user_password(用户口令)在JSP中调用:
Record1 oq=new Record1();
oq.modiRecord(cartManager.getUserName(),request.getParameter("userPassword"));
Record1类如下:
package cart;
import java.sql.*;
import java.util.*;
import java.math.*;
public class Record1
{
public static String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
public static String sConnStr = "jdbc:odbc:cart";
public static Connection conn = null;
public void modiRecord(String userName,String userPassword) throws SQLException
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("Record: " + e.getMessage());
}
String sql="update user set user_password=? where user_name=? ";
try
{
conn = DriverManager.getConnection(sConnStr);
PreparedStatement prepStmt = conn.prepareStatement(sql);
prepStmt.setString(1,userPassword);
prepStmt.setString(2,userName);
prepStmt.executeUpdate();
}
catch(SQLException ex)
{
System.err.println("Record " + ex.getMessage());
}
}
}
Record1 oq=new Record1();
oq.modiRecord(cartManager.getUserName(),request.getParameter("userPassword"));
Record1类如下:
package cart;
import java.sql.*;
import java.util.*;
import java.math.*;
public class Record1
{
public static String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
public static String sConnStr = "jdbc:odbc:cart";
public static Connection conn = null;
public void modiRecord(String userName,String userPassword) throws SQLException
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("Record: " + e.getMessage());
}
String sql="update user set user_password=? where user_name=? ";
try
{
conn = DriverManager.getConnection(sConnStr);
PreparedStatement prepStmt = conn.prepareStatement(sql);
prepStmt.setString(1,userPassword);
prepStmt.setString(2,userName);
prepStmt.executeUpdate();
}
catch(SQLException ex)
{
System.err.println("Record " + ex.getMessage());
}
}
}
oq.modiRecord("tom","123456");