java无法解析为类型jsp_无法编译JSP类：DataConnection无法解析为类型

我在执行tomcat 7服务器中的jsp文件时遇到以下错误。 请帮忙无法编译JSP类：DataConnection无法解析为类型

注：我是jsp的新手，甚至对于java，所以位详细的解释将不胜感激。

An error occurred at line: 26 in the jsp file: /checkLoginRedirect.jsp

DataConnection cannot be resolved to a type

23:

24: try

25: {

26: DataConnection cs = new DataConnection();

27: int res = cs.getResultSet("select * from mnpgui",0);

28:

29: if(res==1)

JSP文件

pageEncoding="ISO-8859-1"%>

NDT

String admin = request.getParameter("adminID");

String password = request.getParameter("adminPW");

session.setAttribute("userName",admin);

%>

try

{

DataConnection cs = new DataConnection();

int res = cs.getResultSet("select * from mnpgui",0);

if(res==1)

{

response.sendRedirect("HomePage.jsp");

}

else

{

response.sendRedirect("loginFailed.jsp");

}

}

catch(Exception e)

{

e.printStackTrace();

}

%>

Java文件

包com.dcddesigns.utilities;

public class DataConnection {

private java.sql.Statement stmt;

private java.sql.Connection conn;

private java.sql.ResultSet rs;

public DataConnection() {

try {

Class.forName("org.postgresql.Driver").newInstance();

conn = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost/db_name?user=username&password=password");

stmt = conn.createStatement();

}

catch (java.sql.SQLException sqle) {

sqle.printStackTrace();

}

catch (Exception e) {

e.printStackTrace();

}

}

public void killOpenObjects() {

try {

if (stmt != null) {

stmt.close();

}

if (conn != null) {

conn.close();

}

}

catch (java.sql.SQLException e) {

System.out.println("Exception in killOpenObjects");

e.printStackTrace();

}

}

public java.sql.ResultSet getResultSet(String query, boolean killTrigger) {

try {

rs = stmt.executeQuery(query);

}

catch (java.sql.SQLException e) {

System.out.println(query);

System.out.println("Exception in DataConnection get ResultSet");

e.printStackTrace();

}

finally {

if (killTrigger) {

killOpenObjects();

}

}

return rs;

}

public int updateTable(String query, boolean killTrigger) {

int rows = 0;

try {

rows = stmt.executeUpdate(query);

}

catch (java.sql.SQLException e) {

if (e.getMessage().indexOf("Invalid argument value: Duplicate entry") == -1) {

System.out.println(e.getMessage());

System.out.println(query);

}

}

finally {

if (killTrigger) {

killOpenObjects();

}

}

return rows;

}

};

2016-08-16

sreejith