数据库连接步骤:
- 步骤一:加载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();
}
}