I have a JSP File and SQLITE File database . I need someone to fix and run this code in the eclipse and send me the screen shot output of all book records displayed for each category, to MS Word document and send to email manalochristian574 This is the file so you can easily to fix https://drive.google.com/drive/folders/13IIog9rotfsMXTdHSBIZWaMoi1roqQRT?usp=share_link

This is the instruction of my work.

Create a JSP app that will display books coming from a book database ( A DB that was created, book.db ).

All books will be displayed dynamically based on the book category selected by the user from web html form. Use html table to display the books properly.

JSP CODE:

<%@ page import="java.sql.*" %>

<%@ page import="java.sql.DriverManager" %>

<%@ page import="org.sqlite.JDBC" %>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding ="ISO-8859-1"%>

<%

// Initialize variables String bookcategory = request.getParameter("bookcategory");

// Load the SQLite JDBC driver Class.forName("org.sqlite.JDBC");

// Establish a connection to the database Connection conn = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\USER\\Downloads\\aljon\\DATABASE\ iverabook.db");

// Create a statement object Statement stmt = conn.createStatement();

// Select the books with the specified category String sql = "SELECT * FROM riverabookinfo WHERE bookcategory = '" + bookcategory + "'"; ResultSet rs = stmt.executeQuery(sql); %>

Book Category:

Fiction

Non-fiction

Mystery

Self-help

<% while (rs.next()) { int bookId = rs.getInt("bookid"); String bookTitle = rs.getString("booktitle"); String bookDescription = rs.getString("bookdescription"); String bookAuthor = rs.getString("bookauthor"); Date bookDatePublish = rs.getDate("bookdatepublish"); int bookPageTotal = rs.getInt("bookpagetotal"); %> <% } %>

Book ID	Book Category	Book Title	Book Description	Book Author	Date Published	Total Pages
<%= bookId %>	<%= bookcategory %>	<%= bookTitle %>	<%= bookDescription %>	<%= bookAuthor %>	<%= bookDatePublish %>	<%= bookPageTotal %>