Não consigo carregar a tabela da base de dados conforme seleciono um nome no botão search.
Não achei o problema, poderiam me ajudar
index.jsp
```
<%@ page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>search</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0-beta.2/css/bootstrap.min.css">
</head>
<body>
<div class="container">
<form class="form-inline" method="post" action="search.jsp">
<input type="text" name="employee_n" class="form-control"
placeholder="Search name..">
<button type="submit" name="save" class="btn btn-primary">Search</button>
</form>
</div>
</body>
</html>
```
search.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%
String driver = "com.mysql.cj.jdbc.Driver";
String connectionUrl = "jdbc:mysql://localhost:3306/";
String database = "userdetails";
String userid = "root";
String password = "123456";
String employee_n=request.getParameter("employee_n");
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>SEARCH</title>
</head>
<body>
<h1>Search Data</h1>
<table border="1">
<tr>
<td>Id</td>
<td>Name</td>
<td>Email </td>
<td>Dpt</td>
</tr>
<%
try{
connection = DriverManager.getConnection(connectionUrl+database, userid, password);
statement=connection.createStatement();
String sql ="select * from employee where emp_name like '%"+employee_n+"%' " ;
System.out.println(employee_n);
//System.out.println(sql);
while(resultSet.next()){
%>
<tr>
<td><%=resultSet.getString("id") %></td>
<td><%=resultSet.getString("emp_name") %></td>
<td><%=resultSet.getString("emp_dept") %></td>
<td><%=resultSet.getString("email") %></td>
</tr>
<%
}
connection.close();
} catch (Exception e) {
e.printStackTrace();
}
%>
</table>
</body>
</html>
```
That's my data in MySQL
CREATE DATABASE userdetails;
```
use userdetails;
create table employee(
id int auto_increment,
emp_name varchar(100),
emp_dept varchar(100),
email varchar(100),
primary key(id)
);
insert into employee (emp_name, emp_dept, email)
values
("baner","engenharia", "[email removido]");
```
Tags