java servlet-在同一文件夹中找不到symbol-对象

7rfyedvj  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(260)

我写了以下两个类:
设备.java

class Equipment{

  private int id;
    private String name;
    private String local;

  public void setId(int id){
    this.id = id;
  }

  public void setName(String n){
    this.name = n;
  }
  public void setLocal(String l){
    this.local = l;
  }

  public int getId(){
    return this.id;
  }

  public String getName(){
    return this.name;
  }
  public String getLocal(){
    return this.local;
  }

}

jdbccommands.java文件

import java.util.*;
import java.sql.*;

class JDBCCommands{
  private static Connection con = new ConnectionFactory().getConnection();

  public static void Create(String name, String local){
    String sql = "insert into equipment (name,local) values (?,?)";
    try{
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, name);
      ps.setString(2, local);
      ps.execute();
      ps.close();
    }catch(SQLException erro_sql){
      throw new RuntimeException(erro_sql);
    }
  }

  public static List<Equipment> Show(){
    List <Equipment> Components = new ArrayList <Equipment> ();
    String sql = "select * from equipment";
    try{
      PreparedStatement ps = con.prepareStatement(sql);
      ResultSet rs = ps.executeQuery();
      while(rs.next()) {
        Equipment e = new Equipment();
        e.setId(Integer.parseInt(rs.getString("equip_id"))  );
        e.setName(rs.getString("nome"));
        e.setLocal(rs.getString("local"));
        Components.add(e);
      }
      rs.close();
      ps.close();
      return Components;
    }catch(SQLException erro_sql){
      throw new RuntimeException(erro_sql);
    }
  }

  public static void Update(int id, String name, String local){
    String sql = "update equipment set name = ?, local = ? where equip_id = ?";
    try{
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, name);
      ps.setString(2, local);
      ps.setInt(3, id);
      ps.execute();
      ps.close();
    }catch(SQLException erro_sql){
      throw new RuntimeException(erro_sql);
    }
  }

  public static void Delete(int id){
    String sql = "delete from equipment where equip_id = ?";
    try{
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setInt(1, id);
      ps.execute();
      ps.close();
    }catch(SQLException erro_sql){
      throw new RuntimeException(erro_sql);
    }
  }

  public static List<Equipment> Search(String name, String local){
    List <Equipment> Components = new ArrayList <Equipment> ();
    String sql = "select * from equipment where name like ? and local like ?";
    try{
      PreparedStatement ps = con.prepareStatement(sql);
      ps.setString(1, "%" + name + "%");
      ps.setString(2, "%" + local + "%");
      ResultSet rs = ps.executeQuery();
      while(rs.next()) {
        Equipment e = new Equipment();
        e.setId(Integer.parseInt(rs.getString("equip_id"))  );
        e.setName(rs.getString("nome"));
        e.setLocal(rs.getString("local"));
        Components.add(e);
      }
      rs.close();
      ps.close();
      return Components;
    }catch(SQLException erro_sql){
      throw new RuntimeException(erro_sql);
    }
  }
}

我用这门课做了测试,效果很好

import java.util.*;
import java.sql.*;

class MainTest{
  public static void main(String[] args) throws SQLException {
    JDBCCommands jdbc = new JDBCCommands();
    //jdbc.Create("Teste novo", "Novo Teste");
    for(Equipment c : jdbc.Show()){
      System.out.print(c.getId() + " ");
      System.out.print(c.getName() + " ");
      System.out.print(c.getLocal() + "\n");

    }
    System.out.println("-------------------------------------");
    for(Equipment c : jdbc.Search("est n" , "est")){
      System.out.print(c.getId() + " ");
      System.out.print(c.getName() + " ");
      System.out.print(c.getLocal() + "\n");

    }
  }
}

问题是当我尝试这门课时:

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;

import java.sql.*;

class ListEquipment extends HttpServlet {
  protected void service(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {

        PrintWriter out = response.getWriter();
        JDBCCommands jdbc = new JDBCCommands();

        System.out.println("<table style=\"width:100%\">");
        for(Equipamento c : jdbc.Show()){
          System.out.println("<tr>");
          System.out.print("<th>" + c.getId() + "</th>");
          System.out.print("<th>" + c.getName() + "</th>");
          System.out.print("<th>" + c.getLocal() + "</th>");
          System.out.println("</tr>");
        }
        System.out.println("</table>");
    }
}

显示此错误:
列表设备。java:13:错误:找不到符号

JDBCCommands jdbc = new JDBCCommands();
    ^

符号:类jdbccommands
位置:class ListedEquipment
列表设备。java:13:错误:找不到符号

JDBCCommands jdbc = new JDBCCommands();
                            ^

符号:类jdbccommands
位置:class ListedEquipment
列表设备。java:16:错误:找不到符号

for(Equipment c : jdbc.Show()){
        ^

符号:等级设备
位置:class ListedEquipment
3个错误
所有文件都在同一个文件夹中,名称正确。我怎样才能解决这个问题?

avkwfej4

avkwfej41#

我只需要把与mariadb连接的.jar文件放在lib文件夹中,现在一切都好了。

相关问题