JDBC quick start

Catalog

JDBC The concept of

JDBC(Java DataBase connectivity Java Database connection )

JDBC The essence of

JDBC Quick start

JDBC Quick start program

Import jar package

The following steps are carried out at the code

JDBC The concept of

JDBC(Java DataBase connectivity Java Database connection )

JDBC The essence of

JDBC Quick start

JDBC Quick start program

Import jar package

The following steps are carried out at the code

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class jdbcdemo01 {
        public static void main(String []args) throws Exception{
            //2. Registration drive 
            Class.forName("com.mysql.jdbc.Driver");
            //3. Get the connection 
            Connection con= DriverManager.getConnection("jdbc:mysql://localhost:3306/dp1","root","109923");
            //4. Get execution object 
            Statement stat =con.createStatement();
            //5. perform sql sentence , And receive the results 
            String sql = "SELECT * FROM city";
            ResultSet rs = stat.executeQuery(sql);
            //6. Processing results 
            while(rs.next()){
                System.out.println(rs.getInt("id")+"\t"+rs.getString("name"));
            }
            //7. Release resources 
            con.close();
            stat.close();
            rs.close();
        }
}