Day6

今日在进行查找部分的练习。

MainServlet类

@WebServlet("/MainServlet")
public class MainServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        String v = req.getParameter("v");

        FileService fs = new FIleServiceImpl();
        User u =fs.getFileByNameOrId(v);
        if (u != null){
            String id = req.getParameter("id");
            FileService fs2 = new FIleServiceImpl();
            User adminel = fs2.getAdmine(id);
            req.getRequestDispatcher("mainPage.jsp").forward(req,resp);
        }

    }
}

FileDaoImpl类

public class FileDaoImpl implements FIleDao{
    @Override
    public ArrayList<User> getAllStudent() {
        ArrayList<User> arr = new ArrayList<>();
        Connection connection = ConnectionFactory.getConnection();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        String sql = "SELECT * FROM u_user WHERE u_role=1 AND u_isdelte=0";

        try {
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()){
                User u = new User();
                u.setU_id(resultSet.getInt("u_id"));
                u.setU_name(resultSet.getString("u_name"));
                u.setU_pwd(resultSet.getString("u_pwd"));
                u.setU_phone(resultSet.getString("u_phone"));
                u.setRole(resultSet.getInt("u_role"));
                u.setIsdelete(resultSet.getInt("u_isdelte"));
                arr.add(u);
            }
        }catch (SQLException e){
            e.printStackTrace();
        }

        return arr;
    }

    @Override
    public User getFileByNameOrId(String v) {

        Connection connection = ConnectionFactory.getConnection();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        String sql = "SELECT * FROM u_user WHERE u_name='"+v+"'";

        try {
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()){
                User user2 = new User();
                user2.setU_id(resultSet.getInt("u_id"));
                user2.setU_name(resultSet.getString("u_name"));
                user2.setU_pwd(resultSet.getString("u_pwd"));
                user2.setU_phone(resultSet.getString("u_phone"));
                user2.setRole(resultSet.getInt("u_role"));
                user2.setIsdelete(resultSet.getInt("u_isdelte"));
                return  user2;
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    @Override
    public User getAdmine(String id) {
        Connection connection = ConnectionFactory.getConnection();
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;

        String sql = "SELECT * FROM u_user WHERE u_name='"+id+"'";

        try {
            preparedStatement = connection.prepareStatement(sql);
            resultSet = preparedStatement.executeQuery();
            while (resultSet.next()){
                User user3 = new User();
                user3.setU_id(resultSet.getInt("u_id"));
                user3.setU_name(resultSet.getString("u_name"));
                return  user3;
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }
}

FileServiceImpl类

public class FIleServiceImpl implements FileService {
    FIleDao fs = new FileDaoImpl();
    @Override
    public ArrayList<User> getAllStudent() {

        FIleDao fs = new FileDaoImpl();
        return fs.getAllStudent();
    }

    @Override
    public User getFileByNameOrId(String v) {
        FIleDao fd = new FileDaoImpl();
        return fd.getFileByNameOrId(v);
    }

    @Override
    public User getAdmine(String id) {
        return fs.getAdmine(id);
    }
}