JSP connection MySQL Database

js|mysql| Data | Database 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)%> <br>
Your second field content is: <%=rs.getstring (2)%> <br>
<%}%>
<%out.print ("Database operation succeeded");%>
<%
Rs.close ();
Statement.close ();
Connection.close ();
%>
The test environment is resin under Redhat 8.0.