Java & MySQL – Drop Database Example This chapter provides an example on how to drop an existing Database using JDBC application. Before executing the following example, make sure you have the following in place − To execute the following example you need to replace the username and password with your actual user name and […]
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. […]