Java & MySQL – ResultSet The SQL statements that read data from a database query, return the data in a result set. The SELECT statement is the standard way to select rows from a database and view them in a result set. The java.sql.ResultSet interface represents the result set of a database query. A ResultSet […]
Category Archives: java Mysql
Java & MySQL – CallableStatement The CallableStatement interface is used to execute a call to a database stored procedure. Suppose, you need to execute the following stored procedure in TUTORIALSPOINT database − DELIMITER $$ DROP PROCEDURE IF EXISTS `TUTORIALSPOINT`.`getEmpName` $$ CREATE PROCEDURE `TUTORIALSPOINT`.`getEmpName` (IN EMP_ID INT, OUT EMP_FIRST VARCHAR(255)) BEGIN SELECT first INTO EMP_FIRST FROM […]
Java & MySQL – Environment Setup To start developing with JDBC, you should setup your JDBC environment by following the steps shown below. We assume that you are working on a Windows platform. Install Java Java SE is available for download for free. To download , please download a version compatible with your operating system. […]