JDBC ：Java数据库连接

数据库连接步骤：

• 步骤一：加载jdbc程序
• 步骤二：建立与数据库的连接，并得到连接对象Connection
• 步骤三：在程序中编写sql
• 步骤四：执行sql
• 步骤五：处理结果集
• 步骤六：断开与数据库的连接

代码示例

package com.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import oracle.jdbc.driver.OracleDriver;

public class DataBase {
    private final static String driver = "oracle.jdbc.driver.OracleDriver";
    private final static String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
    private final static String username = "scott";
    private final static String password = "lzqlzq";
    protected Connection con = null;

    public void getcon() {
        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        try {
            con = DriverManager.getConnection(url,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        System.out.println(con);
    }

    public static void main(String[] args) {
        DataBase db = new DataBase();
        db.getcon();
    }

}