JDBC Projects

JDBC Project 1

Step of the connectivity with MySQL
Previous Home Next

The steps of developing the Java programs that access the MySQL database.

Step1: load the database driver and register it with the driver manager.


Step 2: In the second step we are create the connection to the database server.

Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/student", "system","sam");

Step 3: In this step you can create the statement object by giving your Oracle.

PreparedStatement stm=con.prepareStatement(“select * from sam”);

Step 4: Now you can execute the SQL query and retrieve the data in the form of ResultSet. In case of delete or update you can execute the SQL and get the information about the SQL execution like no of records deleted or modified etc.

ResultSet rset= stm.executeQuery();

Step 5: Finally you should disconnect your database connection.



Previous Home Next