JSP with JDBC connection to a MySQL database

Before we start with this example for connecting and reading data from a MySQL database, we assume that you already have a JSP/Servlet container like Apache Tomcat, Jetty etc. and a MySQL database installed on your computer. An easy to understand article about installing Apache Tomcat can be found in previous tutorials here on Librescript. […]

Connecting to a MySQL Database with the PHP library PDO

PDO stands for PHP Data Objets and support Prepared Statements

you can also use the bindParam method, like:


Assuming you have these two MySQL tables

You can ask MySQL to show you all customers who has a valid credit card

MySQL output