JDBC之一：基本概念解释

一、JDBC编码流程

JDBC：Java Database Connectivity

1、Load The Driver

//加载MySql驱动
Class.forName("com.mysql.jdbc.Driver")
//加载Oracle驱动
Class.forName("oracle.jdbc.driver.OracleDriver")

2、 Connection To The DataBase

Connection conn =DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/study", "root", "root");

3、Execute the SQL

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM user");

4、Retrieve the result data

while(rs.next()){
            System.out.println(rs.getString("name")+"电话："+rs.getString("telphone"));
        }

5、Close Connection

conn.close();

JDBC官方推荐JDBC的加载驱动、创建连接放在静态块中进行初始化

二、双手奉上一个源代码项目