MILAN_Talk

Hi Readers, Now I have Completed my Project with java and oracle database. Thank you for be with till my whole project completion. Thank you very much

Hi Readers, Now i now about JDBC Lets Connect my Java project with Oracle database, you can also connect with different database systems like MySQL. But here I am using Oracle, you can choose yours process is similar To connect java application with the oracle database, we need to follow 5 following steps. In this example, we are using Oracle 10g as the database. So we need to know following information for the oracle database: Driver class: The driver class for the oracle database is oracle.jdbc.driver.OracleDriver. Connection URL: The connection URL for the oracle10G database is jdbc:oracle:thin:@localhost:1521:xe where jdbc is the API, oracle is the database, thin is the driver, localhost is the server name on which oracle is running, we may also use IP address, 1521 is the port number and XE is the Oracle service name. You may get all these information from the tnsnames.ora file. Username: The default username for the oracle database is system. Password: It is the

Hi Readers, I have created my project a bit. I created my whole GUI now I have To Connnect This GUI with database to store information which is given by user. This will be done by JDBC JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database. There are four types of JDBC drivers: JDBC-ODBC Bridge Driver, Native Driver, Network Protocol Driver, and Thin Driver We have discussed the above four drivers in the next chapter. We can use JDBC API to access tabular data stored in any relational database. By the help of JDBC API, we can save, update, delete and fetch data from the database. It is like Open Database Connectivity (ODBC) provided by Microsoft. Why Should We Use JDBC Before JDBC, ODBC API was the database API to connect and execute the query with the database. But, ODBC API uses ODBC driver which is writt