java - 语句无法解析为 JSP 文件中的类型

Question

运行Pregister.jsp文件时显示如下

An error occurred at line: 31 in the jsp file: /pregister.jsp
Statement cannot be resolved to a type
PreparedStatement cannot be resolved to a type

我的代码

try {
     DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
     Connection con = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:xe","system","system");      
     Statement st=con.createStatement();
     String query="select email from patient where email=? ";
     PreparedStatement ps=con.prepareStatement(query);
     ps.setString(1, pemail);

任何人都可以告诉我为什么会出现此错误并建议我如何解决此错误。这个文件放在tomcat的webapps下。请提出这个解决方案

Answer 1

您缺少 java.sql 导入:

import java.sql.PreparedStatement;
import java.sql.Statement;