Add mysql user
Grant SELECT, INSERT ON JSPDB. * To jspuser Identified by '123456';
Code
<%
Class.Forname ("Org.gjt.mm.mysql.driver"). NewInstance ();
String url = "JDBC: mysql: // localhost: 3306 / jspdb? User = jspuser & password = '123456'
Java.sql.connection connection = java.sql.driverManager.getConnection (URL);
Java.sql.Statement Statement = connection.createStatement ();
String SQL = "SELECT * from company";
Java.sql.resultSet RS = Statement.executeQuery (SQL);
While (rs.next ()) {%>
Your first field content is: <% = rs.getstring (1)%>
Your second field content is: <% = rs.getstring (2)%>
<%}%>
<% OUT.PRINT ("Database Operation");%>
<%
Rs.close ();
STATEMENT.CLOSE ();
Connection.Close ();
%>
The test environment is REDHAT 8.0 RESIN
