All Jdbc In This By Programing Kid

                    All For 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:

Source Code -

import java.sql.*;

public class alljdbc {

    public static void main(String[] args) {

        try {

            // Creating Connection

            Class.forName("com.mysql.jdbc.Driver");

   String url ="jdbc:mysql://127.0.0.1:3306/test";

   String user ="root";  

   String pass = "2010";

            Connection con = DriverManager.getConnection(url, user, pass);

            // Checking Connection

   

   

            if (con.isClosed()) {

                System.out.println("close");

               

            }

            else{

                System.out.println("open");

            }

            // CREATE  Query

            String q = "create table stu1 ( tid int(20) primary key auto_increment, tname varchar(200) not null, tCity varchar(200))";

           

            // Fire Statement

            Statement stat = con.createStatement();

            stat.execute(q);

           

            System.out.println("Table Created Success");

           con.close();

           

        } catch (Exception e) {

            e.printStackTrace();

        }

   

    }

}