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
Statement Interface
Last Updated : 26 May, 2026
title: Statement Interface in JDBC
JDBC32 words3 headingsExamples included
title: Statement Interface in JDBC description: JDBC Statement interface ka use
Simple SQL execute karne ke liye — without parameters.
Methods
java exampleWoHoTech
Connection conn = DBConfig.getConnection();
Statement stmt = conn.createStatement();
// executeQuery — SELECT statements
ResultSet rs = stmt.executeQuery("SELECT * FROM students");
// executeUpdate — INSERT, UPDATE, DELETE, DDL
int rowsAffected = stmt.executeUpdate("UPDATE students SET marks = 90 WHERE id = 1");
int created = stmt.executeUpdate("CREATE TABLE temp (id INT)");
// execute — any SQL, returns boolean (true = ResultSet)
boolean hasResultSet = stmt.execute("SELECT * FROM students");
if (hasResultSet) ResultSet rs2 = stmt.getResultSet();
// executeBatch
stmt.addBatch("INSERT INTO students VALUES (null, 'Ram', 20, 85)");
stmt.addBatch("INSERT INTO students VALUES (null, 'Shyam', 22, 90)");
int[] results = stmt.executeBatch();ResultSet Navigate karna
java exampleWoHoTech
ResultSet rs = stmt.executeQuery("SELECT * FROM students");
// Forward only (default)
while (rs.next()) {
int id = rs.getInt(1); // by column index
String name = rs.getString("name"); // by column name
int age = rs.getInt("age");
double marks = rs.getDouble("marks");
}
// Scrollable ResultSet
Statement scrollStmt = conn.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY
);
ResultSet rs2 = scrollStmt.executeQuery("SELECT * FROM students");
rs2.last(); // Last row
rs2.first(); // First row
rs2.absolute(3); // Row 3
rs2.relative(2); // Move 2 forwardStatement ka Problem — SQL Injection
java exampleWoHoTech
// UNSAFE!
String userId = "1 OR 1=1"; // Malicious input
stmt.executeQuery("SELECT * FROM users WHERE id = " + userId);
// Returns ALL users!
// ALWAYS use PreparedStatement for user inputExam Focus
Revise definitions, diagrams, examples, and short-answer points for Statement Interface.
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
JDBCCallableStatementtitle: CallableStatement in JDBCJDBCPreparedStatementtitle: PreparedStatement in JDBCJDBCBatch Processingtitle: Batch Processing in JDBCJDBCJDBC Architecturetitle: JDBC ArchitectureJDBCJDBC — Java Database Connectivitytitle: JDBC IntroductionJDBCJDBC Practice Projectstitle: JDBC Mini Projects