一、准备ojdbc驱动包
链接:https://pan.baidu.com/s/1JEni3roZ-0Jg7qRL2Zp3XQ
提取码:320i
二、加载驱动并创建连接
package com.qianfeng.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Test {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver"); //加载oracle驱动
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//连接数据库
Connection connection = DriverManager.getConnection(url, "system", "123456");
System.out.println(connection);
}
}
三、测试数据库是否连接成功
四、操作数据库
package com.qianfeng.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) throws ClassNotFoundException,SQLException {
Class.forName("oracle.jdbc.driver.OracleDriver"); // 加载oracle驱动
// 连接数据库
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection connection = DriverManager.getConnection(url, "system","123456");
Statement statement = connection.createStatement(); //创建数据库执行对象
String sql="insert into student values(4,'杨超越','女',23,sysdate)";
//增删改
int res = statement.executeUpdate(sql);
System.out.println(res);
//查询
ResultSet resultSet = statement.executeQuery("select * from student");
while (resultSet.next()) {
System.out.println(resultSet.getInt("stuid")+"-"+resultSet.getString("stuname"));
}
}
}
五、对比Oracle数据库中的表数据与上面查询出来的结果是否一致