Step of the connectivity with MySQL
The steps of
developing the Java programs that access the MySQL database.
Step1: load
the database driver and register it with the driver manager.
Class.forName("com.mysql.jdbc.Driver");
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.
Con.close();
Tolal:0 Click:
Show All Comments
