Java Topics
HubJava Collections FrameworkCollections Practice ProgramsComparable vs ComparatorGenericsIteratorArrayListLinkedListStackVectorHashMapHashtableLinkedHashMapTreeMapArrayDequeDeque Double-Ended QueuePriorityQueueHashSetLinkedHashSetTreeSetAdapter PatternBuilder PatternFactory PatternMVC PatternObserver PatternSingleton PatternDynamic ProgrammingGraphHashingHeapLinked List DSAQueue DSARecursionSearching AlgorithmsSorting AlgorithmsStack DSATime ComplexityTreesException Handling Best PracticesCustom ExceptionException Hierarchyfinally BlockException Handlingthrow aur throwstry-catchBuffered StreamsByte StreamsCharacter StreamsDeserializationFile ClassJava NIO New I/OSerializationArrays in JavaArray OperationsArray Practice ProgramsArray Interview QuestionsJagged ArrayMulti-Dimensional ArraysOne Dimensional Arraybreak aur continuedo-while Loopfor Loopif-else StatementsNested Loopsswitch-case Statementwhile LoopJava Compilation ProcessJava ki FeaturesPehla Java ProgramHistory of JavaJava EditionsJava Program StructureJDK, JRE aur JVMJava Kya Hai?Immutable StringsString Class in JavaString Interview QuestionsString MethodsString Practice ProgramsStringBufferStringBuilderComments in JavaData Types in JavaIdentifiers in JavaInput & Output in JavaJava KeywordsOperators in JavaType Casting in JavaVariables in JavaJava Coding Interview QuestionsCollections Interview QuestionsCore Java Interview QuestionsJDBC Interview QuestionsMultithreading Interview QuestionsOOPs Interview QuestionsSpring Framework Interview QuestionsJava 8 Date/Time APIDefault aur Static Methods in InterfaceFunctional InterfaceLambda ExpressionMethod ReferenceOptional ClassStream APIBatch ProcessingCallableStatementJDBC ArchitectureJDBC — Java Database ConnectivityJDBC Practice ProjectsMySQL ConnectionPreparedStatementResultSetStatement InterfaceTransaction ManagementCreating ThreadsDaemon ThreadExecutor FrameworkInter-Thread CommunicationMultithreading Practice ProgramsRunnable InterfaceSynchronizationThread ClassMultithreading IntroductionThread Life CycleThread PriorityJava Cheat SheetImportant Formulas & Key ConceptsImportant Java ProgramsJava Quick RevisionAbstract ClassAbstractionAnonymous ClassClass and ObjectConstructorEncapsulationInheritanceInner ClassInterfaceMethod OverloadingMethod OverridingObject ClassObject CloningObject-Oriented Programming OOPPolymorphismstatic Keywordsuper Keywordthis KeywordWrapper ClassesArray Practice ProgramsBasic Java Practice ProgramsCollection Practice ProgramsJDBC Practice ProgramsMultithreading Practice ProgramsOOPs Practice ProgramsPlacement Coding QuestionsString Practice ProgramsBanking SystemChat ApplicationE-Commerce Backend — Spring Boot REST APIEmployee Management SystemLibrary Management SystemSpring Boot Fullstack ProjectStudent Management SystemCookies in ServletExpression Language ELGenericServletHttpServletJavaServer Pages JSPJSP TagsMVC ArchitectureHttpServletRequest & HttpServletResponseServlet IntroductionServlet Life CycleSession TrackingDependency InjectionSpring BeansSpring CoreSpring FrameworkAPI GatewaySpring Cloud Config ServerDocker DeploymentEureka Server — Service DiscoverySpring Boot CRUD ApplicationException Handling in Spring BootJWT AuthenticationREST API in Spring BootSpring SecuritySpring BootSpring Data JPAValidation in Spring Boot
CallableStatement
Last Updated : 26 May, 2026
title: CallableStatement in JDBC
JDBC32 words4 headingsExamples included
title: CallableStatement in JDBC description: Stored procedures call karna
Database stored procedures aur functions call karna.
MySQL Stored Procedure
sql exampleWoHoTech
DELIMITER //
CREATE PROCEDURE GetStudentById(IN student_id INT)
BEGIN
SELECT * FROM students WHERE id = student_id;
END //
DELIMITER ;
-- Procedure with OUT parameter
CREATE PROCEDURE GetStudentCount(OUT total INT)
BEGIN
SELECT COUNT(*) INTO total FROM students;
END //CallableStatement — IN parameter
java exampleWoHoTech
String sql = "{call GetStudentById(?)}";
try (Connection conn = DBConfig.getConnection();
CallableStatement cs = conn.prepareCall(sql)) {
cs.setInt(1, 5); // IN parameter
ResultSet rs = cs.executeQuery();
while (rs.next())
System.out.println(rs.getString("name") + " - " + rs.getDouble("marks"));
}CallableStatement — OUT parameter
java exampleWoHoTech
String sql = "{call GetStudentCount(?)}";
try (Connection conn = DBConfig.getConnection();
CallableStatement cs = conn.prepareCall(sql)) {
cs.registerOutParameter(1, Types.INTEGER); // OUT parameter register
cs.execute();
int count = cs.getInt(1); // OUT parameter retrieve
System.out.println("Total students: " + count);
}IN + OUT parameter
java exampleWoHoTech
// {call procedureName(?, ?)} — first IN, second OUT
cs.setString(1, "Ram");
cs.registerOutParameter(2, Types.DOUBLE);
cs.execute();
double marks = cs.getDouble(2);Exam Focus
Revise definitions, diagrams, examples, and short-answer points for CallableStatement.
Interview Use
Prepare one clear explanation, one practical example, and one common mistake for this Java topic.
Search Terms
java, java programming, core java, java master course, java notes, master, course, jdbc
Related Java Topics
Continue learning this concept
JDBCStatement Interfacetitle: Statement Interface in JDBCJDBCBatch Processingtitle: Batch Processing in JDBCJDBCJDBC Architecturetitle: JDBC ArchitectureJDBCJDBC — Java Database Connectivitytitle: JDBC IntroductionJDBCJDBC Practice Projectstitle: JDBC Mini ProjectsJDBCMySQL Connectiontitle: MySQL Connection in JDBC