answersLogoWhite

0

JDBC mean Java Database Connectivity. In java, using JDBC drivers, we can connect to database.

Steps to connect to JDBC.

1) Load the driver, using Class.forName(DriverName);

2) Get the connection object, Connection con = Driver.getConnection(loaded driver name);

3) Create a SQL statement, Statement s = con.createStatement();

4) Create Resultset object using the statement created above, ResultSet rs = s.executeQuery("sql statement");

Iterate the result set to get all the values from the database.

Finally don't miss this

5) s.close();

6) con.close() ;

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What are the types of server controls that participate in declarative data binding model?

Java sql programming


Is learning SQL easy for a Java student?

SQL is quite unrelated to Java. It isn't exactly a programming language in the traditional sense; but rather a series of commands to get information from (and to) a database. The basics are actually quite simple; certainly simpler than learning Java.


Which language will be the best language to learn for computer programming in 2016?

C, C++, C#, Java, Python, HTML/CSS and SQL.


Is Oracle a programming language?

In C language Oracle is developed and after that enhancement is done in Java for 10g and 11g


Who are users of SQL programming?

The users of SQL Programming include database administrators(DBAs) and application developers. They use SQL programming to do daily tasks efficiently and correctly.


Can we use SQL for java language?

No. SQL stands for Structured Query Language and that in itself is a language and it is totally different from Java. However, you can use SQL queries inside Java code with the help of JDBC (Java DataBase Connectivity). But the Java compiler cannot understand/compile standalone SQL syntax unless it is used as part of JDBC.


What are the uses of java database connectivity?

Java Database Connectivity, a Java API that enables Java programs to execute SQL statements. This allows Java programs to interact with any SQL-compliant database.


Programming language used for hacking?

Top 10 programming language used for hacking: Python C++ C Programming SQL Javascript PHP JAVA Ruby Perl Bash


When people talk about java programming what java program do they mean?

"Java programming" refers to the act of creating programs - any programs - in the Java programming language. This is much like "C programming" refers to writing programs in the C programming language.


Database programming language?

Depends upon the database you are talking about MS SQL Server uses SQL and T-SQL programming languages. Oracle is also a SQl based language usings its own 'flavor' PSQL


What programming language are java applets written in?

Java applets are written in the Java programming language. Java is considered to be one of the oldest and most commonly used programming languages in the world.


What has the author Daniel I Joshi written?

Daniel I. Joshi has written: 'The comprehensive guide to Visual J++' -- subject(s): Java (Computer program language), Microsoft Visual J++ 'The comprehensive guide to the JDBC SQL API' -- subject(s): Internet programming, Java (Computer program language), SQL (Computer program language), Database management


What is the first name before of the Java Programming?

The first name of the Java Programming was Oak. It then went by the game Green and finally Java from Java coffee.


What is difference between oracle and sql?

The Oracle RDBMS system primarily provides programming access via 2 languages:SQL - the standard language for searching and updating a relational database. Oracle provides various extensions/customizations to the standard ANSI SQL language. I wouldn't call SQL a programming language exactly, since it's only good for defining database objects (e.g. tables), then querying and updating them.PL/SQL - Oracle's Procedural Language for SQL (hence the name PL/SQL). This is a fairly complete procedural programming language (including limited object-oriented features), primarily used to manipulate the data you've accessed via SQL.Additionally, Oracle support SQL access via Java (notJavascript).


Why is a precompiler necessary to translate Embedded SQL and SQLJ Why is a precompiler not necessary for JDBC?

A precompiler is necessary for Embedded SQL and SQLJ because these languages embed SQL statements directly within a host programming language, requiring translation into standard SQL and additional code generation for database interactions before compilation. This process ensures that SQL statements are correctly formatted and integrated with the host language's syntax. In contrast, JDBC (Java Database Connectivity) uses standard Java code to interact with databases, allowing developers to write SQL statements as strings without needing any prior translation, making a precompiler unnecessary.


How do you convert java data to SQL data?

kill urself


How can connect sql server 2005 with java in java?

Use the JDBC functionality to open a connection to SQL Server. You can read up on how here: http://java.sun.com/javase/technologies/database/


What is the programming language does enovia use?

It's JAVA based on the front end with Html and Javascript for the web interface. The backend can be either Oracle or SQL Server 2005/2008 -- with SQL Server 2008 being be better performance over Oracle on the same hardware and lower cost.


What is java card?

Java Card is a Java platform for programming smart cards.


Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database